Spinner
Spinner class
Represents the Forms control: Spinner.
class Spinner extends Shape;
Remarks
Scroll value must be between 0 and 30000.
Constructors
| Name | Description |
|---|---|
| constructor(Shape) | Constructs from a parent object convertible to this. |
Methods
| Method | Description |
|---|---|
| getCurrentValue() | Gets or sets the current value. |
| setCurrentValue(number) | Gets or sets the current value. |
| getMin() | Gets or sets the minimum value of a scroll bar or spinner range. |
| setMin(number) | Gets or sets the minimum value of a scroll bar or spinner range. |
| getMax() | Gets or sets the maximum value of a scroll bar or spinner range. |
| setMax(number) | Gets or sets the maximum value of a scroll bar or spinner range. |
| getIncrementalChange() | Gets or sets the amount that the scroll bar or spinner is incremented a line scroll. |
| setIncrementalChange(number) | Gets or sets the amount that the scroll bar or spinner is incremented a line scroll. |
| getShadow() | Indicates whether the shape has 3-D shading. |
| setShadow(boolean) | Indicates whether the shape has 3-D shading. |
| isHorizontal() | Indicates whether this is a horizontal scroll bar. |
| setIsHorizontal(boolean) | Indicates whether this is a horizontal scroll bar. |
| isNull() | Checks whether the implementation object is null. |
| getMacroName() | Gets and sets the name of macro. |
| setMacroName(string) | Gets and sets the name of macro. |
| isEquation() | Indicates whether the shape only contains an equation. |
| isSmartArt() | Indicates whether the shape is a smart art. |
| getZOrderPosition() | Returns the position of a shape in the z-order. |
| setZOrderPosition(number) | Returns the position of a shape in the z-order. |
| getName() | Gets and sets the name of the shape. |
| setName(string) | Gets and sets the name of the shape. |
| getAlternativeText() | Returns or sets the descriptive (alternative) text string of the Shape object. |
| setAlternativeText(string) | Returns or sets the descriptive (alternative) text string of the Shape object. |
| getTitle() | Specifies the title (caption) of the current shape object. |
| setTitle(string) | Specifies the title (caption) of the current shape object. |
| getLine() | Gets line style |
| getFill() | Returns a FillFormat object that contains fill formatting properties for the specified shape. |
| getShadowEffect() | Represents a Drawing.ShadowEffect object that specifies shadow effect for the chart element or shape. |
| getReflection() | Represents a ReflectionEffect object that specifies reflection effect for the chart element or shape. |
| getGlow() | Represents a GlowEffect object that specifies glow effect for the chart element or shape. |
| getSoftEdges() | Gets and sets the radius of blur to apply to the edges, in unit of points. |
| setSoftEdges(number) | Gets and sets the radius of blur to apply to the edges, in unit of points. |
| getThreeDFormat() | Gets and sets 3d format of the shape. |
| getFormatPicture() | Gets and sets the options of the picture format. |
| isHidden() | Indicates whether the object is visible. |
| setIsHidden(boolean) | Indicates whether the object is visible. |
| isLockAspectRatio() | True means that aspect ratio of the shape is locked. |
| setIsLockAspectRatio(boolean) | True means that aspect ratio of the shape is locked. |
| isAspectRatioLocked() | True means that aspect ratio of the shape is locked. |
| setIsAspectRatioLocked(boolean) | True means that aspect ratio of the shape is locked. |
| getRotationAngle() | Gets and sets the rotation of the shape. |
| setRotationAngle(number) | Gets and sets the rotation of the shape. |
| getHyperlink() | Gets the hyperlink of the shape. |
| getId() | Gets the identifier of this shape. |
| getSpid() | Specifies an optional string identifier that an application can use to identify the particular shape. |
| getSpt() | Specifies an optional number that an application can use to associate the particular shape with a defined shape type. |
| getWorksheet() | Gets the Worksheet object which contains this shape. |
| isGroup() | Indicates whether this shape is a group shape. |
| isInGroup() | Indicates whether the shape is grouped. |
| isWordArt() | Indicates whether this shape is a word art. |
| getTextEffect() | Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to Shape objects that represent WordArt. |
| isLocked() | True means the object can not be modified when the sheet is protected. Note that this value is meaningful only if the worksheet or objects in the worksheet are protected. |
| setIsLocked(boolean) | True means the object can not be modified when the sheet is protected. Note that this value is meaningful only if the worksheet or objects in the worksheet are protected. |
| isPrintable() | Indicates whether the object is printable. If False, this shape will not be printed when printing. |
| setIsPrintable(boolean) | Indicates whether the object is printable. If False, this shape will not be printed when printing. |
| getMsoDrawingType() | Gets drawing type. |
| getAutoShapeType() | Gets and sets the auto shape type. |
| setAutoShapeType(AutoShapeType) | Gets and sets the auto shape type. |
| getAnchorType() | Gets and set the type of the shape anchor placeholder. |
| setAnchorType(ShapeAnchorType) | Gets and set the type of the shape anchor placeholder. |
| getPlacement() | Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet. |
| setPlacement(PlacementType) | Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet. |
| getUpperLeftRow() | Represents the top row index. |
| setUpperLeftRow(number) | Represents the top row index. |
| getUpperDeltaY() | Gets or sets the shape’s vertical offset from its upper left corner row. |
| setUpperDeltaY(number) | Gets or sets the shape’s vertical offset from its upper left corner row. |
| getUpperLeftColumn() | Represents upper left corner column index. |
| setUpperLeftColumn(number) | Represents upper left corner column index. |
| getUpperDeltaX() | Gets or sets the shape’s horizontal offset from its upper left corner column. |
| setUpperDeltaX(number) | Gets or sets the shape’s horizontal offset from its upper left corner column. |
| getLowerRightRow() | Represents lower right corner row index. |
| setLowerRightRow(number) | Represents lower right corner row index. |
| getLowerDeltaY() | Gets or sets the shape’s vertical offset from its lower right corner row. |
| setLowerDeltaY(number) | Gets or sets the shape’s vertical offset from its lower right corner row. |
| getLowerRightColumn() | Represents lower right corner column index. |
| setLowerRightColumn(number) | Represents lower right corner column index. |
| getLowerDeltaX() | Gets or sets the shape’s horizontal offset from its lower right corner column. |
| setLowerDeltaX(number) | Gets or sets the shape’s horizontal offset from its lower right corner column. |
| getRight() | Represents the width of the shape’s horizontal offset from its lower right corner column, in unit of pixels. |
| setRight(number) | Represents the width of the shape’s horizontal offset from its lower right corner column, in unit of pixels. |
| getBottom() | Represents the width of the shape’s vertical offset from its lower bottom corner row, in unit of pixels. |
| setBottom(number) | Represents the width of the shape’s vertical offset from its lower bottom corner row, in unit of pixels. |
| getWidth() | Represents the width of shape, in unit of pixels. |
| setWidth(number) | Represents the width of shape, in unit of pixels. |
| getWidthInch() | Represents the width of the shape, in unit of inch. |
| setWidthInch(number) | Represents the width of the shape, in unit of inch. |
| getWidthPt() | Represents the width of the shape, in unit of point. |
| setWidthPt(number) | Represents the width of the shape, in unit of point. |
| getWidthCM() | Represents the width of the shape, in unit of centimeters. |
| setWidthCM(number) | Represents the width of the shape, in unit of centimeters. |
| getHeight() | Represents the height of shape, in unit of pixel. |
| setHeight(number) | Represents the height of shape, in unit of pixel. |
| getHeightInch() | Represents the height of the shape, in unit of inches. |
| setHeightInch(number) | Represents the height of the shape, in unit of inches. |
| getHeightPt() | Represents the height of the shape, in unit of points. |
| setHeightPt(number) | Represents the height of the shape, in unit of points. |
| getHeightCM() | Represents the height of the shape, in unit of centimeters. |
| setHeightCM(number) | Represents the height of the shape, in unit of centimeters. |
| getLeft() | Represents the horizontal offset of shape from its left column, in unit of pixels. |
| setLeft(number) | Represents the horizontal offset of shape from its left column, in unit of pixels. |
| getLeftInch() | Represents the horizontal offset of shape from its left column, in unit of inches. |
| setLeftInch(number) | Represents the horizontal offset of shape from its left column, in unit of inches. |
| getLeftCM() | Represents the horizontal offset of shape from its left column, in unit of centimeters. |
| setLeftCM(number) | Represents the horizontal offset of shape from its left column, in unit of centimeters. |
| getTop() | Represents the vertical offset of shape from its top row, in unit of pixels. |
| setTop(number) | Represents the vertical offset of shape from its top row, in unit of pixels. |
| getTopInch() | Represents the vertical offset of shape from its top row, in unit of inches. |
| setTopInch(number) | Represents the vertical offset of shape from its top row, in unit of inches. |
| getTopCM() | Represents the vertical offset of shape from its top row, in unit of centimeters. |
| setTopCM(number) | Represents the vertical offset of shape from its top row, in unit of centimeters. |
| getTopToCorner() | Gets and sets the vertical offset of shape from worksheet top border, in unit of pixels. |
| setTopToCorner(number) | Gets and sets the vertical offset of shape from worksheet top border, in unit of pixels. |
| getLeftToCorner() | Gets and sets the horizonal offset of shape from worksheet left border. |
| setLeftToCorner(number) | Gets and sets the horizonal offset of shape from worksheet left border. |
| getX() | Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels. |
| setX(number) | Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels. |
| getY() | Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels. |
| setY(number) | Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels. |
| getWidthScale() | Gets and sets the width scale, in unit of percent of the original picture width. If the shape is not picture ,the WidthScale property only returns 100; |
| setWidthScale(number) | Gets and sets the width scale, in unit of percent of the original picture width. If the shape is not picture ,the WidthScale property only returns 100; |
| getHeightScale() | Gets and sets the height scale,in unit of percent of the original picture height. If the shape is not picture ,the HeightScale property only returns 100; |
| setHeightScale(number) | Gets and sets the height scale,in unit of percent of the original picture height. If the shape is not picture ,the HeightScale property only returns 100; |
| getTopInShape() | Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape. |
| setTopInShape(number) | Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape. |
| getLeftInShape() | Represents the horizontal offset of shape from the left border of the parent shape, in unit of 1/4000 of width of the parent shape. |
| setLeftInShape(number) | Represents the horizontal offset of shape from the left border of the parent shape, in unit of 1/4000 of width of the parent shape. |
| getWidthInShape() | Represents the width of the shape, in unit of 1/4000 of the parent shape. |
| setWidthInShape(number) | Represents the width of the shape, in unit of 1/4000 of the parent shape. |
| getHeightInShape() | Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape.. |
| setHeightInShape(number) | Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape.. |
| getGroup() | Gets the group shape which contains this shape. |
| getType() | Gets the auto shape type. |
| getHasLine() | Gets and sets the line border of the shape is visible. |
| setHasLine(boolean) | Gets and sets the line border of the shape is visible. |
| isFilled() | Indicates whether the fill format is visible. |
| setIsFilled(boolean) | Indicates whether the fill format is visible. |
| isFlippedHorizontally() | Gets and sets whether shape is horizontally flipped . |
| setIsFlippedHorizontally(boolean) | Gets and sets whether shape is horizontally flipped . |
| isFlippedVertically() | Gets and sets whether shape is vertically flipped . |
| setIsFlippedVertically(boolean) | Gets and sets whether shape is vertically flipped . |
| getActualLowerRightRow() | Get the actual bottom row. |
| getRelativeToOriginalPictureSize() | Indicates whether shape is relative to original picture size. |
| setRelativeToOriginalPictureSize(boolean) | Indicates whether shape is relative to original picture size. |
| getLinkedCell() | Gets or sets the worksheet range linked to the control’s value. |
| setLinkedCell(string) | Gets or sets the worksheet range linked to the control’s value. |
| getInputRange() | Gets or sets the worksheet range used to fill the specified combo box. |
| setInputRange(string) | Gets or sets the worksheet range used to fill the specified combo box. |
| getTextShapeType() | Gets and sets the preset text shape type. |
| setTextShapeType(AutoShapeType) | Gets and sets the preset text shape type. |
| getTextBody() | Gets and sets the setting of the shape’s text. |
| getFont() | Represents the font of shape. |
| setFont(Font) | Represents the font of shape. |
| getTextOptions() | Represents the text options of the shape. |
| setTextOptions(TextOptions) | Represents the text options of the shape. |
| getText() | Gets and sets the text of this shape. |
| setText(string) | Gets and sets the text of this shape. |
| isRichText() | Whether or not the text is rich text. |
| getHtmlText() | Gets and sets the html string which contains data and some formats in this textbox. |
| setHtmlText(string) | Gets and sets the html string which contains data and some formats in this textbox. |
| getTextVerticalOverflow() | Gets and sets the text vertical overflow type of the shape which contains text. |
| setTextVerticalOverflow(TextOverflowType) | Gets and sets the text vertical overflow type of the shape which contains text. |
| getTextHorizontalOverflow() | Gets and sets the text horizontal overflow type of the shape which contains text. |
| setTextHorizontalOverflow(TextOverflowType) | Gets and sets the text horizontal overflow type of the shape which contains text. |
| isTextWrapped() | Gets and sets the text wrapped type of the shape which contains text. |
| setIsTextWrapped(boolean) | Gets and sets the text wrapped type of the shape which contains text. |
| getTextOrientationType() | Gets and sets the text orientation type of the shape. |
| setTextOrientationType(TextOrientationType) | Gets and sets the text orientation type of the shape. |
| getTextHorizontalAlignment() | Gets and sets the text horizontal alignment type of the shape. |
| setTextHorizontalAlignment(TextAlignmentType) | Gets and sets the text horizontal alignment type of the shape. |
| getTextVerticalAlignment() | Gets and sets the text vertical alignment type of the shape. |
| setTextVerticalAlignment(TextAlignmentType) | Gets and sets the text vertical alignment type of the shape. |
| getTextDirection() | Gets/Sets the direction of the text flow for this object. |
| setTextDirection(TextDirectionType) | Gets/Sets the direction of the text flow for this object. |
| getTextBoxOptions() | Gets the text information in the shape |
| getControlData() | Gets the data of control. |
| getActiveXControl() | Gets the ActiveX control. |
| getPaths() | Gets the paths of a custom geometric shape. |
| getGeometry() | Gets the geometry |
| isDecorative() | Indicates whether the object is decorative. |
| setIsDecorative(boolean) | Indicates whether the object is decorative. |
| getResultOfSmartArt() | Converting smart art to grouped shapes. |
| toFrontOrBack(number) | Brings the shape to the front or sends the shape to back. |
| getLockedProperty(ShapeLockType) | Gets the value of locked property. |
| setLockedProperty(ShapeLockType, boolean) | Set the locked property. |
| addHyperlink(string) | Adds a hyperlink to the shape. |
| removeHyperlink() | Removes the hyperlink of the shape. |
| moveToRange(number, number, number, number) | Moves the shape to a specified range. |
| alignTopRightCorner(number, number) | Moves the picture to the top-right corner. |
| getConnectionPoints() | Get the connection points |
| toImage(Uint8Array, ImageType) | Creates the shape image and saves it to a stream in the specified format. |
| toImage(string, ImageOrPrintOptions) | Saves the shape to a file. |
| toImage(ImageOrPrintOptions) | Saves the shape to a stream. |
| getLinkedCell(boolean, boolean) | Gets the range linked to the control’s value. |
| setLinkedCell(string, boolean, boolean) | Sets the range linked to the control’s value. |
| getInputRange(boolean, boolean) | Gets the range used to fill the control. |
| setInputRange(string, boolean, boolean) | Sets the range used to fill the control. |
| updateSelectedValue() | Update the selected value by the value of the linked cell. |
| calculateTextSize() | Recalculate the text area |
| formatCharacters(number, number, Font, StyleFlag) | Formats some characters with the font setting. |
| characters(number, number) | Returns a Characters object that represents a range of characters within the text. |
| getRichFormattings() | Returns all Characters objects that represents a range of characters within the text . |
| removeActiveXControl() | Remove activeX control. |
| isSameSetting(object) | Returns whether the shape is same. |
| getActualBox() | Get the actual position and size of the shape (after applying rotation, flip, etc.) |
constructor(Shape)
Constructs from a parent object convertible to this.
constructor(obj: Shape);
Parameters:
| Parameter | Type | Description |
|---|---|---|
| obj | Shape | The parent object. |
getCurrentValue()
Gets or sets the current value.
getCurrentValue() : number;
setCurrentValue(number)
Gets or sets the current value.
setCurrentValue(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getMin()
Gets or sets the minimum value of a scroll bar or spinner range.
getMin() : number;
setMin(number)
Gets or sets the minimum value of a scroll bar or spinner range.
setMin(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getMax()
Gets or sets the maximum value of a scroll bar or spinner range.
getMax() : number;
setMax(number)
Gets or sets the maximum value of a scroll bar or spinner range.
setMax(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getIncrementalChange()
Gets or sets the amount that the scroll bar or spinner is incremented a line scroll.
getIncrementalChange() : number;
setIncrementalChange(number)
Gets or sets the amount that the scroll bar or spinner is incremented a line scroll.
setIncrementalChange(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getShadow()
Indicates whether the shape has 3-D shading.
getShadow() : boolean;
setShadow(boolean)
Indicates whether the shape has 3-D shading.
setShadow(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
isHorizontal()
Indicates whether this is a horizontal scroll bar.
isHorizontal() : boolean;
setIsHorizontal(boolean)
Indicates whether this is a horizontal scroll bar.
setIsHorizontal(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
isNull()
Checks whether the implementation object is null.
isNull() : boolean;
getMacroName()
Gets and sets the name of macro.
getMacroName() : string;
setMacroName(string)
Gets and sets the name of macro.
setMacroName(value: string) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | string | The value to set. |
isEquation()
Indicates whether the shape only contains an equation.
isEquation() : boolean;
isSmartArt()
Indicates whether the shape is a smart art.
isSmartArt() : boolean;
Remarks
Only for ooxml file.
getZOrderPosition()
Returns the position of a shape in the z-order.
getZOrderPosition() : number;
setZOrderPosition(number)
Returns the position of a shape in the z-order.
setZOrderPosition(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getName()
Gets and sets the name of the shape.
getName() : string;
setName(string)
Gets and sets the name of the shape.
setName(value: string) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | string | The value to set. |
getAlternativeText()
Returns or sets the descriptive (alternative) text string of the Shape object.
getAlternativeText() : string;
setAlternativeText(string)
Returns or sets the descriptive (alternative) text string of the Shape object.
setAlternativeText(value: string) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | string | The value to set. |
getTitle()
Specifies the title (caption) of the current shape object.
getTitle() : string;
setTitle(string)
Specifies the title (caption) of the current shape object.
setTitle(value: string) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | string | The value to set. |
getLine()
Gets line style
getLine() : LineFormat;
Returns
getFill()
Returns a FillFormat object that contains fill formatting properties for the specified shape.
getFill() : FillFormat;
Returns
getShadowEffect()
Represents a Drawing.ShadowEffect object that specifies shadow effect for the chart element or shape.
getShadowEffect() : ShadowEffect;
Returns
getReflection()
Represents a ReflectionEffect object that specifies reflection effect for the chart element or shape.
getReflection() : ReflectionEffect;
Returns
getGlow()
Represents a GlowEffect object that specifies glow effect for the chart element or shape.
getGlow() : GlowEffect;
Returns
getSoftEdges()
Gets and sets the radius of blur to apply to the edges, in unit of points.
getSoftEdges() : number;
setSoftEdges(number)
Gets and sets the radius of blur to apply to the edges, in unit of points.
setSoftEdges(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getThreeDFormat()
Gets and sets 3d format of the shape.
getThreeDFormat() : ThreeDFormat;
Returns
getFormatPicture()
Gets and sets the options of the picture format.
getFormatPicture() : MsoFormatPicture;
Returns
isHidden()
Indicates whether the object is visible.
isHidden() : boolean;
setIsHidden(boolean)
Indicates whether the object is visible.
setIsHidden(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
isLockAspectRatio()
True means that aspect ratio of the shape is locked.
isLockAspectRatio() : boolean;
Remarks
Only for pictures and Ole Objects. NOTE: This member is now obsolete. Instead, please use Shape.IsAspectRatioLocked property. This property will be removed 12 months later since July 2024. Aspose apologizes for any inconvenience you may have experienced.
setIsLockAspectRatio(boolean)
True means that aspect ratio of the shape is locked.
setIsLockAspectRatio(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
Remarks
Only for pictures and Ole Objects. NOTE: This member is now obsolete. Instead, please use Shape.IsAspectRatioLocked property. This property will be removed 12 months later since July 2024. Aspose apologizes for any inconvenience you may have experienced.
isAspectRatioLocked()
True means that aspect ratio of the shape is locked.
isAspectRatioLocked() : boolean;
Remarks
Only for pictures and Ole Objects.
setIsAspectRatioLocked(boolean)
True means that aspect ratio of the shape is locked.
setIsAspectRatioLocked(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
Remarks
Only for pictures and Ole Objects.
getRotationAngle()
Gets and sets the rotation of the shape.
getRotationAngle() : number;
setRotationAngle(number)
Gets and sets the rotation of the shape.
setRotationAngle(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getHyperlink()
Gets the hyperlink of the shape.
getHyperlink() : Hyperlink;
Returns
getId()
Gets the identifier of this shape.
getId() : number;
getSpid()
Specifies an optional string identifier that an application can use to identify the particular shape.
getSpid() : string;
getSpt()
Specifies an optional number that an application can use to associate the particular shape with a defined shape type.
getSpt() : number;
getWorksheet()
Gets the Worksheet object which contains this shape.
getWorksheet() : Worksheet;
Returns
isGroup()
Indicates whether this shape is a group shape.
isGroup() : boolean;
isInGroup()
Indicates whether the shape is grouped.
isInGroup() : boolean;
isWordArt()
Indicates whether this shape is a word art.
isWordArt() : boolean;
Remarks
Only for the Legacy Shape of xls file.
getTextEffect()
Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to Shape objects that represent WordArt.
getTextEffect() : TextEffectFormat;
Returns
isLocked()
True means the object can not be modified when the sheet is protected. Note that this value is meaningful only if the worksheet or objects in the worksheet are protected.
isLocked() : boolean;
setIsLocked(boolean)
True means the object can not be modified when the sheet is protected. Note that this value is meaningful only if the worksheet or objects in the worksheet are protected.
setIsLocked(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
isPrintable()
Indicates whether the object is printable. If False, this shape will not be printed when printing.
isPrintable() : boolean;
setIsPrintable(boolean)
Indicates whether the object is printable. If False, this shape will not be printed when printing.
setIsPrintable(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
getMsoDrawingType()
Gets drawing type.
getMsoDrawingType() : MsoDrawingType;
Returns
getAutoShapeType()
Gets and sets the auto shape type.
getAutoShapeType() : AutoShapeType;
Returns
setAutoShapeType(AutoShapeType)
Gets and sets the auto shape type.
setAutoShapeType(value: AutoShapeType) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | AutoShapeType | The value to set. |
getAnchorType()
Gets and set the type of the shape anchor placeholder.
getAnchorType() : ShapeAnchorType;
Returns
setAnchorType(ShapeAnchorType)
Gets and set the type of the shape anchor placeholder.
setAnchorType(value: ShapeAnchorType) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | ShapeAnchorType | The value to set. |
getPlacement()
Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet.
getPlacement() : PlacementType;
Returns
setPlacement(PlacementType)
Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet.
setPlacement(value: PlacementType) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | PlacementType | The value to set. |
getUpperLeftRow()
Represents the top row index.
getUpperLeftRow() : number;
Remarks
If the shape is in the shape or in the group , UpperLeftRow will be ignored.
setUpperLeftRow(number)
Represents the top row index.
setUpperLeftRow(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
Remarks
If the shape is in the shape or in the group , UpperLeftRow will be ignored.
getUpperDeltaY()
Gets or sets the shape’s vertical offset from its upper left corner row.
getUpperDeltaY() : number;
Remarks
The range of value is 0 to 256.
setUpperDeltaY(number)
Gets or sets the shape’s vertical offset from its upper left corner row.
setUpperDeltaY(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
Remarks
The range of value is 0 to 256.
getUpperLeftColumn()
Represents upper left corner column index.
getUpperLeftColumn() : number;
setUpperLeftColumn(number)
Represents upper left corner column index.
setUpperLeftColumn(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getUpperDeltaX()
Gets or sets the shape’s horizontal offset from its upper left corner column.
getUpperDeltaX() : number;
Remarks
The range of value is 0 to 1024.
setUpperDeltaX(number)
Gets or sets the shape’s horizontal offset from its upper left corner column.
setUpperDeltaX(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
Remarks
The range of value is 0 to 1024.
getLowerRightRow()
Represents lower right corner row index.
getLowerRightRow() : number;
setLowerRightRow(number)
Represents lower right corner row index.
setLowerRightRow(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getLowerDeltaY()
Gets or sets the shape’s vertical offset from its lower right corner row.
getLowerDeltaY() : number;
Remarks
The range of value is 0 to 256.
setLowerDeltaY(number)
Gets or sets the shape’s vertical offset from its lower right corner row.
setLowerDeltaY(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
Remarks
The range of value is 0 to 256.
getLowerRightColumn()
Represents lower right corner column index.
getLowerRightColumn() : number;
setLowerRightColumn(number)
Represents lower right corner column index.
setLowerRightColumn(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getLowerDeltaX()
Gets or sets the shape’s horizontal offset from its lower right corner column.
getLowerDeltaX() : number;
Remarks
The range of value is 0 to 1024.
setLowerDeltaX(number)
Gets or sets the shape’s horizontal offset from its lower right corner column.
setLowerDeltaX(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
Remarks
The range of value is 0 to 1024.
getRight()
Represents the width of the shape’s horizontal offset from its lower right corner column, in unit of pixels.
getRight() : number;
setRight(number)
Represents the width of the shape’s horizontal offset from its lower right corner column, in unit of pixels.
setRight(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getBottom()
Represents the width of the shape’s vertical offset from its lower bottom corner row, in unit of pixels.
getBottom() : number;
setBottom(number)
Represents the width of the shape’s vertical offset from its lower bottom corner row, in unit of pixels.
setBottom(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getWidth()
Represents the width of shape, in unit of pixels.
getWidth() : number;
setWidth(number)
Represents the width of shape, in unit of pixels.
setWidth(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getWidthInch()
Represents the width of the shape, in unit of inch.
getWidthInch() : number;
setWidthInch(number)
Represents the width of the shape, in unit of inch.
setWidthInch(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getWidthPt()
Represents the width of the shape, in unit of point.
getWidthPt() : number;
setWidthPt(number)
Represents the width of the shape, in unit of point.
setWidthPt(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getWidthCM()
Represents the width of the shape, in unit of centimeters.
getWidthCM() : number;
setWidthCM(number)
Represents the width of the shape, in unit of centimeters.
setWidthCM(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getHeight()
Represents the height of shape, in unit of pixel.
getHeight() : number;
setHeight(number)
Represents the height of shape, in unit of pixel.
setHeight(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getHeightInch()
Represents the height of the shape, in unit of inches.
getHeightInch() : number;
setHeightInch(number)
Represents the height of the shape, in unit of inches.
setHeightInch(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getHeightPt()
Represents the height of the shape, in unit of points.
getHeightPt() : number;
setHeightPt(number)
Represents the height of the shape, in unit of points.
setHeightPt(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getHeightCM()
Represents the height of the shape, in unit of centimeters.
getHeightCM() : number;
setHeightCM(number)
Represents the height of the shape, in unit of centimeters.
setHeightCM(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getLeft()
Represents the horizontal offset of shape from its left column, in unit of pixels.
getLeft() : number;
setLeft(number)
Represents the horizontal offset of shape from its left column, in unit of pixels.
setLeft(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getLeftInch()
Represents the horizontal offset of shape from its left column, in unit of inches.
getLeftInch() : number;
setLeftInch(number)
Represents the horizontal offset of shape from its left column, in unit of inches.
setLeftInch(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getLeftCM()
Represents the horizontal offset of shape from its left column, in unit of centimeters.
getLeftCM() : number;
setLeftCM(number)
Represents the horizontal offset of shape from its left column, in unit of centimeters.
setLeftCM(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getTop()
Represents the vertical offset of shape from its top row, in unit of pixels.
getTop() : number;
Remarks
If the shape is in the chart, represents the vertical offset of shape from its top border.
setTop(number)
Represents the vertical offset of shape from its top row, in unit of pixels.
setTop(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
Remarks
If the shape is in the chart, represents the vertical offset of shape from its top border.
getTopInch()
Represents the vertical offset of shape from its top row, in unit of inches.
getTopInch() : number;
setTopInch(number)
Represents the vertical offset of shape from its top row, in unit of inches.
setTopInch(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getTopCM()
Represents the vertical offset of shape from its top row, in unit of centimeters.
getTopCM() : number;
setTopCM(number)
Represents the vertical offset of shape from its top row, in unit of centimeters.
setTopCM(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getTopToCorner()
Gets and sets the vertical offset of shape from worksheet top border, in unit of pixels.
getTopToCorner() : number;
setTopToCorner(number)
Gets and sets the vertical offset of shape from worksheet top border, in unit of pixels.
setTopToCorner(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getLeftToCorner()
Gets and sets the horizonal offset of shape from worksheet left border.
getLeftToCorner() : number;
setLeftToCorner(number)
Gets and sets the horizonal offset of shape from worksheet left border.
setLeftToCorner(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getX()
Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels.
getX() : number;
setX(number)
Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels.
setX(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getY()
Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels.
getY() : number;
setY(number)
Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels.
setY(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getWidthScale()
Gets and sets the width scale, in unit of percent of the original picture width. If the shape is not picture ,the WidthScale property only returns 100;
getWidthScale() : number;
setWidthScale(number)
Gets and sets the width scale, in unit of percent of the original picture width. If the shape is not picture ,the WidthScale property only returns 100;
setWidthScale(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getHeightScale()
Gets and sets the height scale,in unit of percent of the original picture height. If the shape is not picture ,the HeightScale property only returns 100;
getHeightScale() : number;
setHeightScale(number)
Gets and sets the height scale,in unit of percent of the original picture height. If the shape is not picture ,the HeightScale property only returns 100;
setHeightScale(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
getTopInShape()
Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape.
getTopInShape() : number;
Remarks
Only Applies when this shape in the group or chart.
setTopInShape(number)
Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape.
setTopInShape(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
Remarks
Only Applies when this shape in the group or chart.
getLeftInShape()
Represents the horizontal offset of shape from the left border of the parent shape, in unit of 1/4000 of width of the parent shape.
getLeftInShape() : number;
Remarks
Only Applies when this shape in the group or chart.
setLeftInShape(number)
Represents the horizontal offset of shape from the left border of the parent shape, in unit of 1/4000 of width of the parent shape.
setLeftInShape(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
Remarks
Only Applies when this shape in the group or chart.
getWidthInShape()
Represents the width of the shape, in unit of 1/4000 of the parent shape.
getWidthInShape() : number;
Remarks
Only Applies when this shape in the group or chart.
setWidthInShape(number)
Represents the width of the shape, in unit of 1/4000 of the parent shape.
setWidthInShape(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
Remarks
Only Applies when this shape in the group or chart.
getHeightInShape()
Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape..
getHeightInShape() : number;
Remarks
Only Applies when this shape in the group or chart.
setHeightInShape(number)
Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape..
setHeightInShape(value: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | number | The value to set. |
Remarks
Only Applies when this shape in the group or chart.
getGroup()
Gets the group shape which contains this shape.
getGroup() : GroupShape;
Returns
getType()
Gets the auto shape type.
getType() : AutoShapeType;
Returns
getHasLine()
Gets and sets the line border of the shape is visible.
getHasLine() : boolean;
setHasLine(boolean)
Gets and sets the line border of the shape is visible.
setHasLine(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
isFilled()
Indicates whether the fill format is visible.
isFilled() : boolean;
setIsFilled(boolean)
Indicates whether the fill format is visible.
setIsFilled(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
isFlippedHorizontally()
Gets and sets whether shape is horizontally flipped .
isFlippedHorizontally() : boolean;
setIsFlippedHorizontally(boolean)
Gets and sets whether shape is horizontally flipped .
setIsFlippedHorizontally(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
isFlippedVertically()
Gets and sets whether shape is vertically flipped .
isFlippedVertically() : boolean;
setIsFlippedVertically(boolean)
Gets and sets whether shape is vertically flipped .
setIsFlippedVertically(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
getActualLowerRightRow()
Get the actual bottom row.
getActualLowerRightRow() : number;
getRelativeToOriginalPictureSize()
Indicates whether shape is relative to original picture size.
getRelativeToOriginalPictureSize() : boolean;
setRelativeToOriginalPictureSize(boolean)
Indicates whether shape is relative to original picture size.
setRelativeToOriginalPictureSize(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
getLinkedCell()
Gets or sets the worksheet range linked to the control’s value.
getLinkedCell() : string;
setLinkedCell(string)
Gets or sets the worksheet range linked to the control’s value.
setLinkedCell(value: string) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | string | The value to set. |
getInputRange()
Gets or sets the worksheet range used to fill the specified combo box.
getInputRange() : string;
setInputRange(string)
Gets or sets the worksheet range used to fill the specified combo box.
setInputRange(value: string) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | string | The value to set. |
getTextShapeType()
Gets and sets the preset text shape type.
getTextShapeType() : AutoShapeType;
Returns
setTextShapeType(AutoShapeType)
Gets and sets the preset text shape type.
setTextShapeType(value: AutoShapeType) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | AutoShapeType | The value to set. |
getTextBody()
Gets and sets the setting of the shape’s text.
getTextBody() : FontSettingCollection;
Returns
getFont()
Represents the font of shape.
getFont() : Font;
Returns
setFont(Font)
Represents the font of shape.
setFont(value: Font) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | Font | The value to set. |
getTextOptions()
Represents the text options of the shape.
getTextOptions() : TextOptions;
Returns
setTextOptions(TextOptions)
Represents the text options of the shape.
setTextOptions(value: TextOptions) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | TextOptions | The value to set. |
getText()
Gets and sets the text of this shape.
getText() : string;
setText(string)
Gets and sets the text of this shape.
setText(value: string) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | string | The value to set. |
isRichText()
Whether or not the text is rich text.
isRichText() : boolean;
getHtmlText()
Gets and sets the html string which contains data and some formats in this textbox.
getHtmlText() : string;
setHtmlText(string)
Gets and sets the html string which contains data and some formats in this textbox.
setHtmlText(value: string) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | string | The value to set. |
getTextVerticalOverflow()
Gets and sets the text vertical overflow type of the shape which contains text.
getTextVerticalOverflow() : TextOverflowType;
Returns
setTextVerticalOverflow(TextOverflowType)
Gets and sets the text vertical overflow type of the shape which contains text.
setTextVerticalOverflow(value: TextOverflowType) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | TextOverflowType | The value to set. |
getTextHorizontalOverflow()
Gets and sets the text horizontal overflow type of the shape which contains text.
getTextHorizontalOverflow() : TextOverflowType;
Returns
setTextHorizontalOverflow(TextOverflowType)
Gets and sets the text horizontal overflow type of the shape which contains text.
setTextHorizontalOverflow(value: TextOverflowType) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | TextOverflowType | The value to set. |
isTextWrapped()
Gets and sets the text wrapped type of the shape which contains text.
isTextWrapped() : boolean;
setIsTextWrapped(boolean)
Gets and sets the text wrapped type of the shape which contains text.
setIsTextWrapped(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
getTextOrientationType()
Gets and sets the text orientation type of the shape.
getTextOrientationType() : TextOrientationType;
Returns
setTextOrientationType(TextOrientationType)
Gets and sets the text orientation type of the shape.
setTextOrientationType(value: TextOrientationType) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | TextOrientationType | The value to set. |
getTextHorizontalAlignment()
Gets and sets the text horizontal alignment type of the shape.
getTextHorizontalAlignment() : TextAlignmentType;
Returns
setTextHorizontalAlignment(TextAlignmentType)
Gets and sets the text horizontal alignment type of the shape.
setTextHorizontalAlignment(value: TextAlignmentType) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | TextAlignmentType | The value to set. |
getTextVerticalAlignment()
Gets and sets the text vertical alignment type of the shape.
getTextVerticalAlignment() : TextAlignmentType;
Returns
setTextVerticalAlignment(TextAlignmentType)
Gets and sets the text vertical alignment type of the shape.
setTextVerticalAlignment(value: TextAlignmentType) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | TextAlignmentType | The value to set. |
getTextDirection()
Gets/Sets the direction of the text flow for this object.
getTextDirection() : TextDirectionType;
Returns
setTextDirection(TextDirectionType)
Gets/Sets the direction of the text flow for this object.
setTextDirection(value: TextDirectionType) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | TextDirectionType | The value to set. |
getTextBoxOptions()
Gets the text information in the shape
getTextBoxOptions() : TextBoxOptions;
Returns
getControlData()
Gets the data of control.
getControlData() : number[];
Returns
number[]
getActiveXControl()
Gets the ActiveX control.
getActiveXControl() : ActiveXControl;
Returns
getPaths()
Gets the paths of a custom geometric shape.
getPaths() : ShapePathCollection;
Returns
getGeometry()
Gets the geometry
getGeometry() : Geometry;
Returns
isDecorative()
Indicates whether the object is decorative.
isDecorative() : boolean;
setIsDecorative(boolean)
Indicates whether the object is decorative.
setIsDecorative(value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean | The value to set. |
getResultOfSmartArt()
Converting smart art to grouped shapes.
getResultOfSmartArt() : GroupShape;
Returns
toFrontOrBack(number)
Brings the shape to the front or sends the shape to back.
toFrontOrBack(orders: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| orders | number | If it’s less than zero, sets the shape to back. /// If it’s greater than zero, brings the shape to front. |
getLockedProperty(ShapeLockType)
Gets the value of locked property.
getLockedProperty(type: ShapeLockType) : boolean;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| type | ShapeLockType | The type of the shape locked property. |
Returns
Returns the value of locked property.
setLockedProperty(ShapeLockType, boolean)
Set the locked property.
setLockedProperty(type: ShapeLockType, value: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| type | ShapeLockType | The locked type. |
| value | boolean | The value of the property. |
addHyperlink(string)
Adds a hyperlink to the shape.
addHyperlink(address: string) : Hyperlink;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| address | string | Address of the hyperlink. |
Returns
Return the new hyperlink object.
removeHyperlink()
Removes the hyperlink of the shape.
removeHyperlink() : void;
moveToRange(number, number, number, number)
Moves the shape to a specified range.
moveToRange(upperLeftRow: number, upperLeftColumn: number, lowerRightRow: number, lowerRightColumn: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| upperLeftRow | number | Upper left row index. |
| upperLeftColumn | number | Upper left column index. |
| lowerRightRow | number | Lower right row index |
| lowerRightColumn | number | Lower right column index |
alignTopRightCorner(number, number)
Moves the picture to the top-right corner.
alignTopRightCorner(topRow: number, rightColumn: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| topRow | number | the row index. |
| rightColumn | number | the column index. |
getConnectionPoints()
Get the connection points
getConnectionPoints() : number[][];
Returns
[X,Y] pairs of the connection point. Every item is a float[2] array, [0] represents x and [1] represents y.
toImage(Uint8Array, ImageType)
Creates the shape image and saves it to a stream in the specified format.
toImage(stream: Uint8Array, imageType: ImageType) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| stream | Uint8Array | The output stream. |
| imageType | ImageType | The type in which to save the image. |
Remarks
The following formats are supported: .bmp, .gif, .jpg, .jpeg, .tiff, .emf.
toImage(string, ImageOrPrintOptions)
Saves the shape to a file.
toImage(imageFile: string, options: ImageOrPrintOptions) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| imageFile | string | |
| options | ImageOrPrintOptions |
toImage(ImageOrPrintOptions)
Saves the shape to a stream.
toImage(options: ImageOrPrintOptions) : Uint8Array;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| options | ImageOrPrintOptions |
Returns
The result stream
getLinkedCell(boolean, boolean)
Gets the range linked to the control’s value.
getLinkedCell(isR1C1: boolean, isLocal: boolean) : string;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |
Returns
The range linked to the control’s value.
setLinkedCell(string, boolean, boolean)
Sets the range linked to the control’s value.
setLinkedCell(formula: string, isR1C1: boolean, isLocal: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| formula | string | The range linked to the control’s value. |
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |
getInputRange(boolean, boolean)
Gets the range used to fill the control.
getInputRange(isR1C1: boolean, isLocal: boolean) : string;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |
Returns
The range used to fill the control.
setInputRange(string, boolean, boolean)
Sets the range used to fill the control.
setInputRange(formula: string, isR1C1: boolean, isLocal: boolean) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| formula | string | The range used to fill the control. |
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |
updateSelectedValue()
Update the selected value by the value of the linked cell.
updateSelectedValue() : void;
calculateTextSize()
Recalculate the text area
calculateTextSize() : number[];
Returns
Text’s Size in an array(width and height).
formatCharacters(number, number, Font, StyleFlag)
Formats some characters with the font setting.
formatCharacters(startIndex: number, length: number, font: Font, flag: StyleFlag) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| startIndex | number | The start index. |
| length | number | The length. |
| font | Font | The font setting. |
| flag | StyleFlag | The flag of the font setting. |
characters(number, number)
Returns a Characters object that represents a range of characters within the text.
characters(startIndex: number, length: number) : FontSetting;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| startIndex | number | The index of the start of the character. |
| length | number | The number of characters. |
Returns
Characters object.
Remarks
This method only works on shape with title.
getRichFormattings()
Returns all Characters objects that represents a range of characters within the text .
getRichFormattings() : FontSetting[];
Returns
All Characters objects
removeActiveXControl()
Remove activeX control.
removeActiveXControl() : void;
isSameSetting(object)
Returns whether the shape is same.
isSameSetting(obj: object) : boolean;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| obj | object |
getActualBox()
Get the actual position and size of the shape (after applying rotation, flip, etc.)
getActualBox() : number[];
Returns
Return the position and size in the order of x, y, w, h
Remarks
Note:The interface is not fully functional, especially the location information is not correct.It is recommended not to use this interface until the function is complete.