Bug 124036 - Calc cells with formula's don't highlight cells in the presence of a % symbol
Summary: Calc cells with formula's don't highlight cells in the presence of a % symbol
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2019-03-13 01:49 UTC by ali
Modified: 2023-09-24 01:11 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
highlight cell with formula percent sign (12.24 KB, image/png)
2023-09-24 01:10 UTC, Kira Tubo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ali 2019-03-13 01:49:09 UTC
Description:
If I type the number "5" in cell A1 and type in cell B1 the following formula "=A1%" vs "=A1/100" the both give the same value, 0.05, however the later will highlight cell A1 and show it as a dependency of the formula when I go back to edit the cell while the former does not.  It should highlight it in both cases.

Steps to Reproduce:
1. Type 5 into cell A1
2. Type =A1% into cell B1
3. Highlight cell B1 and go to the edit textbox, cell A1 is not highlighted
4. If instead we type =A1/100, and subsequently go to the edit textbox, cell A1 is highlighted

Actual Results:
A1 is not highlighted when re-editing cell B1

Expected Results:
A1 should be highlighted when re-editing cell B1


Reproducible: Always


User Profile Reset: Yes



Additional Info:
This functionality works in Excel
Comment 1 Durgapriyanka 2019-03-15 22:34:49 UTC
Thank you for reporting the bug. I can confirm the bug present in 

Version: 6.3.0.0.alpha0+
Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 2 Xisco Faulí 2019-03-22 12:26:35 UTC
Also reproduced in

Version: 5.2.0.0.alpha0+
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.15; Render: default; 

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 3 QA Administrators 2021-04-04 04:00:38 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2023-04-05 03:23:55 UTC Comment hidden (obsolete)
Comment 5 ady 2023-04-05 18:50:13 UTC
Bug still present in:
Version: 7.4.6.2 (x64) / LibreOffice Community
Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (es_AR); UI: en-US
Calc: CL

Interestingly, Trace Precedents and Trace Dependents mark the relation between cells. So this is only relevant for Edit mode (formula bar, or F2).
Comment 6 Kira Tubo 2023-09-24 01:10:58 UTC
Created attachment 189784 [details]
highlight cell with formula percent sign

It looks like this is no longer reproducible in the daily master build or the current stable build. I will be closing this ticket as WORKSFORME.
Comment 7 Kira Tubo 2023-09-24 01:11:41 UTC
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