IWorksheetView Interface Members
In This Topic
The following tables list the members exposed by IWorksheetView.
Public Methods
| Name | Description |
 | getDisplayFormulas | Gets whether the worksheet displays formulas. True if formulas are displayed; False if the worksheet displays values. |
 | getDisplayGridlines | Gets whether gridlines are displayed. |
 | getDisplayHeadings | Gets whether headers are displayed (True if both row and column headings are displayed; False if there are no headings displayed). |
 | getDisplayHorizontalGridlines | Gets whether horizontal gridlines are displayed. |
 | getDisplayOutline | Gets whether outline symbols are displayed. |
 | getDisplayRightToLeft | Gets whether the specified worksheet is displayed from right to left instead of from left to right (False if the object is displayed from left to right). |
 | getDisplayRuler | Gets whether a ruler is displayed for the specified worksheet. |
 | getDisplayVerticalGridlines | Gets whether vertical gridlines are displayed. |
 | getDisplayWhitespace | Gets whether whitespace is displayed. |
 | getDisplayZeros | Gets whether zero values are displayed. |
 | getGridlineColor | Gets the Color object that represents the gridline color of the worksheet. |
 | getScrollColumn | Gets the number of the leftmost column in the pane or worksheet. |
 | getScrollRow | Gets the number of the row that appears at the top of the pane or worksheet. |
 | getViewType | Gets the view type. |
 | getZoom | Gets a Variant value that represents the display size of the worksheet, as a percentage(100 equals normal size, 200 equals double size, and so on). |
 | setDisplayFormulas | Sets whether the worksheet displays formulas. True if formulas are displayed; False if the worksheet displays values. |
 | setDisplayGridlines | Sets whether gridlines are displayed. When this is set, DisplayVerticalGridlines and DisplayHorizontalGridlines would be set to same value. |
 | setDisplayHeadings | Sets whether headers are displayed (True if both row and column headings are displayed; False if there are no headings displayed). |
 | setDisplayHorizontalGridlines | Sets whether horizontal gridlines are displayed. When this is set false, DisplayGridlines would be false, too. |
 | setDisplayOutline | Sets whether outline symbols are displayed. |
 | setDisplayRightToLeft | Sets whether the specified worksheet is displayed from right to left instead of from left to right (False if the object is displayed from left to right). |
 | setDisplayRuler | Sets whether a ruler is displayed for the specified worksheet. |
 | setDisplayVerticalGridlines | Sets whether vertical gridlines are displayed. When this is set false, DisplayGridlines would be false, too. |
 | setDisplayWhitespace | Sets whether whitespace is displayed. |
 | setDisplayZeros | Sets whether zero values are displayed. |
 | setGridlineColor | Sets the Color object that represents the gridline color of the worksheet. |
 | setScrollColumn | Sets the number of the leftmost column in the pane or worksheet. |
 | setScrollRow | Sets the number of the row that appears at the top of the pane or worksheet. |
 | setViewType | Sets the view type. |
 | setZoom | Sets a Variant value that represents the display size of the worksheet, as a percentage(100 equals normal size, 200 equals double size, and so on). |
Top
See Also