Problem found in content of the Excel Sheet #2833

New Issue

codeninjas · 2022-12-01T22:23:47Z

codeninjas commented

2022-12-01 22:23:47 +00:00

Attached the output of the excel (had to clear some of the sensitive info) as well as the window pop-up that I get on opening. I originally thought it was missing data but on inspection, seems like I made a mistake on that. The only outstanding thing is what it's not liking from an excel perspective so my users won't be alarmed by the pop-up.

xlsx bug.png

6.6 KiB

Sales Report_ 2022-11-01 to 2022-12-01-cleaned.xlsx

20 KiB

sheetjs commented

2022-12-01 23:31:42 +00:00

The popup does not show up locally, although the screen does flicker a bit. Checking against the OpenXML validator does not reveal any issue, so it may be an artifact of the original file.

Can you click "Yes" in the original export and check if there is an option to see the log? If you can, please share it.

Also, can you try bijecting (exporting fewer rows) until you find a specific row that causes issues? There may be some bad exported data

The popup does not show up locally, although the screen does flicker a bit. Checking against the OpenXML validator does not reveal any issue, so it may be an artifact of the original file. Can you click "Yes" in the original export and check if there is an option to see the log? If you can, please share it. Also, can you try bijecting (exporting fewer rows) until you find a specific row that causes issues? There may be some bad exported data

sheetjs commented

2022-12-14 11:52:14 +00:00

If you can share the file, we can take a closer look. If the data is confidential, please send an email to hello@sheetjs.com and we can try other approaches

sheetjs closed this issue

2022-12-14 11:52:20 +00:00

Sign in to join this conversation.