This table summarizes how the column and row settings are handled when SpreadJS exports to an Excel-formatted file. These functions are in the GcSpread.Sheets.Sheet class unless otherwise noted.
Row and Column Setting |
Excel Setting and Remarks |
Column or Row Visible |
Excel uses this setting. |
Row Height |
Excel uses this setting. |
Column Width |
Excel uses this setting. |
Row Width |
Excel ignores the Sheet setting. This is specific to SpreadJS. |
Column Height |
Excel ignores the Sheet setting. This is specific to SpreadJS. |
Row or Column CanUserResize |
Excel ignores the Sheet setting. This is specific to SpreadJS. |
Starting Column and Row |
Not supported at this time. |