Selection paint in Excel
-
Confirmed in Excel 2013. Harmless but WTF-y nonetheless.
-
https://support.microsoft.com/en-us/kb/2769340
This behavior is by design because of a change in the Excel 2013 or Excel 2016 graphics engine. This change enables you to highlight overlapping selections. If you repeatedly select the same cells, the cell shading eventually becomes too dark, and you cannot see the text in the cell.
TRWTF is overlapping selection.
-
> If you repeatedly select the same cells, the cell shading eventually becomes too dark, and you cannot see the text in the cell.
Shhh! Here's an idea. Increase the lightness of text as you darken the cell!
-
I don't get what the WTF is here?
The darker color means you have two ranges that overlap. It's a feature.
-
I don't get what the WTF is here?
The darker color means you have two ranges that overlap. It's a feature.
If you repeatedly select the same cells, the cell shading eventually becomes too dark, and you cannot see the text in the cell.
Why not just create a single selection? Is there some advantage to seeing all the individual overlapping selections? Maybe some feature I'm missing?
-
Maybe some feature I'm missing?
You were always allowed to have overlapping selections, but it was never obvious if you did so.Typically thi isn't an issue, but for dumb scripts that take your selection at face value, it can be easy to accidentally apply some operation to the same cell multiple times this way.
With this new graphical change, at least you can see when you're about to Do Something Wrong.
Filed under: Yes, perhaps TRWTF is not simply merging the RANGE value, but that's processor intensive!
-
Why not just create a single selection?
Makes formulas easier if you want the formula to just refer to the range and not have to enumerate each cell in it.
Is there some advantage to seeing all the individual overlapping selections?
For an individual cell? Probably not. It's harmless though.
Maybe some feature I'm missing?
No, you have it.
-
-
Harmless but WTF-y nonetheless.
All we need now is some crazy Japanese guy to use this to create pictures. I guess in this case they'll need to be monochrome, but great art knows no barriers!
-
Did that once, but after making about 1,201 selections I had to take a break and locked my machine. Apparently some time during the unlock process Excel lose my selection...
I did a quickie though:
-
The darker color means you have two ranges that overlap. It's a feature.
Weren't you the one who always says that unwanted features are bugs?
-
-
You have very bad memory.
-
Technically, I think it was more along the lines of "If I'm not expecting it to do this, it's a bug".
- It was discussing Markdown lists
- Blakey keeps calling this a bug
- All of these are 1 in the raw
-
-
Fuck you. Give me links.
-
Weren't you the one who always says that unwanted features are bugs?
They're only bugs if blakeyrat doesn't want them.
-
... I'm sorry, do you want something?
-
Apparently some time during the unlock process Excel lose my selection.
Probably you have to make sure it's not the active window when you lock.
-
You have very bad memory.
No, things he doesn't like are bugs. That may not be the same set as "things he doesn't want".
-
https://what.thedailywtf.com/t/a-dont-do-wrong-broken-shit-checkbox-in-visual-studio-you-wish/7580
So this bug (and I refuse to call it a "feature", even if some moron on the VS team thinks it's desirable behavior)
Closest thing I could find using Disco-Search... I am pretty sure it only gives you one result per topic, though, which is the worst kind of search I can think of...
Filed Under: You can
thankinsult me later for this hard work
-
3 Minutes Later
You have my gratitude, junior belgium er.
-
That was both a thanks and an insult at the same time! I am honored and impressed.
Though my Filed Under was kinda directed at blakeyrat
Filed Under: I am not in the ■■■■■■■-group, though!
-
We might be able to do this in Discourse soon
You drag highlight stuff now