Represents a group of shapes in a worksheet. This group is also a shape which can be positioned and contained within another group or on a worksheet.
Constructors
Section titled "Constructors"WorksheetShapeGroupBase
new WorksheetShapeGroupBase(a: number): WorksheetShapeGroupBaseReturns WorksheetShapeGroupBase
Properties
Section titled "Properties"$t: TypebottomRightCornerCell
Section titled "bottomRightCornerCell"Inherited from: WorksheetShape
bottomRightCornerCell: WorksheetCellbottomRightCornerPosition
Section titled "bottomRightCornerPosition"Inherited from: WorksheetShape
bottomRightCornerPosition: IgPointInherited from: WorksheetShape
fill: ShapeFillflippedHorizontally
Section titled "flippedHorizontally"Inherited from: WorksheetShape
flippedHorizontally: booleanflippedVertically
Section titled "flippedVertically"Inherited from: WorksheetShape
flippedVertically: booleanoutline
Section titled "outline"Inherited from: WorksheetShape
outline: ShapeOutlinepositioningMode
Section titled "positioningMode"Inherited from: WorksheetShape
positioningMode: ShapePositioningModetopLeftCornerCell
Section titled "topLeftCornerCell"Inherited from: WorksheetShape
topLeftCornerCell: WorksheetCelltopLeftCornerPosition
Section titled "topLeftCornerPosition"Inherited from: WorksheetShape
topLeftCornerPosition: IgPointvisible
Section titled "visible"Inherited from: WorksheetShape
visible: booleanAccessors
Section titled "Accessors"sheet
Section titled "sheet"Inherited from: WorksheetShape
Gets the worksheet on which the shape resides. The worksheet on which the shape resides.
get sheet(): SheetReturns Sheet
worksheet
Section titled "worksheet"Inherited from: WorksheetShape
Gets the worksheet on which the shape resides. The worksheet on which the shape resides.
get worksheet(): WorksheetReturns Worksheet
Methods
Section titled "Methods"clearUnknownData
Section titled "clearUnknownData"Inherited from: WorksheetShape
Clears the cached unknown shape data which was read in from a parsed excel file.
clearUnknownData(): voidReturns void
getBoundsInTwips
Section titled "getBoundsInTwips"Inherited from: WorksheetShape
Gets the bounds of the shape in twips (1/20th of a point).
getBoundsInTwips(): IgRectReturns IgRect
setBoundsInTwips
Section titled "setBoundsInTwips"Inherited from: WorksheetShape
Sets the bounds of the shape in twips (1/20th of a point).
setBoundsInTwips(sheet: Sheet, bounds: IgRect): voidParameters
- sheet:
SheetThe worksheet on which the shape should be placed.
- bounds:
IgRectThe new bounds where the shape should be placed.
Returns void
shapes
Section titled "shapes"Gets the shape at the specified index in the collection. The shape at the specified index.
shapes(index: number): WorksheetShapeParameters
- index:
numberThe zero-based index of the shape to get.
Returns WorksheetShape
createPredefinedShape
Section titled "createPredefinedShape"Inherited from: WorksheetShape
Creates a shape which is predefined in Microsoft Excel.
createPredefinedShape(shapeType: PredefinedShapeType): WorksheetShapeParameters
- shapeType:
PredefinedShapeTypeThe type of shape to create.
Returns WorksheetShape
staticInit
Section titled "staticInit"Inherited from: WorksheetShape
staticInit(): void