[Libreoffice-bugs] [Bug 132519] CELL("ADDRESS"; ...) to other sheet from Workbook imported from Excel may let INDIRECT() fail with #REF! if string reference setting forces different syntax than current formula syntax.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
            Summary|INDIRECT() to other sheet   |CELL("ADDRESS";...) to
                   |from Workbook imported from |other sheet from Workbook
                   |Excel fails with Ref!       |imported from Excel may let
                   |                            |INDIRECT() fail with #REF!
                   |                            |if string reference setting
                   |                            |forces different syntax
                   |                            |than current formula
                   |                            |syntax.
         Resolution|NOTABUG                     |---

--- Comment #9 from Eike Rathke <erack at redhat.com> ---
Seeing the CELL() function mentioned in comment 2 that indeed always returns
the current formula syntax and probably should follow the string reference
setting if that differs from the formula syntax.

For that reopening the bug.

-- 
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/20200430/b83ad44d/attachment.htm>