This table summarizes how the column and row settings are handled when Spread.Sheets exports to an Excel-formatted file. These functions are in the GC.Spread.Sheets.Worksheet 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 Spread.Sheets. |
| Column Height |
Excel ignores the Sheet setting. This is specific to Spread.Sheets. |
| Row or Column allowUserResize |
Excel ignores the Sheet setting. This is specific to Spread.Sheets. |
| Starting Column and Row |
Not supported at this time. |