SpreadJS Documentation
Developer's Guide
Getting Started
End-User License Agreement
Product Requirements
Handling Redistribution
Adding the Client Widget to a Browser Page
Using SpreadJS and Spread.Views
UMD Support
Using SpreadJS Libraries
Using TypeScript
Using Previous Code with the Current Version
API Changes
Workbook API Changes
Worksheet API Changes
Style API Changes
Actions and Key API Changes
User Interface API Changes
JSON API Changes
Sparkline API Changes
Print API Changes
Grouping API Changes
Slicer API Changes
Search API Changes
Cell API Changes
Data Binding API Changes
Filter API Changes
Picture and Floating Object API Changes
Fill API Changes
Comment API Changes
Conditional Formatting API Changes
Data Validation API Changes
Table API Changes
Touch API Changes
Calculation API Changes
Culture API Changes
Formatter API Changes
Slicer API Changes
Theme API Changes
Getting Technical Support
Understanding the Product
Product Overview
Object Inheritance
Feature Overview
AutoFit
Background Image
Barcodes
Borders and Gridlines
Cell Alignment, Indentation, and Text Decoration
Cell Comment
Cell Format
Cell Overflow
Cell Span
Cell Tags
Cell Types
Chart
Clipboard Operations
Column and Row Resize
Conditional Formatting
Context Menu
CSV Import and Export
Culture Settings
Data Binding
Data Validation
Drag and Move
Drag Fill
Drag and Merge
Edit Mode Always
Excel Import and Export
Floating Objects
Formulas
Frozen Columns and Rows
Hit Testing
Input Mapping
JavaScript Open and Save
JSON Import and Export
JSON Schema
Keyboard Navigation
JavaScript Frameworks
Multiple Headers
Precision Selection
Printing
Protect and Cell Locking
Quote Prefix
Range Grouping
Rich Text Format
Row Filter
Scroll Bars
Searching
Shapes
Sheet Area Offset
Shrink to Fit
Slicer
Sparklines
Sorting
SpreadJS Designer
Structured References
Styles
Tables
TabStrip
Themes
Tooltips
TypeScript
Undo and Redo
Watermark
Zoom
Best Practices
Using suspendPaint and resumePaint
Setting Large Amounts of Formulas
Setting Large Amounts of Data
Avoid Using Volatile Functions
Using suspendEvent and resumeEvent
Using suspendDirty and resumeDirty
Customizing the Appearance
Setting Borders, Gridlines and Diagonal Lines
Setting Colors
Adding a Background Image
Adding a Watermark
Setting Cell Padding and Label Styles
Setting Cell Alignment and Indentation
Setting Text Decoration
Setting Vertical Text Direction in a Cell
Setting Rich Text in a Cell
Allowing Cell Overflow
Creating Cell Spans
Setting Styles and Themes
Setting Styles
Using Themes
Using Custom Themes from ThemeRoller
Using the Default SpreadJS Theme
Using the Excel Theme
Using a Bootstrap Theme
Setting Sheet Area Offset
Managing the User Interface
Using Automatic Fit
Working with Cell Types
Setting a Button Cell
Setting a Check Box Cell
Setting a Combo Box Cell
Setting a Custom Cell
Setting a Hyperlink Cell
Set the Text Indentation
Set the Word Wrap Formatting
Handle Callback action on a Hyperlink Cell
Wrap Text In Cell
Using Clipboard Operations
Copying and Pasting Styles
Adding a Comment to a Cell
Using Data Validation
Auto Fill Data
Using Drag Fill
Auto Fill Dates
Auto Fill Strings
Auto Fill Lists
Using Double-click for Auto Fill
Using Drag and Move
Allow Merging Cells via Mouse Drag
Using Edit Mode Always
Using Rapid Input Mode
Using Row Filtering
Filtering Rows
Customizing the Row Filter Actions
Freezing Columns and Rows
Using Range Grouping
Customizing the Range Groups
Using Input Mapping
Using Keyboard Navigation
Using Protect and Cell Locking
Creating Multiple Headers
Resizing Columns and Rows
Working with Selections
Using Shrink to Fit
Using the Context Menu
Using the Tab Strip
Using Undo and Redo
Using Hit Testing
Outline Columns
Using Formulas
Using Built-In Formulas
Allowing Users to Enter Formulas
Creating Custom Names
Creating Custom Formulas
Using the Formula Text Box
Using the Formula Text Box as a Control
Creating an Array Formula
Using Asynchronous Functions
Using Language Package
Available CalcEngine Language Packages For SpreadJS
Creating and Using a Custom Language Package
Allowing Zooming
Displaying Tooltips
Using Tables
Creating Tables
Setting Table Styles
Binding Tables
Using Structured Reference Formulas
Using a Slicer
Creating a Custom Slicer
Creating an Item Slicer
Creating a Table Slicer
Setting the Table Slicer Styles
Creating a Table Slicer with the SpreadJS Designer
Using Scroll Bars
Using IME Mode
Using the Status Bar
Working with the Quote Prefix
Managing Data
Adding a Tag to a Cell
Binding to Data
Binding Cells
Using the SpreadJS Designer Template with Cell Binding
Formatting Cells
Basic Format
Accounting Format
Number and Date Format
Getting the Dirty Status
Understanding Printing
Printing Sheets
Setting Page Breaks when Printing
Display Preview Line for Print
Get Page Information
Print Background Image As Watermark
Importing and Exporting to JSON
Importing and Exporting CSV Files
Saving and Loading JavaScript Files
Using JSON Schema with SpreadJS
SpreadJS Spread Schema
Using Serialization
Searching Data
Setting the Culture
Setting the Era Format
Creating a Custom Culture
Sorting Data
Importing and Exporting Excel Files on the Client-Side
Exporting to PDF
Custom PDF Export
Use Custom Font for PDF Export
Managing Data Visualization and Objects
Understanding Chart
Configuring Chart Elements
Configuring Chart Title, Chart Area and Plot Area
Configuring Legends
Configuring Series
Configuring Axes
Configuring Data Label
Configuring Data Markers
Configuring Gridlines
Working with Chart Types
Creating Column Chart
Creating Line Chart
Creating Pie Chart
Creating Bar Chart
Creating Area Chart
Creating Scatter Chart
Creating Stock Chart
Creating Combo Chart
Creating Radar Chart
Creating Sunburst Chart
Creating Treemap Chart
Using Animation in Charts
Set Chart Color with Transparency
Understanding Sparklines
Creating Column, Line, and Winloss Sparklines Using Methods
Markers and Points
Horizontal and Vertical Axes
Creating Column, Line, and Winloss Sparklines with Formulas
Creating an Area Sparkline
Creating a Pie Sparkline
Creating a Scatter Sparkline
Creating a Bullet Sparkline
Creating a Spread Sparkline
Creating a Stacked Sparkline
Creating an Hbar Sparkline
Creating a Vbar Sparkline
Creating a Box Plot Sparkline
Creating a Vari Sparkline
Creating a Cascade Sparkline
Creating a Pareto Sparkline
Creating a Month Sparkline
Creating a Year Sparkline
Creating a Custom Sparkline
Understanding Shapes
Adding Built-In Shapes
Adding Connector Shapes
Adding Group Shapes
Adding Shapes with Formulas
Adding Custom Shapes
Creating Floating Pictures
Creating Custom Floating Objects
Using Conditional Formatting
Summary of Conditional Formatting Types
Understanding Conditional Formats
Using the Average Rule
Using the Cell Value Rule
Using the Data Bar Rule
Using the Date Occurring Rule
Using the Duplicate Rule
Using the Formula Rule
Using the Icon Set Rule
Using the Scale Rule
Using the Specific Text Rule
Using the Top 10 Rule
Using the Unique Rule
Working with Barcodes
Setting QRCode
Setting EAN-13
Setting EAN-8
Setting Codabar
Setting Code39
Setting Code93
Setting Code128
Setting GS1_128
Setting Code49
Setting PDF417
Setting DataMatrix
Using Touch Support with the Widget
Understanding Touch Support
Understanding Touch Gestures
Using Touch Support
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 when Resizing Columns or Rows
Using Touch Support when Scrolling
Using Touch Support with Selections
Using Touch Support with the Tab Strip
Using Touch Support with the Touch Toolbar
Using Touch Support when Zooming
Working with JavaScript Frameworks
Using SpreadJS with AngularJS
Using the Gc-spread-sheets Element
Using the Sheet and Sheets Elements
Using Column, Columns, and Group Elements
Using the Style Element
Using the Cell Elements
Using the Validator Element
Using SpreadJS with Angular
Understanding the Tag Hierarchy
Understanding the Sheet Element
Understanding the Worksheet Element
Understanding the Column Element
Using SpreadJS with Breeze
Using SpreadJS with Knockout
Using SpreadJS with React
Using the Spread-Sheets Element
Using the Worksheet Element
Using the Column Element
Using the Chart Element
Using the Excel IO Element
Using the Shape Element
Using SpreadJS with Vue
Using the gc-spread-sheets Element
Using the gc-worksheet Element
Using the gc-column Element
Using the SpreadJS Designer
Starting and Using the Designer
Opening and Saving Files
Working in the Designer
Understanding the SpreadJS Designer Interface
Understanding the SpreadJS Designer Tabs
SpreadJS Designer File Tab
SpreadJS Designer Home Tab
SpreadJS Designer Insert and Design Tab
SpreadJS Designer Formulas Tab
SpreadJS Designer Data Tab
SpreadJS Designer View Tab
SpreadJS Designer Settings Tab
Understanding SpreadJS Designer Interface Menus
Understanding SpreadJS Designer Status Bar
Formula Reference
Formula Overview
What is a Formula
Sample Formula
Cell References in a Formula
Sheet References in a Formula
Operators in a Formula
Order of Precedence
Operators with Dates and Times
Wildcard Characters in a Formula
Functions in a Formula
Database Functions
Date and Time Functions
Complex Numbers
Day Count Basis
Optional and Missing Arguments
Volatile Functions
Arrays in a Formula
Resultant Error Values
Formula Functions
ABS
ACCRINT
ACCRINTM
ACOS
ACOSH
ACOT
ACOTH
ADDRESS
AMORDEGRC
AMORLINC
AND
ARABIC
AREAS
ASIN
ASINH
ATAN
ATAN2
ATANH
AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
BAHTTEXT
BASE
BESSELI
BESSELJ
BESSELK
BESSELY
BETADIST
BETA.DIST
BETAINV
BETA.INV
BIN2DEC
BIN2HEX
BIN2OCT
BINOMDIST
BINOM.DIST
BINOM.DIST.RANGE
BINOM.INV
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
CEILING
CEILING.MATH
CEILING.PRECISE
CHAR
CHIDIST
CHIINV
CHISQ.DIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
CHISQ.TEST
CHITEST
CHOOSE
CLEAN
CODE
COLUMN
COLUMNS
COMBIN
COMBINA
COMPLEX
CONCAT
CONCATENATE
CONFIDENCE
CONFIDENCE.NORM
CONFIDENCE.T
CONVERT
CORREL
COS
COSH
COT
COTH
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
COVAR
COVARIANCE.P
COVARIANCE.S
CRITBINOM
CSC
CSCH
CUMIPMT
CUMPRINC
DATE
DATEDIF
DATEVALUE
DAVERAGE
DAY
DAYS
DAYS360
DB
DCOUNT
DCOUNTA
DDB
DEC2BIN
DEC2HEX
DEC2OCT
DECIMAL
DEGREES
DELTA
DEVSQ
DGET
DISC
DMAX
DMIN
DOLLAR
DOLLARDE
DOLLARFR
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DURATION
DVAR
DVARP
EDATE
EFFECT
ENCODEURL
EOMONTH
ERF
ERF.PRECISE
ERFC
ERFC.PRECISE
ERROR.TYPE
EURO
EUROCONVERT
EVEN
EXACT
EXP
EXPONDIST
EXPON.DIST
FACT
FACTDOUBLE
FALSE
FDIST
F.DIST
F.DIST.RT
FIND
FINDB
FINV
F.INV
F.INV.RT
FISHER
FISHERINV
FIXED
FLOOR
FLOOR.MATH
FLOOR.PRECISE
FORECAST
FORMULATEXT
FREQUENCY
FTEST
F.TEST
FV
FVSCHEDULE
GAMMA
GAMMADIST
GAMMA.DIST
GAMMAINV
GAMMA.INV
GAMMALN
GAMMALN.PRECISE
GAUSS
GCD
GEOMEAN
GESTEP
GROWTH
HARMEAN
HEX2BIN
HEX2DEC
HEX2OCT
HLOOKUP
HOUR
HYPGEOMDIST
HYPGEOM.DIST
IF
IFERROR
IFNA
IFS
IMABS
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMCOSH
IMCOT
IMCSC
IMCSCH
IMDIV
IMEXP
IMLN
IMLOG2
IMLOG10
IMPOWER
IMPRODUCT
IMREAL
IMSEC
IMSECH
IMSIN
IMSINH
IMSQRT
IMSUB
IMSUM
IMTAN
INDEX
INDIRECT
INT
INTERCEPT
INTRATE
IPMT
IRR
ISBLANK
ISERR
ISERROR
ISEVEN
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISO.CEILING
ISODD
ISOWEEKNUM
ISPMT
ISREF
ISTEXT
KURT
LARGE
LCM
LEFT
LEFTB
LEN
LENB
LINEST
LN
LOG
LOG10
LOGEST
LOGINV
LOGNORMDIST
LOGNORM.DIST
LOGNORM.INV
LOOKUP
LOWER
MATCH
MAX
MAXA
MAXIFS
MDETERM
MDURATION
MEDIAN
MID
MIDB
MIN
MINA
MINIFS
MINUTE
MINVERSE
MIRR
MMULT
MOD
MODE
MODE.MULT
MODE.SNGL
MONTH
MROUND
MULTINOMIAL
N
NA
NEGBINOMDIST
NEGBINOM.DIST
NETWORKDAYS
NETWORKDAYS.INTL
NOMINAL
NORMDIST
NORM.DIST
NORMINV
NORM.INV
NORMSDIST
NORM.S.DIST
NORMSINV
NORM.S.INV
NOT
NOW
NPER
NPV
OCT2BIN
OCT2DEC
OCT2HEX
ODD
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
OFFSET
OR
PDURATION
PEARSON
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
PERCENTRANK
PERCENTRANK.EXC
PERCENTRANK.INC
PERMUT
PERMUTATIONA
PHI
PI
PMT
POISSON
POISSON.DIST
POWER
PPMT
PRICE
PRICEDISC
PRICEMAT
PROB
PRODUCT
PROPER
PV
QUARTILE
QUARTILE.EXC
QUARTILE.INC
QUOTIENT
RADIANS
RAND
RANDBETWEEN
RANK
RANK.AVG
RANK.EQ
RATE
RECEIVED
REFRESH
REPLACE
REPLACEB
REPT
RIGHT
RIGHTB
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
ROW
ROWS
RRI
RSQ
SEARCH
SEARCHB
SEC
SECH
SECOND
SERIESSUM
SIGN
SIN
SINH
SKEW
SKEW.P
SLN
SLOPE
SMALL
SQRT
SQRTPI
STANDARDIZE
STDEV
STDEVA
STDEVP
STDEV.P
STDEV.S
STDEVPA
STEYX
SUBSTITUTE
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
SWITCH
SYD
T
TAN
TANH
TBILLEQ
TBILLPRICE
TBILLYIELD
TDIST
T.DIST
T.DIST.2T
T.DIST.RT
TEXT
TEXTJOIN
TIME
TIMEVALUE
TINV
T.INV
T.INV.2T
TODAY
TRANSPOSE
TREND
TRIM
TRIMMEAN
TRUE
TRUNC
TTEST
T.TEST
TYPE
UNICHAR
UNICODE
UPPER
VALUE
VAR
VARA
VARP
VAR.P
VARPA
VAR.S
VDB
VLOOKUP
WEEKDAY
WEEKNUM
WEIBULL
WEIBULL.DIST
WORKDAY
WORKDAY.INTL
XIRR
XNPV
XOR
YEAR
YEARFRAC
YIELD
YIELDDISC
YIELDMAT
ZTEST
Z.TEST
Import and Export Reference
Excel-Formatted Files Import
Workbook Settings Imported
Worksheet Settings Imported
Row and Column Settings Imported
Cell Settings Imported
Formula Settings Imported
Print Settings Imported
Excel-Formatted Files Export
Spread Settings Exported
Sheet Settings Exported
Row and Column Settings Exported
Cell Settings Exported
Print Settings Exported
Sample Code
Sample Code for the Widget
Setting Visual Styles
Setting a Widget Border
Allowing Cell Overflow
Setting Edit Mode Always
Setting Selection State when Editing Starts
Sample Code for the Sheet
Changing the Grid Line Appearance
Setting the Number of Sheets
Changing the Sheet Names
Setting the Default Style
Adding a Sheet
Deleting a Sheet
Sample Code for Rows and Columns
Setting the Number of Rows and Columns
Changing Row Height and Column Width
Changing the Header Size
Customizing the Headers
Setting the Header Color
Hiding the Headers
Spanning or Merging Header Cells
Creating Multiple Rows and Columns in the Headers
Setting Fixed or Frozen Rows and Columns
Adding Columns and Rows
Deleting Columns and Rows
Creating and Removing Selections
Preventing Resizing
Getting the Displayed Cell Index
Setting the Top Row and Column
Sample Code for Cells
Setting the Cell Color
Setting Alignment and Indentation
Setting Cell Borders
Setting a Background Image
Spanning or Merging Cells
Locking Cells
Getting the Active Cell Index
Changing the Active Cell Backcolor
Setting Cell Values
Getting Cell Values
Setting the Active Cell
Setting the Active Cell at a Specific Location
Allowing Drag and Drop
Creating Multiple Selections
Getting Selected Ranges
Setting Conditional Formats
Getting Cell Index from Mouse Click
Getting Header Cell Index from Mouse Click
Getting the Cell Position and Size
Using the Button Clicked Event with Cells
Sample Code for Cell References
Convert Expression To Formula
Convert Formula To Expression
Convert Formula To Ranges
Evaluate Formula
Using the Goal Seek Method
Sample Code for Data Binding
Binding to a Table
Binding to Columns
Adding Rows
Adding Unbound Columns
Sample Code for Sorting
Sorting a Column
Sorting Row Ranges with Sort Conditions
Sample Code for Row Filtering
Creating Row Filters
Getting the Row Filter Status
Getting the Row Filter Results
Filtering a Row with Code
Hiding the Filter Indicator
Creating a Custom Filter
Sample Code for Range Grouping
Adding and Deleting Outlines
Expanding and Collapsing Outlines
Sample Code for Keyboard and Input Maps
Deactivating the Default Input Map
Changing the Default Input Map
Creating a Custom Action Map
Sample Code for Formulas
Allowing Users to Enter Formulas
Setting Formulas in Cells
Using Cross Sheet References
Using Subtotals
Sample Code Using the Clipboard
Deactivating Clipboard Keys
Deactivating Pasting
Using Code to Copy and Paste
Sample Code for Frequently Used Events
Using Click Events
Using Events when Moving a Cell
Using Events when Edit Mode Starts or Stops
Using Events when Data Changes
Using Events when the Top Row or Column Changes
Using Events when the Sheet Tab Changes
Using Events when Dragging and Moving
API Documentation
SpreadJS
Overview
Namespaces
GC.Spread.CalcEngine Namespace
Overview
Types
AsyncEvaluateContext
Overview
AsyncEvaluateContext Constructor
Methods
setAsyncResult
CalcError
Overview
CalcError Constructor
Methods
parse
toString
Expression
Overview
Expression Constructor
Fields
type
Functions
Overview
Methods
AsyncFunction
defineGlobalCustomFunction
findGlobalFunction
Function
removeGlobalFunction
Fields
AsyncFunctionEvaluateMode
LanguagePackages
Overview
Methods
languagePackages
Enumerations
ExpressionType
GC.Spread.CalcEngine.Expression Namespace
Overview
Types
type
Overview
GC.Spread.CalcEngine.Functions Namespace
Overview
Types
AsyncFunction
Overview
AsyncFunction Constructor
Methods
defaultValue
evaluateAsync
evaluateMode
interval
Function
Overview
Function Constructor
Methods
acceptsArray
acceptsError
acceptsMissingArgument
acceptsReference
description
evaluate
findBranchArgument
findTestArgument
isBranch
isContextSensitive
isVolatile
Fields
maxArgs
minArgs
name
typeName
Enumerations
AsyncFunctionEvaluateMode
GC.Spread.Commands Namespace
Overview
Types
CommandManager
Overview
CommandManager Constructor
Methods
execute
register
setShortcutKey
UndoManager
Overview
UndoManager Constructor
Methods
canRedo
canUndo
clear
redo
undo
Enumerations
Key
GC.Spread.Common Namespace
Overview
Types
CultureInfo
Overview
CultureInfo Constructor
Fields
DateTimeFormat
NumberFormat
CultureManager
Overview
CultureManager Constructor
Methods
addCultureInfo
culture
getCultureInfo
getLanguage
GC.Spread.Excel Namespace
Overview
Types
IO
Overview
IO Constructor
Methods
open
save
Fields
ErrorCode
GC.Spread.Excel.IO Namespace
Overview
Enumerations
ErrorCode
GC.Spread.Formatter Namespace
Overview
Types
FormatterBase
Overview
FormatterBase Constructor
Methods
format
fromJSON
parse
toJSON
Fields
typeName
GeneralFormatter
Overview
GeneralFormatter Constructor
Methods
format
formatString
parse
GC.Spread.Sheets Namespace
Overview
Types
Barcode
Overview
Methods
Codabar
Code128
Code39
Code49
Code93
DataMatrix
EAN13
EAN8
GS1_128
PDF417
QRCode
Bindings
Overview
Methods
CellBindingSource
CalcEngine
Overview
Methods
evaluateFormula
expressionToFormula
formulaToExpression
formulaToRanges
goalSeek
rangesToFormula
rangeToFormula
Fields
RangeReferenceRelative
CellRange
Overview
CellRange Constructor
Methods
backColor
backgroundImage
backgroundImageLayout
bindingPath
borderBottom
borderLeft
borderRight
borderTop
cellPadding
cellType
clear
comment
diagonalDown
diagonalUp
font
foreColor
formatter
formula
hAlign
height
imeMode
isVerticalText
labelOptions
locked
quotePrefix
resizable
setBorder
shrinkToFit
tabStop
tag
text
textDecoration
textIndent
themeFont
validator
vAlign
value
visible
watermark
width
wordWrap
Fields
col
colCount
row
rowCount
sheet
sheetArea
CellTypes
Overview
Methods
Base
Button
CheckBox
ColumnHeader
ComboBox
Corner
HyperLink
RowHeader
Text
Fields
CheckBoxTextAlign
EditorType
EditorValueType
HyperLinkTargetType
Charts
Overview
Methods
Chart
ChartCollection
DataPoints
SeriesCollection
Fields
AxisGroup
ChartType
DataLabelPosition
LegendPosition
LineType
RowCol
SymbolShape
TickLabelPosition
TickMark
ColorScheme
Overview
ColorScheme Constructor
Methods
accent1
accent2
accent3
accent4
accent5
accent6
background1
background2
followedHyperlink
getColor
hyperlink
name
textColor1
textColor2
Commands
Overview
Methods
endTransaction
startTransaction
undoTransaction
Fields
autoFitColumn
autoFitRow
cancelInput
changeFormulaReference
clear
clearAndEditing
clearValues
clipboardPaste
commitArrayFormula
commitInputNavigationDown
commitInputNavigationUp
copy
cut
deleteFloatingObjects
dragCopyFloatingObjects
dragDrop
editCell
expandColumnOutline
expandColumnOutlineForLevel
expandRowOutline
expandRowOutlineForLevel
fill
moveFloatingObjects
moveToNextCell
moveToNextCellThenControl
moveToPreviousCell
moveToPreviousCellThenControl
navigationBottom
navigationDown
navigationEnd
navigationEnd2
navigationFirst
navigationHome
navigationHome2
navigationLast
navigationLeft
navigationNextSheet
navigationPageDown
navigationPageUp
navigationPreviousSheet
navigationRight
navigationTop
navigationUp
outlineColumn
outlineRow
paste
pasteFloatingObjects
redo
removeColumnOutline
removeRowOutline
renameSheet
resizeColumn
resizeFloatingObjects
resizeRow
selectionBottom
selectionDown
selectionEnd
selectionFirst
selectionHome
selectionLast
selectionLeft
selectionPageDown
selectionPageUp
selectionRight
selectionTop
selectionUp
selectNextControl
selectPreviousControl
undo
zoom
Comments
Overview
Methods
Comment
CommentManager
Padding
Fields
CommentState
DisplayMode
ConditionalFormatting
Overview
Methods
Condition
ConditionalFormats
ConditionRuleBase
DataBarRule
IconCriterion
IconSetRule
NormalConditionRule
ScaleRule
ScaleValue
Fields
AverageConditionType
BarDirection
ColorCompareType
ComparisonOperators
ConditionType
CustomValueType
DataBarAxisPosition
DateCompareType
DateOccurringType
GeneralComparisonOperators
IconSetType
IconValueType
LogicalOperators
QuarterType
RuleType
ScaleValueType
TextCompareType
TextComparisonOperators
Top10ConditionType
ContextMenu
Overview
Methods
ContextMenu
MenuView
DataValidation
Overview
Methods
createDateValidator
createFormulaListValidator
createFormulaValidator
createListValidator
createNumberValidator
createTextLengthValidator
DefaultDataValidator
Fields
CriteriaType
DataValidationResult
ErrorStyle
HighlightPosition
HighlightType
Events
Overview
Events Constructor
Events
ActiveSheetChanged
ActiveSheetChanging
BeforePrint
ButtonClicked
CellChanged
CellClick
CellDoubleClick
ClipboardChanged
ClipboardChanging
ClipboardPasted
ClipboardPasting
ColumnChanged
ColumnWidthChanged
ColumnWidthChanging
CommentChanged
CommentRemoved
CommentRemoving
DragDropBlock
DragDropBlockCompleted
DragFillBlock
DragFillBlockCompleted
DragMerged
DragMerging
EditChange
EditEnded
EditEnding
EditorStatusChanged
EditStarting
EnterCell
FloatingObjectChanged
FloatingObjectLoaded
FloatingObjectRemoved
FloatingObjectRemoving
FloatingObjectSelectionChanged
InvalidOperation
LeaveCell
LeftColumnChanged
OutlineColumnCheckStatusChanged
PictureChanged
PictureSelectionChanged
RangeChanged
RangeFilterCleared
RangeFilterClearing
RangeFiltered
RangeFiltering
RangeGroupStateChanged
RangeGroupStateChanging
RangeSorted
RangeSorting
RowChanged
RowHeightChanged
RowHeightChanging
SelectionChanged
SelectionChanging
ShapeChanged
ShapeRemoved
ShapeRemoving
ShapeSelectionChanged
SheetMoved
SheetMoving
SheetNameChanged
SheetNameChanging
SheetTabClick
SheetTabDoubleClick
SlicerChanged
SparklineChanged
TableFilterCleared
TableFilterClearing
TableFiltered
TableFiltering
TopRowChanged
TouchToolStripOpening
UserFormulaEntered
UserZooming
ValidationError
ValueChanged
Fill
Overview
Fields
AutoFillType
FillDateUnit
FillDirection
FillSeries
FillType
Filter
Overview
Methods
HideRowFilter
RowFilterBase
Fields
FilterActionType
FloatingObjects
Overview
Methods
FloatingObject
FloatingObjectCollection
Picture
FormulaTextBox
Overview
Methods
FormulaTextBox
LicenseKey
Overview
LineBorder
Overview
LineBorder Constructor
Fields
color
style
NameInfo
Overview
NameInfo Constructor
Methods
getColumn
getComment
getExpression
getName
getRow
OutlineColumn
Overview
Methods
OutlineColumn
Outlines
Overview
Methods
Outline
OutlineInfo
Fields
OutlineDirection
OutlineState
PDF
Overview
Fields
PDFFontsManager
Point
Overview
Point Constructor
Methods
clone
Print
Overview
Methods
PaperSize
PrintInfo
Fields
PaperKind
PrintCentering
PrintPageOrder
PrintPageOrientation
PrintVisibilityType
Range
Overview
Range Constructor
Methods
contains
containsRange
equals
getIntersect
intersect
offset
union
Fields
col
colCount
row
rowCount
Rect
Overview
Rect Constructor
Methods
contains
getIntersectRect
intersect
intersectRect
Fields
height
width
x
y
Search
Overview
Methods
SearchCondition
SearchResult
Fields
SearchFlags
SearchFoundFlags
SearchOrder
Shapes
Overview
Methods
ConnectorShape
GroupShape
Shape
ShapeBase
ShapeCollection
ShapeStyle
Fields
ArrowheadLength
ArrowheadStyle
ArrowheadWidth
AutoShapeType
ConnectorType
LineCapStyle
LineJoinStyle
PresetLineDashStyle
ShapeFillType
Slicers
Overview
Methods
ItemSlicer
Slicer
SlicerBorder
SlicerCollection
SlicerStyle
SlicerStyleInfo
SlicerStyles
TableSlicerData
Sparklines
Overview
Methods
AreaSparkline
BoxPlotSparkline
BulletSparkline
CascadeSparkline
ColumnSparkline
HBarSparkline
LineSparkline
MonthSparkline
ParetoSparkline
PieSparkline
ScatterSparkline
Sparkline
SparklineEx
SparklineGroup
SparklineSetting
SpreadSparkline
StackedSparkline
VariSparkline
VBarSparkline
WinlossSparkline
YearSparkline
Fields
DataOrientation
EmptyValueStyle
SparklineAxisMinMax
SparklineType
StatusBar
Overview
Methods
StatusBar
StatusItem
Style
Overview
Style Constructor
Methods
clone
Fields
backColor
backgroundImage
backgroundImageLayout
borderBottom
borderLeft
borderRight
borderTop
cellPadding
cellType
diagonalDown
diagonalUp
font
foreColor
formatter
hAlign
imeMode
isVerticalText
labelOptions
locked
name
parentName
shrinkToFit
tabStop
textDecoration
textIndent
themeFont
vAlign
watermark
wordWrap
Tables
Overview
Methods
Table
TableColumn
TableManager
TableStyle
TableTheme
TableThemes
Fields
TableRemoveOptions
Theme
Overview
Theme Constructor
Methods
bodyFont
colors
headerFont
name
ThemeColors
Overview
ThemeColors Constructor
Fields
Apex
Aspect
Civic
Concourse
Default
Equity
Flow
Foundry
Median
Metro
Module
Office
Office2007
Opulent
Oriel
Origin
Paper
Solstice
Technic
Trek
Urban
Verve
Themes
Overview
Themes Constructor
Fields
Apex
Aspect
Civic
Concourse
Default
Equity
Flow
Foundry
Median
Metro
Module
Office
Office2007
Opulent
Oriel
Origin
Paper
Solstice
Technic
Trek
Urban
Verve
Touch
Overview
Methods
TouchToolStrip
TouchToolStripItem
TouchToolStripSeparator
Workbook
Overview
Workbook Constructor
Methods
addCustomFunction
addCustomName
addNamedStyle
addSheet
addSparklineEx
bind
clearCustomFunctions
clearCustomNames
clearSheets
commandManager
destroy
focus
fromJSON
getActiveSheet
getActiveSheetIndex
getCustomFunction
getCustomName
getCustomNames
getHost
getNamedStyle
getNamedStyles
getSheet
getSheetCount
getSheetFromName
getSheetIndex
hitTest
invalidateLayout
isPaintSuspended
nextControl
pageInfo
previousControl
print
refresh
removeCustomFunction
removeCustomName
removeNamedStyle
removeSheet
removeSparklineEx
repaint
resumeCalcService
resumeEvent
resumePaint
savePDF
search
setActiveSheet
setActiveSheetIndex
setSheetCount
startSheetIndex
suspendCalcService
suspendEvent
suspendPaint
toJSON
unbind
unbindAll
undoManager
Fields
contextMenu
name
options
sheets
touchToolStrip
Worksheet
Overview
Worksheet Constructor
Methods
addColumns
addCustomFunction
addCustomName
addNamedStyle
addRows
addSelection
addSpan
autoFitColumn
autoFitRow
bind
bindColumn
bindColumns
clear
clearCustomFunctions
clearCustomNames
clearPendingChanges
clearSelection
copyTo
currentTheme
deleteColumns
deleteRows
editorStatus
endEdit
fillAuto
fromJSON
frozenColumnCount
frozenRowCount
frozenTrailingColumnCount
frozenTrailingRowCount
getActiveColumnIndex
getActiveRowIndex
getActualStyle
getArray
getBindingPath
getCell
getCellRect
getCellType
getColumnCount
getColumnPageBreak
getColumnResizable
getColumnVisible
getColumnWidth
getCsv
getCustomFunction
getCustomName
getCustomNames
getDataColumnName
getDataItem
getDataSource
getDataValidator
getDefaultStyle
getDeletedRows
getDirtyCells
getDirtyRows
getFormatter
getFormula
getFormulaInformation
getInsertRows
getNamedStyle
getNamedStyles
getParent
getRange
getRowCount
getRowHeight
getRowPageBreak
getRowResizable
getRowVisible
getSelections
getSpans
getSparkline
getStyle
getStyleName
getTag
getText
getValue
getViewportBottomRow
getViewportHeight
getViewportLeftColumn
getViewportRightColumn
getViewportTopRow
getViewportWidth
groupSparkline
hasPendingChanges
hitTest
invalidateLayout
isDirtySuspended
isEditing
isPaintSuspended
isPrintLineVisible
isValid
moveTo
name
printInfo
recalcAll
removeCustomFunction
removeCustomName
removeNamedStyle
removeSpan
removeSparkline
repaint
reset
resumeCalcService
resumeDirty
resumeEvent
resumePaint
rowFilter
search
selectionPolicy
selectionUnit
setActiveCell
setArray
setArrayFormula
setBindingPath
setCellType
setColumnCount
setColumnPageBreak
setColumnResizable
setColumnVisible
setColumnWidth
setCsv
setDataSource
setDataValidator
setDefaultStyle
setFormatter
setFormula
setRowCount
setRowHeight
setRowPageBreak
setRowResizable
setRowVisible
setSelection
setSparkline
setStyle
setStyleName
setTag
setText
setValue
showCell
showColumn
showColumnOutline
showRow
showRowOutline
sortRange
startEdit
suspendCalcService
suspendDirty
suspendEvent
suspendPaint
tag
toJSON
unbind
unbindAll
ungroupSparkline
visible
zoom
Fields
autoGenerateColumns
charts
columnOutlines
comments
conditionalFormats
defaults
floatingObjects
options
outlineColumn
pictures
rowOutlines
shapes
slicers
tables
Enumerations
AutoFitType
ClipboardPasteOptions
CopyPasteHeaderOptions
CopyToOptions
EditorStatus
HeaderAutoText
HorizontalAlign
HorizontalPosition
ImageLayout
ImeMode
InvalidOperationType
LabelAlignment
LabelVisibility
LineStyle
RangeChangedAction
ReferenceStyle
ResizeZeroIndicator
SelectionPolicy
SelectionUnit
SheetArea
ShowResizeTip
ShowScrollTip
SortState
StorageType
TextDecorationType
ValueType
VertAlign
VerticalAlign
VerticalPosition
VisualState
GC.Spread.Sheets.Barcode Namespace
Overview
Types
Codabar
Overview
Codabar Constructor
Code128
Overview
Code128 Constructor
Code39
Overview
Code39 Constructor
Code49
Overview
Code49 Constructor
Code93
Overview
Code93 Constructor
DataMatrix
Overview
DataMatrix Constructor
EAN13
Overview
EAN13 Constructor
EAN8
Overview
EAN8 Constructor
GS1_128
Overview
GS1_128 Constructor
PDF417
Overview
PDF417 Constructor
QRCode
Overview
QRCode Constructor
GC.Spread.Sheets.Bindings Namespace
Overview
Types
CellBindingSource
Overview
CellBindingSource Constructor
Methods
getSource
getValue
setValue
GC.Spread.Sheets.CalcEngine Namespace
Overview
Enumerations
RangeReferenceRelative
GC.Spread.Sheets.CellTypes Namespace
Overview
Types
Base
Overview
Base Constructor
Methods
activateEditor
createEditorElement
deactivateEditor
focus
format
fromJSON
getAutoFitHeight
getAutoFitWidth
getEditorValue
getHitInfo
isEditingValueChanged
isImeAware
isReservedKey
paint
paintContent
parse
processKeyDown
processKeyUp
processMouseDown
processMouseEnter
processMouseLeave
processMouseMove
processMouseUp
selectAll
setEditorValue
toJSON
updateEditor
updateEditorContainer
updateImeMode
Fields
typeName
Button
Overview
Button Constructor
Methods
buttonBackColor
marginBottom
marginLeft
marginRight
marginTop
text
CheckBox
Overview
CheckBox Constructor
Methods
caption
isThreeState
textAlign
textFalse
textIndeterminate
textTrue
ColumnHeader
Overview
ColumnHeader Constructor
ComboBox
Overview
ComboBox Constructor
Methods
editable
editorValueType
itemHeight
items
maxDropDownItems
Corner
Overview
Corner Constructor
HyperLink
Overview
HyperLink Constructor
Methods
activeOnClick
linkColor
linkToolTip
onClickAction
target
text
visitedLinkColor
RowHeader
Overview
RowHeader Constructor
Text
Overview
Text Constructor
Enumerations
CheckBoxTextAlign
EditorType
EditorValueType
HyperLinkTargetType
GC.Spread.Sheets.Charts Namespace
Overview
Types
Chart
Overview
Chart Constructor
Methods
axes
chartArea
chartType
dataLabels
dataRange
legend
series
switchDataOrientation
title
useAnimation
ChartCollection
Overview
ChartCollection Constructor
Methods
add
all
clear
get
remove
zIndex
DataPoints
Overview
DataPoints Constructor
Methods
get
set
LineType
Overview
Fields
dash
dashDot
dot
lgDash
lgDashDot
lgDashDotDot
solid
sysDash
sysDashDot
sysDashDotDot
sysDot
SeriesCollection
Overview
SeriesCollection Constructor
Methods
add
dataPoints
get
remove
set
SymbolShape
Overview
Fields
circle
dash
diamond
dot
none
picture
plus
square
star
triangle
x
Enumerations
AxisGroup
ChartType
DataLabelPosition
LegendPosition
RowCol
TickLabelPosition
TickMark
GC.Spread.Sheets.Commands Namespace
Overview
Types
autoFitColumn
Overview
autoFitRow
Overview
cancelInput
Overview
changeFormulaReference
Overview
clear
Overview
clearAndEditing
Overview
clearValues
Overview
clipboardPaste
Overview
commitArrayFormula
Overview
commitInputNavigationDown
Overview
commitInputNavigationUp
Overview
copy
Overview
cut
Overview
deleteFloatingObjects
Overview
dragCopyFloatingObjects
Overview
dragDrop
Overview
editCell
Overview
expandColumnOutline
Overview
expandColumnOutlineForLevel
Overview
expandRowOutline
Overview
expandRowOutlineForLevel
Overview
fill
Overview
moveFloatingObjects
Overview
moveToNextCell
Overview
moveToNextCellThenControl
Overview
moveToPreviousCell
Overview
moveToPreviousCellThenControl
Overview
navigationBottom
Overview
navigationDown
Overview
navigationEnd
Overview
navigationEnd2
Overview
navigationFirst
Overview
navigationHome
Overview
navigationHome2
Overview
navigationLast
Overview
navigationLeft
Overview
navigationNextSheet
Overview
navigationPageDown
Overview
navigationPageUp
Overview
navigationPreviousSheet
Overview
navigationRight
Overview
navigationTop
Overview
navigationUp
Overview
outlineColumn
Overview
outlineRow
Overview
paste
Overview
pasteFloatingObjects
Overview
redo
Overview
removeColumnOutline
Overview
removeRowOutline
Overview
renameSheet
Overview
resizeColumn
Overview
resizeFloatingObjects
Overview
resizeRow
Overview
selectionBottom
Overview
selectionDown
Overview
selectionEnd
Overview
selectionFirst
Overview
selectionHome
Overview
selectionLast
Overview
selectionLeft
Overview
selectionPageDown
Overview
selectionPageUp
Overview
selectionRight
Overview
selectionTop
Overview
selectionUp
Overview
selectNextControl
Overview
selectPreviousControl
Overview
undo
Overview
zoom
Overview
GC.Spread.Sheets.Comments Namespace
Overview
Types
Comment
Overview
Comment Constructor
Methods
autoSize
backColor
borderColor
borderStyle
borderWidth
commentState
displayMode
dynamicMove
dynamicSize
fontFamily
fontSize
fontStyle
fontWeight
foreColor
height
horizontalAlign
location
locked
lockText
opacity
padding
showShadow
text
textDecoration
width
zIndex
CommentManager
Overview
CommentManager Constructor
Methods
add
all
clear
get
remove
Padding
Overview
Padding Constructor
Enumerations
CommentState
DisplayMode
GC.Spread.Sheets.ConditionalFormatting Namespace
Overview
Types
Condition
Overview
Condition Constructor
Methods
compareType
evaluate
expected
formula
fromDay
fromFormula
fromMonth
fromQuarter
fromSource
fromWeek
fromYear
getExpected
getValidList
ignoreBlank
ignoreCase
item1
item2
ranges
reset
treatNullValueAsZero
useWildCards
ConditionalFormats
Overview
ConditionalFormats Constructor
Methods
add2ScaleRule
add3ScaleRule
addAverageRule
addCellValueRule
addDataBarRule
addDateOccurringRule
addDuplicateRule
addFormulaRule
addIconSetRule
addRule
addSpecificTextRule
addTop10Rule
addUniqueRule
clearRule
containsRule
count
getRule
getRules
removeRule
removeRuleByRange
ConditionRuleBase
Overview
ConditionRuleBase Constructor
Methods
condition
contains
createCondition
evaluate
getExpected
intersects
isScaleRule
priority
ranges
reset
ruleType
stopIfTrue
style
DataBarRule
Overview
DataBarRule Constructor
Methods
axisColor
axisPosition
borderColor
color
dataBarDirection
evaluate
gradient
negativeBorderColor
negativeFillColor
showBarOnly
showBorder
useNegativeBorderColor
useNegativeFillColor
IconCriterion
Overview
IconCriterion Constructor
IconSetRule
Overview
IconSetRule Constructor
Methods
evaluate
getIcon
iconCriteria
icons
iconSetType
reset
reverseIconOrder
showIconOnly
NormalConditionRule
Overview
NormalConditionRule Constructor
Methods
createCondition
formula
operator
rank
reset
text
type
value1
value2
ScaleRule
Overview
ScaleRule Constructor
Methods
createCondition
evaluate
maxColor
maxType
maxValue
midColor
midType
midValue
minColor
minType
minValue
stopIfTrue
ScaleValue
Overview
ScaleValue Constructor
Fields
type
value
Enumerations
AverageConditionType
BarDirection
ColorCompareType
ComparisonOperators
ConditionType
CustomValueType
DataBarAxisPosition
DateCompareType
DateOccurringType
GeneralComparisonOperators
IconSetType
IconValueType
LogicalOperators
QuarterType
RuleType
ScaleValueType
TextCompareType
TextComparisonOperators
Top10ConditionType
GC.Spread.Sheets.ContextMenu Namespace
Overview
Types
ContextMenu
Overview
ContextMenu Constructor
Methods
onOpenMenu
Fields
menuData
menuView
MenuView
Overview
MenuView Constructor
Methods
createMenuItemElement
getCommandOptions
GC.Spread.Sheets.DataValidation Namespace
Overview
Types
DefaultDataValidator
Overview
DefaultDataValidator Constructor
Methods
comparisonOperator
condition
errorMessage
errorStyle
errorTitle
getValidList
highlightStyle
ignoreBlank
inCellDropdown
inputMessage
inputTitle
isValid
reset
showErrorMessage
showInputMessage
type
value1
value2
Enumerations
CriteriaType
DataValidationResult
ErrorStyle
HighlightPosition
HighlightType
GC.Spread.Sheets.Fill Namespace
Overview
Enumerations
AutoFillType
FillDateUnit
FillDirection
FillSeries
FillType
GC.Spread.Sheets.Filter Namespace
Overview
Types
HideRowFilter
Overview
HideRowFilter Constructor
Methods
filterDialogVisibleInfo
RowFilterBase
Overview
RowFilterBase Constructor
Methods
addFilterItem
filter
filterButtonVisible
fromJSON
getFilteredItems
getFilterItems
getSortState
isFiltered
isRowFilteredOut
onFilter
openFilterDialog
removeFilterItems
reset
sortColumn
toJSON
unfilter
Fields
range
typeName
Enumerations
FilterActionType
GC.Spread.Sheets.FloatingObjects Namespace
Overview
Types
FloatingObject
Overview
FloatingObject Constructor
Methods
allowMove
allowResize
cloneContent
content
dynamicMove
dynamicSize
endColumn
endColumnOffset
endRow
endRowOffset
fixedPosition
getHost
height
isLocked
isSelected
isVisible
name
refreshContent
startColumn
startColumnOffset
startRow
startRowOffset
width
x
y
Fields
typeName
FloatingObjectCollection
Overview
FloatingObjectCollection Constructor
Methods
add
all
clear
get
remove
zIndex
Picture
Overview
Picture Constructor
Methods
backColor
borderColor
borderRadius
borderStyle
borderWidth
getOriginalHeight
getOriginalWidth
pictureStretch
src
GC.Spread.Sheets.FormulaTextBox Namespace
Overview
Types
FormulaTextBox
Overview
FormulaTextBox Constructor
Methods
add
autoComplete
bind
caret
destroy
refresh
remove
showHelp
text
unbind
unbindAll
workbook
GC.Spread.Sheets.OutlineColumn Namespace
Overview
Types
OutlineColumn
Overview
OutlineColumn Constructor
Methods
getCheckStatus
getCollapsed
options
refresh
setCheckStatus
setCollapsed
GC.Spread.Sheets.Outlines Namespace
Overview
Types
Outline
Overview
Outline Constructor
Methods
direction
expand
expandGroup
find
getCollapsed
getLevel
getMaxLevel
getState
group
isCollapsed
isGroupEnd
refresh
resumeAdding
setCollapsed
suspendAdding
ungroup
ungroupRange
OutlineInfo
Overview
OutlineInfo Constructor
Methods
addChild
contains
state
Fields
children
end
level
model
parent
start
Enumerations
OutlineDirection
OutlineState
GC.Spread.Sheets.PDF Namespace
Overview
Types
PDFFontsManager
Overview
Methods
fallbackFont
registerFont
GC.Spread.Sheets.Print Namespace
Overview
Types
PaperSize
Overview
PaperSize Constructor
Methods
getPageSize
height
kind
width
PrintInfo
Overview
PrintInfo Constructor
Methods
bestFitColumns
bestFitRows
blackAndWhite
centering
columnEnd
columnStart
firstPageNumber
fitPagesTall
fitPagesWide
footerCenter
footerCenterImage
footerLeft
footerLeftImage
footerRight
footerRightImage
headerCenter
headerCenterImage
headerLeft
headerLeftImage
headerRight
headerRightImage
margin
orientation
pageOrder
pageRange
paperSize
qualityFactor
repeatColumnEnd
repeatColumnStart
repeatRowEnd
repeatRowStart
rowEnd
rowStart
showBorder
showColumnHeader
showGridLine
showRowHeader
useMax
watermark
zoomFactor
Enumerations
PaperKind
PrintCentering
PrintPageOrder
PrintPageOrientation
PrintVisibilityType
GC.Spread.Sheets.Search Namespace
Overview
Types
SearchCondition
Overview
SearchCondition Constructor
Fields
columnEnd
columnStart
endSheetIndex
rowEnd
rowStart
searchFlags
searchOrder
searchString
searchTarget
sheetArea
startSheetIndex
SearchResult
Overview
SearchResult Constructor
Fields
foundColumnIndex
foundRowIndex
foundSheetIndex
foundString
searchFoundFlag
Enumerations
SearchFlags
SearchFoundFlags
SearchOrder
GC.Spread.Sheets.Shapes Namespace
Overview
Types
ConnectorShape
Overview
ConnectorShape Constructor
Methods
adjustments
endConnector
startConnector
style
type
GroupShape
Overview
GroupShape Constructor
Methods
add
all
find
remove
rotate
zIndex
Shape
Overview
Shape Constructor
Methods
adjustments
rotate
style
text
type
ShapeBase
Overview
ShapeBase Constructor
Methods
allowMove
allowResize
canPrint
dynamicMove
dynamicSize
endColumn
endColumnOffset
endRow
endRowOffset
height
isLocked
isSelected
isVisible
name
startColumn
startColumnOffset
startRow
startRowOffset
width
x
y
ShapeCollection
Overview
ShapeCollection Constructor
Methods
add
addConnector
all
clear
get
group
remove
ungroup
zIndex
ShapeStyle
Overview
ShapeStyle Constructor
Fields
fill
line
textEffect
textFrame
Enumerations
ArrowheadLength
ArrowheadStyle
ArrowheadWidth
AutoShapeType
ConnectorType
LineCapStyle
LineJoinStyle
PresetLineDashStyle
ShapeFillType
GC.Spread.Sheets.Slicers Namespace
Overview
Types
ItemSlicer
Overview
ItemSlicer Constructor
Methods
captionName
columnCount
getDOMElement
height
itemHeight
name
showHeader
showNoDataItems
showNoDataItemsInLast
sortState
style
visuallyNoDataItems
width
Slicer
Overview
Slicer Constructor
Methods
captionName
columnCount
disableResizingAndMoving
itemHeight
name
showHeader
showNoDataItems
showNoDataItemsInLast
sortState
style
visuallyNoDataItems
SlicerBorder
Overview
SlicerBorder Constructor
Methods
borderColor
borderStyle
borderWidth
SlicerCollection
Overview
SlicerCollection Constructor
Methods
add
all
clear
get
remove
SlicerStyle
Overview
SlicerStyle Constructor
Methods
headerStyle
hoveredSelectedItemWithDataStyle
hoveredSelectedItemWithNoDataStyle
hoveredUnSelectedItemWithDataStyle
hoveredUnSelectedItemWithNoDataStyle
name
selectedItemWithDataStyle
selectedItemWithNoDataStyle
unSelectedItemWithDataStyle
unSelectedItemWithNoDataStyle
wholeSlicerStyle
SlicerStyleInfo
Overview
SlicerStyleInfo Constructor
Methods
backColor
borderBottom
borderLeft
borderRight
borderTop
font
foreColor
setBorders
textDecoration
SlicerStyles
Overview
SlicerStyles Constructor
Methods
dark1
dark2
dark3
dark4
dark5
dark6
light1
light2
light3
light4
light5
light6
other1
other2
TableSlicerData
Overview
TableSlicerData Constructor
Methods
doFilter
doUnfilter
getSlicerData
getTable
refresh
GC.Spread.Sheets.Sparklines Namespace
Overview
Types
AreaSparkline
Overview
AreaSparkline Constructor
BoxPlotSparkline
Overview
BoxPlotSparkline Constructor
BulletSparkline
Overview
BulletSparkline Constructor
CascadeSparkline
Overview
CascadeSparkline Constructor
ColumnSparkline
Overview
ColumnSparkline Constructor
HBarSparkline
Overview
HBarSparkline Constructor
LineSparkline
Overview
LineSparkline Constructor
MonthSparkline
Overview
MonthSparkline Constructor
ParetoSparkline
Overview
ParetoSparkline Constructor
PieSparkline
Overview
PieSparkline Constructor
ScatterSparkline
Overview
ScatterSparkline Constructor
Sparkline
Overview
Sparkline Constructor
Methods
clone
data
dataOrientation
dateAxisData
dateAxisOrientation
displayDateAxis
group
paintSparkline
setting
sparklineType
Fields
column
row
SparklineEx
Overview
SparklineEx Constructor
Methods
createFunction
fromJSON
name
paint
toJSON
Fields
typeName
SparklineGroup
Overview
SparklineGroup Constructor
Methods
add
clone
contains
count
dateAxisData
dateAxisOrientation
remove
Fields
setting
sparklineType
SparklineSetting
Overview
SparklineSetting Constructor
Methods
clone
Fields
options
SpreadSparkline
Overview
SpreadSparkline Constructor
StackedSparkline
Overview
StackedSparkline Constructor
VariSparkline
Overview
VariSparkline Constructor
VBarSparkline
Overview
VBarSparkline Constructor
WinlossSparkline
Overview
WinlossSparkline Constructor
YearSparkline
Overview
YearSparkline Constructor
Enumerations
DataOrientation
EmptyValueStyle
SparklineAxisMinMax
SparklineType
GC.Spread.Sheets.StatusBar Namespace
Overview
Types
StatusBar
Overview
StatusBar Constructor
Methods
add
all
bind
dispose
get
remove
unbind
update
StatusItem
Overview
StatusItem Constructor
Methods
onBind
onCreateItemView
onDispose
onUnbind
onUpdate
GC.Spread.Sheets.Tables Namespace
Overview
Types
Table
Overview
Table Constructor
Methods
autoGenerateColumns
bandColumns
bandRows
bindColumns
bindingPath
dataRange
filterButtonVisible
footerIndex
getColumnFormula
getColumnName
getColumnValue
headerIndex
highlightFirstColumn
highlightLastColumn
name
range
rowFilter
setColumnDataFormula
setColumnFormula
setColumnName
setColumnValue
showFooter
showHeader
style
TableColumn
Overview
TableColumn Constructor
Methods
dataField
id
name
TableManager
Overview
TableManager Constructor
Methods
add
addFromDataSource
all
find
findByName
move
remove
resize
TableStyle
Overview
TableStyle Constructor
Fields
backColor
borderBottom
borderHorizontal
borderLeft
borderRight
borderTop
borderVertical
font
foreColor
textDecoration
TableTheme
Overview
TableTheme Constructor
Methods
firstColumnStripSize
firstColumnStripStyle
firstFooterCellStyle
firstHeaderCellStyle
firstRowStripSize
firstRowStripStyle
footerRowStyle
headerRowStyle
highlightFirstColumnStyle
highlightLastColumnStyle
lastFooterCellStyle
lastHeaderCellStyle
name
secondColumnStripSize
secondColumnStripStyle
secondRowStripSize
secondRowStripStyle
wholeTableStyle
TableThemes
Overview
TableThemes Constructor
Fields
dark1
dark10
dark11
dark2
dark3
dark4
dark5
dark6
dark7
dark8
dark9
light1
light10
light11
light12
light13
light14
light15
light16
light17
light18
light19
light2
light20
light21
light3
light4
light5
light6
light7
light8
light9
medium1
medium10
medium11
medium12
medium13
medium14
medium15
medium16
medium17
medium18
medium19
medium2
medium20
medium21
medium22
medium23
medium24
medium25
medium26
medium27
medium28
medium3
medium4
medium5
medium6
medium7
medium8
medium9
Enumerations
TableRemoveOptions
GC.Spread.Sheets.Touch Namespace
Overview
Types
TouchToolStrip
Overview
TouchToolStrip Constructor
Methods
add
clear
close
getItem
getItems
imageAreaHeight
itemHeight
itemWidth
open
remove
separatorHeight
TouchToolStripItem
Overview
TouchToolStripItem Constructor
Methods
font
foreColor
image
name
text
TouchToolStripSeparator
Overview
TouchToolStripSeparator Constructor
Methods
name
GC.Spread.Slicers Namespace
Overview
Types
GeneralSlicerData
Overview
GeneralSlicerData Constructor
Methods
aggregateData
attachListener
clearPreview
detachListener
doFilter
doUnfilter
getColumnIndex
getData
getExclusiveData
getExclusiveRowIndex
getFilteredIndexes
getFilteredOutIndexes
getFilteredOutRanges
getFilteredOutRowIndexes
getFilteredRanges
getFilteredRowIndexes
getRowIndexes
inPreview
onColumnNameChanged
onColumnsRemoved
onDataChanged
onFiltered
onRowsAdded
onRowsRemoved
resumeFilteredEvents
suspendFilteredEvents
Fields
columnNames
data
Enumerations
FilteredOutDataType
SlicerAggregateType