[Libreoffice-bugs] [Bug 114113] New: No color highlighting of reference if it contains sheet name in single quotes (with spaces)

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com
                CC: erack at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171128/807eb327/attachment.html>