var instance = new GC.Spread.Sheets.Workbook(host); var value; // Type: Object value = instance.options;
var options : Object;
var instance = new GC.Spread.Sheets.Workbook(host); var value; // Type: Object value = instance.options;
var options : Object;
spread.options.allowCopyPasteExcelStyle = true; activeSheet.getCell(1, 0, GC.Spread.Sheets.SheetArea.viewport).backColor("Yellow");
spread.options.allowExtendPasteRange = true;
Name | Type | Description |
---|---|---|
allowUserDragDrop |
boolean | Whether to allow the user to drag and drop range data. |
allowUserDragFill |
boolean | Whether to allow the user to drag fill a range. |
allowUserZoom |
boolean | Whether to zoom the display by scrolling the mouse wheel while pressing the Ctrl key. |
allowUserResize |
boolean | Whether to allow the user to resize columns and rows. |
allowUndo |
boolean | Whether to allow the user to undo edits. |
allowSheetReorder |
boolean | Whether the user can reorder the sheets in the Spread component. |
defaultDragFillType |
GC.Spread.Sheets.Fill.AutoFillType | The default fill type. |
showDragFillSmartTag |
boolean | Whether to display the drag fill dialog. |
showHorizontalScrollbar |
boolean | Whether to display the horizontal scroll bar. |
showVerticalScrollbar |
boolean | Whether to display the vertical scroll bar. |
scrollbarShowMax |
boolean | Whether the displayed scroll bars are based on the entire number of columns and rows in the sheet. |
scrollbarMaxAlign |
boolean | Whether the scroll bar aligns with the last row and column of the active sheet. |
tabStripVisible |
boolean | Whether to display the sheet tab strip. |
tabStripRatio |
number | The width of the tab strip expressed as a percentage of the overall horizontal scroll bar width. |
tabEditable |
boolean | Whether to allow the user to edit the sheet tab strip. |
newTabVisible |
boolean | Whether the spreadsheet displays the special tab to let users insert new sheets. |
tabNavigationVisible |
boolean | Whether to display the sheet tab navigation. |
cutCopyIndicatorVisible |
boolean | Whether to display an indicator when copying or cutting the selected item. |
cutCopyIndicatorBorderColor |
string | The border color for the indicator displayed when the user cuts or copies the selection. |
backColor |
string | A color string used to represent the background color of the Spread component, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on. |
backgroundImage |
string | The background image of the Spread component. |
backgroundImageLayout |
GC.Spread.Sheets.ImageLayout | The background image layout for the Spread component. |
grayAreaBackColor |
string | A color string used to represent the background color of the gray area , such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on. |
showResizeTip |
GC.Spread.Sheets.ShowResizeTip | How to display the resize tip. |
showDragDropTip |
boolean | Whether to display the drag-drop tip. |
showDragFillTip |
boolean | Whether to display the drag-fill tip. |
showScrollTip |
GC.Spread.Sheets.ShowScrollTip | How to display the scroll tip. |
scrollIgnoreHidden |
boolean | Whether the scroll bar ignores hidden rows or columns. |
highlightInvalidData |
boolean | Whether to highlight invalid data. |
useTouchLayout |
boolean | Whether to use touch layout to present the Spread component. |
hideSelection |
boolean | Whether to display the selection highlighting when the Spread component does not have focus. |
resizeZeroIndicator |
GC.Spread.Sheets.ResizeZeroIndicator | The drawing policy when the row or column is resized to zero. |
allowUserEditFormula |
boolean | Whether the user can edit formulas in a cell in the spreadsheet. |
enableFormulaTextbox |
boolean | Whether to enable the formula text box in the spreadsheet. |
autoFitType |
GC.Spread.Sheets.AutoFitType | Whether content will be formatted to fit in cells or in cells and headers. |
referenceStyle |
GC.Spread.Sheets.ReferenceStyle | the style for cell and range references in cell formulas on this sheet. |
allowCopyPasteExcelStyle |
boolean | Whether the user can copy style from Spread Sheets then paste to Excel, or copy style from Excel then paste to Spread Sheets. |
allowExtendPasteRange |
boolean | Whether extend paste range if the paste range is not enough for pasting. |
copyPasteHeaderOptions |
GC.Spread.Sheets.CopyPasteHeaderOptions | Which headers are included when data is copied to or pasted. |