Skip to content
Apiary
Search
Ctrl
K
Cancel
Select theme
Dark
Light
Auto
Tutorials
Getting started
Creating a spreadsheet
API reference
Classes
Cell
CellVertexId
DefinedName
EvaluationError
FormulaError
FormulaSyntaxError
Lambda
Matrix
Model
ModelError
NameVertexId
ParseFailureEvaluationError
Range
RangeVertexId
Reference
StyleManager
ValueBox
VertexIdSet
Workbook
WorkbookDescription
WorkSheet
Interfaces
CellInterface
CellStyle
EvaluationContext
WorkbookBody
Type Aliases
A1Reference
AreaArray
AreaBoxedValueArray
AreaCellArray
AreaValueArray
ArrayValue
AxisCSF
CellCSF
CellData
CellItem
CellValue
CellValueAtom
ChartCSF
CloudConnection
ColumnInfo
DrawingCSF
FormulaArgument
FormulaValue
IterationOptions
KnownVertexId
MaybeBoxed
MaybeBoxedFormulaArgument
MaybeBoxedFormulaValue
ModelEntity
ModelStateTree
NameReference
NonMatrixFormulaArgument
Parameter
RecalcEvent
ReplaceSheetReferencesFn
ReplaceWorkbookReferencesFn
RewriteFormula
SheetCSF
SlimRange
SlimRangeOrCoords
TableColumnCSF
TableCSF
TYPE_ALL
TYPE_ARRAY
TYPE_BLANK
TYPE_BOOL
TYPE_ERROR
TYPE_LAMBDA
TYPE_MISSING
TYPE_NONE
TYPE_NUM
TYPE_RANGE
TYPE_STRING
WorkbookCSF
WorkbookRootsAndDependents
WorkbookType
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
errorTable
formulaParserReady
functions
MAX_COL
MAX_ROW
MODE_ALL
MODE_CANVAS
MODE_EXCEL
MODE_GOOGLE
MODE_GRID_SHEET
parseFormula
VOLATILES
Functions
a1ToRowColumn
a1ToRowColumnOrNull
assignCellStylesIfNeeded
cellToVertexId
checkA1
colFromOffs
constructCellID
csfFromJsf
describeWorkbook
deserializeModel
detectColumnTypesAndNumberFormats
errorForCode
findVertexIdsNeedingInitRecalc
functionSignatures
getReplaceSheetReferencesFn
getReplaceTableReferencesFn
getReplaceWorkbookFn
getRootsAndDependents
hasCellRoot
isA1Ref
isBoxed
isCellOrDefinedName
isCellValue
isMatrix
isNameRef
isRef
loadLazy
offsFromCol
parseDateTime
parseReference
referenceToVertexId
run
serializeModel
toNum
unbox
vertexIdToCell
vertexIdToReference
wbNameToKey
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
MODE_EXCEL
const
MODE_EXCEL
:
WorkbookMode
=
4
