com.aspose.cells

Classes

Interfaces

Constants

com.aspose.cells

Class ComboBox

java.lang.Object
- Shape
- - com.aspose.cells.ComboBox

public class ComboBox extends Shape

Represents the control form ComboBox.

Example:

//Create a new Workbook.        
Workbook workbook = new Workbook();

//Get the first worksheet.
Worksheet sheet = workbook.getWorksheets().get(0);

//Get the worksheet cells collection.
Cells cells = sheet.getCells();

//Input a value.
cells.get("B3").putValue("Employee:");

Cell cell = cells.get("B3");
Style style = cell.getStyle();
//Set it bold.
style.getFont().setBold(true);
cell.setStyle(style);

//Input some values that denote the input range
//for the combo box.
cells.get("A2").putValue("Emp001");
cells.get("A3").putValue("Emp002");
cells.get("A4").putValue("Emp003");
cells.get("A5").putValue("Emp004");
cells.get("A6").putValue("Emp005");
cells.get("A7").putValue("Emp006");

//Add a new combo box.
ComboBox comboBox = (ComboBox)sheet.getShapes().addShape(MsoDrawingType.COMBO_BOX, 2, 0, 2, 0, 22, 100);

//Set the linked cell;
comboBox.setLinkedCell("A1");

//Set the input range.
comboBox.setInputRange("A2:A7");

//Set no. of list lines displayed in the combo 
//box's list portion.
comboBox.setDropDownLines(5);

//Set the combo box with 3-D shading.
comboBox.setShadow(true);

//AutoFit Columns
sheet.autoFitColumns();

//Saves the file.
workbook.save("d:\\test\\tstcombobox.xls");

Property Getters/Setters Summary
`ActiveXControl`	`getActiveXControl()`
	Gets the ActiveX control.
`int`	`getActualLowerRightRow()`
	Get the actual bottom row.
`java.lang.String`	`getAlternativeText()`
`void`	`setAlternativeText(java.lang.Stringvalue)`
	Returns or sets the descriptive (alternative) text string of the Shape object.
`int`	`getAutoShapeType()`
`void`	`setAutoShapeType(intvalue)`
	Gets the auto shape type. The value of the property is AutoShapeType integer constant.
`int`	`getBottom()`
`void`	`setBottom(intvalue)`
	Represents the width of the shape's vertical offset from its lower bottom corner row, in unit of pixels.
`java.awt.geom.Point2D.Float[]`	`getConnectionPoints()`
	Get the connection points
`byte[]`	`getControlData()`
	Gets the data of control.
`int`	`getDropDownLines()`
`void`	`setDropDownLines(intvalue)`
	Gets or sets the number of list lines displayed in the drop-down portion of a combo box.
`FillFormat`	`getFill()`
	Returns a FillFormat object that contains fill formatting properties for the specified shape.
`MsoFillFormat`	`getFillFormat()`
	Returns a MsoFillFormat object that contains fill formatting properties for the specified shape.
`Font`	`getFont()`
`void`	`setFont(Font value)`
	Represents the font of shape.
`ShapeFormat`	`getFormat()`
	Represents the setting of the shape's formatting.
`MsoFormatPicture`	`getFormatPicture()`
	Gets and sets the options of the picture format.
`Geometry`	`getGeometry()`
	Gets the geometry
`GlowEffect`	`getGlow()`
	Represents a object that specifies glow effect for the chart element or shape.
`GroupShape`	`getGroup()`
	Gets the group shape which contains this shape.
`boolean`	`hasLine()`
`void`	`setHasLine(booleanvalue)`
	Gets and sets the line border of the shape is visible.
`int`	`getHeight()`
`void`	`setHeight(intvalue)`
	Represents the height of shape, in unit of pixel.
`double`	`getHeightCM()`
`void`	`setHeightCM(doublevalue)`
	Represents the height of the shape, in unit of inches.
`double`	`getHeightInch()`
`void`	`setHeightInch(doublevalue)`
	Represents the height of the shape, in unit of inches.
`int`	`getHeightInChart()`
`void`	`setHeightInChart(intvalue)`
	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..
`int`	`getHeightInShape()`
`void`	`setHeightInShape(intvalue)`
	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..
`double`	`getHeightPt()`
`void`	`setHeightPt(doublevalue)`
	Represents the height of the shape, in unit of points.
`int`	`getHeightScale()`
`void`	`setHeightScale(intvalue)`
	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;
`java.lang.String`	`getHtmlText()`
`void`	`setHtmlText(java.lang.Stringvalue)`
	Gets and sets the html string which contains data and some formats in this textbox.
`Hyperlink`	`getHyperlink()`
	Gets the hyperlink of the shape.
`int`	`getId()`
	Gets the identifier of this shape.
`java.lang.String`	`getInputRange()`
`void`	`setInputRange(java.lang.Stringvalue)`
	Gets or sets the worksheet range used to fill the specified combo box.
`boolean`	`isEquation()`
	Inidicates whether the shape only contains an equation.
`boolean`	`isFilled()`
`void`	`setFilled(booleanvalue)`
	Indicates whether the fill format is visible.
`boolean`	`isFlippedHorizontally()`
`void`	`setFlippedHorizontally(booleanvalue)`
	Gets and sets whether shape is horizontally flipped .
`boolean`	`isFlippedVertically()`
`void`	`setFlippedVertically(booleanvalue)`
	Gets and sets whether shape is vertically flipped .
`boolean`	`isGroup()`
	Indicates whether the shape is a group.
`boolean`	`isHidden()`
`void`	`setHidden(booleanvalue)`
	Indicates whether the object is visible.
`boolean`	`isLockAspectRatio()`
`void`	`setLockAspectRatio(booleanvalue)`
	True means that don't allow changes in aspect ratio.
`boolean`	`isLocked()`
`void`	`setLocked(booleanvalue)`
	True if the object is locked, False if the object can be modified when the sheet is protected.
`boolean`	`isPrintable()`
`void`	`setPrintable(booleanvalue)`
	True if the object is printable
`boolean`	`isRichText()`
	Whether or not the text is rich text.
`boolean`	`isSmartArt()`
	Inidicates whether the shape is smart art.
`boolean`	`isTextWrapped()`
`void`	`setTextWrapped(booleanvalue)`
	Gets and sets the text wrapped type of the shape which contains text.
`boolean`	`isWordArt()`
	Indicates whether this shape is a word art.
`int`	`getLeft()`
`void`	`setLeft(intvalue)`
	Represents the horizontal offset of shape from its left column, in unit of pixels.
`double`	`getLeftCM()`
`void`	`setLeftCM(doublevalue)`
	Represents the horizontal offset of shape from its left column, in unit of centimeters.
`double`	`getLeftInch()`
`void`	`setLeftInch(doublevalue)`
	Represents the horizontal offset of shape from its left column, in unit of inches.
`int`	`getLeftInChart()`
`void`	`setLeftInChart(intvalue)`
	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.
`int`	`getLeftInShape()`
`void`	`setLeftInShape(intvalue)`
	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.
`int`	`getLeftToCorner()`
`void`	`setLeftToCorner(intvalue)`
	Gets and sets the horizonal offset of shape from worksheet left border.
`LineFormat`	`getLine()`
	Gets line style
`MsoLineFormat`	`getLineFormat()`
	Returns a MsoLineFormat object that contains line formatting properties for the specified shape.
`java.lang.String`	`getLinkedCell()`
`void`	`setLinkedCell(java.lang.Stringvalue)`
	Gets or sets the worksheet range linked to the control's value.
`int`	`getLowerDeltaX()`
`void`	`setLowerDeltaX(intvalue)`
	Gets or sets the shape's horizontal offset from its lower right corner column. The range of value is 0 to 1024.
`int`	`getLowerDeltaY()`
`void`	`setLowerDeltaY(intvalue)`
	Gets or sets the shape's vertical offset from its lower right corner row. The range of value is 0 to 256.
`int`	`getLowerRightColumn()`
`void`	`setLowerRightColumn(intvalue)`
	Represents lower right corner column index.
`int`	`getLowerRightRow()`
`void`	`setLowerRightRow(intvalue)`
	Represents lower right corner row index.
`java.lang.String`	`getMacroName()`
`void`	`setMacroName(java.lang.Stringvalue)`
	Gets and sets the name of macro.
`int`	`getMsoDrawingType()`
	Gets and sets mso drawing type. The value of the property is MsoDrawingType integer constant.
`java.lang.String`	`getName()`
`void`	`setName(java.lang.Stringvalue)`
	Gets and sets the name of the shape.
`ShapePathCollection`	`getPaths()`
	Gets the paths of a custom geometric shape.
`int`	`getPlacement()`
`void`	`setPlacement(intvalue)`
	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.
`int`	`getPositionX()`
`void`	`setPositionX(intvalue)`
	Gets and sets the horizonal offset of shape from worksheet left border,in unit of pixels.
`int`	`getPositionY()`
`void`	`setPositionY(intvalue)`
	Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels.
`ReflectionEffect`	`getReflection()`
	Represents a object that specifies reflection effect for the chart element or shape.
`boolean`	`getRelativeToOriginalPictureSize()`
`void`	`setRelativeToOriginalPictureSize(booleanvalue)`
	Indicates whether shape is relative to original picture size.
`int`	`getRight()`
`void`	`setRight(intvalue)`
	Represents the width of the shape's horizontal offset from its lower right corner column, in unit of pixels.
`double`	`getRotationAngle()`
`void`	`setRotationAngle(doublevalue)`
	Gets and sets the rotation of the shape.
`Cell`	`getSelectedCell()`
	Gets the selected cell in the input range of the combo box.
`int`	`getSelectedIndex()`
`void`	`setSelectedIndex(intvalue)`
	Gets or sets the index number of the currently selected item in a list box or combo box. Zero-based.
`java.lang.String`	`getSelectedValue()`
	Gets the selected value of the combox box.
`boolean`	`getShadow()`
`void`	`setShadow(booleanvalue)`
	Indicates whether the combobox has 3-D shading.
`ShadowEffect`	`getShadowEffect()`
	Represents a object that specifies shadow effect for the chart element or shape.
`double`	`getSoftEdges()`
`void`	`setSoftEdges(doublevalue)`
	Gets and sets the radius of blur to apply to the edges, in unit of points.
`java.lang.String`	`getSpid()`
	Specifies an optional string that an application can use to Identify the particular shape.
`int`	`getSpt()`
	Specifies an optional number that an application can use to associate the particular shape with a defined shape type.
`java.lang.String`	`getText()`
`void`	`setText(java.lang.Stringvalue)`
	Represents the string in this TextBox object.
`FontSettingCollection`	`getTextBody()`
	Gets and ses the setting of the shape's text.
`int`	`getTextDirection()`
`void`	`setTextDirection(intvalue)`
	Gets/Sets the direction of the text flow for this object. The value of the property is TextDirectionType integer constant.
`TextEffectFormat`	`getTextEffect()`
	Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to Shape objects that represent WordArt.
`MsoTextFrame`	`getTextFrame()`
	Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape.
`int`	`getTextHorizontalAlignment()`
`void`	`setTextHorizontalAlignment(intvalue)`
	Gets and sets the text horizontal alignment type of the shape. The value of the property is TextAlignmentType integer constant.
`int`	`getTextHorizontalOverflow()`
`void`	`setTextHorizontalOverflow(intvalue)`
	Gets and sets the text horizontal overflow type of the shape which contains text. The value of the property is TextOverflowType integer constant.
`TextOptions`	`getTextOptions()`
`void`	`setTextOptions(TextOptions value)`
	Represents the text options of the shape.
`int`	`getTextOrientationType()`
`void`	`setTextOrientationType(intvalue)`
	Gets and sets the text orientation type of the shape. The value of the property is TextOrientationType integer constant.
`int`	`getTextShapeType()`
`void`	`setTextShapeType(intvalue)`
	Gets and sets the preset text shape type. The value of the property is AutoShapeType integer constant.
`int`	`getTextVerticalAlignment()`
`void`	`setTextVerticalAlignment(intvalue)`
	Gets and sets the text vertical alignment type of the shape. The value of the property is TextAlignmentType integer constant.
`int`	`getTextVerticalOverflow()`
`void`	`setTextVerticalOverflow(intvalue)`
	Gets and sets the text vertical overflow type of the shape which contains text. The value of the property is TextOverflowType integer constant.
`ThreeDFormat`	`getThreeDFormat()`
	Gets and sets 3d format of the shape.
`java.lang.String`	`getTitle()`
`void`	`setTitle(java.lang.Stringvalue)`
	Specifies the title (caption) of the current shape object.
`int`	`getTop()`
`void`	`setTop(intvalue)`
	Represents the vertical offset of shape from its top row, in unit of pixels.
`double`	`getTopCM()`
`void`	`setTopCM(doublevalue)`
	Represents the vertical offset of shape from its top row, in unit of centimeters.
`double`	`getTopInch()`
`void`	`setTopInch(doublevalue)`
	Represents the vertical offset of shape from its top row, in unit of inches.
`int`	`getTopInChart()`
`void`	`setTopInChart(intvalue)`
	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.
`int`	`getTopInShape()`
`void`	`setTopInShape(intvalue)`
	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.
`int`	`getTopToCorner()`
`void`	`setTopToCorner(intvalue)`
	Gets and sets the vertical offset of shape from worksheet top boder,in unit of pixel
`int`	`getType()`
	Gets the auto shape type. The value of the property is AutoShapeType integer constant.
`int`	`getUpperDeltaX()`
`void`	`setUpperDeltaX(intvalue)`
	Gets or sets the shape's horizontal offset from its upper left corner column. The range of value is 0 to 1024.
`int`	`getUpperDeltaY()`
`void`	`setUpperDeltaY(intvalue)`
	Gets or sets the shape's vertical offset from its upper left corner row. The range of value is 0 to 256.
`int`	`getUpperLeftColumn()`
`void`	`setUpperLeftColumn(intvalue)`
	Represents upper left corner column index.
`int`	`getUpperLeftRow()`
`void`	`setUpperLeftRow(intvalue)`
	Represents upper left corner row index.
`int`	`getWidth()`
`void`	`setWidth(intvalue)`
	Represents the width of shape, in unit of pixels.
`double`	`getWidthCM()`
`void`	`setWidthCM(doublevalue)`
	Represents the width of the shape, in unit of centimeters.
`double`	`getWidthInch()`
`void`	`setWidthInch(doublevalue)`
	Represents the width of the shape, in unit of inch.
`int`	`getWidthInChart()`
`void`	`setWidthInChart(intvalue)`
	Represents the width of the shape, in unit of 1/4000 of the parent shape.
`int`	`getWidthInShape()`
`void`	`setWidthInShape(intvalue)`
	Represents the width of the shape, in unit of 1/4000 of the parent shape.
`double`	`getWidthPt()`
`void`	`setWidthPt(doublevalue)`
	Represents the width of the shape, in unit of point.
`int`	`getWidthScale()`
`void`	`setWidthScale(intvalue)`
	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;
`int`	`getX()`
`void`	`setX(intvalue)`
	Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels.
`int`	`getY()`
`void`	`setY(intvalue)`
	Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels.
`int`	`getZOrderPosition()`
`void`	`setZOrderPosition(intvalue)`
	Returns the position of a shape in the z-order.

Method Summary
`Hyperlink`	`addHyperlink(java.lang.String address)`
`Hyperlink`	Adds a hyperlink to the shape.
`void`	`alignTopRightCorner(int topRow, int rightColumn)`
`void`	Moves the picture to the top-right corner.
`int[]`	`calculateTextSize()`
`int[]`	Recalculate the text area
`FontSetting`	`characters(int startIndex, int length)`
`FontSetting`	Returns a Characters object that represents a range of characters within the text.
`void`	`formatCharacters(int startIndex, int length, Font font)`
`void`	Format some chararcters with the font setting.
`void`	`formatCharacters(int startIndex, int length, Font font, StyleFlag flag)`
`void`	Format some chararcters with the font setting.
`java.util.ArrayList`	`getCharacters()`
`java.util.ArrayList`	Returns all Characters objects that represents a range of characters within the text .
`java.lang.String`	`getInputRange(boolean isR1C1, boolean isLocal)`
`java.lang.String`	Gets the range used to fill the control.
`java.lang.String`	`getLinkedCell(boolean isR1C1, boolean isLocal)`
`java.lang.String`	Gets the range linked to the control's value.
`boolean`	`getLockedProperty(int type)`
`boolean`	Gets the value of locked property.
`GroupShape`	`getResultOfSmartArt()`
`GroupShape`	Converting smart art to grouped shapes.
`void`	`moveToRange(int upperLeftRow, int upperLeftColumn, int lowerRightRow, int lowerRightColumn)`
`void`	Moves the shape to a specified range.
`void`	`removeActiveXControl()`
`void`	Remove activeX control.
`void`	`removeHyperlink()`
`void`	Remove the hyperlink of the shape.
`void`	`setInputRange(java.lang.String formula, boolean isR1C1, boolean isLocal)`
`void`	Sets the range used to fill the control.
`void`	`setLinkedCell(java.lang.String formula, boolean isR1C1, boolean isLocal)`
`void`	Sets the range linked to the control's value.
`void`	`setLockedProperty(int type, boolean value)`
`void`	Set the locked property.
`void`	`toFrontOrBack(int orders)`
`void`	Brings the shape to the front or sends the shape to back.
`void`	`toImage(java.io.OutputStream stream, ImageFormat imageFormat)`
`void`	Creates the shape image and saves it to a stream in the specified format.
`void`	`toImage(java.io.OutputStream stream, ImageOrPrintOptions options)`
`void`	Saves the shape to a stream.
`void`	`toImage(java.lang.String imageFile, ImageOrPrintOptions options)`
`void`	Saves the shape to a file.
`void`	`updateSelectedValue()`
`void`	Update the selected value by the value of the linked cell.

- Property Getters/Setters Detail
  - getSelectedIndex/setSelectedIndex
```
public int getSelectedIndex() / public void setSelectedIndex(int value)
```
    Gets or sets the index number of the currently selected item in a list box or combo box. Zero-based.
    -1 presents no item is selected.
  - getSelectedValue
```
public java.lang.String getSelectedValue()
```
    Gets the selected value of the combox box.
  - getSelectedCell
```
public Cell getSelectedCell()
```
    Gets the selected cell in the input range of the combo box.
  - getShadow/setShadow
```
public boolean getShadow() / public void setShadow(boolean value)
```
    Indicates whether the combobox has 3-D shading.
  - getDropDownLines/setDropDownLines
```
public int getDropDownLines() / public void setDropDownLines(int value)
```
    Gets or sets the number of list lines displayed in the drop-down portion of a combo box.
  - getMacroName/setMacroName
```
public java.lang.String getMacroName() / public void setMacroName(java.lang.String value)
```
    Gets and sets the name of macro.
  - isEquation
```
public boolean isEquation()
```
    Inidicates whether the shape only contains an equation.
  - isSmartArt
```
public boolean isSmartArt()
```
    Inidicates whether the shape is smart art.
    Only for ooxml file.
  - getZOrderPosition/setZOrderPosition
```
public int getZOrderPosition() / public void setZOrderPosition(int value)
```
    Returns the position of a shape in the z-order.
  - getName/setName
```
public java.lang.String getName() / public void setName(java.lang.String value)
```
    Gets and sets the name of the shape.
  - getAlternativeText/setAlternativeText
```
public java.lang.String getAlternativeText() / public void setAlternativeText(java.lang.String value)
```
    Returns or sets the descriptive (alternative) text string of the Shape object.
  - getTitle/setTitle
```
public java.lang.String getTitle() / public void setTitle(java.lang.String value)
```
    Specifies the title (caption) of the current shape object.
  - getLineFormat
```
public MsoLineFormat getLineFormat()
```
    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.
  - getFillFormat
```
public MsoFillFormat getFillFormat()
```
    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.
  - getFormat
```
public ShapeFormat getFormat()
```
    Represents the setting of the shape's formatting.
    NOTE: This member is now obsolete. Instead, please use Shape.Fill and Shape.Line properties. This property will be removed 6 months later since August 2016. Aspose apologizes for any inconvenience you may have experienced.
  - getLine
```
public LineFormat getLine()
```
    Gets line style
  - getFill
```
public FillFormat getFill()
```
    Returns a FillFormat object that contains fill formatting properties for the specified shape.
  - getShadowEffect
```
public ShadowEffect getShadowEffect()
```
    Represents a object that specifies shadow effect for the chart element or shape.
    See Also:
    ShadowEffect
  - getReflection
```
public ReflectionEffect getReflection()
```
    Represents a object that specifies reflection effect for the chart element or shape.
    See Also:
    ReflectionEffect
  - getGlow
```
public GlowEffect getGlow()
```
    Represents a object that specifies glow effect for the chart element or shape.
    See Also:
    GlowEffect
  - getSoftEdges/setSoftEdges
```
public double getSoftEdges() / public void setSoftEdges(double value)
```
    Gets and sets the radius of blur to apply to the edges, in unit of points.
  - getThreeDFormat
```
public ThreeDFormat getThreeDFormat()
```
    Gets and sets 3d format of the shape.
  - getTextFrame
```
public MsoTextFrame getTextFrame()
```
    Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape.
    NOTE: This member is now obsolete. Instead, please use Shape.TextBody.TextAlignment property. This property will be removed 12 months later since May 2016. Aspose apologizes for any inconvenience you may have experienced.
  - getFormatPicture
```
public MsoFormatPicture getFormatPicture()
```
    Gets and sets the options of the picture format.
  - isHidden/setHidden
```
public boolean isHidden() / public void setHidden(boolean value)
```
    Indicates whether the object is visible.
  - isLockAspectRatio/setLockAspectRatio
```
public boolean isLockAspectRatio() / public void setLockAspectRatio(boolean value)
```
    True means that don't allow changes in aspect ratio.
  - getRotationAngle/setRotationAngle
```
public double getRotationAngle() / public void setRotationAngle(double value)
```
    Gets and sets the rotation of the shape.
  - getHyperlink
```
public Hyperlink getHyperlink()
```
    Gets the hyperlink of the shape.
  - getId
```
public int getId()
```
    Gets the identifier of this shape.
  - getSpid
```
public java.lang.String getSpid()
```
    Specifies an optional string that an application can use to Identify the particular shape.
  - getSpt
```
public int getSpt()
```
    Specifies an optional number that an application can use to associate the particular shape with a defined shape type.
  - isGroup
```
public boolean isGroup()
```
    Indicates whether the shape is a group.
  - isWordArt
```
public boolean isWordArt()
```
    Indicates whether this shape is a word art.
    Only for the Legacy Shape of xls file.
  - getTextEffect
```
public TextEffectFormat getTextEffect()
```
    Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to Shape objects that represent WordArt.
  - isLocked/setLocked
```
public boolean isLocked() / public void setLocked(boolean value)
```
    True if the object is locked, False if the object can be modified when the sheet is protected.
  - isPrintable/setPrintable
```
public boolean isPrintable() / public void setPrintable(boolean value)
```
    True if the object is printable
  - getMsoDrawingType
```
public int getMsoDrawingType()
```
    Gets and sets mso drawing type. The value of the property is MsoDrawingType integer constant.
  - getAutoShapeType/setAutoShapeType
```
public int getAutoShapeType() / public void setAutoShapeType(int value)
```
    Gets the auto shape type. The value of the property is AutoShapeType integer constant.
  - getPlacement/setPlacement
```
public int getPlacement() / public void setPlacement(int 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.
  - getUpperLeftRow/setUpperLeftRow
```
public int getUpperLeftRow() / public void setUpperLeftRow(int value)
```
    Represents upper left corner row index.
    If the shape is in the shape or in the group , UpperLeftRow will be ignored.
  - getUpperDeltaY/setUpperDeltaY
```
public int getUpperDeltaY() / public void setUpperDeltaY(int value)
```
    Gets or sets the shape's vertical offset from its upper left corner row. The range of value is 0 to 256.
  - getUpperLeftColumn/setUpperLeftColumn
```
public int getUpperLeftColumn() / public void setUpperLeftColumn(int value)
```
    Represents upper left corner column index.
  - getUpperDeltaX/setUpperDeltaX
```
public int getUpperDeltaX() / public void setUpperDeltaX(int value)
```
    Gets or sets the shape's horizontal offset from its upper left corner column. The range of value is 0 to 1024.
  - getLowerRightRow/setLowerRightRow
```
public int getLowerRightRow() / public void setLowerRightRow(int value)
```
    Represents lower right corner row index.
  - getLowerDeltaY/setLowerDeltaY
```
public int getLowerDeltaY() / public void setLowerDeltaY(int value)
```
    Gets or sets the shape's vertical offset from its lower right corner row. The range of value is 0 to 256.
  - getLowerRightColumn/setLowerRightColumn
```
public int getLowerRightColumn() / public void setLowerRightColumn(int value)
```
    Represents lower right corner column index.
  - getLowerDeltaX/setLowerDeltaX
```
public int getLowerDeltaX() / public void setLowerDeltaX(int value)
```
    Gets or sets the shape's horizontal offset from its lower right corner column. The range of value is 0 to 1024.
  - getRight/setRight
```
public int getRight() / public void setRight(int value)
```
    Represents the width of the shape's horizontal offset from its lower right corner column, in unit of pixels.
  - getBottom/setBottom
```
public int getBottom() / public void setBottom(int value)
```
    Represents the width of the shape's vertical offset from its lower bottom corner row, in unit of pixels.
  - getWidth/setWidth
```
public int getWidth() / public void setWidth(int value)
```
    Represents the width of shape, in unit of pixels.
  - getWidthInch/setWidthInch
```
public double getWidthInch() / public void setWidthInch(double value)
```
    Represents the width of the shape, in unit of inch.
  - getWidthPt/setWidthPt
```
public double getWidthPt() / public void setWidthPt(double value)
```
    Represents the width of the shape, in unit of point.
  - getWidthCM/setWidthCM
```
public double getWidthCM() / public void setWidthCM(double value)
```
    Represents the width of the shape, in unit of centimeters.
  - getHeight/setHeight
```
public int getHeight() / public void setHeight(int value)
```
    Represents the height of shape, in unit of pixel.
  - getHeightInch/setHeightInch
```
public double getHeightInch() / public void setHeightInch(double value)
```
    Represents the height of the shape, in unit of inches.
  - getHeightPt/setHeightPt
```
public double getHeightPt() / public void setHeightPt(double value)
```
    Represents the height of the shape, in unit of points.
  - getHeightCM/setHeightCM
```
public double getHeightCM() / public void setHeightCM(double value)
```
    Represents the height of the shape, in unit of inches.
  - getLeft/setLeft
```
public int getLeft() / public void setLeft(int value)
```
    Represents the horizontal offset of shape from its left column, in unit of pixels.
  - getLeftInch/setLeftInch
```
public double getLeftInch() / public void setLeftInch(double value)
```
    Represents the horizontal offset of shape from its left column, in unit of inches.
  - getLeftCM/setLeftCM
```
public double getLeftCM() / public void setLeftCM(double value)
```
    Represents the horizontal offset of shape from its left column, in unit of centimeters.
  - getTop/setTop
```
public int getTop() / public void setTop(int value)
```
    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.
  - getTopInch/setTopInch
```
public double getTopInch() / public void setTopInch(double value)
```
    Represents the vertical offset of shape from its top row, in unit of inches.
  - getTopCM/setTopCM
```
public double getTopCM() / public void setTopCM(double value)
```
    Represents the vertical offset of shape from its top row, in unit of centimeters.
  - getTopToCorner/setTopToCorner
```
public int getTopToCorner() / public void setTopToCorner(int value)
```
    Gets and sets the vertical offset of shape from worksheet top boder,in unit of pixel
  - getLeftToCorner/setLeftToCorner
```
public int getLeftToCorner() / public void setLeftToCorner(int value)
```
    Gets and sets the horizonal offset of shape from worksheet left border.
  - getX/setX
```
public int getX() / public void setX(int value)
```
    Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels.
  - getY/setY
```
public int getY() / public void setY(int value)
```
    Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels.
  - getWidthScale/setWidthScale
```
public int getWidthScale() / public void setWidthScale(int 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;
  - getHeightScale/setHeightScale
```
public int getHeightScale() / public void setHeightScale(int 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;
  - getTopInShape/setTopInShape
```
public int getTopInShape() / public void setTopInShape(int 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.
    Only Applies when this shape in the group or chart.
  - getLeftInShape/setLeftInShape
```
public int getLeftInShape() / public void setLeftInShape(int 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.
    Only Applies when this shape in the group or chart.
  - getWidthInShape/setWidthInShape
```
public int getWidthInShape() / public void setWidthInShape(int value)
```
    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.
  - getHeightInShape/setHeightInShape
```
public int getHeightInShape() / public void setHeightInShape(int 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..
    Only Applies when this shape in the group or chart.
  - getHeightInChart/setHeightInChart
```
public int getHeightInChart() / public void setHeightInChart(int 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..
    NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Drawing.Shape.HeightInShape property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
  - getLeftInChart/setLeftInChart
```
public int getLeftInChart() / public void setLeftInChart(int 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.
    NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Drawing.Shape.LeftInShape property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
  - getTopInChart/setTopInChart
```
public int getTopInChart() / public void setTopInChart(int 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.
    NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Drawing.Shape.TopInShape property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
  - getWidthInChart/setWidthInChart
```
public int getWidthInChart() / public void setWidthInChart(int value)
```
    Represents the width of the shape, in unit of 1/4000 of the parent shape.
    NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Drawing.Shape.WidthInShape property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
  - getPositionX/setPositionX
```
public int getPositionX() / public void setPositionX(int value)
```
    Gets and sets the horizonal offset of shape from worksheet left border,in unit of pixels.
    NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Drawing.Shape.X property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
  - getPositionY/setPositionY
```
public int getPositionY() / public void setPositionY(int value)
```
    Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels.
    NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Drawing.Shape.Y property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
  - getGroup
```
public GroupShape getGroup()
```
    Gets the group shape which contains this shape.
  - getType
```
public int getType()
```
    Gets the auto shape type. The value of the property is AutoShapeType integer constant.
  - hasLine/setHasLine
```
public boolean hasLine() / public void setHasLine(boolean value)
```
    Gets and sets the line border of the shape is visible.
  - isFilled/setFilled
```
public boolean isFilled() / public void setFilled(boolean value)
```
    Indicates whether the fill format is visible.
  - isFlippedHorizontally/setFlippedHorizontally
```
public boolean isFlippedHorizontally() / public void setFlippedHorizontally(boolean value)
```
    Gets and sets whether shape is horizontally flipped .
  - isFlippedVertically/setFlippedVertically
```
public boolean isFlippedVertically() / public void setFlippedVertically(boolean value)
```
    Gets and sets whether shape is vertically flipped .
  - getActualLowerRightRow
```
public int getActualLowerRightRow()
```
    Get the actual bottom row.
  - getConnectionPoints
```
public java.awt.geom.Point2D.Float[] getConnectionPoints()
```
    Get the connection points
    Returns:
  - getRelativeToOriginalPictureSize/setRelativeToOriginalPictureSize
```
public boolean getRelativeToOriginalPictureSize() / public void setRelativeToOriginalPictureSize(boolean value)
```
    Indicates whether shape is relative to original picture size.
  - getLinkedCell/setLinkedCell
```
public java.lang.String getLinkedCell() / public void setLinkedCell(java.lang.String value)
```
    Gets or sets the worksheet range linked to the control's value.
  - getInputRange/setInputRange
```
public java.lang.String getInputRange() / public void setInputRange(java.lang.String value)
```
    Gets or sets the worksheet range used to fill the specified combo box.
  - getTextShapeType/setTextShapeType
```
public int getTextShapeType() / public void setTextShapeType(int value)
```
    Gets and sets the preset text shape type. The value of the property is AutoShapeType integer constant.
  - getTextBody
```
public FontSettingCollection getTextBody()
```
    Gets and ses the setting of the shape's text.
  - getFont/setFont
```
public Font getFont() / public void setFont(Font value)
```
    Represents the font of shape.
  - getTextOptions/setTextOptions
```
public TextOptions getTextOptions() / public void setTextOptions(TextOptions value)
```
    Represents the text options of the shape.
  - getText/setText
```
public java.lang.String getText() / public void setText(java.lang.String value)
```
    Represents the string in this TextBox object.
  - isRichText
```
public boolean isRichText()
```
    Whether or not the text is rich text.
  - getHtmlText/setHtmlText
```
public java.lang.String getHtmlText() / public void setHtmlText(java.lang.String value)
```
    Gets and sets the html string which contains data and some formats in this textbox.
  - getTextVerticalOverflow/setTextVerticalOverflow
```
public int getTextVerticalOverflow() / public void setTextVerticalOverflow(int value)
```
    Gets and sets the text vertical overflow type of the shape which contains text. The value of the property is TextOverflowType integer constant.
  - getTextHorizontalOverflow/setTextHorizontalOverflow
```
public int getTextHorizontalOverflow() / public void setTextHorizontalOverflow(int value)
```
    Gets and sets the text horizontal overflow type of the shape which contains text. The value of the property is TextOverflowType integer constant.
  - isTextWrapped/setTextWrapped
```
public boolean isTextWrapped() / public void setTextWrapped(boolean value)
```
    Gets and sets the text wrapped type of the shape which contains text.
  - getTextOrientationType/setTextOrientationType
```
public int getTextOrientationType() / public void setTextOrientationType(int value)
```
    Gets and sets the text orientation type of the shape. The value of the property is TextOrientationType integer constant.
  - getTextHorizontalAlignment/setTextHorizontalAlignment
```
public int getTextHorizontalAlignment() / public void setTextHorizontalAlignment(int value)
```
    Gets and sets the text horizontal alignment type of the shape. The value of the property is TextAlignmentType integer constant.
  - getTextVerticalAlignment/setTextVerticalAlignment
```
public int getTextVerticalAlignment() / public void setTextVerticalAlignment(int value)
```
    Gets and sets the text vertical alignment type of the shape. The value of the property is TextAlignmentType integer constant.
  - getTextDirection/setTextDirection
```
public int getTextDirection() / public void setTextDirection(int value)
```
    Gets/Sets the direction of the text flow for this object. The value of the property is TextDirectionType integer constant.
  - getControlData
```
public byte[] getControlData()
```
    Gets the data of control.
  - getActiveXControl
```
public ActiveXControl getActiveXControl()
```
    Gets the ActiveX control.
  - getPaths
```
public ShapePathCollection getPaths()
```
    Gets the paths of a custom geometric shape.
  - getGeometry
```
public Geometry getGeometry()
```
    Gets the geometry
setSelectedIndex
public voidsetSelectedIndex(intvalue)
Gets or sets the index number of the currently selected item in a list box or combo box. Zero-based.
-1 presents no item is selected.
setShadow
public voidsetShadow(booleanvalue)
Indicates whether the combobox has 3-D shading.
setDropDownLines
public voidsetDropDownLines(intvalue)
Gets or sets the number of list lines displayed in the drop-down portion of a combo box.
setMacroName
public voidsetMacroName(java.lang.Stringvalue)
Gets and sets the name of macro.
setZOrderPosition
public voidsetZOrderPosition(intvalue)
Returns the position of a shape in the z-order.
setName
public voidsetName(java.lang.Stringvalue)
Gets and sets the name of the shape.
setAlternativeText
public voidsetAlternativeText(java.lang.Stringvalue)
Returns or sets the descriptive (alternative) text string of the Shape object.
setTitle
public voidsetTitle(java.lang.Stringvalue)
Specifies the title (caption) of the current shape object.
setSoftEdges
public voidsetSoftEdges(doublevalue)
Gets and sets the radius of blur to apply to the edges, in unit of points.
setHidden
public voidsetHidden(booleanvalue)
Indicates whether the object is visible.
setLockAspectRatio
public voidsetLockAspectRatio(booleanvalue)
True means that don't allow changes in aspect ratio.
setRotationAngle
public voidsetRotationAngle(doublevalue)
Gets and sets the rotation of the shape.
setLocked
public voidsetLocked(booleanvalue)
True if the object is locked, False if the object can be modified when the sheet is protected.
setPrintable
public voidsetPrintable(booleanvalue)
True if the object is printable
setAutoShapeType
public voidsetAutoShapeType(intvalue)
Gets the auto shape type. The value of the property is AutoShapeType integer constant.
setPlacement
public voidsetPlacement(intvalue)
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.
setUpperLeftRow
public voidsetUpperLeftRow(intvalue)
Represents upper left corner row index.
If the shape is in the shape or in the group , UpperLeftRow will be ignored.
setUpperDeltaY
public voidsetUpperDeltaY(intvalue)
Gets or sets the shape's vertical offset from its upper left corner row. The range of value is 0 to 256.
setUpperLeftColumn
public voidsetUpperLeftColumn(intvalue)
Represents upper left corner column index.
setUpperDeltaX
public voidsetUpperDeltaX(intvalue)
Gets or sets the shape's horizontal offset from its upper left corner column. The range of value is 0 to 1024.
setLowerRightRow
public voidsetLowerRightRow(intvalue)
Represents lower right corner row index.
setLowerDeltaY
public voidsetLowerDeltaY(intvalue)
Gets or sets the shape's vertical offset from its lower right corner row. The range of value is 0 to 256.
setLowerRightColumn
public voidsetLowerRightColumn(intvalue)
Represents lower right corner column index.
setLowerDeltaX
public voidsetLowerDeltaX(intvalue)
Gets or sets the shape's horizontal offset from its lower right corner column. The range of value is 0 to 1024.
setRight
public voidsetRight(intvalue)
Represents the width of the shape's horizontal offset from its lower right corner column, in unit of pixels.
setBottom
public voidsetBottom(intvalue)
Represents the width of the shape's vertical offset from its lower bottom corner row, in unit of pixels.
setWidth
public voidsetWidth(intvalue)
Represents the width of shape, in unit of pixels.
setWidthInch
public voidsetWidthInch(doublevalue)
Represents the width of the shape, in unit of inch.
setWidthPt
public voidsetWidthPt(doublevalue)
Represents the width of the shape, in unit of point.
setWidthCM
public voidsetWidthCM(doublevalue)
Represents the width of the shape, in unit of centimeters.
setHeight
public voidsetHeight(intvalue)
Represents the height of shape, in unit of pixel.
setHeightInch
public voidsetHeightInch(doublevalue)
Represents the height of the shape, in unit of inches.
setHeightPt
public voidsetHeightPt(doublevalue)
Represents the height of the shape, in unit of points.
setHeightCM
public voidsetHeightCM(doublevalue)
Represents the height of the shape, in unit of inches.
setLeft
public voidsetLeft(intvalue)
Represents the horizontal offset of shape from its left column, in unit of pixels.
setLeftInch
public voidsetLeftInch(doublevalue)
Represents the horizontal offset of shape from its left column, in unit of inches.
setLeftCM
public voidsetLeftCM(doublevalue)
Represents the horizontal offset of shape from its left column, in unit of centimeters.
setTop
public voidsetTop(intvalue)
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.
setTopInch
public voidsetTopInch(doublevalue)
Represents the vertical offset of shape from its top row, in unit of inches.
setTopCM
public voidsetTopCM(doublevalue)
Represents the vertical offset of shape from its top row, in unit of centimeters.
setTopToCorner
public voidsetTopToCorner(intvalue)
Gets and sets the vertical offset of shape from worksheet top boder,in unit of pixel
setLeftToCorner
public voidsetLeftToCorner(intvalue)
Gets and sets the horizonal offset of shape from worksheet left border.
setX
public voidsetX(intvalue)
Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels.
setY
public voidsetY(intvalue)
Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels.
setWidthScale
public voidsetWidthScale(intvalue)
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;
setHeightScale
public voidsetHeightScale(intvalue)
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;
setTopInShape
public voidsetTopInShape(intvalue)
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.
setLeftInShape
public voidsetLeftInShape(intvalue)
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.
setWidthInShape
public voidsetWidthInShape(intvalue)
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.
setHeightInShape
public voidsetHeightInShape(intvalue)
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.
setHeightInChart
public voidsetHeightInChart(intvalue)
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..
NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Drawing.Shape.HeightInShape property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
setLeftInChart
public voidsetLeftInChart(intvalue)
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.
NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Drawing.Shape.LeftInShape property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
setTopInChart
public voidsetTopInChart(intvalue)
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.
NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Drawing.Shape.TopInShape property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
setWidthInChart
public voidsetWidthInChart(intvalue)
Represents the width of the shape, in unit of 1/4000 of the parent shape.
NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Drawing.Shape.WidthInShape property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
setPositionX
public voidsetPositionX(intvalue)
Gets and sets the horizonal offset of shape from worksheet left border,in unit of pixels.
NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Drawing.Shape.X property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
setPositionY
public voidsetPositionY(intvalue)
Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels.
NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Drawing.Shape.Y property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
setHasLine
public voidsetHasLine(booleanvalue)
Gets and sets the line border of the shape is visible.
setFilled
public voidsetFilled(booleanvalue)
Indicates whether the fill format is visible.
setFlippedHorizontally
public voidsetFlippedHorizontally(booleanvalue)
Gets and sets whether shape is horizontally flipped .
setFlippedVertically
public voidsetFlippedVertically(booleanvalue)
Gets and sets whether shape is vertically flipped .
setRelativeToOriginalPictureSize
public voidsetRelativeToOriginalPictureSize(booleanvalue)
Indicates whether shape is relative to original picture size.
setLinkedCell
public voidsetLinkedCell(java.lang.Stringvalue)
Gets or sets the worksheet range linked to the control's value.
setInputRange
public voidsetInputRange(java.lang.Stringvalue)
Gets or sets the worksheet range used to fill the specified combo box.
setTextShapeType
public voidsetTextShapeType(intvalue)
Gets and sets the preset text shape type. The value of the property is AutoShapeType integer constant.
setFont
public voidsetFont(Font value)
Represents the font of shape.
setTextOptions
public voidsetTextOptions(TextOptions value)
Represents the text options of the shape.
setText
public voidsetText(java.lang.Stringvalue)
Represents the string in this TextBox object.
setHtmlText
public voidsetHtmlText(java.lang.Stringvalue)
Gets and sets the html string which contains data and some formats in this textbox.
setTextVerticalOverflow
public voidsetTextVerticalOverflow(intvalue)
Gets and sets the text vertical overflow type of the shape which contains text. The value of the property is TextOverflowType integer constant.
setTextHorizontalOverflow
public voidsetTextHorizontalOverflow(intvalue)
Gets and sets the text horizontal overflow type of the shape which contains text. The value of the property is TextOverflowType integer constant.
setTextWrapped
public voidsetTextWrapped(booleanvalue)
Gets and sets the text wrapped type of the shape which contains text.
setTextOrientationType
public voidsetTextOrientationType(intvalue)
Gets and sets the text orientation type of the shape. The value of the property is TextOrientationType integer constant.
setTextHorizontalAlignment
public voidsetTextHorizontalAlignment(intvalue)
Gets and sets the text horizontal alignment type of the shape. The value of the property is TextAlignmentType integer constant.
setTextVerticalAlignment
public voidsetTextVerticalAlignment(intvalue)
Gets and sets the text vertical alignment type of the shape. The value of the property is TextAlignmentType integer constant.
setTextDirection
public voidsetTextDirection(intvalue)
Gets/Sets the direction of the text flow for this object. The value of the property is TextDirectionType integer constant.
- Method Detail
  - getLinkedCell
```
public java.lang.String getLinkedCell(boolean isR1C1, boolean isLocal)
```
    Gets the range linked to the control's value.
    Parameters:
    isR1C1 - Whether the formula needs to be formatted as R1C1.
    isLocal - Whether the formula needs to be formatted by locale.
    Returns:
    The range linked to the control's value.
  - setLinkedCell
```
public void setLinkedCell(java.lang.String formula, boolean isR1C1, boolean isLocal)
```
    Sets the range linked to the control's value.
    Parameters:
    formula - The range linked to the control's value.
    isR1C1 - Whether the formula needs to be formatted as R1C1.
    isLocal - Whether the formula needs to be formatted by locale.
  - getInputRange
```
public java.lang.String getInputRange(boolean isR1C1, boolean isLocal)
```
    Gets the range used to fill the control.
    Parameters:
    isR1C1 - Whether the formula needs to be formatted as R1C1.
    isLocal - Whether the formula needs to be formatted by locale.
    Returns:
    The range used to fill the control.
  - setInputRange
```
public void setInputRange(java.lang.String formula, boolean isR1C1, boolean isLocal)
```
    Sets the range used to fill the control.
    Parameters:
    formula - The range used to fill the control.
    isR1C1 - Whether the formula needs to be formatted as R1C1.
    isLocal - Whether the formula needs to be formatted by locale.
  - updateSelectedValue
```
public void updateSelectedValue()
                        throws java.lang.Exception
```
    Update the selected value by the value of the linked cell.
  - calculateTextSize
```
public int[] calculateTextSize()
                       throws java.lang.Exception
```
    Recalculate the text area
    Returns:
    Text's Size in an array(width and height).
  - formatCharacters
```
public void formatCharacters(int startIndex, int length, Font font, StyleFlag flag)
```
    Format some chararcters with the font setting.
    Parameters:
    startIndex - The start index.
    length - The the length.
    font - The font setting.
    flag - The flag of the font setting.
  - formatCharacters
```
public void formatCharacters(int startIndex, int length, Font font)
```
    Format some chararcters with the font setting.
    NOTE: This member is now obsolete. Instead, please use Shape.FormatCharacters(int startIndex, int length, Font font,StyleFlag flag) method. This property will be removed 12 months later since March 2016. Aspose apologizes for any inconvenience you may have experienced.
    Parameters:
    startIndex - The start index.
    length - The the length.
    font - The font setting.
  - characters
```
public FontSetting characters(int startIndex, int length)
```
    Returns a Characters object that represents a range of characters within the text.
    This method only works on shape with title.
    Parameters:
    startIndex - The index of the start of the character.
    length - The number of characters.
    Returns:
    Characters object.
  - getCharacters
```
public java.util.ArrayList getCharacters()
```
    Returns all Characters objects that represents a range of characters within the text .
    Returns:
    All Characters objects
  - removeActiveXControl
```
public void removeActiveXControl()
```
    Remove activeX control.
  - toImage
```
public void toImage(java.io.OutputStream stream, ImageFormat imageFormat)
            throws java.lang.Exception
```
    Creates the shape image and saves it to a stream in the specified format.
    The following formats are supported: .bmp, .gif, .jpg, .jpeg, .tiff, .emf.
    Parameters:
    stream - The output stream.
    imageFormat - The format in which to save the image.
  - toImage
```
public void toImage(java.lang.String imageFile, ImageOrPrintOptions options)
            throws java.lang.Exception
```
    Saves the shape to a file.
  - toImage
```
public void toImage(java.io.OutputStream stream, ImageOrPrintOptions options)
            throws java.lang.Exception
```
    Saves the shape to a stream.
  - getResultOfSmartArt
```
public GroupShape getResultOfSmartArt()
                              throws java.lang.Exception
```
    Converting smart art to grouped shapes.
  - toFrontOrBack
```
public void toFrontOrBack(int orders)
```
    Brings the shape to the front or sends the shape to back.
    Parameters:
    orders - If it's less than zero, sens the shape to back. If it's greater than zero, brings the shape to front.
  - getLockedProperty
```
public boolean getLockedProperty(int type)
```
    Gets the value of locked property.
    Parameters:
    type - A ShapeLockType value. The type of the shape locked property.
    Returns:
    Returns the value of locked property.
  - setLockedProperty
```
public void setLockedProperty(int type, boolean value)
```
    Set the locked property.
    Parameters:
    type - A ShapeLockType value. The locked type.
    value - The value of the property.
  - addHyperlink
```
public Hyperlink addHyperlink(java.lang.String address)
```
    Adds a hyperlink to the shape.
    Parameters:
    address - Address of the hyperlink.
    Returns:
    Return the new hyperlink object.
  - removeHyperlink
```
public void removeHyperlink()
```
    Remove the hyperlink of the shape.
  - moveToRange
```
public void moveToRange(int upperLeftRow, int upperLeftColumn, int lowerRightRow, int lowerRightColumn)
```
    Moves the shape to a specified range.
    Parameters:
    upperLeftRow - Upper left row index.
    upperLeftColumn - Upper left column index.
    lowerRightRow - Lower right row index
    lowerRightColumn - Lower right column index
  - alignTopRightCorner
```
public void alignTopRightCorner(int topRow, int rightColumn)
```
    Moves the picture to the top-right corner.
    Parameters:
    topRow - the row index.
    rightColumn - the column index.

setAlternativeText
public voidsetAlternativeText(java.lang.Stringvalue)

setLockAspectRatio
public voidsetLockAspectRatio(booleanvalue)

setFlippedHorizontally
public voidsetFlippedHorizontally(booleanvalue)

setFlippedVertically
public voidsetFlippedVertically(booleanvalue)

setRelativeToOriginalPictureSize
public voidsetRelativeToOriginalPictureSize(booleanvalue)

setLinkedCell
public voidsetLinkedCell(java.lang.Stringvalue)

setInputRange
public voidsetInputRange(java.lang.Stringvalue)

setTextVerticalOverflow
public voidsetTextVerticalOverflow(intvalue)

setTextHorizontalOverflow
public voidsetTextHorizontalOverflow(intvalue)

setTextOrientationType
public voidsetTextOrientationType(intvalue)

setSelectedIndex
public voidsetSelectedIndex(intvalue)

setShadow
public voidsetShadow(booleanvalue)

setDropDownLines
public voidsetDropDownLines(intvalue)

setMacroName
public voidsetMacroName(java.lang.Stringvalue)

setTextHorizontalAlignment
public voidsetTextHorizontalAlignment(intvalue)

setTextVerticalAlignment
public voidsetTextVerticalAlignment(intvalue)

com.aspose.cells

Classes

Interfaces

Constants

Class ComboBox

Property Getters/Setters Detail

getSelectedIndex/setSelectedIndex

getSelectedValue

getSelectedCell

getShadow/setShadow

getDropDownLines/setDropDownLines

getMacroName/setMacroName

isEquation

isSmartArt

getZOrderPosition/setZOrderPosition

getName/setName

getAlternativeText/setAlternativeText

getTitle/setTitle

getLineFormat

getFillFormat

getFormat

getLine

getFill

getShadowEffect

getReflection

getGlow

getSoftEdges/setSoftEdges

getThreeDFormat

getTextFrame

getFormatPicture

isHidden/setHidden

isLockAspectRatio/setLockAspectRatio

getRotationAngle/setRotationAngle

getHyperlink

getId

getSpid

getSpt

isGroup

isWordArt

getTextEffect

isLocked/setLocked

isPrintable/setPrintable

getMsoDrawingType

getAutoShapeType/setAutoShapeType

getPlacement/setPlacement

getUpperLeftRow/setUpperLeftRow

getUpperDeltaY/setUpperDeltaY

getUpperLeftColumn/setUpperLeftColumn

getUpperDeltaX/setUpperDeltaX

getLowerRightRow/setLowerRightRow

getLowerDeltaY/setLowerDeltaY

getLowerRightColumn/setLowerRightColumn

getLowerDeltaX/setLowerDeltaX

getRight/setRight

getBottom/setBottom

getWidth/setWidth

getWidthInch/setWidthInch

getWidthPt/setWidthPt

getWidthCM/setWidthCM

getHeight/setHeight

getHeightInch/setHeightInch

getHeightPt/setHeightPt

getHeightCM/setHeightCM

getLeft/setLeft

getLeftInch/setLeftInch

getLeftCM/setLeftCM

getTop/setTop

getTopInch/setTopInch

getTopCM/setTopCM

getTopToCorner/setTopToCorner

getLeftToCorner/setLeftToCorner

getX/setX

getY/setY

getWidthScale/setWidthScale

getHeightScale/setHeightScale

getTopInShape/setTopInShape

getLeftInShape/setLeftInShape

getWidthInShape/setWidthInShape

getHeightInShape/setHeightInShape

getHeightInChart/setHeightInChart