ig.excel.FrozenPaneSettings
Remarks
Note: Frozen and unfrozen panes cannot be used simultaneously, so depending whether the panes are frozen or unfrozen, these settings may not be used or saved.
Dependencies
-
frozenColumns
- .frozenColumns( );
- Return Type:
- number
- Return Type Description:
- The number of columns frozen at the left of the worksheet.
Gets the number of columns frozen at the left of the worksheet.
Exceptions
Exception Description ig.ArgumentOutOfRangeException The assigned value is not a valid column count (0 to Workbook.maxExcelColumnCount or Workbook.maxExcel2007ColumnCount, depending on the workbook's Workbook.currentFormat). Remarks
The frozen columns will always remain in view, regardless of the horizontal scroll position of the worksheet.
Note: If the number of frozen columns specified is more than the amount of visible columns in the worksheet, the worksheet may not scroll correctly.
-
frozenColumns
- .frozenColumns( value:number );
- Return Type:
- number
- Return Type Description:
- The number of columns frozen at the left of the worksheet.
Sets the number of columns frozen at the left of the worksheet.
- value
- Type:number
Exceptions
Exception Description ig.ArgumentOutOfRangeException The assigned value is not a valid column count (0 to Workbook.maxExcelColumnCount or Workbook.maxExcel2007ColumnCount, depending on the workbook's Workbook.currentFormat). Remarks
The frozen columns will always remain in view, regardless of the horizontal scroll position of the worksheet.
Note: If the number of frozen columns specified is more than the amount of visible columns in the worksheet, the worksheet may not scroll correctly.
-
frozenRows
- .frozenRows( );
- Return Type:
- number
- Return Type Description:
- The number of rows frozen at the top of the worksheet.
Gets the number of rows frozen at the top of the worksheet.
Exceptions
Exception Description ig.ArgumentOutOfRangeException The assigned value is not a valid row count (0 to Workbook.maxExcelRowCount or Workbook.maxExcel2007RowCount, depending on the workbook's Workbook.currentFormat). Remarks
The frozen rows will always remain in view, regardless of the vertical scroll position of the worksheet.
Note: If the number of frozen rows specified is more than the amount of visible rows in the worksheet, the worksheet may not scroll correctly.
-
frozenRows
- .frozenRows( value:number );
- Return Type:
- number
- Return Type Description:
- The number of rows frozen at the top of the worksheet.
Sets the number of rows frozen at the top of the worksheet.
- value
- Type:number
Exceptions
Exception Description ig.ArgumentOutOfRangeException The assigned value is not a valid row count (0 to Workbook.maxExcelRowCount or Workbook.maxExcel2007RowCount, depending on the workbook's Workbook.currentFormat). Remarks
The frozen rows will always remain in view, regardless of the vertical scroll position of the worksheet.
Note: If the number of frozen rows specified is more than the amount of visible rows in the worksheet, the worksheet may not scroll correctly.
-
resetCore
- .resetCore( );
Resets the frozen pane settings to their defaults.
Remarks
The defaults used for each setting are the same defaults with which Microsoft Excel creates a blank worksheet.