IWorksheetView Interface Methods
In This Topic
For a list of all members of this type, see IWorksheetView members.
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). |
TopSee Also
