SpreadJS 14
Index
A1 Notation
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 and Delete Outlines
Add Button in a Tab
Add Columns and Rows
Add Context Menu Item
Add Error Bars In Charts
Add Hover Animation and Style
Add New Dialog
Add Rows
Add Sheet
Add Trendlines To Charts
Add Unbound Columns
ADDRESS
AGGREGATE
align
alignment
Allow Cell Overflow
Allow Drag and Drop
Allow Users to Enter Formulas
Allow Users to Enter Formulas
always
AMORDEGRC
AMORLINC
AND
Angular
angularjs
Animation in Charts
API Changes
API Documentation
ARABIC
area
Area Chart
Area Sparkline
AREAS
AreaSparkline type
arguments
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
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
Bind to Columns
Bind to Table
binding
binding
binding
Bindings type
BINOM.DIST
BINOM.DIST.RANGE
BINOM.INV
BINOMDIST
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
Bootstrap Theme
borderBottom type
borderLeft type
borderRight type
Borders, Gridlines and Diagonal Lines
borderTop 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
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
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
Cells
CellState type
CellStateManager type
CellStatesType Enumeration
celltype
celltype
celltype
cellType type
CellTypes type
Change Active Cell Backcolor
Change Default Input Map
Change Grid Line Appearance
Change Header Size
Change Row Height and Column Width
Change Sheet Names
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
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
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
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
ContextMenu type
ContextMenu type
CONVERT
Convert Expression To Formula
Convert Formula To Expression
Convert Formula To Ranges
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 Remove Selections
Create and Use a Custom Language Package
Create Custom Action Map
Create Custom Culture
Create Custom Filter
Create Custom Formulas
Create Custom Names
Create Multiple Headers
Create Multiple Rows and Columns in the Headers
Create Multiple Selections
Create Row Filters
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 Appearance
Customize Headers
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
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
Deactivate Clipboard Keys
Deactivate Default Input Map
Deactivate Pasting
DEC2BIN
DEC2HEX
DEC2OCT
DECIMAL
decoration
Default SpreadJS Theme
DefaultDataValidator type
DEGREES
Delete Columns and Rows
Delete Sheet
deleteFloatingObjects type
DELTA
descending
design
Designer Interface
Designer Tabs
Developer's Guide
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
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
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
Evaluate Formula
EVEN
Events type
EXACT
excel 2013
Excel Import and Export
Excel IO Element
Excel Theme
excel2013
ExcelCompatibleCalcMode type
Excel-Formatted Files Export
Excel-Formatted Files Import
EXP
expand
Expand and Collapse Outlines
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 type
Fill type
FillDateUnit Enumeration
FillDirection Enumeration
FillSeries Enumeration
FillType Enumeration
filter
filter
filter
Filter API Changes
Filter Row with Code
Filter Rows
Filter type
FilterActionType Enumeration
FilteredOutDataType Enumeration
Filtering
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
FORECAST
foreColor type
format
format
Format String
formatter
Formatter API Changes
formatter type
FormatterBase type
formatting
formula
formula
formula
formula
formula
Formula Auditing
Formula Functions
Formula Overview
Formula Reference
Formula Rule
Formula Settings Imported
Formula Text Box
formulas
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
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.PivotTables Namespace
Overview
GC.Spread.PivotTables.PivotTableThemes Namespace
Overview
GC.Spread.Sheets Namespace
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.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
gestures
Get Active Cell Index
Get Cell Index from Mouse Click
Get Cell Position and Size
Get Cell Values
Get Dirty Status
Get Displayed Cell Index
Get Header Cell Index from Mouse Click
Get Page Information
Get Row Filter Results
Get Row Filter Status
Get Selected Ranges
Getting Started
Getting Started
Goal Seek Method
GrandTotalPosition Enumeration
Gridlines
Group
Group
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
Hide Filter Indicator
Hide Headers
HideRowFilter type
HighlightPosition Enumeration
HighlightType Enumeration
Hit Test
HLOOKUP
home
Home Tab
Horizontal and Vertical Axes
HorizontalAlign Enumeration
HorizontalPosition Enumeration
HOUR
hyperlink
hyperlink
Hyperlink Cell
Hyperlink type
Hyperlink type
HyperLinkTargetType Enumeration
HyperLinkTargetType Enumeration
HYPGEOM.DIST
HYPGEOMDIST
Icon Set Rule
IconCriterion type
IconSetRule type
IconSetType Enumeration
IconValueType Enumeration
IDataSource
IF
IFERROR
IFNA
IFS
IList
IListSource
IMABS
image
image
image
ImageLayout Enumeration
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
Installation
INT
INTERCEPT
Interface Menus
INTRATE
InvalidOperationType Enumeration
IO type
IPMT
IRR
ISBLANK
ISERR
ISERROR
ISEVEN
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISO.CEILING
ISODD
ISOWEEKNUM
ISPMT
ISREF
ISTEXT
isVerticalText type
Item Slicer
ItemSlicer type
Iterative Calculation
javascript
JavaScript Frameworks
JavaScript Frameworks
JSON
JSON API Changes
JSON Schema with SpreadJS
Key Enumeration
keyboard
Keyboard Actions
Keyboard and Input Maps
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
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
light29 type
light3 type
light4 type
light5 type
light6 type
light7 type
light8 type
light9 type
line
line
line
line
Line Chart
LineBorder type
LineCapStyle Enumeration
LineJoinStyle Enumeration
LineSparkline type
LINEST
LineStyle Enumeration
LineType type
LN
load
localize
lock
Lock Cells
locked type
LOG
LOG10
LOGEST
LogicalOperators Enumeration
LOGINV
LOGNORM.DIST
LOGNORM.INV
LOGNORMDIST
LOOKUP
LOWER
Manage Data Visualization and Objects
Manage User Interface
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
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
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 type
pasteFloatingObjects type
Pattern Fill and Gradient Fill
Pattern Fill in Charts
PatternType Enumeration
PatternType Enumeration
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
PivotCaptionFilterOperator Enumeration
PivotDateFilterOperator Enumeration
PivotPanel type
PivotTable type
PivotTableFieldType Enumeration
PivotTableLayoutType Enumeration
PivotTableTheme type
PivotTableThemes type
PivotTop10FilterOperator Enumeration
PivotTop10FilterType Enumeration
PivotValueFilterOperator Enumeration
pluggable
PMT
point
Point type
POISSON
POISSON.DIST
POWER
PPMT
Precision Selection
Preserve Unsupported Charts
PresetLineDashStyle Enumeration
Prevent Resizing
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
R1C1 Notation
Radar Chart
RADIANS
Radio Button List Cell
RadioButtonList type
RAND
RANDARRAY
RANDBETWEEN
range
Range Grouping
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
Relative and Absolute
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 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
Row Filtering
Row Filtering
RowCol Enumeration
RowFilterBase type
RowHeader type
ROWS
Rows and Columns
Rows and Columns
RRI
RSQ
rule
rule
rule
rule
rule
rule
rule
rule
rule
rule
rules
RuleType Enumeration
Sample Formula
save
save
save
Save and Load JavaScript Files
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 Active Cell
Set Active Cell at a Specific Location
Set Alignment and Indentation
Set Background Image
Set Cell Borders
Set Cell Color
Set Cell Values
Set Conditional Formats
Set Culture
Set Default Style
Set Edit Mode Always
Set Era Format
Set Fixed or Frozen Rows and Columns
Set Formulas
Set Formulas in Cells
Set Header Color
Set Large Amounts of Data
Set Large Amounts of Formulas
Set Number of Rows and Columns
Set Number of Sheets
Set Range Template Cell
Set Selection State when Editing Starts
Set Table Styles
Set Top Row and Column
Set Visual 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
Sheet and Sheets Elements
Sheet Area Offset
Sheet Element
Sheet References in a Formula
Sheet Settings Exported
SheetArea 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
Sort
Sort
Sort
Sort
Sort
Sort Column
Sort Data
Sort Row Ranges with Sort Conditions
Sort with Grouped Data
SORTBY
SortState Enumeration
SortType Enumeration
span
Span or Merge Cells
Span or Merge Header Cells
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 Widget
SpreadJS with Angular
SpreadJS with AngularJS
SpreadJS with Breeze
SpreadJS with Knockout
SpreadJS with React
SpreadJS with the Wijmo DataView
SpreadJS with Vue
Spread-Sheets Element
SpreadSparkline type
SQRT
SQRTPI
stacked
Stacked Sparkline
StackedSparkline type
STANDARDIZE
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
TableSlicerData type
TableStyle type
TableTheme type
TableThemes type
tabStop type
tag
Tag Hierarchy
TAN
TANH
TBILLEQ
TBILLPRICE
TBILLYIELD
TDIST
Technical Support
text
text
Text Decoration
Text Indentation
Text type
TextAlign Enumeration
TextCompareType Enumeration
TextComparisonOperators Enumeration
textDecoration type
TextDecorationType Enumeration
textIndent type
TEXTJOIN
textOrientation type
Theme
Theme
Theme
Theme API Changes
Theme type
ThemeColors type
themeFont type
Themes type
TickLabelPosition Enumeration
TickMark Enumeration
TIME
TIMEVALUE
TINV
TODAY
toolbar
tooltip
Tooltips
Top 10 Rule
Top10ConditionType Enumeration
top10rule
touch
touch
touch
Touch API Changes
Touch Support
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
Understand Touch Gestures
Understand Touch Support
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 Code to Copy and Paste
Use Cross Sheet References
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
Use Subtotals
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
VerticalPosition Enumeration
view
View Tab
VisualState Enumeration
VLOOKUP
volatile
Volatile Functions
Vue
Watermark
watermark type
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