https://bugs.documentfoundation.org/show_bug.cgi?id=114113
Bug ID: 114113
Summary: No color highlighting of reference if it contains
sheet name in single quotes (with spaces)
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mikekagan...@hotmail.com
CC: er...@redhat.com
When a reference in a spreadsheet formula contains the sheet name in single
quotes (e.g., when the sheet name contains spaces), the reference isn't
color-highlighted.
Steps to reproduce:
1. In a new spreadsheet, in the default sheet (Sheet1), enter "=Sheet1.A2" to
A1.
2. After reentering the formula bar of A1, see that A2 is highlighted with blue
(both the cell itself, and its name in formula bar).
3. Now rename the sheet to "Sheet 1" (add space between "Sheet" and "1").
4. Reenter A1 formula bar; notice that the formula now looks like "='Sheet
1'.A2".
Expected result: A2 should be highlighted, as at step 2.
Actual: A2 isn't highlighted, neither on spreadsheet, nor in formula bar.
Reproducible with Version: 6.1.0.0.alpha0+ (x64)
Build ID: 401a3d2336bf46b38235c498ff86ff675d0de759
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: ru-RU (ru_RU); Calc: CL
and also with OpenOffice.org 3.3.0
OOO330m20 (Build:9567)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
