var instance = new GC.Spread.Sheets.Worksheet(name); var value; // Type: Object value = instance.options;
var options : Object;
var instance = new GC.Spread.Sheets.Worksheet(name); var value; // Type: Object value = instance.options;
var options : Object;
This table lists the Worksheet options.
Name | Type | Description |
allowCellOverflow | boolean | Specifies whether data can overflow into adjacent empty cells, optional. |
sheetTabColor | string | A color string used to represent the sheet tab color, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on, optional. |
frozenlineColor | string | A color string used to represent the frozen line color, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on, optional. |
clipBoardOptions | GC.Spread.Sheets.ClipboardPasteOptions | The clipboard option, optional. |
gridline | object | The grid line's options, optional. |
gridline.color | string | The grid line color, optional. |
gridline.showVerticalGridline | boolean | Specifies whether to show the vertical grid line, optional. |
gridline.showHorizontalGridline | boolean | Specifies whether to show the horizontal grid line, optional. |
rowHeaderVisible | boolean | Specifies whether the row header is visible, optional. |
colHeaderVisible | boolean | Specifies whether the column header is visible, optional. |
rowHeaderAutoText | GC.Spread.Sheets.HeaderAutoText | Specifies whether the row header displays letters or numbers or is blank, optional. |
colHeaderAutoText | GC.Spread.Sheets.HeaderAutoText | Specifies whether the column header displays letters or numbers or is blank, optional. |
rowHeaderAutoTextIndex | number | Specifies which row header column displays the automatic text when there are multiple row header columns, optional. |
colHeaderAutoTextIndex | number | Specifies which column header row displays the automatic text when there are multiple column header rows, optional. |
isProtected | boolean | Specifies whether cells on this sheet that are marked as protected cannot be edited, optional. |
protectionOptions | object | A value that indicates the elements that you want users to be able to change, optional. |
protectionOptions.allowSelectLockedCells | boolean | Specifies whether the user can select locked cells, optional. |
protectionOptions.allowSelectUnlockedCells | boolean | Specifies whether the user can select unlocked cells, optional. |
protectionOptions.allowSort | boolean | Specifies whether the user can sort ranges, optional. |
protectionOptions.allowFilter | boolean | Specifies whether the user can filter ranges, optional. |
protectionOptions.allowEditObjects | boolean | Specifies whether the user can edit floating objects, optional. |
protectionOptions.allowResizeRows | boolean | Specifies whether the user can resize columns, optional. |
protectionOptions.allowDragInsertRows | boolean | Specifies whether the user can perform the drag operation to insert rows. |
protectionOptions.allowDragInsertColumns | boolean | Specifies whether the user can perform the drag operation to insert columns. |
protectionOptions.allowInsertRows | boolean | Specifies whether the user can insert rows. |
protectionOptions.allowInsertColumns | boolean | Specifies whether the user can insert columns. |
protectionOptions.allowDeleteRows | boolean | Specifies whether the user can delete rows. |
protectionOptions.allowDeleteColumns | boolean | Specifies whether the user can delete columns. |
selectionBackColor | string | The selection's background color for the sheet, optional. |
selectionBorderColor | string | The selection's border color for the sheet, optional. |