Class which exposes the chartsheet display options which can only be controlled through the custom view.

See

  • [[CustomView.getSheetDisplayOptions]]
  • [[ChartsheetDisplayOptions]]

Hierarchy

Hierarchy (view full)

Constructors

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • get magnification(): number
  • Gets or sets the magnification level of the chartsheet.

    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.

    The magnification level of the chartsheet in the current View.

    Throws

    [[ArgumentOutOfRangeException]] The assigned value is outside the valid range of magnification levels for a chartsheet. The level must be between 10 and 400.

    Returns number

  • set magnification(a): void
  • Parameters

    • a: number

    Returns void

  • get sizeWithWindow(): boolean
  • Gets or sets whether the chart should be resized to match the size of the chart sheet window.

    Returns boolean

  • set sizeWithWindow(a): void
  • Parameters

    • a: boolean

    Returns void

  • get visibility(): WorksheetVisibility
  • Gets or sets the visibility of the sheet.

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

    The visibility of the worksheet.

    Throws

    [[InvalidEnumArgumentException]] The value assigned is not defined in the [[WorksheetVisibility]] enumeration.

    Returns WorksheetVisibility

  • set visibility(a): void
  • Parameters

    Returns void

Methods

  • Parameters

    • other: any

    Returns boolean

  • Resets the display options to their default settings.

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

    Returns void

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns boolean