[Libreoffice-bugs] [Bug 131653] Support exclamation mark for referenced to cells on another sheet for Excel compatibility.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Richard <richard.crozier at yahoo.co.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|INVALID                     |---
     Ever confirmed|0                           |1

--- Comment #2 from Richard <richard.crozier at yahoo.co.uk> ---
Hmmm, I think the reason I thought this didn't work was because it doesn't seem
to work for references in an INDIRECT statement.

With the setting 'Excel A1' enabled, 

='Sheet 1'!A1

works, but

=INDIRECT("'Sheet 1'!A1")

does not, but 

=INDIRECT("'Sheet 1'.A1")

does actually still work

-- 
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/20200328/61124816/attachment.htm>