[]
DEMOS DOC DESIGNER API
DOWNLOAD
(Showing Draft Content)

GC.Spread.Sheets.IWorkBookDefaultOptions

Interface: IWorkBookDefaultOptions

Spread.Sheets.IWorkBookDefaultOptions

Table of contents

Properties

Properties

allSheetsListVisible

• Optional allSheetsListVisible: AllSheetsListVisibility

Whether the spreadsheet shows a special tab to allow the user to open the dialog to display all sheets. The default value is GC.Spread.Sheets.AllSheetsListVisibility.auto.

• Optional allowAutoCreateHyperlink: boolean

Whether to enable auto creating hyperlink in the spreadsheet. The default value is true.

allowAutoExtendFilterRange

• Optional allowAutoExtendFilterRange: boolean

Whether allow auto extend filter range like excel. The default value is false.

allowContextMenu

• Optional allowContextMenu: boolean

Whether to allow the user to open the built-in context menu. The default value is true.

allowCopyPasteExcelStyle

• Optional 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. The default value is true.

allowDragHeaderToMove

• Optional allowDragHeaderToMove: AllowDragHeaderToMove

Specifies how to allow drag header to move. The default value is GC.Spread.Sheets.AllowDragHeaderToMove.none.

allowDynamicArray

• Optional allowDynamicArray: boolean

Whether to enable dynamic array. The default value is false.

allowExtendPasteRange

• Optional allowExtendPasteRange: boolean

Whether extend paste range if the paste range is not enough for pasting. The default value is false.

allowInvalidFormula

• Optional allowInvalidFormula: boolean

Whether allow input invalid formula string. The default value is false.

allowSheetReorder

• Optional allowSheetReorder: boolean

Whether the user can reorder the sheets in the Spread component. The default value is true.

allowUndo

• Optional allowUndo: boolean

Whether to allow the user to undo edits. The default value is true.

allowUserDeselect

• Optional allowUserDeselect: boolean

Whether to allow the user to can use deselect in selection. The default value is true.

allowUserDragDrop

• Optional allowUserDragDrop: boolean

Whether to allow the user to drag and drop range data. The default value is true.

allowUserDragFill

• Optional allowUserDragFill: boolean

Whether to allow the user to drag fill a range. The default value is true.

allowUserDragMerge

• Optional allowUserDragMerge: boolean

Whether to allow the user to drag merge cells. The default value is false.

allowUserEditFormula

• Optional allowUserEditFormula: boolean

Whether the user can edit formulas in a cell in the spreadsheet. The default value is true.

allowUserResize

• Optional allowUserResize: boolean

Whether to allow the user to resize columns and rows. The default value is true.

allowUserZoom

• Optional allowUserZoom: boolean

Whether to zoom the display by scrolling the mouse wheel while pressing the Ctrl key. The default value is true.

autoFitType

• Optional autoFitType: AutoFitType

Whether content will be formatted to fit in cells or in cells and headers. The default value is GC.Spread.Sheets.AutoFitType.cell.

backColor

• Optional 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. The default value is "white".

backgroundImage

• Optional backgroundImage: null | string

The background image of the Spread component. It can be a URL string or base64 string.

backgroundImageLayout

• Optional backgroundImageLayout: ImageLayout

The background image layout for the Spread component. The default value is GC.Spread.Sheets.ImageLayout.stretch.

builtInFileIcons

• Optional builtInFileIcons: IBuiltInFileIcons

All built-in file icons.

calcOnDemand

• Optional calcOnDemand: boolean

Whether to calculate formulas only when they are demanded. The default value is false.

calculationMode

• Optional calculationMode: CalculationMode

The recalculation behavior of the workbook. The default value is GC.Spread.Sheets.CalculationMode.auto.

columnResizeMode

• Optional columnResizeMode: ResizeMode

Specifies the way to resize column. The default value is GC.Spread.Sheets.ResizeMode.normal.

copyPasteHeaderOptions

• Optional copyPasteHeaderOptions: CopyPasteHeaderOptions

Which headers are included when data is copied to or pasted. The default value is GC.Spread.Sheets.CopyPasteHeaderOptions.allHeaders.

customList

• Optional customList: string[][]

The list for user to customize drag fill, prioritize matching this list in each fill. Each array item is type of string array. For example, [["Custom1", "C1"], ["Custom2", "C2", "C3"]]. When user drag fill "Custom1", the filled value is "C1"; when user drag fill "Custom2", the filled values are "C2", "C3".

cutCopyIndicatorBorderColor

• Optional cutCopyIndicatorBorderColor: string

The border color for the indicator displayed when the user cuts or copies the selection. The default value is "#217346".

cutCopyIndicatorVisible

• Optional cutCopyIndicatorVisible: boolean

Whether to display an indicator when copying or cutting the selected item. The default value is true.

defaultDragFillType

• Optional defaultDragFillType: AutoFillType

The default fill type. The default value is GC.Spread.Sheets.Fill.AutoFillType.auto.

defaultSheetTabStyles

• Optional defaultSheetTabStyles: SheetTabStyles

All default state styles for sheet tabs.

enableAccessibility

• Optional enableAccessibility: boolean

Whether to enable the accessibility support in the spreadsheet. The default value is false.

enableFormulaTextbox

• Optional enableFormulaTextbox: boolean

Whether to enable the formula text box in the spreadsheet. The default value is true.

font

• Optional font: string

The tab strip font.

formulaFormatHint

• Optional formulaFormatHint: boolean

Whether automatically generate the format when formula inputs. The default value is true.

grayAreaBackColor

• Optional grayAreaBackColor: null | 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. The default value is null which means using the theme default color.

hideSelection

• Optional hideSelection: boolean

Whether to display the selection highlighting when the Spread component does not have focus. The default value is false.

highlightInvalidData

• Optional highlightInvalidData: boolean

Whether to highlight invalid data. The default value is false.

incrementalCalculation

• Optional incrementalCalculation: boolean

Whether to incremental calculate formulas without blocking UI. The default value is false.

iterativeCalculation

• Optional iterativeCalculation: boolean

Whether to enable the iterative calculation. The default value is true.

iterativeCalculationMaximumChange

• Optional iterativeCalculationMaximumChange: number

The Maximum Change when iterative calculation. The default value is 0.01.

iterativeCalculationMaximumIterations

• Optional iterativeCalculationMaximumIterations: number

The Maximum Iterations when iterative calculation. The default value is 1000.

newTabVisible

• Optional newTabVisible: boolean

Whether the spreadsheet displays the special tab to let users insert new sheets. The default value is true.

pasteSkipInvisibleRange

• Optional pasteSkipInvisibleRange: boolean

Whether paste skip invisible range. The default value is false.

pivotAreaReference

• Optional pivotAreaReference: PivotAreaReference

Whether automatically generate the getPivotData formula or cell reference when choose pivot table data area. The default value is GC.Spread.Pivot.PivotAreaReference.getPivotData.

referenceStyle

• Optional referenceStyle: ReferenceStyle

The style for cell and range references in cell formulas on the workbook. The default value is GC.Spread.Sheets.ReferenceStyle.a1.

resizeZeroIndicator

• Optional resizeZeroIndicator: ResizeZeroIndicator

The drawing policy when the row or column is resized to zero. The default value is GC.Spread.Sheets.ResizeZeroIndicator.enhanced.

rowResizeMode

• Optional rowResizeMode: ResizeMode

Specifies the way to resize row. The default value is GC.Spread.Sheets.ResizeMode.normal.

scrollByPixel

• Optional scrollByPixel: boolean

Whether to enable the precision scrolling by pixel. The default value is false.

scrollIgnoreHidden

• Optional scrollIgnoreHidden: boolean

Whether the scroll bar ignores hidden rows or columns. The default value is false.

scrollPixel

• Optional scrollPixel: number

Decides scrolling by that number of pixels at a time when scrollByPixel is true. The final scrolling pixels are the result of scrolling delta multiply scrollPixel. For example, the scrolling delta is 3, and the scrollPixel is 5, the final scrolling pixels are 15. The default value is 5.

scrollbarAppearance

• Optional scrollbarAppearance: ScrollbarAppearance

The scrollbar appearance, contains skin and mobile two enums. The default value is GC.Spread.Sheets.ScrollbarAppearance.skin.

scrollbarMaxAlign

• Optional scrollbarMaxAlign: boolean

Whether the scroll bar aligns with the last row and column of the active sheet. The default value is false.

scrollbarShowMax

• Optional scrollbarShowMax: boolean

Whether the displayed scroll bars are based on the entire number of columns and rows in the sheet. The default value is true.

sheetCount

• Optional sheetCount: number

The number of sheets. The default value is 1.

showDragDropTip

• Optional showDragDropTip: boolean

Whether to display the drag-drop tip. The default value is true.

showDragFillSmartTag

• Optional showDragFillSmartTag: boolean

Whether to display the drag fill dialog. The default value is true.

showDragFillTip

• Optional showDragFillTip: boolean

Whether to display the drag-fill tip. The default value is true.

showHorizontalScrollbar

• Optional showHorizontalScrollbar: boolean

Whether to display the horizontal scroll bar. The default value is true.

showResizeTip

• Optional showResizeTip: ShowResizeTip

How to display the resize tip. The default value is GC.Spread.Sheets.ShowResizeTip.none.

showScrollTip

• Optional showScrollTip: ShowScrollTip

How to display the scroll tip. The default value is GC.Spread.Sheets.ShowScrollTip.none.

showVerticalScrollbar

• Optional showVerticalScrollbar: boolean

Whether to display the vertical scroll bar. The default value is true.

tabEditable

• Optional tabEditable: boolean

Whether to allow the user to edit the sheet tab strip. The default value is true.

tabNavigationVisible

• Optional tabNavigationVisible: boolean

Whether to display the sheet tab navigation. The default value is true.

tabStripRatio

• Optional tabStripRatio: number

The width of the tab strip expressed as a percentage of the overall horizontal scroll bar width. The default value is 0.5.

tabStripVisible

• Optional tabStripVisible: boolean

Whether to display the sheet tab strip. The default value is true.

useTouchLayout

• Optional useTouchLayout: boolean

Whether to use touch layout to present the Spread component. The default value is false.