options Field

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Workbook(host);
var value; // Type: Object
value = instance.options;

var options : Object;

The following examples set Workbook options.

Javascript

var workbook = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:5,showHorizontalScrollbar:false});
workbook.options.allowUserDragDrop = false;
workbook.options.allowUserZoom = false;

Javascript

spread.options.allowCopyPasteExcelStyle = true;
activeSheet.getCell(1, 0, GC.Spread.Sheets.SheetArea.viewport).backColor("Yellow");

Javascript

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.

Reference

Workbook type