SpreadJS 14
Index
ABS
accent
Accessibility Support
accounting
Accounting Format
Accounting Format
ACCRINT
ACCRINTM
ACOS
ACOSH
ACOT
ACOTH
action
action
actions
Actions and Key API Changes
add
Add a Tab
Add Button in a Tab
Add Context Menu Item
Add Error Bars In Charts
Add Hover Animation and Style
Add New Dialog
Add Trendlines To Charts
ADDRESS
AGGREGATE
align
Align Shapes
alignment
Allow Users to Enter Formulas
always
AMORDEGRC
AMORLINC
AND
Angular
angularjs
Animation in Charts
API Changes
API Documentation
API Documentation
ARABIC
area
Area Chart
Area Sparkline
AREAS
AreaSparkline type
arguments
Arrange Shapes
array
Array Formulas
Arrays in a Formula
ArrowheadLength Enumeration
ArrowheadStyle Enumeration
ArrowheadWidth Enumeration
ascending
ASIN
ASINH
AsyncEvaluateContext type
AsyncFunction type
AsyncFunctionEvaluateMode Enumeration
Asynchronous Functions
ATAN
ATAN2
ATANH
Auto Expand Tables
Auto Fill Data
Auto Fill Dates
Auto Fill Lists
Auto Fill Strings
Auto Merge Cells
AutoFillType Enumeration
AutoFit
AutoFit
autoFitColumn type
autoFitRow type
AutoFitType Enumeration
Automatic Fit
AutoMerge type
AutoMergeDirection Enumeration
AutoMergeMode Enumeration
AutoShapeType Enumeration
AutoSum Functions
Available CalcEngine Language Packages For SpreadJS
AVEDEV
average
average
Average Rule
AVERAGEA
AverageConditionType Enumeration
AVERAGEIF
AVERAGEIFS
Avoid Using Volatile Functions
Axes
axis
AxisCrossPoint Enumeration
AxisGroup Enumeration
AxisOrientation Enumeration
backColor type
backColor type
background
Background Image
backgroundImage type
backgroundImageLayout type
BAHTTEXT
bar
Bar Chart
Barcode type
Barcodes
BarDirection Enumeration
BASE
Base type
Basic Format
BESSELI
BESSELJ
BESSELK
BESSELY
Best Practices
BETA.DIST
BETA.INV
BETADIST
BETAINV
BIN2DEC
BIN2HEX
BIN2OCT
Bind Cells
Bind Tables
binding
binding
binding
Bindings type
BINOM.DIST
BINOM.DIST.RANGE
BINOM.INV
BINOMDIST
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
Bootstrap Theme
borderBottom type
borderBottom type
borderHorizontal type
borderLeft type
borderLeft type
borderRight type
borderRight type
Borders, Gridlines and Diagonal Lines
borderTop type
borderTop type
borderVertical type
bound
box plot
Box Plot Sparkline
BoxPlotSparkline type
break
breeze
built-in
Built-In Formulas
Built-In Shapes
bullet
Bullet Sparkline
BulletSparkline type
button
Button Cell
Button List Cell
Button type
ButtonImageType Enumeration
ButtonList type
ButtonPosition Enumeration
ButtonVisibility Enumeration
CalcArray type
CalcEngine type
CalcError type
Calculation API Changes
CalendarPage Enumeration
CalendarStartDay Enumeration
Camera Shape
CameraShape type
cancelInput type
CaptionAlignment Enumeration
cascade
Cascade Sparkline
CascadeSparkline type
CEILING
CEILING.MATH
CEILING.PRECISE
cell
cell
Cell Alignment and Indentation
Cell API Changes
Cell Buttons
Cell Colors
Cell Comments
Cell Dropdowns
Cell Elements
Cell Format
Cell Overflow
Cell Padding and Label Styles
Cell Range
Cell References in a Formula
Cell Settings Exported
Cell Settings Imported
Cell Span
Cell States
Cell Tags
cell type
Cell Types
Cell Types
cell value
Cell Value Rule
CellBindingSource type
cellButtons type
cellPadding type
CellRange type
Cells
CellState type
CellStateManager type
CellStatesType Enumeration
celltype
celltype
celltype
cellType type
CellTypes type
Change Vertical Axis To Logarithmic Scale
changeFormulaReference type
CHAR
chart
chart
chart
chart
Chart Area and Plot Area
Chart Color with Transparency
Chart Element
Chart Elements
Chart Title
Chart type
Chart Types
ChartCollection type
Charts
Charts type
ChartType Enumeration
Check Box Cell
Check Box List Cell
checkbox
CheckBox type
CheckBoxList type
CheckBoxTextAlign Enumeration
CHIDIST
CHIINV
CHISQ.DIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
CHISQ.TEST
CHITEST
CHOOSE
CLEAN
clear type
clearAndEditing type
ClearPendingChangeType Enumeration
clearValues type
client-side
clipboard
Clipboard Operations
clipboardPaste type
ClipboardPasteOptions Enumeration
Codabar
Codabar type
CODE
Code128
Code128 type
Code39
Code39 type
Code49
Code49 type
Code93
Code93 type
collapse
color
color
color
color
color
ColorCompareType Enumeration
ColorScheme type
column
column
column
column
Column Chart
Column Element
Column Element
Column, Columns, and Group Elements
Column, Line, and Winloss Sparklines Using Methods
Column, Line, and Winloss Sparklines with Formulas
ColumnHeader type
COLUMNS
ColumnSparkline type
COMBIN
COMBINA
combo
Combo Box Cell
Combo Chart
ComboBox type
CommandManager type
CommandNames type
Commands type
comment
Comment API Changes
Comment type
CommentManager type
Comments type
CommentState Enumeration
commitArrayFormula type
commitInputNavigationDown type
commitInputNavigationUp type
ComparisonOperators Enumeration
complex
complex
Complex Numbers
CompoundType Enumeration
CONCAT
CONCATENATE
Condition type
conditional
Conditional Formatting
Conditional Formatting API Changes
ConditionalFormats type
ConditionalFormatting type
ConditionRuleBase type
ConditionType Enumeration
CONFIDENCE
CONFIDENCE.NORM
CONFIDENCE.T
Configure Page Breaks
Configure Themes
Connector Shapes
ConnectorShape type
ConnectorType Enumeration
Context Menu
Context Menu
ContextMenu type
ContextMenu type
CONVERT
Copy Excel Objects to SpreadJS
copy type
CopyPasteHeaderOptions Enumeration
CopyToOptions Enumeration
Corner type
CORREL
COS
COSH
COT
COTH
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
COVAR
COVARIANCE.P
COVARIANCE.S
Create and Use a Custom Language Package
Create Custom Culture
Create Custom Formulas
Create Custom Names
Create Multiple Headers
Create Pivot Table
Create Tables
CRITBINOM
CriteriaType Enumeration
CSC
CSCH
CSV
Culture
Culture
Culture
Culture API Changes
CultureInfo type
CultureManager type
CUMIPMT
CUMPRINC
custom
custom
custom
custom
custom
custom
custom
Custom Cell
Custom Floating Objects
Custom PDF Export
Custom Shapes
Custom Slicer
Custom Sorting
Custom Sparkline
Custom Themes from ThemeRoller
Customizations
Customize Range Groups
Customize Row Filter Actions
Customize Scrollbar
CustomValueType Enumeration
cut type
dark1 type
dark10 type
dark11 type
dark12 type
dark13 type
dark14 type
dark15 type
dark16 type
dark17 type
dark18 type
dark19 type
dark2 type
dark20 type
dark21 type
dark22 type
dark23 type
dark24 type
dark25 type
dark26 type
dark27 type
dark28 type
dark3 type
dark4 type
dark5 type
dark6 type
dark7 type
dark8 type
dark9 type
data
Data Bar Rule
Data Binding
Data Binding
Data Binding API Changes
Data Labels
Data Markers
data source
data source
Data Tab
Data Validation
Data Validation API Changes
DataBarAxisPosition Enumeration
DataBarRule type
database
Database Functions
DataLabelPosition Enumeration
DataMatrix
DataMatrix type
DataOrientation Enumeration
DataPoints type
DataPosition Enumeration
DataValidation type
DataValidationResult Enumeration
date
date
date and time
Date and Time Functions
Date Occurring Rule
DateCompareType Enumeration
DATEDIF
DateGroupType Enumeration
DateOccurringType Enumeration
DATEVALUE
DAVERAGE
DAY
day count
Day Count Basis
DAYS
DAYS360
DB
DCOUNT
DCOUNTA
DDB
DEC2BIN
DEC2HEX
DEC2OCT
DECIMAL
decoration
Default SpreadJS Theme
DefaultConfig type
DefaultDataValidator type
DEGREES
deleteFloatingObjects type
DELTA
descending
design
Designer Interface
Designer Tabs
Designer type
Designer type
DEVSQ
DGET
diagonalDown type
diagonalUp type
Direction Enumeration
dirty status
DISC
Display #N/A Cells in Chart
Display Empty Cells in Chart
Display Preview Lines
DisplayBlanksAs Enumeration
DisplayFields Enumeration
DisplayMode Enumeration
DisplayUnit Enumeration
Distribute Shapes
DMAX
DMIN
DOLLAR
DOLLARDE
DOLLARFR
Double-click for Auto Fill
DPRODUCT
drag
Drag and Merge
Drag and Merge
Drag and Move
Drag Fill
Drag Fill
dragCopyFloatingObjects type
dragDrop type
drop
DropdownListValue Enumeration
dropDowns type
DropDownType Enumeration
DSTDEV
DSTDEVP
DSUM
duplicate
Duplicate Rule
DURATION
DVAR
DVARP
Dynamic Array Formulas
Dynamic Arrays in a Formula
Dynamic Column Size
EAN-13
EAN13 type
EAN-8
EAN8 type
easy outline
EDATE
edit
Edit Mode Always
editable
editable
Editable Cells
editCell type
Editor Status
EditorStatus Enumeration
EditorType Enumeration
EditorValueType Enumeration
EFFECT
element
element
element
element
element
element
Ellipsis or Tips for Cell Overflow
EmptyValueStyle Enumeration
Enable or Disable Ribbon Elements
ENCODEURL
End-User License Agreement
EOMONTH
era
ERF
ERF.PRECISE
ERFC
ERFC.PRECISE
ERROR.TYPE
ErrorBarType type
ErrorBarValueType type
ErrorCode Enumeration
ErrorStyle Enumeration
EURO
EUROCONVERT
EVEN
Events type
EXACT
excel 2013
Excel Import and Export
Excel IO Element
Excel IO Element
Excel Theme
excel2013
ExcelCompatibleCalcMode type
Excel-Formatted Files Export
Excel-Formatted Files Import
EXP
expand
expandColumnOutline type
expandColumnOutlineForLevel type
expandRowOutline type
expandRowOutlineForLevel type
EXPON.DIST
EXPONDIST
export
export
Export Range to HTML
Export to PDF
Expression type
ExpressionType Enumeration
F.DIST
F.DIST.RT
F.INV
F.INV.RT
F.TEST
FACT
FACTDOUBLE
FALSE
FDIST
Features
file
File Tab
Fill API Changes
Fill Effects
Fill type
Fill type
FillDateUnit Enumeration
FillDirection Enumeration
FillSeries Enumeration
FillType Enumeration
filter
filter
filter
filter
Filter API Changes
Filter Rows
Filter type
FilterActionType Enumeration
FilteredOutDataType Enumeration
Filtering
FILTERJSON
FIND
FINDB
FINV
FISHER
FISHERINV
fit
fit
FIXED
float
float
Floating Objects
Floating Pictures
FloatingObject type
FloatingObjectCollection type
FloatingObjects type
FLOOR
FLOOR.MATH
FLOOR.PRECISE
font type
font type
FORECAST
foreColor type
foreColor type
format
format
Format String
formatter
Formatter API Changes
formatter type
FormatterBase type
formatting
Formatting Shapes
formula
formula
formula
formula
formula
Formula Auditing
Formula Functions
Formula Overview
Formula Reference
Formula Rule
Formula Settings Imported
Formula Text Box
formulas
formulas
Formulas Tab
FORMULATEXT
FormulaTextBox type
FormulaTextBox type
Freeze Columns and Rows
freezing
FREQUENCY
Frequently Used Events
frozen
FTEST
function
Function type
Functions in a Formula
Functions type
Funnel Chart
FV
FVSCHEDULE
GAMMA
GAMMA.DIST
GAMMA.INV
GAMMADIST
GAMMAINV
GAMMALN
GAMMALN.PRECISE
Gauge KPI Sparkline
GaugeKPISparkline type
GAUSS
GC.Pivot Namespace
Overview
GC.Spread.CalcEngine Namespace
Overview
GC.Spread.CalcEngine.Expression Namespace
Overview
GC.Spread.CalcEngine.Functions Namespace
Overview
GC.Spread.Commands Namespace
Overview
GC.Spread.Common Namespace
Overview
GC.Spread.Excel Namespace
Overview
GC.Spread.Excel.IO Namespace
Overview
GC.Spread.Formatter Namespace
Overview
GC.Spread.Pivot Namespace
Overview
GC.Spread.Pivot.PivotTable Namespace
Overview
GC.Spread.Pivot.PivotTableStyle Namespace
Overview
GC.Spread.Pivot.PivotTableThemes Namespace
Overview
GC.Spread.Sheets Namespace (SpreadJS)
Overview
GC.Spread.Sheets Namespace (SpreadJSDesigner)
Overview
GC.Spread.Sheets.AutoMerge Namespace
Overview
GC.Spread.Sheets.Barcode Namespace
Overview
GC.Spread.Sheets.Bindings Namespace
Overview
GC.Spread.Sheets.CalcEngine Namespace
Overview
GC.Spread.Sheets.CellState Namespace
Overview
GC.Spread.Sheets.CellTypes Namespace
Overview
GC.Spread.Sheets.Charts Namespace
Overview
GC.Spread.Sheets.Commands Namespace
Overview
GC.Spread.Sheets.Comments Namespace
Overview
GC.Spread.Sheets.ConditionalFormatting Namespace
Overview
GC.Spread.Sheets.ContextMenu Namespace
Overview
GC.Spread.Sheets.DataValidation Namespace
Overview
GC.Spread.Sheets.Designer Namespace
Overview
GC.Spread.Sheets.Fill Namespace
Overview
GC.Spread.Sheets.Filter Namespace
Overview
GC.Spread.Sheets.FloatingObjects Namespace
Overview
GC.Spread.Sheets.FormulaTextBox Namespace
Overview
GC.Spread.Sheets.Hyperlink Namespace
Overview
GC.Spread.Sheets.OutlineColumn Namespace
Overview
GC.Spread.Sheets.Outlines Namespace
Overview
GC.Spread.Sheets.PDF Namespace
Overview
GC.Spread.Sheets.Print Namespace
Overview
GC.Spread.Sheets.Search Namespace
Overview
GC.Spread.Sheets.Shapes Namespace
Overview
GC.Spread.Sheets.Slicers Namespace
Overview
GC.Spread.Sheets.Sparklines Namespace
Overview
GC.Spread.Sheets.StatusBar Namespace
Overview
GC.Spread.Sheets.Style Namespace
Overview
GC.Spread.Sheets.Tables Namespace
Overview
GC.Spread.Sheets.Touch Namespace
Overview
GC.Spread.Slicers Namespace
Overview
Gc-column Element
GCD
Gc-spread-sheets Element
Gc-spread-sheets Element
Gc-worksheet Element
GeneralComparisonOperators Enumeration
GeneralFormatter type
GeneralSlicerData type
GEOMEAN
GESTEP
Get Dirty Status
Get Page Information
GETPIVOTDATA
Getting Started
Getting Started
Getting Started
GradientFillType Enumeration
GrandTotalPosition Enumeration
Gridlines
Group
Group
Group and Collapse
Group Shapes
Grouping
Grouping API Changes
GroupShape type
GroupSort Enumeration
GROWTH
GS1_128
GS1_128 type
hAlign type
Handle Callback action on a Hyperlink Cell
HARMEAN
hbar
Hbar Sparkline
HBarSparkline type
header
HeaderAutoText Enumeration
HeaderOptions Enumeration
Headers
HEX2BIN
HEX2DEC
HEX2OCT
Hidden Rows or Columns in Chart
hide
HideRowFilter type
HighlightPosition Enumeration
HighlightType Enumeration
Histogram Sparkline
HistogramSparkline type
Hit Test
HLOOKUP
home
Home Tab
Horizontal and Vertical Axes
HorizontalAlign Enumeration
HorizontalAlign Enumeration
HorizontalPosition Enumeration
HOUR
hyperlink
hyperlink
hyperlink
Hyperlink Cell
Hyperlink type
Hyperlink type
Hyperlinks on Shapes
HyperlinkTargetType Enumeration
HyperlinkTargetType Enumeration
HyperlinkTargetType Enumeration
HYPGEOM.DIST
HYPGEOMDIST
ICalcFieldInfo type
Icon Set Rule
IconCriterion type
IconSetRule type
IconSetType Enumeration
IconValueType Enumeration
IDataPosition type
IDataSource
IDateGroupInfo type
IDateGroupsInfo type
IF
IFERROR
IFieldInfo type
IFNA
IFS
IList
IListSource
IMABS
image
image
image
Image Sparkline
ImageLayout Enumeration
ImageSparkline type
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMCOSH
IMCOT
IMCSC
IMCSCH
IMDIV
ime
IME Mode
ImeMode Enumeration
imeMode type
IMEXP
IMLN
IMLOG10
IMLOG2
import
import
Import and Export CSV Files
Import and Export Excel Files on Client-Side
Import and Export JSON
Import and Export Reference
Importing files to SpreadJS
IMPOWER
IMPRODUCT
IMREAL
IMSEC
IMSECH
IMSIN
IMSINH
IMSQRT
IMSUB
IMSUM
IMTAN
Incremental Loading
indent
indent
INDEX
INDIRECT
input
input
Input Mapping
input method editor
insert
Insert and Design Tab
Insert Cut or Copied Cells
InsertShiftCell Enumeration
INT
INTERCEPT
Interface Menus
INTRATE
INumberGroupInfo type
InvalidOperationType Enumeration
IO type
IPivotArea type
IPivotAreasCollection type
IPivotCaptionConditionFilterInfo type
IPivotConditionFilterInfo type
IPivotDateConditionFilterInfo type
IPivotReference type
IPivotShowDataAsInfo type
IPivotStyle type
IPivotTableOption type
IPivotTablePosition type
IPivotTableRange type
IPivotTableView type
IPivotTextFilterInfo type
IPivotTop10ConditionFilterInfo type
IPivotValueConditionInfo type
IPivotViewSortInfo type
IPMT
IRR
ISBLANK
ISerializeFieldInfo type
ISerializeInfo type
ISerializeShowDataAsInfo type
ISERR
ISERROR
ISEVEN
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISO.CEILING
ISODD
ISourceFieldInfo type
ISOWEEKNUM
ISPMT
ISREF
ISTEXT
IStringGroupItems type
isVerticalText type
Item Slicer
ItemSlicer type
Iterative Calculation
ITextCollectionCondition type
ITextGroupInfo type
JavaScript Frameworks
JavaScript Frameworks
JSON
JSON API Changes
JSON Schema with SpreadJS
Key Enumeration
keyboard
Keyboard Actions
Keyboard Navigation Shortcuts
keys
keys
keys
knockout
KURT
LabelAlignment Enumeration
labelOptions type
LabelVisibility Enumeration
Language Package
LanguagePackages type
LARGE
Launch Designer
layout
LayoutDirection Enumeration
LayoutDisplayAs Enumeration
LCM
LEFT
LEFTB
LegendPosition Enumeration
Legends
LEN
LENB
LET
level
license
LicenseKey type
LicenseKey type
light0 type
light1 type
light10 type
light11 type
light12 type
light13 type
light14 type
light15 type
light16 type
light17 type
light18 type
light19 type
light2 type
light20 type
light21 type
light22 type
light23 type
light24 type
light25 type
light26 type
light27 type
light28 type
light3 type
light4 type
light5 type
light6 type
light7 type
light8 type
light9 type
line
line
line
line
Line Chart
LinearGradientFillDirection Enumeration
LineBorder type
LineCapStyle Enumeration
LineJoinStyle Enumeration
LineSparkline type
LINEST
LineStyle Enumeration
LineType type
LN
Locale-based Date Format Imported
localize
lock
locked type
LOG
LOG10
LOGEST
LogicalOperators Enumeration
LOGINV
LOGNORM.DIST
LOGNORM.INV
LOGNORMDIST
LOOKUP
LOWER
map
marker
Markers and Points
MATCH
MAX
MAXA
MAXIFS
MDETERM
MDURATION
MEDIAN
medium1 type
medium10 type
medium11 type
medium12 type
medium13 type
medium14 type
medium15 type
medium16 type
medium17 type
medium18 type
medium19 type
medium2 type
medium20 type
medium21 type
medium22 type
medium23 type
medium24 type
medium25 type
medium26 type
medium27 type
medium28 type
medium3 type
medium4 type
medium5 type
medium6 type
medium7 type
medium8 type
medium9 type
menu
MenuView type
MessageBoxButtons Enumeration
MessageBoxIcon Enumeration
MessageBoxResult Enumeration
MID
MIDB
MIN
MINA
MINIFS
MINUTE
MINVERSE
MIRR
MMULT
MOD
mode
mode
MODE.MULT
MODE.SNGL
module
MONTH
Month Sparkline
MonthSparkline type
move
moveFloatingObjects type
moveToNextCell type
moveToNextCellThenControl type
moveToPreviousCell type
moveToPreviousCellThenControl type
MROUND
MULTINOMIAL
multiple
N
NA
name
name
name type
NameInfo type
navigation
navigationBottom type
navigationDown type
navigationEnd type
navigationEnd2 type
navigationFirst type
navigationHome type
navigationHome2 type
navigationLast type
navigationLeft type
navigationNextSheet type
navigationPageDown type
navigationPageUp type
navigationPreviousSheet type
navigationRight type
navigationTop type
navigationUp type
NEGBINOM.DIST
NEGBINOMDIST
NETWORKDAYS
NETWORKDAYS.INTL
NOMINAL
NORM.DIST
NORM.INV
NORM.S.DIST
NORM.S.INV
NormalConditionRule type
NORMDIST
NORMINV
NORMSDIST
NORMSINV
NOT
NOW
NPER
NPV
number
Number and Date Format
NumbersFitMode Enumeration
OBJECT
Object Inheritance
OCT2BIN
OCT2DEC
OCT2HEX
ODD
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
OFFSET
open
open
Open and Save Files
openCalculator type
openColorPicker type
openDateTimePicker type
openList type
openMonthPicker type
openMultiColumn type
openSlider type
openTimePicker type
openUrl type
openWorkflowList type
operators
Operators in a Formula
Operators with Dates and Times
Optional and Missing Arguments
options type
OR
Order of Precedence
outline
Outline Columns
Outline type
OutlineColumn type
OutlineColumn type
OutlineColumn type
OutlineDirection Enumeration
OutlineInfo type
outlineRow type
Outlines type
OutlineState Enumeration
overflow
Padding type
PaperKind Enumeration
PaperSize type
parentName type
pareto
Pareto Sparkline
ParetoSparkline type
Paste or Skip Data in Invisible Range
paste type
pasteFloatingObjects type
Pattern Fill and Gradient Fill
Pattern Fill in Charts
PatternType Enumeration
PatternType Enumeration (GC.Spread.Sheets)
PatternType Enumeration (GC.Spread.Sheets)
PDF type
PDF417
PDF417 type
PDFFontsManager type
PDURATION
PEARSON
Percentage Format
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
PERCENTRANK
PERCENTRANK.EXC
PERCENTRANK.INC
permanent
PERMUT
PERMUTATIONA
PHI
PI
picture
picture
Picture and Floating Object API Changes
Picture type
pie
Pie Chart
Pie Sparkline
PieSparkline type
Pivot Table
Pivot Table Components
Pivot Table Layout
Pivot Table Print
Pivot Table Settings
Pivot View Manager
PivotAreaAxisType Enumeration
PivotAreaType Enumeration
PivotCaptionFilterOperator Enumeration
PivotConditionType Enumeration
PivotDataType Enumeration
PivotDateFilterOperator Enumeration
PivotPanel type
PivotPanelLayoutType Enumeration
PivotPanelSection Enumeration
PivotShowDataAs Enumeration
PivotShowDataAsBaseItemType Enumeration
PivotSourceFieldType Enumeration
PivotTable type
PivotTableFieldType Enumeration
PivotTableLayoutType Enumeration
PivotTableManager type
PivotTableStyle type
PivotTableTheme type
PivotTableThemes type
PivotTableViewManager type
PivotTop10FilterOperator Enumeration
PivotTop10FilterType Enumeration
PivotValueFilterOperator Enumeration
pluggable
PMT
point
Point type
POISSON
POISSON.DIST
POWER
PPMT
Precision Selection
Preserve Unsupported Charts
PresetLineDashStyle Enumeration
PRICE
PRICEDISC
PRICEMAT
Print
Print
Print API Changes
Print Background Image As Watermark
Print Settings Exported
Print Settings Imported
Print Sheets
Print type
PrintCentering Enumeration
PrintInfo type
PrintPageOrder Enumeration
PrintPageOrientation Enumeration
PrintVisibilityType Enumeration
PROB
PRODUCT
PROPER
PROPERTY
protect
Protect Worksheet and Lock Cells
PV
QRCode
QRCode type
QuarterType Enumeration
QUARTILE
QUARTILE.EXC
QUARTILE.INC
Quick Start
Quick Start
Quote Prefix
Quote Prefix
QUOTIENT
Radar Chart
RadialGradientFillDirection Enumeration
RADIANS
Radio Button List Cell
RadioButtonList type
RAND
RANDARRAY
RANDBETWEEN
range
Range Groups
Range Template Cell
Range type
Rangeblock Sparkline
RangeBlockSparkline type
RangeChangedAction Enumeration
RangeReferenceRelative Enumeration
RangeTemplate type
RANK
RANK.AVG
RANK.EQ
rapid
RATE
React
RECEIVED
Rect type
Redistribution
redo
redo type
reference
reference
reference
reference styles
ReferenceStyle Enumeration
REFRESH
Refresh Data Source
Release Notes
Release Notes for Version 1.20131.RC1
Release Notes for Version 1.20132.3
Release Notes for Version 1.20133.6
Release Notes for Version 10.0.0
Release Notes for Version 10.1.0
Release Notes for Version 10.2.0
Release Notes for Version 11.0.0
Release Notes for Version 11.1.0
Release Notes for Version 11.2.0
Release Notes for Version 12.0.0
Release Notes for Version 12.1.0
Release Notes for Version 12.2.0
Release Notes for Version 13.0.0
Release Notes for Version 13.1.0
Release Notes for Version 13.2.0
Release Notes for Version 14.0.0
Release Notes for Version 14.1.0
Release Notes for Version 3.20141.9
Release Notes for Version 3.20142.11
Release Notes for Version 3.20143.14
Release Notes for Version 3.20151.16
Release Notes for Version 8.40.20151.0
Release Notes for Version 8.40.20152.0
Release Notes for Version 9.40.20153.0
Release Notes for Version 9.40.20161.0
removeColumnOutline type
removeRowOutline type
renameSheet type
REPLACE
REPLACEB
REPT
resize
resize
resize
Resize Columns and Rows
Resize Tables
resizeColumn type
resizeFloatingObjects type
ResizeMode Enumeration
resizeRow type
ResizeZeroIndicator Enumeration
Resizing Columns or Rows
Resultant Error Values
Rich Text
RIGHT
RIGHTB
ROMAN
Rotate Text In Cells
ROUND
ROUNDDOWN
ROUNDUP
ROW
Row and Column Settings Exported
Row and Column Settings Imported
RowCol Enumeration
RowFilterBase type
RowHeader type
ROWS
Rows and Columns
RRI
RSQ
rule
rule
rule
rule
rule
rule
rule
rule
rule
rule
rules
RuleType Enumeration
save
save
Save Spreadsheet Changes to Database
scale
Scale Rule
ScaleRule type
ScaleValue type
ScaleValueType Enumeration
scatter
Scatter Chart
Scatter Sparkline
ScatterSparkline type
schema
scroll bars
Scroll By Pixel
Scrollbar
Scrollbar Options
ScrollbarAppearance Enumeration
Scrolling
search
search
Search API Changes
Search Data
Search type
SEARCHB
SearchCondition type
SearchFlags Enumeration
SearchFoundFlags Enumeration
SearchOrder Enumeration
SearchResult type
SEC
SECH
SECOND
Select Multiple Worksheets
selection
selectionBottom type
selectionDown type
selectionEnd type
selectionFirst type
selectionHome type
selectionLast type
selectionLeft type
SelectionMode Enumeration
SelectionMode Enumeration
selectionPageDown type
selectionPageUp type
SelectionPolicy Enumeration
selectionRight type
Selections
selectionTop type
SelectionUnit Enumeration
selectionUp type
selectNextControl type
selectPreviousControl type
SEQUENCE
Serialization
series
series
SeriesCollection type
SERIESSUM
Set Culture
Set Era Format
Set Formulas
Set Large Amounts of Data
Set Large Amounts of Formulas
Set Range Template Cell
Set Table Styles
Set Widget Border
settings
Settings Tab
Shape Element
Shape Property Formulas
Shape type
ShapeBase type
ShapeCollection type
ShapeFillType Enumeration
Shapes
Shapes type
ShapeStyle type
Sheet and Sheets Elements
Sheet Area Offset
Sheet Element
Sheet References in a Formula
Sheet Settings Exported
SheetArea Enumeration
SheetType Enumeration
Show Cell Formulas
showEllipsis type
ShowResizeTip Enumeration
ShowScrollTip Enumeration
shrink
Shrink to Fit
shrinkToFit type
SIGN
Simplify Complex Formula
SIN
SINGLE
SINH
size
SKEW
SKEW.P
Slicer
Slicer API Changes
Slicer API Changes
Slicer type
SlicerAggregateType Enumeration
SlicerBorder type
SlicerCollection type
Slicers type
SlicerStyle type
SlicerStyleInfo type
SlicerStyles type
SLN
SLOPE
SMALL
Snap Shapes
SnapMode Enumeration
Sort
Sort
Sort
Sort
Sort
Sort Data
Sort with Grouped Data
SORTBY
SortState Enumeration
SortType Enumeration
span
sparkline
sparkline
sparkline
sparkline
sparkline
sparkline
sparkline
sparkline
sparkline
sparkline
sparkline
sparkline
sparkline
sparkline
Sparkline API Changes
Sparkline type
SparklineAxisMinMax Enumeration
SparklineEx type
SparklineGroup type
Sparklines
Sparklines type
SparklineSetting type
SparklineType Enumeration
Specific Text Rule
Split Resize Columns and Rows
splitResizeColumn type
splitResizeRow type
spread
Spread Settings Exported
Spread Sparkline
SpreadJS
Overview
SpreadJS and DataViewsJS
SpreadJS Designer
SpreadJS Designer Components
SpreadJS Designer Template with Cell Binding
SpreadJS Libraries
SpreadJS Overview
SpreadJS Spread Schema
SpreadJS with Angular
SpreadJS with AngularJS
SpreadJS with Breeze
SpreadJS with Knockout
SpreadJS with React
SpreadJS with the Wijmo DataView
SpreadJS with Vue
SpreadJSDesigner
Overview
Spread-Sheets Element
SpreadSparkline type
SQRT
SQRTPI
stacked
Stacked Sparkline
StackedSparkline type
STANDARDIZE
StatesType Enumeration
status
Status Bar
Status Bar
StatusBar type
StatusBar type
StatusItem type
STDEV
STDEV.P
STDEV.S
STDEVA
STDEVP
STDEVPA
STEYX
Stock Chart
StorageType Enumeration
Store Changes Made to Spreadsheet
structured
Structured Reference Formulas
style
Style API Changes
Style Element
Style type
Styles
SUBSTITUTE
SUBTOTAL
SubtotalsPosition Enumeration
SubtotalType Enumeration
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
Sunburst Chart
suspendDirty and resumeDirty
suspendEvent and resumeEvent
suspendPaint and resumePaint
SWITCH
SYD
SymbolShape type
T
T.DIST
T.DIST.2T
T.DIST.RT
T.INV
T.INV.2T
T.TEST
tab
tab
tab
Tab Strip
Tab Strip
table
table
Table API Changes
Table Slicer
Table Slicer Styles
Table Slicer with the SpreadJS Designer
Table type
TableColumn type
tableDeleteColumns type
tableDeleteRows type
tableInsertColumns type
tableInsertRows type
TableManager type
TableRemoveOptions Enumeration
tableResize type
Tables
Tables type
TableSheet type
TableSlicerData type
TableStyle type
TableTheme type
TableThemes type
tabStop type
TabStripPosition Enumeration
tag
Tag Hierarchy
TAN
TANH
TBILLEQ
TBILLPRICE
TBILLYIELD
TDIST
Technical Support
TemplateNames type
text
text
Text Decoration
Text Indentation
Text on Shapes
Text type
TextAlign Enumeration
TextCompareType Enumeration
TextComparisonOperators Enumeration
textDecoration type
textDecoration type
TextDecorationType Enumeration
textIndent type
TEXTJOIN
textOrientation type
TextureFillAlignment Enumeration
TextureFillMirrorType Enumeration
Theme
Theme
Theme
Theme API Changes
Theme type
ThemeColors type
themeFont type
Themes and Style
Themes type
TickLabelPosition Enumeration
TickMark Enumeration
TIME
TIMEVALUE
TINV
TODAY
toolbar
tooltip
Tooltips
Top 10 Rule
Top10ConditionType Enumeration
top10rule
touch
Touch API Changes
Touch Support
Touch Toolbar
Touch type
TouchToolStrip type
TouchToolStripItem type
TouchToolStripSeparator type
trailing
TRANSPOSE
Treemap Chart
TREND
TrendlineType Enumeration
Trial Version and Licensing Information
TRIM
TRIMMEAN
TRUE
TRUNC
TTEST
TYPE
type type
TypeScript
UMD Support
underline
Understanding the Product
undo
Undo and Redo
undo type
UndoManager type
ungroup
UNICHAR
UNICODE
unique
unique
Unique Rule
UPPER
Use Cell References
Use Click Events
Use Custom Font for PDF Export
Use Events when Clicking a Button
Use Events when Clipboard Changes
Use Events when Data Changes
Use Events when Dragging and Moving
Use Events when Edit Mode Starts or Stops
Use Events when Moving a Cell
Use Events when Range Changes
Use Events when Sheet Changes
Use Events when the Sheet Tab Changes
Use Events when the Top Row or Column Changes
Use Formula Text Box as a Control
Use Previous Code with Current Version
User Interface API Changes
validate
validation
Validator Element
vAlign type
VALUE
ValueType Enumeration
VAR
VAR.P
VAR.S
VARA
vari
Vari Sparkline
VariSparkline type
VARP
VARPA
vbar
Vbar Sparkline
VBarSparkline type
VDB
VertAlign Enumeration
Vertical Text Direction
VerticalAlign Enumeration
VerticalAlign Enumeration
VerticalPosition Enumeration
view
View Tab
views type
VisualState Enumeration
VLOOKUP
volatile
Volatile Functions
Vue
Watermark
watermark type
WEBSERVICE
WEEKDAY
WEEKNUM
WEIBULL
WEIBULL.DIST
What is a Formula
wheel
wildcard
Wildcard Characters in a Formula
winloss
winloss
winloss
WinlossSparkline type
Word Wrap Format
wordwrap
wordWrap type
Work in the Designer
Work with Cells
Work with Rows and Columns
Work with Worksheets
Workbook
Workbook API Changes
Workbook Settings Imported
Workbook type
WORKDAY
WORKDAY.INTL
Worksheet
Worksheet API Changes
Worksheet Element
Worksheet Element
Worksheet Settings Imported
Worksheet type
Wrap Text
XIRR
XLOOKUP
XMATCH
XNPV
XOR
YEAR
Year Sparkline
YEARFRAC
YearSparkline type
YIELD
YIELDDISC
YIELDMAT
Z.TEST
Zoom
Zoom
zoom type
Zooming
ZTEST