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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
