Bug 105622 - Highlight more than 64 cells in Calc formula
Summary: Highlight more than 64 cells in Calc formula
Status: ASSIGNED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: shubhamgoyal
URL:
Whiteboard: target:6.3.0
Keywords:
Depends on:
Blocks: Calc-Enhancements Cell-Formula
  Show dependency treegraph
 
Reported: 2017-01-30 19:24 UTC by Thomas Lendo
Modified: 2019-05-15 11:57 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Only the first 32 cells are colored in an arithmetic operation (16.22 KB, image/png)
2017-02-01 09:06 UTC, Thomas Lendo
Details
64 cells are colored with LibO 5.2.5.1 on Linux (Ubuntu) 32-bit (32.99 KB, image/png)
2017-02-02 20:44 UTC, Thomas Lendo
Details
Example spreadsheet with formula in cell B1 (10.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-02-09 09:52 UTC, Thomas Lendo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Lendo 2017-01-30 19:24:48 UTC
Description:
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:
.

Actual Results:  
.

Expected Results:
.


Reproducible: Always

User Profile Reset: 

Additional Info:


User-Agent: Mozilla/5.0 (Android 5.0; Mobile; rv:50.0) Gecko/50.0 Firefox/50.0
Comment 1 Julien Nabet 2017-01-31 20:53:05 UTC
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?
Comment 2 Thomas Lendo 2017-02-01 09:06:33 UTC
Created attachment 130810 [details]
Only the first 32 cells are colored in an arithmetic operation

@Julien Nabet:
My current used version is 5.1.4.2 (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.
Comment 3 Julien Nabet 2017-02-01 09:24:18 UTC
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.

See https://wiki.documentfoundation.org/ReleasePlan#Dates
Comment 4 Thomas Lendo 2017-02-02 20:44:36 UTC
Created attachment 130866 [details]
64 cells are colored with LibO 5.2.5.1 on Linux (Ubuntu) 32-bit

@Julien Nabet:
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 5.3.0.3 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: 5.2.5.1, Build-ID: 1:5.2.5~rc1-0ubuntu1~trusty0
CPU-Threads: 2; BS-Version: Linux 3.13; UI-Render: Standard; VCL: gtk2
Comment 5 Thomas Lendo 2017-02-09 09:52:41 UTC
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 5.3.0.3 on Windows 10.
Comment 6 Thomas Lendo 2017-02-09 09:53:59 UTC
Changed summary text from "32" to "64".
Comment 7 Buovjaga 2017-02-12 15:29:00 UTC
(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 5.3.0.3 on Windows 10.

Confirmed by double-clicking the formula.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
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
Comment 8 Thomas Lendo 2017-12-20 12:00:19 UTC
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)?
Comment 9 Heiko Tietze 2018-01-23 20:14:02 UTC
Is it one for you, Gülşah? Feeding people who just finished another task ;-)
Comment 10 QA Administrators 2019-01-24 03:51:12 UTC Comment hidden (obsolete)
Comment 11 Commit Notification 2019-05-15 07:58:54 UTC
Shubham Goyal committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/+/38ea76edb9b009a5eeeeeff748e7e14b98423828%5E%21

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:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 12 Thomas Lendo 2019-05-15 11:57:05 UTC
(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?