Created attachment 139377 [details]
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