Calc only shows a maximum of 32 with color highlighted cells if they are part of an arithmetic operation. Only the first 32 cells are highlighted with 8 different colors.
How can users see which cells are selected when they are not highlighted?
Possible solution: Repeat the coloring of the first 8 cells to more than the first 32 cells.
Inherited from OOo: https://bz.apache.org/ooo/show_bug.cgi?id=100263
Steps to Reproduce:
User Profile Reset:
User-Agent: Mozilla/5.0 (Android 5.0; Mobile; rv:50.0) Gecko/50.0 Firefox/50.0
On pc Debian x86-64 with LO Debian package 5.2.4, I don't reproduce this.
Indeed, I tested with 33 or 34 cells, all have highlighting.
Could you give a try to last stable LO version 5.2.5?
Created attachment 130810 [details]
Only the first 32 cells are colored in an arithmetic operation
My current used version is 22.214.171.124 (x64), BS-Version: Windows 6.19, UI-Render: Standard. I'm using LibreOffice at work, I will be updated by the admin when 5.3.x is released, then I can test a "fresh" version.
The point of my bug report is not if 32 or 34 cells are colored. The point is that ONLY FEW cells are colored and NOT ALL of an arithmetic operation which would be the logical way to highlight it.
My previous comment was just to tell that even when using more than 32 cells, all of them (the 33 or 34) were highlighted.
Now I recognize, I haven't got the patience to test with 100 cells.
FYI, 5.1 branch is EOL so even if the bug is confirmed, there won't be any official TDF version for this branch.
5.2.5 has just been released and 5.3.0 would be released soon but it's never a good thing to use first release of a branch in production.
Created attachment 130866 [details]
64 cells are colored with LibO 126.96.36.199 on Linux (Ubuntu) 32-bit
Thank you, I know the branches and release plans very well. I studied the release notes at the wiki and the list of fixed bugs till 188.8.131.52 and didn't find anything relating to this bug.
I tested it with today's stable version 5.2 and found out that (maybe only on Linux?) 64 cells are colored. Therefore the intention of this bug is still valid.
Version: 184.108.40.206, Build-ID: 1:5.2.5~rc1-0ubuntu1~trusty0
CPU-Threads: 2; BS-Version: Linux 3.13; UI-Render: Standard; VCL: gtk2
Created attachment 131032 [details]
Example spreadsheet with formula in cell B1
64 cells (instead of 32 cells in older LibreOffice versions) are highlighted/colored now.
Tested with version 220.127.116.11 on Windows 10.
Changed summary text from "32" to "64".
(In reply to Thomas Lendo from comment #5)
> Created attachment 131032 [details]
> Example spreadsheet with formula in cell B1
> 64 cells (instead of 32 cells in older LibreOffice versions) are
> highlighted/colored now.
> Tested with version 18.104.22.168 on Windows 10.
Confirmed by double-clicking the formula.
Arch Linux 64-bit, KDE Plasma 5
Build ID: ac8197327d3ef4f3c94fb0746393863404df086b
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4;
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on February 11th 2016
Kumar, as you solved bug 65206 "FORMATTING: Highlighted (colored) cells only limited to 32 cells in formula", can you have a look at this bug?
Was it wanted in bug 65206 that only 64 cells are highlighted (colored)?
Is it one for you, Gülşah? Feeding people who just finished another task ;-)
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword
Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
Shubham Goyal committed a patch related to this issue.
It has been pushed to "master":
tdf#105622 Highlight 128 cells.
It will be available in 6.3.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
(In reply to Commit Notification from comment #11)
> Shubham Goyal committed a patch related to this issue.
Thank you very much for your patch!
Is there a technical limitation or a developer decision why it's wanted to only show 32/64/128 cells highlighted?
A polite ping to shubhamgoyal:
Is this bug fixed? if so, could you please close it as RESOLVED FIXED ? Otherwise, Could you please explain what's missing?
Created attachment 152862 [details]
highlight cells with chart color palett
I would recommend to use the chart color palett cause this is defined for the same issue. Separate elements from each other.
In the image you see:
left: master build
center: standard color palett (problem colors are next to each other similar)
right: chart color palett (background saturation: 10% and brightness: 100 %)
I know the chart color palett didn't has 16, 32, 64, 128, ... different colors. For now there are only 12 colors defined, but that doesn't mean that we can't add there more colors.
When we use an color palett the colors are not hardcoded somewhere, so I think it's an good plan.
*** Bug 126594 has been marked as a duplicate of this bug. ***
For comment, which has nothing to do with this bug, I've created Bug 127227 'Calc formula should use a color palette as highlight color'.
Hi, the problem with this bug been in the unresolved state till now
1) Currently, the have only 8 colors to color 128 adjacent cells.
2) I was asked to include 16 color to do that.
3) But my choice of color combination were matching.
4) Talked to UI team for color combinations, Andreas proposed the idea to use color pallets(In reply to Thomas Lendo from comment #12)
> (In reply to Commit Notification from comment #11)
> > Shubham Goyal committed a patch related to this issue.
> Thank you very much for your patch!
> Is there a technical limitation or a developer decision why it's wanted to
> only show 32/64/128 cells highlighted?
There is no such limitation that coloring should be in the power of 2.
But Yes, we can not color much of the cells as coloring reqire time to render. It was tested and found that coloring 128 cells would be fine to by-pass the user's notice.
(In reply to Thomas Lendo QA from comment #16)
> For comment, which has nothing to do with this bug, I've created Bug 127227
> 'Calc formula should use a color palette as highlight color'.
When we have 128 cells to color, it would be bad to only have 8 colors to color them all. It would be cumbersome and complex. Highlighting will be no use then.
so, closing the bug as RESOLVED and will work on including chart color pallet to color cells :)
(In reply to shubhamgoyal from comment #17)
Thank you very much for your clarification and your tests and patch to color 128 cells!
So, it's a performance issue. This is bad but it is as it is. :) Although I regularly need more colored cells.
(In reply to shubhamgoyal from comment #18)
> When we have 128 cells to color, it would be bad to only have 8 colors to
> color them all. It would be cumbersome and complex. Highlighting will be no
> use then.
As the existing colors never were good to distinguish if you have more than a handful elements, it is insignificant if you have 8 different colors or 20 different colors for >30 cells.
I don't see a disadvantage in coloring (for example) 10,000 cells with few 'bad' colors as for so many cells it's not possible to have so many different colors to distinguish them visually. For many cells it's often only needed to have them highlighted with ANY color only to differ them from not-colored cells in a sheet (how the cells are colored is secondary).
> so, closing the bug as RESOLVED and will work on including chart color
> pallet to color cells :)
Feel free to assign yourself to bug 127227 or at least CC yourself and set it to NEW if you think it's worth.