Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with other spreadsheet software.
For columns exceeding 1352, the current method for converting column number to a letter combination will issue B@A to B@Z, instead of the expected AZA to AZZ. This fix fixes the specific column range 1352 to 1377 - I dont have the time to test for columns beyond this, but programmatically I think it fixes it.
Steps to Reproduce
Use any tabular functionality with more than 1352 columns.
Fix
Modify the "getColumnName" functions in index.ts
Summary
Columns 1352 -> 1377 will no longer issue funny naming, (B@A -> B@Z), and wont mess up formulas and so on.
hodeware
commented
10 months ago
Description
For columns exceeding 1352, the current method for converting column number to a letter combination will issue B@A to B@Z, instead of the expected AZA to AZZ. This fix fixes the specific column range 1352 to 1377 - I dont have the time to test for columns beyond this, but programmatically I think it fixes it.
Steps to Reproduce
Use any tabular functionality with more than 1352 columns.
Fix
Modify the "getColumnName" functions in index.ts
Summary
Columns 1352 -> 1377 will no longer issue funny naming, (B@A -> B@Z), and wont mess up formulas and so on.