[Libreoffice-bugs] [Bug 131653] New: 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

            Bug ID: 131653
           Summary: Support exclamation mark for referenced to cells on
                    another sheet for Excel compatibility.
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: richard.crozier at yahoo.co.uk

Libreoffice uses a dot ('.') to reference cells on other sheets, e.g. 

'Sheet 1'.A1

Excel does not support this syntax, but instead uses an exclamation mark ('!')
like so:

'Sheet 1'!A1

This means documents produced in either system which reference other cells are
incompatible. This enhancement request is for LibreOffice Calc to support both
syntaxes to improve portability of documents.

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