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. |