https://bugs.documentfoundation.org/show_bug.cgi?id=115214
Bug ID: 115214
Summary: FILESAVE XLSX Function Syntax Error (#Name?), with a
reference to an external xlsx file.
Product: LibreOffice
Version: 5.4.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: kelem...@ubuntu.com
Created attachment 139345
--> https://bugs.documentfoundation.org/attachment.cgi?id=139345&action=edit
Example data source file made with LO 5.4
These spreadsheets was created with LibreOffice 5.4.3.2 and LibreOffice Dev.
6.0. The main problem here is the functions which did not work correctly if we
want to refer to an external file. We got an Error (#NAME?) message in the
cell, if we use the Excel A1 Formula Syntax. Although we set the syntax to
“Excel A1”, the function syntax does not look like the “Excel A1” syntax.
Steps to reproduce:
1. Create a new spreadsheet with LibreOffice Calc 5.4
2. Click on Tools then choose the options.
3. In the Option set the LibreOffice Calc Formula options just like as you can
see at the attached Formula_syntax_setting.PNG file.
4. Fill the A1:A3 cells with some number.
5. Save the file as “Function_Error_Source.xlsx” or something like that.
6. Create a new spreadsheet with LibreOffice 5.4 and save as
“Function_Error_Target.xlsx”.
7. In the “Function_Error_Target.xlsx” file click on the A1 cell and then click
on the “Function wizard” and choose a function (for example “MAX”). Then select
the data in the “Function_Error_Source.xlsx” file (A1:A3 cells) and press OK.
Here is the example code with “Excel A1” syntax:
MAX('file:///c:/users/teszt_admin/desktop/function_error_source.xlsx'#$sheet1.a1:A3)
Actual results:
We got an Error (#NAME?) code as a function result. If we save the file and
reload the spreadsheet the function result will be the same (#NAME?). If we
open this file (Function_Error_Target.xlsx) with Microsoft Excel we got an
error message of course.
Expected results:
If we choose the Excel A1 syntax the function syntax should be the same as in
Microsoft Excel. There is no difference between the Excel A1 and Calc A1 syntax
when we use a function in LibreOffice. But if we use the Calc A1 syntax for a
function we have not got a (#NAME?) result.
Version: 5.4.3.2
Build ID: 92a7159f7e4af62137622921e809f8546db437e5
CPU threads: 4; OS: Windows 6.1; UI render: default;
Locale: hu-HU (hu_HU); Calc: group
Version: 6.0.0.1.0+
Build ID: c678dc5309741097d9b0265f03dd279a8794d256
CPU threads: 4; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@42, Branch:libreoffice-6-0, Time: 2017-12-28_04:21:33
Locale: hu-HU (hu_HU); Calc: group
--
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
