ScrollBarActiveXControl

ScrollBarActiveXControl class

Represents the ScrollBar control.

class ScrollBarActiveXControl extends SpinButtonActiveXControl;

Constructors

Name	Description
constructor(SpinButtonActiveXControl)	Constructs from a parent object convertible to this.

Properties

Property	Type	Description
largeChange	number	Gets and sets the amount by which the Position property changes
workbook	Workbook	Readonly. Gets the Workbook object.
mouseIcon	Uint8Array	Gets and sets a custom icon to display as the mouse pointer for the control.
mousePointer	ControlMousePointerType	Gets and sets the type of icon displayed as the mouse pointer for the control.
linkedCell	string	Gets and sets the linked cell.
listFillRange	string	Gets and sets the list fill range.
isEnabled	boolean	Indicates whether the control can receive the focus and respond to user-generated events.
isLocked	boolean	Indicates whether data in the control is locked for editing.
isTransparent	boolean	Indicates whether the control is transparent.
iMEMode	InputMethodEditorMode	Gets and sets the default run-time mode of the Input Method Editor for the control as it receives focus.
font	Font	Readonly. Represents the font of the control.
textAlign	TextAlignmentType	Represents how to align the text used by the control.
min	number	Gets and sets the minimum acceptable value.
max	number	Gets and sets the maximum acceptable value.
position	number	Gets and sets the value.
smallChange	number	Gets and sets the amount by which the Position property changes
orientation	ControlScrollOrientation	Gets and sets whether the SpinButton or ScrollBar is oriented vertically or horizontally.

Methods

Method	Description
getType()	Gets the type of the ActiveX control.
getWidth()	Gets and sets the width of the control in unit of points.
setWidth(number)	Gets and sets the width of the control in unit of points.
getHeight()	Gets and sets the height of the control in unit of points.
setHeight(number)	Gets and sets the height of the control in unit of points.
getForeOleColor()	Gets and sets the ole color of the foreground.
setForeOleColor(number)	Gets and sets the ole color of the foreground.
getBackOleColor()	Gets and sets the ole color of the background.
setBackOleColor(number)	Gets and sets the ole color of the background.
isVisible()	Indicates whether this control is visible.
setIsVisible(boolean)	Indicates whether this control is visible.
getShadow()	Indicates whether to show a shadow.
setShadow(boolean)	Indicates whether to show a shadow.
isAutoSize()	Indicates whether the control will automatically resize to display its entire contents.
setIsAutoSize(boolean)	Indicates whether the control will automatically resize to display its entire contents.
getData()	Gets and sets the binary data of the control.

constructor(SpinButtonActiveXControl)

Constructs from a parent object convertible to this.

constructor(obj: SpinButtonActiveXControl);

Parameters:

Parameter	Type	Description
obj	SpinButtonActiveXControl	The parent object.

largeChange

Gets and sets the amount by which the Position property changes

largeChange : number;

workbook

Readonly. Gets the Workbook object.

workbook : Workbook;

mouseIcon

Gets and sets a custom icon to display as the mouse pointer for the control.

mouseIcon : Uint8Array;

mousePointer

Gets and sets the type of icon displayed as the mouse pointer for the control.

mousePointer : ControlMousePointerType;

linkedCell

Gets and sets the linked cell.

linkedCell : string;

listFillRange

Gets and sets the list fill range.

listFillRange : string;

isEnabled

Indicates whether the control can receive the focus and respond to user-generated events.

isEnabled : boolean;

isLocked

Indicates whether data in the control is locked for editing.

isLocked : boolean;

isTransparent

Indicates whether the control is transparent.

isTransparent : boolean;

iMEMode

Gets and sets the default run-time mode of the Input Method Editor for the control as it receives focus.

iMEMode : InputMethodEditorMode;

font

Readonly. Represents the font of the control.

font : Font;

textAlign

Represents how to align the text used by the control.

textAlign : TextAlignmentType;

min

Gets and sets the minimum acceptable value.

min : number;

max

Gets and sets the maximum acceptable value.

max : number;

position

Gets and sets the value.

position : number;

smallChange

Gets and sets the amount by which the Position property changes

smallChange : number;

orientation

Gets and sets whether the SpinButton or ScrollBar is oriented vertically or horizontally.

orientation : ControlScrollOrientation;

getType()

Gets the type of the ActiveX control.

getType() : ControlType;

Returns

ControlType

getWidth()

Gets and sets the width of the control in unit of points.

getWidth() : number;

setWidth(number)

Gets and sets the width of the control in unit of points.

setWidth(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

getHeight()

Gets and sets the height of the control in unit of points.

getHeight() : number;

setHeight(number)

Gets and sets the height of the control in unit of points.

setHeight(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

getForeOleColor()

Gets and sets the ole color of the foreground.

getForeOleColor() : number;

Remarks

Not applies to Image control.

setForeOleColor(number)

Gets and sets the ole color of the foreground.

setForeOleColor(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

Remarks

Not applies to Image control.

getBackOleColor()

Gets and sets the ole color of the background.

getBackOleColor() : number;

setBackOleColor(number)

Gets and sets the ole color of the background.

setBackOleColor(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

isVisible()

Indicates whether this control is visible.

isVisible() : boolean;

setIsVisible(boolean)

Indicates whether this control is visible.

setIsVisible(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getShadow()

Indicates whether to show a shadow.

getShadow() : boolean;

setShadow(boolean)

Indicates whether to show a shadow.

setShadow(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

isAutoSize()

Indicates whether the control will automatically resize to display its entire contents.

isAutoSize() : boolean;

setIsAutoSize(boolean)

Indicates whether the control will automatically resize to display its entire contents.

setIsAutoSize(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getData()

Gets and sets the binary data of the control.

getData() : Uint8Array;