Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Editing linked workbooks: formulae don't change?

LibreOffice Calc version 6.0.5.2 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?

Editing linked workbooks: formulae don't change?

LibreOffice Calc version 6.0.5.2 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?