Spread.Sheets Documentation
options Field
GC.Spread.Sheets Namespace > Workbook type : options Field
Represents the options of the Spread control.
Syntax
var instance = new GC.Spread.Sheets.Workbook(host);
var value; // Type: Object
value = instance.options;
var options : Object;
Example
The following examples set Workbook options.
spread.options.allowCopyPasteExcelStyle = true;
activeSheet.getCell(1, 0, GC.Spread.Sheets.SheetArea.viewport).backColor("Yellow");
spread.options.allowExtendPasteRange = true;
Remarks
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.
See Also

Reference

Workbook type