Skip to content
Apiary
Search
Ctrl
K
Cancel
grid.is
Select theme
Dark
Light
Auto
Tutorials
Getting started
Creating a spreadsheet
Applying a theme to a workbook
Changelog
Reference
Supported functions
API reference
Classes
ArrayEditBlockedError
Cell
CellVertexId
DataTableEditBlockedError
DefinedName
EditBlockedError
EvaluationError
FormulaError
FormulaSyntaxError
Lambda
Matrix
MergedCellWriteBlockedError
Model
ModelError
NameNotFoundError
NameVertexId
PivotCellWriteBlockedError
PivotDuplicateSourceHeadersError
PivotEditBlockedError
PivotField
PivotItem
PivotMeasure
PivotNameConflictError
PivotOutputOverlapsDataError
PivotSourceInvalidError
PivotTable
Range
RangeVertexId
Reference
ReorderMergeBlockedError
SheetEdgeBlockedError
SheetNotFoundError
SortCellsBlockedError
StyleManager
TableEditBlockedError
ValueBox
ValueSnapshot
VertexId
VertexIdSet
Workbook
WorkbookDescription
WorkbookNotFoundError
WorkSheet
Interfaces
AddWorkbookOptions
CellInterface
CellStyle
CommentsManager
EvaluateExpressionOptions
EvaluationContext
ModelMeta
NamedStyles
NotesManager
PivotCache
PivotManager
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
DataTableBlockedOperation
Dimension
DrawingCSF
FillType
FilterOptions
FormulaArgument
FormulaValue
IterationOptions
KnownVertexId
MaybeBoxed
MaybeBoxedFormulaArgument
MaybeBoxedFormulaValue
ModelEntity
ModelEventArgs
ModelEventListener
ModelEventType
NamedStyleDeleteResult
NamedStyleRenameResult
NameReference
NonMatrixFormulaArgument
OutputBounds
Parameter
PivotAddOptions
PivotBlockedOperation
PivotColRole
PivotDataFieldAggregation
PivotFieldAxis
PivotFieldFilter
PivotFieldFilterKind
PivotFilterType
PivotLabelFilter
PivotLabelFilterCondition
PivotLookupError
PivotLookupErrorReason
PivotManualFilter
PivotMeasureShowDataAs
PivotOpaqueFilter
PivotPageArea
PivotRowRole
PivotSettableFilter
PivotShowDataAs
PivotTopNFilter
PivotTopNSelection
PivotValueFilter
PivotValueFilterCondition
RecalcEvent
RecalculateOptions
ReplaceSheetReferencesFn
ReplaceTableReferencesFn
ReplaceWorkbookReferencesFn
RewriteFormula
SheetCSF
SheetEdgeBlockedReason
SlimRange
SlimRangeOrCoords
SortCellsBlockedReason
SortKey
SortOptions
StylePatch
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
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
getReplaceSheetReferencesFn
getReplaceTableReferencesFn
getReplaceWorkbookFn
isA1Ref
isBoxed
isCellOrDefinedName
isCellValue
isDateFormat
isMatrix
isNameRef
isPivotLookupError
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
Internal defined names
Nomenclature
Recalculation algorithm
Sort behavior
grid.is
Select theme
Dark
Light
Auto
PivotFieldAxis
type
PivotFieldAxis
=
"
row
"
|
"
col
"
|
"
page
"
;
The axis a pivot field can be placed on.
ApiaryApiary