• 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
        • 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
          • Clipboard Operations
          • Column and Row Resize
          • Conditional Formatting
          • CSV Import and Export
          • Culture Settings
          • Data Binding
          • Data Validation
          • Drag Fill
            • Drag and Move
          • Edit Mode Always
          • Excel Import and Export
          • Floating Objects
          • Formulas
          • Frozen Columns and Rows
          • Input Mapping
          • JavaScript Open and Save
          • JSON Import and Export
          • JSON Schema
          • Keyboard Navigation
          • Knockout, Breeze, and AngularJS
          • Multiple Headers
          • Printing
          • Protect and Cell Locking
          • Range Grouping
          • Row Filter
          • Scroll Bars
          • Searching
          • Selection
          • 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 and Gridlines
        • Setting Colors
        • Adding a Background Image
        • Adding a Watermark
        • Setting Cell Padding and Label Styles
        • Setting Cell Alignment and Indentation
        • Setting Text Decoration
        • Allowing Cell Overflow
        • Creating Cell Spans
        • 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
      • 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
        • Using Clipboard Operations
        • Copying and Pasting Styles
        • Adding a Comment to a Cell
        • Using Data Validation
        • Using Drag Fill
        • Using Drag and Move
        • 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
        • 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 Tab Strip
        • Using Undo and Redo
        • 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
      • Managing Data
        • Adding a Tag to a Cell
        • Binding to Data
          • Binding Cells
          • Using the Spread.Sheets Designer Template with Cell Binding
        • Formatting Cells
        • 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 Schema
        • Using Serialization
        • Searching Data
        • Setting the Culture
        • Setting the Era Format
        • Creating a Custom Culture
        • Sorting Data
        • Using Spread.Sheets with Knockout
        • Using Spread.Sheets with Breeze
        • 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 2
          • Understanding the Tag Hierarchy
          • Understanding the Sheet Element
          • Understanding the Worksheet Element
          • Understanding the Column Element
        • Importing and Exporting Excel Files on the Client-Side
        • Using the Server-side Excel Import and Export Component
          • Installing and Configuring the Excel Import and Export Component
          • Adding a License for the Excel Import and Export Component
          • Using the Excel Import and Export Component in a Windows Forms Application
          • Using the Excel Import and Export Component in a Web Application
          • Excel Import Classes
          • Excel Export Classes
          • Excel Open and Save Flags
          • Text Open Flags
          • PDF Classes and Enumerations
          • Data Enumerations
          • Using the Excel Import and Export Service
      • 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
    • 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
        • ADDRESS
        • AMORDEGRC
        • AMORLINC
        • AND
        • ASIN
        • ASINH
        • ATAN
        • ATAN2
        • ATANH
        • AVEDEV
        • AVERAGE
        • AVERAGEA
        • AVERAGEIF
        • AVERAGEIFS
        • BESSELI
        • BESSELJ
        • BESSELK
        • BESSELY
        • BETADIST
        • BETA.DIST
        • BETAINV
        • BETA.INV
        • BIN2DEC
        • BIN2HEX
        • BIN2OCT
        • BINOMDIST
        • BINOM.DIST
        • BINOM.INV
        • CEILING
        • CEILING.PRECISE
        • CHAR
        • CHIDIST
        • CHIINV
        • CHISQ.DIST
        • CHISQ.DIST.RT
        • CHISQ.INV
        • CHISQ.INV.RT
        • CHISQ.TEST
        • CHITEST
        • CHOOSE
        • CLEAN
        • CODE
        • COLUMN
        • COLUMNS
        • COMBIN
        • COMPLEX
        • CONCATENATE
        • CONFIDENCE
        • CONFIDENCE.NORM
        • CONFIDENCE.T
        • CONVERT
        • CORREL
        • COS
        • COSH
        • COUNT
        • COUNTA
        • COUNTBLANK
        • COUNTIF
        • COUNTIFS
        • COUPDAYBS
        • COUPDAYS
        • COUPDAYSNC
        • COUPNCD
        • COUPNUM
        • COUPPCD
        • COVAR
        • COVARIANCE.P
        • COVARIANCE.S
        • CRITBINOM
        • CUMIPMT
        • CUMPRINC
        • DATE
        • DATEDIF
        • DATEVALUE
        • DAVERAGE
        • DAY
        • DAYS360
        • DB
        • DCOUNT
        • DCOUNTA
        • DDB
        • DEC2BIN
        • DEC2HEX
        • DEC2OCT
        • DEGREES
        • DELTA
        • DEVSQ
        • DGET
        • DISC
        • DMAX
        • DMIN
        • DOLLAR
        • DOLLARDE
        • DOLLARFR
        • DPRODUCT
        • DSTDEV
        • DSTDEVP
        • DSUM
        • DURATION
        • DVAR
        • DVARP
        • EDATE
        • EFFECT
        • 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
        • FINV
        • F.INV
        • F.INV.RT
        • FISHER
        • FISHERINV
        • FIXED
        • FLOOR
        • FLOOR.PRECISE
        • FORECAST
        • FREQUENCY
        • FTEST
        • F.TEST
        • FV
        • FVSCHEDULE
        • GAMMADIST
        • GAMMA.DIST
        • GAMMAINV
        • GAMMA.INV
        • GAMMALN
        • GAMMALN.PRECISE
        • GCD
        • GEOMEAN
        • GESTEP
        • GROWTH
        • HARMEAN
        • HEX2BIN
        • HEX2DEC
        • HEX2OCT
        • HLOOKUP
        • HOUR
        • HYPGEOMDIST
        • HYPGEOM.DIST
        • IF
        • IFERROR
        • IMABS
        • IMAGINARY
        • IMARGUMENT
        • IMCONJUGATE
        • IMCOS
        • IMDIV
        • IMEXP
        • IMLN
        • IMLOG2
        • IMLOG10
        • IMPOWER
        • IMPRODUCT
        • IMREAL
        • IMSIN
        • IMSQRT
        • IMSUB
        • IMSUM
        • INDEX
        • INDIRECT
        • INT
        • INTERCEPT
        • INTRATE
        • IPMT
        • IRR
        • ISBLANK
        • ISERR
        • ISERROR
        • ISEVEN
        • ISLOGICAL
        • ISNA
        • ISNONTEXT
        • ISNUMBER
        • ISO.CEILING
        • ISODD
        • ISPMT
        • ISREF
        • ISTEXT
        • KURT
        • LARGE
        • LCM
        • LEFT
        • LEN
        • LINEST
        • LN
        • LOG
        • LOG10
        • LOGEST
        • LOGINV
        • LOGNORMDIST
        • LOGNORM.DIST
        • LOGNORM.INV
        • LOOKUP
        • LOWER
        • MATCH
        • MAX
        • MAXA
        • MDETERM
        • MDURATION
        • MEDIAN
        • MID
        • MIN
        • MINA
        • 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
        • PEARSON
        • PERCENTILE
        • PERCENTILE.EXC
        • PERCENTILE.INC
        • PERCENTRANK
        • PERCENTRANK.EXC
        • PERCENTRANK.INC
        • PERMUT
        • 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
        • REPT
        • RIGHT
        • ROMAN
        • ROUND
        • ROUNDDOWN
        • ROUNDUP
        • ROW
        • ROWS
        • RSQ
        • SEARCH
        • SECOND
        • SERIESSUM
        • SIGN
        • SIN
        • SINH
        • SKEW
        • 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
        • SYD
        • T
        • TAN
        • TANH
        • TBILLEQ
        • TBILLPRICE
        • TBILLYIELD
        • TDIST
        • T.DIST
        • T.DIST.2T
        • T.DIST.RT
        • TEXT
        • TIME
        • TIMEVALUE
        • TINV
        • T.INV
        • T.INV.2T
        • TODAY
        • TRANSPOSE
        • TREND
        • TRIM
        • TRIMMEAN
        • TRUE
        • TRUNC
        • TTEST
        • T.TEST
        • TYPE
        • UPPER
        • VALUE
        • VAR
        • VARA
        • VARP
        • VAR.P
        • VARPA
        • VAR.S
        • VDB
        • VLOOKUP
        • WEEKDAY
        • WEEKNUM
        • WEIBULL
        • WEIBULL.DIST
        • WORKDAY
        • WORKDAY.INTL
        • XIRR
        • XNPV
        • 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
        • Setting Number Format with Leading Zeros
      • 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
      • Spread
        • Overview
        • Namespaces
          • GC Namespace
            • Overview
            • Types
              • Spread
                • Overview
                • Fields
                  • CalcEngine
                  • Commands
                  • Common
                  • Excel
                  • Formatter
                  • Sheets
                  • Slicers
          • GC.Spread Namespace
            • Overview
            • Types
              • CalcEngine
                • Overview
                • Methods
                  • AsyncEvaluateContext
                  • CalcError
                  • Expression
                • Fields
                  • ExpressionType
                  • Functions
              • Commands
                • Overview
                • Methods
                  • CommandManager
                  • UndoManager
                • Fields
                  • Key
              • Common
                • Overview
                • Methods
                  • CultureInfo
                  • CultureManager
              • Excel
                • Overview
                • Methods
                  • IO
              • Formatter
                • Overview
                • Methods
                  • FormatterBase
                  • GeneralFormatter
              • Sheets
                • Overview
                • Methods
                  • CellRange
                  • ColorScheme
                  • getTypeFromString
                  • NameInfo
                  • Theme
                  • Themes
                  • Workbook
                  • Worksheet
                • Fields
                  • Bindings
                  • CalcEngine
                  • CellTypes
                  • Commands
                  • Comments
                  • ConditionalFormatting
                  • CopyPasteHeaderOptions
                  • CopyToOptions
                  • DataValidation
                  • Fill
                  • Filter
                  • FloatingObjects
                  • LabelAlignment
                  • LabelVisibility
                  • LicenseKey
                  • Outlines
                  • Print
                  • Search
                  • Slicers
                  • Sparklines
                  • Tables
                  • Touch
              • Slicers
                • Overview
                • Methods
                  • GeneralSlicerData
                • Fields
                  • FilteredOutDataType
                  • SlicerAggregateType
          • 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
                • Fields
                  • AsyncFunctionEvaluateMode
            • 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
              • AsyncFunctionEvaluateMode
                • Overview
                • Fields
                  • calculateOnce
                  • onInterval
                  • onRecalculation
              • Function
                • Overview
                • Function Constructor
                • Methods
                  • acceptsArray
                  • acceptsError
                  • acceptsMissingArgument
                  • acceptsReference
                  • description
                  • evaluate
                  • findBranchArgument
                  • findTestArgument
                  • isBranch
                  • isContextSensitive
                  • isVolatile
                • Fields
                  • maxArgs
                  • minArgs
                  • name
                  • typeName
          • GC.Spread.CalcEngine.Functions.Function Namespace
            • Overview
            • Types
              • maxArgs
                • Overview
              • minArgs
                • Overview
              • name
                • Overview
              • typeName
                • Overview
          • 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.Common.CultureInfo Namespace
            • Overview
            • Types
              • DateTimeFormat
                • Overview
              • NumberFormat
                • Overview
          • 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.Formatter.FormatterBase Namespace
            • Overview
            • Types
              • typeName
                • Overview
          • GC.Spread.Sheets Namespace
            • Overview
            • Types
              • Bindings
                • Overview
                • Methods
                  • CellBindingSource
              • CalcEngine
                • Overview
                • Methods
                  • evaluateFormula
                  • expressionToFormula
                  • formulaToExpression
                  • formulaToRanges
                  • rangesToFormula
                  • rangeToFormula
                • Fields
                  • RangeReferenceRelative
              • CellRange
                • Overview
                • CellRange Constructor
                • Methods
                  • backColor
                  • backgroundImage
                  • backgroundImageLayout
                  • bindingPath
                  • borderBottom
                  • borderLeft
                  • borderRight
                  • borderTop
                  • cellPadding
                  • cellType
                  • clear
                  • comment
                  • font
                  • foreColor
                  • formatter
                  • formula
                  • hAlign
                  • height
                  • imeMode
                  • labelOptions
                  • locked
                  • 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
                  • EditorValueType
                  • HyperLinkTargetType
              • ColorScheme
                • Overview
                • ColorScheme Constructor
                • Methods
                  • accent1
                  • accent2
                  • accent3
                  • accent4
                  • accent5
                  • accent6
                  • background1
                  • background2
                  • followedHyperlink
                  • getColor
                  • hyperlink
                  • name
                  • textColor1
                  • textColor2
              • Commands
                • Overview
                • 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
              • 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
                  • 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
                  • 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
                  • getExpression
                  • getName
                  • getRow
              • Outlines
                • Overview
                • Methods
                  • Outline
                  • OutlineInfo
                • Fields
                  • OutlineDirection
                  • OutlineState
              • 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
                  • font
                  • foreColor
                  • formatter
                  • hAlign
                  • imeMode
                  • labelOptions
                  • locked
                  • name
                  • parentName
                  • shrinkToFit
                  • tabStop
                  • textDecoration
                  • textIndent
                  • themeFont
                  • validator
                  • 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
                  • invalidateLayout
                  • isPaintSuspended
                  • nextControl
                  • previousControl
                  • print
                  • refresh
                  • removeCustomFunction
                  • removeCustomName
                  • removeNamedStyle
                  • removeSheet
                  • removeSparklineEx
                  • repaint
                  • resumeCalcService
                  • resumeEvent
                  • resumePaint
                  • 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
                  • isEditing
                  • isPaintSuspended
                  • isValid
                  • moveTo
                  • name
                  • printInfo
                  • recalcAll
                  • removeCustomFunction
                  • removeCustomName
                  • removeNamedStyle
                  • removeSpan
                  • removeSparkline
                  • repaint
                  • reset
                  • resumeCalcService
                  • 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
                  • suspendEvent
                  • suspendPaint
                  • tag
                  • toJSON
                  • unbind
                  • unbindAll
                  • ungroupSparkline
                  • visible
                  • zoom
                • Fields
                  • autoGenerateColumns
                  • columnOutlines
                  • comments
                  • conditionalFormats
                  • defaults
                  • floatingObjects
                  • options
                  • 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.CalcEngine Namespace
            • Overview
            • Enumerations
              • RangeReferenceRelative
          • GC.Spread.Sheets.CellRange Namespace
            • Overview
            • Types
              • col
                • Overview
              • colCount
                • Overview
              • row
                • Overview
              • rowCount
                • Overview
              • sheet
                • Overview
              • sheetArea
                • Overview
          • 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
                  • linkColor
                  • linkToolTip
                  • target
                  • text
                  • visitedLinkColor
              • RowHeader
                • Overview
                • RowHeader Constructor
              • Text
                • Overview
                • Text Constructor
            • Enumerations
              • CheckBoxTextAlign
              • EditorValueType
              • HyperLinkTargetType
          • GC.Spread.Sheets.CellTypes.Base Namespace
            • Overview
            • Types
              • typeName
                • Overview
          • 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
                  • 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.ConditionalFormatting.ScaleValue Namespace
            • Overview
            • Types
              • type
                • Overview
              • value
                • Overview
          • 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.Events Namespace
            • Overview
            • Types
              • ActiveSheetChanged
                • Overview
              • ActiveSheetChanging
                • Overview
              • ButtonClicked
                • Overview
              • CellChanged
                • Overview
              • CellClick
                • Overview
              • CellDoubleClick
                • Overview
              • ClipboardChanged
                • Overview
              • ClipboardChanging
                • Overview
              • ClipboardPasted
                • Overview
              • ClipboardPasting
                • Overview
              • ColumnChanged
                • Overview
              • ColumnWidthChanged
                • Overview
              • ColumnWidthChanging
                • Overview
              • CommentChanged
                • Overview
              • CommentRemoved
                • Overview
              • CommentRemoving
                • Overview
              • DragDropBlock
                • Overview
              • DragDropBlockCompleted
                • Overview
              • DragFillBlock
                • Overview
              • DragFillBlockCompleted
                • Overview
              • EditChange
                • Overview
              • EditEnded
                • Overview
              • EditEnding
                • Overview
              • EditorStatusChanged
                • Overview
              • EditStarting
                • Overview
              • EnterCell
                • Overview
              • FloatingObjectChanged
                • Overview
              • FloatingObjectLoaded
                • Overview
              • FloatingObjectRemoved
                • Overview
              • FloatingObjectRemoving
                • Overview
              • FloatingObjectSelectionChanged
                • Overview
              • InvalidOperation
                • Overview
              • LeaveCell
                • Overview
              • LeftColumnChanged
                • Overview
              • PictureChanged
                • Overview
              • PictureSelectionChanged
                • Overview
              • RangeChanged
                • Overview
              • RangeFiltered
                • Overview
              • RangeFiltering
                • Overview
              • RangeGroupStateChanged
                • Overview
              • RangeGroupStateChanging
                • Overview
              • RangeSorted
                • Overview
              • RangeSorting
                • Overview
              • RowChanged
                • Overview
              • RowHeightChanged
                • Overview
              • RowHeightChanging
                • Overview
              • SelectionChanged
                • Overview
              • SelectionChanging
                • Overview
              • SheetNameChanged
                • Overview
              • SheetNameChanging
                • Overview
              • SheetTabClick
                • Overview
              • SheetTabDoubleClick
                • Overview
              • SlicerChanged
                • Overview
              • SparklineChanged
                • Overview
              • TableFiltered
                • Overview
              • TableFiltering
                • Overview
              • TopRowChanged
                • Overview
              • TouchToolStripOpening
                • Overview
              • UserFormulaEntered
                • Overview
              • UserZooming
                • Overview
              • ValidationError
                • Overview
              • ValueChanged
                • Overview
          • GC.Spread.Sheets.Fill Namespace
            • Overview
            • Enumerations
              • AutoFillType
              • FillDateUnit
              • FillDirection
              • FillSeries
              • FillType
          • GC.Spread.Sheets.Filter Namespace
            • Overview
            • Types
              • HideRowFilter
                • Overview
                • HideRowFilter Constructor
              • 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.Filter.RowFilterBase Namespace
            • Overview
            • Types
              • range
                • Overview
              • typeName
                • Overview
          • 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.FloatingObjects.FloatingObject Namespace
            • Overview
            • Types
              • typeName
                • Overview
          • 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.LineBorder Namespace
            • Overview
            • Types
              • color
                • Overview
              • style
                • Overview
          • 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.Outlines.OutlineInfo Namespace
            • Overview
            • Types
              • children
                • Overview
              • end
                • Overview
              • level
                • Overview
              • model
                • Overview
              • parent
                • Overview
              • start
                • Overview
          • 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.Range Namespace
            • Overview
            • Types
              • col
                • Overview
              • colCount
                • Overview
              • row
                • Overview
              • rowCount
                • Overview
          • GC.Spread.Sheets.Rect Namespace
            • Overview
            • Types
              • height
                • Overview
              • width
                • Overview
              • x
                • Overview
              • y
                • Overview
          • 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.Search.SearchCondition Namespace
            • Overview
            • Types
              • columnEnd
                • Overview
              • columnStart
                • Overview
              • endSheetIndex
                • Overview
              • rowEnd
                • Overview
              • rowStart
                • Overview
              • searchFlags
                • Overview
              • searchOrder
                • Overview
              • searchString
                • Overview
              • searchTarget
                • Overview
              • sheetArea
                • Overview
              • startSheetIndex
                • Overview
          • GC.Spread.Sheets.Search.SearchResult Namespace
            • Overview
            • Types
              • foundColumnIndex
                • Overview
              • foundRowIndex
                • Overview
              • foundSheetIndex
                • Overview
              • foundString
                • Overview
              • searchFoundFlag
                • Overview
          • 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.Sparklines.Sparkline Namespace
            • Overview
            • Types
              • column
                • Overview
              • row
                • Overview
          • GC.Spread.Sheets.Sparklines.SparklineEx Namespace
            • Overview
            • Types
              • typeName
                • Overview
          • GC.Spread.Sheets.Sparklines.SparklineGroup Namespace
            • Overview
            • Types
              • setting
                • Overview
              • sparklineType
                • Overview
          • GC.Spread.Sheets.Sparklines.SparklineSetting Namespace
            • Overview
            • Types
              • options
                • Overview
          • GC.Spread.Sheets.Style Namespace
            • Overview
            • Types
              • backColor
                • Overview
              • backgroundImage
                • Overview
              • backgroundImageLayout
                • Overview
              • borderBottom
                • Overview
              • borderLeft
                • Overview
              • borderRight
                • Overview
              • borderTop
                • Overview
              • cellPadding
                • Overview
              • cellType
                • Overview
              • font
                • Overview
              • foreColor
                • Overview
              • formatter
                • Overview
              • hAlign
                • Overview
              • imeMode
                • Overview
              • labelOptions
                • Overview
              • locked
                • Overview
              • name
                • Overview
              • parentName
                • Overview
              • shrinkToFit
                • Overview
              • tabStop
                • Overview
              • textDecoration
                • Overview
              • textIndent
                • Overview
              • themeFont
                • Overview
              • validator
                • Overview
              • vAlign
                • Overview
              • watermark
                • Overview
              • wordWrap
                • Overview
          • 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.Tables.TableStyle Namespace
            • Overview
            • Types
              • backColor
                • Overview
              • borderBottom
                • Overview
              • borderHorizontal
                • Overview
              • borderLeft
                • Overview
              • borderRight
                • Overview
              • borderTop
                • Overview
              • borderVertical
                • Overview
              • font
                • Overview
              • foreColor
                • Overview
              • textDecoration
                • Overview
          • GC.Spread.Sheets.Tables.TableThemes Namespace
            • Overview
            • Types
              • dark1
                • Overview
              • dark10
                • Overview
              • dark11
                • Overview
              • dark2
                • Overview
              • dark3
                • Overview
              • dark4
                • Overview
              • dark5
                • Overview
              • dark6
                • Overview
              • dark7
                • Overview
              • dark8
                • Overview
              • dark9
                • Overview
              • light1
                • Overview
              • light10
                • Overview
              • light11
                • Overview
              • light12
                • Overview
              • light13
                • Overview
              • light14
                • Overview
              • light15
                • Overview
              • light16
                • Overview
              • light17
                • Overview
              • light18
                • Overview
              • light19
                • Overview
              • light2
                • Overview
              • light20
                • Overview
              • light21
                • Overview
              • light3
                • Overview
              • light4
                • Overview
              • light5
                • Overview
              • light6
                • Overview
              • light7
                • Overview
              • light8
                • Overview
              • light9
                • Overview
              • medium1
                • Overview
              • medium10
                • Overview
              • medium11
                • Overview
              • medium12
                • Overview
              • medium13
                • Overview
              • medium14
                • Overview
              • medium15
                • Overview
              • medium16
                • Overview
              • medium17
                • Overview
              • medium18
                • Overview
              • medium19
                • Overview
              • medium2
                • Overview
              • medium20
                • Overview
              • medium21
                • Overview
              • medium22
                • Overview
              • medium23
                • Overview
              • medium24
                • Overview
              • medium25
                • Overview
              • medium26
                • Overview
              • medium27
                • Overview
              • medium28
                • Overview
              • medium3
                • Overview
              • medium4
                • Overview
              • medium5
                • Overview
              • medium6
                • Overview
              • medium7
                • Overview
              • medium8
                • Overview
              • medium9
                • Overview
          • GC.Spread.Sheets.ThemeColors Namespace
            • Overview
            • Types
              • Apex
                • Overview
              • Aspect
                • Overview
              • Civic
                • Overview
              • Concourse
                • Overview
              • Default
                • Overview
              • Equity
                • Overview
              • Flow
                • Overview
              • Foundry
                • Overview
              • Median
                • Overview
              • Metro
                • Overview
              • Module
                • Overview
              • Office
                • Overview
              • Office2007
                • Overview
              • Opulent
                • Overview
              • Oriel
                • Overview
              • Origin
                • Overview
              • Paper
                • Overview
              • Solstice
                • Overview
              • Technic
                • Overview
              • Trek
                • Overview
              • Urban
                • Overview
              • Verve
                • Overview
          • GC.Spread.Sheets.Themes Namespace
            • Overview
            • Types
              • Apex
                • Overview
              • Aspect
                • Overview
              • Civic
                • Overview
              • Concourse
                • Overview
              • Default
                • Overview
              • Equity
                • Overview
              • Flow
                • Overview
              • Foundry
                • Overview
              • Median
                • Overview
              • Metro
                • Overview
              • Module
                • Overview
              • Office
                • Overview
              • Office2007
                • Overview
              • Opulent
                • Overview
              • Oriel
                • Overview
              • Origin
                • Overview
              • Paper
                • Overview
              • Solstice
                • Overview
              • Technic
                • Overview
              • Trek
                • Overview
              • Urban
                • Overview
              • Verve
                • Overview
          • 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.Sheets.Workbook Namespace
            • Overview
            • Types
              • name
                • Overview
              • options
                • Overview
              • sheets
                • Overview
              • touchToolStrip
                • Overview
          • GC.Spread.Sheets.Worksheet Namespace
            • Overview
            • Types
              • autoGenerateColumns
                • Overview
              • columnOutlines
                • Overview
              • comments
                • Overview
              • conditionalFormats
                • Overview
              • defaults
                • Overview
              • floatingObjects
                • Overview
              • options
                • Overview
              • pictures
                • Overview
              • rowOutlines
                • Overview
              • slicers
                • Overview
              • tables
                • Overview
          • 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
          • GC.Spread.Slicers.GeneralSlicerData Namespace
            • Overview
            • Types
              • columnNames
                • Overview
              • data
                • Overview