Skip to content
Apiary
Search
Ctrl
K
Cancel
Select theme
Dark
Light
Auto
Tutorials
Getting started
Creating a spreadsheet
Applying a theme to a workbook
Changelog
API reference
Classes
Cell
CellVertexId
DefinedName
EvaluationError
FormulaError
FormulaSyntaxError
Lambda
Matrix
Model
ModelError
NameVertexId
Range
RangeVertexId
Reference
StyleManager
ValueBox
VertexId
VertexIdSet
Workbook
WorkbookDescription
WorkSheet
Interfaces
AddWorkbookOptions
CellInterface
CellStyle
CommentsManager
EvaluateExpressionOptions
EvaluationContext
ModelMeta
NamedStyles
NotesManager
Table
TableManager
ThemeManager
ViewManager
WorkbookBody
WorkbookView
WriteOptions
Type Aliases
A1Reference
AddCommentInput
AreaArray
AreaBoxedValueArray
AreaCellArray
AreaValueArray
ArrayValue
AxisCSF
CellCSF
CellData
CellItem
CellValue
CellValueAtom
ChartCSF
CloudConnection
ColumnInfo
DrawingCSF
FilterOptions
FormulaArgument
FormulaValue
IterationOptions
KnownVertexId
MaybeBoxed
MaybeBoxedFormulaArgument
MaybeBoxedFormulaValue
ModelEntity
ModelEventArgs
ModelEventListener
ModelEventType
ModelStateTree
NamedStyleDeleteResult
NamedStyleRenameResult
NameReference
NonMatrixFormulaArgument
Parameter
RecalcEvent
RecalculateOptions
ReplaceSheetReferencesFn
ReplaceTableReferencesFn
ReplaceWorkbookReferencesFn
RewriteFormula
SheetCSF
SlimRange
SlimRangeOrCoords
TableColumnCSF
TableCSF
ToXLSXOptions
TYPE_ALL
TYPE_ARRAY
TYPE_BLANK
TYPE_BOOL
TYPE_ERROR
TYPE_LAMBDA
TYPE_MISSING
TYPE_NONE
TYPE_NUM
TYPE_RANGE
TYPE_STRING
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
formulaParserReady
functions
MAX_COL
MAX_ROW
MODE_ALL
MODE_CANVAS
MODE_EXCEL
MODE_GOOGLE
MODE_GRID_SHEET
parseFormula
VOLATILES
Functions
a1ToRowColumn
a1ToRowColumnOrNull
checkA1
colFromOffs
constructCellID
describeWorkbook
deserializeModel
functionSignatures
getReplaceSheetReferencesFn
getReplaceTableReferencesFn
getReplaceWorkbookFn
isA1Ref
isBoxed
isCellOrDefinedName
isCellValue
isMatrix
isNameRef
isRef
offsFromCol
parseReference
serializeModel
unbox
References
Sheet
Understanding Apiary
Excel under the hood
Dereference helper functions reference
Excel floating point arithmetic
Google Sheets Dummy Values
Nomenclature
Recalculation algorithm
Select theme
Dark
Light
Auto
ERROR_UNKNOWN
const
ERROR_UNKNOWN
:
FormulaError
;