Ask Your Question

[UNSOLVED/UNREPLICATED] Editing linked workbooks: formulae don't change?

asked 2018-07-08 18:22:45 +0200

taxedserf gravatar image

updated 2018-07-21 20:46:01 +0200

LibreOffice Calc version running on Linux Mint Xfce 18.3

Calc imported a series of XLSX, saved each as ODS, closed and re-opened the ODS.

Edit Links > Modify each XLSX reference to that of the equivalent ODS file.

But, in the workbook, references to the XLSX remained. It required a find-and-replace exercise to manually replace ".XLSX" with ".ODS".

Is this by design?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-07-08 20:22:02 +0200

erAck gravatar image

Works here. Select the source file in Edit -> Links ..., with Modify choose new file (unfortunately the link is not updated in the dialog after that before closing), close dialog => external references in cell formulas are updated with the new name.

edit flag offensive delete link more


I can't replicate the success. I can, however, replicate the issue in sanitised versions of the workbooks. The ultimate originals were xlsx imported into LibreOffice,saved as ODS, redacted heavily and re-saved as new ODS files. Re-linked, yet still two links in Edit Links and now #NAME has appeared instead of zero.

taxedserf gravatar imagetaxedserf ( 2018-07-13 23:37:16 +0200 )edit

Same sample file as in the accs- Automatic accounts 2019 debug anon.ods file does not have any named ranges or database ranges so can't work.

erAck gravatar imageerAck ( 2018-07-14 20:29:51 +0200 )edit

Looks like the redaction process removed the named ranges, which didn't help (!!), and the files needed to be renamed to make them different from the originals. Test data clearly flawed. It demonstrates why testing spreadsheets is actually rock hard. I'll close this issue as unsolved/unreplicated and raise another issue when the incident recurs.

It's frustrating, because I cannot get Calc to work as reliably as Excel. It undermines the project to leave Microsoft!

taxedserf gravatar imagetaxedserf ( 2018-07-21 20:45:46 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-08 18:22:45 +0200

Seen: 39 times

Last updated: Jul 21 '18