[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
bugzilla-daemon at bugs.documentfoundation.org
Tue Oct 10 05:08:18 UTC 2017
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>
More information about the Libreoffice-bugs
mailing list