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 188.8.131.52 (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 184.108.40.206 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 220.127.116.11 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: 18.104.22.168, 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 22.214.171.124 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 126.96.36.199 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?