Reading xlsx with Column width exceeded 255

[pokorny]

In Excel version : Microsoft Office Professional Plus 2019 Version 2503 (build 18623.20178) is possible to exceed max. allowed column width.

Steps to reproduce:

• Create new Worksheet
• Grab first column and extend it to maximal width (in tooltip is information: Width: 254.86 (1789px)
• Save the file
• Unzip the xls and look at sheet1.xml
• In the current version of NanoXLS, a subsequent attempt to open an xlsx file will result in an error

Possible solution

• Let's add new property ImportOptions "EnforceAllowedColumnWidth" with default value true
• In case width will not be enforced and width will be out of allowed range it will be setted to Worksheet.MIN_COLUMN_WIDTH or Worksheet.MAX_COLUMN_WIDTH.