ExcelGroupShape Class

Namespace:
GemBox.Spreadsheet
Assembly:
GemBox.Spreadsheet.dll

Represents a drawing that groups other drawings.

public sealed class ExcelGroupShape : ExcelDrawing
Public NotInheritable Class ExcelGroupShape
    Inherits ExcelDrawing
Inheritance:
System.Object
ExcelGroupShape

Properties

Charts

Gets the group shape charts. Not supported in XLS.

public ExcelChartCollection Charts { get; }
Public ReadOnly Property Charts As ExcelChartCollection
Property Value
ExcelChartCollection

The group shape charts.

Fill

Gets or sets the fill formatting options.

public FillFormat Fill { get; set; }
Public Property Fill As FillFormat
Property Value
FillFormat

The fill formatting options.

FlipHorizontal

Gets or sets a value indicating whether to flip the drawing horizontally - reflect it across a vertical line that intersects the center of the drawing's bounding box.

public bool FlipHorizontal { get; set; }
Public Property FlipHorizontal As Boolean
Property Value
System.Boolean

true to flip the drawing horizontally; otherwise, false.

Remarks

This property is supported only when loading and saving to XLSX and XLSB file format.

When set to a value different than the current FlipHorizontal, MS Excel automatically inverts the Rotation to 360° - Rotation (normalized to the interval [0°, 360°>). To follow the MS Excel's behavior, you should do the same.

FlipVertical

Gets or sets a value indicating whether to flip the drawing vertically - reflect it across a horizontal line that intersects the center of the drawing's bounding box.

public bool FlipVertical { get; set; }
Public Property FlipVertical As Boolean
Property Value
System.Boolean

true to flip the drawing horizontally; otherwise, false.

Remarks

This property is supported only when loading and saving to XLSX and XLSB file format.

When set to a value different than the current FlipVertical, MS Excel automatically inverts the Rotation to 360° - Rotation (normalized to the interval [0°, 360°>). To follow the MS Excel's behavior, you should do the same.

FormControls

Gets the group shape form controls.

public ExcelFormControlCollection FormControls { get; }
Public ReadOnly Property FormControls As ExcelFormControlCollection
Property Value
ExcelFormControlCollection

The group shape form controls.

See Also

GroupShapes

Gets the group shape sub groups.

public ExcelGroupShapeCollection GroupShapes { get; }
Public ReadOnly Property GroupShapes As ExcelGroupShapeCollection
Property Value
ExcelGroupShapeCollection

The group shape sub groups.

See Also

Outline

Gets or sets the outline formatting options.

public LineFormat Outline { get; set; }
Public Property Outline As LineFormat
Property Value
LineFormat

The outline formatting options.

Pictures

Gets the group shape pictures.

public ExcelPictureCollection Pictures { get; }
Public ReadOnly Property Pictures As ExcelPictureCollection
Property Value
ExcelPictureCollection

The group shape pictures.

Remarks

Supported picture formats are listed in ExcelPictureFormat.

See Also

Rotation

Gets or sets the amount (in degrees) by which the drawing is rotated clockwise about the center of the drawing's bounding box.

public double Rotation { get; set; }
Public Property Rotation As Double
Property Value
System.Double

The amount (in degrees) by which the drawing is rotated clockwise about the center of the drawing's bounding box.

Remarks

This property is supported only when loading and saving to XLSX and XLSB file format.

Shapes

Gets the group shape shapes.

public ExcelShapeCollection Shapes { get; }
Public ReadOnly Property Shapes As ExcelShapeCollection
Property Value
ExcelShapeCollection

The group shape shapes.

See Also

Inherited Properties

Gets or sets the hyperlink on this drawing (picture, chart, etc.).

(Inherited from ExcelDrawing)

Metadata

Gets the metadata (non-visual properties) of this ExcelDrawing instance.

(Inherited from ExcelDrawing)

Position

Gets the position of this drawing (picture, chart, etc.) in the worksheet.

(Inherited from ExcelDrawing)

Worksheet

Gets the parent worksheet.

(Inherited from ExcelDrawing)

ZIndex

Gets the z-order position of the picture. -1 if the picture is not contained in proper collection.

(Inherited from ExcelDrawing)

Inherited Methods

Format()

Formats this drawing (picture, chart, etc.) to its default size so it can be exported to PDF, XPS, image or be printed.

(Inherited from ExcelDrawing)

Format(System.Double, System.Double, LengthUnit)

Formats this drawing (picture, chart, etc.) to specified size so it can be exported to PDF, XPS, image or be printed.

(Inherited from ExcelDrawing)