Class WorksheetDesign
Contents
[
Hide
]WorksheetDesign class
Inherited from WebWorksheet. Used in design-time only.
public class WorksheetDesign : WebWorksheet
Constructors
| Name | Description |
|---|---|
| WorksheetDesign() | Default constructor. |
| WorksheetDesign(MainWeb, GridWorksheet) | the constructor with MainWeb and 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 worksheets.(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, GridTableItemStyle, GridTableItemStyle, NumberType, string) | Creates subtotal in the sheet.(Inherited from WebWorksheet.) |
| override DataBind() | Bind the sheet to the DataSource.(Inherited from WebWorksheet.) |
| DeleteBindRow(int) | Deletes a bind row.(Inherited from WebWorksheet.) |
| FreezePanes(int, int, int, int) | Freezes panes at the specified cell in the worksheet.(Inherited from WebWorksheet.) |
| GroupRows(int, int) | Groups rows.(Inherited from WebWorksheet.) |
| GroupRows(int, int, bool) | Groups rows.(Inherited from WebWorksheet.) |
| SetAllCellsEditable() | Makes all cells editable.this is extended attribute(Inherited from WebWorksheet.) |
| SetAllCellsReadonly() | Makes all cells readonly.this is extended attribute notice this attribute can not keep in actual cell,if you want to keep protect please use setProtect(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() | Unfreezes panes in the worksheet.(Inherited from WebWorksheet.) |
| UngroupRows(int, int) | Ungroups rows.(Inherited from WebWorksheet.) |
| UpdateBindCellValue(GridCell) | Updates the binding datasource record’s property value according to the cell’s value.(Inherited from WebWorksheet.) |
See Also
- class WebWorksheet
- namespace Aspose.Cells.GridWeb
- assembly Aspose.Cells.GridWeb
