webodf / ViewerJS

ViewerJS: Document Reader in JavaScript
http://viewerjs.org
1.94k stars 422 forks source link

random fields in ODS spreadsheet return as blank #308

Closed chenks closed 11 months ago

chenks commented 1 year ago

not sure if this project is still active, but came across it because i was wanting to find a way to view spreadsheets from within our website. it works, sort of, but i have some issues.

we have the spreadsheet saved as an ODS file, and using the required code it does open within the ViewerJS tool.

however we are seeing that it's randomly missing out fields in some columns. at first i though maybe the original XLSX file was corrupt so i re-created it from scratch and saved it direct as an ODS file - got the same result where some fields return blank.

have tested in both Chrome and Firefox with the same result

see example screenshot below, all the fields circled should be coloured (similar to the other coloured fields) Screenshot 2022-08-25 131017

any ideas what the problem is?

also, is it possible for ViewerJS to respect column widths? are it seems to make some columns thinner than they are in the OSD file when opened in Excel.