New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

We shouldn't be able to make sheetnames bigger then 31 characters. #155

Open

jappeace opened this issue Jul 15, 2022 · 1 comment

Contributor

jappeace commented Jul 15, 2022

The reason is that excell claims the worksheet "may contain a virus" if it detects this.
Excell validator explain this:

File: xlsx/avy.xlsx
Error: The attribute 'name' has invalid value 'Gross written premium (calendar years)'. The actual length is greater than the MaxLength value. The length must be smaller than or equal to 31.
ContentType: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml
XPath: /x:workbook[1]/x:sheets[1]/x:sheet[1]

The text was updated successfully, but these errors were encountered:

vrom911 commented Apr 30, 2024

Additionally to that, here are all the conditions on the sheet names:

the name you entered does not exceed 31 characters.
the name does not contain any of the following characters: : \ / ? * [ or ]
the name is not blank.

We could introduce "safe" function like createSafeSheetName for these checks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment