• Spread.Sheets Documentation
  • Developer's Guide
    • Getting Started
      • End-User License Agreement
      • Product Requirements
      • Handling Redistribution
      • Adding the Client Widget to a Browser Page
      • Using Spread.Sheets and Spread.Views
      • UMD Support
      • Using Spread.Sheets 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
        • 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
        • Printing
        • Protect and Cell Locking
        • Quote Prefix
        • Range Grouping
        • Row Filter
        • Scroll Bars
        • Searching
        • Selection
        • Sheet Area Offset
        • Shrink to Fit
        • Slicer
        • Sparklines
        • Sorting
        • Spread.Sheets Designer
        • Structured References
        • Styles
        • Tables
        • TabStrip
        • Themes
        • Tooltips
        • TypeScript
        • Undo and Redo
        • Watermark
        • Zoom
    • Using the Spread.Sheets Designer
      • Starting and Using the Designer
      • Opening and Saving Files
      • Working in the Designer
      • Understanding the Spread.Sheets Designer Interface
        • Understanding the Spread.Sheets Designer Tabs
          • Spread.Sheets Designer File Tab
          • Spread.Sheets Designer Home Tab
          • Spread.Sheets Designer Insert and Design Tab
          • Spread.Sheets Designer Formulas Tab
          • Spread.Sheets Designer Data Tab
          • Spread.Sheets Designer View Tab
          • Spread.Sheets Designer Settings Tab
        • Understanding Spread.Sheets Designer Interface Menus
    • 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
      • Allowing Cell Overflow
      • Creating Cell Spans
      • Understanding Chart
        • Configuring Chart Elements
          • Configuring Chart Title, Chart Area and Plot Area
          • Configuring Legends
          • Configuring Series
          • Configuring Axes
          • Configuring Data Label
          • 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
      • 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
      • Creating Custom Floating Objects
      • Creating Floating Pictures
      • 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
      • Setting Styles and Themes
        • Setting Styles
        • Using Themes
        • Using Custom Themes from ThemeRoller
        • Using the Default Spread.Sheets 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
      • Using Clipboard Operations
      • Copying and Pasting Styles
      • Adding a Comment to a Cell
      • Using Data Validation
      • Using Drag 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
      • 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
      • Working with the Quote Prefix
    • Managing Data
      • Adding a Tag to a Cell
      • Binding to Data
        • Binding Cells
        • Using the Spread.Sheets Designer Template with Cell Binding
      • Formatting Cells
        • Basic Format
        • Accounting Format
      • Getting the Dirty Status
      • Understanding Printing
        • Printing Sheets
        • Setting Page Breaks when Printing
      • Importing and Exporting to JSON
      • Importing and Exporting CSV Files
      • Saving and Loading JavaScript Files
      • Using JSON Schema with Spread.Sheets
        • Spread.Sheets 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
    • 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 Spread.Sheets 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 Spread.Sheets with Angular
        • Understanding the Tag Hierarchy
        • Understanding the Sheet Element
        • Understanding the Worksheet Element
        • Understanding the Column Element
      • Using Spread.Sheets with Breeze
      • Using Spread.Sheets with Knockout
      • Using Spread.Sheets with React
        • Using the Worksheet Element
        • Using the Column Element
        • Using the Spread-Sheets Element
      • Using Spread.Sheets with Vue
        • Using the gc-spread-sheets Element
        • Using the gc-worksheet Element
        • Using the gc-column Element
  • Formula Reference
    • Formula Overview
      • What is a Formula
        • Sample Formula
      • Cell References in a Formula
        • A1 Notation
        • R1C1 Notation
        • Relative and Absolute
      • 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
      • HYPERLINK
      • 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 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
      • Setting Formulas in Cells
      • Allowing Users to Enter Formulas
      • 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
          • Enumerations
            • ExpressionType
        • 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
        • GC.Spread.Excel Namespace
          • Overview
          • Types
            • IO
              • Overview
              • IO Constructor
              • Methods
                • open
                • save
              • Fields
                • 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
            • 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
                • SeriesCollection
              • Fields
                • AxisGroup
                • ChartType
                • DataLabelPosition
                • LegendPosition
                • RowCol
                • 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
            • Events
              • Overview
              • Events Constructor
              • Events
                • ActiveSheetChanged
                • ActiveSheetChanging
                • 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
                • PictureChanged
                • PictureSelectionChanged
                • RangeChanged
                • RangeFiltered
                • RangeFiltering
                • RangeGroupStateChanged
                • RangeGroupStateChanging
                • RangeSorted
                • RangeSorting
                • RowChanged
                • RowHeightChanged
                • RowHeightChanging
                • SelectionChanged
                • SelectionChanging
                • SheetMoved
                • SheetMoving
                • SheetNameChanged
                • SheetNameChanging
                • SheetTabClick
                • SheetTabDoubleClick
                • SlicerChanged
                • SparklineChanged
                • 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
                • PDFFontManager
            • 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
            • 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
            • 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
                • 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
                • 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
                • 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
                • 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
            • VerticalAlign
            • VerticalPosition
            • VisualState
        • GC.Spread.Sheets.Bindings Namespace
          • Overview
          • Types
            • CellBindingSource
              • Overview
              • CellBindingSource Constructor
              • Methods
                • getSource
                • getValue
                • setValue
        • 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
            • ChartCollection
              • Overview
              • ChartCollection Constructor
              • Methods
                • add
            • SeriesCollection
              • Overview
              • SeriesCollection Constructor
              • Methods
                • add
                • get
                • remove
                • set
          • 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
                • ignoreBlank
                • inCellDropdown
                • inputMessage
                • inputTitle
                • isValid
                • reset
                • showErrorMessage
                • showInputMessage
                • type
                • value1
                • value2
          • Enumerations
            • CriteriaType
            • DataValidationResult
            • ErrorStyle
        • 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
            • PDFFontManager
              • 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
                • 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.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.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