|
Open two copies of Excel, with different sheets (I do this on separate monitors).
Give Excel 1 the focus, and then position the mouse over Excel 2 - do not click.
Twiddle the mouse wheel to scroll the sheet on Excel 2.
Notice that the sheet on Excel 1 scrolls instead ... 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Excel is really strange.
I noticed just the other day that if I have an Excel spreadsheet open in the background with cells selected with CTRL+C, I can't copy and paste from any other program. The text is simply not copied to the clipboard... 
Anything that is unrelated to elephants is irrelephant
Anonymous
-
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-
Never argue with a fool. Onlookers may not be able to tell the difference.
Mark Twain
modified 1-Sep-20 8:39am.
|
|
|
|
|
It is indeed strange, but ... it's also a very, very good spreadsheet, and a whole load better than any other. Nothing else even comes close. Unlike Word, which could be beaten by a pencil and paper most of the time. 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Quote: but ... it's also a very, very good spreadsheet, and a whole load better than any other. Nothing else even comes close.
Quote: Give Excel 1 the focus, and then position the mouse over Excel 2 - do not click.
Nothing else comes close, even itself, apparently. 
|
|
|
|
|
I detest word. I will use Notepad++ in word wrap mode before I use Word.
"They have a consciousness, they have a life, they have a soul! Damn you! Let the rabbits wear glasses! Save our brothers! Can I get an amen?"
|
|
|
|
|
Indeed so - Excel is the real flagship in Office and always has been.
I do quite like Quattro Pro though, which is a much extended Lotus 123 and more compatible with that than Excel.
|
|
|
|
|
Think about it! How much effort they put in it? After all - naturally Windows sends scroll events by the mouse position and not by the focused application... Trapping it upon focus request additional programming of very high quality
"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012
|
|
|
|
|
This is how it's always been. Browsers now do it and I imagine some other programs do it too. Request it as a feature from Microsoft.
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
Try it with Chrome: two windows, one with CP on it. The other with Dilbert[^].
Click on CP to give it the focus.
Move the mouse over Dilbert, but do not click.
Move the mouse wheel.
Which one scrolls, CP or Dilbert?
Dilbert does, as you would expect.
Move the mouse over CP, and again, don't click.
Move the mouse wheel.
Which one scrolls, CP or Dilbert?
CP does, as you would expect.
Excel doesn't do that: it scrolls the focussed spreadsheet, not the one under the mouse pointer. Which is damn annoying!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Which is why I said, Quote: Browsers now do it
It referring to scrolling without focus.
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
Yes, but only the window under the mouse pointer, not the focussed window! Excel just does it to be annoying ... and only if the mouse is over any Excel spreadsheet, not Chrome, or Windows Explorer, or ...
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: but only the window under the mouse pointer
Yes, that's what I said the first time. You seem to be misunderstanding what I said.
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
This feature is something linux does better than windows, you can set the setting to scroll active window. I am hoping windows catches up soon and makes it a windows thing instead of per app thing.
|
|
|
|
|
What annoys me is SSMS scrolling both the query pane and the result pane unless I select one.
modified 1-Sep-20 9:52am.
|
|
|
|
|
really? What version? I've never seen that. Some programs have a setting to do that so maybe you turned on a setting?
In 2018, it works like the browsers, scrolls whatever the mouse is over.
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
I'm using SSMS 2014, and 2012 may have done it as well, but I don't think older versions did.
Nothing in the settings looks like it would do that.
|
|
|
|
|
I could've sworn the Mouse applet in Control Panel used to have a checkbox to control exactly that behavior - I forget what it might have been called, and I can't find it right now. Of course, they had to re-do everything in Windows 10, so that doesn't help either.
[Edit]
On Win10, Settings, Devices, Mouse, there's a switch labeled "Scroll inactive windows when I hover over them", which seems to be exactly that. However, Excel does seem to go out of its way to ignore that.
|
|
|
|
|
My Windows 10 Pro version 2004 doesn't have a switch labeled "Scroll inactive windows when I hover over them". What am I doing wrong?
|
|
|
|
|
I thought that: you have to select the mouse in the list on the left
|
|
|
|
|
It shows up on my 2004 system. It's right under the "Choose how many lines to scroll each time" slider.
|
|
|
|
|
I'm on 2004 as well, so even though they keep moving that crap around in each version, yours should still match mine. I've spelled out the steps to get there in my post, and I've just verified that I haven't skipped any.
|
|
|
|
|
Yes, that has bugged the heck out of me numerous times as well. With Word or a browser going, Excel always manages to scroll when I don't want it to!
Another major annoyance is when Excel and Word go out of focus, they no longer highlight the currently highlighted or selected cells. That makes it really hard to keep track of where you are when in another program and glance back over to remind yourself what you were doing.
Other than that, I don't get the hate for Word. To me, it is an extremely powerful editor when you know the its ins and outs. I formatted an entire book in it, including embedded pictures and the index, and it worked far better than the version of Serif's PagePlus I bought that many people swore by. Serif's indexer wasn't even a tenth as good as Words.
|
|
|
|
|
One clarification: Word's ribbon absolutely sucks. It should burn in the lowest levels of hell for all eternity, and those who designed and pushed it over the menu system lack the intelligence to eat breakfast cereal.
|
|
|
|
|
I found out users were running multiple instances of my app, because they could, even though I had never considered it myself at the time (Win 95 / XP). But no multiple monitors.
I find that FireFox gets confused with multiple monitors if one of them isn't turned on at start up.
And VLC player freaks out moving between monitors of different resolutions; picking monitors other than the one intended.
It's a user model they're still trying to get a handle on.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
IIRC mouse handling has been butchered in the Windows 98 timeframe due to licensing.
Once upon time we had X Window style mouseover activates the underlying window setting, too.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
