Interface: IWorkBookDefaultOptions

Spread.Sheets.IWorkBookDefaultOptions

Table of contents

Properties

• allSheetsListVisible
• allowAutoCreateHyperlink
• allowAutoExtendFilterRange
• allowContextMenu
• allowCopyPasteExcelStyle
• allowDragHeaderToMove
• allowDynamicArray
• allowExtendPasteRange
• allowSheetReorder
• allowUndo
• allowUserDeselect
• allowUserDragDrop
• allowUserDragFill
• allowUserDragMerge
• allowUserEditFormula
• allowUserResize
• allowUserZoom
• autoFitType
• backColor
• backgroundImage
• backgroundImageLayout
• builtInFileIcons
• calcOnDemand
• calculationMode
• columnResizeMode
• copyPasteHeaderOptions
• customList
• cutCopyIndicatorBorderColor
• cutCopyIndicatorVisible
• defaultDragFillType
• defaultSheetTabStyles
• enableAccessibility
• enableFormulaTextbox
• font
• grayAreaBackColor
• hideSelection
• highlightInvalidData
• incrementalCalculation
• iterativeCalculation
• iterativeCalculationMaximumChange
• iterativeCalculationMaximumIterations
• newTabVisible
• pasteSkipInvisibleRange
• pivotAreaReference
• referenceStyle
• resizeZeroIndicator
• rowResizeMode
• scrollByPixel
• scrollIgnoreHidden
• scrollPixel
• scrollbarMaxAlign
• scrollbarShowMax
• sheetCount
• showDragDropTip
• showDragFillSmartTag
• showDragFillTip
• showHorizontalScrollbar
• showResizeTip
• showScrollTip
• showVerticalScrollbar
• tabEditable
• tabNavigationVisible
• tabStripRatio
• tabStripVisible
• useTouchLayout

Properties

allSheetsListVisible

• Optional allSheetsListVisible: AllSheetsListVisibility

---

allowAutoCreateHyperlink

• Optional allowAutoCreateHyperlink: boolean

---

allowAutoExtendFilterRange

• Optional allowAutoExtendFilterRange: boolean

---

allowContextMenu

• Optional allowContextMenu: boolean

---

allowCopyPasteExcelStyle

• Optional allowCopyPasteExcelStyle: boolean

---

allowDragHeaderToMove

• Optional allowDragHeaderToMove: AllowDragHeaderToMove

---

allowDynamicArray

• Optional allowDynamicArray: boolean

---

allowExtendPasteRange

• Optional allowExtendPasteRange: boolean

---

allowSheetReorder

• Optional allowSheetReorder: boolean

---

allowUndo

• Optional allowUndo: boolean

---

allowUserDeselect

• Optional allowUserDeselect: boolean

---

allowUserDragDrop

• Optional allowUserDragDrop: boolean

---

allowUserDragFill

• Optional allowUserDragFill: boolean

---

allowUserDragMerge

• Optional allowUserDragMerge: boolean

---

allowUserEditFormula

• Optional allowUserEditFormula: boolean

---

allowUserResize

• Optional allowUserResize: boolean

---

allowUserZoom

• Optional allowUserZoom: boolean

---

autoFitType

• Optional autoFitType: AutoFitType

---

backColor

• Optional backColor: string

---

backgroundImage

• Optional backgroundImage: null | string

---

backgroundImageLayout

• Optional backgroundImageLayout: ImageLayout

---

builtInFileIcons

• Optional builtInFileIcons: IBuiltInFileIcons

---

calcOnDemand

• Optional calcOnDemand: boolean

---

calculationMode

• Optional calculationMode: CalculationMode

---

columnResizeMode

• Optional columnResizeMode: ResizeMode

---

copyPasteHeaderOptions

• Optional copyPasteHeaderOptions: CopyPasteHeaderOptions

---

customList

• Optional customList: string[][]

---

cutCopyIndicatorBorderColor

• Optional cutCopyIndicatorBorderColor: string

---

cutCopyIndicatorVisible

• Optional cutCopyIndicatorVisible: boolean

---

defaultDragFillType

• Optional defaultDragFillType: AutoFillType

---

defaultSheetTabStyles

• Optional defaultSheetTabStyles: SheetTabStyles

---

enableAccessibility

• Optional enableAccessibility: boolean

---

enableFormulaTextbox

• Optional enableFormulaTextbox: boolean

---

font

• Optional font: string

---

grayAreaBackColor

• Optional grayAreaBackColor: null | string

---

hideSelection

• Optional hideSelection: boolean

---

highlightInvalidData

• Optional highlightInvalidData: boolean

---

incrementalCalculation

• Optional incrementalCalculation: boolean

---

iterativeCalculation

• Optional iterativeCalculation: boolean

---

iterativeCalculationMaximumChange

• Optional iterativeCalculationMaximumChange: number

---

iterativeCalculationMaximumIterations

• Optional iterativeCalculationMaximumIterations: number

---

newTabVisible

• Optional newTabVisible: boolean

---

pasteSkipInvisibleRange

• Optional pasteSkipInvisibleRange: boolean

---

pivotAreaReference

• Optional pivotAreaReference: PivotAreaReference

---

referenceStyle

• Optional referenceStyle: number

---

resizeZeroIndicator

• Optional resizeZeroIndicator: ResizeZeroIndicator

---

rowResizeMode

• Optional rowResizeMode: ResizeMode

---

scrollByPixel

• Optional scrollByPixel: boolean

---

scrollIgnoreHidden

• Optional scrollIgnoreHidden: boolean

---

scrollPixel

• Optional scrollPixel: number

---

scrollbarMaxAlign

• Optional scrollbarMaxAlign: boolean

---

scrollbarShowMax

• Optional scrollbarShowMax: boolean

---

sheetCount

• Optional sheetCount: number

---

showDragDropTip

• Optional showDragDropTip: boolean

---

showDragFillSmartTag

• Optional showDragFillSmartTag: boolean

---

showDragFillTip

• Optional showDragFillTip: boolean

---

showHorizontalScrollbar

• Optional showHorizontalScrollbar: boolean

---

showResizeTip

• Optional showResizeTip: ShowResizeTip

---

showScrollTip

• Optional showScrollTip: ShowScrollTip

---

showVerticalScrollbar

• Optional showVerticalScrollbar: boolean

---

tabEditable

• Optional tabEditable: boolean

---

tabNavigationVisible

• Optional tabNavigationVisible: boolean

---

tabStripRatio

• Optional tabStripRatio: number

---

tabStripVisible

• Optional tabStripVisible: boolean

---

useTouchLayout

• Optional useTouchLayout: boolean