ig.excel.WorksheetDisplayOptions

Class which exposes the display options which can only be controlled through the worksheet.

Dependencies

jquery-1.4.4.js
infragistics.util.js
infragistics.ext_core.js
infragistics.ext_collections.js
infragistics.ext_collectionsExtended.js
infragistics.ext_io.js
infragistics.ext_text.js
infragistics.documents.core_core.js
infragistics.ext_ui.js
The current widget has no options.
The current widget has no events.
  • clearSelection
    Inherited

    .clearSelection( );

    Removes any saved selection information.

  • frozenPaneSettings
    Inherited

    .frozenPaneSettings( );
    Return Type:
    ig.excel.FrozenPaneSettings
    Return Type Description:
    The settings which control the frozen panes in the worksheet..

    Gets the settings which control the frozen panes in the worksheet.

    Remarks

    For these settings to be saved in the workbook file, DisplayOptions.panesAreFrozen must be True.

    Note: Frozen and unfrozen panes cannot be used simultaneously, so depending on whether the panes are frozen or unfrozen, these settings may not be used.

  • gridlineColor
    Inherited

    .gridlineColor( );
    Return Type:
    string
    Return Type Description:
    The color of the gridlines on the worksheet.

    Gets the color of the gridlines on the worksheet.

    Exceptions

    Exception Description
    ig.InvalidOperationException The workbook is using a custom palette and setting this color would cause the custom palette to use too many colors.

    Remarks

    If the workbook is using a standard palette, the color set may be changed if it is not in the palette. In this case, the closest color in the standard palette will be used.

  • gridlineColor
    Inherited

    .gridlineColor( value:string );
    Return Type:
    string
    Return Type Description:
    The color of the gridlines on the worksheet.

    Sets the color of the gridlines on the worksheet.

    • value
    • Type:string

    Exceptions

    Exception Description
    ig.InvalidOperationException The workbook is using a custom palette and setting this color would cause the custom palette to use too many colors.

    Remarks

    If the workbook is using a standard palette, the color set may be changed if it is not in the palette. In this case, the closest color in the standard palette will be used.

  • magnificationInNormalView

    .magnificationInNormalView( );
    Return Type:
    number
    Return Type Description:
    The magnification level of the worksheet when it is displayed in normal view.

    Gets the magnification level of the worksheet when it is displayed in normal view.

    Exceptions

    Exception Description
    ig.ArgumentOutOfRangeException The assigned value is outside the valid range of magnification levels for a worksheet. The level must be between 10 and 400.

    Remarks

    Magnifications are stored as percentages of the normal viewing magnification. A value of 100 indicates normal magnification whereas a value of 200 indicates a zoom that is twice the normal viewing magnification.

  • magnificationInNormalView

    .magnificationInNormalView( value:number );
    Return Type:
    number
    Return Type Description:
    The magnification level of the worksheet when it is displayed in normal view.

    Sets the magnification level of the worksheet when it is displayed in normal view.

    • value
    • Type:number

    Exceptions

    Exception Description
    ig.ArgumentOutOfRangeException The assigned value is outside the valid range of magnification levels for a worksheet. The level must be between 10 and 400.

    Remarks

    Magnifications are stored as percentages of the normal viewing magnification. A value of 100 indicates normal magnification whereas a value of 200 indicates a zoom that is twice the normal viewing magnification.

  • magnificationInPageBreakView

    .magnificationInPageBreakView( );
    Return Type:
    number
    Return Type Description:
    The magnification level of the worksheet when it is displayed in the page break preview.

    Gets the magnification level of the worksheet when it is displayed in the page break preview.

    Exceptions

    Exception Description
    ig.ArgumentOutOfRangeException The assigned value is outside the valid range of magnification levels for a worksheet. The level must be between 10 and 400.

    Remarks

    Magnifications are stored as percentages of the normal viewing magnification. A value of 100 indicates normal magnification whereas a value of 200 indicates a zoom that is twice the normal viewing magnification.

  • magnificationInPageBreakView

    .magnificationInPageBreakView( value:number );
    Return Type:
    number
    Return Type Description:
    The magnification level of the worksheet when it is displayed in the page break preview.

    Sets the magnification level of the worksheet when it is displayed in the page break preview.

    • value
    • Type:number

    Exceptions

    Exception Description
    ig.ArgumentOutOfRangeException The assigned value is outside the valid range of magnification levels for a worksheet. The level must be between 10 and 400.

    Remarks

    Magnifications are stored as percentages of the normal viewing magnification. A value of 100 indicates normal magnification whereas a value of 200 indicates a zoom that is twice the normal viewing magnification.

  • magnificationInPageLayoutView

    .magnificationInPageLayoutView( );
    Return Type:
    number
    Return Type Description:
    The magnification level of the worksheet when it is displayed in page layout view.

    Gets the magnification level of the worksheet when it is displayed in page layout view.

    Exceptions

    Exception Description
    ig.ArgumentOutOfRangeException The assigned value is outside the valid range of magnification levels for a worksheet. The level must be between 10 and 400.

    Remarks

    Magnifications are stored as percentages of the normal viewing magnification. A value of 100 indicates normal magnification whereas a value of 200 indicates a zoom that is twice the normal viewing magnification.

  • magnificationInPageLayoutView

    .magnificationInPageLayoutView( value:number );
    Return Type:
    number
    Return Type Description:
    The magnification level of the worksheet when it is displayed in page layout view.

    Sets the magnification level of the worksheet when it is displayed in page layout view.

    • value
    • Type:number

    Exceptions

    Exception Description
    ig.ArgumentOutOfRangeException The assigned value is outside the valid range of magnification levels for a worksheet. The level must be between 10 and 400.

    Remarks

    Magnifications are stored as percentages of the normal viewing magnification. A value of 100 indicates normal magnification whereas a value of 200 indicates a zoom that is twice the normal viewing magnification.

  • orderColumnsRightToLeft

    .orderColumnsRightToLeft( );
    Return Type:
    boolean
    Return Type Description:
    The value indicating whether the columns are ordered right to left.

    Gets the value indicating whether the columns are ordered right to left.

    Remarks

    If the columns are ordered right to left, other aspects of the worksheet display differently. The vertical scrollbar will display on the left side of the worksheet and the worksheet tab bar, usually displayed on the left side of the worksheet, will display on the right side.

  • orderColumnsRightToLeft

    .orderColumnsRightToLeft( value:boolean );
    Return Type:
    boolean
    Return Type Description:
    The value indicating whether the columns are ordered right to left.

    Sets the value indicating whether the columns are ordered right to left.

    • value
    • Type:boolean

    Remarks

    If the columns are ordered right to left, other aspects of the worksheet display differently. The vertical scrollbar will display on the left side of the worksheet and the worksheet tab bar, usually displayed on the left side of the worksheet, will display on the right side.

  • panesAreFrozen
    Inherited

    .panesAreFrozen( );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates if the panes in the worksheet are frozen.

    Gets the value which indicates if the panes in the worksheet are frozen.

    Remarks

    Depending on the value of this property, either the DisplayOptions.frozenPaneSettings or the DisplayOptions.unfrozenPaneSettings will be used for the worksheet. The unused settings are ignored and are not saved with the workbook stream.

  • panesAreFrozen
    Inherited

    .panesAreFrozen( value:boolean );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates if the panes in the worksheet are frozen.

    Sets the value which indicates if the panes in the worksheet are frozen.

    • value
    • Type:boolean

    Remarks

    Depending on the value of this property, either the DisplayOptions.frozenPaneSettings or the DisplayOptions.unfrozenPaneSettings will be used for the worksheet. The unused settings are ignored and are not saved with the workbook stream.

  • reset
    Inherited

    .reset( );

    Resets the display options to their default settings.

    Remarks

    The defaults used for each setting are the same defaults with which Microsoft Excel creates a blank sheet.

  • resetCore

    .resetCore( );

    Resets the display options to their default settings.

    Remarks

    The defaults used for each setting are the same defaults with which Microsoft Excel creates a blank worksheet.

  • showExpansionIndicatorBelowGroupedRows
    Inherited

    .showExpansionIndicatorBelowGroupedRows( );

    Gets the value which indicates whether the expansion indicators should be shown below grouped, or indented rows.

  • showExpansionIndicatorBelowGroupedRows
    Inherited

    .showExpansionIndicatorBelowGroupedRows( value:boolean );

    Sets the value which indicates whether the expansion indicators should be shown below grouped, or indented rows.

    • value
    • Type:boolean
  • showExpansionIndicatorToRightOfGroupedColumns
    Inherited

    .showExpansionIndicatorToRightOfGroupedColumns( );

    Gets the value which indicates whether the expansion indicators should be shown to the right of grouped, or indented rows.

  • showExpansionIndicatorToRightOfGroupedColumns
    Inherited

    .showExpansionIndicatorToRightOfGroupedColumns( value:boolean );

    Sets the value which indicates whether the expansion indicators should be shown to the right of grouped, or indented rows.

    • value
    • Type:boolean
  • showFormulasInCells
    Inherited

    .showFormulasInCells( );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether formulas are shown in cells.

    Gets the value which indicates whether formulas are shown in cells.

    Remarks

    If this value is True, the formula string will be displayed in the cell. If the value is False, the result of the formula will be displayed in the cell.

  • showFormulasInCells
    Inherited

    .showFormulasInCells( value:boolean );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether formulas are shown in cells.

    Sets the value which indicates whether formulas are shown in cells.

    • value
    • Type:boolean

    Remarks

    If this value is True, the formula string will be displayed in the cell. If the value is False, the result of the formula will be displayed in the cell.

  • showGridlines
    Inherited

    .showGridlines( );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether gridlines are shown between cells.

    Gets the value which indicates whether gridlines are shown between cells.

  • showGridlines
    Inherited

    .showGridlines( value:boolean );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether gridlines are shown between cells.

    Sets the value which indicates whether gridlines are shown between cells.

    • value
    • Type:boolean
  • showOutlineSymbols
    Inherited

    .showOutlineSymbols( );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether outline symbols are shown for outlined columns and rows.

    Gets the value which indicates whether outline symbols are shown for outlined columns and rows.

    Remarks

    If the outline symbols are displayed, they provide a visual representation of the outline levels or rows and columns in Microsoft Excel. In addition, the outline symbols include the expansion indicators which allow for the expanding and collapsing of outline groups.

  • showOutlineSymbols
    Inherited

    .showOutlineSymbols( value:boolean );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether outline symbols are shown for outlined columns and rows.

    Sets the value which indicates whether outline symbols are shown for outlined columns and rows.

    • value
    • Type:boolean

    Remarks

    If the outline symbols are displayed, they provide a visual representation of the outline levels or rows and columns in Microsoft Excel. In addition, the outline symbols include the expansion indicators which allow for the expanding and collapsing of outline groups.

  • showRowAndColumnHeaders
    Inherited

    .showRowAndColumnHeaders( );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether to display row and column headers.

    Gets the value which indicates whether to display row and column headers.

    Remarks

    The row and column headers show the identifier of the row or column. They also allow the user to easily select all cells in a row or column by clicking them.

  • showRowAndColumnHeaders
    Inherited

    .showRowAndColumnHeaders( value:boolean );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether to display row and column headers.

    Sets the value which indicates whether to display row and column headers.

    • value
    • Type:boolean

    Remarks

    The row and column headers show the identifier of the row or column. They also allow the user to easily select all cells in a row or column by clicking them.

  • showRulerInPageLayoutView
    Inherited

    .showRulerInPageLayoutView( );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether to show rulers in the page layout view.

    Gets the value which indicates whether to show rulers in the page layout view.

    Remarks

    When this value is True, one ruler will display above the column headers of the active page in page layout view. Another ruler will also display before the row headers of the active page.

    Note: This property will only affect the worksheet view if the DisplayOptions.view is PageLayout.

    Note: The WorksheetView value of PageLayout is only supported in Excel 2007. If a worksheet with that View is viewed in earlier versions of Microsoft Excel, the view will default to Normal view.

  • showRulerInPageLayoutView
    Inherited

    .showRulerInPageLayoutView( value:boolean );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether to show rulers in the page layout view.

    Sets the value which indicates whether to show rulers in the page layout view.

    • value
    • Type:boolean

    Remarks

    When this value is True, one ruler will display above the column headers of the active page in page layout view. Another ruler will also display before the row headers of the active page.

    Note: This property will only affect the worksheet view if the DisplayOptions.view is PageLayout.

    Note: The WorksheetView value of PageLayout is only supported in Excel 2007. If a worksheet with that View is viewed in earlier versions of Microsoft Excel, the view will default to Normal view.

  • showWhitespaceInPageLayoutView

    .showWhitespaceInPageLayoutView( );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether to show white page between worksheet pages in page layout view.

    Gets the value which indicates whether to show whitespace between worksheet pages in page layout view.

    Remarks

    Note: For this value to affect the display of the worksheet, the DisplayOptions.view must be set to PageLayout. However, if a different view is used, this is still saved with the workbook.

    Note: The WorksheetView value of PageLayout is only supported in Excel 2007. If a worksheet with that View is viewed in earlier versions of Microsoft Excel, the view will default to Normal view.

  • showWhitespaceInPageLayoutView

    .showWhitespaceInPageLayoutView( value:boolean );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether to show white page between worksheet pages in page layout view.

    Sets the value which indicates whether to show whitespace between worksheet pages in page layout view.

    • value
    • Type:boolean

    Remarks

    Note: For this value to affect the display of the worksheet, the DisplayOptions.view must be set to PageLayout. However, if a different view is used, this is still saved with the workbook.

    Note: The WorksheetView value of PageLayout is only supported in Excel 2007. If a worksheet with that View is viewed in earlier versions of Microsoft Excel, the view will default to Normal view.

  • showZeroValues
    Inherited

    .showZeroValues( );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether zero values are shown in cells.

    Gets the value which indicates whether zero values are shown in cells.

    Remarks

    If this value is True, cells with a value of zero will display their values; otherwise, those cells will display as blanks.

  • showZeroValues
    Inherited

    .showZeroValues( value:boolean );
    Return Type:
    boolean
    Return Type Description:
    The value which indicates whether zero values are shown in cells.

    Sets the value which indicates whether zero values are shown in cells.

    • value
    • Type:boolean

    Remarks

    If this value is True, cells with a value of zero will display their values; otherwise, those cells will display as blanks.

  • tabColorInfo

    .tabColorInfo( );
    Return Type:
    ig.excel.WorkbookColorInfo
    Return Type Description:
    The WorkbookColorInfo to use for the associated worksheet's tab in the tab bar of Microsoft Excel.

    Gets the WorkbookColorInfo to use for the associated worksheet's tab in the tab bar of Microsoft Excel.

    Remarks

    If the tab bar is not visible, this color will not be seen.

  • tabColorInfo

    .tabColorInfo( value:ig.excel.WorkbookColorInfo );
    Return Type:
    ig.excel.WorkbookColorInfo
    Return Type Description:
    The WorkbookColorInfo to use for the associated worksheet's tab in the tab bar of Microsoft Excel.

    Sets the WorkbookColorInfo to use for the associated worksheet's tab in the tab bar of Microsoft Excel.

    • value
    • Type:ig.excel.WorkbookColorInfo

    Remarks

    If the tab bar is not visible, this color will not be seen.

  • unfrozenPaneSettings
    Inherited

    .unfrozenPaneSettings( );
    Return Type:
    ig.excel.UnfrozenPaneSettings
    Return Type Description:
    The settings which control the unfrozen panes in the worksheet.

    Gets the settings which control the unfrozen panes in the worksheet.

    Remarks

    For these settings to be saved in the workbook file, DisplayOptions.panesAreFrozen must be False.

    Note: Frozen and unfrozen panes cannot be used simultaneously, so depending on whether the panes are frozen or unfrozen, these settings may not be used.

  • view
    Inherited

    .view( );
    Return Type:
    ig.excel.WorksheetView
    Return Type Description:
    The current view of the worksheet.

    Gets the current view of the worksheet.

    Exceptions

    Exception Description
    ig.excel.InvalidEnumArgumentException The value assigned is not defined in the WorksheetView enumeration.

    Remarks

    The view determines the overall display of the worksheet in Microsoft Excel.

    Note: The WorksheetView value of PageLayout is only supported in Excel 2007. If a worksheet with that View is viewed in earlier versions of Microsoft Excel, the view will default to Normal view.

  • view
    Inherited

    .view( value:ig.excel.WorksheetView );
    Return Type:
    ig.excel.WorksheetView
    Return Type Description:
    The current view of the worksheet.

    Sets the current view of the worksheet.

    • value
    • Type:ig.excel.WorksheetView

    Exceptions

    Exception Description
    ig.excel.InvalidEnumArgumentException The value assigned is not defined in the WorksheetView enumeration.

    Remarks

    The view determines the overall display of the worksheet in Microsoft Excel.

    Note: The WorksheetView value of PageLayout is only supported in Excel 2007. If a worksheet with that View is viewed in earlier versions of Microsoft Excel, the view will default to Normal view.

  • visibility
    Inherited

    .visibility( );
    Return Type:
    ig.excel.WorksheetVisibility
    Return Type Description:
    The visibility of the worksheet.

    Gets the visibility of the sheet.

    Exceptions

    Exception Description
    ig.excel.InvalidEnumArgumentException The value assigned is not defined in the WorksheetVisibility enumeration.

    Remarks

    The visibility determines whether the sheet's tab will appear in the tab bar at the bottom of Microsoft Excel.

  • visibility
    Inherited

    .visibility( value:ig.excel.WorksheetVisibility );
    Return Type:
    ig.excel.WorksheetVisibility
    Return Type Description:
    The visibility of the worksheet.

    Sets the visibility of the sheet.

    • value
    • Type:ig.excel.WorksheetVisibility

    Exceptions

    Exception Description
    ig.excel.InvalidEnumArgumentException The value assigned is not defined in the WorksheetVisibility enumeration.

    Remarks

    The visibility determines whether the sheet's tab will appear in the tab bar at the bottom of Microsoft Excel.

Copyright © 1996 - 2024 Infragistics, Inc. All rights reserved.