Bug 94155 - EDITING Cell highlightning depends on cell name
Summary: EDITING Cell highlightning depends on cell name
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency treegraph
 
Reported: 2015-09-12 08:48 UTC by Martin Lorscheid
Modified: 2023-09-25 23:26 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example for not working cell highlightning (27.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-09-12 08:48 UTC, Martin Lorscheid
Details
Cell highlight for sheet names with characters (28.58 KB, image/png)
2023-09-24 01:31 UTC, Kira Tubo
Details
No cell highlighting v.5.4 alpha (101.67 KB, image/png)
2023-09-25 20:19 UTC, Kira Tubo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Martin Lorscheid 2015-09-12 08:48:01 UTC
Created attachment 118631 [details]
Example for not working cell highlightning

Depending on the name of the referenced calc sheet you will have cell highlightning or not (see attachment).
Cell highlightning works with sheet names as:
Example
Example_1
Will not work with:
Example_(1)

Seems only the brackets () create the problem, other like ## or {} works fine

Found with V.4.4.5.2 but not sure about the earliest affected version.


Workaround:
Rename sheet until highlightning works again
Comment 1 m_a_riosv 2015-09-12 09:57:52 UTC
Hi @Martin, thanks for reporting.

This is inherited from OOo.
Reproducible.
Win10x64
Comment 2 QA Administrators 2016-09-20 10:32:51 UTC Comment hidden (obsolete)
Comment 3 Martin Lorscheid 2016-09-20 20:03:46 UTC
Bug is still present.

Tested versions:
LO 5.1.5.2 (x64) on Win10 Pro
LO 5.1.5.2 on Ubuntu 16.04 LTS

Characters which don't work if any of these are part of the sheet name:
( ) " < >
Comment 4 QA Administrators 2018-07-24 02:37:20 UTC Comment hidden (obsolete)
Comment 5 Martin Lorscheid 2018-07-24 16:05:15 UTC
Bug is still present.

LO Version: 6.0.5.2 (x64)
Build-ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16
Comment 6 QA Administrators 2019-07-30 03:14:49 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2021-07-30 06:23:22 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2023-07-31 03:05:39 UTC Comment hidden (obsolete)
Comment 9 Kira Tubo 2023-09-24 01:31:50 UTC
Created attachment 189786 [details]
Cell highlight for sheet names with characters
Comment 10 Kira Tubo 2023-09-24 01:33:58 UTC
Seems this issue is no longer reproducible in daily master build or current stable build. See attachment 189786 [details]. I also tested the other characters mentioned in Comment 3 and they work fine as well. Closing ticket as WORKSFORME.

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 486ae5db6987411d5e394de94b2b077099d03856
CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded

Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674
CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
Comment 11 ady 2023-09-24 01:46:40 UTC
(In reply to Kira Tubo from comment #10)
> Seems this issue is no longer reproducible in daily master build or current
> stable build.

@Kira,
Where you able to reproduce the problem in an older version first? If you are not able to reproduce the problem in the reported versions (where others do), then there is no real meaning (regarding the status of this report) to not being able to reproduce it in a newer version.
Comment 12 Kira Tubo 2023-09-25 20:19:36 UTC
Created attachment 189814 [details]
No cell highlighting v.5.4 alpha

(In reply to ady from comment #11)
> 
> @Kira,
> Where you able to reproduce the problem in an older version first? If you
> are not able to reproduce the problem in the reported versions (where others
> do), then there is no real meaning (regarding the status of this report) to
> not being able to reproduce it in a newer version.

@ady, Yeah I was able to reproduce on 5.4 alpha, which is somewhere in between all of the other versions that have been reported. See attached. 

Version: 5.4.0.0.alpha1 (x64)
Build ID: 0b9f9bef65bb21ebb6a64aafad448f7f62dc824a
CPU threads: 6; OS: Windows 6.19; UI render: default; 
Locale: en-US (en_US); Calc: CL
Comment 13 Kira Tubo 2023-09-25 20:20:33 UTC
@ady see Comment 12
Comment 14 ady 2023-09-25 23:26:33 UTC
(In reply to Kira Tubo from comment #12)
> @ady, Yeah I was able to reproduce on 5.4 alpha

OK, now it is indeed explicitly clear (as it should). Thank you. Resetting as WFM.