qrilka/xlsx

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

jappeace opened this issue · 1 comments

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]

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.