Booleans from Excel sheet from Microsoft produce TRUE/FALSE whilst Libre Office produce 1/0
KNejad opened this issue · 0 comments
Firstly, thanks for the amazing tool. It's saved me a lot of time automating things compared to manually converting each page to a CSV!
When I run xlsx2csv on a file created in Microsoft Excel, the output of boolean fields are either TRUE or FALSE (microsoft_version.csv, microsoft_version.xlsx).
When I then save that file again in Libre Office, without making any changes, the outputs are either 1 or 0 (libre_office_version.csv, libre_office_version.xlsx)
I would expect both versions to produce the same output.
I am running Arch Linux with the latest version of xlsx2csv.
$ xlsx2csv --version
0.7.8
$ libreoffice --version
LibreOffice 7.2.1.2 20(Build:2)
The example Microsoft Excel sheet was produced in the web version of Excel, however I believe the same issue occurs with files generated from the desktop version.