[Libreoffice-bugs] [Bug 113027] New: Editing F4 (Sheet - Cycle Cell Reference Types) doesn' t cycle remote references with space in sheet name

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=113027

            Bug ID: 113027
           Summary: Editing F4 (Sheet - Cycle Cell Reference Types)
                    doesn't cycle remote references with space in sheet
                    name
           Product: LibreOffice
           Version: 5.3.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jrussell_88 at yahoo.com.sg

Created attachment 136881
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136881&action=edit
Example remote RC reference to sheet with space in name

LibreOffice Version: 5.3.1.2
Build ID: 1:5.3.1-0ubuntu2

Ubuntu 17.04 on a MacBook Retina Pro

Open a new workbook with RC Formula Syntax (Tools - Options - LibreOffice Calc
- Formula Formula Options) and add a sheet with a space in the name e.g. 'Sheet
3'.

A formula containing a remote reference from the active Sheet1 to 'Sheet 3'
e.g. '='Sheet 3'!R[1]C[1]' cannot be cycled between absolute and relative
references by pressing F4 or selecting the command. 

Works as expected with Formula Syntax Calc A1 and Excel A1, but fails in Excel
RC with error dialog: No cell references are found in the selected cells.

-- 
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/20171010/d6ebf446/attachment.html>