Class WorksheetShapeCollection

Represents a collection of shapes on a Worksheet.

Inheritance

System.Object

ShapeCollection

WorksheetShapeCollection

Inherited Members

ShapeCollection.shapesById

ShapeCollection.shapesByName

ShapeCollection.duplicateShapesByName

ShapeCollection.Count

ShapeCollection.AddShape(ShapeType, Int32, String, Position, Size)

ShapeCollection.GetConnector(Int32)

ShapeCollection.GetConnector(String)

ShapeCollection.GetGroupShape(String)

ShapeCollection.GetPicture(String)

ShapeCollection.GetTextBox(String)

ShapeCollection.RemoveById(Int32)

ShapeCollection.RemoveByName(String)

ShapeCollection.Remove(AbstractShape)

ShapeCollection.GetEnumerator()

Namespace: DRIT.Spreadsheet.Drawing

Assembly: DRIT.Spreadsheet.dll

Syntax

public class WorksheetShapeCollection : ShapeCollection

Properties

Worksheet

Declaration

public Worksheet Worksheet { get; }

Property Value

Type	Description
Worksheet

Methods

AddConnector(ShapeType, Int32, String, String, PointDoubleUnit, SizeEmu)

Declaration

public ConnectorShape AddConnector(ShapeType shapeType, int id, string name, string label, PointDoubleUnit cellOffset, SizeEmu size)

Parameters

Type	Name	Description
ShapeType	shapeType
System.Int32	id
System.String	name
System.String	label
PointDoubleUnit	cellOffset
SizeEmu	size

Returns

Type	Description
ConnectorShape

AddConnector(ShapeType, Int32, String, String, Position, Size)

Declaration

public ConnectorShape AddConnector(ShapeType shapeType, int id, string name, string label, Position cellOffset, Size size)

Parameters

Type	Name	Description
ShapeType	shapeType
System.Int32	id
System.String	name
System.String	label
Position	cellOffset
Size	size

Returns

Type	Description
ConnectorShape

AddConnector(Int32, String, String, Position, Size)

Declaration

public ConnectorShape AddConnector(int id, string name, string label, Position cellOffsetPixel, Size size)

Parameters

Type	Name	Description
System.Int32	id
System.String	name
System.String	label
Position	cellOffsetPixel
Size	size

Returns

Type	Description
ConnectorShape

AddConnector(String, Position, Size)

Declaration

public ConnectorShape AddConnector(string label, Position cellOffsetPixel, Size size)

Parameters

Type	Name	Description
System.String	label
Position	cellOffsetPixel
Size	size

Returns

Type	Description
ConnectorShape

AddPicture(String, String, Position, Size)

Declaration

public PictureShape AddPicture(string filePath, string anchoredCellLabel, Position cellOffsetPixel, Size size)

Parameters

Type	Name	Description
System.String	filePath
System.String	anchoredCellLabel
Position	cellOffsetPixel
Size	size

Returns

Type	Description
PictureShape

AddShape(AbstractShape)

Declaration

public void AddShape(AbstractShape sheetShape)

Parameters

Type	Name	Description
AbstractShape	sheetShape

AddShape(ShapeType, Int32, String, String, Position, Size)

Declaration

public Shape AddShape(ShapeType shapeType, int id, string name, string cellLabel, Position cellOffset, Size size)

Parameters

Type	Name	Description
ShapeType	shapeType
System.Int32	id
System.String	name
System.String	cellLabel
Position	cellOffset
Size	size

Returns

Type	Description
Shape

AddShape(ShapeType, String, Position, Size)

Declaration

public Shape AddShape(ShapeType type, string label, Position cellOffsetPixel, Size size)

Parameters

Type	Name	Description
ShapeType	type
System.String	label
Position	cellOffsetPixel
Size	size

Returns

Type	Description
Shape

AddShape(Int32, String, String, Position, Size)

Declaration

public Shape AddShape(int id, string name, string cellLabel, Position cellOffset, Size size)

Parameters

Type	Name	Description
System.Int32	id
System.String	name
System.String	cellLabel
Position	cellOffset
Size	size

Returns

Type	Description
Shape

AddTextBox(Int32, String, String, Position, Size)

Declaration

public TextBoxShape AddTextBox(int id, string name, string label, Position cellOffset, Size size)

Parameters

Type	Name	Description
System.Int32	id
System.String	name
System.String	label
Position	cellOffset
Size	size

Returns

Type	Description
TextBoxShape

AddTextBox(String, Position, Size)

Declaration

public TextBoxShape AddTextBox(string label, Position cellOffsetPixel, Size size)

Parameters

Type	Name	Description
System.String	label
Position	cellOffsetPixel
Size	size

Returns

Type	Description
TextBoxShape

GetDiagram(String)

Declaration

public DiagramShape GetDiagram(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
DiagramShape

GetFirstConnectorByCell(String)

Declaration

public ConnectorShape GetFirstConnectorByCell(string label)

Parameters

Type	Name	Description
System.String	label

Returns

Type	Description
ConnectorShape

GetFirstShapeByCell(String)

Declaration

public Shape GetFirstShapeByCell(string label)

Parameters

Type	Name	Description
System.String	label

Returns

Type	Description
Shape

GetShape(String)

Declaration

public Shape GetShape(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
Shape

OnRemove(AbstractShape)

Declaration

protected override void OnRemove(AbstractShape shape)

Parameters

Type	Name	Description
AbstractShape	shape

Overrides

ShapeCollection.OnRemove(AbstractShape)