• SpreadJS Documentation
    • Developer's Guide
      • Getting Started
        • End-User License Agreement
        • Product Requirements
        • Handling Redistribution
        • Adding the Client Widget to a Browser Page
        • Using SpreadJS Libraries
        • Using TypeScript
        • 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 and Move
          • Drag Fill
          • 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
          • SpreadJS Designer
          • Structured References
          • Styles
          • Tables
          • TabStrip
          • Themes
          • Tooltips
          • TypeScript
          • Undo and Redo
          • Watermark
          • Zoom
      • Using the SpreadJS Designer
        • Starting and Using the Designer
        • Opening and Saving Files
        • Working in the Designer
        • Understanding the SpreadJS Designer Interface
          • Understanding the SpreadJS Designer Tabs
            • SpreadJS Designer File Tab
            • SpreadJS Designer Home Tab
            • SpreadJS Designer Insert and Design Tab
            • SpreadJS Designer Formulas Tab
            • SpreadJS Designer Data Tab
            • SpreadJS Designer View Tab
            • SpreadJS Designer Settings Tab
          • Understanding SpreadJS Designer Interface Menus
      • Customizing the Appearance
        • Setting Borders and Gridlines
        • Setting Colors
        • Adding a Background Image
        • Adding a Watermark
        • 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 Custom Sparkline
        • Setting Styles and Themes
          • Setting Styles
          • Using Themes
          • Using Custom Themes from ThemeRoller
          • Using the Default SpreadJS Theme
          • Using the Excel Theme
          • Using a Bootstrap Theme
      • 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
        • 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
          • 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 SpreadJS 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 SpreadJS
          • Spread Schema
        • Using Serialization
        • Searching Data
        • Setting the Culture
        • Setting the Era Format
        • Creating a Custom Culture
        • Sorting Data
        • Using SpreadJS with Knockout
        • Using SpreadJS with Breeze
        • Using SpreadJS with AngularJS
          • Using the Gcspread-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 the Excel Import and Export Component
          • Installing and Configuring the Excel Import and Export Component
          • Creating a License File 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 with the Designer
          • 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
        • 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
      • 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
          • GcSpread Namespace
            • Overview
            • Types
              • Sheets
                • Overview
                • Methods
                  • addCultureInfo
                  • Culture
                  • getCultureInfo
                  • getTypeFromString
                  • Spread
          • GcSpread.Sheets Namespace
            • Overview
            • Types
              • AreaCondition
                • Overview
                • AreaCondition Constructor
                • Methods
                  • evaluate
                  • fromFormula
                  • fromSource
                  • getExpected
                  • getValidList
                • Fields
                  • expected
                  • formula
                  • ignoreBlank
              • AreaSparkline
                • Overview
                • AreaSparkline Constructor
              • AutoFormatter
                • Overview
                • AutoFormatter Constructor
                • Methods
                  • Format
                  • FormatString
                  • innerFormatter
                  • Parse
              • AverageCondition
                • Overview
                • AverageCondition Constructor
                • Methods
                  • evaluate
                  • getExpected
                  • getExpectedDouble
                  • reset
                • Fields
                  • ignoreBlank
                  • ranges
                  • type
              • AverageRule
                • Overview
                • AverageRule Constructor
                • Methods
                  • reset
                • Fields
                  • type
              • BaseCellType
                • Overview
                • BaseCellType Constructor
                • Methods
                  • activateEditor
                  • createEditorElement
                  • deactivateEditor
                  • focus
                  • format
                  • getAutoFitHeight
                  • getAutoFitWidth
                  • getEditorValue
                  • getHitInfo
                  • isEditingValueChanged
                  • isImeAware
                  • isReservedKey
                  • paint
                  • parse
                  • processKeyDown
                  • processKeyUp
                  • processMouseDown
                  • processMouseEnter
                  • processMouseLeave
                  • processMouseMove
                  • processMouseUp
                  • selectAll
                  • setEditorValue
                  • updateEditor
                  • updateImeMode
                • Fields
                  • typeName
              • BoxPlotSparkline
                • Overview
                • BoxPlotSparkline Constructor
              • BulletSparkline
                • Overview
                • BulletSparkline Constructor
              • ButtonCellType
                • Overview
                • ButtonCellType Constructor
                • Methods
                  • buttonBackColor
                  • marginBottom
                  • marginLeft
                  • marginRight
                  • marginTop
                  • text
              • Calc
                • Overview
                • Methods
                  • AsyncEvaluateContext
                  • CalcArray
                  • CalcError
                  • CalcService
                  • CalcSource
                  • CalcSourceModel
                  • Errors
                  • EvaluateContext
                  • evaluateFormula
                  • Evaluator
                  • Parser
                  • ParserContext
                  • rangesToFormula
                  • rangeToFormula
                  • Reference
                  • SheetReference
                • Fields
                  • CalcValueType
                  • Expressions
                  • Functions
                  • missingArgument
                  • Operators
                  • RangeReferenceRelative
              • CascadeSparkline
                • Overview
                • CascadeSparkline Constructor
              • Cell
                • Overview
                • Cell Constructor
                • Methods
                  • backColor
                  • backgroundImage
                  • backgroundImageLayout
                  • bindingPath
                  • borderBottom
                  • borderLeft
                  • borderRight
                  • borderTop
                  • cellType
                  • clearStyleProperty
                  • comment
                  • dataValidator
                  • font
                  • foreColor
                  • formatter
                  • formula
                  • hAlign
                  • imeMode
                  • locked
                  • shrinkToFit
                  • tabStop
                  • tag
                  • text
                  • textDecoration
                  • textIndent
                  • themeFont
                  • vAlign
                  • value
                  • watermark
                  • wordWrap
                • Fields
                  • col
                  • col2
                  • row
                  • row2
                  • sheet
                  • sheetArea
              • CellBindingSource
                • Overview
                • CellBindingSource Constructor
                • Methods
                  • getSource
                  • getValue
                  • setValue
              • CellPosition
                • Overview
                • CellPosition Constructor
                • Fields
                  • col
                  • row
              • CellsEnumerator
                • Overview
                • CellsEnumerator Constructor
                • Methods
                  • init
                  • moveNext
                  • skipCurrent
                  • tryMoveNext
              • CellValueCondition
                • Overview
                • CellValueCondition Constructor
                • Methods
                  • evaluate
                  • getExpected
                  • isSatisfyingCondition
                • Fields
                  • compareType
                  • expected
                  • formula
                  • treatNullValueAsZero
              • CellValueRule
                • Overview
                • CellValueRule Constructor
                • Methods
                  • reset
                • Fields
                  • operator
                  • value1
                  • value2
              • CheckBoxCellType
                • Overview
                • CheckBoxCellType Constructor
                • Methods
                  • caption
                  • isThreeState
                  • textAlign
                  • textFalse
                  • textIndeterminate
                  • textTrue
              • ColorCondition
                • Overview
                • ColorCondition Constructor
                • Methods
                  • evaluate
                  • reset
                • Fields
                  • compareType
                  • expected
                  • ignoreBlank
              • Column
                • Overview
                • Column Constructor
                • Methods
                  • backColor
                  • backgroundImage
                  • backgroundImageLayout
                  • borderBottom
                  • borderLeft
                  • borderRight
                  • borderTop
                  • cellType
                  • clearStyleProperty
                  • dataValidator
                  • font
                  • foreColor
                  • formatter
                  • hAlign
                  • imeMode
                  • locked
                  • resizable
                  • shrinkToFit
                  • tabStop
                  • tag
                  • textDecoration
                  • textIndent
                  • themeFont
                  • vAlign
                  • visible
                  • watermark
                  • width
                  • wordWrap
                • Fields
                  • index
                  • index2
                  • sheet
                  • sheetArea
              • ColumnHeaderCellType
                • Overview
                • ColumnHeaderCellType Constructor
              • ComboBoxCellType
                • Overview
                • ComboBoxCellType Constructor
                • Methods
                  • editable
                  • editorValueType
                  • itemHeight
                  • items
                  • maxDropDownItems
              • 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
              • 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
                  • contains
                  • evaluate
                  • getExpected
                  • intersects
                  • priority
                  • reset
                  • stopIfTrue
                • Fields
                  • ranges
                  • style
              • CornerCellType
                • Overview
                • CornerCellType Constructor
              • CultureInfo
                • Overview
                • CultureInfo Constructor
                • Fields
                  • abbreviatedDayNames
                  • abbreviatedMonthGenitiveNames
                  • abbreviatedMonthNames
                  • amDesignator
                  • arrayGroupSeparator
                  • arrayListSeparator
                  • currencyDecimalSeparator
                  • currencyGroupSeparator
                  • currencySymbol
                  • dayNames
                  • fullDateTimePattern
                  • listSeparator
                  • longDatePattern
                  • longTimePattern
                  • monthDayPattern
                  • monthGenitiveNames
                  • monthNames
                  • numberDecimalSeparator
                  • numberGroupSeparator
                  • pmDesignator
                  • rfc1123Pattern
                  • shortDatePattern
                  • shortTimePattern
                  • sortableDateTimePattern
                  • universalSortableDateTimePattern
                  • yearMonthPattern
              • CustomCellType
                • Overview
                • CustomCellType Constructor
                • Methods
                  • activateEditor
                  • createEditorElement
                  • deactivateEditor
                  • fromJSON
                  • getAutoFitHeight
                  • getAutoFitWidth
                  • getEditorValue
                  • getHitInfo
                  • isEditingValueChanged
                  • isImeAware
                  • isReservedKey
                  • paint
                  • processKeyDown
                  • processKeyUp
                  • processMouseDown
                  • processMouseEnter
                  • processMouseLeave
                  • processMouseMove
                  • processMouseUp
                  • setEditorValue
                  • toJSON
                  • updateEditor
                  • updateImeMode
                • Fields
                  • typeName
              • CustomFloatingObject
                • Overview
                • CustomFloatingObject Constructor
                • Methods
                  • cloneContent
                  • Content
              • CustomFormatterBase
                • Overview
                • CustomFormatterBase Constructor
                • Methods
                  • Format
                  • fromJSON
                  • Parse
                  • toJSON
                • Fields
                  • typeName
              • DataBarRule
                • Overview
                • DataBarRule Constructor
                • Methods
                  • axisColor
                  • axisPosition
                  • borderColor
                  • color
                  • dataBarDirection
                  • evaluate
                  • gradient
                  • maximumType
                  • maximumValue
                  • minimumType
                  • minimumValue
                  • negativeBorderColor
                  • negativeFillColor
                  • showBarOnly
                  • showBorder
                  • useNegativeBorderColor
                  • useNegativeFillColor
              • DateCondition
                • Overview
                • DateCondition Constructor
                • Methods
                  • evaluate
                  • getExpected
                  • getExpectedDateTime
                • Fields
                  • compareType
                  • expected
                  • formula
                  • ignoreBlank
              • DateExCondition
                • Overview
                • DateExCondition Constructor
                • Methods
                  • evaluate
                  • fromDay
                  • fromMonth
                  • fromQuarter
                  • fromWeek
                  • fromYear
                  • getExpected
                  • getExpectedInt
                  • reset
                • Fields
                  • expected
                  • formula
                  • ignoreBlank
              • DateOccurringRule
                • Overview
                • DateOccurringRule Constructor
                • Methods
                  • reset
                • Fields
                  • type
              • DefaultDataValidator
                • Overview
                • DefaultDataValidator Constructor
                • Methods
                  • createDateValidator
                  • createFormulaListValidator
                  • createFormulaValidator
                  • createListValidator
                  • createNumberValidator
                  • createTextLengthValidator
                  • getValidList
                  • IgnoreBlank
                  • isValid
                  • reset
                  • value1
                  • value2
                • Fields
                  • comparisonOperator
                  • condition
                  • errorMessage
                  • errorStyle
                  • errorTitle
                  • ignoreBlank
                  • inCellDropdown
                  • inputMessage
                  • inputTitle
                  • showErrorMessage
                  • showInputMessage
                  • type
              • DuplicateRule
                • Overview
                • DuplicateRule Constructor
              • Events
                • Overview
                • Events Constructor
                • Events
                  • ActiveSheetChanged
                  • ActiveSheetChanging
                  • ButtonClicked
                  • CellChanged
                  • CellClick
                  • CellDoubleClick
                  • ClipboardChanged
                  • ClipboardChanging
                  • ClipboardPasted
                  • ClipboardPasting
                  • ColumnChanged
                  • ColumnWidthChanged
                  • ColumnWidthChanging
                  • CommentChanged
                  • CommentRemoved
                  • CommentRemoving
                  • CustomFloatingObjectLoaded
                  • DragDropBlock
                  • DragDropBlockCompleted
                  • DragFillBlock
                  • DragFillBlockCompleted
                  • EditChange
                  • EditEnded
                  • EditEnding
                  • EditorStatusChanged
                  • EditStarting
                  • EnterCell
                  • FloatingObjectChanged
                  • 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
              • FloatingObject
                • Overview
                • FloatingObject Constructor
                • Methods
                  • allowMove
                  • allowResize
                  • dynamicMove
                  • dynamicSize
                  • endColumn
                  • endColumnOffset
                  • endRow
                  • endRowOffset
                  • fixedPosition
                  • height
                  • isLocked
                  • isSelected
                  • isVisible
                  • name
                  • position
                  • startColumn
                  • startColumnOffset
                  • startRow
                  • startRowOffset
                  • width
              • FontFactory
                • Overview
                • FontFactory Constructor
                • Methods
                  • buildFont
              • FormatConverter
                • Overview
                • FormatConverter Constructor
                • Methods
                  • IsNumber
                  • ToDouble
                  • toString
              • FormulaCondition
                • Overview
                • FormulaCondition Constructor
                • Methods
                  • evaluate
                  • getExpected
                  • reset
                • Fields
                  • customValueType
                  • formula
                  • ignoreBlank
              • FormulaInformation
                • Overview
                • FormulaInformation Constructor
                • Fields
                  • baseRange
                  • formula
                  • hasFormula
                  • isArrayFormula
              • FormulaRule
                • Overview
                • FormulaRule Constructor
                • Methods
                  • reset
                • Fields
                  • formula
              • FormulaTextBox
                • Overview
                • FormulaTextBox Constructor
                • Methods
                  • add
                  • autoComplete
                  • bind
                  • caret
                  • destroy
                  • remove
                  • showHelp
                  • spread
                  • text
                  • unbind
                  • unbindAll
              • GcSpreadSheetsOptions
                • Overview
                • GcSpreadSheetsOptions Constructor
                • Fields
                  • activeSheetIndex
                  • allowUserResize
                  • allowUserZoom
                  • font
                  • name
                  • newTabVisible
                  • sheetCount
                  • sheets
                  • tabEditable
                  • tabStripRatio
                  • tabStripVisible
              • GeneralFormatter
                • Overview
                • GeneralFormatter Constructor
                • Methods
                  • ExcelCompatibleFormatString
                  • Format
                  • FormatMode
                  • FormatString
                  • GetFormatType
                  • GetPreferredDisplayFormatter
                  • GetPreferredEditingFormatter
                  • HasFormatedColor
                  • IsDefaultFormat
                  • Parse
                • Fields
                  • PropertyChanged
              • GroupedItemIndexEnumerator
                • Overview
                • GroupedItemIndexEnumerator Constructor
              • HBarSparkline
                • Overview
                • HBarSparkline Constructor
              • HideRowFilter
                • Overview
                • HideRowFilter Constructor
                • Methods
                  • isHideRowFilter
              • HyperLinkCellType
                • Overview
                • HyperLinkCellType Constructor
                • Methods
                  • linkColor
                  • linkToolTip
                  • target
                  • text
                  • visitedLinkColor
              • IconCriterion
                • Overview
                • IconCriterion Constructor
              • IconSetRule
                • Overview
                • IconSetRule Constructor
                • Methods
                  • evaluate
                  • getIcon
                  • iconCriteria
                  • iconSetType
                  • reset
                  • reverseIconOrder
                  • showIconOnly
              • ItemSlicer
                • Overview
                • ItemSlicer Constructor
                • Methods
                  • captionName
                  • columnCount
                  • getDOMElement
                  • height
                  • itemHeight
                  • name
                  • setData
                  • showHeader
                  • showNoDataItems
                  • showNoDataItemsInLast
                  • sortState
                  • style
                  • visuallyNoDataItems
                  • width
              • KeyMap
                • Overview
                • KeyMap Constructor
              • LineBorder
                • Overview
                • LineBorder Constructor
                • Methods
                  • width
                • Fields
                  • color
                  • style
              • NameInfo
                • Overview
                • NameInfo Constructor
                • Methods
                  • getColumn
                  • getExpression
                  • getName
                  • getRow
              • NumberCondition
                • Overview
                • NumberCondition Constructor
                • Methods
                  • evaluate
                  • getExpected
                  • reset
                • Fields
                  • compareType
                  • expected
                  • formula
                  • ignoreBlank
              • Padding
                • Overview
                • Padding Constructor
                • Fields
                  • bottom
                  • left
                  • right
                  • top
              • PaperSize
                • Overview
                • PaperSize Constructor
                • Methods
                  • getPageSize
                  • height
                  • kind
                  • width
              • ParetoSparkline
                • Overview
                • ParetoSparkline Constructor
              • Picture
                • Overview
                • Picture Constructor
                • Methods
                  • backColor
                  • borderColor
                  • borderRadius
                  • borderStyle
                  • borderWidth
                  • getOriginalHeight
                  • getOriginalWidth
                  • pictureStretch
                  • src
              • PieSparkline
                • Overview
                • PieSparkline Constructor
              • Point
                • Overview
                • Point Constructor
                • Methods
                  • clone
              • 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
              • Range
                • Overview
                • Range Constructor
                • Methods
                  • contains
                  • containsRange
                  • equals
                  • getIntersect
                  • intersect
                  • offset
                  • union
                • Fields
                  • col
                  • colCount
                  • row
                  • rowCount
              • RangeGroup
                • Overview
                • RangeGroup Constructor
                • Methods
                  • equals
                  • expand
                  • expandGroup
                  • find
                  • getCollapsed
                  • getDirection
                  • getLevel
                  • getMaxLevel
                  • getState
                  • group
                  • isCollapsed
                  • isGroupEnd
                  • refresh
                  • resumeAdding
                  • setCollapsed
                  • setDirection
                  • suspendAdding
                  • ungroup
                  • ungroupRange
              • RangeGroupInfo
                • Overview
                • RangeGroupInfo Constructor
                • Methods
                  • addChild
                  • contains
                  • getState
                  • setState
                • Fields
                  • children
                  • end
                  • level
                  • model
                  • parent
                  • start
              • Rect
                • Overview
                • Rect Constructor
                • Methods
                  • contains
                  • empty
                  • getIntersectRect
                  • intersect
                  • intersectRect
                • Fields
                  • height
                  • width
                  • x
                  • y
              • RelationCondition
                • Overview
                • RelationCondition Constructor
                • Methods
                  • create
                  • evaluate
                  • reset
                • Fields
                  • compareType
                  • ignoreBlank
                  • item1
                  • item2
              • Row
                • Overview
                • Row Constructor
                • Methods
                  • backColor
                  • backgroundImage
                  • backgroundImageLayout
                  • borderBottom
                  • borderLeft
                  • borderRight
                  • borderTop
                  • cellType
                  • clearStyleProperty
                  • dataValidator
                  • font
                  • foreColor
                  • formatter
                  • hAlign
                  • height
                  • imeMode
                  • locked
                  • resizable
                  • shrinkToFit
                  • tabStop
                  • tag
                  • textDecoration
                  • textIndent
                  • themeFont
                  • vAlign
                  • visible
                  • watermark
                  • wordWrap
                • Fields
                  • index
                  • index2
                  • sheet
                  • sheetArea
              • RowFilterBase
                • Overview
                • RowFilterBase Constructor
                • Methods
                  • addAverageFilter
                  • addBackgroundFilter
                  • addDateFilter
                  • addFilterItem
                  • addForegroundFilter
                  • addNumberFilter
                  • addTextFilter
                  • addTop10Filter
                  • filter
                  • filterButtonVisible
                  • fromJSON
                  • getFilteredItems
                  • getFilterItems
                  • getSortState
                  • isColumnFiltered
                  • isFiltered
                  • isHideRowFilter
                  • isRowFilteredOut
                  • onFilter
                  • openFilterDialog
                  • reFilter
                  • removeFilterItems
                  • reset
                  • sortColumn
                  • toJSON
                  • unfilter
                • Fields
                  • range
                  • typeName
              • RowHeaderCellType
                • Overview
                • RowHeaderCellType Constructor
              • ScaleRule
                • Overview
                • ScaleRule Constructor
                • Methods
                  • createCondition
                  • stopIfTrue
              • ScaleValue
                • Overview
                • ScaleValue Constructor
                • Fields
                  • type
                  • value
              • ScatterSparkline
                • Overview
                • ScatterSparkline Constructor
              • 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
              • Sheet
                • Overview
                • Sheet Constructor
                • Methods
                  • addColumns
                  • addCustomFunction
                  • addCustomFunctionDescription
                  • addCustomName
                  • addFloatingObject
                  • addKeyMap
                  • addNamedStyle
                  • addPicture
                  • addRows
                  • addSelection
                  • addSlicer
                  • addSpan
                  • addTable
                  • addTableByDataSource
                  • allowCellOverflow
                  • allowEditorReservedLocations
                  • allowUndo
                  • autoFitColumn
                  • autoFitRow
                  • bind
                  • bindColumn
                  • bindColumns
                  • clear
                  • clearCustomFunctionDescriptions
                  • clearCustomFunctions
                  • clearCustomNames
                  • clearPendingChanges
                  • clearSelection
                  • clipBoardOptions
                  • copyTo
                  • currentTheme
                  • deleteColumns
                  • deleteRows
                  • doCommand
                  • editorStatus
                  • endEdit
                  • fillAuto
                  • fillAutobyDirection
                  • fillDate
                  • fillGrowth
                  • fillLinear
                  • findFloatingObject
                  • findPicture
                  • findTable
                  • findTableByName
                  • fromJSON
                  • frozenlineColor
                  • getActiveColumnIndex
                  • getActiveRowIndex
                  • getActualStyle
                  • getArray
                  • getBindingPath
                  • getCalcService
                  • getCell
                  • getCellRect
                  • getCells
                  • getCellType
                  • getColumn
                  • getColumnCount
                  • getColumnHeaderAutoText
                  • getColumnHeaderAutoTextIndex
                  • getColumnHeaderVisible
                  • getColumnPageBreak
                  • getColumnResizable
                  • getColumns
                  • getColumnVisible
                  • getColumnWidth
                  • getComment
                  • getComments
                  • getConditionalFormats
                  • getCsv
                  • getCustomFunction
                  • getCustomFunctionDescription
                  • getCustomName
                  • getCustomNames
                  • getDataColumnName
                  • getDataItem
                  • getDataSource
                  • getDataValidator
                  • getDefaultStyle
                  • getDeleteRows
                  • getDirtyCells
                  • getDirtyRows
                  • getFloatingObjects
                  • getFloatingObjectZIndex
                  • getFormatter
                  • getFormula
                  • getFormulaInformation
                  • getFrozenColumnCount
                  • getFrozenRowCount
                  • getFrozenTrailingColumnCount
                  • getFrozenTrailingRowCount
                  • getGridlineOptions
                  • getInsertRows
                  • getIsProtected
                  • getName
                  • getNamedStyle
                  • getNamedStyles
                  • getParent
                  • getPictures
                  • getRow
                  • getRowCount
                  • getRowHeaderAutoText
                  • getRowHeaderAutoTextIndex
                  • getRowHeaderVisible
                  • getRowHeight
                  • getRowPageBreak
                  • getRowResizable
                  • getRows
                  • getRowVisible
                  • getSelections
                  • getSlicer
                  • getSlicers
                  • getSlicersFromTable
                  • getSpans
                  • getSparkline
                  • getStyle
                  • getStyleName
                  • getTables
                  • getTag
                  • getText
                  • getValue
                  • getViewportBottomRow
                  • getViewportHeight
                  • getViewportLeftColumn
                  • getViewportRightColumn
                  • getViewportTopRow
                  • getViewportWidth
                  • groupSparkline
                  • hasFormula
                  • hasPendingChanges
                  • hitTest
                  • invalidateLayout
                  • isColumnBound
                  • isEditing
                  • isPaintSuspended
                  • isValid
                  • moveTable
                  • moveTableByName
                  • moveTo
                  • printInfo
                  • protectionOption
                  • recalcAll
                  • referenceStyle
                  • removeCustomFunction
                  • removeCustomFunctionDescription
                  • removeCustomName
                  • removeFloatingObject
                  • removeKeyMap
                  • removeNamedStyle
                  • removePicture
                  • removeSlicer
                  • removeSpan
                  • removeSparkline
                  • removeTable
                  • removeTableByName
                  • repaint
                  • reset
                  • resizeTable
                  • resizeTableByName
                  • resumeCalcService
                  • resumeEvent
                  • rowFilter
                  • search
                  • selectionBackColor
                  • selectionBorderColor
                  • selectionPolicy
                  • selectionUnit
                  • setActiveCell
                  • setArray
                  • setArrayFormula
                  • setBindingPath
                  • setBorder
                  • setCellType
                  • setColumnCount
                  • setColumnHeaderAutoText
                  • setColumnHeaderAutoTextIndex
                  • setColumnHeaderVisible
                  • setColumnPageBreak
                  • setColumnResizable
                  • setColumnVisible
                  • setColumnWidth
                  • setComment
                  • setCsv
                  • setDataSource
                  • setDataValidator
                  • setDefaultStyle
                  • setFloatingObjectZIndex
                  • setFormatter
                  • setFormula
                  • setFrozenColumnCount
                  • setFrozenRowCount
                  • setFrozenTrailingColumnCount
                  • setFrozenTrailingRowCount
                  • setGridlineOptions
                  • setIsProtected
                  • setName
                  • setRowCount
                  • setRowHeaderAutoText
                  • setRowHeaderAutoTextIndex
                  • setRowHeaderVisible
                  • setRowHeight
                  • setRowPageBreak
                  • setRowResizable
                  • setRowVisible
                  • setSelection
                  • setSparkline
                  • setStyle
                  • setStyleName
                  • setTag
                  • setText
                  • setValue
                  • sheetTabColor
                  • showCell
                  • showColumn
                  • showColumnRangeGroup
                  • showRow
                  • showRowRangeGroup
                  • sortRange
                  • startEdit
                  • suspendCalcService
                  • suspendEvent
                  • tag
                  • toJSON
                  • unbind
                  • unbindAll
                  • undoManager
                  • ungroupSparkline
                  • visible
                  • zoom
                • Fields
                  • autoGenerateColumns
                  • colRangeGroup
                  • defaults
                  • keyMap
                  • rowRangeGroup
              • SheetTable
                • Overview
                • SheetTable Constructor
                • Methods
                  • autoGenerateColumns
                  • bandColumns
                  • bandRows
                  • bindColumns
                  • bindingPath
                  • dataRange
                  • filterButtonVisible
                  • footerIndex
                  • getColumnFormula
                  • getColumnName
                  • getColumnValue
                  • getSlicerData
                  • headerIndex
                  • highlightFirstColumn
                  • highlightLastColumn
                  • name
                  • range
                  • refresh
                  • rowFilter
                  • setColumnDataFormula
                  • setColumnFormula
                  • setColumnName
                  • setColumnValue
                  • showFooter
                  • showHeader
                  • style
              • Slicer
                • Overview
                • Slicer Constructor
                • Methods
                  • captionName
                  • columnCount
                  • disableResizingAndMoving
                  • itemHeight
                  • name
                  • showHeader
                  • showNoDataItems
                  • showNoDataItemsInLast
                  • sortState
                  • style
                  • visuallyNoDataItems
              • SlicerBorder
                • Overview
                • SlicerBorder Constructor
                • Methods
                  • borderColor
                  • borderStyle
                  • borderWidth
              • 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
              • Sparkline
                • Overview
                • Sparkline Constructor
                • Methods
                  • clone
                  • data
                  • dataOrientation
                  • dateAxisData
                  • dateAxisOrientation
                  • displayDateAxis
                  • group
                  • 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
                  • axisColor
                  • clone
                  • firstMarkerColor
                  • highMarkerColor
                  • lastMarkerColor
                  • lowMarkerColor
                  • markersColor
                  • negativeColor
                  • seriesColor
                  • showFirst
                  • showHigh
                  • showLast
                  • showLow
                  • showMarkers
                  • showNegative
                • Fields
                  • displayEmptyCellsAs
                  • displayHidden
                  • displayXAxis
                  • groupMaxValue
                  • groupMinValue
                  • lineWeight
                  • manualMax
                  • manualMin
                  • maxAxisType
                  • minAxisType
                  • rightToLeft
              • SpecificTextRule
                • Overview
                • SpecificTextRule Constructor
                • Methods
                  • reset
                • Fields
                  • operator
                  • text
              • Spread
                • Overview
                • Spread Constructor
                • Methods
                  • addCustomFunction
                  • addCustomFunctionDescription
                  • addCustomName
                  • addNamedStyle
                  • addSheet
                  • addSparklineEx
                  • allowSheetReorder
                  • allowUndo
                  • allowUserResize
                  • allowUserZoom
                  • autoFitType
                  • backColor
                  • backgroundImage
                  • backgroundImageLayout
                  • bind
                  • canUserDragDrop
                  • canUserDragFill
                  • canUserEditFormula
                  • clearCustomFunctionDescriptions
                  • clearCustomFunctions
                  • clearCustomNames
                  • clearSheets
                  • cutCopyIndicatorBorderColor
                  • cutCopyIndicatorVisible
                  • defaultDragFillType
                  • destroy
                  • doCommand
                  • enableFormulaTextbox
                  • focus
                  • fromJSON
                  • getActiveSheet
                  • getActiveSheetIndex
                  • getCalcService
                  • getCustomFunction
                  • getCustomFunctionDescription
                  • getCustomName
                  • getCustomNames
                  • getHost
                  • getNamedStyle
                  • getNamedStyles
                  • getSheet
                  • getSheetCount
                  • getSheetFromName
                  • getSheetIndex
                  • getTabStripRatio
                  • grayAreaBackColor
                  • hideSelection
                  • highlightInvalidData
                  • invalidateLayout
                  • isPaintSuspended
                  • newTabVisible
                  • nextControl
                  • previousControl
                  • print
                  • referenceStyle
                  • refresh
                  • removeCustomFunction
                  • removeCustomFunctionDescription
                  • removeCustomName
                  • removeNamedStyle
                  • removeSheet
                  • removeSparklineEx
                  • repaint
                  • resizeZeroIndicator
                  • resumeCalcService
                  • resumeEvent
                  • scrollbarMaxAlign
                  • scrollbarShowMax
                  • scrollIgnoreHidden
                  • search
                  • setActiveSheet
                  • setActiveSheetIndex
                  • setSheetCount
                  • setTabStripRatio
                  • showActiveCell
                  • showCell
                  • showColumn
                  • showDragDropTip
                  • showDragFillSmartTag
                  • showDragFillTip
                  • showHorizontalScrollbar
                  • showResizeTip
                  • showRow
                  • showScrollTip
                  • showVerticalScrollbar
                  • startSheetIndex
                  • suspendCalcService
                  • suspendEvent
                  • tabEditable
                  • tabNavigationVisible
                  • tabStripVisible
                  • toJSON
                  • unbind
                  • unbindAll
                  • useTouchLayout
                • Fields
                  • name
                  • sheets
                  • touchToolStrip
              • SpreadActions
                • Overview
                • SpreadActions Constructor
                • Methods
                  • cancelInput
                  • changeFormulaReference
                  • clear
                  • clearAndEditing
                  • commitArrayFormula
                  • commitInputNavigationDown
                  • commitInputNavigationUp
                  • copy
                  • cut
                  • moveToNextCell
                  • moveToNextCellThenControl
                  • moveToPreviousCell
                  • moveToPreviousCellThenControl
                  • navigationBottom
                  • navigationDown
                  • navigationEnd
                  • navigationEnd2
                  • navigationFirst
                  • navigationHome
                  • navigationHome2
                  • navigationLast
                  • navigationLeft
                  • navigationNextSheet
                  • navigationPageDown
                  • navigationPageUp
                  • navigationPreviousSheet
                  • navigationRight
                  • navigationTop
                  • navigationUp
                  • paste
                  • redo
                  • selectionBottom
                  • selectionDown
                  • selectionEnd
                  • selectionFirst
                  • selectionHome
                  • selectionLast
                  • selectionLeft
                  • selectionPageDown
                  • selectionPageUp
                  • selectionRight
                  • selectionTop
                  • selectionUp
                  • selectNextControl
                  • selectPreviousControl
                  • undo
              • SpreadSparkline
                • Overview
                • SpreadSparkline Constructor
              • SpreadTheme
                • Overview
                • SpreadTheme Constructor
                • Methods
                  • bodyFont
                  • colors
                  • headerFont
                  • name
              • SpreadThemes
                • Overview
                • SpreadThemes Constructor
                • Fields
                  • Apex
                  • Aspect
                  • Civic
                  • Concourse
                  • Default
                  • Equity
                  • Flow
                  • Foundry
                  • Median
                  • Metro
                  • Module
                  • Office
                  • Office2007
                  • Opulent
                  • Oriel
                  • Origin
                  • Paper
                  • Solstice
                  • Technic
                  • Trek
                  • Urban
                  • Verve
              • StackedSparkline
                • Overview
                • StackedSparkline Constructor
              • Style
                • Overview
                • Style Constructor
                • Methods
                  • clear
                  • compose
                  • copyFrom
                • Fields
                  • backColor
                  • backgroundImage
                  • backgroundImageLayout
                  • borderBottom
                  • borderLeft
                  • borderRight
                  • borderTop
                  • cellType
                  • font
                  • foreColor
                  • formatter
                  • hAlign
                  • imeMode
                  • locked
                  • name
                  • parentName
                  • shrinkToFit
                  • tabStop
                  • textDecoration
                  • textIndent
                  • themeFont
                  • validator
                  • vAlign
                  • watermark
                  • wordWrap
              • TableColumnInfo
                • Overview
                • TableColumnInfo Constructor
                • Methods
                  • dataField
                  • id
                  • name
              • TableSlicerData
                • Overview
                • TableSlicerData Constructor
                • Methods
                  • attachListener
                  • clearPreview
                  • detachListener
                  • doFilter
                  • doUnfilter
                  • getData
                  • getExclusiveData
                  • getExclusiveRowIndex
                  • getFilteredIndexes
                  • getFilteredOutIndexes
                  • getFilteredOutRanges
                  • getFilteredRanges
                  • getRowIndexes
                  • getTable
                  • refresh
              • TableStyle
                • Overview
                • TableStyle Constructor
                • Methods
                  • firstColumnStripSize
                  • firstColumnStripStyle
                  • firstFooterCellStyle
                  • firstHeaderCellStyle
                  • firstRowStripSize
                  • firstRowStripStyle
                  • footerRowStyle
                  • headerRowStyle
                  • highlightFirstColumnStyle
                  • highlightLastColumnStyle
                  • lastFooterCellStyle
                  • lastHeaderCellStyle
                  • name
                  • secondColumnStripSize
                  • secondColumnStripStyle
                  • secondRowStripSize
                  • secondRowStripStyle
                  • wholeTableStyle
              • TableStyleInfo
                • Overview
                • TableStyleInfo Constructor
                • Fields
                  • backColor
                  • borderBottom
                  • borderHorizontal
                  • borderLeft
                  • borderRight
                  • borderTop
                  • borderVertical
                  • font
                  • foreColor
                  • textDecoration
              • TableStyles
                • Overview
                • TableStyles Constructor
                • Methods
                  • addCustomStyles
                  • customStyles
                  • 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
                  • removeCustomStyle
                  • removeCustomStyleByName
              • TextCellType
                • Overview
                • TextCellType Constructor
              • TextCondition
                • Overview
                • TextCondition Constructor
                • Methods
                  • evaluate
                  • getExpected
                • Fields
                  • compareType
                  • expected
                  • formula
                  • ignoreBlank
                  • ignoreCase
                  • useWildCards
              • TextLengthCondition
                • Overview
                • TextLengthCondition Constructor
                • Methods
                  • evaluate
                  • getExpected
                  • reset
                • Fields
                  • compareType
                  • expected
                  • formula
                  • ignoreBlank
              • ThemeColor
                • Overview
                • ThemeColor Constructor
                • Methods
                  • accent1
                  • accent2
                  • accent3
                  • accent4
                  • accent5
                  • accent6
                  • background1
                  • background2
                  • followedHyperline
                  • getColor
                  • hyperline
                  • name
                  • textColor1
                  • textColor2
              • 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
              • ThreeScaleRule
                • Overview
                • ThreeScaleRule Constructor
                • Methods
                  • evaluate
                  • getMaximumColor
                  • getMaximumType
                  • getMaximumValue
                  • getMidpointColor
                  • getMidpointType
                  • getMidpointValue
                  • getMinimumColor
                  • getMinimumType
                  • getMinimumValue
                  • reset
                  • setMaximumColor
                  • setMaximumType
                  • setMaximumValue
                  • setMidpointColor
                  • setMidpointType
                  • setMidpointValue
                  • setMinimumColor
                  • setMinimumType
                  • setMinimumValue
              • Top10Condition
                • Overview
                • Top10Condition Constructor
                • Methods
                  • evaluate
                  • getExpected
                  • reset
                • Fields
                  • expected
                  • ignoreBlank
                  • ranges
                  • type
              • Top10Rule
                • Overview
                • Top10Rule Constructor
                • Methods
                  • reset
                • Fields
                  • rank
                  • type
              • 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
              • TwoScaleRule
                • Overview
                • TwoScaleRule Constructor
                • Methods
                  • evaluate
                  • getMaximumColor
                  • getMaximumType
                  • getMaximumValue
                  • getMinimumColor
                  • getMinimumType
                  • getMinimumValue
                  • reset
                  • setMaximumColor
                  • setMaximumType
                  • setMaximumValue
                  • setMinimumColor
                  • setMinimumType
                  • setMinimumValue
              • UniqueCondition
                • Overview
                • UniqueCondition Constructor
                • Methods
                  • evaluate
                  • getExpected
                  • reset
                • Fields
                  • expected
                  • ignoreBlank
                  • ranges
              • UniqueRule
                • Overview
                • UniqueRule Constructor
              • VariSparkline
                • Overview
                • VariSparkline Constructor
              • VBarSparkline
                • Overview
                • VBarSparkline Constructor
            • Enumerations
              • AutoFillType
              • AutoFitType
              • AverageConditionType
              • BarDirection
              • CheckBoxTextAlign
              • ClipboardPasteOptions
              • ColorCompareType
              • CommentState
              • ComparisonOperator
              • CopyToOption
              • CriteriaType
              • CustomValueType
              • DataBarAxisPosition
              • DataOrientation
              • DataValidationResult
              • DateCompareType
              • DateOccurringType
              • DisplayMode
              • EditorStatus
              • EditorValueType
              • EmptyValueStyle
              • ErrorStyle
              • FillDateUnit
              • FillDirection
              • FillSeries
              • FillType
              • FilterActionType
              • FormatMode
              • GeneralCompareType
              • GroupState
              • HeaderAutoText
              • HorizontalAlign
              • HorizontalPosition
              • HyperLinkTargetType
              • IconSetType
              • IconValueType
              • ImageLayout
              • ImeMode
              • InvalidOperationType
              • Key
              • LineStyle
              • NumberFormatType
              • PaperKind
              • PrintCentering
              • PrintPageOrder
              • PrintPageOrientation
              • PrintVisibilityType
              • QuarterType
              • RangeChangedAction
              • RangeGroupDirection
              • ReferenceStyle
              • RelationCompareType
              • ResizeZeroIndicator
              • RuleType
              • ScaleValueType
              • SearchFlags
              • SearchFoundFlags
              • SearchOrder
              • SelectionPolicy
              • SelectionUnit
              • SheetArea
              • ShowResizeTip
              • ShowScrollTip
              • SlicerDataChangeReason
              • SortState
              • SparklineAxisMinMax
              • SparklineType
              • StorageType
              • TextCompareType
              • TextComparisonOperator
              • TextDecorationType
              • TextFileOpenFlags
              • Top10ConditionType
              • VerticalAlign
              • VerticalPosition
              • VisualState
          • GcSpread.Sheets.Calc Namespace
            • Overview
            • Types
              • AsyncEvaluateContext
                • Overview
                • AsyncEvaluateContext Constructor
                • Methods
                  • SetAsyncResult
              • CalcArray
                • Overview
                • CalcArray Constructor
                • Methods
                  • getColumnCount
                  • getRowCount
                  • getValue
                  • getValueByIndex
                  • length
              • CalcError
                • Overview
                • CalcError Constructor
                • Methods
                  • parse
                  • toString
              • CalcService
                • Overview
                • CalcService Constructor
                • Methods
                  • getSourceModel
                  • recalculate
                  • recalculateAll
                  • recalculateByName
                  • removeSource
              • CalcSource
                • Overview
                • CalcSource Constructor
                • Methods
                  • getCalcService
                  • getCalcSourceModel
                  • getColumnCount
                  • getCustomFunction
                  • getCustomName
                  • getEvaluatorContext
                  • getName
                  • getParserContext
                  • getReference
                  • getRowCount
                  • getValue
                  • getValueByName
                  • isHiddenRow
                  • setArrayFormula
                  • setFormula
                  • setFormulaByName
                  • setValue
                  • setValueByName
              • CalcSourceModel
                • Overview
                • CalcSourceModel Constructor
                • Methods
                  • getCalcService
                  • getFormula
                  • getFormulaByName
                  • getSource
                  • setArrayFormula
                  • setFormula
                  • setFormulaByName
              • Errors
                • Overview
                • Errors Constructor
                • Fields
                  • DivideByZero
                  • Name
                  • NotAvailable
                  • Null
                  • Number
                  • Reference
                  • Value
              • EvaluateContext
                • Overview
                • EvaluateContext Constructor
                • Methods
                  • getFunction
                  • getName
                  • getReference
                  • getValue
              • Evaluator
                • Overview
                • Evaluator Constructor
                • Methods
                  • evaluateExpression
              • Expressions
                • Overview
                • Methods
                  • ArrayExpression
                  • BangCellExpression
                  • BangErrorExpression
                  • BangNameExpression
                  • BangRangeExpression
                  • BinaryOperatorExpression
                  • BooleanExpression
                  • CellExpression
                  • ConstantExpression
                  • DoubleExpression
                  • ErrorExpression
                  • Expression
                  • ExternalCellExpression
                  • ExternalErrorExpression
                  • ExternalNameExpression
                  • ExternalNameIdentityExpression
                  • ExternalRangeExpression
                  • ExternalReferenceExpression
                  • FunctionExpression
                  • MissingArgumentExpression
                  • NameExpression
                  • NameIdentityExpression
                  • OperatorExpression
                  • ParenthesesExpression
                  • RangeExpression
                  • ReferenceExpression
                  • SheetRangeErrorExpression
                  • SheetRangeExpression
                  • StringExpression
                  • StructReferenceExpression
                  • UnaryOperatorExpression
              • Functions
                • Overview
                • Methods
                  • AsyncFunction
                  • defineGlobalCustomFunction
                  • findGlobalFunction
                  • Function
                • Fields
                  • ArrayArgumentEvaluateMode
              • missingArgument
                • Overview
              • Operators
                • Overview
                • Methods
                  • BinaryOperator
                  • Operator
                  • UnaryOperator
              • Parser
                • Overview
                • Parser Constructor
                • Methods
                  • parse
                  • unparse
              • ParserContext
                • Overview
                • ParserContext Constructor
                • Methods
                  • getExternalSourceToken
              • Reference
                • Overview
                • Reference Constructor
                • Methods
                  • getColumn
                  • getColumnCount
                  • getRangeCount
                  • getRow
                  • getRowCount
                  • getSource
                  • getValue
                  • isHiddenRow
                  • isSubtotal
              • SheetReference
                • Overview
                • SheetReference Constructor
            • Enumerations
              • CalcValueType
              • RangeReferenceRelative
          • GcSpread.Sheets.Calc.Expressions Namespace
            • Overview
            • Types
              • ArrayExpression
                • Overview
                • ArrayExpression Constructor
              • BangCellExpression
                • Overview
                • BangCellExpression Constructor
              • BangErrorExpression
                • Overview
                • BangErrorExpression Constructor
              • BangNameExpression
                • Overview
                • BangNameExpression Constructor
              • BangRangeExpression
                • Overview
                • BangRangeExpression Constructor
              • BinaryOperatorExpression
                • Overview
                • BinaryOperatorExpression Constructor
              • BooleanExpression
                • Overview
                • BooleanExpression Constructor
              • CellExpression
                • Overview
                • CellExpression Constructor
                • Methods
                  • getRange
              • ConstantExpression
                • Overview
                • ConstantExpression Constructor
              • DoubleExpression
                • Overview
                • DoubleExpression Constructor
              • ErrorExpression
                • Overview
                • ErrorExpression Constructor
              • Expression
                • Overview
                • Expression Constructor
              • ExternalCellExpression
                • Overview
                • ExternalCellExpression Constructor
                • Methods
                  • getRange
              • ExternalErrorExpression
                • Overview
                • ExternalErrorExpression Constructor
              • ExternalNameExpression
                • Overview
                • ExternalNameExpression Constructor
              • ExternalNameIdentityExpression
                • Overview
                • ExternalNameIdentityExpression Constructor
              • ExternalRangeExpression
                • Overview
                • ExternalRangeExpression Constructor
                • Methods
                  • getRange
              • ExternalReferenceExpression
                • Overview
                • ExternalReferenceExpression Constructor
              • FunctionExpression
                • Overview
                • FunctionExpression Constructor
                • Methods
                  • argCount
                  • getArg
                  • getFunctionName
              • MissingArgumentExpression
                • Overview
                • MissingArgumentExpression Constructor
              • NameExpression
                • Overview
                • NameExpression Constructor
              • NameIdentityExpression
                • Overview
                • NameIdentityExpression Constructor
              • OperatorExpression
                • Overview
                • OperatorExpression Constructor
              • ParenthesesExpression
                • Overview
                • ParenthesesExpression Constructor
              • RangeExpression
                • Overview
                • RangeExpression Constructor
                • Methods
                  • getRange
              • ReferenceExpression
                • Overview
                • ReferenceExpression Constructor
                • Methods
                  • getRange
              • SheetRangeErrorExpression
                • Overview
                • SheetRangeErrorExpression Constructor
              • SheetRangeExpression
                • Overview
                • SheetRangeExpression Constructor
                • Methods
                  • getRange
              • StringExpression
                • Overview
                • StringExpression Constructor
              • StructReferenceExpression
                • Overview
                • StructReferenceExpression Constructor
              • UnaryOperatorExpression
                • Overview
                • UnaryOperatorExpression Constructor
          • GcSpread.Sheets.Calc.Functions Namespace
            • Overview
            • Types
              • AsyncFunction
                • Overview
                • AsyncFunction Constructor
                • Methods
                  • defaultValue
                  • evaluateAsync
              • Function
                • Overview
                • Function Constructor
                • Methods
                  • acceptsArray
                  • acceptsError
                  • acceptsMissingArgument
                  • acceptsReference
                  • evaluate
                  • findBranchArgument
                  • findTestArgument
                  • fromJSON
                  • isBranch
                  • isContextSensitive
                  • isVolatile
                  • toJSON
                  • toString
                • Fields
                  • typeName
            • Enumerations
              • ArrayArgumentEvaluateMode
          • GcSpread.Sheets.Calc.Operators Namespace
            • Overview
            • Types
              • BinaryOperator
                • Overview
                • BinaryOperator Constructor
                • Methods
                  • evaluate
              • Operator
                • Overview
                • Operator Constructor
                • Methods
                  • compareTo
                  • getName
              • UnaryOperator
                • Overview
                • UnaryOperator Constructor
                • Methods
                  • evaluate
          • GcSpread.Sheets.UndoRedo Namespace
            • Overview
            • Types
              • ActionBase
                • Overview
                • ActionBase Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • CellEditUndoAction
                • Overview
                • CellEditUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • ClearRangeValueUndoAction
                • Overview
                • ClearRangeValueUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • ClearValueUndoAction
                • Overview
                • ClearValueUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • ClipboardPasteFloatingObjectUndoAction
                • Overview
                • ClipboardPasteFloatingObjectUndoAction Constructor
                • Methods
                  • execute
                  • undo
              • ClipboardPasteRangeUndoAction
                • Overview
                • ClipboardPasteRangeUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • pasteOption
                  • pasteRange
                  • saveState
                  • undo
              • ClipboardPasteUndoAction
                • Overview
                • ClipboardPasteUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • ColumnAutoFitUndoAction
                • Overview
                • ColumnAutoFitUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • ColumnGroupExpandUndoAction
                • Overview
                • ColumnGroupExpandUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • ColumnGroupHeaderExpandUndoAction
                • Overview
                • ColumnGroupHeaderExpandUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • ColumnGroupUndoAction
                • Overview
                • ColumnGroupUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • ColumnResizeUndoAction
                • Overview
                • ColumnResizeUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • ColumnUngroupUndoAction
                • Overview
                • ColumnUngroupUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • DeleteFloatingObjectUndoAction
                • Overview
                • DeleteFloatingObjectUndoAction Constructor
                • Methods
                  • execute
                  • undo
              • DragCopyFloatingObjectUndoAction
                • Overview
                • DragCopyFloatingObjectUndoAction Constructor
                • Methods
                  • execute
                  • undo
              • DragDropExtent
                • Overview
                • DragDropExtent Constructor
                • Fields
                  • columnCount
                  • fromColumn
                  • fromRow
                  • rowCount
                  • toColumn
                  • toRow
              • DragDropUndoAction
                • Overview
                • DragDropUndoAction Constructor
                • Methods
                  • canExecute
                  • execute
                  • saveState
                  • undo
              • DragFillExtent
                • Overview
                • DragFillExtent Constructor
              • DragFillUndoAction
                • Overview
                • DragFillUndoAction Constructor
                • Methods
                  • canExecute
                  • execute
                  • saveState
                  • undo
              • FloatingObjectExtent
                • Overview
                • FloatingObjectExtent Constructor
              • FloatingObjectUndoActionBase
                • Overview
                • FloatingObjectUndoActionBase Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • saveState
              • GroupExpandExtent
                • Overview
                • GroupExpandExtent Constructor
              • GroupExtent
                • Overview
                • GroupExtent Constructor
                • Fields
                  • count
                  • index
              • GroupHeaderExpandExtent
                • Overview
                • GroupHeaderExpandExtent Constructor
              • MovingFloatingObjectExtent
                • Overview
                • MovingFloatingObjectExtent Constructor
              • MovingFloatingObjectUndoAction
                • Overview
                • MovingFloatingObjectUndoAction Constructor
                • Methods
                  • execute
                  • undo
              • PasteExtent
                • Overview
                • PasteExtent Constructor
              • PasteRangeExtent
                • Overview
                • PasteRangeExtent Constructor
              • ResizingFloatingObjectUndoAction
                • Overview
                • ResizingFloatingObjectUndoAction Constructor
                • Methods
                  • execute
                  • undo
              • ReszingFloatingObjectExtent
                • Overview
                • ReszingFloatingObjectExtent Constructor
              • RowAutoFitUndoAction
                • Overview
                • RowAutoFitUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • RowGroupExpandUndoAction
                • Overview
                • RowGroupExpandUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • RowGroupHeaderExpandUndoAction
                • Overview
                • RowGroupHeaderExpandUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • RowGroupUndoAction
                • Overview
                • RowGroupUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • RowResizeUndoAction
                • Overview
                • RowResizeUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • RowUngroupUndoAction
                • Overview
                • RowUngroupUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • SheetRenameUndoAction
                • Overview
                • SheetRenameUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
              • ZoomUndoAction
                • Overview
                • ZoomUndoAction Constructor
                • Methods
                  • canExecute
                  • canUndo
                  • execute
                  • saveState
                  • undo
          • GcSpread.Slicer Namespace
            • Overview
            • Types
              • GeneralSlicerData
                • Overview
                • GeneralSlicerData Constructor
                • Methods
                  • addRows
                  • aggregateData
                  • attachListener
                  • changeColumnName
                  • changeData
                  • clearPreview
                  • detachListener
                  • doFilter
                  • doUnfilter
                  • getColumnIndex
                  • getData
                  • getExclusiveData
                  • getExclusiveRowIndex
                  • getFilteredIndexes
                  • getFilteredOutIndexes
                  • getFilteredOutRanges
                  • getFilteredOutRowIndexes
                  • getFilteredRanges
                  • getFilteredRowIndexes
                  • getRowIndexes
                  • inPreview
                  • onFiltered
                  • removeColumns
                  • removeRows
                  • resumeFilteredEvents
                  • suspendFilteredEvents
                • Fields
                  • columnNames
                  • data
              • SlicerDataItem
                • Overview
                • SlicerDataItem Constructor
                • Fields
                  • columnName
                  • data
                  • rowIndex
            • Enumerations
              • SlicerAggregateType