A1 Notation
ABS
accent
ACCRINT
ACCRINTM
ACOS
ACOSH
action
action
actions
Actions and Key API Changes
ActiveSheetChanged type
ActiveSheetChanging type
add
Adding a Background Image
Adding a Comment to a Cell
Adding a License for the Excel Import and Export Component
Adding a Sheet
Adding a Tag to a Cell
Adding a Watermark
Adding and Deleting Outlines
Adding Columns and Rows
Adding Rows
Adding the Client Widget to a Browser Page
Adding Unbound Columns
ADDRESS
alignment
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
Apex type
Apex type
API Changes
API Documentation
area
AreaSparkline type
arguments
array
Arrays in a Formula
ascending
ASIN
ASINH
Aspect type
Aspect type
AsyncEvaluateContext type
AsyncFunction type
AsyncFunctionEvaluateMode type
ATAN
ATAN2
ATANH
AutoFillType Enumeration
AutoFit
AutoFit
autoFitColumn type
autoFitRow type
AutoFitType Enumeration
autoGenerateColumns type
automatic fit
AVEDEV
average
average
AVERAGEA
AverageConditionType Enumeration
AVERAGEIF
AVERAGEIFS
axis
backColor type
backColor type
background
Background Image
backgroundImage type
backgroundImageLayout type
bar
BarDirection Enumeration
Base type
BESSELI
BESSELJ
BESSELK
BESSELY
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.INV
BINOMDIST
borderBottom type
borderBottom type
borderHorizontal type
borderLeft type
borderLeft type
borderRight type
borderRight type
Borders and Gridlines
borderTop type
borderTop type
borderVertical type
bound
box plot
BoxPlotSparkline type
break
breeze
browser
built-in
bullet
BulletSparkline type
button
Button type
ButtonClicked type
CalcEngine type
CalcEngine type
CalcError type
Calculation API Changes
cancelInput type
cascade
CascadeSparkline type
CEILING
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
CellChanged type
CellClick type
CellDoubleClick type
cellPadding type
CellRange type
celltype
celltype
celltype
cellType type
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
checkbox
CheckBox type
CheckBoxTextAlign Enumeration
CHIDIST
CHIINV
children type
CHISQ.DIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
CHISQ.TEST
CHITEST
CHOOSE
Civic type
Civic type
CLEAN
clear type
clearAndEditing type
clearValues type
client-side
clipboard
Clipboard Operations
ClipboardChanged type
ClipboardChanging type
clipboardPaste type
ClipboardPasted type
ClipboardPasteOptions Enumeration
ClipboardPasting type
CODE
col type
col type
colCount type
colCount type
collapse
color
color
color
color
color
color type
ColorCompareType Enumeration
ColorScheme type
column
column
column
column
Column and Row Resize
column type
ColumnChanged type
columnEnd type
ColumnHeader type
columnNames type
columnOutlines type
COLUMNS
ColumnSparkline type
columnStart type
ColumnWidthChanged type
ColumnWidthChanging type
COMBIN
combo
ComboBox type
CommandManager type
Commands type
Commands type
comment
Comment API Changes
Comment type
CommentChanged type
CommentManager type
CommentRemoved type
CommentRemoving type
Comments type
Comments type
CommentState Enumeration
commitArrayFormula type
commitInputNavigationDown type
commitInputNavigationUp type
Common type
ComparisonOperators Enumeration
complex
complex
Complex Numbers
CONCATENATE
Concourse type
Concourse type
Condition type
conditional
Conditional Formatting
Conditional Formatting
Conditional Formatting
Conditional Formatting API Changes
ConditionalFormats type
ConditionalFormats type
ConditionalFormatting type
ConditionRuleBase type
ConditionType Enumeration
CONFIDENCE
CONFIDENCE.NORM
CONFIDENCE.T
CONVERT
copy type
Copying and Pasting Styles
CopyPasteHeaderOptions Enumeration
CopyToOptions Enumeration
Corner type
CORREL
COS
COSH
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 Cell Spans
Creating Column, Line, and Winloss Sparklines Using Methods
Creating Column, Line, and Winloss Sparklines with Formulas
Creating Custom Floating Objects
Creating Custom Formulas
Creating Custom Names
Creating Floating Pictures
Creating Multiple Headers
Creating Multiple Rows and Columns in the Headers
Creating Multiple Selections
Creating Row Filters
Creating Tables
CRITBINOM
CriteriaType Enumeration
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
Customizing the Appearance
Customizing the Headers
Customizing the Row Filter Actions
CustomValueType Enumeration
cut type
dark1 type
dark10 type
dark11 type
dark2 type
dark3 type
dark4 type
dark5 type
dark6 type
dark7 type
dark8 type
dark9 type
data
data bar rule
Data Binding
Data Binding API Changes
Data Enumerations
data source
data source
data type
Data Validation
Data Validation API Changes
DataBarAxisPosition Enumeration
DataBarRule type
database
Database Functions
DataOrientation Enumeration
DataValidation type
DataValidationResult Enumeration
date
date
date and time
Date and Time Functions
DateCompareType Enumeration
DATEDIF
DateOccurringType Enumeration
DateTimeFormat type
DATEVALUE
DAVERAGE
DAY
day count
Day Count Basis
DAYS360
DB
DCOUNT
DCOUNTA
DDB
Deactivating Clipboard Keys
Deactivating Pasting
Deactivating the Default Input Map
DEC2BIN
DEC2HEX
DEC2OCT
decoration
Default type
Default type
DefaultDataValidator type
defaults type
DEGREES
deleteFloatingObjects type
Deleting a Sheet
Deleting Columns and Rows
DELTA
descending
design
Developer's Guide
DEVSQ
DGET
dirty status
DISC
Displaying Tooltips
DisplayMode Enumeration
DMAX
DMIN
DOLLAR
DOLLARDE
DOLLARFR
DPRODUCT
drag
Drag and Move
Drag Fill
Drag Fill
Drag Fill
dragCopyFloatingObjects type
dragDrop type
DragDropBlock type
DragDropBlockCompleted type
DragFillBlock type
DragFillBlockCompleted type
drop
DSTDEV
DSTDEVP
DSUM
duplicate
DURATION
DVAR
DVARP
EDATE
edit
Edit Mode Always
editable
editable
editCell type
EditChange type
EditEnded type
EditEnding type
EditorStatus Enumeration
EditorStatusChanged type
EditorValueType Enumeration
EditStarting type
EFFECT
element
element
element
element
element
element
EmptyValueStyle Enumeration
end type
endSheetIndex type
End-User License Agreement
EnterCell type
EOMONTH
Equity type
Equity type
era
ERF
ERF.PRECISE
ERFC
ERFC.PRECISE
ERROR.TYPE
ErrorCode Enumeration
ErrorStyle Enumeration
EURO
EUROCONVERT
EVEN
Events type
EXACT
excel
excel 2013
Excel Export Classes
Excel Import and Export
Excel Import Classes
Excel Open and Save Flags
Excel type
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
export
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
FINV
FISHER
FISHERINV
fit
fit
FIXED
float
float
Floating Objects
FloatingObject type
FloatingObjectChanged type
FloatingObjectCollection type
FloatingObjectLoaded type
FloatingObjectRemoved type
FloatingObjectRemoving type
FloatingObjects type
FloatingObjects type
FloatingObjectSelectionChanged type
FLOOR
FLOOR.PRECISE
Flow type
Flow type
font type
font type
FORECAST
foreColor type
foreColor type
format
format
formatter
Formatter API Changes
Formatter type
Formatter type
FormatterBase type
Formatting Cells
formula
formula
formula
formula
formula
Formula Functions
Formula Overview
Formula Reference
Formula Settings Imported
formula text box
Formulas
Formulas
FormulaTextBox type
FormulaTextBox type
foundColumnIndex type
foundRowIndex type
Foundry type
Foundry type
foundSheetIndex type
foundString 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.DIST
GAMMA.INV
GAMMADIST
GAMMAINV
GAMMALN
GAMMALN.PRECISE
GC Namespace

Overview

GC.Spread Namespace

Overview

GC.Spread.CalcEngine Namespace

Overview

GC.Spread.CalcEngine.Expression Namespace

Overview

GC.Spread.CalcEngine.Functions Namespace

Overview

GC.Spread.CalcEngine.Functions.Function Namespace

Overview

GC.Spread.Commands Namespace

Overview

GC.Spread.Common Namespace

Overview

GC.Spread.Common.CultureInfo Namespace

Overview

GC.Spread.Excel Namespace

Overview

GC.Spread.Excel.IO Namespace

Overview

GC.Spread.Formatter Namespace

Overview

GC.Spread.Formatter.FormatterBase Namespace

Overview

GC.Spread.Sheets Namespace

Overview

GC.Spread.Sheets.Bindings Namespace

Overview

GC.Spread.Sheets.CalcEngine Namespace

Overview

GC.Spread.Sheets.CellRange Namespace

Overview

GC.Spread.Sheets.CellTypes Namespace

Overview

GC.Spread.Sheets.CellTypes.Base Namespace

Overview

GC.Spread.Sheets.Commands Namespace

Overview

GC.Spread.Sheets.Comments Namespace

Overview

GC.Spread.Sheets.ConditionalFormatting Namespace

Overview

GC.Spread.Sheets.ConditionalFormatting.ScaleValue Namespace

Overview

GC.Spread.Sheets.DataValidation Namespace

Overview

GC.Spread.Sheets.Events Namespace

Overview

GC.Spread.Sheets.Fill Namespace

Overview

GC.Spread.Sheets.Filter Namespace

Overview

GC.Spread.Sheets.Filter.RowFilterBase Namespace

Overview

GC.Spread.Sheets.FloatingObjects Namespace

Overview

GC.Spread.Sheets.FloatingObjects.FloatingObject Namespace

Overview

GC.Spread.Sheets.FormulaTextBox Namespace

Overview

GC.Spread.Sheets.LineBorder Namespace

Overview

GC.Spread.Sheets.Outlines Namespace

Overview

GC.Spread.Sheets.Outlines.OutlineInfo Namespace

Overview

GC.Spread.Sheets.Print Namespace

Overview

GC.Spread.Sheets.Range Namespace

Overview

GC.Spread.Sheets.Rect Namespace

Overview

GC.Spread.Sheets.Search Namespace

Overview

GC.Spread.Sheets.Search.SearchCondition Namespace

Overview

GC.Spread.Sheets.Search.SearchResult Namespace

Overview

GC.Spread.Sheets.Slicers Namespace

Overview

GC.Spread.Sheets.Sparklines Namespace

Overview

GC.Spread.Sheets.Sparklines.Sparkline Namespace

Overview

GC.Spread.Sheets.Sparklines.SparklineEx Namespace

Overview

GC.Spread.Sheets.Sparklines.SparklineGroup Namespace

Overview

GC.Spread.Sheets.Sparklines.SparklineSetting Namespace

Overview

GC.Spread.Sheets.Style Namespace

Overview

GC.Spread.Sheets.Tables Namespace

Overview

GC.Spread.Sheets.Tables.TableStyle Namespace

Overview

GC.Spread.Sheets.Tables.TableThemes Namespace

Overview

GC.Spread.Sheets.ThemeColors Namespace

Overview

GC.Spread.Sheets.Themes Namespace

Overview

GC.Spread.Sheets.Touch Namespace

Overview

GC.Spread.Sheets.Workbook Namespace

Overview

GC.Spread.Sheets.Worksheet Namespace

Overview

GC.Spread.Slicers Namespace

Overview

GC.Spread.Slicers.GeneralSlicerData Namespace

Overview

GCD
GeneralComparisonOperators Enumeration
GeneralFormatter type
GeneralSlicerData type
GEOMEAN
GESTEP
gestures
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
GROWTH
hAlign type
Handling Redistribution
HARMEAN
hbar
HBarSparkline type
header
HeaderAutoText Enumeration
height type
HEX2BIN
HEX2DEC
HEX2OCT
hide
HideRowFilter type
Hiding the Filter Indicator
Hiding the Headers
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
IList
IListSource
IMABS
image
image
image
ImageLayout Enumeration
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMDIV
ime
ImeMode Enumeration
imeMode type
IMEXP
IMLN
IMLOG10
IMLOG2
import
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
IMSIN
IMSQRT
IMSUB
IMSUM
indent
INDEX
INDIRECT
input
input
Input Mapping
input method editor
insert
Installing and Configuring the Excel Import and Export Component
INT
INTERCEPT
INTRATE
InvalidOperation type
InvalidOperationType Enumeration
IO type
IPMT
IRR
ISBLANK
ISERR
ISERROR
ISEVEN
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISO.CEILING
ISODD
ISPMT
ISREF
ISTEXT
ItemSlicer type
javascript
JavaScript Open and Save
JSON
JSON API Changes
JSON Import and Export
JSON Schema
Key Enumeration
keyboard
Keyboard Navigation
keys
keys
keys
knockout
Knockout, Breeze, and AngularJS
KURT
LabelAlignment Enumeration
labelOptions type
LabelVisibility Enumeration
LARGE
layout
LCM
LeaveCell type
LEFT
LeftColumnChanged type
LEN
level
level type
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
light3 type
light4 type
light5 type
light6 type
light7 type
light8 type
light9 type
line
line
line
line
LineBorder type
LineSparkline type
LINEST
LineStyle Enumeration
LN
load
lock
locked type
Locking Cells
LOG
LOG10
LOGEST
LogicalOperators Enumeration
LOGINV
LOGNORM.DIST
LOGNORM.INV
LOGNORMDIST
LOOKUP
LOWER
Managing Data
Managing the User Interface
map
marker
Markers and Points
MATCH
MAX
MAXA
maxArgs type
MDETERM
MDURATION
MEDIAN
Median type
Median type
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
Metro type
Metro type
MID
MIN
MINA
minArgs type
MINUTE
MINVERSE
MIRR
MMULT
MOD
mode
mode
MODE.MULT
MODE.SNGL
model type
module
Module type
Module type
MONTH
MonthSparkline type
move
moveFloatingObjects type
moveToNextCell type
moveToNextCellThenControl type
moveToPreviousCell type
moveToPreviousCellThenControl type
MROUND
MULTINOMIAL
multiple
Multiple Headers
N
NA
name
name
name type
name type
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
NumberFormat type
Object Inheritance
OCT2BIN
OCT2DEC
OCT2HEX
ODD
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
Office type
Office type
Office2007 type
Office2007 type
OFFSET
open
open
Opening and Saving Files
operators
Operators in a Formula
Operators with Dates and Times
Optional and Missing Arguments
options type
options type
options type
Opulent type
Opulent type
OR
Order of Precedence
Oriel type
Oriel type
Origin type
Origin type
Outline type
outlineColumn type
OutlineDirection Enumeration
OutlineInfo type
outlineRow type
Outlines type
OutlineState Enumeration
overflow
Padding type
Paper type
Paper type
PaperKind Enumeration
PaperSize type
parent type
parentName type
pareto
ParetoSparkline type
paste type
pasteFloatingObjects type
PDF Classes and Enumerations
PEARSON
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
PERCENTRANK
PERCENTRANK.EXC
PERCENTRANK.INC
permanent
PERMUT
PI
picture
picture
Picture and Floating Object API Changes
Picture type
PictureChanged type
pictures type
PictureSelectionChanged type
pie
PieSparkline type
pluggable
PMT
point
Point type
POISSON
POISSON.DIST
POWER
PPMT
Preventing Resizing
PRICE
PRICEDISC
PRICEMAT
print
Print API Changes
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
QuarterType Enumeration
QUARTILE
QUARTILE.EXC
QUARTILE.INC
QUOTIENT
R1C1 Notation
RADIANS
RAND
RANDBETWEEN
range
Range Grouping
Range type
Range type
RangeChanged type
RangeChangedAction Enumeration
RangeFiltered type
RangeFiltering type
RangeGroupStateChanged type
RangeGroupStateChanging type
RangeReferenceRelative Enumeration
RangeSorted type
RangeSorting type
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
REPT
resize
resize
resize
resizeColumn type
resizeFloatingObjects type
resizeRow type
ResizeZeroIndicator Enumeration
Resizing Columns and Rows
Resultant Error Values
RIGHT
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
ROW
Row and Column Settings Exported
Row and Column Settings Imported
Row Filter
row type
row type
row type
RowChanged type
rowCount type
rowCount type
rowEnd type
RowFilterBase type
RowHeader type
RowHeightChanged type
RowHeightChanging type
rowOutlines type
ROWS
rowStart type
RSQ
rule
rule
rule
rule
rule
rule
rule
rule
rule
rule
rules
RuleType Enumeration
Sample Code
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
schema
Scroll Bars
Scroll Bars
scrolling
search
search
Search API Changes
Search type
SearchCondition type
SearchFlags Enumeration
searchFlags type
searchFoundFlag type
SearchFoundFlags Enumeration
Searching
Searching Data
SearchOrder Enumeration
searchOrder type
SearchResult type
searchString type
searchTarget type
SECOND
Selection
Selection
selectionBottom type
SelectionChanged type
SelectionChanging 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
SERIESSUM
service
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 and Gridlines
Setting Cell Alignment and Indentation
Setting Cell Borders
Setting Cell Padding and Label Styles
Setting Cell Values
Setting Colors
Setting Conditional Formats
Setting Edit Mode Always
Setting Fixed or Frozen Rows and Columns
Setting Formulas in Cells
Setting Number Format with Leading Zeros
Setting Page Breaks when Printing
Setting Selection State when Editing Starts
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 type
Setting Visual Styles
settings
Sheet References in a Formula
Sheet Settings Exported
sheet type
SheetArea Enumeration
sheetArea type
sheetArea type
SheetNameChanged type
SheetNameChanging type
Sheets type
Sheets type
SheetTabClick type
SheetTabDoubleClick type
ShowResizeTip Enumeration
ShowScrollTip Enumeration
shrink
Shrink to Fit
shrinkToFit type
SIGN
SIN
SINH
size
SKEW
Slicer
Slicer API Changes
Slicer API Changes
Slicer type
SlicerAggregateType Enumeration
SlicerBorder type
SlicerChanged type
SlicerCollection type
Slicers type
Slicers type
Slicers type
SlicerStyle type
SlicerStyleInfo type
SlicerStyles type
SLN
SLOPE
SMALL
Solstice type
Solstice type
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
SparklineChanged type
SparklineEx type
SparklineGroup type
Sparklines
Sparklines
Sparklines type
SparklineSetting type
SparklineType Enumeration
sparklineType type
spread
spread

Overview

Spread Schema
Spread Settings Exported
Spread type
Spread.Sheets Designer
Spread.Sheets Designer Data Tab
Spread.Sheets Designer File Tab
Spread.Sheets Designer Formulas Tab
Spread.Sheets Designer Home Tab
Spread.Sheets Designer Insert and Design Tab
Spread.Sheets Designer Settings Tab
Spread.Sheets Designer View Tab
Spread.Sheets Documentation
SpreadSparkline type
SQRT
SQRTPI
stacked
StackedSparkline type
STANDARDIZE
start type
Starting and Using the Designer
startSheetIndex type
status
STDEV
STDEV.P
STDEV.S
STDEVA
STDEVP
STDEVPA
STEYX
StorageType Enumeration
structured
Structured References
style
Style API Changes
Style type
Style type
Styles
SUBSTITUTE
SUBTOTAL
SUM
SUMIF
SUMIFS
Summary of Conditional Formatting Types
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
SYD
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
TableFiltered type
TableFiltering type
TableManager type
TableRemoveOptions Enumeration
Tables
Tables type
Tables type
TableSlicerData type
TableStyle type
TableTheme type
TableThemes type
tabStop type
TabStrip
tag
TAN
TANH
TBILLEQ
TBILLPRICE
TBILLYIELD
TDIST
Technic type
Technic type
text
text
Text Open Flags
Text type
TextCompareType Enumeration
TextComparisonOperators Enumeration
textDecoration type
textDecoration type
TextDecorationType Enumeration
textIndent type
theme
theme
Theme API Changes
Theme type
ThemeColors type
themeFont type
Themes
Themes type
TIME
TIMEVALUE
TINV
TODAY
toolbar
tooltip
Tooltips
Top10ConditionType Enumeration
top10rule
TopRowChanged type
touch
touch
touch
Touch API Changes
touch support
Touch type
TouchToolStrip type
TouchToolStrip type
TouchToolStripItem type
TouchToolStripOpening type
TouchToolStripSeparator type
trailing
TRANSPOSE
Trek type
Trek type
TREND
TRIM
TRIMMEAN
TRUE
TRUNC
TTEST
TYPE
type type
type type
typeName type
typeName type
typeName type
typeName type
typeName type
typeName type
typescript
typescript
underline
Understanding Conditional Formats
Understanding Printing
Understanding Sparklines
Understanding Spread.Sheets Designer Interface Menus
Understanding the Column Element
Understanding the Product
Understanding the Sheet Element
Understanding the Spread.Sheets Designer Interface
Understanding the Spread.Sheets 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
unique
UPPER
Urban type
Urban type
User Interface API Changes
UserFormulaEntered type
UserZooming type
Using a Bootstrap Theme
Using a Slicer
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 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 IME Mode
Using Input Mapping
Using JSON Schema with Spread.Sheets
Using Keyboard Navigation
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 Spread.Sheets and Spread.Views
Using Spread.Sheets Libraries
Using Spread.Sheets with Angular 2
Using Spread.Sheets with AngularJS
Using Spread.Sheets with Breeze
Using Spread.Sheets with Knockout
Using Spread.Sheets with the Wijmo DataView
Using Structured Reference Formulas
Using Subtotals
Using Tables
Using the Average Rule
Using the Button Clicked Event with Cells
Using the Cell Elements
Using the Cell Value Rule
Using the Data Bar Rule
Using the Date Occurring Rule
Using the Default Spread.Sheets Theme
Using the Duplicate Rule
Using the Excel Import and Export Component in a Web Application
Using the Excel Import and Export Component in a Windows Forms Application
Using the Excel Import and Export Service
Using the Excel Theme
Using the Formula Rule
Using the Formula Text Box
Using the Formula Text Box as a Control
Using the Gc-spread-sheets Element
Using the Icon Set Rule
Using the Scale Rule
Using the Server-side Excel Import and Export Component
Using the Sheet and Sheets Elements
Using the Specific Text Rule
Using the Spread.Sheets Designer
Using the Spread.Sheets Designer Template with Cell Binding
Using the Style Element
Using the Tab Strip
Using the Top 10 Rule
Using the Unique Rule
Using the Validator 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 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
ValidationError type
validator type
vAlign type
VALUE
value type
ValueChanged type
VAR
VAR.P
VAR.S
VARA
vari
VariSparkline type
VARP
VARPA
vbar
VBarSparkline type
VDB
VerticalAlign Enumeration
VerticalPosition Enumeration
Verve type
Verve type
view
VisualState Enumeration
VLOOKUP
volatile
Volatile Functions
Watermark
Watermark
watermark type
WEEKDAY
WEEKNUM
WEIBULL
WEIBULL.DIST
What is a Formula
wheel
width type
wildcard
Wildcard Characters in a Formula
winloss
winloss
winloss
WinlossSparkline type
wordwrap
wordWrap type
Workbook API Changes
Workbook Settings Imported
Workbook type
WORKDAY
WORKDAY.INTL
Working in the Designer
Working with Cell Types
Working with Selections
Worksheet API Changes
Worksheet Settings Imported
Worksheet type
x type
XIRR
XNPV
y type
YEAR
YEARFRAC
YearSparkline type
YIELD
YIELDDISC
YIELDMAT
Z.TEST
Zoom
Zoom
Zoom
zoom type
ZTEST