[Libreoffice-bugs] [Bug 130333] LibreOffice Calc: Invalid reference result from INDIRECT() function when trying to reference a cell in another sheet

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Mar 15 16:12:08 UTC 2021


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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

--- Comment #6 from Eike Rathke <erack at redhat.com> ---
Apparently this is if the sheet name is enclosed in typographical single quotes
(e.g. ’ U+2019 RIGHT SINGLE QUOTATION MARK) instead of ASCII single quotes '
U+0027 APOSTROPHE. Disable Tools -> AutoCorrect, tab Localized Options,
replacement of single quotes (and best double quotes as well); or make
otherwise sure the correct characters are used to quote a sheet name. Note that
comment 0 uses apostrophe, but I doubt that's what the cell actually contained.
But as there never was sample file attached..

-- 
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/20210315/b325350e/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list