ethercalc icon indicating copy to clipboard operation
ethercalc copied to clipboard

Published 20 hours ago • verified publisher icon audreyt

XLSX and ODS exports output invalid XML files

Open pedlino opened this issue 4 years ago • 4 comments

When opening the resulting ODS file in OpenOffice or LibreOffice I get the following error message

Screenshot from 2020-09-04 17-00-10

I have attached a sample XLSX but could not attach the ODS because Open Document formats are not supported by GitHub!!! This is ridiculous! (but then again GitHub was acquired by Microsoft, right?)

escalalabs.xlsx

Here is the ODS uploaded as ZIP (please change the extension from ZIP to ODS) escalalabs.zip

pedlino avatar Sep 04 '20 16:09 pedlino

Please can you describe how to recreate this?

I tested with: https://ethercalc.net/eddy_download_test and all worked just fine.

eddyparkinson avatar Sep 05 '20 04:09 eddyparkinson

I forgot to leave the link to the ethercalc spreadsheet :) https://ethercalc.net/=escalalabs

Thanks for looking into this!

pedlino avatar Sep 05 '20 08:09 pedlino

Looks like a mutisheet issue. This also fails https://ethercalc.net/=eddymulti2

Old versions work - e.g. http://sheet.cellmaster.com.au/ has the older export code and exports to XLSX

eddyparkinson avatar Nov 10 '20 06:11 eddyparkinson

Currently it is impossible even to save a single sheet. Only CSV is working. Help?

pedlino avatar Mar 09 '21 10:03 pedlino