Documentation

TrendLine extends Properties

in package

• Application

Created by PhpStorm.

Table of Contents

Constants

ANGLE_MULTIPLIER  = 60000

AXIS_LABELS_HIGH  = 'high'

AXIS_LABELS_LOW  = 'low'

AXIS_LABELS_NEXT_TO  = 'nextTo'

AXIS_LABELS_NONE  = 'none'

FORMAT_CODE_ACCOUNTING  = '_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)'

FORMAT_CODE_CURRENCY  = '$#,##0.00'

FORMAT_CODE_DATE  = 'm/d/yyyy'

FORMAT_CODE_DATE_ISO8601  = 'yyyy-mm-dd'

FORMAT_CODE_FRACTION  = '# ?/?'

FORMAT_CODE_GENERAL  = 'General'

FORMAT_CODE_NUMBER  = '#,##0.00'

FORMAT_CODE_PERCENTAGE  = '0.00%'

FORMAT_CODE_SCIENTIFIC  = '0.00E+00'

FORMAT_CODE_SPECIAL  = '00000'

FORMAT_CODE_TEXT  = '@'

FORMAT_CODE_TIME  = '[$-F400]h:mm:ss AM/PM'

HORIZONTAL_CROSSES_AUTOZERO  = 'autoZero'

HORIZONTAL_CROSSES_MAXIMUM  = 'max'

LINE_STYLE_ARROW_SIZE_1  = 1

LINE_STYLE_ARROW_SIZE_2  = 2

LINE_STYLE_ARROW_SIZE_3  = 3

LINE_STYLE_ARROW_SIZE_4  = 4

LINE_STYLE_ARROW_SIZE_5  = 5

LINE_STYLE_ARROW_SIZE_6  = 6

LINE_STYLE_ARROW_SIZE_7  = 7

LINE_STYLE_ARROW_SIZE_8  = 8

LINE_STYLE_ARROW_SIZE_9  = 9

LINE_STYLE_ARROW_TYPE_ARROW  = 'triangle'

LINE_STYLE_ARROW_TYPE_DIAMOND  = 'diamond'

LINE_STYLE_ARROW_TYPE_NOARROW  = null

LINE_STYLE_ARROW_TYPE_OPEN  = 'arrow'

LINE_STYLE_ARROW_TYPE_OVAL  = 'oval'

LINE_STYLE_ARROW_TYPE_STEALTH  = 'stealth'

LINE_STYLE_CAP_FLAT  = 'flat'

LINE_STYLE_CAP_ROUND  = 'rnd'

LINE_STYLE_CAP_SQUARE  = 'sq'

LINE_STYLE_COMPOUND_DOUBLE  = 'dbl'

LINE_STYLE_COMPOUND_SIMPLE  = 'sng'

LINE_STYLE_COMPOUND_THICKTHIN  = 'thickThin'

LINE_STYLE_COMPOUND_THINTHICK  = 'thinThick'

LINE_STYLE_COMPOUND_TRIPLE  = 'tri'

LINE_STYLE_DASH_DASH_DOT  = 'dashDot'

LINE_STYLE_DASH_LONG_DASH  = 'lgDash'

LINE_STYLE_DASH_LONG_DASH_DOT  = 'lgDashDot'

LINE_STYLE_DASH_LONG_DASH_DOT_DOT  = 'lgDashDotDot'

LINE_STYLE_DASH_ROUND_DOT  = 'sysDot'

LINE_STYLE_DASH_SOLID  = 'solid'

LINE_STYLE_DASH_SQUARE_DOT  = 'sysDash'

LINE_STYLE_JOIN_BEVEL  = 'bevel'

LINE_STYLE_JOIN_MITER  = 'miter'

LINE_STYLE_JOIN_ROUND  = 'round'

LINE_STYPE_DASH_DASH  = 'dash'

ORIENTATION_NORMAL  = 'minMax'

ORIENTATION_REVERSED  = 'maxMin'

PERCENTAGE_MULTIPLIER  = 100000

POINTS_WIDTH_MULTIPLIER  = 12700

SHADOW_PRESETS_INNER_BOTTOM  = 11

SHADOW_PRESETS_INNER_BOTTOM_LEFT  = 12

SHADOW_PRESETS_INNER_BOTTTOM_RIGHT  = 10

SHADOW_PRESETS_INNER_CENTER  = 14

SHADOW_PRESETS_INNER_LEFT  = 15

SHADOW_PRESETS_INNER_RIGHT  = 13

SHADOW_PRESETS_INNER_TOP  = 17

SHADOW_PRESETS_INNER_TOP_LEFT  = 18

SHADOW_PRESETS_INNER_TOP_RIGHT  = 16

SHADOW_PRESETS_NOSHADOW  = null

SHADOW_PRESETS_OUTER_BOTTOM  = 2

SHADOW_PRESETS_OUTER_BOTTOM_LEFT  = 3

SHADOW_PRESETS_OUTER_BOTTTOM_RIGHT  = 1

SHADOW_PRESETS_OUTER_CENTER  = 5

SHADOW_PRESETS_OUTER_LEFT  = 6

SHADOW_PRESETS_OUTER_RIGHT  = 4

SHADOW_PRESETS_OUTER_TOP  = 8

SHADOW_PRESETS_OUTER_TOP_LEFT  = 9

SHADOW_PRESETS_OUTER_TOP_RIGHT  = 7

SHADOW_PRESETS_PERSPECTIVE_BELOW  = 19

SHADOW_PRESETS_PERSPECTIVE_LOWER_LEFT  = 23

SHADOW_PRESETS_PERSPECTIVE_LOWER_RIGHT  = 22

SHADOW_PRESETS_PERSPECTIVE_UPPER_LEFT  = 21

SHADOW_PRESETS_PERSPECTIVE_UPPER_RIGHT  = 20

TICK_MARK_CROSS  = 'cross'

TICK_MARK_INSIDE  = 'in'

TICK_MARK_NONE  = 'none'

TICK_MARK_OUTSIDE  = 'out'

TRENDLINE_EXPONENTIAL  = 'exp'

TRENDLINE_LINEAR  = 'linear'

TRENDLINE_LOGARITHMIC  = 'log'

TRENDLINE_MOVING_AVG  = 'movingAvg'

TRENDLINE_POLYNOMIAL  = 'poly'

TRENDLINE_POWER  = 'power'

TRENDLINE_TYPES  = [self::TRENDLINE_EXPONENTIAL, self::TRENDLINE_LINEAR, self::TRENDLINE_LOGARITHMIC, self::TRENDLINE_POLYNOMIAL, self::TRENDLINE_POWER, self::TRENDLINE_MOVING_AVG]

ARROW_SIZES  = [1 => ['w' => 'sm', 'len' => 'sm'], 2 => ['w' => 'sm', 'len' => 'med'], 3 => ['w' => 'sm', 'len' => 'lg'], 4 => ['w' => 'med', 'len' => 'sm'], 5 => ['w' => 'med', 'len' => 'med'], 6 => ['w' => 'med', 'len' => 'lg'], 7 => ['w' => 'lg', 'len' => 'sm'], 8 => ['w' => 'lg', 'len' => 'med'], 9 => ['w' => 'lg', 'len' => 'lg']]

PRESETS_OPTIONS  = [ //NONE 0 => [ 'presets' => self::SHADOW_PRESETS_NOSHADOW, 'effect' => null, //'color' => [ // 'type' => ChartColor::EXCEL_COLOR_TYPE_STANDARD, // 'value' => 'black', // 'alpha' => 40, //], 'size' => ['sx' => null, 'sy' => null, 'kx' => null, 'ky' => null], 'blur' => null, 'direction' => null, 'distance' => null, 'algn' => null, 'rotWithShape' => null, ], //OUTER 1 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 2700000 / self::ANGLE_MULTIPLIER, 'algn' => 'tl', 'rotWithShape' => '0'], 2 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 5400000 / self::ANGLE_MULTIPLIER, 'algn' => 't', 'rotWithShape' => '0'], 3 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 8100000 / self::ANGLE_MULTIPLIER, 'algn' => 'tr', 'rotWithShape' => '0'], 4 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'algn' => 'l', 'rotWithShape' => '0'], 5 => ['effect' => 'outerShdw', 'size' => ['sx' => 102000 / self::PERCENTAGE_MULTIPLIER, 'sy' => 102000 / self::PERCENTAGE_MULTIPLIER], 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'algn' => 'ctr', 'rotWithShape' => '0'], 6 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 10800000 / self::ANGLE_MULTIPLIER, 'algn' => 'r', 'rotWithShape' => '0'], 7 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 18900000 / self::ANGLE_MULTIPLIER, 'algn' => 'bl', 'rotWithShape' => '0'], 8 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 16200000 / self::ANGLE_MULTIPLIER, 'rotWithShape' => '0'], 9 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 13500000 / self::ANGLE_MULTIPLIER, 'algn' => 'br', 'rotWithShape' => '0'], //INNER 10 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 2700000 / self::ANGLE_MULTIPLIER], 11 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 5400000 / self::ANGLE_MULTIPLIER], 12 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 8100000 / self::ANGLE_MULTIPLIER], 13 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER], 14 => ['effect' => 'innerShdw', 'blur' => 114300 / self::POINTS_WIDTH_MULTIPLIER], 15 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 10800000 / self::ANGLE_MULTIPLIER], 16 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 18900000 / self::ANGLE_MULTIPLIER], 17 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 16200000 / self::ANGLE_MULTIPLIER], 18 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 13500000 / self::ANGLE_MULTIPLIER], //perspective 19 => ['effect' => 'outerShdw', 'blur' => 152400 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 317500 / self::POINTS_WIDTH_MULTIPLIER, 'size' => ['sx' => 90000 / self::PERCENTAGE_MULTIPLIER, 'sy' => -19000 / self::PERCENTAGE_MULTIPLIER], 'direction' => 5400000 / self::ANGLE_MULTIPLIER, 'rotWithShape' => '0'], 20 => ['effect' => 'outerShdw', 'blur' => 76200 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 18900000 / self::ANGLE_MULTIPLIER, 'size' => ['sy' => 23000 / self::PERCENTAGE_MULTIPLIER, 'kx' => -1200000 / self::ANGLE_MULTIPLIER], 'algn' => 'bl', 'rotWithShape' => '0'], 21 => ['effect' => 'outerShdw', 'blur' => 76200 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 13500000 / self::ANGLE_MULTIPLIER, 'size' => ['sy' => 23000 / self::PERCENTAGE_MULTIPLIER, 'kx' => 1200000 / self::ANGLE_MULTIPLIER], 'algn' => 'br', 'rotWithShape' => '0'], 22 => ['effect' => 'outerShdw', 'blur' => 76200 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 12700 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 2700000 / self::ANGLE_MULTIPLIER, 'size' => ['sy' => -23000 / self::PERCENTAGE_MULTIPLIER, 'kx' => -800400 / self::ANGLE_MULTIPLIER], 'algn' => 'bl', 'rotWithShape' => '0'], 23 => ['effect' => 'outerShdw', 'blur' => 76200 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 12700 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 8100000 / self::ANGLE_MULTIPLIER, 'size' => ['sy' => -23000 / self::PERCENTAGE_MULTIPLIER, 'kx' => 800400 / self::ANGLE_MULTIPLIER], 'algn' => 'br', 'rotWithShape' => '0'], ]

SHADOW_ARRAY_KEYS  = ['size', 'color']

Properties

$glowColor  : ChartColor

$glowSize  : float|null

$lineColor  : ChartColor

$lineStyleProperties  : array<string|int, mixed>

$objectState  : bool

$shadowColor  : ChartColor

$shadowProperties  : array<string|int, mixed>

$softEdges  : array<string|int, mixed>

$backward  : float

$dispEq  : bool

$dispRSqr  : bool

$forward  : float

$intercept  : float

$name  : string

$order  : int

$period  : int

$trendLineType  : string

Methods

__clone()  : mixed

Implement PHP __clone to create a deep clone, not just a shallow copy.

__construct()  : mixed

Create a new TrendLine object.

activateObject()  : $this

Change Object State to True.

angleToXml()  : string

copyLineStyles()  : void

getBackward()  : float

getDispEq()  : bool

getDispRSqr()  : bool

getForward()  : float

getGlowColor()  : null|int|string

Get Glow Color Property.

getGlowColorObject()  : ChartColor

getGlowProperty()  : null|array<string|int, mixed>|float|int|string

Get Glow Property.

getGlowSize()  : float|null

Get Glow Size.

getIntercept()  : float

getLineColor()  : ChartColor

getLineColorProperty()  : null|int|string

Get Line Color Property.

getLineStyleArray()  : array<string|int, mixed>

getLineStyleArrowLength()  : string|null

Get Line Style Arrow Excel Length.

getLineStyleArrowParameters()  : string

Get Line Style Arrow Parameters.

getLineStyleArrowWidth()  : string|null

Get Line Style Arrow Width.

getLineStyleProperty()  : string|null

Get Line Style Property.

getName()  : string

getObjectState()  : bool

Get Object State.

getOrder()  : int

getPeriod()  : int

getShadowArray()  : array<string|int, mixed>

getShadowColorObject()  : ChartColor

getShadowProperty()  : array<string|int, mixed>|string|null

Get Shadow Property.

getSoftEdgesSize()  : float|null

Get Soft Edges Size.

getTrendLineType()  : string

pointsToXml()  : string

setBackward()  : self

setDispEq()  : self

setDispRSqr()  : self

setForward()  : self

setGlowProperties()  : void

Set Glow Properties.

setIntercept()  : self

setLineColorProperties()  : void

Set Line Color Properties.

setLineStyleArray()  : self

setLineStyleProperties()  : void

Set Line Style Properties.

setLineStyleProperty()  : self

setName()  : self

setOrder()  : self

setPeriod()  : self

setShadowProperties()  : void

Set Shadow Properties.

setShadowProperty()  : self

setSoftEdges()  : void

Set Soft Edges Size.

setTrendLineProperties()  : self

setTrendLineType()  : self

tenthOfPercentToXml()  : string

xmlToAngle()  : float

xmlToPoints()  : float

xmlToTenthOfPercent()  : float

getArrayElementsValue()  : mixed

Get value of array element.

getLineStyleArrowSize()  : string

Get Line Style Arrow Size.

getShadowPresetsMap()  : array<string|int, mixed>

setColorProperties()  : array<string|int, mixed>

setGlowSize()  : $this

Set Glow Size.

setShadowAngle()  : $this

Set Shadow Angle.

setShadowBlur()  : $this

Set Shadow Blur.

setShadowDistance()  : $this

Set Shadow Distance.

setShadowPresetsProperties()  : $this

Set Shadow Presets Properties.

setShadowPropertiesMapValues()  : $this

Set Shadow Properties Values.