Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Comparative test: linked workbooks fail to transition from Excel/Windows to Calc/Linux

Following my earlier queries (listed below), I've undertaken a comparative test of linked workbooks in Excel/Windows and Calc/Linux.

The test sought to replicate the experience of a user wanting to migrate from Excel/Windows to Calc/Linux via a sync agent of Google Drive.

Unfortunately, the findings of this test suggest that Calc cannot successfully, or consistently, link workbooks. This means that it isn't feasible to migrate from Excel/Windows to Calc/Linux.

The full test documentation is linked below. The findings are in file "documentation Excel v Calc linked books named ranges test.*". The test workbooks and loads of screenshots are present. The full documentation is zipped in "full package- Excel v Calc linked books named ranges test.zip".

This issue asks for a detailed peer review, not quick fixes. It could take a developer up to 4 hours to review the documentation and understand it, then a further 16 hours to re-test/re-prove/disprove the findings.

Documentation of the test:

  • https://drive.google.com/drive/folders/1Lph8nIRHh53W3nlbmoL4zdWUrJhGyTgp?usp=sharing

Prior issues:

  • https://ask.libreoffice.org/en/question/158187/closed-abandoned-calc-named-ranges-v-database-ranges/
  • https://ask.libreoffice.org/en/question/160051/unsolvedunreplicated-editing-linked-workbooks-formulae-dont-change/
  • https://ask.libreoffice.org/en/question/160048/unsolvedunreplicated-why-inconsistent-calculation-outcomes-with-linked-spreadsheets/