GrapeCity.SpreadBuilder.DDSheet

DDSheet Class

Represents a WorkSheet.

Inheritance

DDSheet

Namespace: GrapeCity.SpreadBuilder

Assembly: MESCIUS.ActiveReports.SpreadBuilder.dll

Syntax

public class DDSheet

Properties

Name	Description
ColumnsCount	Get columns count.
DisplayGridLines	Gets or sets the flag indicating whether gridlines are displayed in the sheet.
HasMergeAreas	Gets whether or not this sheet has merged areas
ImagesCount	Gets the number of images.
Name	Gets or sets the name of this DDSheet.
PageBreaksHorizontal	Gets collection of horizontal page breaks.
PageBreaksVertical	Gets a collection of vertical page breaks.
PageSetup	Gets a PageSetup class that represents current information about this sheet when it is printed.
ParentSheets	Gets the DDSheets collection that this DDSheet is a member of.
RowsCount	Gets rows count.

Methods

Name	Description
AddHorizontalPageBreak(ushort, ushort, ushort)	Adds a horizontal page break to the sheet.
AddImage(byte[], ImageInfo, Color, Color, int, short, int, short, int, short, int, short, string)	Adds the specified image (currently saved as PNG) to this sheet at the specified location and with the specified settings.
AddLine(LineInfo)	Adds a line with specified coordinates and properties.
AddVerticalPageBreak(ushort, ushort, ushort)	Adds a vertical page break to the sheet.
Cell(int, int)	Returns the DDCell object located in the specified row and column.
Cells(DDCell, DDCell)	Returns the collection of DDCells between the specified DDCells.
Clear()	Deletes all properties and content, effectively creating a blank sheet.
Columns(short)	Returns the DDColumn object that represents the specified column.
FixImageOffset(bool)	Adjusts the position of images in the sheet to ensure they align correctly with cell boundaries.
IsMerged(int, int)	Gets whether a cell at specified coordinates is merged, or not.
Rows(int)	Returns a DDRow instance for the specified row number.
SetColumnWidth(short, float)	Sets the column width on the BiffRow object that represents the specified row number.
SetRowAutoSize(int, bool)	Sets the AutoSize property for the row. If the value is false, the height of the row may differ from the height of the font. If the value is true, the height of the row is based directly on the size of the text in the row.
SetRowHeight(int, short)	Sets the row height on the BiffRow object that represents the specified row number.
UnMergeCells(int, int)	Removes the MergeArea containing the cell at the specified coordinates from the MergedAreas record for this sheet.