A1 Notation
ABS
accent
accounting
Accounting Format
ACCRINT
ACCRINTM
ACOS
ACOSH
ACOT
ACOTH
action
action
actions
Actions and Key API Changes
add
Adding a Background Image
Adding a Comment to a Cell
Adding a Sheet
Adding a Tag to a Cell
Adding a Watermark
Adding and Deleting Outlines
Adding Built-In Shapes
Adding Columns and Rows
Adding Connector Shapes
Adding Custom Shapes
Adding Group Shapes
Adding Rows
Adding Shapes with Formulas
Adding the Client Widget to a Browser Page
Adding Unbound Columns
ADDRESS
align
alignment
Allow Merging Cells via Mouse Drag
Allowing Cell Overflow
Allowing Cell Overflow
Allowing Drag and Drop
Allowing Users to Enter Formulas
Allowing Users to Enter Formulas
Allowing Zooming
always
AMORDEGRC
AMORLINC
AND
angularjs
API Changes
API Documentation
ARABIC
area
AREAS
AreaSparkline type
arguments
array
Arrays in a Formula
ArrowheadLength Enumeration
ArrowheadStyle Enumeration
ArrowheadWidth Enumeration
ascending
ASIN
ASINH
AsyncEvaluateContext type
AsyncFunction type
AsyncFunctionEvaluateMode Enumeration
ATAN
ATAN2
ATANH
Auto Fill Data
Auto Fill Dates
Auto Fill Lists
Auto Fill Strings
AutoFillType Enumeration
AutoFit
AutoFit
autoFitColumn type
autoFitRow type
AutoFitType Enumeration
automatic fit
AutoShapeType Enumeration
Available CalcEngine Language Packages For SpreadJS
AVEDEV
average
average
AVERAGEA
AverageConditionType Enumeration
AVERAGEIF
AVERAGEIFS
Avoid Using Volatile Functions
axis
AxisGroup Enumeration
background
Background Image
BAHTTEXT
bar
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
binding
binding
binding
Binding Cells
Binding Tables
Binding to a Table
Binding to Columns
Binding to Data
Bindings type
BINOM.DIST
BINOM.DIST.RANGE
BINOM.INV
BINOMDIST
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
Borders and Gridlines
bound
box plot
BoxPlotSparkline type
break
breeze
browser
built-in
bullet
BulletSparkline type
button
Button type
CalcEngine type
CalcError type
Calculation API Changes
cancelInput type
cascade
CascadeSparkline type
CEILING
CEILING.MATH
CEILING.PRECISE
cell
cell
Cell Alignment, Indentation, and Text Decoration
Cell API Changes
Cell Comment
Cell Format
Cell Overflow
Cell References in a Formula
Cell Settings Exported
Cell Settings Imported
Cell Span
Cell Tags
cell type
Cell Types
cell value
CellBindingSource type
CellRange type
celltype
celltype
celltype
CellTypes type
changeFormulaReference type
Changing Row Height and Column Width
Changing the Active Cell Backcolor
Changing the Default Input Map
Changing the Grid Line Appearance
Changing the Header Size
Changing the Sheet Names
CHAR
chart
chart
chart
chart
chart
Chart type
ChartCollection type
Charts type
ChartType Enumeration
checkbox
CheckBox type
CheckBoxTextAlign Enumeration
CHIDIST
CHIINV
CHISQ.DIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
CHISQ.TEST
CHITEST
CHOOSE
CLEAN
clear type
clearAndEditing type
clearValues type
client-side
clipboard
Clipboard Operations
clipboardPaste type
ClipboardPasteOptions Enumeration
Codabar type
CODE
Code128 type
Code39 type
Code49 type
Code93 type
collapse
color
color
color
color
color
ColorCompareType Enumeration
ColorScheme type
column
column
column
column
Column and Row Resize
ColumnHeader type
COLUMNS
ColumnSparkline type
COMBIN
COMBINA
combo
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
Conditional Formatting
Conditional Formatting API Changes
ConditionalFormats type
ConditionalFormatting type
ConditionRuleBase type
ConditionType Enumeration
CONFIDENCE
CONFIDENCE.NORM
CONFIDENCE.T
Configuring Axes
Configuring Chart Elements
Configuring Chart Title, Chart Area and Plot Area
Configuring Data Label
Configuring Data Markers
Configuring Gridlines
Configuring Legends
Configuring Series
ConnectorShape type
ConnectorType Enumeration
Context Menu
ContextMenu type
ContextMenu type
CONVERT
Convert Expression To Formula
Convert Formula To Expression
Convert Formula To Ranges
copy type
Copying and Pasting Styles
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
Creating a Box Plot Sparkline
Creating a Bullet Sparkline
Creating a Cascade Sparkline
Creating a Custom Action Map
Creating a Custom Culture
Creating a Custom Filter
Creating a Custom Slicer
Creating a Custom Sparkline
Creating a Month Sparkline
Creating a Pareto Sparkline
Creating a Pie Sparkline
Creating a Scatter Sparkline
Creating a Spread Sparkline
Creating a Stacked Sparkline
Creating a Table Slicer
Creating a Table Slicer with the SpreadJS Designer
Creating a Vari Sparkline
Creating a Vbar Sparkline
Creating a Year Sparkline
Creating an Area Sparkline
Creating an Array Formula
Creating an Hbar Sparkline
Creating an Item Slicer
Creating and Removing Selections
Creating and Using a Custom Language Package
Creating Area Chart
Creating Bar Chart
Creating Cell Spans
Creating Column Chart
Creating Column, Line, and Winloss Sparklines Using Methods
Creating Column, Line, and Winloss Sparklines with Formulas
Creating Combo Chart
Creating Custom Floating Objects
Creating Custom Formulas
Creating Custom Names
Creating Floating Pictures
Creating Line Chart
Creating Multiple Headers
Creating Multiple Rows and Columns in the Headers
Creating Multiple Selections
Creating Pie Chart
Creating Radar Chart
Creating Row Filters
Creating Scatter Chart
Creating Stock Chart
Creating Sunburst Chart
Creating Tables
Creating Treemap Chart
CRITBINOM
CriteriaType Enumeration
CSC
CSCH
CSV
CSV Import and Export
culture
culture
Culture API Changes
Culture Settings
CultureInfo type
CultureManager type
CUMIPMT
CUMPRINC
custom
custom
custom
custom
custom
custom
custom
Custom PDF Export
Customizing the Appearance
Customizing the Headers
Customizing the Range Groups
Customizing the Row Filter Actions
CustomValueType Enumeration
cut type
data
data bar rule
Data Binding
Data Binding API Changes
data source
data source
Data Validation
Data Validation API Changes
DataBarAxisPosition Enumeration
DataBarRule type
database
Database Functions
DataLabelPosition Enumeration
DataMatrix type
DataOrientation Enumeration
DataPoints type
DataValidation type
DataValidationResult Enumeration
date
date
date and time
Date and Time Functions
DateCompareType Enumeration
DATEDIF
DateOccurringType Enumeration
DATEVALUE
DAVERAGE
DAY
day count
Day Count Basis
DAYS
DAYS360
DB
DCOUNT
DCOUNTA
DDB
Deactivating Clipboard Keys
Deactivating Pasting
Deactivating the Default Input Map
DEC2BIN
DEC2HEX
DEC2OCT
DECIMAL
decoration
DefaultDataValidator type
DEGREES
deleteFloatingObjects type
Deleting a Sheet
Deleting Columns and Rows
DELTA
descending
design
Developer's Guide
DEVSQ
DGET
dirty status
DISC
Display Preview Line for Print
Displaying Tooltips
DisplayMode Enumeration
DMAX
DMIN
DOLLAR
DOLLARDE
DOLLARFR
DPRODUCT
drag
Drag and Merge
Drag and Move
Drag Fill
Drag Fill
Drag Fill
dragCopyFloatingObjects type
dragDrop type
drop
DSTDEV
DSTDEVP
DSUM
duplicate
DURATION
DVAR
DVARP
EAN13 type
EAN8 type
easy outline
EDATE
edit
Edit Mode Always
editable
editable
editCell type
EditorStatus Enumeration
EditorType Enumeration
EditorValueType Enumeration
EFFECT
element
element
element
element
element
element
EmptyValueStyle Enumeration
ENCODEURL
End-User License Agreement
EOMONTH
era
ERF
ERF.PRECISE
ERFC
ERFC.PRECISE
ERROR.TYPE
ErrorCode Enumeration
ErrorStyle Enumeration
EURO
EUROCONVERT
Evaluate Formula
EVEN
Events type
EXACT
excel 2013
Excel Import and Export
excel2013
Excel-Formatted Files Export
Excel-Formatted Files Import
EXP
expand
expandColumnOutline type
expandColumnOutlineForLevel type
Expanding and Collapsing Outlines
expandRowOutline type
expandRowOutlineForLevel type
EXPON.DIST
EXPONDIST
export
export
Exporting to PDF
Expression type
ExpressionType Enumeration
F.DIST
F.DIST.RT
F.INV
F.INV.RT
F.TEST
FACT
FACTDOUBLE
FALSE
FDIST
Feature Overview
file
Fill API Changes
Fill type
Fill type
FillDateUnit Enumeration
FillDirection Enumeration
FillSeries Enumeration
FillType Enumeration
filter
filter
Filter API Changes
Filter type
FilterActionType Enumeration
FilteredOutDataType Enumeration
Filtering a Row with Code
Filtering Rows
FIND
FINDB
FINV
FISHER
FISHERINV
fit
fit
FIXED
float
float
Floating Objects
FloatingObject type
FloatingObjectCollection type
FloatingObjects type
FLOOR
FLOOR.MATH
FLOOR.PRECISE
FORECAST
format
format
formatter
Formatter API Changes
FormatterBase type
formatting
Formatting Cells
formula
formula
formula
formula
formula
Formula Functions
Formula Overview
Formula Reference
Formula Settings Imported
formula text box
Formulas
Formulas
FORMULATEXT
FormulaTextBox type
FormulaTextBox type
freezing
Freezing Columns and Rows
FREQUENCY
frozen
Frozen Columns and Rows
FTEST
function
Function type
Functions in a Formula
Functions type
FV
FVSCHEDULE
GAMMA
GAMMA.DIST
GAMMA.INV
GAMMADIST
GAMMAINV
GAMMALN
GAMMALN.PRECISE
GAUSS
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.Sheets Namespace

Overview

GC.Spread.Sheets.Barcode Namespace

Overview

GC.Spread.Sheets.Bindings Namespace

Overview

GC.Spread.Sheets.CalcEngine 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.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.Tables Namespace

Overview

GC.Spread.Sheets.Touch Namespace

Overview

GC.Spread.Slicers Namespace

Overview

GCD
GeneralComparisonOperators Enumeration
GeneralFormatter type
GeneralSlicerData type
GEOMEAN
GESTEP
gestures
Get Page Information
Getting Cell Index from Mouse Click
Getting Cell Values
Getting Header Cell Index from Mouse Click
Getting Selected Ranges
Getting Started
Getting Technical Support
Getting the Active Cell Index
Getting the Cell Position and Size
Getting the Dirty Status
Getting the Displayed Cell Index
Getting the Row Filter Results
Getting the Row Filter Status
group
grouping
Grouping API Changes
GroupShape type
GROWTH
GS1_128 type
Handle Callback action on a Hyperlink Cell
Handling Redistribution
HARMEAN
hbar
HBarSparkline type
header
HeaderAutoText Enumeration
HEX2BIN
HEX2DEC
HEX2OCT
hide
HideRowFilter type
Hiding the Filter Indicator
Hiding the Headers
HighlightPosition Enumeration
HighlightType Enumeration
Hit Testing
HLOOKUP
home
Horizontal and Vertical Axes
HorizontalAlign Enumeration
HorizontalPosition Enumeration
HOUR
hyperlink
HyperLink type
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
ImeMode Enumeration
IMEXP
IMLN
IMLOG10
IMLOG2
import
import
Import and Export Reference
Importing and Exporting CSV Files
Importing and Exporting Excel Files on the Client-Side
Importing and Exporting to JSON
IMPOWER
IMPRODUCT
IMREAL
IMSEC
IMSECH
IMSIN
IMSINH
IMSQRT
IMSUB
IMSUM
IMTAN
indent
indent
INDEX
INDIRECT
input
input
Input Mapping
input method editor
insert
INT
INTERCEPT
INTRATE
InvalidOperationType Enumeration
IO type
IPMT
IRR
ISBLANK
ISERR
ISERROR
ISEVEN
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISO.CEILING
ISODD
ISOWEEKNUM
ISPMT
ISREF
ISTEXT
ItemSlicer type
javascript
JavaScript Frameworks
JavaScript Open and Save
JSON
JSON API Changes
JSON Import and Export
JSON Schema
Key Enumeration
keyboard
Keyboard Navigation
keys
keys
keys
knockout
KURT
LabelAlignment Enumeration
LabelVisibility Enumeration
LanguagePackages type
LARGE
layout
LCM
LEFT
LEFTB
LegendPosition Enumeration
LEN
LENB
level
license
LicenseKey type
line
line
line
line
LineBorder type
LineCapStyle Enumeration
LineJoinStyle Enumeration
LineSparkline type
LINEST
LineStyle Enumeration
LineType type
LN
load
localize
lock
Locking Cells
LOG
LOG10
LOGEST
LogicalOperators Enumeration
LOGINV
LOGNORM.DIST
LOGNORM.INV
LOGNORMDIST
LOOKUP
LOWER
Managing Data
Managing Data Visualization and Objects
Managing the User Interface
map
marker
Markers and Points
MATCH
MAX
MAXA
MAXIFS
MDETERM
MDURATION
MEDIAN
menu
MenuView type
MID
MIDB
migratemethod
MIN
MINA
MINIFS
MINUTE
MINVERSE
MIRR
MMULT
MOD
mode
mode
MODE.MULT
MODE.SNGL
module
MONTH
MonthSparkline type
move
moveFloatingObjects type
moveToNextCell type
moveToNextCellThenControl type
moveToPreviousCell type
moveToPreviousCellThenControl type
MROUND
MULTINOMIAL
multiple
Multiple Headers
N
NA
name
name
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
Object Inheritance
OCT2BIN
OCT2DEC
OCT2HEX
ODD
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
OFFSET
open
open
Opening and Saving Files
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
pareto
ParetoSparkline type
paste type
pasteFloatingObjects type
PDF type
PDF417 type
PDFFontsManager type
PDURATION
PEARSON
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
PieSparkline type
pluggable
PMT
point
Point type
POISSON
POISSON.DIST
POWER
PPMT
Precision Selection
PresetLineDashStyle Enumeration
Preventing Resizing
PRICE
PRICEDISC
PRICEMAT
print
Print API Changes
Print Background Image As Watermark
Print Settings Exported
Print Settings Imported
Print type
PrintCentering Enumeration
PrintInfo type
Printing
Printing Sheets
PrintPageOrder Enumeration
PrintPageOrientation Enumeration
PrintVisibilityType Enumeration
PROB
PRODUCT
Product Overview
Product Requirements
PROPER
protect
Protect and Cell Locking
PV
QRCode type
QuarterType Enumeration
QUARTILE
QUARTILE.EXC
QUARTILE.INC
Quote Prefix
QUOTIENT
R1C1 Notation
RADIANS
RAND
RANDBETWEEN
range
Range Grouping
Range type
RangeChangedAction Enumeration
RangeReferenceRelative Enumeration
RANK
RANK.AVG
RANK.EQ
rapid
RATE
RECEIVED
Rect type
redo
redo type
reference
reference
reference
reference styles
ReferenceStyle Enumeration
REFRESH
Relative and Absolute
removeColumnOutline type
removeRowOutline type
renameSheet type
REPLACE
REPLACEB
REPT
resize
resize
resize
resizeColumn type
resizeFloatingObjects type
resizeRow type
ResizeZeroIndicator Enumeration
Resizing Columns and Rows
Resultant Error Values
Rich Text Format
RIGHT
RIGHTB
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
ROW
Row and Column Settings Exported
Row and Column Settings Imported
Row Filter
RowCol Enumeration
RowFilterBase type
RowHeader type
ROWS
RRI
RSQ
rule
rule
rule
rule
rule
rule
rule
rule
rule
rule
rules
RuleType Enumeration
Sample Code
Sample Code for Cell References
Sample Code for Cells
Sample Code for Data Binding
Sample Code for Formulas
Sample Code for Frequently Used Events
Sample Code for Keyboard and Input Maps
Sample Code for Range Grouping
Sample Code for Row Filtering
Sample Code for Rows and Columns
Sample Code for Sorting
Sample Code for the Sheet
Sample Code for the Widget
Sample Code Using the Clipboard
Sample Formula
save
save
save
Saving and Loading JavaScript Files
scale
ScaleRule type
ScaleValue type
ScaleValueType Enumeration
scatter
ScatterSparkline type
schema
Scroll Bars
Scroll Bars
scrolling
search
search
Search API Changes
Search type
SEARCHB
SearchCondition type
SearchFlags Enumeration
SearchFoundFlags Enumeration
Searching
Searching Data
SearchOrder Enumeration
SearchResult type
SEC
SECH
SECOND
selection
selectionBottom type
selectionDown type
selectionEnd type
selectionFirst type
selectionHome type
selectionLast type
selectionLeft type
selectionPageDown type
selectionPageUp type
SelectionPolicy Enumeration
selectionRight type
selections
selectionTop type
SelectionUnit Enumeration
selectionUp type
selectNextControl type
selectPreviousControl type
series
SeriesCollection type
SERIESSUM
Set Chart Color with Transparency
Set the Text Indentation
Set the Word Wrap Formatting
Setting a Background Image
Setting a Button Cell
Setting a Check Box Cell
Setting a Combo Box Cell
Setting a Custom Cell
Setting a Hyperlink Cell
Setting a Widget Border
Setting Alignment and Indentation
Setting Borders, Gridlines and Diagonal Lines
Setting Cell Alignment and Indentation
Setting Cell Borders
Setting Cell Padding and Label Styles
Setting Cell Values
Setting Codabar
Setting Code128
Setting Code39
Setting Code49
Setting Code93
Setting Colors
Setting Conditional Formats
Setting DataMatrix
Setting EAN-13
Setting EAN-8
Setting Edit Mode Always
Setting Fixed or Frozen Rows and Columns
Setting Formulas in Cells
Setting GS1_128
Setting Large Amounts of Data
Setting Large Amounts of Formulas
Setting Page Breaks when Printing
Setting PDF417
Setting QRCode
Setting Rich Text in a Cell
Setting Selection State when Editing Starts
Setting Sheet Area Offset
Setting Styles
Setting Styles and Themes
Setting Table Styles
Setting Text Decoration
Setting the Active Cell
Setting the Active Cell at a Specific Location
Setting the Cell Color
Setting the Culture
Setting the Default Style
Setting the Era Format
Setting the Header Color
Setting the Number of Rows and Columns
Setting the Number of Sheets
Setting the Table Slicer Styles
Setting the Top Row and Column
Setting Vertical Text Direction in a Cell
Setting Visual Styles
settings
Shape type
ShapeBase type
ShapeCollection type
ShapeFillType Enumeration
Shapes
Shapes type
ShapeStyle type
Sheet Area Offset
Sheet References in a Formula
Sheet Settings Exported
SheetArea Enumeration
ShowResizeTip Enumeration
ShowScrollTip Enumeration
shrink
Shrink to Fit
SIGN
SIN
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
Sorting
Sorting a Column
Sorting Data
Sorting Row Ranges with Sort Conditions
SortState Enumeration
span
Spanning or Merging Cells
Spanning or Merging 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
Sparklines type
SparklineSetting type
SparklineType Enumeration
spread
Spread Settings Exported
SpreadJS

Overview

SpreadJS Designer
SpreadJS Designer Data Tab
SpreadJS Designer File Tab
SpreadJS Designer Formulas Tab
SpreadJS Designer Home Tab
SpreadJS Designer Insert and Design Tab
SpreadJS Designer Settings Tab
SpreadJS Designer View Tab
SpreadJS Documentation
SpreadJS Spread Schema
SpreadSparkline type
SQRT
SQRTPI
stacked
StackedSparkline type
STANDARDIZE
Starting and Using the Designer
status
StatusBar type
StatusBar type
StatusItem type
STDEV
STDEV.P
STDEV.S
STDEVA
STDEVP
STDEVPA
STEYX
StorageType Enumeration
structured
Structured References
style
Style API Changes
Style type
Styles
SUBSTITUTE
SUBTOTAL
SUM
SUMIF
SUMIFS
Summary of Conditional Formatting Types
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
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
table
table
Table API Changes
Table type
TableColumn type
TableManager type
TableRemoveOptions Enumeration
Tables
Tables type
TableSlicerData type
TableStyle type
TableTheme type
TableThemes type
TabStrip
tag
TAN
TANH
TBILLEQ
TBILLPRICE
TBILLYIELD
TDIST
text
text
Text type
TextCompareType Enumeration
TextComparisonOperators Enumeration
TextDecorationType Enumeration
TEXTJOIN
theme
theme
Theme API Changes
Theme type
ThemeColors type
Themes
Themes type
TickLabelPosition Enumeration
TickMark Enumeration
TIME
TIMEVALUE
TINV
TODAY
toolbar
tooltip
Tooltips
Top10ConditionType Enumeration
top10rule
touch
touch
touch
Touch API Changes
touch support
Touch type
TouchToolStrip type
TouchToolStripItem type
TouchToolStripSeparator type
trailing
TRANSPOSE
TREND
TRIM
TRIMMEAN
TRUE
TRUNC
TTEST
TYPE
type type
typescript
typescript
UMD Support
underline
Understanding Chart
Understanding Conditional Formats
Understanding Printing
Understanding Shapes
Understanding Sparklines
Understanding SpreadJS Designer Interface Menus
Understanding SpreadJS Designer Status Bar
Understanding the Column Element
Understanding the Product
Understanding the Sheet Element
Understanding the SpreadJS Designer Interface
Understanding the SpreadJS Designer Tabs
Understanding the Tag Hierarchy
Understanding the Worksheet Element
Understanding Touch Gestures
Understanding Touch Support
undo
Undo and Redo
undo type
UndoManager type
ungroup
UNICHAR
UNICODE
unique
UPPER
Use Custom Font for PDF Export
User Interface API Changes
Using a Bootstrap Theme
Using a Slicer
Using Animation in Charts
Using Asynchronous Functions
Using Automatic Fit
Using Built-In Formulas
Using Click Events
Using Clipboard Operations
Using Code to Copy and Paste
Using Column, Columns, and Group Elements
Using Conditional Formatting
Using Cross Sheet References
Using Custom Themes from ThemeRoller
Using Data Validation
Using Double-click for Auto Fill
Using Drag and Move
Using Drag Fill
Using Edit Mode Always
Using Events when Data Changes
Using Events when Dragging and Moving
Using Events when Edit Mode Starts or Stops
Using Events when Moving a Cell
Using Events when the Sheet Tab Changes
Using Events when the Top Row or Column Changes
Using Formulas
Using Hit Testing
Using IME Mode
Using Input Mapping
Using JSON Schema with SpreadJS
Using Keyboard Navigation
Using Language Package
Using Previous Code with the Current Version
Using Protect and Cell Locking
Using Range Grouping
Using Rapid Input Mode
Using Row Filtering
Using Scroll Bars
Using Serialization
Using Shrink to Fit
Using SpreadJS and Spread.Views
Using SpreadJS Libraries
Using SpreadJS with Angular
Using SpreadJS with AngularJS
Using SpreadJS with Breeze
Using SpreadJS with Knockout
Using SpreadJS with React
Using SpreadJS with the Wijmo DataView
Using SpreadJS with Vue
Using Structured Reference Formulas
Using Subtotals
Using suspendDirty and resumeDirty
Using suspendEvent and resumeEvent
Using suspendPaint and resumePaint
Using Tables
Using the Accounting Format
Using the Average Rule
Using the Button Clicked Event with Cells
Using the Cell Elements
Using the Cell Value Rule
Using the Chart Element
Using the Column Element
Using the Context Menu
Using the Data Bar Rule
Using the Date Occurring Rule
Using the Default SpreadJS Theme
Using the Duplicate Rule
Using the Excel IO Element
Using the Excel Theme
Using the Formula Rule
Using the Formula Text Box
Using the Formula Text Box as a Control
Using the gc-column Element
Using the Gc-spread-sheets Element
Using the Gc-spread-sheets Element
Using the gc-worksheet Element
Using the Goal Seek Method
Using the Icon Set Rule
Using the Scale Rule
Using the Shape Element
Using the Sheet and Sheets Elements
Using the Specific Text Rule
Using the SpreadJS Designer
Using the SpreadJS Designer Template with Cell Binding
Using the Spread-Sheets Element
Using the Status Bar
Using the Style Element
Using the Tab Strip
Using the Top 10 Rule
Using the Unique Rule
Using the Validator Element
Using the Worksheet Element
Using Themes
Using Touch Support
Using Touch Support when Resizing Columns or Rows
Using Touch Support when Scrolling
Using Touch Support when Zooming
Using Touch Support with Automatic Fit
Using Touch Support with Cell Types
Using Touch Support with Chart
Using Touch Support with Drag Fill
Using Touch Support with Editable Cells
Using Touch Support with Filtering
Using Touch Support with Grouping
Using Touch Support with Selections
Using Touch Support with the Tab Strip
Using Touch Support with the Touch Toolbar
Using Touch Support with the Widget
Using TypeScript
Using Undo and Redo
validate
validation
VALUE
ValueType Enumeration
VAR
VAR.P
VAR.S
VARA
vari
VariSparkline type
VARP
VARPA
vbar
VBarSparkline type
VDB
VertAlign Enumeration
VerticalAlign Enumeration
VerticalPosition Enumeration
view
VisualState Enumeration
VLOOKUP
volatile
Volatile Functions
Watermark
Watermark
WEEKDAY
WEEKNUM
WEIBULL
WEIBULL.DIST
What is a Formula
wheel
wildcard
Wildcard Characters in a Formula
winloss
winloss
winloss
WinlossSparkline type
wordwrap
Workbook API Changes
Workbook Settings Imported
Workbook type
WORKDAY
WORKDAY.INTL
Working in the Designer
Working with Barcodes
Working with Cell Types
Working with Chart Types
Working with JavaScript Frameworks
Working with Selections
Working with the Quote Prefix
Worksheet API Changes
Worksheet Settings Imported
Worksheet type
Wrap Text In Cell
XIRR
XNPV
XOR
YEAR
YEARFRAC
YearSparkline type
YIELD
YIELDDISC
YIELDMAT
Z.TEST
Zoom
Zoom
Zoom
zoom type
ZTEST