[]
        
(Showing Draft Content)

GC.Spread.Sheets.IWorksheetOptions

Interface: IWorksheetOptions

Spread.Sheets.IWorksheetOptions

Table of contents

Properties

Properties

addColumnButtonOption

Optional addColumnButtonOption: IAddColumnButtonOption

The add column button's options.


addRowButtonOption

Optional addRowButtonOption: IAddRowButtonOption

The add row button's options.


allowCellOverflow

allowCellOverflow: boolean

indicates whether data can overflow into adjacent empty cells.


clipBoardOptions

clipBoardOptions: ClipboardPasteOptions

The clipboard option.


colHeaderAutoText

colHeaderAutoText: HeaderAutoText

Indicates whether the column header displays letters or numbers or is blank.


colHeaderAutoTextIndex

colHeaderAutoTextIndex: HeaderAutoText

Specifies which column header row displays the automatic text when there are multiple column header rows.


colHeaderVisible

colHeaderVisible: boolean

Indicates whether the column header is visible.


frozenlineColor

frozenlineColor: string

A color string used to represent the frozen line color, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on.


gridline

gridline: IWorkSheetGridlineOption

The grid line's options.


isProtected

isProtected: boolean

Indicates whether cells on this sheet that are marked as protected cannot be edited.


keepUnknownFormulas

keepUnknownFormulas: boolean

Indicates whether the unknown formulas could be included in sheet json data.


protectionOptions

protectionOptions: IProtectionOptions

A value that indicates the elements that you want users to be able to change.


rightToLeft

rightToLeft: boolean

Indicates whether the sheet is rendered from right to left.


rowHeaderAutoText

rowHeaderAutoText: HeaderAutoText

Indicates whether the row header displays letters or numbers or is blank.


rowHeaderAutoTextIndex

rowHeaderAutoTextIndex: HeaderAutoText

Specifies which row header column displays the automatic text when there are multiple row header columns.


rowHeaderVisible

rowHeaderVisible: boolean

Indicates whether the row header is visible.


selectionBackColor

selectionBackColor: string

The selection's background color for the sheet.


selectionBorderColor

selectionBorderColor: string

The selection's border color for the sheet.


sheetAreaOffset

sheetAreaOffset: IWorkSheetSheetAreaOffsetOption

The sheetAreaOffset's options.


sheetTabColor

sheetTabColor: string

A color string used to represent the sheet tab color, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on.


showFormulas

showFormulas: boolean

indicates whether display the formulas string not the formula result.


showZeros

showZeros: boolean

indicates whether display the 0 in cells containing zero value. Default is true.