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
DefinedName
EvaluationError
FormulaError
FormulaSyntaxError
Lambda
Matrix
Model
ModelError
Range
Reference
StyleManager
Table
TableManager
ValueBox
Workbook
WorkbookDescription
WorkSheet
Interfaces
CellInterface
CellStyle
CommentsManager
EvaluationContext
NotesManager
ThemeManager
WorkbookBody
Type Aliases
A1Reference
AddCommentInput
AreaArray
AreaBoxedValueArray
AreaCellArray
AreaValueArray
ArrayValue
AxisCSF
CellCSF
CellData
CellItem
CellValue
CellValueAtom
ChartCSF
CloudConnection
ColumnInfo
DrawingCSF
FilterOptions
FormulaArgument
FormulaValue
IterationOptions
MaybeBoxed
MaybeBoxedFormulaArgument
MaybeBoxedFormulaValue
ModelEntity
ModelStateTree
NameReference
NonMatrixFormulaArgument
Parameter
RecalcEvent
RecalculateOptions
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
WorkbookType
XlsxOutputMap
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
ArrayValue
type
ArrayValue
=
|
CellValue
|
Lambda
;
Values that can be stored inside arrays
