Welcome to the Lounge

1-Sep-20 1:32

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 ... D'Oh! | :doh:

"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!

Johnny J.1-Sep-20 1:38

Johnny J.

1-Sep-20 1:38

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... Unsure | :~

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.

OriginalGriff1-Sep-20 1:54

1-Sep-20 1:54

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. Laugh | :laugh:

CPallini1-Sep-20 2:14

CPallini

1-Sep-20 2:14

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. Poke tongue | ;-P

Rick York1-Sep-20 7:58

Rick York

1-Sep-20 7:58

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?"

Mike Winiberg2-Sep-20 5:00

Mike Winiberg

2-Sep-20 5:00

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.

Kornfeld Eliyahu Peter1-Sep-20 1:39

Kornfeld Eliyahu Peter

1-Sep-20 1:39

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 Laugh | :laugh:

"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012

ZurdoDev1-Sep-20 2:53

1-Sep-20 2:53

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.

OriginalGriff1-Sep-20 3:12

1-Sep-20 3:12

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!

ZurdoDev1-Sep-20 3:22

1-Sep-20 3:22

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.

OriginalGriff1-Sep-20 3:29

1-Sep-20 3:29

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 ...

ZurdoDev1-Sep-20 3:35

1-Sep-20 3:35

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.

nobody15818-Sep-20 8:27

nobody158

18-Sep-20 8:27

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.

PIEBALDconsult1-Sep-20 3:28

PIEBALDconsult

1-Sep-20 3:28

What annoys me is SSMS scrolling both the query pane and the result pane unless I select one.

modified 1-Sep-20 9:52am.

ZurdoDev1-Sep-20 3:36

1-Sep-20 3:36

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.

PIEBALDconsult1-Sep-20 3:52

PIEBALDconsult

1-Sep-20 3:52

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.

dandy721-Sep-20 4:28

dandy72

1-Sep-20 4:28

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.

Member 131386682-Sep-20 4:31

Member 13138668

2-Sep-20 4:31

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?

mngerhold2-Sep-20 4:50

mngerhold

2-Sep-20 4:50

I thought that: you have to select the mouse in the list on the left

sasadler2-Sep-20 6:35

sasadler

2-Sep-20 6:35

It shows up on my 2004 system. It's right under the "Choose how many lines to scroll each time" slider.

dandy722-Sep-20 7:40

dandy72

2-Sep-20 7:40

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.

David O'Neil1-Sep-20 6:16

David O'Neil

1-Sep-20 6:16

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.

The forgotten roots of science | C++ Programming | DWinLib