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@lists.freedesktop.org
Reporter: richard.croz...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs