Skip to content
Spreadsheet Engine
Search
Ctrl
K
Cancel
grid.is
npm
Select theme
Dark
Light
Auto
Getting started
Tips
API reference
Classes
Cell
CellVertexId
CommentsManager
DataTableEditBlockedError
DefinedName
EditBlockedError
EvaluationError
FormulaError
FormulaSyntaxError
Lambda
Matrix
MergedCellWriteBlockedError
Model
ModelError
NamedStyles
NameNotFoundError
NameVertexId
NotesManager
PivotCache
PivotCellWriteBlockedError
PivotDuplicateSourceHeadersError
PivotEditBlockedError
PivotManager
PivotOutputOverlapsDataError
PivotTable
Range
RangeVertexId
Reference
ReorderMergeBlockedError
SheetEdgeBlockedError
SheetNotFoundError
SortCellsBlockedError
StyleManager
Table
TableEditBlockedError
TableManager
ThemeManager
ValueBox
ValueSnapshot
VertexId
VertexIdSet
ViewManager
Workbook
WorkbookDescription
WorkbookNotFoundError
WorkbookView
WorkSheet
Interfaces
AddWorkbookOptions
CellInterface
CellStyle
EvaluateExpressionOptions
EvaluationContext
ModelMeta
WorkbookBody
WriteOptions
Type Aliases
A1Reference
AddCommentInput
AreaArray
AreaBoxedValueArray
AreaCellArray
AreaValueArray
ArrayValue
AxisCSF
CellCSF
CellData
CellItem
CellValue
CellValueAtom
ChartCSF
CloudConnection
ColumnInfo
DataTableBlockedOperation
Dimension
DrawingCSF
FillType
FilterOptions
FormulaArgument
FormulaValue
IterationOptions
KnownVertexId
MaybeBoxed
MaybeBoxedFormulaArgument
MaybeBoxedFormulaValue
ModelEntity
ModelEventArgs
ModelEventListener
ModelEventType
NamedStyleDeleteResult
NamedStyleRenameResult
NameReference
NonMatrixFormulaArgument
OutputBounds
Parameter
PivotBlockedOperation
PivotColRole
PivotLookupError
PivotLookupErrorReason
PivotPageArea
PivotRowRole
RecalcEvent
RecalculateOptions
ReplaceSheetReferencesFn
ReplaceTableReferencesFn
ReplaceWorkbookReferencesFn
RewriteFormula
SheetCSF
SheetEdgeBlockedReason
SlimRange
SlimRangeOrCoords
SortCellsBlockedReason
SortKey
SortOptions
TableBlockedOperation
TableColumnCSF
TableCSF
ToXLSXOptions
ViewSelection
WorkbookCSF
WorkbookOptions
WorkbookType
XLSXOutputType
Variables
ALL_FORMULA_CELLS
CHANGED_ONLY
CHANGED_OR_VOLATILE
ERROR_CALC
ERROR_DIV0
ERROR_FIELD
ERROR_GETDATA
ERROR_NA
ERROR_NAME
ERROR_NULL
ERROR_NUM
ERROR_REF
ERROR_SPILL
ERROR_SYNTAX
ERROR_UNKNOWN
ERROR_VALUE
FILL_TYPES
formulaParserReady
functions
getReplaceSheetReferencesFn
getReplaceTableReferencesFn
getReplaceWorkbookFn
MAX_COL
MAX_ROW
MODE_ALL
MODE_CANVAS
MODE_EXCEL
MODE_GOOGLE
MODE_GRID_SHEET
parseFormula
TYPE_ALL
TYPE_ARRAY
TYPE_BLANK
TYPE_BOOL
TYPE_ERROR
TYPE_LAMBDA
TYPE_MISSING
TYPE_NONE
TYPE_NUM
TYPE_RANGE
TYPE_STRING
VOLATILES
Functions
a1ToRowColumn
a1ToRowColumnOrNull
checkA1
colFromOffs
constructCellID
describeWorkbook
deserializeModel
functionSignatures
isA1Ref
isBoxed
isCellOrDefinedName
isCellValue
isMatrix
isNameRef
isPivotLookupError
isRef
offsFromCol
parseReference
serializeModel
unbox
References
Sheet
grid.is
npm
Select theme
Dark
Light
Auto
Dimension
type
Dimension
=
"
row
"
|
"
col
"
;
Axis along which a row/column insertion, deletion, or move operates.