Example:
//Create a new Workbook $workbook = new cells\Workbook(); //Get the first worksheet in the workbook $sheet = $workbook->getWorksheets()->get(0); //Add a new label to the worksheet $label = $sheet->getShapes()->addShape(cells\MsoDrawingType::LABEL, 2, 0, 2, 0, 60, 120); //Set the caption of the label $label->setText("This is a Label"); //Set the Placement Type, the way the //label is attached to the cells $label->setPlacement(cells\PlacementType::FREE_FLOATING); //Set the fill color of the label $label->getFillFormat()->setForeColor(cells\Color::getYellow());
Property Getters/Setters Summary | ||
---|---|---|
function | getActualLowerRightRow() | |
Get the actual bottom row. | ||
function | getAlternativeText() | |
function | setAlternativeText(value) | |
Returns or sets the descriptive (alternative) text string of the |
||
function | getAnchorType() | |
function | setAnchorType(value) | |
Gets and set the shape anchor placeholder. The value of the property is ShapeAnchorType integer constant. | ||
function | getAutoShapeType() | |
function | setAutoShapeType(value) | |
Gets the auto shape type. The value of the property is AutoShapeType integer constant. | ||
function | getBottom() | |
function | setBottom(value) | |
Represents the width of the shape's vertical offset from its lower bottom corner row, in unit of pixels. | ||
function | getConnectionPoints() | |
Get the connection points | ||
function | getControlData() | |
Gets the data of control. | ||
function | getFill() | |
Returns a |
||
function | getFillFormat() | |
Returns a MsoFillFormat object that contains fill formatting properties for the specified shape. | ||
function | getFont() | |
function | setFont(value) | |
Represents the font of shape. | ||
function | getFormat() | |
Represents the setting of the shape's formatting. | ||
function | getFormatPicture() | |
Gets and sets the options of the picture format. | ||
function | getGeometry() | |
Gets the geometry | ||
function | getGlow() | |
Represents a object that specifies glow effect for the chart element or shape. | ||
function | getGroup() | |
Gets the group shape which contains this shape. | ||
function | hasLine() | |
function | setHasLine(value) | |
Gets and sets the line border of the shape is visible. | ||
function | getHeight() | |
function | setHeight(value) | |
Represents the height of shape, in unit of pixel. | ||
function | getHeightCM() | |
function | setHeightCM(value) | |
Represents the height of the shape, in unit of inches. | ||
function | getHeightInch() | |
function | setHeightInch(value) | |
Represents the height of the shape, in unit of inches. | ||
function | getHeightInChart() | |
function | setHeightInChart(value) | |
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.. | ||
function | getHeightInShape() | |
function | setHeightInShape(value) | |
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.. | ||
function | getHeightPt() | |
function | setHeightPt(value) | |
Represents the height of the shape, in unit of points. | ||
function | getHeightScale() | |
function | setHeightScale(value) | |
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; | ||
function | getHtmlText() | |
function | setHtmlText(value) | |
Gets and sets the html string which contains data and some formats in this textbox. | ||
function | getHyperlink() | |
Gets the hyperlink of the shape. | ||
function | getId() | |
Gets the identifier of this shape. | ||
function | getInputRange() | |
function | setInputRange(value) | |
Gets or sets the worksheet range used to fill the specified combo box. | ||
function | isEquation() | |
Indicates whether the shape only contains an equation. | ||
function | isFilled() | |
function | setFilled(value) | |
Indicates whether the fill format is visible. | ||
function | isFlippedHorizontally() | |
function | setFlippedHorizontally(value) | |
Gets and sets whether shape is horizontally flipped . | ||
function | isFlippedVertically() | |
function | setFlippedVertically(value) | |
Gets and sets whether shape is vertically flipped . | ||
function | isGroup() | |
Indicates whether the shape is a group. | ||
function | isHidden() | |
function | setHidden(value) | |
Indicates whether the object is visible. | ||
function | isLockAspectRatio() | |
function | setLockAspectRatio(value) | |
True means that don't allow changes in aspect ratio. | ||
function | isLocked() | |
function | setLocked(value) | |
True if the object is locked, False if the object can be modified when the sheet is protected. | ||
function | isPrintable() | |
function | setPrintable(value) | |
True if the object is printable | ||
function | isRichText() | |
Whether or not the text is rich text. | ||
function | isSmartArt() | |
Indicates whether the shape is smart art. | ||
function | isTextWrapped() | |
function | setTextWrapped(value) | |
Gets and sets the text wrapped type of the shape which contains text. | ||
function | isWordArt() | |
Indicates whether this shape is a word art. | ||
function | getLeft() | |
function | setLeft(value) | |
Represents the horizontal offset of shape from its left column, in unit of pixels. | ||
function | getLeftCM() | |
function | setLeftCM(value) | |
Represents the horizontal offset of shape from its left column, in unit of centimeters. | ||
function | getLeftInch() | |
function | setLeftInch(value) | |
Represents the horizontal offset of shape from its left column, in unit of inches. | ||
function | getLeftInChart() | |
function | setLeftInChart(value) | |
Represents the vertical offset of shape from the left border of the parent shape, in unit of 1/4000 of width of the parent shape. | ||
function | getLeftInShape() | |
function | setLeftInShape(value) | |
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. | ||
function | getLeftToCorner() | |
function | setLeftToCorner(value) | |
Gets and sets the horizonal offset of shape from worksheet left border. | ||
function | getLine() | |
Gets line style | ||
function | getLineFormat() | |
Returns a MsoLineFormat object that contains line formatting properties for the specified shape. | ||
function | getLinkedCell() | |
function | setLinkedCell(value) | |
Gets or sets the worksheet range linked to the control's value. | ||
function | getLowerDeltaX() | |
function | setLowerDeltaX(value) | |
Gets or sets the shape's horizontal offset from its lower right corner column.
|
||
function | getLowerDeltaY() | |
function | setLowerDeltaY(value) | |
Gets or sets the shape's vertical offset from its lower right corner row.
|
||
function | getLowerRightColumn() | |
function | setLowerRightColumn(value) | |
Represents lower right corner column index. | ||
function | getLowerRightRow() | |
function | setLowerRightRow(value) | |
Represents lower right corner row index. | ||
function | getMacroName() | |
function | setMacroName(value) | |
Gets and sets the name of macro. | ||
function | getMsoDrawingType() | |
Gets and sets mso drawing type. The value of the property is MsoDrawingType integer constant. | ||
function | getName() | |
function | setName(value) | |
Gets and sets the name of the shape. | ||
function | getPaths() | |
Gets the paths of a custom geometric shape. | ||
function | getPlacement() | |
function | setPlacement(value) | |
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. | ||
function | getPositionX() | |
function | setPositionX(value) | |
Gets and sets the horizonal offset of shape from worksheet left border,in unit of pixels. | ||
function | getPositionY() | |
function | setPositionY(value) | |
Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels. | ||
function | getReflection() | |
Represents a object that specifies reflection effect for the chart element or shape. | ||
function | getRelativeToOriginalPictureSize() | |
function | setRelativeToOriginalPictureSize(value) | |
Indicates whether shape is relative to original picture size. | ||
function | getRight() | |
function | setRight(value) | |
Represents the width of the shape's horizontal offset from its lower right corner column, in unit of pixels. | ||
function | getRotationAngle() | |
function | setRotationAngle(value) | |
Gets and sets the rotation of the shape. | ||
function | getShadowEffect() | |
Represents a object that specifies shadow effect for the chart element or shape. | ||
function | getSoftEdges() | |
function | setSoftEdges(value) | |
Gets and sets the radius of blur to apply to the edges, in unit of points. | ||
function | getSpid() | |
Specifies an optional string that an application can use to Identify the particular shape. | ||
function | getSpt() | |
Specifies an optional number that an application can use to associate the particular shape with a defined shape type. | ||
function | getText() | |
function | setText(value) | |
Represents the string in this TextBox object. | ||
function | getTextBody() | |
Gets and sets the setting of the shape's text. | ||
function | getTextDirection() | |
function | setTextDirection(value) | |
Gets/Sets the direction of the text flow for this object. The value of the property is TextDirectionType integer constant. | ||
function | getTextEffect() | |
Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to Shape objects that represent WordArt. | ||
function | getTextFrame() | |
Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape. | ||
function | getTextHorizontalAlignment() | |
function | setTextHorizontalAlignment(value) | |
Gets and sets the text horizontal alignment type of the shape. The value of the property is TextAlignmentType integer constant. | ||
function | getTextHorizontalOverflow() | |
function | setTextHorizontalOverflow(value) | |
Gets and sets the text horizontal overflow type of the shape which contains text. The value of the property is TextOverflowType integer constant. | ||
function | getTextOptions() | |
Represents the text options of the shape. | ||
function | getTextOrientationType() | |
function | setTextOrientationType(value) | |
Gets and sets the text orientation type of the shape. The value of the property is TextOrientationType integer constant. | ||
function | getTextShapeType() | |
function | setTextShapeType(value) | |
Gets and sets the preset text shape type. The value of the property is AutoShapeType integer constant. | ||
function | getTextVerticalAlignment() | |
function | setTextVerticalAlignment(value) | |
Gets and sets the text vertical alignment type of the shape. The value of the property is TextAlignmentType integer constant. | ||
function | getTextVerticalOverflow() | |
function | setTextVerticalOverflow(value) | |
Gets and sets the text vertical overflow type of the shape which contains text. The value of the property is TextOverflowType integer constant. | ||
function | getThreeDFormat() | |
Gets and sets 3d format of the shape. | ||
function | getTitle() | |
function | setTitle(value) | |
Specifies the title (caption) of the current shape object. | ||
function | getTop() | |
function | setTop(value) | |
Represents the vertical offset of shape from its top row, in unit of pixels. | ||
function | getTopCM() | |
function | setTopCM(value) | |
Represents the vertical offset of shape from its top row, in unit of centimeters. | ||
function | getTopInch() | |
function | setTopInch(value) | |
Represents the vertical offset of shape from its top row, in unit of inches. | ||
function | getTopInChart() | |
function | setTopInChart(value) | |
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. | ||
function | getTopInShape() | |
function | setTopInShape(value) | |
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. | ||
function | getTopToCorner() | |
function | setTopToCorner(value) | |
Gets and sets the vertical offset of shape from worksheet top border, in unit of pixels. | ||
function | getType() | |
Gets the auto shape type. The value of the property is AutoShapeType integer constant. | ||
function | getUpperDeltaX() | |
function | setUpperDeltaX(value) | |
Gets or sets the shape's horizontal offset from its upper left corner column.
|
||
function | getUpperDeltaY() | |
function | setUpperDeltaY(value) | |
Gets or sets the shape's vertical offset from its upper left corner row.
|
||
function | getUpperLeftColumn() | |
function | setUpperLeftColumn(value) | |
Represents upper left corner column index. | ||
function | getUpperLeftRow() | |
function | setUpperLeftRow(value) | |
Represents upper left corner row index. | ||
function | getWidth() | |
function | setWidth(value) | |
Represents the width of shape, in unit of pixels. | ||
function | getWidthCM() | |
function | setWidthCM(value) | |
Represents the width of the shape, in unit of centimeters. | ||
function | getWidthInch() | |
function | setWidthInch(value) | |
Represents the width of the shape, in unit of inch. | ||
function | getWidthInChart() | |
function | setWidthInChart(value) | |
Represents the width of the shape, in unit of 1/4000 of the parent shape. | ||
function | getWidthInShape() | |
function | setWidthInShape(value) | |
Represents the width of the shape, in unit of 1/4000 of the parent shape. | ||
function | getWidthPt() | |
function | setWidthPt(value) | |
Represents the width of the shape, in unit of point. | ||
function | getWidthScale() | |
function | setWidthScale(value) | |
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; | ||
function | getWorksheet() | |
Gets the |
||
function | getX() | |
function | setX(value) | |
Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels. | ||
function | getY() | |
function | setY(value) | |
Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels. | ||
function | getZOrderPosition() | |
function | setZOrderPosition(value) | |
Returns the position of a shape in the z-order. |
Method Summary | ||
---|---|---|
function | addHyperlink(address) | → inherited from Shape |
Adds a hyperlink to the shape. | ||
function | alignTopRightCorner(topRow, rightColumn) | → inherited from Shape |
Moves the picture to the top-right corner. | ||
function | calculateTextSize() | → inherited from Shape |
Recalculate the text area | ||
function | characters(startIndex, length) | → inherited from Shape |
Returns a Characters object that represents a range of characters within the text. | ||
function | formatCharacters(startIndex, length, font) | → inherited from Shape |
Formats some characters with the font setting. | ||
function | formatCharacters(startIndex, length, font, flag) | → inherited from Shape |
Formats some characters with the font setting. | ||
function | getCharacters() | → inherited from Shape |
Returns all Characters objects that represents a range of characters within the text . | ||
function | getInputRange(isR1C1, isLocal) | → inherited from Shape |
Gets the range used to fill the control. | ||
function | getLinkedCell(isR1C1, isLocal) | → inherited from Shape |
Gets the range linked to the control's value. | ||
function | getLockedProperty(type) | → inherited from Shape |
Gets the value of locked property. | ||
function | getResultOfSmartArt() | → inherited from Shape |
Converting smart art to grouped shapes. | ||
function | moveToRange(upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn) | → inherited from Shape |
Moves the shape to a specified range. | ||
function | removeActiveXControl() | → inherited from Shape |
Remove activeX control. | ||
function | removeHyperlink() | → inherited from Shape |
Remove the hyperlink of the shape. | ||
function | setInputRange(formula, isR1C1, isLocal) | → inherited from Shape |
Sets the range used to fill the control. | ||
function | setLinkedCell(formula, isR1C1, isLocal) | → inherited from Shape |
Sets the range linked to the control's value. | ||
function | setLockedProperty(type, value) | → inherited from Shape |
Set the locked property. | ||
function | toFrontOrBack(orders) | → inherited from Shape |
Brings the shape to the front or sends the shape to back. | ||
function | toImage(imageFile, options) | → inherited from Shape |
Saves the shape to a file. | ||
function | updateSelectedValue() | → inherited from Shape |
Update the selected value by the value of the linked cell. |
Property Getters/Setters Detail |
---|
getMacroName/setMacroName : String | |
function getMacroName() / function setMacroName(value) |
isEquation : boolean | |
function isEquation() |
isSmartArt : boolean | |
function isSmartArt() |
getZOrderPosition/setZOrderPosition : Number | |
function getZOrderPosition() / function setZOrderPosition(value) |
getName/setName : String | |
function getName() / function setName(value) |
getAlternativeText/setAlternativeText : String | |
function getAlternativeText() / function setAlternativeText(value) |
getTitle/setTitle : String | |
function getTitle() / function setTitle(value) |
getLineFormat : MsoLineFormat | |
function getLineFormat() |
getFillFormat : MsoFillFormat | |
function getFillFormat() |
getFormat : ShapeFormat | |
function getFormat() |
getLine : LineFormat | |
function getLine() |
getFill : FillFormat | |
function getFill() |
getShadowEffect : ShadowEffect | |
function getShadowEffect() |
getReflection : ReflectionEffect | |
function getReflection() |
getGlow : GlowEffect | |
function getGlow() |
getSoftEdges/setSoftEdges : Number | |
function getSoftEdges() / function setSoftEdges(value) |
getThreeDFormat : ThreeDFormat | |
function getThreeDFormat() |
getTextFrame : MsoTextFrame | |
function getTextFrame() |
getFormatPicture : MsoFormatPicture | |
function getFormatPicture() |
isHidden/setHidden : boolean | |
function isHidden() / function setHidden(value) |
isLockAspectRatio/setLockAspectRatio : boolean | |
function isLockAspectRatio() / function setLockAspectRatio(value) |
getRotationAngle/setRotationAngle : Number | |
function getRotationAngle() / function setRotationAngle(value) |
getHyperlink : Hyperlink | |
function getHyperlink() |
getId : Number | |
function getId() |
getSpid : String | |
function getSpid() |
getSpt : Number | |
function getSpt() |
getWorksheet : Worksheet | |
function getWorksheet() |
isGroup : boolean | |
function isGroup() |
isWordArt : boolean | |
function isWordArt() |
getTextEffect : TextEffectFormat | |
function getTextEffect() |
isLocked/setLocked : boolean | |
function isLocked() / function setLocked(value) |
isPrintable/setPrintable : boolean | |
function isPrintable() / function setPrintable(value) |
getMsoDrawingType : Number | |
function getMsoDrawingType() |
getAutoShapeType/setAutoShapeType : Number | |
function getAutoShapeType() / function setAutoShapeType(value) |
getAnchorType/setAnchorType : Number | |
function getAnchorType() / function setAnchorType(value) |
getPlacement/setPlacement : Number | |
function getPlacement() / function setPlacement(value) |
getUpperLeftRow/setUpperLeftRow : Number | |
function getUpperLeftRow() / function setUpperLeftRow(value) |
getUpperDeltaY/setUpperDeltaY : Number | |
function getUpperDeltaY() / function setUpperDeltaY(value) |
getUpperLeftColumn/setUpperLeftColumn : Number | |
function getUpperLeftColumn() / function setUpperLeftColumn(value) |
getUpperDeltaX/setUpperDeltaX : Number | |
function getUpperDeltaX() / function setUpperDeltaX(value) |
getLowerRightRow/setLowerRightRow : Number | |
function getLowerRightRow() / function setLowerRightRow(value) |
getLowerDeltaY/setLowerDeltaY : Number | |
function getLowerDeltaY() / function setLowerDeltaY(value) |
getLowerRightColumn/setLowerRightColumn : Number | |
function getLowerRightColumn() / function setLowerRightColumn(value) |
getLowerDeltaX/setLowerDeltaX : Number | |
function getLowerDeltaX() / function setLowerDeltaX(value) |
getRight/setRight : Number | |
function getRight() / function setRight(value) |
getBottom/setBottom : Number | |
function getBottom() / function setBottom(value) |
getWidth/setWidth : Number | |
function getWidth() / function setWidth(value) |
getWidthInch/setWidthInch : Number | |
function getWidthInch() / function setWidthInch(value) |
getWidthPt/setWidthPt : Number | |
function getWidthPt() / function setWidthPt(value) |
getWidthCM/setWidthCM : Number | |
function getWidthCM() / function setWidthCM(value) |
getHeight/setHeight : Number | |
function getHeight() / function setHeight(value) |
getHeightInch/setHeightInch : Number | |
function getHeightInch() / function setHeightInch(value) |
getHeightPt/setHeightPt : Number | |
function getHeightPt() / function setHeightPt(value) |
getHeightCM/setHeightCM : Number | |
function getHeightCM() / function setHeightCM(value) |
getLeft/setLeft : Number | |
function getLeft() / function setLeft(value) |
getLeftInch/setLeftInch : Number | |
function getLeftInch() / function setLeftInch(value) |
getLeftCM/setLeftCM : Number | |
function getLeftCM() / function setLeftCM(value) |
getTop/setTop : Number | |
function getTop() / function setTop(value) |
getTopInch/setTopInch : Number | |
function getTopInch() / function setTopInch(value) |
getTopCM/setTopCM : Number | |
function getTopCM() / function setTopCM(value) |
getTopToCorner/setTopToCorner : Number | |
function getTopToCorner() / function setTopToCorner(value) |
getLeftToCorner/setLeftToCorner : Number | |
function getLeftToCorner() / function setLeftToCorner(value) |
getX/setX : Number | |
function getX() / function setX(value) |
getY/setY : Number | |
function getY() / function setY(value) |
getWidthScale/setWidthScale : Number | |
function getWidthScale() / function setWidthScale(value) |
getHeightScale/setHeightScale : Number | |
function getHeightScale() / function setHeightScale(value) |
getTopInShape/setTopInShape : Number | |
function getTopInShape() / function setTopInShape(value) |
getLeftInShape/setLeftInShape : Number | |
function getLeftInShape() / function setLeftInShape(value) |
getWidthInShape/setWidthInShape : Number | |
function getWidthInShape() / function setWidthInShape(value) |
getHeightInShape/setHeightInShape : Number | |
function getHeightInShape() / function setHeightInShape(value) |
getHeightInChart/setHeightInChart : Number | |
function getHeightInChart() / function setHeightInChart(value) |
getLeftInChart/setLeftInChart : Number | |
function getLeftInChart() / function setLeftInChart(value) |
getTopInChart/setTopInChart : Number | |
function getTopInChart() / function setTopInChart(value) |
getWidthInChart/setWidthInChart : Number | |
function getWidthInChart() / function setWidthInChart(value) |
getPositionX/setPositionX : Number | |
function getPositionX() / function setPositionX(value) |
getPositionY/setPositionY : Number | |
function getPositionY() / function setPositionY(value) |
getGroup : GroupShape | |
function getGroup() |
getType : Number | |
function getType() |
hasLine/setHasLine : boolean | |
function hasLine() / function setHasLine(value) |
isFilled/setFilled : boolean | |
function isFilled() / function setFilled(value) |
isFlippedHorizontally/setFlippedHorizontally : boolean | |
function isFlippedHorizontally() / function setFlippedHorizontally(value) |
isFlippedVertically/setFlippedVertically : boolean | |
function isFlippedVertically() / function setFlippedVertically(value) |
getActualLowerRightRow : Number | |
function getActualLowerRightRow() |
getConnectionPoints : Float[] | |
function getConnectionPoints() |
getRelativeToOriginalPictureSize/setRelativeToOriginalPictureSize : boolean | |
function getRelativeToOriginalPictureSize() / function setRelativeToOriginalPictureSize(value) |
getLinkedCell/setLinkedCell : String | |
function getLinkedCell() / function setLinkedCell(value) |
getInputRange/setInputRange : String | |
function getInputRange() / function setInputRange(value) |
getTextShapeType/setTextShapeType : Number | |
function getTextShapeType() / function setTextShapeType(value) |
getTextBody : FontSettingCollection | |
function getTextBody() |
getFont/setFont : Font | |
function getFont() / function setFont(value) |
getTextOptions : TextOptions | |
function getTextOptions() |
getText/setText : String | |
function getText() / function setText(value) |
isRichText : boolean | |
function isRichText() |
getHtmlText/setHtmlText : String | |
function getHtmlText() / function setHtmlText(value) |
getTextVerticalOverflow/setTextVerticalOverflow : Number | |
function getTextVerticalOverflow() / function setTextVerticalOverflow(value) |
getTextHorizontalOverflow/setTextHorizontalOverflow : Number | |
function getTextHorizontalOverflow() / function setTextHorizontalOverflow(value) |
isTextWrapped/setTextWrapped : boolean | |
function isTextWrapped() / function setTextWrapped(value) |
getTextOrientationType/setTextOrientationType : Number | |
function getTextOrientationType() / function setTextOrientationType(value) |
getTextHorizontalAlignment/setTextHorizontalAlignment : Number | |
function getTextHorizontalAlignment() / function setTextHorizontalAlignment(value) |
getTextVerticalAlignment/setTextVerticalAlignment : Number | |
function getTextVerticalAlignment() / function setTextVerticalAlignment(value) |
getTextDirection/setTextDirection : Number | |
function getTextDirection() / function setTextDirection(value) |
getControlData : byte[] | |
function getControlData() |
getPaths : ShapePathCollection | |
function getPaths() |
getGeometry : Geometry | |
function getGeometry() |
Method Detail |
---|
getLinkedCell | |
function getLinkedCell(isR1C1, isLocal) |
isR1C1: boolean
- Whether the formula needs to be formatted as R1C1.isLocal: boolean
- Whether the formula needs to be formatted by locale.setLinkedCell | |
function setLinkedCell(formula, isR1C1, isLocal) |
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 | |
function getInputRange(isR1C1, isLocal) |
isR1C1: boolean
- Whether the formula needs to be formatted as R1C1.isLocal: boolean
- Whether the formula needs to be formatted by locale.setInputRange | |
function setInputRange(formula, isR1C1, isLocal) |
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 | |
function updateSelectedValue() |
calculateTextSize | |
function calculateTextSize() |
formatCharacters | |
function formatCharacters(startIndex, length, font, flag) |
startIndex: Number
- The start index.length: Number
- The length.font: Font
- The font setting.flag: StyleFlag
- The flag of the font setting.formatCharacters | |
function formatCharacters(startIndex, length, font) |
startIndex: Number
- The start index.length: Number
- The length.font: Font
- The font setting.characters | |
function characters(startIndex, length) |
startIndex: Number
- The index of the start of the character.length: Number
- The number of characters.getCharacters | |
function getCharacters() |
removeActiveXControl | |
function removeActiveXControl() |
toImage | |
function toImage(imageFile, options) |
getResultOfSmartArt | |
function getResultOfSmartArt() |
toFrontOrBack | |
function toFrontOrBack(orders) |
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 | |
function getLockedProperty(type) |
type: Number
- A setLockedProperty | |
function setLockedProperty(type, value) |
type: Number
- A value: boolean
- The value of the property.addHyperlink | |
function addHyperlink(address) |
address: String
- Address of the hyperlink.removeHyperlink | |
function removeHyperlink() |
moveToRange | |
function moveToRange(upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn) |
upperLeftRow: Number
- Upper left row index.upperLeftColumn: Number
- Upper left column index.lowerRightRow: Number
- Lower right row indexlowerRightColumn: Number
- Lower right column indexalignTopRightCorner | |
function alignTopRightCorner(topRow, rightColumn) |
topRow: Number
- the row index.rightColumn: Number
- the column index.