https://bugs.freedesktop.org/show_bug.cgi?id=83481
Priority: medium
Bug ID: 83481
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: EDITING: Incorrect syntax for external references with
Excel A1 or R1C1 formula syntax
Severity: normal
Classification: Unclassified
OS: All
Reporter: jumbo4...@yahoo.fr
Hardware: Other
Status: NEW
Version: 4.1.6.2 release
Component: Spreadsheet
Product: LibreOffice
Bug description: it is not possible to build correct external reference with XL
A1 or XL R1C1 formula syntax
Step to reproduce:
1. Create a new spreadsheet
2. Select Tools > Options > LibreOffice Calc > Formula: Formula syntax="Excel
R1C1" or "Excel A1"
3. Start a formula with =
4. Open an existing spreadsheet
5. Select a cell
6. Return to the new spreadsheet
Observed behavior:
Reference is: 'file:///C:/<path to file>/test.xls'#Feuil1!R[4]C[1]
=> result is #NAME?
Expected behavior:
Syntax should be: ['file:///C:/<path to file>/test.xls']Feuil1!R[4]C[1]
and result should be the content of the cell
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
