ig.excel.PaneSettingsBase
Dependencies
-
firstColumnInRightPane
- .firstColumnInRightPane( );
- Return Type:
- number
- Return Type Description:
- The zero-based index of the first visible column in the right pane(s).
Gets the first visible column in the right pane(s) of the worksheet.
Exceptions
Exception Description ig.ArgumentOutOfRangeException The assigned value is outside the valid column range (0 to one less than Workbook.maxExcelColumnCount or Workbook.maxExcel2007ColumnCount, depending on the workbook's Workbook.currentFormat). Remarks
This affects the scroll position for the right pane(s) of the worksheet and is only used if the worksheet is split vertically.
-
firstColumnInRightPane
- .firstColumnInRightPane( value:number );
- Return Type:
- number
- Return Type Description:
- The zero-based index of the first visible column in the right pane(s).
Sets the first visible column in the right pane(s) of the worksheet.
- value
- Type:number
Exceptions
Exception Description ig.ArgumentOutOfRangeException The assigned value is outside the valid column range (0 to one less than Workbook.maxExcelColumnCount or Workbook.maxExcel2007ColumnCount, depending on the workbook's Workbook.currentFormat). Remarks
This affects the scroll position for the right pane(s) of the worksheet and is only used if the worksheet is split vertically.
-
firstRowInBottomPane
- .firstRowInBottomPane( );
- Return Type:
- number
- Return Type Description:
- The zero-based index of the first visible row in the bottom pane(s).
Gets the first visible row in the bottom pane(s) of the worksheet.
Exceptions
Exception Description ig.ArgumentOutOfRangeException The assigned value is outside the valid row range (0 to one less than Workbook.maxExcelRowCount or Workbook.maxExcel2007RowCount, depending on the workbook's Workbook.currentFormat). Remarks
This affects the scroll position for the bottom pane(s) of the worksheet and is only used if the worksheet is split horizontally.
-
firstRowInBottomPane
- .firstRowInBottomPane( value:number );
- Return Type:
- number
- Return Type Description:
- The zero-based index of the first visible row in the bottom pane(s).
Sets the first visible row in the bottom pane(s) of the worksheet.
- value
- Type:number
Exceptions
Exception Description ig.ArgumentOutOfRangeException The assigned value is outside the valid row range (0 to one less than Workbook.maxExcelRowCount or Workbook.maxExcel2007RowCount, depending on the workbook's Workbook.currentFormat). Remarks
This affects the scroll position for the bottom pane(s) of the worksheet and is only used if the worksheet is split horizontally.
-
reset
- .reset( );
Resets the pane settings to their defaults.
Remarks
The defaults used for each setting are the same defaults with which Microsoft Excel creates a blank worksheet.
-
resetCore
- .resetCore( );
Resets the pane settings to their defaults.
Remarks
The defaults used for each setting are the same defaults with which Microsoft Excel creates a blank worksheet.