Picture

Picture class

Encapsulates the object that represents a single picture in a spreadsheet.

Properties

Name	Type	Description
IsPlacedInCell	boolean
OriginalHeight	Number	Gets the original height of the picture.
OriginalWidth	Number	Gets the original width of the picture.
BorderLineColor	Color	Represents the com.aspose.cells.Color of the border line of a picture.
BorderWeight	Number	Gets or sets the weight of the border line of a picture in units of pt.
Data	byte[]	Gets the data of the picture.
SourceFullName	String	Gets or sets the path and name of the source file for the linked image. The default value is an empty string. If SourceF
Formula	String	Gets and sets the data of the formula.
IsAutoSize	boolean	True indicates that the size of the ole object will be auto changed as the size of snapshot of the embedded content when
IsLink	boolean	Returns true if the picture is linked to a file.
IsDynamicDataExchange	boolean	Gets or sets whether dynamic data exchange
DisplayAsIcon	boolean	True if the specified object is displayed as an icon and the image will not be auto changed.
ImageType	Number	Gets the image format of the picture. The value of the property is ImageType integer constant.
OriginalHeightCM	Number	Gets the original height of picture, in unit of centimeters.
OriginalWidthCM	Number	Gets the original width of picture, in unit of centimeters.
OriginalHeightInch	Number	Gets the original height of picture, in unit of inches.
OriginalWidthInch	Number	Gets the original width of picture, in unit of inches.
SignatureLine	SignatureLine	Gets and sets the signature line
MacroName	String	Gets and sets the name of macro.
IsEquation	boolean	Indicates whether the shape only contains an equation.
IsSmartArt	boolean	Indicates whether the shape is a smart art. Only for ooxml file.
ZOrderPosition	Number	Returns the position of a shape in the z-order.
Name	String	Gets and sets the name of the shape.
AlternativeText	String	Returns or sets the descriptive (alternative) text string of the Shape object.
Title	String	Specifies the title (caption) of the current shape object.
LineFormat	MsoLineFormat	Returns a MsoLineFormat object that contains line formatting properties for the specified shape. NOTE: This member is no
FillFormat	MsoFillFormat	Returns a MsoFillFormat object that contains fill formatting properties for the specified shape. NOTE: This member is no
Line	LineFormat	Gets line style
Fill	FillFormat	Returns a FillFormat object that contains fill formatting properties for the specified shape.
ShadowEffect	ShadowEffect	Represents a ShadowEffect object that specifies shadow effect for the chart element or shape.
Reflection	ReflectionEffect	Represents a ReflectionEffect object that specifies reflection effect for the chart element or shape.
Glow	GlowEffect	Represents a GlowEffect object that specifies glow effect for the chart element or shape.
SoftEdges	Number	Gets and sets the radius of blur to apply to the edges, in unit of points.
ThreeDFormat	ThreeDFormat	Gets and sets 3d format of the shape.
FormatPicture	MsoFormatPicture	Gets and sets the options of the picture format.
IsHidden	boolean	Indicates whether the object is visible.
IsLockAspectRatio	boolean	True means that aspect ratio of the shape is locked. Only for pictures and Ole Objects. NOTE: This member is now obsolet
IsAspectRatioLocked	boolean	True means that aspect ratio of the shape is locked. Only for pictures and Ole Objects.
RotationAngle	Number	Gets and sets the rotation of the shape.
Hyperlink	Hyperlink	Gets the hyperlink of the shape.
Id	Number	Gets the identifier of this shape.
Spid	String	Specifies an optional string identifier that an application can use to identify the particular shape.
Spt	Number	Specifies an optional number that an application can use to associate the particular shape with a defined shape type.
Worksheet	Worksheet	Gets the Worksheet object which contains this shape.
IsGroup	boolean	Indicates whether this shape is a group shape.
IsInGroup	boolean	Indicates whether the shape is grouped.
IsWordArt	boolean	Indicates whether this shape is a word art. Only for the Legacy Shape of xls file.
TextEffect	TextEffectFormat	Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to Sh
IsLocked	boolean	True means the object can not be modified when the sheet is protected. Note that this value is meaningful only if the wo
IsPrintable	boolean	Indicates whether the object is printable. If False, this shape will not be printed when printing.
MsoDrawingType	Number	Gets drawing type. The value of the property is MsoDrawingType integer constant.
AutoShapeType	Number	Gets and sets the auto shape type. The value of the property is AutoShapeType integer constant.
AnchorType	Number	Gets and set the type of the shape anchor placeholder. The value of the property is ShapeAnchorType integer constant.
Placement	Number	Represents the way the drawing object is attached to the cells below it. The property controls the placement of an objec
UpperLeftRow	Number	Represents the top row index. If the shape is in the shape or in the group , UpperLeftRow will be ignored.
UpperDeltaY	Number	Gets or sets the shape’s vertical offset from its upper left corner row. The range of value is 0 to 256.
UpperLeftColumn	Number	Represents upper left corner column index.
UpperDeltaX	Number	Gets or sets the shape’s horizontal offset from its upper left corner column. The range of value is 0 to 1024.
LowerRightRow	Number	Represents lower right corner row index.
LowerDeltaY	Number	Gets or sets the shape’s vertical offset from its lower right corner row. The range of value is 0 to 256.
LowerRightColumn	Number	Represents lower right corner column index.
LowerDeltaX	Number	Gets or sets the shape’s horizontal offset from its lower right corner column. The range of value is 0 to 1024.
Right	Number	Represents the width of the shape’s horizontal offset from its lower right corner column, in unit of pixels.
Bottom	Number	Represents the width of the shape’s vertical offset from its lower bottom corner row, in unit of pixels.
Width	Number	Represents the width of shape, in unit of pixels.
WidthInch	Number	Represents the width of the shape, in unit of inch.
WidthPt	Number	Represents the width of the shape, in unit of point.
WidthCM	Number	Represents the width of the shape, in unit of centimeters.
Height	Number	Represents the height of shape, in unit of pixel.
HeightInch	Number	Represents the height of the shape, in unit of inches.
HeightPt	Number	Represents the height of the shape, in unit of points.
HeightCM	Number	Represents the height of the shape, in unit of centimeters.
Left	Number	Represents the horizontal offset of shape from its left column, in unit of pixels.
LeftInch	Number	Represents the horizontal offset of shape from its left column, in unit of inches.
LeftCM	Number	Represents the horizontal offset of shape from its left column, in unit of centimeters.
Top	Number	Represents the vertical offset of shape from its top row, in unit of pixels. If the shape is in the chart, represents th
TopInch	Number	Represents the vertical offset of shape from its top row, in unit of inches.
TopCM	Number	Represents the vertical offset of shape from its top row, in unit of centimeters.
TopToCorner	Number	Gets and sets the vertical offset of shape from worksheet top border, in unit of pixels.
LeftToCorner	Number	Gets and sets the horizonal offset of shape from worksheet left border.
X	Number	Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels.
Y	Number	Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels.
WidthScale	Number	Gets and sets the width scale, in unit of percent of the original picture width. If the shape is not picture ,the WidthS
HeightScale	Number	Gets and sets the height scale,in unit of percent of the original picture height. If the shape is not picture ,the Heigh
TopInShape	Number	Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the pare
LeftInShape	Number	Represents the horizontal offset of shape from the left border of the parent shape, in unit of 1/4000 of width of the pa
WidthInShape	Number	Represents the width of the shape, in unit of 1/4000 of the parent shape. Only Applies when this shape in the group or c
HeightInShape	Number	Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the pare
Group	GroupShape	Gets the group shape which contains this shape.
Type	Number	Gets the auto shape type. The value of the property is AutoShapeType integer constant.
HasLine	boolean	Gets and sets the line border of the shape is visible.
IsFilled	boolean	Indicates whether the fill format is visible.
IsFlippedHorizontally	boolean	Gets and sets whether shape is horizontally flipped .
IsFlippedVertically	boolean	Gets and sets whether shape is vertically flipped .
ActualLowerRightRow	Number	Get the actual bottom row.
RelativeToOriginalPictureSize	boolean	Indicates whether shape is relative to original picture size.
LinkedCell	String	Gets or sets the worksheet range linked to the control’s value.
InputRange	String	Gets or sets the worksheet range used to fill the specified combo box.
TextShapeType	Number	Gets and sets the preset text shape type. The value of the property is AutoShapeType integer constant.
TextBody	FontSettingCollection	Gets and sets the setting of the shape’s text.
Font	Font	Represents the font of shape.
TextOptions	TextOptions	Represents the text options of the shape.
Text	String	Gets and sets the text of this shape.
IsRichText	boolean	Whether or not the text is rich text.
HtmlText	String	Gets and sets the html string which contains data and some formats in this textbox.
TextVerticalOverflow	Number	Gets and sets the text vertical overflow type of the shape which contains text. The value of the property is TextOverflo
TextHorizontalOverflow	Number	Gets and sets the text horizontal overflow type of the shape which contains text. The value of the property is TextOverf
IsTextWrapped	boolean	Gets and sets the text wrapped type of the shape which contains text.
TextOrientationType	Number	Gets and sets the text orientation type of the shape. The value of the property is TextOrientationType integer constant.
TextHorizontalAlignment	Number	Gets and sets the text horizontal alignment type of the shape. The value of the property is TextAlignmentType integer co
TextVerticalAlignment	Number	Gets and sets the text vertical alignment type of the shape. The value of the property is TextAlignmentType integer cons
TextDirection	Number	Gets/Sets the direction of the text flow for this object. The value of the property is TextDirectionType integer constan
TextBoxOptions	TextBoxOptions
ControlData	byte[]	Gets the data of control.
Paths	ShapePathCollection	Gets the paths of a custom geometric shape.
Geometry	Geometry	Gets the geometry
CreateId	UUID	Gets and sets create id for this shape.
IsDecorative	boolean	Indicates whether the object is decorative.

Methods

Name	Description
copy	Copy the picture.
move	Moves the picture to a specified location.
placeInCell	Place this picture in the cell
isSameSetting	Returns whether the shape is same.
getLinkedCell	Gets the range linked to the control’s value.
setLinkedCell	Sets the range linked to the control’s value.
getInputRange	Gets the range used to fill the control.
setInputRange	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	Formats some characters with the font setting.
characters	Returns a Characters object that represents a range of characters within the text.

This method only works on shape with | | getCharacters | Returns all Characters objects that represents a range of characters within the text .

Picture.IsPlacedInCell property

Type: boolean

Picture.OriginalHeight property

Gets the original height of the picture.

Type: Number

Picture.OriginalWidth property

Gets the original width of the picture.

Type: Number

Picture.BorderLineColor property

Represents the com.aspose.cells.Color of the border line of a picture.

Type: Color

Picture.BorderWeight property

Gets or sets the weight of the border line of a picture in units of pt.

Type: Number

Picture.Data property

Gets the data of the picture.

Type: byte[]

Picture.SourceFullName property

Gets or sets the path and name of the source file for the linked image. The default value is an empty string. If SourceFullName is not an empty string, the image is linked. If SourceFullName is not an empty string, but Data is null, then the image is linked and not stored in the file.

Type: String

Picture.Formula property

Gets and sets the data of the formula.

Type: String

Picture.IsAutoSize property

True indicates that the size of the ole object will be auto changed as the size of snapshot of the embedded content when the ole object is activated.

Type: boolean

Picture.IsLink property

Returns true if the picture is linked to a file.

Type: boolean

Picture.IsDynamicDataExchange property

Gets or sets whether dynamic data exchange

Type: boolean

Picture.DisplayAsIcon property

True if the specified object is displayed as an icon and the image will not be auto changed.

Type: boolean

Picture.ImageType property

Gets the image format of the picture. The value of the property is ImageType integer constant.

Type: Number

Picture.OriginalHeightCM property

Gets the original height of picture, in unit of centimeters.

Type: Number

Picture.OriginalWidthCM property

Gets the original width of picture, in unit of centimeters.

Type: Number

Picture.OriginalHeightInch property

Gets the original height of picture, in unit of inches.

Type: Number

Picture.OriginalWidthInch property

Gets the original width of picture, in unit of inches.

Type: Number

Picture.SignatureLine property

Gets and sets the signature line

Type: SignatureLine

Picture.MacroName property

Gets and sets the name of macro.

Type: String

Picture.IsEquation property

Indicates whether the shape only contains an equation.

Type: boolean

Picture.IsSmartArt property

Indicates whether the shape is a smart art. Only for ooxml file.

Type: boolean

Picture.ZOrderPosition property

Returns the position of a shape in the z-order.

Type: Number

Picture.Name property

Gets and sets the name of the shape.

Type: String

Picture.AlternativeText property

Returns or sets the descriptive (alternative) text string of the Shape object.

Type: String

Picture.Title property

Specifies the title (caption) of the current shape object.

Type: String

Picture.LineFormat property

Returns a MsoLineFormat object that contains line formatting properties for the specified shape. NOTE: This member is now obsolete. Instead, please use Shape.Line property. This property will be removed 12 months later since July 2016. Aspose apologizes for any inconvenience you may have experienced.

Type: MsoLineFormat

Picture.FillFormat property

Returns a MsoFillFormat object that contains fill formatting properties for the specified shape. NOTE: This member is now obsolete. Instead, please use Shape.Fill property. This property will be removed 12 months later since July 2016. Aspose apologizes for any inconvenience you may have experienced.

Type: MsoFillFormat

Picture.Line property

Gets line style

Type: LineFormat

Picture.Fill property

Returns a FillFormat object that contains fill formatting properties for the specified shape.

Type: FillFormat

Picture.ShadowEffect property

Represents a ShadowEffect object that specifies shadow effect for the chart element or shape.

Type: ShadowEffect

Picture.Reflection property

Represents a ReflectionEffect object that specifies reflection effect for the chart element or shape.

Type: ReflectionEffect

Picture.Glow property

Represents a GlowEffect object that specifies glow effect for the chart element or shape.

Type: GlowEffect

Picture.SoftEdges property

Gets and sets the radius of blur to apply to the edges, in unit of points.

Type: Number

Picture.ThreeDFormat property

Gets and sets 3d format of the shape.

Type: ThreeDFormat

Picture.FormatPicture property

Gets and sets the options of the picture format.

Type: MsoFormatPicture

Picture.IsHidden property

Indicates whether the object is visible.

Type: boolean

Picture.IsLockAspectRatio property

True means that aspect ratio of the shape is locked. 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.

Type: boolean

Picture.IsAspectRatioLocked property

True means that aspect ratio of the shape is locked. Only for pictures and Ole Objects.

Type: boolean

Picture.RotationAngle property

Gets and sets the rotation of the shape.

Type: Number

Picture.Hyperlink property

Gets the hyperlink of the shape.

Type: Hyperlink

Picture.Id property

Gets the identifier of this shape.

Type: Number

Picture.Spid property

Specifies an optional string identifier that an application can use to identify the particular shape.

Type: String

Picture.Spt property

Specifies an optional number that an application can use to associate the particular shape with a defined shape type.

Type: Number

Picture.Worksheet property

Gets the Worksheet object which contains this shape.

Type: Worksheet

Picture.IsGroup property

Indicates whether this shape is a group shape.

Type: boolean

Picture.IsInGroup property

Indicates whether the shape is grouped.

Type: boolean

Picture.IsWordArt property

Indicates whether this shape is a word art. Only for the Legacy Shape of xls file.

Type: boolean

Picture.TextEffect property

Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to Shape objects that represent WordArt.

Type: TextEffectFormat

Picture.IsLocked property

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.

Type: boolean

Picture.IsPrintable property

Indicates whether the object is printable. If False, this shape will not be printed when printing.

Type: boolean

Picture.MsoDrawingType property

Gets drawing type. The value of the property is MsoDrawingType integer constant.

Type: Number

Picture.AutoShapeType property

Gets and sets the auto shape type. The value of the property is AutoShapeType integer constant.

Type: Number

Picture.AnchorType property

Gets and set the type of the shape anchor placeholder. The value of the property is ShapeAnchorType integer constant.

Type: Number

Picture.Placement property

Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet. The value of the property is PlacementType integer constant.

Type: Number

Picture.UpperLeftRow property

Represents the top row index. If the shape is in the shape or in the group , UpperLeftRow will be ignored.

Type: Number

Picture.UpperDeltaY property

Gets or sets the shape’s vertical offset from its upper left corner row. The range of value is 0 to 256.

Type: Number

Picture.UpperLeftColumn property

Represents upper left corner column index.

Type: Number

Picture.UpperDeltaX property

Gets or sets the shape’s horizontal offset from its upper left corner column. The range of value is 0 to 1024.

Type: Number

Picture.LowerRightRow property

Represents lower right corner row index.

Type: Number

Picture.LowerDeltaY property

Gets or sets the shape’s vertical offset from its lower right corner row. The range of value is 0 to 256.

Type: Number

Picture.LowerRightColumn property

Represents lower right corner column index.

Type: Number

Picture.LowerDeltaX property

Gets or sets the shape’s horizontal offset from its lower right corner column. The range of value is 0 to 1024.

Type: Number

Picture.Right property

Represents the width of the shape’s horizontal offset from its lower right corner column, in unit of pixels.

Type: Number

Picture.Bottom property

Represents the width of the shape’s vertical offset from its lower bottom corner row, in unit of pixels.

Type: Number

Picture.Width property

Represents the width of shape, in unit of pixels.

Type: Number

Picture.WidthInch property

Represents the width of the shape, in unit of inch.

Type: Number

Picture.WidthPt property

Represents the width of the shape, in unit of point.

Type: Number

Picture.WidthCM property

Represents the width of the shape, in unit of centimeters.

Type: Number

Picture.Height property

Represents the height of shape, in unit of pixel.

Type: Number

Picture.HeightInch property

Represents the height of the shape, in unit of inches.

Type: Number

Picture.HeightPt property

Represents the height of the shape, in unit of points.

Type: Number

Picture.HeightCM property

Represents the height of the shape, in unit of centimeters.

Type: Number

Picture.Left property

Represents the horizontal offset of shape from its left column, in unit of pixels.

Type: Number

Picture.LeftInch property

Represents the horizontal offset of shape from its left column, in unit of inches.

Type: Number

Picture.LeftCM property

Represents the horizontal offset of shape from its left column, in unit of centimeters.

Type: Number

Picture.Top property

Represents the vertical offset of shape from its top row, in unit of pixels. If the shape is in the chart, represents the vertical offset of shape from its top border.

Type: Number

Picture.TopInch property

Represents the vertical offset of shape from its top row, in unit of inches.

Type: Number

Picture.TopCM property

Represents the vertical offset of shape from its top row, in unit of centimeters.

Type: Number

Picture.TopToCorner property

Gets and sets the vertical offset of shape from worksheet top border, in unit of pixels.

Type: Number

Picture.LeftToCorner property

Gets and sets the horizonal offset of shape from worksheet left border.

Type: Number

Picture.X property

Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels.

Type: Number

Picture.Y property

Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels.

Type: Number

Picture.WidthScale property

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;

Type: Number

Picture.HeightScale property

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;

Type: Number

Picture.TopInShape property

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. Only Applies when this shape in the group or chart.

Type: Number

Picture.LeftInShape property

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. Only Applies when this shape in the group or chart.

Type: Number

Picture.WidthInShape property

Represents the width of the shape, in unit of 1/4000 of the parent shape. Only Applies when this shape in the group or chart.

Type: Number

Picture.HeightInShape property

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.. Only Applies when this shape in the group or chart.

Type: Number

Picture.Group property

Gets the group shape which contains this shape.

Type: GroupShape

Picture.Type property

Gets the auto shape type. The value of the property is AutoShapeType integer constant.

Type: Number

Picture.HasLine property

Gets and sets the line border of the shape is visible.

Type: boolean

Picture.IsFilled property

Indicates whether the fill format is visible.

Type: boolean

Picture.IsFlippedHorizontally property

Gets and sets whether shape is horizontally flipped .

Type: boolean

Picture.IsFlippedVertically property

Gets and sets whether shape is vertically flipped .

Type: boolean

Picture.ActualLowerRightRow property

Get the actual bottom row.

Type: Number

Picture.RelativeToOriginalPictureSize property

Indicates whether shape is relative to original picture size.

Type: boolean

Picture.LinkedCell property

Gets or sets the worksheet range linked to the control’s value.

Type: String

Picture.InputRange property

Gets or sets the worksheet range used to fill the specified combo box.

Type: String

Picture.TextShapeType property

Gets and sets the preset text shape type. The value of the property is AutoShapeType integer constant.

Type: Number

Picture.TextBody property

Gets and sets the setting of the shape’s text.

Type: FontSettingCollection

Picture.Font property

Represents the font of shape.

Type: Font

Picture.TextOptions property

Represents the text options of the shape.

Type: TextOptions

Picture.Text property

Gets and sets the text of this shape.

Type: String

Picture.IsRichText property

Whether or not the text is rich text.

Type: boolean

Picture.HtmlText property

Gets and sets the html string which contains data and some formats in this textbox.

Type: String

Picture.TextVerticalOverflow property

Gets and sets the text vertical overflow type of the shape which contains text. The value of the property is TextOverflowType integer constant.

Type: Number

Picture.TextHorizontalOverflow property

Gets and sets the text horizontal overflow type of the shape which contains text. The value of the property is TextOverflowType integer constant.

Type: Number

Picture.IsTextWrapped property

Gets and sets the text wrapped type of the shape which contains text.

Type: boolean

Picture.TextOrientationType property

Gets and sets the text orientation type of the shape. The value of the property is TextOrientationType integer constant.

Type: Number

Picture.TextHorizontalAlignment property

Gets and sets the text horizontal alignment type of the shape. The value of the property is TextAlignmentType integer constant.

Type: Number

Picture.TextVerticalAlignment property

Gets and sets the text vertical alignment type of the shape. The value of the property is TextAlignmentType integer constant.

Type: Number

Picture.TextDirection property

Gets/Sets the direction of the text flow for this object. The value of the property is TextDirectionType integer constant.

Type: Number

Picture.TextBoxOptions property

Type: TextBoxOptions

Picture.ControlData property

Gets the data of control.

Type: byte[]

Picture.Paths property

Gets the paths of a custom geometric shape.

Type: ShapePathCollection

Picture.Geometry property

Gets the geometry

Type: Geometry

Picture.CreateId property

Gets and sets create id for this shape.

Type: UUID

Picture.IsDecorative property

Indicates whether the object is decorative.

Type: boolean

copy(source, options)

Copy the picture.

Parameter	Type	Description
source	Picture	The source picture.
options	CopyOptions	The copy options.

move(topRow, leftColumn)

Moves the picture to a specified location.

Parameter	Type	Description
upperLeftRow		Upper left row index.
upperLeftColumn		Upper left column index.

placeInCell()

Place this picture in the cell

isSameSetting(obj)

Returns whether the shape is same.

Parameter	Type	Description
obj	Object

getLinkedCell(isR1C1, isLocal)

Gets the range linked to the control’s value.

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(formula, isR1C1, isLocal)

Sets the range linked to the control’s value.

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(isR1C1, isLocal)

Gets the range used to fill the control.

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(formula, isR1C1, isLocal)

Sets the range used to fill the control.

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.

calculateTextSize()

Recalculate the text area

Returns: Text’s Size in an array(width and height).

formatCharacters(startIndex, length, font, flag)

Formats some characters with the font setting.

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(startIndex, length)

Returns a Characters object that represents a range of characters within the text.

This method only works on shape with title.

Parameter	Type	Description
startIndex	Number	The index of the start of the character.
length	Number	The number of characters.

Returns: Characters object.

getCharacters()

Returns all Characters objects that represents a range of characters within the text .

NOTE: This method is now obsolete. Instead, please use Shape.GetRichFormattings() method. This method will be removed 12 months later since November 2023. Aspose apologizes for any inconvenience you may have experienced.

Returns: All Characters objects

getRichFormattings()

Returns all Characters objects that represents a range of characters within the text .

Returns: All Characters objects

removeActiveXControl()

Remove activeX control.

getActualBox()

Get the actual position and size of the shape (after applying rotation, flip, etc.)

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.

Returns: Return the position and size in the order of x, y, w, h

fitToTextSize()

getConnectionPoints()

Get the connection points

Returns: [X,Y] pairs of the connection point. Every item is a float[2] array, [0] represents x and [1] represents y.

toImage(imageFile, options)

Saves the shape to a file.

getResultOfSmartArt()

Converting smart art to grouped shapes.

toFrontOrBack(orders)

Brings the shape to the front or sends the shape to back.

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(type)

Gets the value of locked property.

Parameter	Type	Description
type	Number	A ShapeLockType value. The type of the shape locked property.

Returns: Returns the value of locked property.

setLockedProperty(type, value)

Set the locked property.

Parameter	Type	Description
type	Number	A ShapeLockType value. The locked type.
value	boolean	The value of the property.

addHyperlink(address)

Adds a hyperlink to the shape.

Parameter	Type	Description
address	String	Address of the hyperlink.

Returns: Return the new hyperlink object.

removeHyperlink()

Removes the hyperlink of the shape.

moveToRange(topRow, leftColumn, bottomRow, rightColumn)

Moves the shape to a specified range.

Parameter	Type	Description
upperLeftRow		Upper left row index.
upperLeftColumn		Upper left column index.
lowerRightRow		Lower right row index
lowerRightColumn		Lower right column index

alignTopRightCorner(topRow, rightColumn)

Moves the picture to the top-right corner.

Parameter	Type	Description
topRow	Number	the row index.
rightColumn	Number	the column index.

PicFormatOption Class PictureBulletValue Class