A collection of [[Trendline]] objects belonging to the same [[Series]].

Constructors

Section titled "Constructors"

TrendlineCollection 

new TrendlineCollection(a: IChartObject): TrendlineCollection

Returns TrendlineCollection

Properties

Section titled "Properties"

$t

Section titled "$t" 
$t: Type

Accessors

Section titled "Accessors"

chart

Section titled "chart"

Inherited from: ChartObject

Returns the owning chart (read-only)

 
get chart(): WorksheetChart

Returns WorksheetChart

count

Section titled "count"

Returns the number of items in the collection (read-only)

 
get count(): number

Returns number

isReadOnly

Section titled "isReadOnly"

Determines if the collecion can be modified (read-only)

 
get isReadOnly(): boolean

Returns boolean

owner

Section titled "owner"

Inherited from: ChartObject

returns this object's owner. (read-only) The owner or null if this object is owned directly by the Chart

 
get owner(): ChartObject

Returns ChartObject

sheet

Section titled "sheet"

Inherited from: ChartObject

The owning sheet (read-only)

 
get sheet(): Sheet

Returns Sheet

workbook

Section titled "workbook"

Inherited from: ChartObject

The owning workbook (read-only)

 
get workbook(): Workbook

Returns Workbook

worksheet

Section titled "worksheet"

Inherited from: ChartObject

The owning worksheet (read-only)

 
get worksheet(): Worksheet

Returns Worksheet

Methods

Section titled "Methods"

[iterator]

Section titled "[iterator]" 
[iterator](): EnumeratorWrapper<Trendline>

Returns EnumeratorWrapper<Trendline>

add

Section titled "add"

Adds a new [[Trendline]] to the collection

 
add(): Trendline

Returns Trendline

clear

Section titled "clear"

Clears the collection.

 
clear(): void

Returns void

contains

Section titled "contains"

Returns a boolean value indicating whether the specified instance is contained within this collection.

 
contains(item: Trendline): boolean

Parameters

Returns boolean

getEnumerator

Section titled "getEnumerator" 
getEnumerator(): any

Returns any

getEnumeratorObject

Section titled "getEnumeratorObject" 
getEnumeratorObject(): any

Returns any

indexOf

Section titled "indexOf"

Returns the index of the item in the collection.

 
indexOf(item: Trendline): number

Parameters

Returns number

insert

Section titled "insert"

Inserts a new [[Trendline]] into the collection at the specified index.

 
insert(index: number): Trendline

Parameters

  • index: number

    The index at which to insert the new trendline.

Returns Trendline

item

Section titled "item"

Returns the [[Trendline]] instance at the specified ordinal position within the collection.

 
item(a: number): Trendline

Parameters

  • a: number

Returns Trendline

remove

Section titled "remove"

Removes an item from the collection.

 
remove(item: Trendline): boolean

Parameters

  • item: Trendline

    The [[Trendline]] to remove

Returns boolean

removeAt

Section titled "removeAt"

Removes the series at the specified index

 
removeAt(index: number): void

Parameters

  • index: number

    The zero-based index

Returns void

staticInit

Section titled "staticInit" 
staticInit(): void

Returns void