https://bugs.documentfoundation.org/show_bug.cgi?id=114918
Bug ID: 114918
Summary: Updating links doesn't work after reloading an XLSX
file with cell reference in function
Product: LibreOffice
Version: 5.4.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
These spreadsheets were created with LibreOffice 5.4.3.2 and LibreOffice Dev.
6.0 and contain links. If we want to refer to an external file with cell
reference or a function, we have to click in the function to refresh the links.
If we just open the file and click Yes on the “This file contains links to
other files. Should they be updated?” message, nothing happens.
Steps to reproduce:
1. Create a new spreadsheet with LibreOffice Calc.
2. Click on Tools then choose Options.
3. In the Options set the LibreOffice Calc Formula options just like as you can
see at the attached Formula_syntax_setting.PNG file. I use these settings
because this is the only one which is interoperable with Microsoft Office
Excel.
4. Fill the cells with some simple data.
5. Save the file as “Source.xlsx”. This will be the source file which contains
the queried data.
6. Create a new spreadsheet in Calc and save as
Function-update-link-target_LO-54.xlsx. This is the reference file.
7. In the Function-update-link-target_LO-54.xlsx file create a correct function
or a simple cell reference which refers to the “Source file” data.
8. Save the file and close it.
9. Modify the “Source.xlsx” file data, which is referenced by the reference
file.
10. Save the file.
11. Open the reference file (Function-update-link-target_LO-54.xlsx) and click
YES on the “Should they be updated?” message.
Actual results:
When I click YES on the “Should they be updated?” dialog, nothing happened. If
I choose the “Always” Update links when opening, instead of “On request” I
still get the dialog.
Expected results:
When I click YES on the “Should they be updated?” dialog, the links should be
updated. If I choose the “Always” Update links when opening, instead of “On
request” the links should be updated automatically without any message.
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.0.beta1+
Build ID: 29228e83df009cf76ac819ed024527be1092f065
CPU threads: 4; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@42, Branch:libreoffice-6-0, Time: 2017-12-04_23:15:34
Locale: hu-HU (hu_HU); Calc: group threaded
--
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
