Bug 100970 - Formula edit not hightlighting cells when value in sheet with uncommon name (with "-" or "," values)
Summary: Formula edit not hightlighting cells when value in sheet with uncommon name (...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2016-07-17 15:09 UTC by Jaroslav Urik
Modified: 2020-07-12 09:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jaroslav Urik 2016-07-17 15:09:00 UTC
Hi,
I have noticed, that values are not highlighted when formula points to sheet which needs to be in single quotes (in the formula) - when they contain characters like "-", ";" or ","... In this case the cell highlighting does not work. The problem is resolved when sheet is renamed..ยจ
e.g. formula "=A5+Q3+my_sheet_food.B35" works fine, but formula "=A5+Q3+'sheet-food,drinks'.B35" does not highlight values in "commented" sheets.
Comment 1 m_a_riosv 2016-07-17 21:44:49 UTC
Hi @Jaroslay, thanks for reporting.

Reproducible.
Win10x64
Version: 5.1.5.1 (x64) Build ID: bb431b2be5fb7772067efc27a3cc98b6927c7b4c
CPU Threads: 1; OS Version: Windows 6.19; UI Render: GL; 
Locale: es-ES (es_ES); Calc: CL
Comment 2 QA Administrators 2018-07-12 02:44:03 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2020-07-12 03:37:04 UTC Comment hidden (obsolete)
Comment 4 m_a_riosv 2020-07-12 09:00:13 UTC
Works for me with
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 9af38b4504ccda57a0c32eb8bdd03e5a8ca29ddc
CPU threads: 4; OS: Windows 10.0 Build 19608; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: threaded