Class Shape
Contents
[
Hide
]Shape class
Represents the msodrawing object.
public class Shape
Properties
| Name | Description |
|---|---|
| ActiveXControl { get; } | Gets the ActiveX control. |
| ActualLowerRightRow { get; } | Get the actual bottom row. |
| AlternativeText { get; set; } | Returns or sets the descriptive (alternative) text string of the Shape object. |
| AnchorType { get; set; } | Gets and set the type of the shape anchor placeholder. |
| AutoShapeType { get; set; } | Gets and sets the auto shape type. |
| Bottom { get; set; } | Represents the width of the shape’s vertical offset from its lower bottom corner row, in unit of pixels. |
| ControlData { get; } | Gets the data of control. |
| CreateId { get; set; } | Gets and sets create id for this shape. |
| Fill { get; } | Returns a FillFormat object that contains fill formatting properties for the specified shape. |
| FillFormat { get; } | (Obsolete.) Returns a MsoFillFormat object that contains fill formatting properties for the specified shape. |
| Font { get; set; } | Represents the font of shape. |
| FormatPicture { get; } | Gets and sets the options of the picture format. |
| Geometry { get; } | Gets the geometry |
| Glow { get; } | Represents a GlowEffect object that specifies glow effect for the chart element or shape. |
| Group { get; } | Gets the group shape which contains this shape. |
| HasLine { get; set; } | Gets and sets the line border of the shape is visible. |
| Height { get; set; } | Represents the height of shape, in unit of pixel. |
| HeightCM { get; set; } | Represents the height of the shape, in unit of centimeters. |
| HeightInch { get; set; } | Represents the height of the shape, in unit of inches. |
| HeightInShape { get; set; } | 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.. |
| HeightPt { get; set; } | Represents the height of the shape, in unit of points. |
| HeightScale { get; set; } | 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; |
| HtmlText { get; set; } | Gets and sets the html string which contains data and some formats in this textbox. |
| Hyperlink { get; } | Gets the hyperlink of the shape. |
| Id { get; } | Gets the identifier of this shape. |
| InputRange { get; set; } | Gets or sets the worksheet range used to fill the specified combo box. |
| IsAspectRatioLocked { get; set; } | True means that aspect ratio of the shape is locked. |
| IsDecorative { get; set; } | Indicates whether the object is decorative. |
| IsEquation { get; } | Indicates whether the shape only contains an equation. |
| IsFilled { get; set; } | Indicates whether the fill format is visible. |
| IsFlippedHorizontally { get; set; } | Gets and sets whether shape is horizontally flipped . |
| IsFlippedVertically { get; set; } | Gets and sets whether shape is vertically flipped . |
| IsGroup { get; } | Indicates whether this shape is a group shape. |
| IsHidden { get; set; } | Indicates whether the object is visible. |
| IsInGroup { get; } | Indicates whether the shape is grouped. |
| IsLockAspectRatio { get; set; } | (Obsolete.) True means that aspect ratio of the shape is locked. |
| IsLocked { get; set; } | True means the object can not be modified when the sheet is protected. Note that this value is meaningful only if the worksheet or objects in the worksheet are protected. |
| IsPrintable { get; set; } | Indicates whether the object is printable. If False, this shape will not be printed when printing. |
| IsRichText { get; } | Whether or not the text is rich text. |
| IsSmartArt { get; } | Indicates whether the shape is a smart art. |
| IsTextWrapped { get; set; } | Gets and sets the text wrapped type of the shape which contains text. |
| IsWordArt { get; } | Indicates whether this shape is a word art. |
| Left { get; set; } | Represents the horizontal offset of shape from its left column, in unit of pixels. |
| LeftCM { get; set; } | Represents the horizontal offset of shape from its left column, in unit of centimeters. |
| LeftInch { get; set; } | Represents the horizontal offset of shape from its left column, in unit of inches. |
| LeftInShape { get; set; } | 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. |
| LeftToCorner { get; set; } | Gets and sets the horizonal offset of shape from worksheet left border. |
| Line { get; } | Gets line style |
| LineFormat { get; } | (Obsolete.) Returns a MsoLineFormat object that contains line formatting properties for the specified shape. |
| LinkedCell { get; set; } | Gets or sets the worksheet range linked to the control’s value. |
| LowerDeltaX { get; set; } | Gets or sets the shape’s horizontal offset from its lower right corner column. |
| LowerDeltaY { get; set; } | Gets or sets the shape’s vertical offset from its lower right corner row. |
| LowerRightColumn { get; set; } | Represents lower right corner column index. |
| LowerRightRow { get; set; } | Represents lower right corner row index. |
| MacroName { get; set; } | Gets and sets the name of macro. |
| MsoDrawingType { get; } | Gets drawing type. |
| Name { get; set; } | Gets and sets the name of the shape. |
| Paths { get; } | Gets the paths of a custom geometric shape. |
| Placement { get; set; } | Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet. |
| Reflection { get; } | Represents a ReflectionEffect object that specifies reflection effect for the chart element or shape. |
| RelativeToOriginalPictureSize { get; set; } | Indicates whether shape is relative to original picture size. |
| Right { get; set; } | Represents the width of the shape’s horizontal offset from its lower right corner column, in unit of pixels. |
| RotationAngle { get; set; } | Gets and sets the rotation of the shape. |
| ShadowEffect { get; } | Represents a ShadowEffect object that specifies shadow effect for the chart element or shape. |
| SoftEdges { get; set; } | Gets and sets the radius of blur to apply to the edges, in unit of points. |
| Spid { get; } | Specifies an optional string identifier that an application can use to identify the particular shape. |
| Spt { get; } | Specifies an optional number that an application can use to associate the particular shape with a defined shape type. |
| Text { get; set; } | Gets and sets the text of this shape. |
| TextBody { get; } | Gets and sets the setting of the shape’s text. |
| TextBoxOptions { get; } | Gets the text information in the shape |
| TextDirection { get; set; } | Gets/Sets the direction of the text flow for this object. |
| TextEffect { get; } | Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to Shape objects that represent WordArt. |
| TextHorizontalAlignment { get; set; } | Gets and sets the text horizontal alignment type of the shape. |
| TextHorizontalOverflow { get; set; } | Gets and sets the text horizontal overflow type of the shape which contains text. |
| TextOptions { get; set; } | Represents the text options of the shape. |
| TextOrientationType { get; set; } | Gets and sets the text orientation type of the shape. |
| TextShapeType { get; set; } | Gets and sets the preset text shape type. |
| TextVerticalAlignment { get; set; } | Gets and sets the text vertical alignment type of the shape. |
| TextVerticalOverflow { get; set; } | Gets and sets the text vertical overflow type of the shape which contains text. |
| ThreeDFormat { get; } | Gets and sets 3d format of the shape. |
| Title { get; set; } | Specifies the title (caption) of the current shape object. |
| Top { get; set; } | Represents the vertical offset of shape from its top row, in unit of pixels. |
| TopCM { get; set; } | Represents the vertical offset of shape from its top row, in unit of centimeters. |
| TopInch { get; set; } | Represents the vertical offset of shape from its top row, in unit of inches. |
| TopInShape { get; set; } | 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. |
| TopToCorner { get; set; } | Gets and sets the vertical offset of shape from worksheet top border, in unit of pixels. |
| Type { get; } | Gets the auto shape type. |
| UpperDeltaX { get; set; } | Gets or sets the shape’s horizontal offset from its upper left corner column. |
| UpperDeltaY { get; set; } | Gets or sets the shape’s vertical offset from its upper left corner row. |
| UpperLeftColumn { get; set; } | Represents upper left corner column index. |
| UpperLeftRow { get; set; } | Represents the top row index. |
| Width { get; set; } | Represents the width of shape, in unit of pixels. |
| WidthCM { get; set; } | Represents the width of the shape, in unit of centimeters. |
| WidthInch { get; set; } | Represents the width of the shape, in unit of inch. |
| WidthInShape { get; set; } | Represents the width of the shape, in unit of 1/4000 of the parent shape. |
| WidthPt { get; set; } | Represents the width of the shape, in unit of point. |
| WidthScale { get; set; } | 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; |
| Worksheet { get; } | Gets the Worksheet object which contains this shape. |
| X { get; set; } | Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels. |
| Y { get; set; } | Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels. |
| ZOrderPosition { get; set; } | Returns the position of a shape in the z-order. |
Methods
| Name | Description |
|---|---|
| AddHyperlink(string) | Adds a hyperlink to the shape. |
| AlignTopRightCorner(int, int) | Moves the picture to the top-right corner. |
| CalculateTextSize() | Recalculate the text area |
| Characters(int, int) | Returns a Characters object that represents a range of characters within the text. |
| FitToTextSize() | Recalculate a text area suitable for displaying all text content. |
| FormatCharacters(int, int, Font, StyleFlag) | Formats some characters with the font setting. |
| GetActualBox() | Get the actual position and size of the shape (after applying rotation, flip, etc.) |
| GetCharacters() | (Obsolete.) Returns all Characters objects that represents a range of characters within the text . |
| GetConnectionPoints() | Get the connection points |
| GetInputRange(bool, bool) | Gets the range used to fill the control. |
| GetLinkedCell(bool, bool) | Gets the range linked to the control’s value. |
| GetLockedProperty(ShapeLockType) | Gets the value of locked property. |
| virtual GetResultOfSmartArt() | Converting smart art to grouped shapes. |
| GetRichFormattings() | Returns all Characters objects that represents a range of characters within the text . |
| virtual IsSameSetting(object) | Returns whether the shape is same. |
| MoveToRange(int, int, int, int) | Moves the shape to a specified range. |
| RemoveActiveXControl() | Remove activeX control. |
| RemoveHyperlink() | Removes the hyperlink of the shape. |
| SetInputRange(string, bool, bool) | Sets the range used to fill the control. |
| SetLinkedCell(string, bool, bool) | Sets the range linked to the control’s value. |
| SetLockedProperty(ShapeLockType, bool) | Set the locked property. |
| ToFrontOrBack(int) | Brings the shape to the front or sends the shape to back. |
| ToImage(ImageOrPrintOptions) | Returns the bitmap object of the shape . |
| ToImage(Stream, ImageOrPrintOptions) | Saves the shape to a stream. |
| ToImage(Stream, ImageType) | Creates the shape image and saves it to a stream in the specified format. |
| ToImage(string, ImageOrPrintOptions) | Saves the shape to a file. |
| UpdateSelectedValue() | Update the selected value by the value of the linked cell. |
Examples
using System;
using Aspose.Cells;
using Aspose.Cells.Drawing;
namespace AsposeCellsExamples
{
public class DrawingClassShapeDemo
{
public static void Run()
{
// Initialize a new workbook
Workbook workbook = new Workbook();
// Add a rectangle shape to the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
Shape shape = worksheet.Shapes.AddRectangle(2, 0, 2, 0, 130, 130);
// Set some shape properties
shape.Fill.FillType = FillType.Solid;
shape.Fill.SolidFill.Color = System.Drawing.Color.LightBlue;
shape.Line.DashStyle = MsoLineDashStyle.Solid;
shape.Line.Weight = 2;
// Save the workbook
workbook.Save("ShapeDemo.xlsx");
}
}
}
See Also
- namespace Aspose.Cells.Drawing
- assembly Aspose.Cells
