See Also

IWorksheetWindowInfo Interface  | SpreadsheetGear Namespace  | WindowInfo Property  | IWorkbookWindowInfo Interface

See Also SpreadsheetGear The Performance Spreadsheet Component Company 

IWorksheetWindowInfo Interface Members

SpreadsheetGear Namespace : IWorksheetWindowInfo Interface

IWorksheetWindowInfo overview

Public Properties

 Property ActiveCell Returns an instance of IRange representing the active cell.
 Property ActiveCellAreaIndex Returns the index of the area of the active cell.
 Property ActivePane Returns the active pane.
 Property DisplayFormulas Gets or sets the property which specifies whether formulas are displayed in worksheet cells instead of values.
 Property DisplayGridlines Gets or sets the property which specifies whether gridlines are displayed for the worksheet.
 Property DisplayHeadings Gets or sets the property which specifies whether row and column headings are displayed for the worksheet.
 Property DisplayOutline Gets or sets the property which specifies whether outlines are displayed for the worksheet.
 Property DisplayRightToLeft Returns true if the worksheet is displayed right to left.
 Property DisplayZeros Gets or sets the property which specifies whether zero values are displayed for the worksheet.
 Property FreezePanes Gets or sets the property which specifies whether window panes are frozen for the worksheet.
 Property GridlineColor Gets or sets the color to use for gridlines.
 Property GridlineColorIndex Gets or sets the index of the color to use for gridlines.
 Property Panes Returns the collection of window panes associated with the worksheet.
 Property RangeSelection Gets or sets the range selection associated with this IWorksheetWindowInfo.
 Property ScrollColumn Gets or sets the left column displayed in the window.
 Property ScrollRow Gets or sets the top row displayed in the window.
 Property ShapeSelection Gets or sets the shape selection associated with this IWorksheetWindowInfo.
 Property SplitColumns Gets or sets the number of columns displayed to the left of the split.
 Property SplitHorizontal Gets or sets the position of the horizontal split in points.
 Property SplitRows Gets or sets the number of rows displayed above the split.
 Property SplitVertical Gets or sets the position of the vertical split in points.
 Property View Gets or sets whether the worksheet is viewed normally or in page break preview mode.
 Property Worksheet Gets the worksheet which this window information refers to.
 Property Zoom Gets or sets the scaling factor for displaying in a window.

Public Methods

 Method ColumnToPoints Converts from a zero based fractional column position to points (1/72 of an inch).
 Method PointsToColumn Converts from points (1/72 of an inch) to a zero based fractional column position.
 Method PointsToRow Converts from points (1/72 of an inch) to a zero based fractional row position.
 Method RowToPoints Converts from a zero based fractional row position to points (1/72 of an inch).
 Method SetSelection Overloaded.  

See Also

IWorksheetWindowInfo Interface  | SpreadsheetGear Namespace  | WindowInfo Property  | IWorkbookWindowInfo Interface

 

 


See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.