A collection of SparklineGroups exposed from a worksheet

Hierarchy

Hierarchy

  • Base
    • SparklineGroupCollection

Implements

Constructors

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • get count(): number
  • Returns the total number of items in the collection.

    Returns number

  • get generateGuidsForGroups(): boolean
  • Determines if guids will be generated for groups. Note: if any group has a guid then all of them must also have guids. Therefore, when this property is set to true all groups in the collection, including groups that are subsequently added, will have guids generated for them. Also note that this property can not be set to false if the collection contains any group with a guid.

    Throws

    ArgumentException Can't set GenerateGuidsForGroups to false if the collection contains groups that already have guids generated.

    See

    SparklineGroup.guid

    Returns boolean

  • set generateGuidsForGroups(a: boolean): void
  • Parameters

    • a: boolean

    Returns void

Methods

  • Adds a new SparklineGroup

    Returns

    The added group

    Parameters

    • type: SparklineType

      The type of the group.

    • locationRange: string

      The aggregated location for the sparklines in the group.

    • dataRange: string

      The aggreagated data range for all the sparklines in the group.

    • Optional groupInitializer: ((arg1: SparklineGroup) => void)

      An optional callback for initializing the group before it is added to the collection.

    • Optional cellReferenceMode: CellReferenceMode

      An optional CellReferenceMode to use to parse the location and data ranges. If null it defaults to the workbook's mode.

    Returns SparklineGroup

  • Clears all items from the collection

    Returns void

  • Returns true if the collection contains the item

    Parameters

    Returns boolean

  • Parameters

    • other: any

    Returns boolean

  • Returns any

  • Returns any

  • Returns number

  • Gets the index of the item in the collection

    Returns

    The index or -1 if the item is not in the collection

    Parameters

    Returns number

  • Indexer

    Returns

    The item at the specified index

    Throws

    IndexOutOfRangeException If the index is negative or greater than or equal to count

    Parameters

    • a: number

    Returns SparklineGroup

  • Removes a group from the collection

    Returns

    true if successful, otherwise false

    Parameters

    Returns boolean

  • Removes a group from the collection

    Throws

    IndexOutOfRangeException if the index is less than 0 or not less than the count.

    Parameters

    • index: number

      The zero-based index of the group to remove.

    Returns void

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns boolean

  • Parameters

    • a: any
    • b: any

    Returns boolean

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns number

  • Parameters

    • a: any
    • b: any

    Returns boolean

  • Returns void