-
Notifications
You must be signed in to change notification settings - Fork 215
Excel files generated by excel4node always showing a warning/error upon opening #140
Comments
Anyone? |
So, it appears that this problem will occur if your sheet name is longer than 31 characters. |
I had a same problem. |
It looks like the 31 character limit is a hard coded limitation into MS Excel. There is nothing that I can find in the XLSX spec about this limitation, however. I'll see about adding some validation and possibly providing a warning/error when attempting to create a worksheet with a name longer than 31 characters. |
Sheet Name is less than 31 character, still not opening file in MS Office 2016. |
@HardikGlib, can you provide a gist that demonstrates the issue? That "we found a problem" prompt can occur for many reasons and you may be seeing that for some reason other than the sheet name character length. |
I had the same problem. It did work when I removed special characters ( _ , : é à -) from the sheet name I hope it can help you |
Other things that I've seen cause this are
Might be worth spitting out some warnings when this happens, if specified limits can be trusted. Also including warnings about (possibly) invalid sheetnames would probably be useful. |
This one hit us, because it's not on Microsoft's list of Excel limits: https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 There are many limits that Excel enforces but other readers like LibreOffice, Numbers, GSheets, don't. It might be worthwhile for excel4node to check for at least the easy ones. The character limits, worksheet name length, etc., can be checked for easily. I imagine the link count limit can also be checked for easily. Simple checks would make the export faster. Also like others have experienced, Excel will only say "there is a problem". Also since the free readers don't have these limits some developers will find it hard to reproduce bugs. |
Hi guys, I'm seeing that the posts are really old... So is this repo still maintained? What about this? I'm having troubles to open generated sheets in MS Excel, but in LibreOffice are opening just fine. |
@amekkawi
Every Excel file that I generate shows a warning/error when opening:
Excel version from Office 2016.
My Excel files do not not have any images, so I'm guessing that the fix proposed in pull request 99 (#99) won't apply, but I've tried that anyway with no luck.
Any ideas?
The text was updated successfully, but these errors were encountered: