search

brechtsanders / xlsxio

XLSX I/O - C library for reading and writing .xlsx files
MIT License
417 stars 112 forks source link

Blank cells on xlsx files opened on Libreoffice and gnumeric #55

Open lsevero opened 4 years ago

lsevero commented 4 years ago

Hello, I'm having problems on opening the generated xlsx files written by xlsxio_write lib. Running the example program example_xlsxio_write and openning the generated example.xlsx on various spreadsheet editors I had the following results:

Libreoffice 6.2.7.1: Blank Cells 2019-11-05-150249-1080x948-scrot.png

Gnumeric 1.12.44: Blank Cells 2019-11-05-150819-1079x948-scrot.png

Google Sheets: Works fine 2019-11-05-150935-1371x655-scrot.png

I've tested on both Arch Linux and Ubuntu 19.04 and they had the same results. Btw xlsxio was built using minizip, builting it with libzip as the readme states, libreoffice does not even open the file.

brechtsanders commented 4 years ago

Could you send me the actual .xslx file so I can compare and to some tests at my end?

lsevero commented 4 years ago

Sure, https://drive.google.com/file/d/16gHypu-smpI2AStG6Hj9Flg_dk6yIrU0/view?usp=sharing

╰─λ md5sum example.xlsx ec3c127dcde55a20867d331419977aa3 example.xlsx

ghost commented 4 years ago

I am having the same issue, which makes it difficult/slower to debug my own programs from Linux because I have to upload the output to Google Drive.

@brechtsanders have you discovered the cause of this issue?

If you can point us in the right direction (e.g. what the problem is, which part of the xlsxio code to mess with) I or someone else might be able to fix it without much effort.