search

thscharler / spreadsheet-ods

Apache License 2.0
29 stars 6 forks source link

Unable to open generated ODS in Excel #24

Closed twiclo closed 3 years ago

twiclo commented 3 years ago

When trying to open my ods in excel it gives a file corrupted message. If you open that same ods in LibreOffice then save it under a different name you'll see that LibreOffice adds to the archive. The newly saved archive can be opened in Excel without issue.

Pre-re-saved ods that I generated using the library AspenSummit_bom (5).ods And the re-saved ods file test.ods

thscharler commented 3 years ago

I'll have a look. First I have to see to get excel...

twiclo commented 3 years ago

Haha can't blame you for not having it

thscharler commented 3 years ago

Found the bugger. Online excel stumbled upon the empty content-validations tag. And it absolutely needs a sheet-name.

thscharler commented 3 years ago

0.8.1 is out. please try

twiclo commented 3 years ago

That took care of it. Thanks again for the speedy resolution!

thscharler commented 3 years ago

Can't guarantee that next time. But this one nagged me.