https://bugs.documentfoundation.org/show_bug.cgi?id=115244
Bug ID: 115244
Summary: FILESAVE XLSX Cell Reference Error:507, with a
reference external xlsx file cells
Product: LibreOffice
Version: 5.4.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 139377
--> https://bugs.documentfoundation.org/attachment.cgi?id=139377&action=edit
Example data source file made with LO 5.4
These spreadsheets were created with LibreOffice 5.4.3.2 and LibreOffice Dev.
6.0. The main problem here is the cell reference which did not work correctly
if we want to refer to an external file. We got an Error (507) message in the
cell, if we use the Excel A1 Formula 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 cells with some simple data.
5. Save the file as “Cell_reference_source.xlsx” or something like that.
6. Create a new spreadsheet with LibreOffice 5.4 and save as
“Cell_reference_target.xlsx”.
7. In the “Cell_reference_target.xlsx” file click on the B1 cell and then click
on the “equal sign” or “Function button”. After that click on the
“Cell_reference_source.xlsx” file’s A1 cell and hit Enter.
Here is the example code:
=['file:///c:/users/teszt_admin/desktop/lo-4-hivatkozasok/error-507/cell_reference_source.xlsx']munkalap1!a1
Actual results:
We got an Error:507 code in the “Cell_reference_target.xlsx” file’s B1 cell. If
we save the file and reload the spreadsheet the data will be updated and the
Error:507 code will disappear. But If we modify the
“Cell_reference_source.xlsx” file’s A1 Cell and save it, the data will not
updated in the “Cell_reference_target.xlsx” file even if we reload the file. If
we click in the function (refresh the link manual) and hit enter we got an
Error:507 code again.
Expected results:
We should not receive an error code in the cell, because the link and the
syntax is correct. The links should be updated when we got the “This file
contains links to another files Should they be updated?” message and we click
Yes.
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
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
