WorksheetDesign

WorksheetDesign class

Inherited from WebWorksheet. Used in design-time only.

public class WorksheetDesign : WebWorksheet

Constructors

Name Description
WorksheetDesign() Default constructor.
WorksheetDesign(MainWeb, GridWorksheet)

Properties

Name Description
BindColumns { get; } Bind columns collection.(Inherited from WebWorksheet.)
BindingSource { get; } The actually binding datasource object at run-time. It is a DataView object when the DataSource property is a DataSet, DataTable or DataView object.(Inherited from WebWorksheet.)
BindStartColumn { get; set; } In data-binding mode, BindStartRow and BindStartColumn indicate the position of the grid to bind bo the datasource.(Inherited from WebWorksheet.)
BindStartRow { get; set; } In data-binding mode, BindStartRow and BindStartColumn indicate the position of the grid to bind bo the datasource.(Inherited from WebWorksheet.)
CellImages { get; } (Inherited from WebWorksheet.)
Cells { get; } Gets the WebCells.(Inherited from WebWorksheet.)
Comments { get; } (Inherited from WebWorksheet.)
CurrentBindRows { get; set; } Gets the binding rows number in data-binding mode.(Inherited from WebWorksheet.)
DataMember { get; set; } Gets or sets the DataMember from the multi-member DataSource. Generally it represents a DataTable object of a DataSet.(Inherited from WebWorksheet.)
DataSource { get; set; } Gets or sets the DataSource. Generally it’s a DataSet object.(Inherited from WebWorksheet.)
EnableCreateBindColumnHeader { get; set; } In data-binding mode, indicates whether to create bind column header captions in the sheet.(Inherited from WebWorksheet.)
Hyperlinks { get; } Gets the HyperlinkCollection collection.(Inherited from WebWorksheet.)
Index { get; } Gets the index of itself within the WebWorksheets.(Inherited from WebWorksheet.)
IsProtected { get; set; } Gets or sets whether the worksheet is protected. When a worksheet is protected, all the cells can not be edit except the cell whose IsLocked property is false.(Inherited from WebWorksheet.)
Name { get; set; } Gets or sets the name of the sheet.(Inherited from WebWorksheet.)
RowFilter { get; } (Inherited from WebWorksheet.)
Validations { get; } Gets the data validation setting collection in the worksheet.(Inherited from WebWorksheet.)
override Visible { get; set; } Indicates whether this sheet’s name is shown in the sheet tabs of the control.(Inherited from WebWorksheet.)

Methods

Name Description
AutoFitColumn(int) Autofits the column width.(Inherited from WebWorksheet.)
AutoFitColumn(int, int, int) Autofits the column width. This method autofits a column based on content in a range of cells within the column from startRow to endRow. AutoFitColumn is an imprecise function.(Inherited from WebWorksheet.)
CancelNewBindRow() Cancels and deletes the new added bind row.(Inherited from WebWorksheet.)
CommitNewBindRow() Commits the new added bind row and add it to the datasource.(Inherited from WebWorksheet.)
Copy(WebWorksheet) Copies from another worksheet object.(Inherited from WebWorksheet.)
CreateAutoGenratedColumns() After setting a datasource for the worksheet, call this method to generate the bind columns automatically.(Inherited from WebWorksheet.)
CreateNewBindRow() Creates a new bind row and bind to the datasource.(Inherited from WebWorksheet.)
CreateSubtotal(int, int, int, SubtotalFunction, int[], string, TableItemStyle, TableItemStyle, NumberType, string) Creates subtotal in the sheet.(Inherited from WebWorksheet.)
override DataBind() Bind the sheet to the DataSource.(Inherited from WebWorksheet.)
DataSourceControlUpdate(AccessDataSource) (Inherited from WebWorksheet.)
DeleteBindRow(int) Deletes a bind row.(Inherited from WebWorksheet.)
FreezePanes(int, int, int, int) (Inherited from WebWorksheet.)
GroupRows(int, int) Groups rows.(Inherited from WebWorksheet.)
GroupRows(int, int, bool) Groups rows.(Inherited from WebWorksheet.)
RemoveSubtotal() (Inherited from WebWorksheet.)
SetAllCellsEditable() (Inherited from WebWorksheet.)
SetAllCellsReadonly() (Inherited from WebWorksheet.)
SetEditableRange(int, int, int, int) Makes a range of cells editable. http://docs.aspose.com:8082/docs/display/cellsnet/Protecting+Cells Make all cells read only by calling the SetAllCellsReadonly method. then call this method to Specify the range of cells that to be editable(Inherited from WebWorksheet.)
SetReadonlyRange(int, int, int, int) Makes a range of cells readonly. http://docs.aspose.com:8082/docs/display/cellsnet/Protecting+Cells First make all cells editable by calling the SetAllCellsEditable method. then call this method to Specify the range of cells that to be readonly(Inherited from WebWorksheet.)
UnfreezePanes() (Inherited from WebWorksheet.)
UngroupRows(int, int) (Inherited from WebWorksheet.)
UpdateBindCellValue(GridCell) Updates the binding datasource record’s property value according to the cell’s value.(Inherited from WebWorksheet.)

See Also