Bug 105622 - Highlight more than 64 cells in Calc formula
Summary: Highlight more than 64 cells in Calc formula
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Enhancements Cell-Formula
  Show dependency treegraph
 
Reported: 2017-01-30 19:24 UTC by Thomas Lendo
Modified: 2019-01-24 03:51 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
** 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!

Warm Regards,
QA Team

MassPing-UntouchedBug