policy

sheet name tabs

allowing

Tab key

appearance

sheet corner

automatic text

headers

buttons

setting type

colors

scroll bars

compound files

opening

data

saving to files

data binding

adding unbound row

displaying

pager
scroll bars

importing

Spread settings

labels

headers

loading

from Spread XML files

look and feel
modes

setting

navigation

page advancing
position

pager

position

setting

button type

settings

scroll bar colors

sheets

appearance

tool bars

hierarchy

<$nopage>appearance

See also styles

<$nopage>deleting, See removing
<$nopage>deleting, See removing
<$nopage>displaying, See hiding
<$nopage>displaying, See hiding
A1 setting (ReferenceStyle enum)
Abort Property
About Property
AbsFunction Field
AcceptAMPM Property
AcceptNegative Property
AcceptsError Method
AcceptsMissingArgument Method
AcceptsReference Method
AcceptsReferenceReturn Method
AccessKey Property (ButtonCellType)
AccessKey Property (ButtonRenderer)
AccessKey Property (ChartMapArea)
AccessKey Property (CheckBoxCellType)
AccessKey Property (CheckBoxEditor)
AccrIntFunction Field
AccrIntMFunction Field
AcosFunction Field
AcoshFunction Field
active

cell
cell type of active cell
sheet
skin

active cell

importing
importing

Active setting (ImeMode enumeration)
active, column
active, row
active, sheet
active, sheet
active, sheet tab
active, sheet tab
active, skin
ActiveChart Property
ActiveCol, client-side
ActiveColumn Property
ActiveCssClass Property
ActiveRow Property
ActiveRow, client-side
ActiveRowChanged Event
ActiveSheetChanged Event
ActiveSheetView Property
ActiveSheetViewIndex Property
ActiveSkin Property
ActiveSpread command (client-side)
ActiveTabBackColor Property
ActiveTabBorderColor Property
Add command (client-side)
Add Method (AreaSeriesCollection)
Add Method (BarSeriesCollection)
Add Method (BaseSheetSpanModel)
Add Method (BevelCollection)
Add Method (Column)
Add Method (Columns)
Add Method (ConditionalFormatCollection)
Add Method (ConditionalFormatting)
Add Method (ConditionalFormattingModel)
Add Method (DefaultSheetSpanModel)
Add Method (DefaultSparklineContainer)
Add Method (DefaultStyleCollection)
Add Method (DetachmentCollection)
Add Method (DoubleCollection)
Add Method (DoubleCollectionCollection)
Add Method (ExcelSparklineGroup)
Add Method (FillCollection)
Add Method (FilterColumnDefinitionCollection)
Add Method (FilterItemCollection)
Add Method (FilterItemValueCollection)
Add Method (GroupInfoCollection)
Add Method (IMovable)
Add Method (ISheetSpanModel)
Add Method (LabelAreaCollection)
Add Method (LayoutColumns)
Add Method (LayoutRows)
Add Method (LegendAreaCollection)
Add Method (LightCollection)
Add Method (LineCollection)
Add Method (LineSeriesCollection)
Add Method (MarkerCollection)
Add Method (NamedStyleCollection)
Add Method (PlotAreaCollection)
Add Method (PointSeriesCollection)
Add Method (PolarRadiusAxisCollection)
Add Method (RadarValueAxisCollection)
Add Method (Row)
Add Method (Rows)
Add Method (SeriesCollection)
Add Method (SheetViewCollection)
Add Method (SmartPrintRulesCollection)
Add Method (SpreadChartCollection)
Add Method (SpreadDataColumnCollection)
Add Method (StringCollection)
Add Method (StripeCollection)
Add Method (ValueAxisCollection)
Add Method (WorksheetTemplate)
Add, client-side
AddChart Method
AddColumn Method (DefaultRowFilter)
AddColumn Method (DefaultSheetDataModel)
AddColumn Method (IRowFilter)
AddColumns Method (ConditionalFormattingModel)
AddColumns Method (DefaultSheetDataModel)
AddColumns Method (DefaultSparklineContainer)
AddColumns Method (IRangeSupport)
AddColumns Method (SheetView)
AddCustomFunction Method (DefaultSheetDataModel)
AddCustomFunction Method (ICustomFunctionSupport)
AddCustomName Method (DefaultSheetDataModel)
AddCustomName Method (ICustomNameSupport)
adding

cell reference
cell spans
columns
data to sheet
formula to sheet
notes
rows
selections
styles
tags

adding spans
adding Spread component

tutorials

adding, cell span
adding, columns
adding, columns
adding, columns
adding, custom function
adding, custom name
adding, rows
adding, rows
adding, rows
adding, rows to data source
adding, rows to data source
adding, unbound rows
adding, unbound rows
AddKeyMap, client-side
AddNewCore Method
AddOperator Field
AddRange Method (AreaSeriesCollection)
AddRange Method (BarSeriesCollection)
AddRange Method (BevelCollection)
AddRange Method (ConditionalFormatting)
AddRange Method (DetachmentCollection)
AddRange Method (DoubleCollection)
AddRange Method (DoubleCollectionCollection)
AddRange Method (FillCollection)
AddRange Method (GroupInfoCollection)
AddRange Method (LabelAreaCollection)
AddRange Method (LegendAreaCollection)
AddRange Method (LightCollection)
AddRange Method (LineCollection)
AddRange Method (LineSeriesCollection)
AddRange Method (MarkerCollection)
AddRange Method (NamedStyleCollection)
AddRange Method (PlotAreaCollection)
AddRange Method (PointSeriesCollection)
AddRange Method (PolarRadiusAxisCollection)
AddRange Method (RadarValueAxisCollection)
AddRange Method (SeriesCollection)
AddRange Method (SheetCellRangeCollection)
AddRange Method (SheetViewCollection)
AddRange Method (SpreadChartCollection)
AddRange Method (StringCollection)
AddRange Method (StripeCollection)
AddRange Method (ValueAxisCollection)
AddressFunction Field
AddRow Method
AddRows Method (ConditionalFormattingModel)
AddRows Method (DefaultSheetDataModel)
AddRows Method (DefaultSparklineContainer)
AddRows Method (IRangeSupport)
AddRows Method (SheetView)
AddRowToDataSource Method (DefaultSheetDataModel)
AddRowToDataSource Method (IUnboundRowSupport)
AddRowToDataSource Method (SheetView)
AddSelection Method (BaseSheetSelectionModel)
AddSelection Method (DefaultSheetSelectionModel)
AddSelection Method (ISheetSelectionModel)
AddSelection, client-side
AddSpanCell Method
AddSparkline Method
AddSparklineToGroup Method (DefaultSparklineContainer)
AddSparklineToGroup Method (ISparklineContainer)
AddSquareSparkline Method
AddUnboundRows Method (DefaultSheetDataModel)
AddUnboundRows Method (IUnboundRowSupport)
AddUnboundRows Method (SheetView)
AdjustSplittingConditionalFormattings Method (ConditionalFormattingModel)
AdjustSplittingConditionalFormattings Method (IConditionalFormattingModel)
AfterChanged Event
Aggregate Event (DefaultSheetDataModel)
Aggregate Event (FpSpread)
Aggregate Event (GroupDataModel)
Aggregate Event (IAggregationSupport)
AggregateArgs Class

Members
Overview

AggregateArgs Constructor (AggregateArgs)
AggregateEventHandler Delegate
AggregationType Enumeration
AggregationType Property (AggregateArgs)
AggregationType Property (Column)
AgressiveDataViewCreating Property
AJAX

browser support
automatic-completion cell type
check box cell type
combo box cell type
date with calendar cell type
extenders
filtered text cell type
masked edit cell type
mutually exclusive check box cell type
numeric up-down cell type
overview
rating cell type
slide show cell type
slider cell type
support
text box with watermark cell type

AJAX, enabling
AjaxCellTypeBase Class

Members
Overview

AjaxCellTypeBase Constructor (AjaxCellTypeBase)
AjaxComboBoxCellType Class

Members
Overview

AjaxComboBoxCellType Constructor (AjaxComboBoxCellType)
Align Property (HierBarInfo)
Align Property (PagerInfo)
alignment

importing
importing
setting for cell contents

alignment, horizontal
alignment, horizontal
alignment, horizontal
alignment, vertical
alignment, vertical
alignment, vertical
AlignmentX Property (LabelArea)
AlignmentX Property (LegendArea)
AlignmentY Property (LabelArea)
AlignmentY Property (LegendArea)
All (filtering list item)
All (filtering list item)
All setting (PrintType enum)
All setting (ResetOption enum)
AllowClientUnlock Property
AllowColumnMove Property
AllowDBNull Property
AllowDelete Property
AllowGetAllHiddenValue Property
AllowGroup Property
AllowHeaderResize Property
allowing, deleting rows
allowing, grouping
allowing, header resize
allowing, inserting rows
allowing, load on demand
allowing, load on demand
allowing, load on demand
allowing, load on demand
allowing, load on demand
allowing, load on demand
allowing, page number display
allowing, resizing
allowing, resizing
allowing, resizing
allowing, resizing header
allowing, sorting
allowing, user formulas
AllowInsert Property
AllowLoadOnDemand Property (FpSpread)
AllowLoadOnDemand Property (SheetView)
AllowPage Property
AllowParallel Property
AllowServerValidators Property (GeneralCellType)
AllowServerValidators Property (IAcceptServerValidator)
AllowServerValidators Property (TextCellType)
AllowSort Property
AllowTableCorner Property
AllowUserFormulas Property
AllowVirtualScrollPaging Property
AllowWrap Property (ButtonCellType)
AllowWrap Property (ButtonRenderer)
AllowWrap Property (ComboBoxCellType)
AllowWrap Property (DefaultRenderer)
AllowWrap Property (GeneralCellType)
AllowWrap Property (HyperLinkCellType)
AllowWrap Property (HyperLinkRenderer)
AllowWrap Property (IWrapableRenderer)
AllowWrap Property (LabelCellType)
AllowWrap Property (TextCellType)
AllString Property (DefaultRowFilter)
AllString Property (IRowFilter)
AlternateText Property (ChartMapArea)
AlternateText Property (FpChart)
AlternateText Property (ImageCellType)
AlternateText Property (ImageRenderer)
alternating rows
alternating rows
alternating rows, parent
alternating rows, parent
AlternatingRow Class

Members
Overview

AlternatingRows Class

Members
Overview

AlternatingRows Property (ColumnFooter)
AlternatingRows Property (ColumnHeader)
AlternatingRows Property (RowHeader)
AlternatingRows Property (SheetCorner)
AlternatingRows Property (SheetView)
AltRowCount Property (BaseSheetStyleModel)
AltRowCount Property (DefaultSheetStyleModel)
AltRowCount Property (ISheetStyleModel)
Always setting (MergePolicy enum)
Always setting (MergePolicy enum)
Always setting (MergePolicy enum)
Always setting (MergePolicy enum)
Always setting (MergePolicy enum)
Always setting (ScrollBarPolicy enum)
Always setting (TabControlPolicy enum)
AmbientColor Property
AmordegrcFunction Field
AmorlincFunction Field
anchor cells
And Property
AndFunction Field
Animated Property
Any Field
appearance

cell settings
conditional format
grouping affect on
headers
overall component
rows and columns
See also styles
selections
settings in general
sheet

Appearance Class

Members
Overview

Appearance Constructor (Appearance)
appearance, background color
appearance, background color
appearance, text color
appearance, text color
appearance, text color
appearance, text color
AppearanceItemsUpdated setting (SheetAxisModelEventType enum)
AppearanceProperty Class

Members
Overview

AppearanceProperty Constructor (AppearanceProperty)
AppendEllipsis Method
application-specific tags
Apply Method
ApplyAttributes Method
ApplyBorder Method
ApplyStyleTo Method (BaseCellType)
ApplyStyleTo Method (BaseEditor)
ApplyStyleTo Method (BaseRenderer)
Area Property
AreaBorder Property (AreaSeries)
AreaBorder Property (HighLowAreaSeries)
AreaBorder Property (PolarAreaSeries)
AreaBorder Property (RadarAreaSeries)
AreaBorders Property (AreaSeries)
AreaBorders Property (HighLowAreaSeries)
AreaBorders Property (PolarAreaSeries)
AreaBorders Property (RadarAreaSeries)
AreaFill Property (AreaSeries)
AreaFill Property (HighLowAreaSeries)
AreaFill Property (PolarAreaSeries)
AreaFill Property (RadarAreaSeries)
AreaFills Property (AreaSeries)
AreaFills Property (HighLowAreaSeries)
AreaFills Property (PolarAreaSeries)
AreaFills Property (RadarAreaSeries)
AreaIndex Property
AreaSeries Class

Members
Overview

AreaSeries Constructor (AreaSeries)
AreaSeriesCollection Class

Members
Overview

AreaShape Enumeration
Arg Property (ParenthesesExpression)
Arg Property (UnaryOperatorExpression)
Arg0 Property
Arg1 Property
ArgCount Property
arguments, missing
arguments, optional
arranging

columns
rows

ArrayExpression Class

Members
Overview

ArrayExpression Constructor (ArrayExpression)
arrays, formulas
arrays, support
ArraySegmentData Class

Members
Overview

ArraySegmentData Constructor (ArraySegmentData)
ArrayValue Property
ArrowImageUrl Property
arrows, scroll bar colors
Ascending Property (Group)
Ascending Property (SortInfo)
Ascending setting (SortIndicator enum)
ASCII files

saving

AsDisplayed setting (PrintNotes enum)
AsinFunction Field
AsinhFunction Field
AsNeeded setting (ScrollBarPolicy enum)
AsNeeded setting (TabControlPolicy enum)
ASP.NET AJAX

automatic-completion cell type
check box cell type
combo
date with calendar cell type
filtered text cell type
masked edit cell type
mutually exclusive check box cell type
numeric up-down cell type
rating cell type
slide show cell type
slider cell type
text box with watermark cell type

ASP.NET spreadsheet component
ASPX page requests
ASPX page requests
assemblies, FarPoint.Web.Spread
assigning

cell types for bound data
CSS to cell

Atan2Function Field
AtanFunction Field
AtanhFunction Field
AtEnd setting (PrintNotes enum)
ATLAS (see AJAX)
attaching

CSS to cell

AttachObjectExpression Method
Attributes Property
Auto setting (CursorType enum)
Auto setting (ImeMode enumeration)
Auto setting (PrintOrientation enum)
Auto setting (PrintPageOrder)
AutoCalculation Property (DefaultSheetDataModel)
AutoCalculation Property (ICalculationSupport)
AutoCalculation Property (SheetView)
AutoComplete Property
AutoCompleteCellType Class

Members
Overview

AutoCompleteCellType Constructor (AutoCompleteCellType)
AutoCompleteMode Property
AutoCompleteValue Property
AutoFilterColumn Method
AutoFilteredColumn Event
AutoFilteredColumnEventArgs Class

Members
Overview

AutoFilteredColumnEventArgs Constructor (AutoFilteredColumnEventArgs)
AutoFilteredColumnEventHandler Delegate
AutoFilterIndex Field
AutoFilterIndex Property (Column)
AutoFilterIndex Property (ColumnHeader)
AutoFilterIndexChanged Event
AutoFilterIndexChangedEventArgs Class

Members
Overview

AutoFilterIndexChangedEventArgs Constructor (AutoFilterIndexChangedEventArgs)
AutoFilterIndexChangedEventHandler Delegate
AutoFilteringColumn Event
AutoFilteringColumnEventArgs Class

Members
Overview

AutoFilteringColumnEventArgs Constructor (AutoFilteringColumnEventArgs)
AutoFilteringColumnEventHandler Delegate
AutoFilterMode Enumeration
AutoFilterMode Property
AutoFilterReset Method
autofit
AutoGenerateColumns Property (DefaultSheetDataModel)
AutoGenerateColumns Property (IDataSourceSupport)
AutoGenerateColumns Property (SheetView)
AutoGenerateMapAreaToolTip Property
AutoLabelUnit Property (IndexAxis)
AutoLabelUnit Property (PolarAngleAxis)
AutoLabelUnit Property (PolarRadiusAxis)
AutoLabelUnit Property (RadarIndexAxis)
AutoLabelUnit Property (RadarValueAxis)
AutoLabelUnit Property (ValueAxis)
AutoMajorUnit Property (IndexAxis)
AutoMajorUnit Property (PolarAngleAxis)
AutoMajorUnit Property (PolarRadiusAxis)
AutoMajorUnit Property (RadarIndexAxis)
AutoMajorUnit Property (RadarValueAxis)
AutoMajorUnit Property (ValueAxis)
automatic cell type assignment
automatic completion cell type
automatic merging
automatic text
automatic, cell type assignment
automatic, column generation
automatic, header text
automatic, merging
automatic, merging
automatic, merging
automatic, merging
automatic, merging
automatic, postback
automatic, postback
automatic, postback
automatic, postback
automatic, postback
automatic, postback
automatic, postback
automatic, recalculation
automatic, recalculation
automatic, text
automatic, text
automatic, text
automatic, text
automatic, text
automatic, text
automatic, text
automatic, text
automatic, text
automatic, text
automatic, text
automatic, text
automatic, text
automatic, text
automatically merging cells
automatically merging cells
automatically merging cells
automatically merging cells
automatically merging cells
automatically merging cells
automatic-completion cell type
AutoMaximum Property (IndexAxis)
AutoMaximum Property (PolarRadiusAxis)
AutoMaximum Property (RadarValueAxis)
AutoMaximum Property (ValueAxis)
AutoMinimum Property (IndexAxis)
AutoMinimum Property (PolarRadiusAxis)
AutoMinimum Property (RadarValueAxis)
AutoMinimum Property (ValueAxis)
AutoMinorUnit Property (IndexAxis)
AutoMinorUnit Property (PolarAngleAxis)
AutoMinorUnit Property (PolarRadiusAxis)
AutoMinorUnit Property (RadarIndexAxis)
AutoMinorUnit Property (RadarValueAxis)
AutoMinorUnit Property (ValueAxis)
AutoOrigin Property (AreaSeries)
AutoOrigin Property (BarSeries)
AutoOrigin Property (ClusteredBarSeries)
AutoPlay Property
AutoPostBack Property (AjaxComboBoxCellType)
AutoPostBack Property (CheckBoxCellType)
AutoPostBack Property (CheckBoxEditor)
AutoPostBack Property (ComboBoxCellType)
AutoPostBack Property (ComboBoxEditor)
AutoPostBack Property (IAutoPostBack)
AutoPostBack Property (MenuItem)
AutoPostBack Property (MultiColumnEditor)
AutoPostBack Property (SheetView)
AutoPostBack Property (TouchStripItem)
AutoText Property (ColumnHeader)
AutoText Property (RowHeader)
AutoTextIndex Property (ColumnHeader)
AutoTextIndex Property (RowHeader)
AveDevFunction Field
AverageAFunction Field
AverageConditionalFormattingRule Class

Members
Overview

AverageConditionalFormattingRule Constructor (AverageConditionalFormattingRule)
AverageFunction Field
AverageIfFunction Field
AverageIfsFunction Field
AverageValue Property
Avg setting (AggregationType enum)
axis
axis
Axis Class

Members
Overview

axis model
axis model
axis model
axis model, base
axis model, column
axis model, default
axis model, event arguments
axis model, headers
axis model, headers
axis model, interface
axis model, properties
AxisColor Property (DatabarConditionalFormattingRule)
AxisColor Property (ExcelSparklineSetting)
AxisId Property (PolarRadiusAxis)
AxisId Property (RadarValueAxis)
AxisId Property (ValueAxis)
AxisLocation Enumeration
AxisPosition Property
Azure
BackColor Field (AppearanceProperty)
BackColor Field (SheetStyleProperty)
BackColor Property (AjaxComboBoxCellType)
BackColor Property (AlternatingRow)
BackColor Property (Appearance)
BackColor Property (ButtonCellType)
BackColor Property (ButtonRenderer)
BackColor Property (CalendarDropDownStyleInfo)
BackColor Property (Cell)
BackColor Property (Column)
BackColor Property (ComboBoxCellType)
BackColor Property (ComboBoxEditor)
BackColor Property (CommandBarInfo)
BackColor Property (ContextMenuStyle)
BackColor Property (FpSpread)
BackColor Property (GroupInfo)
BackColor Property (HierBarInfo)
BackColor Property (HighlightConditionalFormattingRule)
BackColor Property (HighlightConditionalFormattingStyle)
BackColor Property (NamedStyle)
BackColor Property (PagerInfo)
BackColor Property (PreviewRowInfo)
BackColor Property (Row)
BackColor Property (SheetSkin)
BackColor Property (SheetView)
BackColor Property (StyleInfo)
BackColor Property (TagCloudCellType)
BackColor Property (TagCloudRenderer)
BackColor Property (TitleInfo)
BackColorFilterSupport Property
background

cell color

Background Class

Members
Overview

background colors
background colors
background colors
background colors, active tab
background colors, alternating rows
background colors, appearance
background colors, cells
background colors, cells
background colors, columns
background colors, FarPoint Spread component
background colors, list box
background colors, locked cells
background colors, rows
background colors, selections
background colors, sheet
background colors, sheet
background colors, styles
Background Constructor (Background)
Background Field
Background Property (AlternatingRow)
Background Property (Cell)
Background Property (Column)
Background Property (CommandBarInfo)
Background Property (GroupInfo)
Background Property (NamedStyle)
Background Property (PreviewRowInfo)
Background Property (Row)
Background Property (StyleInfo)
Background Property (TitleInfo)
BackgroundAttachment Property
BackgroundImageUrl Property
BackgroundPosition Property
BackgroundRepeat Property
BackWall Property (PolarPlotArea)
BackWall Property (RadarPlotArea)
BackWall Property (XYPlotArea)
BackWall Property (XYZPlotArea)
BackWall Property (YPlotArea)
bar, grouping
bar, grouping
bar, grouping
bar, grouping
bar, grouping
BarBorder Property (BarSeries)
BarBorder Property (HighLowBarSeries)
BarBorders Property (BarSeries)
BarBorders Property (HighLowBarSeries)
BarFill Property (BarSeries)
BarFill Property (HighLowBarSeries)
BarFills Property (BarSeries)
BarFills Property (HighLowBarSeries)
bars

grouping

bars, command
bars, command
bars, hierarchy
bars, hierarchy
bars, page navigation
bars, page navigation
BarSeries Class

Members
Overview

BarSeries Constructor (BarSeries)
BarSeriesCollection Class

Members
Overview

BarShape Enumeration
BarShape Property (BarSeries)
BarShape Property (HighLowBarSeries)
base cell type
base cell type
base classes, expressions
base color, scroll bars
base models
base, operators
BaseCellType Class

Members
Overview

BaseDropDownCellType Class

Members
Overview

BaseEditor Class

Members
Overview

BaseFilterItem Class

Members
Overview

BaseRenderer Class

Members
Overview

BaseSheetAxisModel Class

Members
Overview

BaseSheetDataModel Class

Members
Overview

BaseSheetSelectionModel Class

Members
Overview

BaseSheetSpanModel Class

Members
Overview

BaseSheetStyleModel Class

Members
Overview

BaseSparkline Class

Members
Overview

BeforeRenderMapAreas Event
BeforeRenderMapAreasEventArgs Class

Members
Overview

BeforeRenderMapAreasEventArgs Constructor (BeforeRenderMapAreasEventArgs)
BeforeRenderMapAreasHandler Delegate
BeginEdit Method
BeginInit Method
BeginProcessRequest Method
BesselIFunction Field
BesselJFunction Field
BesselKFunction Field
BesselYFunction Field
BestFitCols Property
BestFitColumnRule Class

Members
Overview

BestFitColumnRule Constructor (BestFitColumnRule)
BestFitRows Property
BetaDistFunction Field
BetaInvFunction Field
Between setting (ComparisonOperator enum)
BetweenValuesConditionalFormattingRule Class

Members
Overview

BetweenValuesConditionalFormattingRule Constructor (BetweenValuesConditionalFormattingRule)
Bevel Class

Members
Overview

BevelCollection Class

Members
Overview

BevelCollection Constructor (BevelCollection)
BIFF8
BIFF8
BIFF8 file format
BIFF-compatible files

opening
saving to

BIFF-compatible files, saving to
BIFF-compatile files, opening
BiffStreamError setting (ExcelExceptionCode enum)
Bin2DecFunction Field
Bin2HexFunction Field
Bin2OctFunction Field
Binary Interchange File Format
Binary Interchange File Format
binary operator
BinaryOperatorExpression Class

Members
Overview

BinaryOperatorExpression Constructor (BinaryOperatorExpression)
BinaryOperatorInfo Class

Members
Overview

binding

to data set

binding to data set
binding to data set

hierarchy display
limiting postbacks
managing

binding to data sets, assigning cell types
binding to data sets, data member
binding to data sets, data member
binding to data sets, data model
binding to data sets, data source
binding to data sets, data source
binding to database

tutorial

binding, data binding property
BindModel Method
BinomDistFunction Field
blank area, colors
Blank setting (FilterListBehavior enum)
Blank setting (HeaderAutoText enum)
BlankConditionalFormattingRule Class

Members
Overview

BlankConditionalFormattingRule Constructor (BlankConditionalFormattingRule)
Blanks (filtering list item)
Blanks (filtering list item)
BlanksString Property (DefaultRowFilter)
BlanksString Property (IRowFilter)
BooleanExpression Class

Members
Overview

BooleanExpression Constructor (BooleanExpression)
BooleanValue Property
Border Class

Members
Overview

Border Constructor (Border)
Border Field
Border Property (AlternatingRow)
Border Property (Cell)
Border Property (Column)
Border Property (ContextMenuStyle)
Border Property (GroupInfo)
Border Property (HighlightConditionalFormattingRule)
Border Property (HighlightConditionalFormattingStyle)
Border Property (LabelArea)
Border Property (LegendArea)
Border Property (NamedStyle)
Border Property (PreviewRowInfo)
Border Property (Row)
Border Property (StyleInfo)
Border Property (TitleInfo)
Border Property (Wall)
border styles

importing from Excel file
importing from Excel file

BorderColor Field
BorderColor Property (Border)
BorderColor Property (DatabarConditionalFormattingRule)
BorderColor Property (SpreadChart)
BorderColorBottom Field
BorderColorBottom Property
BorderColorLeft Field
BorderColorLeft Property
BorderColorRight Field
BorderColorRight Property
BorderColorTop Field
BorderColorTop Property
BorderProperty Class

Members
Overview

BorderProperty Constructor (BorderProperty)
borders
borders
borders

importing
importing
selection

borders, focus rectangle
borders, focus rectangle
borders, PDF support
borders, selection
borders, tabs
borders,header default
BorderSize Field
BorderSize Property
BorderSizeBottom Field
BorderSizeBottom Property
BorderSizeLeft Field
BorderSizeLeft Property
BorderSizeRight Field
BorderSizeRight Property
BorderSizeTop Field
BorderSizeTop Property
BorderStyle Field
BorderStyle Property (Border)
BorderStyle Property (SpreadChart)
BorderStyleBottom Field
BorderStyleBottom Property
BorderStyleLeft Field
BorderStyleLeft Property
BorderStyleRight Field
BorderStyleRight Property
BorderStyleTop Field
BorderStyleTop Property
BorderWidth Property
Both setting (Centering enum)
Both setting (PagerMode enum)
BothCustomOnly setting (IncludeHeaders enum)
bottom margin
Bottom Property (Inset)
Bottom Property (PaddingF)
Bottom Property (PrintMargin)
Bottom setting (PagerPosition enum)
BottomBevel Property (BarSeries)
BottomBevel Property (HighLowBarSeries)
BottomBevel Property (PieSeries)
BottomBevels Property (BarSeries)
BottomBevels Property (HighLowBarSeries)
BottomBevels Property (PieSeries)
BottomWall Property (XYPlotArea)
BottomWall Property (XYZPlotArea)
BottomWall Property (YPlotArea)
bound cells, asssigning cell type
bound data
bound data

limiting postbacks

bound spreadsheet
BoundControl Property
Bounds Property
Browse button
browsers

downlevel
support
uplevel

BubbleSize Property
built-in

CallBack commands

built-in functions
built-in skins
built-in skins
BuiltinMarker Class

Members
Overview

BuiltinMarker Constructor (BuiltinMarker)
button (cell)

hypertext link
image

button cell type
button cell type
button cell type
ButtonCellType Class

Members
Overview

ButtonCellType Constructor (ButtonCellType)
ButtonCommand Event
ButtonFaceColor Property
ButtonHighlightColor Property
ButtonRenderer Class

Members
Overview

ButtonRenderer Constructor (ButtonRenderer)
buttons
buttons

changing images in command bar
command
hiding in command bar
hierarchy
page navigation
page navigation
print button

buttons, cancel
buttons, cell type
buttons, cell type constructors
buttons, color
buttons, color
buttons, color
buttons, color
buttons, command
buttons, command
buttons, command bar
buttons, create
buttons, delete
buttons, edit
buttons, hiding
buttons, insert
buttons, labels
buttons, renderer
buttons, scroll bars
buttons, setting type
buttons, text
buttons, type
buttons, update
buttons,event handler
ButtonShadowColor Property
ButtonTextColor Property
ButtonType Enumeration
ButtonType Property (ButtonCellType)
ButtonType Property (ButtonRenderer)
ButtonType Property (CommandBarInfo)
ButtonType Property (PagerInfo)
CalcArray Class

Members
Overview

CalcConvert Class

Members
Overview

CalcError Class

Members
Overview

CalcMissingArgument Class

Members
Overview

CalcMissingArgument Constructor (CalcMissingArgument)
CalcReference Class

Members
Overview

calculation, errors
calendar cell type
CalendarDropDownStyleInfo Class

Members
Overview

CalendarDropDownStyleInfo Constructor (CalendarDropDownStyleInfo)
CalendarType Enumeration
CalendarType Property
callback

custom commands
events
events
method

CallBack, client-side
Cancel command (client-side)
Cancel Property (AutoFilteringColumnEventArgs)
Cancel Property (GroupingEventArgs)
Cancel Property (PropertyChangingEventArgs)
Cancel, client-side
CancelButton setting (ReplacementType enum)
CancelCommand Event
CancelEdit Method (FpSpread)
CancelEdit Method (SpreadDataRowView)
CanChangeChartType Property
CanChangeSeriesType Method
CanConvertFrom Method (CellRangeConverter)
CanConvertFrom Method (CellTypeConverter)
CanConvertFrom Method (MapperInfoConverter)
CanConvertFrom Method (ParentStyleNameConverter)
CanConvertFrom Method (StyleNameConverter)
CanConvertTo Method (CellRangeConverter)
CanConvertTo Method (MapperInfoConverter)
CanDelete Property
CandlestickSeries Class

Members
Overview

CandlestickSeries Constructor (CandlestickSeries)
CanExportTo Method
CanFocus Field
CanFocus Property (AlternatingRow)
CanFocus Property (Cell)
CanFocus Property (Column)
CanFocus Property (Row)
CanFocus Property (StyleInfo)
CanInsert Property
CanMove Property
CannotOpen setting (ExcelWarningCode enum)
CannotOpenPasswordProtect setting (ExcelWarningCode enum)
CanPrint Property (IPdfPrintableRule)
CanPrint Property (SpreadChart)
CanResetValue Method (DoubleCollectionPropertyDescriptor)
CanResetValue Method (SpreadDataColumnPropertyDescriptor)
CanSelect Property
CanSerializeObject Method
CanSerializeXml Property (DefaultSheetDataModel)
CanSerializeXml Property (DefaultSheetStyleModel)
CanSerializeXml Property (GroupDataModel)
CanSerializeXml Property (GroupInfo)
CanSerializeXml Property (GroupInfoCollection)
CanSerializeXml Property (ICanSerializeXml)
CanSerializeXml Property (NamedStyleCollection)
CanSerializeXml Property (PreviewRowInfo)
CanSerializeXml Property (StyleInfo)
CanSize Property
CanSort Property
CanSwitchRowColumn Property
CanUpdate Property
Caption Property
cascading style sheet

assigning to cell

cascading style sheet, class name
cascading style sheet, setting
cascading style sheet, support
CaseSensitive Property
Category Property (IIndicator)
Category Property (IndicatorChangedEventArgs)
CategoryFormula Property
CategoryNames Property (PieSeries)
CategoryNames Property (RadarSeries)
CategoryNames Property (YSeries)
CeilingFunction Field
cell alignment
cell blocks

importing
importing

Cell Class

Members
Overview

cell color

importing
importing

cell formats

importing
importing

cell margins
cell notes
cell notes
cell notes
cell notes
cell padding
cell padding
cell padding
cell padding
cell padding
cell reference
cell reference
cell reference

style

cell reference, style
cell spacing
cell span
cell spans
cell spans
cell spans

column headers
row headers

cell type

automatic completion
button
check box
check box
combo box
combo box
combo with list drop-down
currency
date time
date with calendar drop-down
double
filtered text
general
hyperlink
image
integer
label
list box
masked edit
mutually exclusive check box
numeric
radio button list
rating
regular expression
setting
setting
slide show
slider
tag cloud
text
text box with watermark
time (see date time)

cell type, button
cell type, combo box
cell type, currency
cell type, date time
cell type, double
cell type, empty
cell type, general
cell type, hyperlink
cell type, image
cell type, integer
cell type, label
cell type, list box
cell type, percent
cell type, radio button list
cell type, regular expression
cell type, text
cell type, text box
cell types
cell types

exporting
importing
in formulas
active cell
automatic assignment
basics
bound data
exporting
headers
importing
overview
percent
sorting

cell types, automatic assignment
cell types, automatic completion
cell types, calendar
cell types, check box
cell types, check box
cell types, date calendar
cell types, extender
cell types, filtered
cell types, interface
cell types, masked
cell types, mutually exclusive check box
cell types, numeric up-down
cell types, password strength
cell types, rating
cell types, slide show
cell types, slider
cell types, watermark
CellBackColor Property
CellClick command (client-side)
CellClick Event
CellColumnHeader setting (SearchFoundFlags enum)
CellCssClass Property
CellExpression Class

Members
Overview

CellExpression Constructor (CellExpression)
CellForeColor Property
CellLayoutMode setting (LayoutModeType enum)
CellNote setting (SearchFoundFlags enum)
CellRange Class

Members
Overview

CellRange Constructor (CellRange)
CellRange Property (DefaultSpreadDataViewMapper)
CellRange Property (SpreadDataSource)
CellRange setting (PrintType enum)
CellRangeConverter Class

Members
Overview

CellRangeConverter Constructor (CellRangeConverter)
CellRanges Property
CellRangeSegmentData Class

Members
Overview

CellRangeSegmentData Constructor (CellRangeSegmentData)
CellRowHeader setting (SearchFoundFlags enum)
cells
cells

importing from Excel file
active cell
adding data
anchor cell
appearance settings
assigning CSS
automatic merging
conditional formatting
custom name
editor
editor
formula
formulas
header size
headers
hidden
importing from Excel file
locking
margins
notes
searching
selections
shortcut object
shortcut object
sorting
spacing
spanning
spanning
styles
tags

Cells Class

Members
Overview

Cells Property (ColumnFooter)
Cells Property (ColumnHeader)
Cells Property (FilterBar)
Cells Property (FpSpread)
Cells Property (RowHeader)
Cells Property (SheetCorner)
Cells Property (SheetView)
cells, aligning contents
cells, aligning contents
cells, automatic merging
cells, automatic merging
cells, automatic merging
cells, automatic merging
cells, automatic merging
cells, automatically merging
cells, automatically merging
cells, automatically merging
cells, automatically merging
cells, automatically merging
cells, automatically merging
cells, background color
cells, background color
cells, background color
cells, cell reference
cells, cell reference style
cells, cell reference style
Cells, client-side
cells, conditional format
cells, conditional formatting
cells, editable
cells, editable
cells, empty
cells, empty
cells, getting unbound value
cells, in expression
cells, locked
cells, locked
cells, locking
cells, margins
cells, margins
cells, margins
cells, margins
cells, margins
cells, merging automatically
cells, merging automatically
cells, merging automatically
cells, merging automatically
cells, merging automatically
cells, merging automatically
cells, merging automatically
cells, merging automatically
cells, merging automatically
cells, merging automatically
cells, merging automatically
cells, parent
cells, parent
cells, range support
cells, sheet corner
cells, spacing
cells, spacing
cells, styles
cells, styles
cells, tags
cells, types
cells,aligning contents
cells,aligning contents
CellSpacing Property (SheetSkin)
CellSpacing Property (SheetView)
CellsUpdated setting (SheetDataModelEventType enum)
CellTag setting (SearchFoundFlags enum)
CellText setting (SearchFoundFlags enum)
CellType Property (AlternatingRow)
CellType Property (Cell)
CellType Property (Column)
CellType Property (NamedStyle)
CellType Property (Row)
CellType Property (StyleInfo)
CellType Property (TitleInfo)
CellType setting (ReplacementType enum)
CellTypeConverter Class

Members
Overview

CellTypeConverter Constructor (CellTypeConverter)
Centering Enumeration
Centering Property
Century Property
ChangeChartType Method
Changed Event (AreaSeriesCollection)
Changed Event (Axis)
Changed Event (BarSeriesCollection)
Changed Event (BaseSheetAxisModel)
Changed Event (BaseSheetDataModel)
Changed Event (BaseSheetStyleModel)
Changed Event (BevelCollection)
Changed Event (ChartModel)
Changed Event (ConditionalFormatting)
Changed Event (ConditionalFormattingModel)
Changed Event (DefaultSparklineContainer)
Changed Event (DetachmentCollection)
Changed Event (DoubleCollection)
Changed Event (DoubleCollectionCollection)
Changed Event (FillCollection)
Changed Event (FilterColumnDefinitionCollection)
Changed Event (IConditionalFormattingModel)
Changed Event (INotifyItemChanged<T>)
Changed Event (ISheetAxisModel)
Changed Event (ISheetDataModel)
Changed Event (ISheetStyleModel2)
Changed Event (ISparklineContainer)
Changed Event (LabelArea)
Changed Event (LabelAreaCollection)
Changed Event (LegendArea)
Changed Event (LegendAreaCollection)
Changed Event (Light)
Changed Event (LightCollection)
Changed Event (LineCollection)
Changed Event (LineSeriesCollection)
Changed Event (MarkerCollection)
Changed Event (NamedStyle)
Changed Event (NamedStyleCollection)
Changed Event (PlotArea)
Changed Event (PlotAreaCollection)
Changed Event (PointSeriesCollection)
Changed Event (PolarRadiusAxisCollection)
Changed Event (RadarValueAxisCollection)
Changed Event (Series)
Changed Event (SeriesCollection)
Changed Event (StringCollection)
Changed Event (Stripe)
Changed Event (StripeCollection)
Changed Event (ValueAxisCollection)
Changed Event (Wall)
changes

saving

ChangeSeriesType Method
ChangeType Property
changing

command button images

Changing Event
CharFunction Field
chart

control
overview

chart control
Chart2DRenderer Class

Members
Overview

Chart2DRenderer Constructor (Chart2DRenderer)
Chart3DRenderer Class

Members
Overview

Chart3DRenderer Constructor (Chart3DRenderer)
ChartDataSetting Class

Members
Overview

ChartDataSetting Constructor (ChartDataSetting)
ChartImageHttpHandler Class

Members
Overview

ChartImageHttpHandler Constructor (ChartImageHttpHandler)
ChartImageType Property
ChartIndex Property
ChartMapArea Class

Members
Overview

ChartMapArea Constructor (ChartMapArea)
ChartModel Class

Members
Overview

ChartModel Constructor (ChartModel)
ChartName Property
charts

importing from Excel file
importing from Excel file
importing from Excel file

Charts Property
ChartViewType Enumeration
check box cell type
check box cell type
check box cells, editor
check box, mutually exclusive
check boxes, cell type
CheckBoxCellType Class

Members
Overview

CheckBoxCellType Constructor (CheckBoxCellType)
CheckBoxEditor Class

Members
Overview

CheckBoxEditor Constructor (CheckBoxEditor)
CheckBoxRenderer Class

Members
Overview

CheckBoxRenderer Constructor (CheckBoxRenderer)
CheckedImageUrl Property (CheckBoxCellType)
CheckedImageUrl Property (CheckBoxRenderer)
CheckUsedDataIndexes Method
ChiDistFunction Field
ChiInvFunction Field
child data relation
child relation
child relation
child sheets
child views
child views
child views
child views
child views
child views
ChildItems Property
ChildRelationCount Property (DefaultSheetDataModel)
ChildRelationCount Property (IChildModelSupport)
ChildRelationCount Property (SheetView)
ChildView command (client-side)
ChildViewCreated Event
childViews Field
ChiTestFunction Field
ChooseFunction Field
CircleBevel Class

Members
Overview

CircleBevel Constructor (CircleBevel)
circular reference
circular references
circular references
circular references
Classic Property
Classic1 Property
Classic2 Property
CleanFunction Field
Clear Method (AreaSeriesCollection)
Clear Method (BarSeriesCollection)
Clear Method (BaseSheetSpanModel)
Clear Method (BevelCollection)
Clear Method (ConditionalFormatting)
Clear Method (ConditionalFormattingModel)
Clear Method (DefaultSheetAxisModel)
Clear Method (DefaultSheetDataModel)
Clear Method (DefaultSheetSpanModel)
Clear Method (DefaultSheetStyleModel)
Clear Method (DefaultSparklineContainer)
Clear Method (DetachmentCollection)
Clear Method (DoubleCollection)
Clear Method (DoubleCollectionCollection)
Clear Method (ExcelSparklineGroup)
Clear Method (FillCollection)
Clear Method (FilterColumnDefinitionCollection)
Clear Method (FilterItemCollection)
Clear Method (FilterItemValueCollection)
Clear Method (GroupInfoCollection)
Clear Method (IMovable)
Clear Method (IRangeSupport)
Clear Method (ISheetSpanModel)
Clear Method (LabelAreaCollection)
Clear Method (LegendAreaCollection)
Clear Method (LightCollection)
Clear Method (LineCollection)
Clear Method (LineSeriesCollection)
Clear Method (MarkerCollection)
Clear Method (NamedStyleCollection)
Clear Method (PlotAreaCollection)
Clear Method (PointSeriesCollection)
Clear Method (PolarRadiusAxisCollection)
Clear Method (RadarValueAxisCollection)
Clear Method (SeriesCollection)
Clear Method (SmartPrintRulesCollection)
Clear Method (StringCollection)
Clear Method (StripeCollection)
Clear Method (ValueAxisCollection)
Clear, client-side
ClearConditionalFormating Method
ClearConditionalFormatings Method
ClearConditionalFormats Method
ClearCustomFunctions Method (DefaultSheetDataModel)
ClearCustomFunctions Method (ICustomFunctionSupport2)
ClearCustomNames Method (DefaultSheetDataModel)
ClearCustomNames Method (ICustomNameSupport2)
ClearData Method (DefaultSheetDataModel)
ClearData Method (IClearDataSupport)
ClearFilterRowFormats Method
ClearFormulas Method (DefaultSheetDataModel)
ClearFormulas Method (IClearFormulasSupport)
ClearGroupEventHandler Delegate
clearing

selections

clearing, filters
clearing, formulas
clearing,selections
ClearItems Event (ExcelSparklineGroup)
ClearItems Event (ISparklineGroup)
ClearMaskOnLostFocus Property
ClearRange Method
ClearRowFilter Method
ClearRowVisibleState Method
ClearSelection Method (BaseSheetSelectionModel)
ClearSelection Method (DefaultSheetSelectionModel)
ClearSelection Method (ISheetSelectionModel)
ClearSelection, client-side
ClearSparklineGroupsInRange Method
ClearSparklines Method
Click Event
ClickHeaderCellToExpand Property
client side event
client side event
client side event
client side event
ClientAutoCalculation Property
ClientAutoSize Property
ClientAutoSizeMaxHeight Property
ClientAutoSizeMaxWidth Property
client-side events

mapping to function
onActiveCellChanged
onActiveCellChanging
onAutoFilterColumn
onAutoFilterColumnCompleted
onAutoFilteredColumn
onAutoFilteringColumn
onCallBackStart
onCallBackStopped
onColumnDragMove
onColumnDragMoveCompleted
onColWidthChanged
onCopyData
onDataChanged
onEditStart
onEditStopped
onErrorMessageShown
onRowHeightChanged
onScroll
onSelectionChanged

client-side methods

Add
AddKeyMap
AddSelection
CallBack
Cancel
Cells
Clear
ClearSelection
Columns
Copy
Delete
Edit
EndEdit
ExpandRow
GetActiveChart
GetActiveChildSheetView
GetCellByRowCol
GetChildSpread
GetChildSpreads
GetColByKey
GetColCount
GetColKeyFromCol
GetCurrentPageIndex
GetFormula
GetHiddenValue
GetLeftColIndex
GetPageCount
GetParentRowIndex
GetParentSpread
GetRowByKey
GetRowCount
GetRowKeyFromRow
GetSelectedRange
GetSelectedRanges
GetSheetColIndex
GetSheetRowIndex
GetSpread
GetTitleInfo
GetTopRowIndex
GetTotalRowCount
GetValue
HideMessage
HideMessage
Insert
IsValid
LoadData
MoveToFirstColumn
MoveToLastColumn
MoveToNextCell
MoveToNextRow
MoveToPrevCell
MoveToPrevCell
Next
Paste
Prev
Prev
Prev
RemoveKeyMap
ResumeLayout
Rows
ScrollTo
SetActiveCell
SetActiveChart
SetColWidth
SetFormula
SetSelectedRange
SetValue
SizeToFit
sort
StartEdit
SuspendLayout
Update
UpdatePostBackData

client-side properties

ActiveCol
ActiveRow

client-side scripting

overview

client-side scripting reference
client-side scripting, enabling
client-side validation

effects of EnableClientScript

ClientValidationFunction Property
clip
clip
clip
clip
clip
clip
clip
clip
clip
clip
clip
clip
ClipboardEnabled Property
ClipboardText Property
Clockwise Property
Clone Method (AjaxComboBoxCellType)
Clone Method (Appearance)
Clone Method (AreaSeries)
Clone Method (BarSeries)
Clone Method (BaseCellType)
Clone Method (BaseSparkline)
Clone Method (BevelCollection)
Clone Method (Border)
Clone Method (CandlestickSeries)
Clone Method (ChartModel)
Clone Method (ClusteredBarSeries)
Clone Method (ConditionalFormat)
Clone Method (DetachmentCollection)
Clone Method (DirectionalLight)
Clone Method (DoubleCollection)
Clone Method (ExcelSparkline)
Clone Method (ExcelSparklineGroup)
Clone Method (ExcelSparklineSetting)
Clone Method (FillCollection)
Clone Method (HighLowAreaSeries)
Clone Method (HighLowBarSeries)
Clone Method (HighLowCloseSeries)
Clone Method (IndexAxis)
Clone Method (LabelArea)
Clone Method (LegendArea)
Clone Method (LineCollection)
Clone Method (LineSeries)
Clone Method (MarkerCollection)
Clone Method (NamedStyle)
Clone Method (OpenHighLowCloseSeries)
Clone Method (PiePlotArea)
Clone Method (PieSeries)
Clone Method (PointSeries)
Clone Method (PolarAngleAxis)
Clone Method (PolarAreaSeries)
Clone Method (PolarLineSeries)
Clone Method (PolarPlotArea)
Clone Method (PolarPointSeries)
Clone Method (PolarRadiusAxis)
Clone Method (PositionalLight)
Clone Method (PrintInfo)
Clone Method (RadarAreaSeries)
Clone Method (RadarIndexAxis)
Clone Method (RadarLineSeries)
Clone Method (RadarPlotArea)
Clone Method (RadarPointSeries)
Clone Method (RadarValueAxis)
Clone Method (SeriesCollection)
Clone Method (Sparkline)
Clone Method (SpreadChart)
Clone Method (StackedAreaSeries)
Clone Method (StackedBarSeries)
Clone Method (StackedLineSeries)
Clone Method (StackedPointSeries)
Clone Method (StringCollection)
Clone Method (Stripe)
Clone Method (StyleInfo)
Clone Method (ValidatorCollection)
Clone Method (ValueAxis)
Clone Method (Wall)
Clone Method (XYBubbleSeries)
Clone Method (XYLineSeries)
Clone Method (XYPlotArea)
Clone Method (XYPointSeries)
Clone Method (XYZLineSeries)
Clone Method (XYZPlotArea)
Clone Method (XYZPointSeries)
Clone Method (XYZSurfaceSeries)
Clone Method (YPlotArea)
CloneSetting Method (ExcelSparklineGroup)
CloneSetting Method (ISparklineGroup)
CloseContour Property (PolarAreaSeries)
CloseContour Property (PolarLineSeries)
CloseContour Property (RadarAreaSeries)
CloseContour Property (RadarLineSeries)
CloseValues Property (CandlestickSeries)
CloseValues Property (HighLowCloseSeries)
CloseValues Property (OpenHighLowCloseSeries)
ClusteredBarSeries Class

Members
Overview

ClusteredBarSeries Constructor (ClusteredBarSeries)
Code Property (ExcelException)
Code Property (ExcelWarning)
CodeFunction Field
codes, Excel exceptions
Col Property
ColEnd Property
CollapseImage Field
collapsing

grouping

Collection Editor
collections, grouping information
collections, styles
color palette (exporting)
Color Property (ColorFilterItem)
Color Property (ConditionalFormattingColorValue)
Color Property (SolidFill)
Color Property (SolidLine)
Color0 Property
Color1 Property
ColorFilterItem Class

Members
Overview

ColorFilterItem Constructor (ColorFilterItem)
Colorful1 Property
Colorful2 Property
Colorful3 Property
Colorful4 Property
Colorful5 Property
colors

cell background
Excel exporting
grid lines
header empty areas
scroll bars¶
selections

Colors Property
colors, background
colors, background
colors, background
colors, grid lines
colors, grid lines
colors, header empty area
colors, locked cells background
colors, locked cells text
colors, scroll bars
colors, scroll bars
colors, scroll bars
colors, scroll bars
colors, scroll bars
colors, scroll bars
colors, scroll bars
colors, scroll bars
colors, selection background
colors, tab border
colors, tab text
colors, text
colors, text
colors, text
colors,background
colors,background
colors,background
colors,background
colors,background
colors,background
colors,foreground
colors,foreground
colors,foreground
colors,foreground
colors,foreground
ColStart Property
columm headers, height
column
Column Class

Members
Overview

column definitions, filtering
column definitions, filtering
column footer

hiding

column footers
column headers
column headers
column headers

automatic text
content
custom text
default style
displaying
editor
editor
hiding
multiple
multiple rows
spans
text
text

column headers, labels
column headers, labels
column headers, labels
column headers, labels
column headers, visible
column label
column label
column label
Column Property (AggregateArgs)
Column Property (AutoFilterIndexChangedEventArgs)
Column Property (BaseSparkline)
Column Property (CalcArray)
Column Property (CalcReference)
Column Property (Cell)
Column Property (CellExpression)
Column Property (CellRange)
Column Property (ConditionalFormatInfo)
Column Property (ConditionalFormattingModelEventArgs)
Column Property (ExcelSparkline)
Column Property (ExcelWarning)
Column Property (ExternalCellExpression)
Column Property (ExternalRangeExpression)
Column Property (ExternalReferenceExpression)
Column Property (Group)
Column Property (ISparkline)
Column Property (MapperInfo)
Column Property (RangeExpression)
Column Property (ReferenceExpression)
Column Property (SheetDataModelEventArgs)
Column Property (SheetSelectionModelEventArgs)
Column Property (SheetStyleModelEventArgs)
column width
column width

importing
importing

ColumnAxisModel Property
ColumnCount Property (AggregateArgs)
ColumnCount Property (BaseSheetDataModel)
ColumnCount Property (CalcArray)
ColumnCount Property (CalcReference)
ColumnCount Property (CellExpression)
ColumnCount Property (CellRange)
ColumnCount Property (ConditionalFormattingModelEventArgs)
ColumnCount Property (DefaultSheetDataModel)
ColumnCount Property (DefaultSheetStyleModel)
ColumnCount Property (ExternalCellExpression)
ColumnCount Property (ExternalRangeExpression)
ColumnCount Property (ExternalReferenceExpression)
ColumnCount Property (GroupDataModel)
ColumnCount Property (ISheetDataModel)
ColumnCount Property (MapperInfo)
ColumnCount Property (RangeExpression)
ColumnCount Property (ReferenceExpression)
ColumnCount Property (RowHeader)
ColumnCount Property (SheetCorner)
ColumnCount Property (SheetDataModelEventArgs)
ColumnCount Property (SheetSelectionModelEventArgs)
ColumnCount Property (SheetStyleModelEventArgs)
ColumnCount Property (SheetView)
ColumnCount Property (WorksheetTemplate)
ColumnDefinitions Property (DefaultRowFilter)
ColumnDefinitions Property (IRowFilter)
ColumnEdit Property (MultiColumnComboBoxCellType)
ColumnEdit Property (MultiColumnEditor)
ColumnEditName Property (MultiColumnComboBoxCellType)
ColumnEditName Property (MultiColumnEditor)
columnField Field
ColumnFooter Class

Members
Overview

ColumnFooter Property (FpSpread)
ColumnFooter Property (SheetView)
ColumnFooterDataModel Property
ColumnFooterDefault Field
ColumnFooterHeight Property
ColumnFooterRowAxisModel Property
ColumnFooterSpanModel Property
ColumnFooterStyleModel Property
ColumnFooterVisible Property
ColumnFunction Field
ColumnHeader Class

Members
Overview

ColumnHeader Property (FpSpread)
ColumnHeader Property (SheetView)
ColumnHeaderAutoFilterIndex Property
ColumnHeaderAutoText Property
ColumnHeaderAutoTextIndex Property
ColumnHeaderBackground Property
ColumnHeaderClick command (client-side)
ColumnHeaderClick Event
ColumnHeaderDataModel Property
ColumnHeaderDefault Field
ColumnHeaderFilterCellType Class

Members
Overview

ColumnHeaderFilterCellType Constructor (ColumnHeaderFilterCellType)
ColumnHeaderHeight Property
ColumnHeaderRowAxisModel Property
ColumnHeaders setting (ExcelOpenFlags enum)
ColumnHeadersCustomOnly setting (IncludeHeaders enum)
ColumnHeaderSpanModel Property
ColumnHeaderStyleModel Property
ColumnHeaderTemplate Property
ColumnHeaderVisible Property
ColumnIndex Property (FilterColumnDefinition)
ColumnIndex Property (FpSpreadTemplateReplacement)
ColumnName Property
ColumnRelative Property (CellExpression)
ColumnRelative Property (ExternalCellExpression)
ColumnRelative Property (ExternalRangeExpression)
ColumnRelative Property (ExternalReferenceExpression)
ColumnRelative Property (RangeExpression)
ColumnRelative Property (ReferenceExpression)
columns
columns

exporting to Excel file
importing from Excel file
adding
appearance
default number
editor
editor
exporting to Excel file
frozen
frozen
grid lines
hiding
importing from Excel file
moving
multiple lines
removing
resizing
searching
setting number of
shortcut object
shortcut object
sorting
sorting
width

Columns Class

Members
Overview

Columns Property (ColumnFooter)
Columns Property (ColumnHeader)
Columns Property (FpSpread)
Columns Property (RowHeader)
Columns Property (SheetCorner)
Columns Property (SheetView)
Columns Property (SpreadDataView)
columns, active
columns, adding
columns, adding
columns, adding
columns, background color
Columns, client-side
columns, count
columns, counting non-empty
columns, default column
columns, default column
columns, default header style
columns, default header style
columns, default width
columns, filter
columns, footers
columns, frozen
columns, grouping
columns, grouping
columns, header
columns, header
columns, header
columns, header
columns, header
columns, headers
columns, headers
columns, headers
columns, headers
columns, moving
columns, non-empty
columns, parent
columns, parent
columns, quantity
columns, removing
columns, removing
columns, removing
columns, sizable by user
columns, sizable by user
columns, sizable by user
columns, sorted
columns, sorting
columns, sorting
columns, starting number
columns, tags
columns, width (client-side)
Columns.DefaultColumn Class

Members
Overview

ColumnsAdded setting (SheetDataModelEventType enum)
ColumnsFunction Field
ColumnSpan Property (Cell)
ColumnSpan Property (LayoutCell)
ColumnSparklineRenderer Class

Members
Overview

ColumnSparklineRenderer Constructor (ColumnSparklineRenderer)
ColumnSparklineRenderer Property
ColumnsRemoved setting (SheetDataModelEventType enum)
ColumnWidths Property (MultiColumnComboBoxCellType)
ColumnWidths Property (MultiColumnEditor)
combined
CombinFunction Field
combo box
combo box cell
combo box cell
combo box cell type
combo box cell type
combo box cells, editor
combo box list
combo box list
combo box list
combo box, row filtering
combo boxes, cell type
combo-box cell type
ComboBoxCellType Class

Members
Overview

ComboBoxCellType Constructor (ComboBoxCellType)
ComboBoxEditor Class

Members
Overview

ComboBoxEditor Constructor (ComboBoxEditor)
command
command
command bar
command bar
command bar

button images
buttons
hiding buttons
Next button
position
Previous button
print icon
Update button
Update button

command bar button

effect of EnableClientScript

command bar, buttons
command bar, placement
command bars, in Spread
command bars, in Spread
command buttons
command buttons
command buttons
command buttons
command buttons, cancel
command buttons, create
command buttons, delete
command buttons, insert
command buttons, update
command buttons,edit
Command Property
CommandArgument Property
CommandBar Property
CommandBar setting (PagerPosition enum)
CommandBarInfo Class

Members
Overview

CommandBarInfo Constructor (CommandBarInfo)
CommandBarOnBottom Property
CommandName Property (ButtonCellType)
CommandName Property (ButtonRenderer)
CommandName Property (MenuItem)
commands

custom CallBack
pre-defined CallBack

comments

importing
importing as notes

comments (See notes)
comments (See notes)
comments (See notes)
CompareExpression Method
Comparer Property
CompareTo Method (Border)
CompareTo Method (LinearRange)
CompareTo Method (StyleInfo)
ComparisonOperator Enumeration
ComparisonOperator Property
CompletionInterval Property
CompletionListCssClass Property
CompletionListHighlightedItemCssClass Property
CompletionListItemCssClass Property
CompletionSetCount Property
ComplexFunction Field
component

customizing interaction
events

component files (HTC files)
ComponentType Property (DoubleCollectionPropertyDescriptor)
ComponentType Property (SpreadDataColumnPropertyDescriptor)
Compose Method (DefaultStyleCollection)
Compose Method (NamedStyleCollection)
Compose Method (StyleInfo)
composite of settings
compound files, opening
computed value

custom name

ConcatenateFunction Field
ConcatenateOperator Field
conditional formatting
conditional formatting
conditional formatting
conditional formatting
conditional formatting

overview

ConditionalFormat Class

Members
Overview

ConditionalFormat Constructor (ConditionalFormat)
ConditionalFormat Property
ConditionalFormatCollection Class

Members
Overview

ConditionalFormatCollection Constructor (ConditionalFormatCollection)
ConditionalFormatInfo Class

Members
Overview

ConditionalFormatInfo Constructor (ConditionalFormatInfo)
ConditionalFormatInvalidateCell Method
ConditionalFormatInvalidateColumn Method
ConditionalFormatInvalidateRow Method
ConditionalFormatIsRowUsed Method
ConditionalFormatNextNonEmptyColumnInRow Method
ConditionalFormatting Class

Members
Overview

ConditionalFormatting Constructor (ConditionalFormatting)
ConditionalFormatting Property (ConditionalFormattingRule)
ConditionalFormatting Property (IConditionalFormattingRule)
ConditionalFormatting Property (SheetView)
ConditionalFormattingColorValue Class

Members
Overview

ConditionalFormattingColorValue Constructor (ConditionalFormattingColorValue)
ConditionalFormattingColorValueCollection Class

Members
Overview

ConditionalFormattingColorValueCollection Constructor (ConditionalFormattingColorValueCollection)
ConditionalFormattingIcon Enumeration
ConditionalFormattingIconRuleSet Class

Members
Overview

ConditionalFormattingIconRuleSet Constructor (ConditionalFormattingIconRuleSet)
ConditionalFormattingIconSetStyle Enumeration
ConditionalFormattingIconValue Class

Members
Overview

ConditionalFormattingIconValue Constructor (ConditionalFormattingIconValue)
ConditionalFormattingModel Class

Members
Overview

ConditionalFormattingModel Constructor (ConditionalFormattingModel)
ConditionalFormattingModelEventArgs Class

Members
Overview

ConditionalFormattingModelEventArgs Constructor (ConditionalFormattingModelEventArgs)
ConditionalFormattingModelEventType Enumeration
ConditionalFormattingRule Class

Members
Overview

ConditionalFormattingRulePropertyChangedEventArgs Class

Members
Overview

ConditionalFormattingRulePropertyChangedEventArgs Constructor (ConditionalFormattingRulePropertyChangedEventArgs)
ConditionalFormattings Property
ConditionalFormattingSplit Event
ConditionalFormattingSupported Property
ConditionalFormattingValue Class

Members
Overview

ConditionalFormattingValue Constructor (ConditionalFormattingValue)
ConditionalFormattingValueCollection Class

Members
Overview

ConditionalFormattingValueCollection Constructor (ConditionalFormattingValueCollection)
ConditionalFormattingValueType Enumeration
ConfidenceFunction Field
Consumer Property (ExpressionConsumerFormulaInfo)
Consumer Property (FormulaRestrictedException)
Contains Method (AreaSeriesCollection)
Contains Method (BarSeriesCollection)
Contains Method (BevelCollection)
Contains Method (CellRange)
Contains Method (ConditionalFormatCollection)
Contains Method (ConditionalFormatting)
Contains Method (ConditionalFormattingModel)
Contains Method (DefaultSkins)
Contains Method (DefaultSparklineContainer)
Contains Method (DefaultStyleCollection)
Contains Method (DetachmentCollection)
Contains Method (DoubleCollection)
Contains Method (DoubleCollectionCollection)
Contains Method (ExcelSparklineGroup)
Contains Method (FillCollection)
Contains Method (FilterColumnDefinitionCollection)
Contains Method (FilterItemValueCollection)
Contains Method (GroupInfoCollection)
Contains Method (LabelAreaCollection)
Contains Method (LegendAreaCollection)
Contains Method (LightCollection)
Contains Method (LineCollection)
Contains Method (LineSeriesCollection)
Contains Method (MarkerCollection)
Contains Method (NamedStyleCollection)
Contains Method (PlotAreaCollection)
Contains Method (PointSeriesCollection)
Contains Method (PolarRadiusAxisCollection)
Contains Method (RadarValueAxisCollection)
Contains Method (SeriesCollection)
Contains Method (SheetViewCollection)
Contains Method (SmartPrintRulesCollection)
Contains Method (SpreadChartCollection)
Contains Method (SpreadDataColumnCollection)
Contains Method (StringCollection)
Contains Method (StripeCollection)
Contains Method (ValueAxisCollection)
ContainsCalcError Property
ContainStringValue Method (ArraySegmentData)
ContainStringValue Method (CellRangeSegmentData)
ContainStringValue Method (ISegmentData)
ContainStringValue Method (StringSegmentData)
Content Property
context menu
context menu
ContextKey Property (AutoCompleteCellType)
ContextKey Property (SlideShowCellType)
ContextMenu Class

Members
Overview

ContextMenu Constructor (ContextMenu)
ContextMenuCollection Class

Members
Overview

ContextMenuCollection Constructor (ContextMenuCollection)
ContextMenus Property
ContextMenuStyle Class

Members
Overview

ContextMenuStyle Constructor (ContextMenuStyle)
ContextMenuStyle Property (SheetSkin)
ContextMenuStyle Property (SheetView)
ContextMenuType Enumeration
control

Azure

control size

effect of EnableClientScript

control, background color
controls

ASP.NET AJAX extenders

Controls Property
controls, finding
controls, recreating
controls,Spread
ConvertFrom Method (CellRangeConverter)
ConvertFrom Method (CellTypeConverter)
ConvertFrom Method (MapperInfoConverter)
ConvertFrom Method (ParentStyleNameConverter)
ConvertFrom Method (StyleNameConverter)
ConvertFunction Field
converting, data types
ConvertTo Method (CellRangeConverter)
ConvertTo Method (CellTypeConverter)
ConvertTo Method (MapperInfoConverter)
ConvertTo Method (ParentStyleNameConverter)
ConvertTo Method (StyleNameConverter)
ConvertToTagCloudItems Method
Coordinates Property (ChartMapArea)
Coordinates Property (IChartMapArea)
Coordinates Property (MapArea)
CoordsSet Property
copy
copy
copy
Copy Method (Appearance)
Copy Method (Border)
Copy Method (ConditionalFormattingModel)
Copy Method (DefaultSheetAxisModel)
Copy Method (DefaultSheetDataModel)
Copy Method (DefaultSheetSpanModel)
Copy Method (DefaultSheetStyleModel)
Copy Method (DefaultSparklineContainer)
Copy Method (IMovable)
Copy Method (IRangeSupport)
copy style
Copy, client-side
CopyColumns Method
CopyFrom Method (NamedStyle)
CopyFrom Method (PrintInfo)
CopyFrom Method (StyleInfo)
CopyFrom Method (TitleInfo)
CopyRows Method
CopyTo Method (AreaSeriesCollection)
CopyTo Method (BarSeriesCollection)
CopyTo Method (BevelCollection)
CopyTo Method (ConditionalFormatting)
CopyTo Method (ConditionalFormattingModel)
CopyTo Method (DefaultSkins)
CopyTo Method (DefaultSparklineContainer)
CopyTo Method (DefaultStyleCollection)
CopyTo Method (DetachmentCollection)
CopyTo Method (DoubleCollection)
CopyTo Method (DoubleCollectionCollection)
CopyTo Method (ExcelSparklineGroup)
CopyTo Method (ExcelWarningList)
CopyTo Method (FillCollection)
CopyTo Method (FilterColumnDefinitionCollection)
CopyTo Method (FilterItemValueCollection)
CopyTo Method (GroupInfoCollection)
CopyTo Method (LabelAreaCollection)
CopyTo Method (LegendAreaCollection)
CopyTo Method (LightCollection)
CopyTo Method (LineCollection)
CopyTo Method (LineSeriesCollection)
CopyTo Method (MarkerCollection)
CopyTo Method (NamedStyleCollection)
CopyTo Method (PlotAreaCollection)
CopyTo Method (PointSeriesCollection)
CopyTo Method (PolarRadiusAxisCollection)
CopyTo Method (RadarValueAxisCollection)
CopyTo Method (SeriesCollection)
CopyTo Method (SheetViewCollection)
CopyTo Method (SmartPrintRulesCollection)
CopyTo Method (StringCollection)
CopyTo Method (StripeCollection)
CopyTo Method (ValueAxisCollection)
corner

sheet

corner, sheet
corner, sheet
corner, sheet
corner, sheet
corner, sheet
corner, sheet
corner, style
corner, style
CornerDefault Field
CorrelFunction Field
CosFunction Field
CoshFunction Field
Count Property (AlternatingRows)
Count Property (AreaSeries)
Count Property (AreaSeriesCollection)
Count Property (ArraySegmentData)
Count Property (BarSeries)
Count Property (BarSeriesCollection)
Count Property (BaseSheetAxisModel)
Count Property (BaseSheetSelectionModel)
Count Property (BevelCollection)
Count Property (CandlestickSeries)
Count Property (CellRangeSegmentData)
Count Property (ClusteredBarSeries)
Count Property (Columns)
Count Property (ConditionalFormatting)
Count Property (ConditionalFormattingModel)
Count Property (DefaultSheetAxisModel)
Count Property (DefaultSheetSelectionModel)
Count Property (DefaultSkins)
Count Property (DefaultSparklineContainer)
Count Property (DefaultStyleCollection)
Count Property (DetachmentCollection)
Count Property (DoubleCollection)
Count Property (DoubleCollectionCollection)
Count Property (ExcelSparklineGroup)
Count Property (ExcelWarningList)
Count Property (FillCollection)
Count Property (FilterColumnDefinitionCollection)
Count Property (FilterItemValueCollection)
Count Property (GroupInfoCollection)
Count Property (HighLowAreaSeries)
Count Property (HighLowBarSeries)
Count Property (HighLowCloseSeries)
Count Property (IMovable)
Count Property (ISegmentData)
Count Property (ISheetSelectionModel)
Count Property (LabelAreaCollection)
Count Property (LayoutColumns)
Count Property (LayoutRows)
Count Property (LegendAreaCollection)
Count Property (LightCollection)
Count Property (LineCollection)
Count Property (LineSeries)
Count Property (LineSeriesCollection)
Count Property (ListBase.ListChangedEventArgs<T>)
Count Property (MarkerCollection)
Count Property (NamedStyleCollection)
Count Property (OpenHighLowCloseSeries)
Count Property (PieSeries)
Count Property (PlotAreaCollection)
Count Property (PointSeries)
Count Property (PointSeriesCollection)
Count Property (PolarAreaSeries)
Count Property (PolarLineSeries)
Count Property (PolarPointSeries)
Count Property (PolarRadiusAxisCollection)
Count Property (RadarAreaSeries)
Count Property (RadarLineSeries)
Count Property (RadarPointSeries)
Count Property (RadarValueAxisCollection)
Count Property (Rows)
Count Property (Series)
Count Property (SeriesCollection)
Count Property (SeriesDataField)
Count Property (SeriesDataFieldCollection)
Count Property (SheetAxisModelEventArgs)
Count Property (SheetViewCollection)
Count Property (SmartPrintRulesCollection)
Count Property (StackedAreaSeries)
Count Property (StackedBarSeries)
Count Property (StackedLineSeries)
Count Property (StackedPointSeries)
Count Property (StringCollection)
Count Property (StripeCollection)
Count Property (TabInfo)
Count Property (TouchStripCollection)
Count Property (ValueAxisCollection)
Count Property (XYBubbleSeries)
Count Property (XYLineSeries)
Count Property (XYPointSeries)
Count Property (XYZLineSeries)
Count Property (XYZPointSeries)
Count Property (XYZSurfaceSeries)
Count setting (AggregationType enum)
count, columns
count, rows
CountA setting (AggregationType enum)
CountAFunction Field
CountBlankFunction Field
CountChanged Property
CountFunction Field
CountIfFunction Field
CountIfsFunction Field
counting, sheet name tabs
CountX Property
CountZ Property
CoupDayBSFunction Field
CoupDaysFunction Field
CoupDaysNCFunction Field
CoupNCDFunction Field
CoupNumFunction Field
CoupPCDFunction Field
CovarFunction Field
CreateButton Event
CreateButtonEventArgs Class

Members
Overview

CreateButtonEventArgs Constructor (CreateButtonEventArgs)
CreateButtonEventHandler Delegate
CreateChart2DRenderer Method (FpChart)
CreateChart2DRenderer Method (SpreadChart)
CreateChart3DRenderer Method (FpChart)
CreateChart3DRenderer Method (SpreadChart)
CreateChartModelFromExcelSparklineSetting Method
CreateChildControls Method (FpSpread)
CreateChildControls Method (RowEditTemplateContainer)
CreateChildViewEventArgs Class

Members
Overview

CreateChildViewEventArgs Constructor (CreateChildViewEventArgs)
CreateChildViewEventHandler Delegate
CreateCollectionForm Method
CreateColumnAxisModel Method (LayoutTemplate)
CreateColumnAxisModel Method (SheetView)
CreateContent Method
CreateContext Method
CreateDataModel Method (LayoutTemplate)
CreateDataModel Method (SheetView)
CreateInstance Method (CellRangeConverter)
CreateInstance Method (DesignTimeCellTypeConverter)
CreateInstance Method (SpreadChartCollectionEditor)
CreateObjectInstanceAndDeserialize Method
CreateRowAxisModel Method (LayoutTemplate)
CreateRowAxisModel Method (SheetView)
CreateSelectionModel Method
CreateSpanModel Method (LayoutTemplate)
CreateSpanModel Method (SheetView)
CreateStreamError setting (ExcelExceptionCode enum)
CreateStyleModel Method
creating

custom function
custom names
skins
styles

creating, custom skin
CritBinomFunction Field
criteria, filtering items
CrossHair setting (CursorType enum)
cross-sheet referencing
CSS

assigning to cell

CSS class name
CSS class, dragging column
CSS class, support
CSS, setting
CssClass Property (ButtonCellType)
CssClass Property (CheckBoxCellType)
CssClass Property (ComboBoxCellType)
CssClass Property (FilterBarCellType)
CssClass Property (GeneralCellType)
CssClass Property (GroupInfo)
CssClass Property (HyperLinkCellType)
CssClass Property (ICSSClassSupport)
CssClass Property (ImageCellType)
CssClass Property (LabelCellType)
CssClass Property (ListBoxCellType)
CssClass Property (PagerInfo)
CssClass Property (PreviewRowInfo)
CssClass Property (RadioButtonListCellType)
CssClass Property (TabInfo)
CssClass Property (TextCellType)
CultureName Property
CumIpmtFunction Field
CumPrincFunction Field
currency

minimum and maximum values

currency cell
currency separator
currency, cell type
CurrencyCellType Class

Members
Overview

CurrencyCellType Constructor (CurrencyCellType)
CurrencyCellType.EditModeSettings Class

Members
Overview

CurrencyCellType.EditModeSettings Constructor (CurrencyCellType.EditModeSettings)
CurrencyFormatter Class

Members
Overview

CurrencyFormatter Constructor (CurrencyFormatter)
Current Property
Current setting (ResetOption enum)
CurrentPage Property
CurrentPage setting (PrintType enum)
CurrentPageIndex Property
CurrentRating Property
CurrentSize Property
CurrentVisible Property
cursors, type
CursorType Enumeration
custom

cell type, client side
CallBack commands
filter
functions
names
skins
styles
text in headers

custom functions
custom functions, adding
custom functions, removing
custom HTC files
custom names
custom names, adding
custom names, removing
Custom setting (AggregationType enum)
custom skins
custom skins
custom styles
custom styles
custom styles
custom text in headers
custom, functions
custom, functions
custom, names
custom, names
custom, styles
custom, styles parent
CustomFilterItem Class

Members
Overview

CustomFilterItem Constructor (CustomFilterItem)
CustomFilterOperatorType Enumeration
customized styles

overview

customizing

data model
graphical interface
selections

cut
Dashed setting (FocusBorderStyle enum)
data

searching
sorting

data area

appearance

data binding

automatic cell type assignment
binding
binding
hierarchy display
limiting postbacks
overview
procedures

data binding, assigning cell types
data binding, data key
data binding, data member
data binding, data member
data binding, data model
data binding, Data namespace
data binding, data source
data binding, data source
data binding, data source
data binding, key field
data binding, key names
data binding, property
data binding, recreating controls
data binding, source identifier
data binding, unbound row
data bound cells, assigning cell type
data key

editor
editor

data key, model support
data model
data model

customizing
optional interfaces

data model, base
data model, default
data model, event arguments
data model, headers
data model, interface
data models, for data binding
data plot types
Data Property (IIndicator)
Data Property (IndicatorChangedEventArgs)
Data Property (Sparkline)
data set

binding to
binding to

data sets, setting data member
data sets, setting data source
data source
data source, adding rows
data source, generating columns
data sources, Data namespace
data type, interface
data types

in formulas

data types, converting
data, Data namespace
data, non-empty cells
data, sorting
data, sorting
DataAndFormulasOnly setting (ExcelOpenFlags enum)
DataAreaDefault Field
DataAreaDefault2 Field
DataAutoCellTypes Property

using

DataBarAxisPosition Enumeration
DatabarConditionalFormattingRule Class

Members
Overview

DatabarConditionalFormattingRule Constructor (DatabarConditionalFormattingRule)
database

binding to
binding to

database state management
databases, Data namespace
DataBind Method
DataChanged Event (CellRangeSegmentData)
DataChanged Event (ISegmentData)
DataChanged Event (SeriesDataField)
DataChanged Property
DataColumn Property (MultiColumnComboBoxCellType)
DataColumn Property (MultiColumnEditor)
DataColumnName Property (MultiColumnComboBoxCellType)
DataColumnName Property (MultiColumnEditor)
DataDisplayTextField Property
DataField Property (Column)
DataField Property (DoubleCollection)
DataField Property (StringCollection)
DataFieldChangedEventArgs Class

Members
Overview

DataFieldChangedEventArgs Constructor (DataFieldChangedEventArgs)
DataFieldChangedEventHandler Delegate
DataFieldConverter Class

Members
Overview

DataFieldConverter Constructor (DataFieldConverter)
DataFormula Property
DataHrefField Property
DataHrefFormatString Property
DataIndex Property
DataInfo Property
DataItemDataField Property
DataKeyField Property

using

DataKeyField Property (DefaultSheetDataModel)
DataKeyField Property (IDataSourceSupport)
DataKeyField Property (SheetView)
DataKeyNames Property
DataMember Property

using

DataMember Property (AjaxComboBoxCellType)
DataMember Property (ComboBoxCellType)
DataMember Property (DefaultSheetDataModel)
DataMember Property (FpSpread)
DataMember Property (IDataSourceSupport)
DataMember Property (MultiColumnComboBoxCellType)
DataMember Property (MultiColumnEditor)
DataMember Property (SheetView)
DataMember Property (TagCloudCellType)
DataModel Property
DataOnly setting (ExcelOpenFlags enum)
DataOnly setting (ExcelSaveFlags enum)
DataOrientation Enumeration
DataOrientation Property
DataSetting Property (ISupportChartDataSetting)
DataSetting Property (SeriesDataField)
DataSetting Property (SpreadChart)
DataSource Property

using

DataSource Property (AjaxComboBoxCellType)
DataSource Property (ComboBoxCellType)
DataSource Property (DefaultSheetDataModel)
DataSource Property (DoubleCollection)
DataSource Property (FpSpread)
DataSource Property (IDataSourceSupport)
DataSource Property (MultiColumnComboBoxCellType)
DataSource Property (MultiColumnEditor)
DataSource Property (SheetView)
DataSource Property (StringCollection)
DataSource Property (TagCloudCellType)
DataSourceChanged Event
DataSourceID Property (AjaxComboBoxCellType)
DataSourceID Property (ComboBoxCellType)
DataSourceID Property (FpSpread)
DataSourceID Property (MultiColumnComboBoxCellType)
DataSourceID Property (MultiColumnEditor)
DataSourceID Property (SheetView)
DataSourceID Property (TagCloudCellType)
DataTextField Property (AjaxComboBoxCellType)
DataTextField Property (ComboBoxCellType)
DataTextField Property (TagCloudCellType)
DataTextFormatString Property
DataTitleField Property
DataTitleFormatString Property
DataType Property (ArraySegmentData)
DataType Property (CellRangeSegmentData)
DataType Property (ISupportDynamicDataSegment)
DataType Property (SeriesDataField)
DataType Property (SpreadDataColumn)
DataValueField Property (AjaxComboBoxCellType)
DataValueField Property (ComboBoxCellType)
DataViewColumnCount Property (DefaultSpreadDataViewMapper)
DataViewColumnCount Property (ISpreadDataViewMapper)
DataViewRowCount Property (DefaultSpreadDataViewMapper)
DataViewRowCount Property (ISpreadDataViewMapper)
DataWeightField Property
date cell message
date cells, format
date time cell type
date, cell type
DateCalendarCellType Class

Members
Overview

DateCalendarCellType Constructor (DateCalendarCellType)
DateDifFunction Field
DateFormat Property
DateFunction Field
DatePickerMode Enumeration
DatePickerMode Property
dates cell type
date-selection (calendar) cell type
DateTimeCellType Class

Members
Overview

DateTimeCellType Constructor (DateTimeCellType)
DateTimeCellType.EditModeSettings Class

Members
Overview

DateTimeFormat Property (DateTimeCellType)
DateTimeFormat Property (DateTimeCellType.EditModeSettings)
DateTimeFormat Property (FilterBarCellType)
DateTimeFormat Property (GeneralCellType)
DateTimeFormat Property (GeneralFormatter)
DateTimeFormat Property (IDateCellType)
DateValueFunction Field
DAverageFunction Field
DayFunction Field
Days360Function Field
DbFunction Field
DCountAFunction Field
DCountFunction Field
DdbFunction Field
Dec2BinFunction Field
Dec2HexFunction Field
Dec2OctFunction Field
decimal digits
decimal places
decimal symbol in currency
DecimalDigits Property (DoubleCellType)
DecimalDigits Property (DoubleCellType.EditModeSettings)
DecimalDigits Property (PercentCellType)
Decimals Property
DecodeObject Method
Decscending setting (SortIndicator enum)
default

header labels
header style
models
number rows, columns
sheet names

default

skins

default column width

importing
importing

Default Property (Columns)
Default Property (DefaultSkins)
Default Property (Rows)
default row height

importing
importing

Default setting (FilterListBehavior enum)
default, axis model
default, column header style
default, column header style
default, column width
default, columns
default, columns
default, data model
default, filter item
default, header border
default, renderer
default, renderer
default, resetting control
default, resetting skin
default, resetting style
default, row filtering
default, row header style
default, row header style
default, row height
default, rows
default, rows
default, selection model
default, skins
default, span model
default, style model
default, styles
default, styles
default, styles
DEFAULT_COLUMN_NAME Field
DefaultColumn (Columns.DefaultColumn Class)
DefaultColumnWidth Property
DefaultDeserializeProp Method
DefaultFilter setting (FilterListBehavior enum)
DefaultFilterItem Class

Members
Overview

DefaultFilterItem Constructor (DefaultFilterItem)
DefaultHeaderStyle Property
DefaultPage
DefaultRenderer Class

Members
Overview

DefaultRenderer Constructor (DefaultRenderer)
DefaultRow (Rows.DefaultRow Class)
DefaultRowFilter Class

Members
Overview

DefaultRowHeight Property
DefaultSerializeProp Method
DefaultSheetAxisModel Class

Members
Overview

DefaultSheetAxisModel Constructor (DefaultSheetAxisModel)
DefaultSheetDataModel Class

Members
Overview

DefaultSheetDataModel Constructor (DefaultSheetDataModel)
DefaultSheetDataModel.DataModelEnumeratorType Enumeration
DefaultSheetDataModel.DefaultSheetDataModelEnumerator Class

Members
Overview

DefaultSheetDataModel.DefaultSheetDataModelEnumerator Constructor (DefaultSheetDataModel.DefaultSheetDataModelEnumerator)
DefaultSheetSelectionModel Class

Members
Overview

DefaultSheetSelectionModel Constructor (DefaultSheetSelectionModel)
DefaultSheetSpanModel Class

Members
Overview

DefaultSheetSpanModel Constructor (DefaultSheetSpanModel)
DefaultSheetStyleModel Class

Members
Overview

DefaultSheetStyleModel Constructor (DefaultSheetStyleModel)
DefaultSkins Class

Members
Overview

DefaultSkins Constructor (DefaultSkins)
DefaultSparklineContainer Class

Members
Overview

DefaultSparklineContainer Constructor (DefaultSparklineContainer)
DefaultSpreadDataViewDataFormatter Class

Members
Overview

DefaultSpreadDataViewDataFormatter Constructor (DefaultSpreadDataViewDataFormatter)
DefaultSpreadDataViewMapper Class

Members
Overview

DefaultSpreadDataViewMapper Constructor (DefaultSpreadDataViewMapper)
DefaultStyle Property (ColumnFooter)
DefaultStyle Property (ColumnHeader)
DefaultStyle Property (FilterBar)
DefaultStyle Property (RowHeader)
DefaultStyle Property (SheetCorner)
DefaultStyle Property (SheetView)
DefaultStyleCollection Class

Members
Overview

DefaultStyleCollection Constructor (DefaultStyleCollection)
DefaultStyleName Property (ColumnFooter)
DefaultStyleName Property (ColumnHeader)
DefaultStyleName Property (RowHeader)
DefaultStyleName Property (SheetCorner)
DefaultStyleName Property (SheetView)
DefaultStyles Field
defining

cell styles
sheet skins

DegreesFunction Field
Delete command (client-side)
Delete, client-side
DeleteCommand Event
DeleteContext Method
DeleteMethod
DeleteMethod Property (FpSpread)
DeleteMethod Property (SheetView)
deleting, columns
deleting, columns
deleting, columns
deleting, rows
deleting, rows
deleting, rows
deleting, rows
deleting, See removing
deleting, See removing
deleting, See removing.
deleting, selections
deleting, selections
DelimiterCharacters Property
DeltaFunction Field
Depth Property (PlotArea)
Depth Property (XYZPlotArea)
DescriptionUrl Property
Deserialize Method (Appearance)
Deserialize Method (Background)
Deserialize Method (BaseDropDownCellType)
Deserialize Method (BaseFilterItem)
Deserialize Method (BaseSparkline)
Deserialize Method (Border)
Deserialize Method (ButtonCellType)
Deserialize Method (CalendarDropDownStyleInfo)
Deserialize Method (CheckBoxCellType)
Deserialize Method (ColorFilterItem)
Deserialize Method (ColumnSparklineRenderer)
Deserialize Method (ComboBoxCellType)
Deserialize Method (CommandBarInfo)
Deserialize Method (CurrencyCellType)
Deserialize Method (CustomFilterItem)
Deserialize Method (DateTimeCellType)
Deserialize Method (DefaultRowFilter)
Deserialize Method (DefaultSheetAxisModel)
Deserialize Method (DefaultSheetDataModel)
Deserialize Method (DefaultSheetSelectionModel)
Deserialize Method (DefaultSheetSpanModel)
Deserialize Method (DefaultSheetStyleModel)
Deserialize Method (DefaultSparklineContainer)
Deserialize Method (DoubleCellType)
Deserialize Method (DynamicFilterItem)
Deserialize Method (ExcelBaseSparkLineRenderer)
Deserialize Method (ExcelSparkline)
Deserialize Method (ExcelSparklineGroup)
Deserialize Method (ExcelSparklineSetting)
Deserialize Method (FilterCondition)
Deserialize Method (FilterItemCollection)
Deserialize Method (FilterItemValue)
Deserialize Method (FilterItemValueCollection)
Deserialize Method (GeneralCellType)
Deserialize Method (GroupDataModel)
Deserialize Method (GroupInfo)
Deserialize Method (GroupInfoCollection)
Deserialize Method (HideRowFilter)
Deserialize Method (HierBarInfo)
Deserialize Method (HyperLinkCellType)
Deserialize Method (IconFilterItem)
Deserialize Method (ImageCellType)
Deserialize Method (Inset)
Deserialize Method (IntegerCellType)
Deserialize Method (ISerializeData)
Deserialize Method (ISerializePresentation)
Deserialize Method (ISerializeSettings)
Deserialize Method (ISerializeStyles)
Deserialize Method (ISerializeSupport)
Deserialize Method (LabelCellType)
Deserialize Method (LayoutTemplate)
Deserialize Method (LineSparklineRenderer)
Deserialize Method (ListBoxCellType)
Deserialize Method (MaskedEditValidator)
Deserialize Method (MultiColumnComboBoxCellType)
Deserialize Method (MultiValuesFilterItem)
Deserialize Method (NamedStyle)
Deserialize Method (NamedStyleCollection)
Deserialize Method (PagerInfo)
Deserialize Method (PercentCellType)
Deserialize Method (PreviewRowInfo)
Deserialize Method (RadioButtonListCellType)
Deserialize Method (RegExpCellType)
Deserialize Method (SheetSkin)
Deserialize Method (StyleInfo)
Deserialize Method (StyleRowFilter)
Deserialize Method (TabInfo)
Deserialize Method (TagCloudCellType)
Deserialize Method (TextCellType)
Deserialize Method (TitleInfo)
Deserialize Method (Top10FilterItem)
Deserialize Method (TouchInfo)
Deserialize Method (WinLossSparklineRenderer)
DeserializeByteArray Method
DeserializeColorValue Method
DeserializeDateTimeFormatInfo Method
DeserializeDateValue Method
DeserializeEditor Method (DateCalendarCellType)
DeserializeEditor Method (MutuallyExclusiveCheckBoxCellType)
DeserializeEntry Method (AverageConditionalFormattingRule)
DeserializeEntry Method (BetweenValuesConditionalFormattingRule)
DeserializeEntry Method (BlankConditionalFormattingRule)
DeserializeEntry Method (ConditionalFormattingRule)
DeserializeEntry Method (DatabarConditionalFormattingRule)
DeserializeEntry Method (ErrorConditionalFormattingRule)
DeserializeEntry Method (FormulaConditionalFormattingRule)
DeserializeEntry Method (HighlightConditionalFormattingRule)
DeserializeEntry Method (IconSetConditionalFormattingRule)
DeserializeEntry Method (PrePaintTextConditionalFormattingRule)
DeserializeEntry Method (TextConditionalFormattingRule)
DeserializeEntry Method (TimePeriodConditionalFormattingRule)
DeserializeEntry Method (TopRankedValuesConditionalFormattingRule)
DeserializeEntry Method (TwoColorScaleConditionalFormattingRule)
DeserializeEntry Method (UnaryComparisonConditionalFormattingRule)
DeserializeEntry Method (UniqueOrDuplicatedConditionalFormattingRule)
DeserializeEnumValue Method
DeserializeExtenders Method
DeserializeFont Method
DeserializeImage Method
DeserializeIntArray Method
DeserializeNumberFormatInfo Method
DeserializePointFArray Method
DeserializeString Method
DeserializeStringArray Method
DesignTimeCellTypeConverter Class

Members
Overview

DesignTimeCellTypeConverter Constructor (DesignTimeCellTypeConverter)
DesignTimeOnly Property
destination
destination
DetachmentCollection Class

Members
Overview

DetachmentCollection Constructor (DetachmentCollection)
DetachObjectExpression Method
Developer’s Guide

FarPoint Spread for ASP.NET

Developer's Guide

FarPoint Spread for ASP.NET

developing custom HTC files
DevSqFunction Field
DGetFunction Field
dialog box

printing

dialogs

Formula editor

DiffuseColor Property
digits, decimal places
dimensions
Direction Property (DatabarConditionalFormattingRule)
Direction Property (GripHitTest)
DirectionalLight Class

Members
Overview

DirectionalLight Constructor (DirectionalLight)
DirectionX Property
DirectionY Property
DirectionZ Property
Disabled Property
Disabled setting (ImeMode enumeration)
DisabledImgUrl Property
DiscFunction Field
display data
display text
DisplayAtTopOfList Property (BaseFilterItem)
DisplayAtTopOfList Property (ColorFilterItem)
DisplayAtTopOfList Property (CustomFilterItem)
DisplayAtTopOfList Property (DefaultFilterItem)
DisplayAtTopOfList Property (DynamicFilterItem)
DisplayAtTopOfList Property (IconFilterItem)
DisplayAtTopOfList Property (IFilterItem)
DisplayAtTopOfList Property (MultiValuesFilterItem)
DisplayAtTopOfList Property (Top10FilterItem)
DisplayCount Property (TagCloudCellType)
DisplayCount Property (TagCloudRenderer)
DisplayEmptyCellsAs Property
DisplayHidden Property
displaying

active cell
active sheet
command bar
command bar
date and time
hiding rows or columns
number of rows
sheet names
top row

displaying, child in hierarchy
displaying, column headers
displaying, command bar buttons
displaying, page
displaying, page numbers
displaying, pager
displaying, rows per page
displaying, scroll bars
displaying, See hiding
displaying, See hiding
displaying, sheet names
displaying, sheet names
displaying, sheets
displaying, top row
displaying,sheet names
DisplayLimit Enumeration
DisplayLimit Property (TagCloudCellType)
DisplayLimit Property (TagCloudRenderer)
DisplayMoney Property
DisplayName Property (BaseFilterItem)
DisplayName Property (ColorFilterItem)
DisplayName Property (CustomFilterItem)
DisplayName Property (DefaultFilterItem)
DisplayName Property (DynamicFilterItem)
DisplayName Property (IconFilterItem)
DisplayName Property (IFilterItem)
DisplayName Property (MultiValuesFilterItem)
DisplayName Property (Top10FilterItem)
displays

grouping affect on

DisplayText Property
DisplayTextAscending setting (SortOrder enum)
DisplayTextDescending setting (SortOrder enum)
DisplayUnits Property (PolarRadiusAxis)
DisplayUnits Property (RadarValueAxis)
DisplayUnits Property (ValueAxis)
DisplayXAxis Property
Dispose Method (CellRangeSegmentData)
Dispose Method (ErrorForm)
Dispose Method (ExcelSparkline)
Dispose Method (ExcelSparklineGroup)
Dispose Method (ExcelSparklineSetting)
Dispose Method (FpChart)
Dispose Method (ListBase.Enumerator<T>)
Dispose Method (SeriesDataField)
Dispose Method (SpreadDataSource)
Dispose Method (SpreadDataView)
DivideByZero Property
DivideOperator Field
DMaxFunction Field
DMinFunction Field
doc type
DOCTYPE
DocumentMode Enumeration
DocumentMode Property
DollarDeFunction Field
DollarFrFunction Field
DollarFunction Field
DoNotRecalculateAfterLoad setting (ExcelOpenFlags enum)
Dotted setting (FocusBorderStyle enum)
double cell type
double cell value
double cell value
double, cell type
DoubleCellType Class

Members
Overview

DoubleCellType Constructor (DoubleCellType)
DoubleCellType.EditModeSettings Class

Members
Overview

DoubleCellType.EditModeSettings Constructor (DoubleCellType.EditModeSettings)
DoubleCollection Class

Members
Overview

DoubleCollection Constructor (DoubleCollection)
DoubleCollectionCollection Class

Members
Overview

DoubleCollectionCollection Constructor (DoubleCollectionCollection)
DoubleCollectionCollectionCodeDomSerializer Class

Members
Overview

DoubleCollectionCollectionCodeDomSerializer Constructor (DoubleCollectionCollectionCodeDomSerializer)
DoubleCollectionCustomTypeDescriptor Class

Members
Overview

DoubleCollectionCustomTypeDescriptor Constructor (DoubleCollectionCustomTypeDescriptor)
DoubleCollectionPropertyDescriptor Class

Members
Overview

DoubleCollectionPropertyDescriptor Constructor (DoubleCollectionPropertyDescriptor)
DoubleCollectionTypeDescriptionProvider Class

Members
Overview

DoubleCollectionTypeDescriptionProvider Constructor (DoubleCollectionTypeDescriptionProvider)
DoubleExpression Class

Members
Overview

DoubleExpression Constructor (DoubleExpression)
double-precision floating-point number (cell type)
DoubleValue Property
DoubleValues Property
doughnut
DownBorder Property
DownBorders Property
DownFill Property
DownFills Property
downlevel browser
DownLine Property
DownLines Property
DownThenOver setting (PrintPageOrder)
DProductFunction Field
DragColumnCssClass Property
DragDirection Enumeration
dragging

columns

dragging, column
DrawBackgroundImage Method
drop-down

filtering

drop-down list cell
drop-down list cell
DropDownButton Property
DropDownControlStyleInfo Property
DropDownStyle Property
DropLinesLine Property (AreaSeries)
DropLinesLine Property (HighLowAreaSeries)
DropLinesLine Property (LineSeries)
DropLinesLine Property (PointSeries)
DropLinesVisible Property (AreaSeries)
DropLinesVisible Property (HighLowAreaSeries)
DropLinesVisible Property (LineSeries)
DropLinesVisible Property (PointSeries)
DStDevFunction Field
DStDevPFunction Field
DSumFunction Field
DurationFunction Field
DVarFunction Field
DVarPFunction Field
DynamicFilterItem Class

Members
Overview

DynamicFilterItem Constructor (DynamicFilterItem)
DynamicFilterType Enumeration
ECMAScript
EDateFunction Field
Edit command (client-side)
edit mode
edit mode
edit mode

ending client-side
starting client-side
template client-side

Edit, client-side
editable, cell
editable, cell
EditBaseCellType Class

about

EditCommand Event
EditMode Property (CurrencyCellType)
EditMode Property (DateTimeCellType)
EditMode Property (DoubleCellType)
EditMode Property (IntegerCellType)
EditModePermanent Property
EditModeReplace Property
EditModeSettings Class

Members
Overview

editor
editor
editor
Editor Field
Editor Property (AjaxComboBoxCellType)
Editor Property (AlternatingRow)
Editor Property (Cell)
Editor Property (Column)
Editor Property (ExtenderCellType)
Editor Property (MutuallyExclusiveCheckBoxCellType)
Editor Property (NamedStyle)
Editor Property (RatingCellType)
Editor Property (Row)
Editor Property (SlideShowCellType)
Editor Property (StyleInfo)
editor, check box cells
editor, client-side script
editor, client-side script
editor, combo box cells
editor, control
editor, control
editor, control
editor, control
editor, control
editor, generic text
editor, list box cells
editor, radio button list cells
editor, value in
editor, value in
EditorClientScriptUrl Property (BaseCellType)
EditorClientScriptUrl Property (BaseEditor)
EditorClientScriptUrl Property (ComboBoxCellType)
EditorClientScriptUrl Property (IEditor)
EditorClientScriptUrl2 Method
EditorCssClass Property (GeneralCellType)
EditorCssClass Property (IEditorCSSClassSupport)
EditorCssClass Property (TextCellType)
editors

Collection
cell types
Cells, Columns, and Rows
Cells, Columns, and Rows
data key names
data key names
formula
formula
Formula Editor
grouping headers
grouping headers
headers
headers
row template
row template
sheet skins
sheet skins
sheets
sheets
Spread Designer
styles
styles

editors, Editor namespace
editors, interface
EditRow Property
EditTemplateColumnCount Property
EditValue Method
EditValues Property
effect
EffectFunction Field
elevation
Elevation Property
empty area, headers
empty areas

appearance
headers

Empty Field (DataFieldChangedEventArgs)
Empty Field (LinearRange)
Empty Field (SegmentDataChangedEventArgs)
empty, cell
empty, cell
empty, cell type
EmptyCellType Class

Members
Overview

EmptyCellType Constructor (EmptyCellType)
EmptyStarCssClass Property
EmptyValueMessage Property
EmptyValueStyle Enumeration
EmptyValueStyle Property
Enable Property
EnableAjaxCall Property
EnableCaching Property
EnableClickEvent Property
EnableClientScript Property
EnableContextMenu Property
EnableCrossSheetReference Property
Enabled Property
EnabledImgUrl Property
EnableGroupFooter Property (GroupDataModel)
EnableGroupFooter Property (IGroupSupport)
EnableHandleAnimation Property
EnablejQueryTheme Property
EnableOnClient Property
EnableRowEditTemplate Property
enabling

AJAX

enabling client scripts
EncodeObject Method
EncodeValue Field (AppearanceProperty)
EncodeValue Field (SheetStyleProperty)
EncodeValue Property (AlternatingRow)
EncodeValue Property (Appearance)
EncodeValue Property (Cell)
EncodeValue Property (Column)
EncodeValue Property (FpSpread)
EncodeValue Property (Row)
EncodeValue Property (StyleInfo)
End Field
EndEdit Method
EndEdit, client-side
EndFactor Property
EndInit Method
EndProcessRequest Method
engine, calculation
EnsureDataBound Method
entity
EoMonthFunction Field
Equality Operator (CellRange)
Equality Operator (ConditionalFormattingValue)
Equality Operator (LinearRange)
Equality Operator (NamedStyle)
Equality Operator (PaddingF)
Equality Operator (SheetCellRange)
Equality Operator (StyleInfo)
EqualOperator Field
Equals Method (AlternatingRow)
Equals Method (Border)
Equals Method (Cell)
Equals Method (CellRange)
Equals Method (Column)
Equals Method (ConditionalFormattingColorValue)
Equals Method (ConditionalFormattingValue)
Equals Method (FilterItemValue)
Equals Method (Inset)
Equals Method (LinearRange)
Equals Method (MapperInfo)
Equals Method (NamedStyle)
Equals Method (PaddingF)
Equals Method (Row)
Equals Method (SeriesInfo)
Equals Method (SheetCellRange)
Equals Method (SheetSkin)
Equals Method (StyleInfo)
EqualTo setting (ComparisonOperator enum)
EResize setting (CursorType enum)
ErfcFunction Field
ErfFunction Field
error message
error message
error message
ErrorCommand Event
ErrorConditionalFormattingRule Class

Members
Overview

ErrorConditionalFormattingRule Constructor (ErrorConditionalFormattingRule)
ErrorExpression Class

Members
Overview

ErrorExpression Constructor (ErrorExpression)
ErrorForm Class

Members
Overview

ErrorForm Constructor (ErrorForm)
ErrorMessage Property (DateTimeCellType)
ErrorMessage Property (EmptyCellType)
ErrorMessage Property (GeneralCellType)
ErrorMessage Property (MaskedEditValidator)
ErrorMessage Property (TextCellType)
ErrorOffset Property
errors, calculation
ErrorTypeFunction Field
ErrorValue Property
EuroConvertFunction Field
EuroFunction Field
Evaluate Method (BinaryOperatorInfo)
Evaluate Method (ConditionalFormatting)
Evaluate Method (FunctionInfo)
Evaluate Method (IntersectOperatorInfo)
Evaluate Method (UnaryOperatorInfo)
Evaluate Method (UnionOperatorInfo)
EvaluateExpression Method (DefaultSheetDataModel)
EvaluateExpression Method (IExpressionSupport2)
EvenFunction Field
EvenRowBackColor Property
events

effect of EnableClientScript
mapping to function in client-side
page load
post back

ExactFunction Field
Excel

colors

Excel 2007
Excel file

exporting
importing
exporting
importing

Excel files

loading from
opening
saving to

Excel files, loading from
Excel files, opening
Excel files, saving to
Excel files, sheet names
Excel formats
Excel formats
Excel, exceptions
Excel, exceptions
Excel, opening files
Excel, opening in sheet
Excel, saving files
Excel, saving Spread
Excel, saving Spread
Excel, warnings
Excel, warnings
Excel, warnings
ExcelBaseSparkLineRenderer Class

Members
Overview

ExcelException Class

Members
Overview

ExcelExceptionCode Enumeration
ExcelOpenFlags Enumeration
ExcelSaveFlag Enumeration (overview)
ExcelSaveFlags Enumeration
ExcelSheetIndexOutOfRange setting (ExcelExceptionCode enum)
ExcelSheetNameNotFound setting (ExcelExceptionCode enum)
ExcelSparkline Class

Members
Overview

ExcelSparkline Constructor (ExcelSparkline)
ExcelSparklineGroup Class

Members
Overview

ExcelSparklineGroup Constructor (ExcelSparklineGroup)
ExcelSparklineSetting Class

Members
Overview

ExcelSparklineSetting Constructor (ExcelSparklineSetting)
ExcelWarning Class

Members
Overview

ExcelWarningCode Enumeration
ExcelWarningList Class

Members
Overview

ExcelWarningList Constructor (ExcelWarningList)
exception handling
exceptions, Excel
exceptions, Excel-related
exceptions,parsing
ExcludeContents Enumeration
ExcludeContents Property
Execute Method (FormulaConditionalFormattingRule)
Execute Method (HighlightConditionalFormattingRule)
Execute Method (IPrePaintConditionalFormattingRule)
Execute Method (PrePaintConditionalFormattingRule)
Execute Method (TwoColorScaleConditionalFormattingRule)
ExecuteSelect Method
Expandable Property
ExpandAll Method
Expanded Property
ExpandIconOnRight Property
ExpandImage Field
expanding

customizing images
grouping
row
rows in hierarchy

expanding properties
expanding, rows
expando properties
ExpandRow Method
ExpandRow, client-side
ExpandView command (client-side)
ExpFunction Field
ExponDistFunction Field
ExponentOperator Field
exporting

cell types
column settings
row settings
sheet settings
Spread settings
cell types
chart settings
column settings
row settings
sheet settings
Spread settings

ExportTo Method
expression (see regular expression)
expression cell type
expression cell type (see regular expression cell type)
Expression Class

Members
Overview

ExpressionConsumerFormulaInfo Class

Members
Overview

ExpressionConsumerFormulaInfo Constructor (ExpressionConsumerFormulaInfo)
expressions

names in formulas

expressions, base class
expressions, cells
expressions, cross-sheet references
expressions, formulas
expressions, formulas
expressions, formulas
expressions, formulas
expressions, named variable
expressions, operators
expressions, operators
expressions, range of cells
expressions, references
expressions, regular expression
expressions, validation
expressions, variable names
ExtenderCellType Class

Members
Overview

ExtenderCellType Constructor (ExtenderCellType)
ExtenderCellTypeBase Class

Members
Overview

ExtenderCssClass Property
extenders

ASP.NET AJAX

extenders, cell types
ExternalCellExpression Class

Members
Overview

ExternalCellExpression Constructor (ExternalCellExpression)
ExternalNameExpression Class

Members
Overview

ExternalNameExpression Constructor (ExternalNameExpression)
ExternalRangeExpression Class

Members
Overview

ExternalRangeExpression Constructor (ExternalRangeExpression)
ExternalReferenceExpression Class

Members
Overview

ExtractNode Method
ExtraRendererSettings Class

Members
Overview

ExtraRendererSettings Constructor (ExtraRendererSettings)
ExtraRendererSettings Property (BaseCellType)
ExtraRendererSettings Property (BaseRenderer)
face color, scroll bars
FactDoubleFunction Field
FactFunction Field
FailedOnFileOpen setting (ExcelExceptionCode enum)
FalseFunction Field
FarPoint Spread assembly
FarPoint Spread command
FarPoint Spread command
FarPoint Spread component
FarPoint Spread for ASP.NET

Import and Export Reference

FarPoint Spread for Web Forms
FarPoint Spread for Web Forms
FarPoint Spread object (client side)
FarPoint Spread object (client side)
FarPoint Spread object (client side)
FarPoint Spread object (client side)
FarPoint Spread object (client side)
FarPoint Spread XML files, loading from
FarPoint Spread XML files, opening
FarPoint spreadsheet component
FarPoint.CalcEngine Assembly

Overview

FarPoint.CalcEngine Namespace

Overview

FarPoint.Excel Assembly

Overview

FarPoint.Excel Namespace

Overview

FarPoint.Mvc.Spread Assembly

Overview

FarPoint.Mvc.Spread Namespace

Overview

FarPoint.Web.Chart Assembly

Overview

FarPoint.Web.Chart Namespace

Overview

FarPoint.Web.Spread Assembly

Overview

FarPoint.Web.Spread Namespace

Overview

FarPoint.Web.Spread.Chart Namespace

Overview

FarPoint.Web.Spread.Data Namespace

Overview

FarPoint.Web.Spread.Editor Namespace

Overview

FarPoint.Web.Spread.Extender Assembly

Overview

FarPoint.Web.Spread.Extender Namespace

Overview

FarPoint.Web.Spread.Model Namespace

Overview

FarPoint.Web.Spread.Renderer Namespace

Overview

FDistFunction Field
features

AJAX
ASP.NET AJAX extenders
built-in functions
cell types
chart control
column footer
conditional formatting
data binding
designer
designer
filtering
frozen columns
frozen columns
goal seeking
grouping
grouping affect on
hierarchy
import and export
load on demand
load on demand
multiple headers
multiple sheets
multiple-line columns
preview
printing
printing
searching
sheet corner
skins
sorting
spanning cells
Spread Designer
Spread Wizard
subtitle
template
title

FetchGroupText Event
FetchGroupTextEventArgs Class

Members
Overview

FetchGroupTextEventArgs Constructor (FetchGroupTextEventArgs)
FetchGroupTextEventHandler Delegate
FieldName Property
file

exporting to Excel
importing from Excel
exporting to Excel
importing from Excel

file type
FileImageRender Class

Members
Overview

FileImageRender Constructor (FileImageRender)
FileName Property
files

HTC
HTC
loading
loading from Excel files
loading from Spread XML files
loading from text files
opening
opening Excel files
opening Spread XML files
opening text files
saving to
saving to Excel files
saving to Spread XML files
XLSX support

files, loading from Excel files
files, loading from FarPoint Spread XML files
files, loading from text files
files, opening Excel files
files, opening FarPoint Spread XML files
files, opening text files
files, saving to Excel files
files, saving to Spread XML files
fill
Fill Class

Members
Overview

Fill Property (ChartModel)
Fill Property (LabelArea)
Fill Property (LegendArea)
Fill Property (Stripe)
Fill Property (Wall)
FillCollection Class

Members
Overview

FillCollection Constructor (FillCollection)
FillColor Property
FilledStarCssClass Property
filter
filter
filter bar

customizing images

filter items, base
Filter Method (BaseFilterItem)
Filter Method (ColorFilterItem)
Filter Method (CustomFilterItem)
Filter Method (DefaultFilterItem)
Filter Method (DynamicFilterItem)
Filter Method (IconFilterItem)
Filter Method (IFilterItem)
Filter Method (MultiValuesFilterItem)
Filter Method (Top10FilterItem)
FilterBar Class

Members
Overview

FilterBar Property
FilterBarBackColor Property
FilterBarCellType Class

Members
Overview

FilterBarCellType Constructor (FilterBarCellType)
FilterBarDefault Field
FilterBarForeColor Property
FilterBarHeaderBackColor Property
FilterBarHeaderForeColor Property
FilterBarHeaderParent Property
FilterBarMode Enumeration
FilterBarMode Property
FilterBarParent Property
FilterBlank Property
FilterColumnDefinition Class

Members
Overview

FilterColumnDefinition Constructor (FilterColumnDefinition)
FilterColumnDefinitionCollection Class

Members
Overview

FilterColumnDefinitionCollection Constructor (FilterColumnDefinitionCollection)
FilterCondition Class

Members
Overview

FilterCondition Constructor (FilterCondition)
filtered cell type
Filtered Property
filtered text cell type
filtered-in style
filtered-out style
FilteredTextCellType Class

Members
Overview

FilteredTextCellType Constructor (FilteredTextCellType)
FilterFrozenRows Property (DefaultRowFilter)
FilterFrozenRows Property (IRowFilterFrozenSupport)
filtering
filtering
filtering
filtering
filtering
filtering

custom filter
enhanced
filter bar
hiding row
setting style

filtering, allowing
filtering, base filter item
filtering, column definitions
filtering, column definitions
filtering, combo box
filtering, default filter item
filtering, default row
filtering, hiding
filtering, items
filtering, list behavior
filtering, rows
filtering, styles
FilterInterval Property
FilterItemCollection Class

Members
Overview

FilterItemCollection Constructor (FilterItemCollection)
FilterItems Property
FilterItemValue Class

Members
Overview

FilterItemValue Constructor (FilterItemValue)
FilterItemValueCollection Class

Members
Overview

FilterItemValueCollection Constructor (FilterItemValueCollection)
FilterListBehavior Enumeration
FilterMenuType Enumeration
FilterMode Property
Filters Property
filters, cell type
filters, clear
filters, column
filters, default item
filters, list behavior
filters, reset
filters, resetting
filters, resetting
filters, styles
FilterString Property
FilterTextColor Property
FilterType Property
Finalize Method (CellRangeSegmentData)
Finalize Method (SeriesDataField)
Find Method (BaseSheetSpanModel)
Find Method (ConditionalFormattingModel)
Find Method (DefaultSheetSpanModel)
Find Method (DefaultSkins)
Find Method (DefaultStyleCollection)
Find Method (IConditionalFormattingModel)
Find Method (ISheetSpanModel)
Find Method (NamedStyleCollection)
FindChildView Method
FindControl Method
FindFunction Field
finding

value with GoalSeek

finding (searching)
FindIntersection Method
FindRules Method (ConditionalFormattingModel)
FindRules Method (IConditionalFormattingModel)
FInvFunction Field
FireChanged Method (BaseSheetStyleModel)
FireChanged Method (DefaultSparklineContainer)
FireChanged Method (ExcelSparklineSetting)
FireChanging Method
FireClearItems Method
Firefox

browser support

FireItemAdded Method
FireItemRemoved Method
FireItemUpdated Method
FirePropertyChanged Method
FireUpdated Method (BaseSparkline)
FireUpdated Method (ExcelSparklineGroup)
FireUpdated Method (ExcelSparklineSetting)
first column number
first page
first row number
FirstColumnIndex Property
FirstCondition Property (ConditionalFormat)
FirstCondition Property (CustomFilterItem)
FirstConditionExpression Property
FirstDayOfWeek Property
FirstFormula Property
FirstMarkerColor Property
FirstPageNumber Property
FirstReference Property
FirstRowSelected Property
FirstValue Property
FirstVisibleTab Property
FisherFunction Field
FisherInvFunction Field
fixed size
FixedFunction Field
FixedPoint Property (CurrencyCellType)
FixedPoint Property (CurrencyCellType.EditModeSettings)
FixedPoint Property (CurrencyFormatter)
FixedPoint Property (DoubleCellType)
FixedPoint Property (DoubleCellType.EditModeSettings)
FixedPoint Property (PercentCellType)
flags, searching
FlatColumnFooter Property
FlatColumnHeader Property
FlatRowHeader Property
floating-point number (cell type)
FloorFunction Field
FlushData Method
FocusBorderStyle Enumeration
FocusRectangleBorderColor Property
FocusRectangleBorderStyle Property
Font Field (AppearanceProperty)
Font Field (SheetStyleProperty)
Font Property (AlternatingRow)
Font Property (Appearance)
Font Property (CalendarDropDownStyleInfo)
Font Property (Cell)
Font Property (Column)
Font Property (CommandBarInfo)
Font Property (GroupInfo)
Font Property (HierBarInfo)
Font Property (NamedStyle)
Font Property (PagerInfo)
Font Property (PreviewRowInfo)
Font Property (Row)
Font Property (StyleInfo)
Font Property (TitleInfo)
FontName Property
fonts

importing
importing

FontStyle Property (HighlightConditionalFormattingRule)
FontStyle Property (HighlightConditionalFormattingStyle)
Footer Property (PrintInfo)
Footer Property (PrintMargin)
FooterBackColor Property
FooterDefault Property
FooterFontBold Property
FooterForeColor Property
FooterHeight Property
footers

overview
printing
printing

footers, column
ForecastFunction Field
ForeColor Field (AppearanceProperty)
ForeColor Field (SheetStyleProperty)
ForeColor Property (AlternatingRow)
ForeColor Property (Appearance)
ForeColor Property (ButtonCellType)
ForeColor Property (ButtonRenderer)
ForeColor Property (CalendarDropDownStyleInfo)
ForeColor Property (Cell)
ForeColor Property (Column)
ForeColor Property (GroupInfo)
ForeColor Property (HierBarInfo)
ForeColor Property (HighlightConditionalFormattingRule)
ForeColor Property (HighlightConditionalFormattingStyle)
ForeColor Property (NamedStyle)
ForeColor Property (PagerInfo)
ForeColor Property (PreviewRowInfo)
ForeColor Property (Row)
ForeColor Property (StyleInfo)
ForeColor Property (TagCloudRenderer)
ForeColor Property (TitleInfo)
ForeColorFilterSupport Property
foreground colors
foreground colors
foreground colors
foreground colors, alternating rows
foreground colors, appearance
foreground colors, cells
foreground colors, cells
foreground colors, columns
foreground colors, list box
foreground colors, rows
foreground colors, selections
foreground colors, styles
format label
Format Method (AjaxComboBoxCellType)
Format Method (BaseCellType)
Format Method (CheckBoxCellType)
Format Method (ComboBoxCellType)
Format Method (CurrencyCellType)
Format Method (CurrencyFormatter)
Format Method (DateCalendarCellType)
Format Method (DateTimeCellType)
Format Method (DoubleCellType)
Format Method (GeneralCellType)
Format Method (GeneralFormatter)
Format Method (IEditFormatter)
Format Method (IEnhancedFormatter)
Format Method (IFormatter)
Format Method (IntegerCellType)
Format Method (ListBoxCellType)
Format Method (MultiColumnComboBoxCellType)
Format Method (NumericUpDownCellType)
Format Method (PercentCellType)
Format Method (RadioButtonListCellType)
Format Method (RegExpCellType)
Format Method (SliderCellType)
Format Method (TagCloudCellType)
Format Method (TextCellType)
format strings, parsing
FormatForPdf Method (BaseCellType)
FormatForPdf Method (RadioButtonListCellType)
FormatString Property (DateTimeCellType)
FormatString Property (DateTimeCellType.EditModeSettings)
FormatString Property (FilterBarCellType)
FormatString Property (GeneralCellType)
FormatString Property (GeneralFormatter)
FormatString Property (IDateCellType)
FormatString Property (LabelCellType)
formatter

cell types

Formatter Field
Formatter Property (AlternatingRow)
Formatter Property (Cell)
Formatter Property (Column)
Formatter Property (ExtraRendererSettings)
Formatter Property (HighlightConditionalFormattingRule)
Formatter Property (HighlightConditionalFormattingStyle)
Formatter Property (NamedStyle)
Formatter Property (Row)
Formatter Property (SpreadDataColumn)
Formatter Property (StyleInfo)
formatter, general formatter
formatter, interface
formatter,currency
formatting

conditional
conditional
inheriting

formatting information (importing)
formatting, conditional
formatting, conditional
formatting, conditional
formula bar
Formula Editor
Formula Editor
Formula Property (AggregateArgs)
Formula Property (Cell)
Formula Property (Column)
Formula Property (ExcelSparkline)
Formula Property (ExcelSparklineSetting)
Formula Property (FormulaConditionalFormattingRule)
Formula Property (Row)
Formula Property (Rows.DefaultRow)
Formula Property (SeriesDataField)
Formula Property (SpreadChart)
Formula Property (TextConditionalFormattingRule)
Formula Property (UnaryComparisonConditionalFormattingRule)
formula reference style

importing
importing

Formula toolbar
formula, recalculation
FormulaChanged Event (ExcelSparkline)
FormulaChanged Event (ExcelSparklineGroup)
FormulaChanged Event (ExcelSparklineSetting)
FormulaChanged Event (ISheetCellRangeSupport)
FormulaChanged Property (DataFieldChangedEventArgs)
FormulaChanged Property (SegmentDataChangedEventArgs)
FormulaChangedType Enumeration
FormulaConditionalFormattingRule Class

Members
Overview

FormulaConditionalFormattingRule Constructor (FormulaConditionalFormattingRule)
FormulaContextType Enumeration
FormulaCount Property
FormulaElementExceedsExcelLimits setting (ExcelWarningCode enum)
FormulaElementNotFound setting (ExcelWarningCode enum)
FormulaElementNotSupported setting (ExcelWarningCode enum)
FormulaErrorNotifyFarPoint setting (ExcelWarningCode enum)
FormulaRestrictedCondition Enumeration
FormulaRestrictedException Class

Members
Overview

FormulaRestrictedException Constructor (FormulaRestrictedException)
formulas
formulas
formulas

client-side
importing
adding to sheet
cell reference
cell types
custom functions
custom name
custom names
data types
Formula Editor
Formula Editor
goal seeking
goal seeking
importing
nesting functions
one-based

formulas, allowing user
formulas, arrays
formulas, as expressions
formulas, as expressions
formulas, calculation
formulas, calculation errors
formulas, cell reference
formulas, cell reference style
formulas, clearing
formulas, converting data types
formulas, custom names
formulas, custom names
formulas, expressions
formulas, functions
formulas, in cell
formulas, in row
formulas, in sheet
formulas, in sheet
formulas, in sheet
formulas, in sheet
formulas, iteration support
formulas, iterations
formulas, iterations
formulas, iterations
formulas, missing arguments
FpCategoryAttribute Class

Members
Overview

FpCategoryAttribute Constructor (FpCategoryAttribute)
FpChart Class

Members
Overview

FpChart Constructor (FpChart)
FpChartBuilder Class

Members
Overview

FpChartBuilder Constructor (FpChartBuilder)
FpSpread Class
FpSpread Class

Members
Members
Overview
Overview

FpSpread component
FpSpread Constructor (FpSpread)
FpSpread Constructor (FpSpread)
FpSpread Designer
FpSpread Property
FpSpread, background color
fpspread.htc file
FpSpreadAdapter Property
FpSpreadTemplateReplacement Class

Members
Overview

FpSpreadTemplateReplacement Constructor (FpSpreadTemplateReplacement)
FrequencyFunction Field
From Property
frozen columns

overview
overview

frozen rows

overview
overview

frozen, columns
frozen, rows
FrozenColumnCount Property
FrozenIndicatorImage Field
FrozenRowCount Property
FTestFunction Field
Function Property
FunctionExpression Class

Members
Overview

FunctionExpression Constructor (FunctionExpression)
FunctionInfo Class

Members
Overview

FunctionName Property
functions
functions
functions

importing
custom
nesting in formula

functions, adding
functions, custom
functions, custom
functions, expressions
functions, expressions
functions, in cell
functions, in row
functions, in sheet
functions, in sheet
functions, in sheet
functions, in sheet
functions, removing custom
FvFunction Field
FvScheduleFunction Field
GammaDistFunction Field
GammaInvFunction Field
GammaLnFunction Field
GAP_WIDTH Field
GapDepth Property (AreaSeries)
GapDepth Property (BarSeries)
GapDepth Property (CandlestickSeries)
GapDepth Property (ClusteredBarSeries)
GapDepth Property (HighLowAreaSeries)
GapDepth Property (HighLowBarSeries)
GapDepth Property (LineSeries)
GapDepth Property (PointSeries)
GapDepth Property (PolarAreaSeries)
GapDepth Property (PolarLineSeries)
GapDepth Property (PolarPointSeries)
GapDepth Property (RadarAreaSeries)
GapDepth Property (RadarLineSeries)
GapDepth Property (RadarPointSeries)
GapDepth Property (StackedAreaSeries)
GapDepth Property (StackedBarSeries)
GapDepth Property (StackedLineSeries)
GapDepth Property (StackedPointSeries)
GapDepth Property (XYBubbleSeries)
GapDepth Property (XYLineSeries)
GapDepth Property (XYPointSeries)
GapWidth Property (BarSeries)
GapWidth Property (CandlestickSeries)
GapWidth Property (ClusteredBarSeries)
GapWidth Property (HighLowBarSeries)
GapWidth Property (HighLowCloseSeries)
GapWidth Property (OpenHighLowCloseSeries)
GapWidth Property (StackedBarSeries)
GcdFunction Field
general cell type
general cell type
general cells, editor
General setting (ExcelWarningCode enum)
GeneralCellType Class

Members
Overview

GeneralCellType Constructor (GeneralCellType)
GeneralEditor Class

Members
Overview

GeneralEditor Constructor (GeneralEditor)
GeneralFormatter Class

Members
Overview

GeneralFormatter Constructor (GeneralFormatter)
GenerateEmptyAlternateText Property
GenerateFromCellRanges Method
GenerateSegmentDataList Method
generating columns
generic cell message
generic cell type
generic cell type (see general cell type)
generic text box cells, editor
GeoMeanFunction Field
GeStepFunction Field
GetActiveChart, client-side
GetActiveChildSheetView, client-side
getactivecol
GetActiveRow
GetAdjustingFormulaInfo Method
GetAggregateValue Method
GetAggregationResult Method (DefaultSheetDataModel)
GetAggregationResult Method (GroupDataModel)
GetAggregationResult Method (IAggregationSupport)
GetAggregationType Method (DefaultSheetDataModel)
GetAggregationType Method (GroupDataModel)
GetAggregationType Method (IAggregationSupport)
GetAllRules Method (PrePaintConditionalFormattingRule)
GetAllRules Method (PrePaintTextConditionalFormattingRule)
GetAppearance Method (GroupInfo)
GetAppearance Method (PreviewRowInfo)
GetAppearance Method (StyleInfo)
GetArg Method
GetArray Method (DefaultSheetDataModel)
GetArray Method (DefaultSheetStyleModel)
GetArray Method (IArraySupport)
GetAt Method
GetAttributes Method
GetAttributesString Method
GetAutoFilterIndex Method (BaseSheetAxisModel)
GetAutoFilterIndex Method (DefaultSheetAxisModel)
GetAutoFilterIndex Method (IAutoFilterIndexSupport)
GetBaseColumn Method
GetBaseRow Method
GetBinder Method
GetCellByRowCol, client-side
GetCellConditionalFormats Method
GetCellFromTag Method
GetCellRanges Method
GetCellRangeSpanCombined Method
GetCellType Method
GetCellValue Method (DefaultSpreadDataViewDataFormatter)
GetCellValue Method (ISpreadDataViewDataFormatter)
GetChildDataModel Method (DefaultSheetDataModel)
GetChildDataModel Method (IChildModelSupport)
GetChildRelation Method (DefaultSheetDataModel)
GetChildRelation Method (IChildModelSupport)
GetChildRelation Method (SheetView)
GetChildSpread, client-side
GetChildSpreads, client-side
GetChildView Method
GetChildViewName Method
GetChildVisible Method
GetClassName Method
GetClip Method (ColumnFooter)
GetClip Method (ColumnHeader)
GetClip Method (RowHeader)
GetClip Method (SheetView)
GetClipValue Method (ColumnFooter)
GetClipValue Method (ColumnHeader)
GetClipValue Method (RowHeader)
GetClipValue Method (SheetView)
GetColByKey, client-side
GetColCount, client-side
GetColKeyFromCol, client-side
GetColumnAllowFilter Method
GetColumnAutoText Method
GetColumnConditionalFormats Method
GetColumnDefinitionIndexFromColumnIndex Method
GetColumnFilterBy Method
GetColumnFilterIndexFromColumnIndex Method (DefaultRowFilter)
GetColumnFilterIndexFromColumnIndex Method (IRowFilter)
GetColumnFromTag Method
GetColumnIndex Method (DefaultSheetDataModel)
GetColumnIndex Method (FpSpread)
GetColumnIndexes Method
GetColumnLabel Method
GetColumnMerge Method
GetColumnName Method (GroupDataModel)
GetColumnName Method (IGroupSupport)
GetColumnSizeable Method
GetColumnSortIndicator Method
GetColumnVisible Method
GetColumnWidth Method
GetComparedValue Method
GetComponentName Method
GetCompositeBackColor Method
GetCompositeCellType Method
GetCompositeForeColor Method
GetCompositeInfo Method (BaseSheetStyleModel)
GetCompositeInfo Method (DefaultSheetStyleModel)
GetCompositeInfo Method (IOptimizedFilterStyleModel)
GetCompositeInfo Method (ISheetStyleModel)
GetCompositeInfo Method (ISheetStyleModel3)
GetConditionalFormats Method (IConditionalFormatSupport)
GetConditionalFormats Method (IConditionalFormatSupport2)
GetConditionalFormatting Method
GetConverter Method
GetCoordinates Method
GetCreateInstanceSupported Method
GetCurrentPageIndex, client-side
GetCustomFunction Method (DefaultSheetDataModel)
GetCustomFunction Method (ICustomFunctionSupport)
GetCustomFunctionEnumerator Method (DefaultSheetDataModel)
GetCustomFunctionEnumerator Method (ICustomFunctionSupport)
GetCustomName Method (DefaultSheetDataModel)
GetCustomName Method (ICustomNameSupport)
GetCustomName Method (SheetView)
GetCustomNameEnumerator Method (DefaultSheetDataModel)
GetCustomNameEnumerator Method (ICustomNameSupport)
GetData Method
GetDataColumnCaption Method
GetDataColumnFromModelColumn Method (DefaultSheetDataModel)
GetDataColumnFromModelColumn Method (IDataSourceSupport)
GetDataColumnName Method (DefaultSheetDataModel)
GetDataColumnName Method (IDataSourceSupport)
GetDataColumnType Method
GetDataKey Method
GetDataModel Method
GetDataRow Method
GetDataRowFromModelRow Method (DefaultSheetDataModel)
GetDataRowFromModelRow Method (IDataSourceSupport)
GetDataSource Method
GetDataTable Method
GetDataView Method (DefaultSheetDataModel)
GetDataView Method (IDataSourceSupport)
GetDataViewColumnFromModelColumn Method (DefaultSpreadDataViewMapper)
GetDataViewColumnFromModelColumn Method (ISpreadDataViewMapper)
GetDataViewRowFromModelRow Method (DefaultSpreadDataViewMapper)
GetDataViewRowFromModelRow Method (ISpreadDataViewMapper)
GetDataViewRowFromModelRowWhenAddNew Method (DefaultSpreadDataViewMapper)
GetDataViewRowFromModelRowWhenAddNew Method (ISpreadDataViewMapper)
GetDefaultEditor Method
GetDefaultEvent Method
GetDefaultProperty Method
GetDefaultRenderer Method
GetDirectAltRowInfo Method (BaseSheetStyleModel)
GetDirectAltRowInfo Method (DefaultSheetStyleModel)
GetDirectAltRowInfo Method (ISheetStyleModel)
GetDirectAltRowName Method (DefaultSheetStyleModel)
GetDirectAltRowName Method (INamedStyleSupport)
GetDirectInfo Method (BaseSheetStyleModel)
GetDirectInfo Method (DefaultSheetStyleModel)
GetDirectInfo Method (ISheetStyleModel)
GetDirectName Method (DefaultSheetStyleModel)
GetDirectName Method (INamedStyleSupport)
GetDropDownButton Method (BaseDropDownCellType)
GetDropDownButton Method (DateTimeCellType)
GetDropDownControl Method (BaseDropDownCellType)
GetDropDownControl Method (DateTimeCellType)
GetDropDownFilterItems Method (IFilterSupport)
GetDropDownFilterItems Method (SheetView)
GetEditor Method (SheetView)
GetEditor Method (SpreadDataRowView)
GetEditorControl Method (AjaxCellTypeBase)
GetEditorControl Method (AjaxComboBoxCellType)
GetEditorControl Method (BaseCellType)
GetEditorControl Method (BaseDropDownCellType)
GetEditorControl Method (BaseEditor)
GetEditorControl Method (ButtonCellType)
GetEditorControl Method (CheckBoxCellType)
GetEditorControl Method (CheckBoxEditor)
GetEditorControl Method (ColumnHeaderFilterCellType)
GetEditorControl Method (ComboBoxCellType)
GetEditorControl Method (ComboBoxEditor)
GetEditorControl Method (CurrencyCellType)
GetEditorControl Method (DateCalendarCellType)
GetEditorControl Method (DateTimeCellType)
GetEditorControl Method (DoubleCellType)
GetEditorControl Method (EmptyCellType)
GetEditorControl Method (ExtenderCellType)
GetEditorControl Method (FilterBarCellType)
GetEditorControl Method (GeneralCellType)
GetEditorControl Method (GeneralEditor)
GetEditorControl Method (HyperLinkCellType)
GetEditorControl Method (IEditor)
GetEditorControl Method (ImageCellType)
GetEditorControl Method (IntegerCellType)
GetEditorControl Method (LabelCellType)
GetEditorControl Method (ListBoxCellType)
GetEditorControl Method (ListBoxEditor)
GetEditorControl Method (MaskedEditCellType)
GetEditorControl Method (MultiColumnComboBoxCellType)
GetEditorControl Method (MultiColumnEditor)
GetEditorControl Method (MutuallyExclusiveCheckBoxCellType)
GetEditorControl Method (PercentCellType)
GetEditorControl Method (RadioButtonListCellType)
GetEditorControl Method (RadioButtonListEditor)
GetEditorControl Method (RatingCellType)
GetEditorControl Method (SliderCellType)
GetEditorControl Method (SlideShowCellType)
GetEditorControl Method (TagCloudCellType)
GetEditorControl Method (TextCellType)
GetEditorValue Method (AjaxComboBoxCellType)
GetEditorValue Method (BaseCellType)
GetEditorValue Method (BaseEditor)
GetEditorValue Method (ButtonCellType)
GetEditorValue Method (CheckBoxCellType)
GetEditorValue Method (CheckBoxEditor)
GetEditorValue Method (HyperLinkCellType)
GetEditorValue Method (IEditor)
GetEditorValue Method (ImageCellType)
GetEditorValue Method (LabelCellType)
GetEditorValue Method (MultiColumnComboBoxCellType)
GetEditorValue Method (MutuallyExclusiveCheckBoxCellType)
GetEditorValue Method (RatingCellType)
GetEditorValue Method (TagCloudCellType)
GetEditValue Method
GetEnumerator Method (AreaSeriesCollection)
GetEnumerator Method (BarSeriesCollection)
GetEnumerator Method (BaseSheetSelectionModel)
GetEnumerator Method (BaseSheetSpanModel)
GetEnumerator Method (BevelCollection)
GetEnumerator Method (BorderProperty)
GetEnumerator Method (ConditionalFormatting)
GetEnumerator Method (ConditionalFormattingModel)
GetEnumerator Method (DefaultSheetSelectionModel)
GetEnumerator Method (DefaultSheetSpanModel)
GetEnumerator Method (DefaultSparklineContainer)
GetEnumerator Method (DefaultStyleCollection)
GetEnumerator Method (DetachmentCollection)
GetEnumerator Method (DoubleCollection)
GetEnumerator Method (DoubleCollectionCollection)
GetEnumerator Method (ExcelSparklineGroup)
GetEnumerator Method (FillCollection)
GetEnumerator Method (FilterItemValueCollection)
GetEnumerator Method (GroupInfoCollection)
GetEnumerator Method (ISheetSelectionModel)
GetEnumerator Method (ISheetSpanModel)
GetEnumerator Method (LabelAreaCollection)
GetEnumerator Method (LegendAreaCollection)
GetEnumerator Method (LightCollection)
GetEnumerator Method (LineCollection)
GetEnumerator Method (LineSeriesCollection)
GetEnumerator Method (MarkerCollection)
GetEnumerator Method (NamedStyleCollection)
GetEnumerator Method (PlotAreaCollection)
GetEnumerator Method (PointSeriesCollection)
GetEnumerator Method (PolarRadiusAxisCollection)
GetEnumerator Method (RadarValueAxisCollection)
GetEnumerator Method (SeriesCollection)
GetEnumerator Method (SmartPrintRulesCollection)
GetEnumerator Method (StringCollection)
GetEnumerator Method (StripeCollection)
GetEnumerator Method (TouchStripCollection)
GetEnumerator Method (ValueAxisCollection)
GetEvents Method
GetExcelSetting Method
GetExcelSheetNames Method
GetExpression Method (DefaultSheetDataModel)
GetExpression Method (ExpressionConsumerFormulaInfo)
GetExpression Method (IExpressionSupport)
GetExpression Method (IObjectExpressionSupport)
GetExpression Method (SheetView)
GetExtendedSelection Method (DefaultSheetSelectionModel)
GetExtendedSelection Method (IQuerySelection)
GetFilterColumnDefinition Method (DefaultRowFilter)
GetFilterColumnDefinition Method (IRowFilter)
GetFilteredColumnIndexes Method (DefaultRowFilter)
GetFilteredColumnIndexes Method (IRowFilter)
GetFilteredOutRowList Method
GetFormatter Method
GetFormula Method (DefaultSheetDataModel)
GetFormula Method (IExpressionConsumer)
GetFormula Method (IExpressionSupport)
GetFormula Method (IObjectExpressionSupport)
GetFormula Method (SheetView)
GetFormula, client-side
GetFormulaContextType Method
GetGroup Method (GroupDataModel)
GetGroup Method (IGroupSupport)
GetGroupCoverCellRange Method (ExcelSparklineGroup)
GetGroupCoverCellRange Method (ISparklineWebSupport)
GetGroupFooter Method (GroupDataModel)
GetGroupFooter Method (IGroupSupport)
GetGroupFooterInfo Method
GetGroupInfo Method
GetHashCode Method (AlternatingRow)
GetHashCode Method (Cell)
GetHashCode Method (CellRange)
GetHashCode Method (Column)
GetHashCode Method (FilterItemValue)
GetHashCode Method (LinearRange)
GetHashCode Method (MapperInfo)
GetHashCode Method (NamedStyle)
GetHashCode Method (PaddingF)
GetHashCode Method (Row)
GetHashCode Method (SeriesInfo)
GetHashCode Method (SheetCellRange)
GetHashCode Method (SheetSkin)
GetHashCode Method (StyleInfo)
GetHeader Method
GetHiddenValue, client-side
GetImage Method (BaseCellType)
GetImage Method (ChartImageHttpHandler)
GetImage Method (FpSpread)
GetImageFormatFromType Method
GetImageUrl Method (FileImageRender)
GetImageUrl Method (HttpHandlerImageRender)
GetImageUrl Method (ImageRender)
GetIndex Method (AppearanceProperty)
GetIndex Method (GroupDataModel)
GetIndex Method (SheetStyleProperty)
GetIntersectedFilteredInRows Method (IRowFilter)
GetIntersectedFilteredInRows Method (IRowFilterSlim)
GetItem Method (DefaultSheetDataModel)
GetItem Method (GroupDataModel)
GetItem Method (IEditableObjectSupport)
GetItems Method
GetKey Method (DefaultSheetDataModel)
GetKey Method (IDataKeySupport)
GetLabelAreaRectangle Method (Chart2DRenderer)
GetLabelAreaRectangle Method (Chart3DRenderer)
GetLeftColIndex, client-side
GetLegendAreaRectangle Method (Chart2DRenderer)
GetLegendAreaRectangle Method (Chart3DRenderer)
GetListSource Method
GetLocalizedString Method
GetLocked

client-side

GetMapAreaByName Method
GetMapAreaPostBackClientHyperlink Method (FpChart)
GetMapAreaPostBackClientHyperlink Method (SpreadChart)
GetMapAreas Method
GetMergeCell Method
GetMergeCells Method
GetMergePolicy Method (BaseSheetAxisModel)
GetMergePolicy Method (DefaultSheetAxisModel)
GetMergePolicy Method (ISheetAxisModel)
GetModelColumnFromDataColumn Method (DefaultSheetDataModel)
GetModelColumnFromDataColumn Method (IDataSourceSupport)
GetModelColumnFromDataViewColumn Method (DefaultSpreadDataViewMapper)
GetModelColumnFromDataViewColumn Method (ISpreadDataViewMapper)
GetModelColumnFromViewColumn Method
GetModelIndexFromTargetIndex Method
GetModelRowFromDataRow Method (DefaultSheetDataModel)
GetModelRowFromDataRow Method (IDataSourceSupport)
GetModelRowFromDataViewRow Method (DefaultSpreadDataViewMapper)
GetModelRowFromDataViewRow Method (ISpreadDataViewMapper)
GetModelRowFromViewRow Method
GetNavigateUrl Method (ChartMapArea)
GetNavigateUrl Method (MapArea)
GetNonEmptyNotesColumnCount Method
GetNonEmptyNotesRowCount Method
GetNote Method (BaseSheetDataModel)
GetNote Method (DefaultSheetDataModel)
GetNote Method (GroupDataModel)
GetNote Method (ISheetDataModel)
GetNote Method (SheetView)
GetObjectData Method (AverageConditionalFormattingRule)
GetObjectData Method (Background)
GetObjectData Method (BaseSparkline)
GetObjectData Method (BetweenValuesConditionalFormattingRule)
GetObjectData Method (BlankConditionalFormattingRule)
GetObjectData Method (ColumnSparklineRenderer)
GetObjectData Method (ConditionalFormattingRule)
GetObjectData Method (ContextMenuStyle)
GetObjectData Method (DatabarConditionalFormattingRule)
GetObjectData Method (DefaultSparklineContainer)
GetObjectData Method (ErrorConditionalFormattingRule)
GetObjectData Method (ExcelBaseSparkLineRenderer)
GetObjectData Method (ExcelSparkline)
GetObjectData Method (ExcelSparklineGroup)
GetObjectData Method (ExcelSparklineSetting)
GetObjectData Method (FormulaConditionalFormattingRule)
GetObjectData Method (HighlightConditionalFormattingRule)
GetObjectData Method (IconSetConditionalFormattingRule)
GetObjectData Method (LineSparklineRenderer)
GetObjectData Method (PrePaintTextConditionalFormattingRule)
GetObjectData Method (PrintInfo)
GetObjectData Method (TextConditionalFormattingRule)
GetObjectData Method (TimePeriodConditionalFormattingRule)
GetObjectData Method (TopRankedValuesConditionalFormattingRule)
GetObjectData Method (TwoColorScaleConditionalFormattingRule)
GetObjectData Method (UnaryComparisonConditionalFormattingRule)
GetObjectData Method (UniqueOrDuplicatedConditionalFormattingRule)
GetObjectData Method (WinLossSparklineRenderer)
GetObjectsFromInstance Method
GetObjectXml Method
GetPageBreak Method (BaseSheetAxisModel)
GetPageBreak Method (DefaultSheetAxisModel)
GetPageBreak Method (IPageBreakSupport)
GetPageCount, client-side
GetPageIndex Method
GetParentRowIndex, client-side
GetParentSpread, client-side
GetParseFormat Method (DefaultSheetStyleModel)
GetParseFormat Method (GeneralCellType)
GetParseFormat Method (IOptimizedFilterStyleModel)
GetParseFormat Method (IParseFormatSupport)
GetParseFormat Method (IParseFormatSupport2)
GetPostBackValue Method (ChartMapArea)
GetPostBackValue Method (MapArea)
GetPreferredSize Method (BaseCellType)
GetPreferredSize Method (ButtonCellType)
GetPreferredSize Method (CheckBoxCellType)
GetPreferredSize Method (ColumnHeaderFilterCellType)
GetPreferredSize Method (ComboBoxCellType)
GetPreferredSize Method (HyperLinkCellType)
GetPreferredSize Method (IconSetConditionalFormattingRule)
GetPreferredSize Method (IEnhancedPdfRenderer)
GetPreferredSize Method (ImageCellType)
GetPreferredSize Method (IPdfSupport)
GetPreferredSize Method (IPrePaintTextConditionalFormattingRule)
GetPreferredSize Method (LabelCellType)
GetPreferredSize Method (ListBoxCellType)
GetPreferredSize Method (MultiColumnComboBoxCellType)
GetPreferredSize Method (PrePaintTextConditionalFormattingRule)
GetPreferredSize Method (RadioButtonListCellType)
GetPreferredSize Method (TagCloudCellType)
GetPreferredSize Method (TextCellType)
GetProperties Method (CellTypeConverter)
GetProperties Method (DoubleCollectionCustomTypeDescriptor)
GetProperties Method (SpreadDataRowView)
GetPropertiesSupported Method
GetPropertyOwner Method
GetRenderer Method
GetResizable Method (BaseSheetAxisModel)
GetResizable Method (DefaultSheetAxisModel)
GetResizable Method (ISheetAxisModel)
GetResourceString Method (DefaultSpreadDataViewMapper)
GetResourceString Method (MapperInfoConverter)
GetResourceString Method (SpreadDataColumnCollection)
GetResourceString Method (SpreadDataRowView)
GetResourceString Method (SpreadDataView)
GetRestrictions Method
GetRowAutoText Method
GetRowByKey, client-side
GetRowConditionalFormats Method
GetRowCount, client-side
GetRowExpandable Method
GetRowFromTag Method
GetRowHeight Method
GetRowIndex Method
GetRowKeyFromRow, client-side
GetRowLabel Method
GetRowMerge Method
GetRowSizeable Method
GetRowVisible Method
GetRowVisibles Method
GetRowVisibleState Method
GetSchema Method (AreaSeries)
GetSchema Method (AreaSeriesCollection)
GetSchema Method (BarSeries)
GetSchema Method (BarSeriesCollection)
GetSchema Method (CandlestickSeries)
GetSchema Method (ChartModel)
GetSchema Method (ClusteredBarSeries)
GetSchema Method (DirectionalLight)
GetSchema Method (HighLowAreaSeries)
GetSchema Method (HighLowBarSeries)
GetSchema Method (HighLowCloseSeries)
GetSchema Method (IndexAxis)
GetSchema Method (LabelArea)
GetSchema Method (LabelAreaCollection)
GetSchema Method (LegendArea)
GetSchema Method (LegendAreaCollection)
GetSchema Method (Light)
GetSchema Method (LightCollection)
GetSchema Method (LineSeries)
GetSchema Method (LineSeriesCollection)
GetSchema Method (OpenHighLowCloseSeries)
GetSchema Method (PiePlotArea)
GetSchema Method (PieSeries)
GetSchema Method (PlotArea)
GetSchema Method (PlotAreaCollection)
GetSchema Method (PointSeries)
GetSchema Method (PointSeriesCollection)
GetSchema Method (PolarAngleAxis)
GetSchema Method (PolarAreaSeries)
GetSchema Method (PolarLineSeries)
GetSchema Method (PolarPlotArea)
GetSchema Method (PolarPointSeries)
GetSchema Method (PolarRadiusAxis)
GetSchema Method (PolarRadiusAxisCollection)
GetSchema Method (PolarSeries)
GetSchema Method (PositionalLight)
GetSchema Method (RadarAreaSeries)
GetSchema Method (RadarIndexAxis)
GetSchema Method (RadarLineSeries)
GetSchema Method (RadarPlotArea)
GetSchema Method (RadarPointSeries)
GetSchema Method (RadarSeries)
GetSchema Method (RadarValueAxis)
GetSchema Method (RadarValueAxisCollection)
GetSchema Method (Series)
GetSchema Method (SeriesCollection)
GetSchema Method (StackedAreaSeries)
GetSchema Method (StackedBarSeries)
GetSchema Method (StackedLineSeries)
GetSchema Method (StackedPointSeries)
GetSchema Method (Stripe)
GetSchema Method (StripeCollection)
GetSchema Method (ValueAxis)
GetSchema Method (ValueAxisCollection)
GetSchema Method (Wall)
GetSchema Method (XYBubbleSeries)
GetSchema Method (XYLineSeries)
GetSchema Method (XYPlotArea)
GetSchema Method (XYPointSeries)
GetSchema Method (XYSeries)
GetSchema Method (XYZLineSeries)
GetSchema Method (XYZPlotArea)
GetSchema Method (XYZPointSeries)
GetSchema Method (XYZSeries)
GetSchema Method (XYZSurfaceSeries)
GetSchema Method (YPlotArea)
GetSchema Method (YSeries)
GetSelectedRange, client-side
GetSelectedRanges, client-side
GetSelections Method (DefaultSheetSelectionModel)
GetSelections Method (IDisjointSelections)
GetSelections Method (SheetView)
GetSeriesVisible Method (Chart2DRenderer)
GetSeriesVisible Method (Chart3DRenderer)
GetSheetColIndex, client-side
GetSheetRowIndex, client-side
GetSheetView Method
GetSize Method (BaseSheetAxisModel)
GetSize Method (DefaultSheetAxisModel)
GetSize Method (ISheetAxisModel)
GetSortIndicator Method (BaseSheetAxisModel)
GetSortIndicator Method (DefaultSheetAxisModel)
GetSortIndicator Method (ISheetAxisModel)
GetSource Method
GetSpanCell Method
GetSparkline Method (DefaultSparklineContainer)
GetSparkline Method (ISparklineContainer)
GetSparkline Method (SheetView)
GetSparkLineData Method (BaseSparkline)
GetSparkLineData Method (ExcelSparkline)
GetSparkLineData Method (ISparkline)
GetSpread Method (BaseEditor)
GetSpread Method (BaseRenderer)
GetSpread, client-side
GetStandardValues Method (CellTypeConverter)
GetStandardValues Method (DataFieldConverter)
GetStandardValues Method (ParentStyleNameConverter)
GetStandardValues Method (StyleNameConverter)
GetStandardValuesSupported Method (CellTypeConverter)
GetStandardValuesSupported Method (DataFieldConverter)
GetStandardValuesSupported Method (ParentStyleNameConverter)
GetStandardValuesSupported Method (StyleNameConverter)
GetStringSize Method
GetStyleInfo Method
GetTabText Method
GetTag Method (BaseSheetAxisModel)
GetTag Method (BaseSheetDataModel)
GetTag Method (DefaultSheetAxisModel)
GetTag Method (DefaultSheetDataModel)
GetTag Method (GroupDataModel)
GetTag Method (ISheetAxisModel)
GetTag Method (ISheetDataModel)
GetTag Method (SheetView)
GetText Method (RowEditTemplateContainer)
GetText Method (SheetView)
getting started

tutorials

GetTitleInfo, client-side
GetToolTip Method (ChartMapArea)
GetToolTip Method (MapArea)
GetTopRowIndex, client-side
GetTotalRowCount, client-side
GetTypeDescriptor Method
GetUnboundValue Method (DefaultSheetDataModel)
GetUnboundValue Method (IUnboundRowSupport)
GetUnboundValue Method (SheetView)
GetValidator Method
GetValidators Method (BaseCellType)
GetValidators Method (BaseEditor)
GetValidators Method (IEditor3)
GetValidConditionalFormat Method (IConditionalFormatSupport)
GetValidConditionalFormat Method (SheetView)
GetValue method

scripting example

GetValue Method (ArraySegmentData)
GetValue Method (BaseSheetDataModel)
GetValue Method (CalcArray)
GetValue Method (CalcReference)
GetValue Method (CellRangeSegmentData)
GetValue Method (ConditionalFormatting)
GetValue Method (DefaultSheetDataModel)
GetValue Method (DoubleCollectionPropertyDescriptor)
GetValue Method (GroupDataModel)
GetValue Method (IObjectExpressionSupport)
GetValue Method (ISegmentData)
GetValue Method (ISheetDataModel)
GetValue Method (RowEditTemplateContainer)
GetValue Method (SheetView)
GetValue Method (SpreadDataColumnPropertyDescriptor)
GetValue, client-side
GetView Method
GetViewColumnFromModelColumn Method
GetViewNames Method
GetViewRowFromModelRow Method
GetVisible Method (BaseSheetAxisModel)
GetVisible Method (DefaultSheetAxisModel)
GetVisible Method (ISheetAxisModel)
GetVisibleCount Method
GetWeights Method
GetWeightStrings Method
GlobalAmbientLight Property
goal seeking
goal seeking
GoalSeek method
GoalSeek method
GoalSeek Method (DefaultSheetDataModel)
GoalSeek Method (FpSpread)
GotoPage Method
Gradient Property
Gradient1 Property
GradientFill Class

Members
Overview

GradientFill Constructor (GradientFill)
GradientStyle Enumeration
graphic
graphic
graphic cell (see image cell type)
Graphics Property
gray area, colors
gray areas (See empty areas)
GrayAreaCursorImageUrl Property
GrayAreaCursorType Property
GreaterThan setting (ComparisonOperator enum)
GreaterThanOperator Field
GreaterThanOrEqualOperator Field
GreaterThanOrEqualTo setting (ComparisonOperator enum)
grid lines
grid lines
grid lines
grid lines
grid lines

colors
columns
hiding
rows

GridLineColor Property (SheetSkin)
GridLineColor Property (SheetView)
gridlines

importing from Excel file
importing from Excel file

GridLines Property (SheetSkin)
GridLines Property (SheetView)
GripHitTest Class

Members
Overview

Group Class

Members
Overview

Group Constructor (Group)
group footer
Group Method (FpSpread)
Group Method (GroupDataModel)
Group Method (IGroupSupport)
Group Property (FetchGroupTextEventArgs)
Group Property (GroupFooter)
Group Property (SeriesHitTest)
GroupBarBackColor Property
GroupBarHeight Property
GroupBarText Property
GroupBarVisible Property
GroupColumnHeaderCssClass Property
GroupComparer Property (GroupDataModel)
GroupComparer Property (GroupingEventArgs)
GroupComparer Property (IGroupSupport)
GroupDataModel Class

Members
Overview

GroupDataModel Constructor (GroupDataModel)
Grouped Event
GroupFooter Class

Members
Overview

GroupFooter Constructor (GroupFooter)
GroupFooter Property
GroupFooterEventHandler Delegate
GroupFooterInfos Property
GroupFooterVisible Property
GroupInfo Class

Members
Overview

GroupInfo Constructor (GroupInfo)
GroupInfo editor
GroupInfo editor
GroupInfoCollection Class

Members
Overview

GroupInfoCollection Constructor (GroupInfoCollection)
GroupInfos Property
grouping
grouping

bar
header editor
header editor
interoperability
multiple levels
overview
primary
secondary
spacing between group names

Grouping Event
grouping, allowing
grouping, bar
grouping, bar
grouping, bar
grouping, bar
grouping, bar
grouping, collection
grouping, data model
grouping, dragging column
grouping, event arguments
grouping, group object
grouping, information object
grouping, interface
grouping, levels
grouping, regrouping
grouping, removing
GroupingEventArgs Class

Members
Overview

GroupingEventArgs Constructor (GroupingEventArgs)
GroupingEventHandler Delegate
GroupingPolicy Enumeration
GroupingPolicy Property (FpSpread)
GroupingPolicy Property (SheetView)
GroupMaximumLevel Property
Groupped Property
Groups Property
GroupSparkline Method (Cell)
GroupSparkline Method (SheetView)
GrowthFunction Field
GUI (graphical user interface)

customizing

Hand setting (CursorType enum)
HandleCssClass Property
Handled Property (SheetViewStateEventArgs)
Handled Property (SpreadCommandEventArgs)
HandleImageUrl Property
handling, Tab key
HarMeanFunction Field
HasSpaceAfterFirstKeyword Property
HasSpaceBefore Property
Header Property (PrintEventArgs)
Header Property (PrintInfo)
Header Property (PrintMargin)
Header setting (ReplacementType enum)
HeaderAutoText Enumeration
HeaderBackColor Property (CalendarDropDownStyleInfo)
HeaderBackColor Property (SheetSkin)
HeaderDefault Field
HeaderDefault Property
HeaderFontBold Property
HeaderForeColor Property (CalendarDropDownStyleInfo)
HeaderForeColor Property (SheetSkin)
HeaderFormat Property
HeaderGrayAreaBackgroundImageUrl Property
HeaderGrayAreaColor Property (SheetSkin)
HeaderGrayAreaColor Property (SheetView)
HeaderHeight Property
HeaderIndicatorPositionAdjusting Property
headers

importing from Excel file
appearance
automatic text
cell types
corner
default style
displaying
editor
editor
empty areas
grouping header editor
grouping header editor
height
importing from Excel file
label text
labels
multiple
printing
printing
setting
shortcut object
shortcut object
size
width

headers, axis model
headers, column
headers, column default style
headers, column default style
headers, columns
headers, columns
headers, columns
headers, columns
headers, columns
headers, columns
headers, columns
headers, columns
headers, data model
headers, empty area
headers, grouping
headers, label
headers, labels
headers, printing
headers, printing
headers, resizing
headers, row
headers, row default style
headers, row default style
headers, searching
headers, span model
headers, style model
headers, styles
headers, text
headers, text
headers, text
headers, text
headers, text
headers, text
headers, text
headers, text
headers, text
headers, text
headers, text
headers, text
headers, text
headers, visible
headers, visible
headers,default border
height

headers
rows

Height Property (Bevel)
Height Property (CircleBevel)
Height Property (ColumnFooter)
Height Property (ColumnHeader)
Height Property (FilterBar)
Height Property (FpChart)
Height Property (LayoutRow)
Height Property (MenuItem)
Height Property (NoBevel)
Height Property (Row)
Height Property (TitleInfo)
height row
height row
height, column headers
height, default row
Help setting (CursorType enum)
Hex2BinFunction Field
Hex2DecFunction Field
Hex2OctFunction Field
hidden

cells when spanned

hidden cells
hidden columns

importing
importing

hidden rows

importing
importing

Hide setting (PrintHeader enum)
HideMessage, client-side
HideMessage, client-side
HideRowFilter Class

Members
Overview

HideRowFilter Constructor (HideRowFilter)
hiding

columns
filtering rows
footer
grid lines
rows
sheets

hiding, command bar buttons
hiding, row filtering
hiding, sheets
HierarchicalView Property
hierarchy
hierarchy

bar
displaying data
expandable rows
grouping
views

hierarchy bar
hierarchy bar
hierarchy buttons
hierarchy, child data relation
hierarchy, child relation
hierarchy, child relation
hierarchy, child views
hierarchy, child views
hierarchy, child views
hierarchy, child views
hierarchy, child views
hierarchy, collapse image
hierarchy, displaying child
hierarchy, expand image
hierarchy, expanding rows
hierarchy, icons
hierarchy, parent row
hierarchy, parent view
HierBar Property
HierBarInfo Class

Members
Overview

HierBarInfo Constructor (HierBarInfo)
highlight color, scroll bars
HighlightConditionalFormattingRule Class

Members
Overview

HighlightConditionalFormattingStyle Class

Members
Overview

HighlightConditionalFormattingStyle Constructor (HighlightConditionalFormattingStyle)
HighLowAreaSeries Class

Members
Overview

HighLowAreaSeries Constructor (HighLowAreaSeries)
HighLowBarSeries Class

Members
Overview

HighLowBarSeries Constructor (HighLowBarSeries)
HighLowCloseSeries Class

Members
Overview

HighLowCloseSeries Constructor (HighLowCloseSeries)
HighMarkerColor Property
HighValues Property (CandlestickSeries)
HighValues Property (HighLowAreaSeries)
HighValues Property (HighLowBarSeries)
HighValues Property (HighLowCloseSeries)
HighValues Property (OpenHighLowCloseSeries)
HitTest Class

Members
Overview

HitTest Method (Chart2DRenderer)
HitTest Method (Chart3DRenderer)
HitTest Method (FpChart)
HLookupFunction Field
HoleSize Property
HomePage
horizontal alignment
horizontal grid lines
horizontal grid lines
horizontal grid lines
Horizontal setting (Centering enum)
Horizontal setting (SheetAxisOrientation enum)
HorizontalAlign Field (AppearanceProperty)
HorizontalAlign Field (SheetStyleProperty)
HorizontalAlign Property (AlternatingRow)
HorizontalAlign Property (Appearance)
HorizontalAlign Property (Cell)
HorizontalAlign Property (Column)
HorizontalAlign Property (GroupInfo)
HorizontalAlign Property (NamedStyle)
HorizontalAlign Property (PreviewRowInfo)
HorizontalAlign Property (Row)
HorizontalAlign Property (StyleInfo)
HorizontalAlign Property (TitleInfo)
HorizontalScrollBarPolicy Property
hot-keys
hot-keys
HotSpotMode Property (ChartMapArea)
HotSpotMode Property (FpChart)
HourFunction Field
HoverColor Property (TagCloudCellType)
HoverColor Property (TagCloudRenderer)
How To’s
How To's
Href Property
HResult Property
HRSet Property
HTC files

custom

HTML component files
HttpHandlerImageRender Class

Members
Overview

HttpHandlerImageRender Constructor (HttpHandlerImageRender)
hyperlink
hyperlink
hyperlink
hyperlink button
hyperlink cell type
hyperlink, cell type
HyperLinkCellType Class

Members
Overview

HyperLinkCellType Constructor (HyperLinkCellType)
HyperLinkRenderer Class

Members
Overview

HyperLinkRenderer Constructor (HyperLinkRenderer)
hypertext link button
HypGeomDistFunction Field
IAcceptServerValidator Interface
IAggregationSupport Interface
IArraySupport Interface
IAutoFilterIndexSupport Interface
IAutoFilterIndexSupport2 Interface
IAutoPostBack Interface
ICalculationSupport Interface
ICanSerializeXml Interface
ICellType Interface
IChartMapArea Interface
IChartSupport Interface
IChildModelSupport Interface
IClearDataSupport Interface
IClearFormulasSupport Interface
ICompositeSeries Interface
Icon Property (ConditionalFormattingIconValue)
Icon Property (IconFilterItem)
Icon Property (MeasureIconSizeEventArgs)
IConditionalFormatSupport Interface
IConditionalFormatSupport2 Interface
IConditionalFormattingDataRule Interface
IConditionalFormattingModel Interface
IConditionalFormattingRule Interface
IconFilterItem Class

Members
Overview

IconFilterItem Constructor (IconFilterItem)
IconFilterSupport Property
IconRuleSet Property
icons, hierarchy
icons, setting
IconSetConditionalFormattingRule Class

Members
Overview

IconSetConditionalFormattingRule Constructor (IconSetConditionalFormattingRule)
IconSetStyle Property
IconUrl Property
ICSSClassSupport Interface
ICustomFunctionSupport Interface
ICustomFunctionSupport2 Interface
ICustomNameSupport Interface
ICustomNameSupport2 Interface
ID Property
IDataKeySupport Interface
IDataSourceSupport Interface
IDataSourceSupport2 Interface
IDateCellType Interface
identifier, data source
IDisjointSelections Interface
IE

browser support

IEditableObjectSupport Interface
IEditFormatter Interface
IEditor Interface
IEditor2 Interface
IEditor3 Interface
IEditorCSSClassSupport Interface
IEnhancedFormatter Interface
IEnhancedPdfRenderer Interface
IEnhancedRenderer Interface
IExcelExporter Interface
IExpandoSupport Interface
IExpressionConsumer Interface
IExpressionSupport Interface
IExpressionSupport2 Interface
IfErrorFunction Field
IfFunction Field
IFilteredRowSupport Interface
IFilterItem Interface
IFilterSupport Interface
IFilterSupportConditionalFormattingRule Interface
IFindRowsVisibleStateSupport Interface
IFormatter Interface
IgnoreDataSourceViewChanged Property
IgnoreFormula Property (DefaultSheetDataModel)
IgnoreFormula Property (IOptimizedEnumerationSupport3)
IgnoreHiddenRowsWhenPaging Property
IgnoresContextValue Method
IgnoresValues Method
IGroupMapAreaSupport Interface
IGroupSupport Interface
IIndicator Interface
IItemTypeSupport Interface
IIterationSupport Interface
ImAbsFunction Field
image
image
image
image
image button
image button
image cell type
image cell type
Image Property (ImageFill)
Image Property (PrintExternalImageEventArgs)
image text
ImageAlign Property (FpChart)
ImageAlign Property (ImageCellType)
ImageAlign Property (ImageRenderer)
ImageButton setting (ButtonType enum)
ImageButtonHoverColor Property
ImageButtonTheme Enumeration
ImageCellType Class

Members
Overview

ImageCellType Constructor (ImageCellType)
ImageDescriptionLabelID Property
ImageDirty Property
ImageFill Class

Members
Overview

ImageFill Constructor (ImageFill)
ImageRectangle Property
ImageRender Class

Members
Overview

ImageRender Property
ImageRenderer Class

Members
Overview

ImageRenderer Constructor (ImageRenderer)
images

changing command buttons
customizing in interface

Images Property
images, cell type
images, collapse icon
images, expand icon
images, setting
images, sort ascending
images, sort descending
images,button
images,button
images,for check box
images,for check box
images,for check box
ImageTitleLabelID Property
ImageTransferStorage Enumeration
ImageTransferStorage Property
ImageType Enumeration
ImageUrl Property (ButtonCellType)
ImageUrl Property (ButtonRenderer)
ImageUrl Property (FileImageRender)
ImageUrl Property (HyperLinkCellType)
ImageUrl Property (HyperLinkRenderer)
ImageUrl Property (ImageCellType)
ImageUrl Property (ImageRenderer)
ImageUrl Property (MenuItem)
ImaginaryFunction Field
ImArgumentFunction Field
ImConjugateFunction Field
ImCosFunction Field
ImDivFunction Field
ImeMode Enumeration
ImeMode Field (AppearanceProperty)
ImeMode Field (SheetStyleProperty)
ImeMode Property (Appearance)
ImeMode Property (Cell)
ImeMode Property (Column)
ImeMode Property (GeneralCellType)
ImeMode Property (NamedStyle)
ImeMode Property (Row)
ImeMode Property (StyleInfo)
ImeMode Property (TextCellType)
ImExpFunction Field
ImLnFunction Field
ImLog10Function Field
ImLog2Function Field
IMovable Interface
Implicit Type Conversion Operator (AppearanceProperty)
Implicit Type Conversion Operator (BorderProperty)
Implicit Type Conversion Operator (SheetStyleProperty)
importing

border settings
cell settings
column settings
grid lines
headers
row settings
scroll bar settings
sheet settings
border settings
cell settings
chart settings
chart settings
chart settings
column settings
grid lines
headers
row settings
scroll bar settings
sheet settings
Spread settings

ImPowerFunction Field
ImProductFunction Field
ImRealFunction Field
ImSinFunction Field
ImSqrtFunction Field
ImSubFunction Field
ImSumFunction Field
Inactive setting (ImeMode enumeration)
INamedStyleSupport Interface
INameSupport Interface
INameSupport2 Interface
IncludeCellLocked Property
IncludeHeaders Enumeration
index
index
Index Property (AlternatingRow)
Index Property (BorderProperty)
Index Property (Column)
Index Property (FormulaRestrictedException)
Index Property (MenuItem)
Index Property (Row)
Index Property (SheetAxisModelEventArgs)
Index Property (SheetViewStateEventArgs)
Index Property (SortInfo)
Index2 Property (Column)
Index2 Property (Row)
IndexAxis Class

Members
Overview

IndexAxis Constructor (IndexAxis)
IndexFunction Field
IndexOf Method (AreaSeriesCollection)
IndexOf Method (BarSeriesCollection)
IndexOf Method (BevelCollection)
IndexOf Method (ConditionalFormatting)
IndexOf Method (DefaultSkins)
IndexOf Method (DefaultStyleCollection)
IndexOf Method (DetachmentCollection)
IndexOf Method (DoubleCollection)
IndexOf Method (DoubleCollectionCollection)
IndexOf Method (FillCollection)
IndexOf Method (FilterColumnDefinitionCollection)
IndexOf Method (GroupInfoCollection)
IndexOf Method (LabelAreaCollection)
IndexOf Method (LegendAreaCollection)
IndexOf Method (LightCollection)
IndexOf Method (LineCollection)
IndexOf Method (LineSeriesCollection)
IndexOf Method (MarkerCollection)
IndexOf Method (NamedStyleCollection)
IndexOf Method (PlotAreaCollection)
IndexOf Method (PointSeriesCollection)
IndexOf Method (PolarRadiusAxisCollection)
IndexOf Method (RadarValueAxisCollection)
IndexOf Method (SeriesCollection)
IndexOf Method (SheetViewCollection)
IndexOf Method (SmartPrintRulesCollection)
IndexOf Method (SpreadChartCollection)
IndexOf Method (SpreadDataColumnCollection)
IndexOf Method (StringCollection)
IndexOf Method (StripeCollection)
IndexOf Method (ValueAxisCollection)
indicator

filtering

indicator,sorting
IndicatorChanged Event
IndicatorChangedEventArgs Class

Members
Overview

IndicatorChangedEventArgs Constructor (IndicatorChangedEventArgs)
IndicatorChangedEventHandler Delegate
IndicatorChangeType Enumeration
IndicatorCssClass Property
indicators

ascending in grouping
expanding in grouping

Inequality Operator (CellRange)
Inequality Operator (ConditionalFormattingValue)
Inequality Operator (LinearRange)
Inequality Operator (NamedStyle)
Inequality Operator (PaddingF)
Inequality Operator (SheetCellRange)
Inequality Operator (StyleInfo)
InformRowsVisibleStateChanged Method
Inherit setting (PrintHeader enum)
inheriting formatting
InitialValue Property
INonEmptyCells Interface
INotifyItemChanged Interface
INotifyItemChanged<T> Interface
INotifySheetAxisModelChanging Interface
InputDirection Property
Insert command (client-side)
Insert Method (AreaSeriesCollection)
Insert Method (BarSeriesCollection)
Insert Method (BevelCollection)
Insert Method (DefaultStyleCollection)
Insert Method (DetachmentCollection)
Insert Method (DoubleCollection)
Insert Method (DoubleCollectionCollection)
Insert Method (FillCollection)
Insert Method (FilterColumnDefinitionCollection)
Insert Method (FilterItemCollection)
Insert Method (GroupInfoCollection)
Insert Method (LabelAreaCollection)
Insert Method (LegendAreaCollection)
Insert Method (LightCollection)
Insert Method (LineCollection)
Insert Method (LineSeriesCollection)
Insert Method (MarkerCollection)
Insert Method (NamedStyleCollection)
Insert Method (PlotAreaCollection)
Insert Method (PointSeriesCollection)
Insert Method (PolarRadiusAxisCollection)
Insert Method (RadarValueAxisCollection)
Insert Method (SeriesCollection)
Insert Method (SheetViewCollection)
Insert Method (SmartPrintRulesCollection)
Insert Method (SpreadChartCollection)
Insert Method (SpreadDataView)
Insert Method (StringCollection)
Insert Method (StripeCollection)
Insert Method (ValueAxisCollection)
Insert, client-side
InsertAt Method
InsertCommand Event
inserting, rows
InsertMethod
InsertMethod Property (FpSpread)
InsertMethod Property (SheetView)
InsertRange Method (AreaSeriesCollection)
InsertRange Method (BarSeriesCollection)
InsertRange Method (BevelCollection)
InsertRange Method (DetachmentCollection)
InsertRange Method (DoubleCollection)
InsertRange Method (DoubleCollectionCollection)
InsertRange Method (FillCollection)
InsertRange Method (LabelAreaCollection)
InsertRange Method (LegendAreaCollection)
InsertRange Method (LightCollection)
InsertRange Method (LineCollection)
InsertRange Method (LineSeriesCollection)
InsertRange Method (MarkerCollection)
InsertRange Method (PlotAreaCollection)
InsertRange Method (PointSeriesCollection)
InsertRange Method (PolarRadiusAxisCollection)
InsertRange Method (RadarValueAxisCollection)
InsertRange Method (SeriesCollection)
InsertRange Method (StringCollection)
InsertRange Method (StripeCollection)
InsertRange Method (ValueAxisCollection)
Inset Class

Members
Overview

Inset Constructor (Inset)
insets
insets
insets
insets
insets
InstanceGuid Property
InStyle Property
integer cell type
integer, cell type
IntegerCellType Class

Members
Overview

IntegerCellType Constructor (IntegerCellType)
IntegerCellType.EditModeSettings Class

Members
Overview

IntegerCellType.EditModeSettings Constructor (IntegerCellType.EditModeSettings)
Intellisense
Intellisense
Intellisense
interaction

customizing
customizing
events

InterceptFunction Field
interface images
interface, formatter
interface, renderer
interface, renderer
interfaces

models
optional model

Internet Explorer

browser support

Internet Information Services (IIS)
interoperability

grouping

IntersectColumn Method
IntersectOperator Field
IntersectOperatorInfo Class

Members
Overview

IntersectOperatorInfo Constructor (IntersectOperatorInfo)
IntersectRow Method
Intersects Method (CellRange)
Intersects Method (IIndicator)
IntersectWith Method
IntersecWith Method
Interval Property
IntFunction Field
IntRateFunction Field
invalid entries
invalid parameter
InvalidateRowFilter Method
InvalidChars Property
InvalidExternalReferenceParseException Class

Members
Overview

InvalidExternalReferenceParseException Constructor (InvalidExternalReferenceParseException)
InvalidValueMessage Property
IObjectExpressionSupport Interface
IOptimizedEnumerationSupport Interface
IOptimizedEnumerationSupport2 Interface
IOptimizedEnumerationSupport3 Interface
IOptimizedEnumerationSupport7 Interface
IOptimizedFilterConditionalFormattingModel Interface
IOptimizedFilterStyleModel Interface
IOptimizedSheetAxisModelSupport Interface
IOptimizedSheetAxisModelSupport2 Interface
IPageBreakSupport Interface
IParallelSupport Interface
IParentStyleModelSupport Interface
IParseFormatSupport Interface
IParseFormatSupport2 Interface
IPdfBorderSupport Interface
IPdfPrintableRule Interface
IPdfSupport Interface
IpmtFunction Field
IPrePaintConditionalFormattingRule Interface
IPrePaintTextConditionalFormattingRule Interface
IPropertyChangedNotification Interface
IQuerySelection Interface
IRangeSupport Interface
IReceiveRowsVisibleStateChangedNotificationSupport Interface
IRenderer Interface
IRenderer2 Interface
IRowFilter Interface
IRowFilterComboSupport Interface
IRowFilterFrozenSupport Interface
IRowFilterSlim Interface
IrrFunction Field
IsAbove Property
IsAnyCellInColumnSelected Method (BaseSheetSelectionModel)
IsAnyCellInColumnSelected Method (DefaultSheetSelectionModel)
IsAnyCellInColumnSelected Method (ISheetSelectionModel)
IsAnyCellInRowSelected Method (BaseSheetSelectionModel)
IsAnyCellInRowSelected Method (DefaultSheetSelectionModel)
IsAnyCellInRowSelected Method (ISheetSelectionModel)
IsBlank Property
IsBlankFunction Field
IsColumnBound Method (DefaultSheetDataModel)
IsColumnBound Method (IDataSourceSupport)
IsColumnBound Method (SheetView)
IsConditionalFormatEmpty Property
IsContextSensitive Property
IsContextSensitiveWhenHasArguments Method
IsDateFormat Property (GeneralCellType)
IsDateFormat Property (GeneralFormatter)
IsDateFormat Property (IDateCellType)
IsDefaultValue Method
IsDefined Method (Appearance)
IsDefined Method (Border)
IsDescending Property (Top10FilterItem)
IsDescending Property (TopRankedValuesConditionalFormattingRule)
IsEditable Method (BaseSheetDataModel)
IsEditable Method (DefaultSheetDataModel)
IsEditable Method (GroupDataModel)
IsEditable Method (ISheetDataModel)
ISegmentData Interface
IsEmpty Method (BaseSheetAxisModel)
IsEmpty Method (BaseSheetDataModel)
IsEmpty Method (BaseSheetSelectionModel)
IsEmpty Method (BaseSheetSpanModel)
IsEmpty Method (BaseSheetStyleModel)
IsEmpty Method (DefaultSheetAxisModel)
IsEmpty Method (DefaultSheetDataModel)
IsEmpty Method (DefaultSheetSelectionModel)
IsEmpty Method (DefaultSheetSpanModel)
IsEmpty Method (DefaultSheetStyleModel)
IsEmpty Method (GroupDataModel)
IsEmpty Method (ISheetAxisModel)
IsEmpty Method (ISheetDataModel)
IsEmpty Method (ISheetSelectionModel)
IsEmpty Method (ISheetSpanModel)
IsEmpty Method (ISheetStyleModel)
IsEmpty Property (Appearance)
IsEmpty Property (Background)
IsEmpty Property (Border)
IsEmpty Property (DefaultSparklineContainer)
IsEmpty Property (Inset)
IsEmpty Property (ISparklineContainer)
IsEmpty Property (PreviewRowInfo)
IsEmpty Property (StyleInfo)
IsEmpty setting (ComparisonOperator enum)
IsEquals Method
ISerializeData Interface
ISerializePresentation Interface
ISerializeSettings Interface
ISerializeStyles Interface
ISerializeSupport Interface
ISerializeSupport2 Interface
IsErrFunction Field
IsError Property
IsErrorFunction Field
IsEvenFunction Field
IsExcelFile Method
IsExcelStream Method
IsFalse setting (ComparisonOperator enum)
IsFiltered Method
IsFilteredStyleEmpty Property
IsFixedSize Property (DefaultStyleCollection)
IsFixedSize Property (FilterColumnDefinitionCollection)
IsFixedSize Property (GroupInfoCollection)
IsFixedSize Property (NamedStyleCollection)
IsFixedSize Property (SmartPrintRulesCollection)
IsGreaterOrEquals Property
IsGroup Method (GroupDataModel)
IsGroup Method (IGroupSupport)
IsGroupFooter Method (GroupDataModel)
IsGroupFooter Method (IGroupSupport)
ISheetAxisModel Interface
ISheetCellRangeSupport Interface
ISheetDataModel Interface
ISheetSelectionModel Interface
ISheetSpanModel Interface
ISheetStyleModel Interface
ISheetStyleModel2 Interface
ISheetStyleModel3 Interface
IsIncludeEquals Property
IsLogicalFunction Field
IsNAFunction Field
IsNonTextFunction Field
IsNotBetween Property
IsNumber Method
IsNumberFunction Field
IsOddFunction Field
ISortedFilterItem Interface
ISparkline Interface
ISparklineContainer Interface
ISparklineGroup Interface
ISparklineRenderer Interface
ISparklineSetting Interface
ISparklineSupportHandler Interface
ISparklineWebSupport Interface
IsPercent Property (Top10FilterItem)
IsPercent Property (TopRankedValuesConditionalFormattingRule)
IspmtFunction Field
ISpreadDataViewDataFormatter Interface
ISpreadDataViewMapper Interface
IsPrint Property
IsPropertySet Method (BaseSheetAxisModel)
IsPropertySet Method (DefaultSheetAxisModel)
IsPropertySet Method (ISheetAxisModel)
IsPropertySet Method (StyleInfo)
IsReadOnly Property (ConditionalFormatting)
IsReadOnly Property (ConditionalFormattingModel)
IsReadOnly Property (DefaultSparklineContainer)
IsReadOnly Property (DefaultStyleCollection)
IsReadOnly Property (DoubleCollectionPropertyDescriptor)
IsReadOnly Property (ExcelSparklineGroup)
IsReadOnly Property (FilterColumnDefinitionCollection)
IsReadOnly Property (GroupInfoCollection)
IsReadOnly Property (NamedStyleCollection)
IsReadOnly Property (SmartPrintRulesCollection)
IsReadOnly Property (SpreadDataColumnPropertyDescriptor)
IsRefFunction Field
IsReusable Property
IsRowBound Method (DefaultSheetDataModel)
IsRowBound Method (IUnboundRowSupport)
IsRowBound Method (SheetView)
IsRowExpanded Method
IsRowFilteredOut Method (DefaultRowFilter)
IsRowFilteredOut Method (IRowFilter)
IsRowUsed Method (BaseSheetDataModel)
IsRowUsed Method (BaseSheetStyleModel)
IsRowUsed Method (DefaultSheetDataModel)
IsRowUsed Method (DefaultSheetDataModel.DefaultSheetDataModelEnumerator)
IsRowUsed Method (DefaultSheetStyleModel)
IsRowUsed Method (GroupDataModel)
IsRowUsed Method (IOptimizedEnumerationSupport)
IsRowUsed Method (ISheetDataModel)
IsRowUsed Method (ISheetStyleModel)
IsRowVisibleSensitive Method
IsSave Property
IsSelected Method (BaseSheetSelectionModel)
IsSelected Method (DefaultSheetSelectionModel)
IsSelected Method (ISheetSelectionModel)
IsSpreadXmlFile Method
IsStrictMode Method
IsSubtotal Method
IsSwitchable Method
IsSynchronized Property (DefaultStyleCollection)
IsSynchronized Property (GroupInfoCollection)
IsSynchronized Property (NamedStyleCollection)
IsSynchronized Property (SmartPrintRulesCollection)
IsTextFunction Field
IStopablePrePaintConditionalFormattingRule Interface
IsTrackingViewState Property (ContextMenu)
IsTrackingViewState Property (SheetView)
IsTrue setting (ComparisonOperator enum)
IsUnique Property
ISupportChartDataSetting Interface
ISupportDynamicDataSegment Interface
ISuspendFormulaParsing Interface
IsValid Method (AverageConditionalFormattingRule)
IsValid Method (BetweenValuesConditionalFormattingRule)
IsValid Method (BlankConditionalFormattingRule)
IsValid Method (Cell)
IsValid Method (DefaultSpreadDataViewMapper)
IsValid Method (ErrorConditionalFormattingRule)
IsValid Method (HighlightConditionalFormattingRule)
IsValid Method (ISpreadDataViewMapper)
IsValid Method (TextConditionalFormattingRule)
IsValid Method (TimePeriodConditionalFormattingRule)
IsValid Method (TopRankedValuesConditionalFormattingRule)
IsValid Method (UnaryComparisonConditionalFormattingRule)
IsValid Method (UniqueOrDuplicatedConditionalFormattingRule)
IsValid, client-side
IsValidEmpty Property
IsValidRange Method
IsVolatile Method
Item Property (AlternatingRows)
Item Property (AreaSeriesCollection)
Item Property (BarSeriesCollection)
Item Property (BaseSheetSelectionModel)
Item Property (BevelCollection)
Item Property (Cells)
Item Property (Columns)
Item Property (ConditionalFormatCollection)
Item Property (ConditionalFormattingIconRuleSet)
Item Property (ConditionalFormattingModel)
Item Property (ContextMenuCollection)
Item Property (DefaultSheetSelectionModel)
Item Property (DefaultSparklineContainer)
Item Property (DefaultStyleCollection)
Item Property (DetachmentCollection)
Item Property (DoubleCollection)
Item Property (DoubleCollectionCollection)
Item Property (ExcelSparklineGroup)
Item Property (ExcelWarningList)
Item Property (FillCollection)
Item Property (FilterColumnDefinitionCollection)
Item Property (FilterItemCollection)
Item Property (GroupInfoCollection)
Item Property (IConditionalFormattingModel)
Item Property (ISheetSelectionModel)
Item Property (ISparklineContainer)
Item Property (ISparklineGroup)
Item Property (ItemEventArgs<T>)
Item Property (ItemEventArgs)
Item Property (LabelAreaCollection)
Item Property (LayoutCells)
Item Property (LayoutColumns)
Item Property (LayoutRows)
Item Property (LegendAreaCollection)
Item Property (LightCollection)
Item Property (LineCollection)
Item Property (LineSeriesCollection)
Item Property (MarkerCollection)
Item Property (MenuItemCollection)
Item Property (NamedStyleCollection)
Item Property (PlotAreaCollection)
Item Property (PointSeriesCollection)
Item Property (PolarRadiusAxisCollection)
Item Property (RadarValueAxisCollection)
Item Property (Rows)
Item Property (SeriesCollection)
Item Property (SeriesDataFieldCollection)
Item Property (SheetViewCollection)
Item Property (SmartPrintRulesCollection)
Item Property (SpreadChartCollection)
Item Property (SpreadDataColumnCollection)
Item Property (SpreadDataRowView)
Item Property (StringCollection)
Item Property (StripeCollection)
Item Property (TabInfo)
Item Property (TouchStripItemCollection)
Item Property (ValueAxisCollection)
Item Property (WorksheetLayoutCells)
ItemAdded Event (ExcelSparklineGroup)
ItemAdded Event (INotifyItemChanged)
ItemAdded setting (NamedStyleCollectionEventType enum)
ItemBackColor Property
ItemChanged setting (NamedStyleCollectionEventType enum)
ItemChangedType Enumeration
ItemData Property
ItemDisabledBackColor Property
ItemDisabledForeColor Property
ItemEventArgs Class

Members
Overview

ItemEventArgs Constructor (ItemEventArgs)
ItemEventArgs<T> Class

Members
Overview

ItemEventArgs<T> Constructor (ItemEventArgs<T>)
ItemEventHandler Delegate
ItemEventHandler<T> Delegate
ItemFont Property
ItemForeColor Property
ItemHoverBackColor Property
ItemHoverBorder Property
ItemHoverForeColor Property
ItemInsertLocation Property
ItemPropertyEventArgs<T> Class

Members
Overview

ItemPropertyEventArgs<T> Constructor (ItemPropertyEventArgs<T>)
ItemRemoved Event (ExcelSparklineGroup)
ItemRemoved Event (INotifyItemChanged)
ItemRemoved setting (NamedStyleCollectionEventType enum)
items in list
items in list
Items Property (AjaxComboBoxCellType)
Items Property (ComboBoxCellType)
Items Property (ComboBoxEditor)
Items Property (ContextMenu)
Items Property (ListBoxCellType)
Items Property (ListBoxEditor)
Items Property (ListBoxRenderer)
Items Property (RadioButtonListCellType)
Items Property (RadioButtonListEditor)
Items Property (TagCloudCellType)
Items Property (TouchStrip)
ItemsAdded setting (SheetAxisModelEventType enum)
ItemsRemoved setting (SheetAxisModelEventType enum)
ItemTemplate Property
ItemTrackedEventArgs Class

Members
Overview

ItemTrackedEventArgs Constructor (ItemTrackedEventArgs)
ItemType
ItemType Property (DefaultSheetDataModel)
ItemType Property (FpSpread)
ItemType Property (IItemTypeSupport)
ItemType Property (SheetView)
ItemUpdated Event (ExcelSparklineGroup)
ItemUpdated Event (INotifyItemChanged)
iteration
Iteration Property (DefaultSheetDataModel)
Iteration Property (IIterationSupport)
Iteration Property (SheetView)
iterations, allowing
iterations, maximum
iterations, maximum change
iterations, model support
IUnboundRowAddNewRowSupport Interface
IUnboundRowSupport Interface
IWebSparklineSheetView Interface
IWrapableRenderer Interface
JavaScript

object (client side)
object (client side)
mapping event to function

JointList Method
JpegQuality Property
KeepTransferStorage Property
key field, data binding
key names, data binding
Key Property
keys, access key
keys, access keys
Keyword Property
KurtFunction Field
label cell type
label cell type
Label Property (Column)
Label Property (CreateButtonEventArgs)
Label Property (Row)
Label Property (Rows.DefaultRow)
label text
label, cell type
LabelArea Class

Members
Overview

LabelArea Constructor (LabelArea)
LabelArea Property
LabelAreaCollection Class

Members
Overview

LabelAreaHitTest Class

Members
Overview

LabelAreaHitTest Constructor (LabelAreaHitTest)
LabelAreas Property
LabelBorder Property
LabelCellType Class

Members
Overview

LabelCellType Constructor (LabelCellType)
LabelContainsCategoryName Property (PieSeries)
LabelContainsCategoryName Property (RadarSeries)
LabelContainsCategoryName Property (YSeries)
LabelContainsCloseValue Property (CandlestickSeries)
LabelContainsCloseValue Property (HighLowCloseSeries)
LabelContainsCloseValue Property (OpenHighLowCloseSeries)
LabelContainsHighValue Property (CandlestickSeries)
LabelContainsHighValue Property (HighLowAreaSeries)
LabelContainsHighValue Property (HighLowBarSeries)
LabelContainsHighValue Property (HighLowCloseSeries)
LabelContainsHighValue Property (OpenHighLowCloseSeries)
LabelContainsLowValue Property (CandlestickSeries)
LabelContainsLowValue Property (HighLowAreaSeries)
LabelContainsLowValue Property (HighLowBarSeries)
LabelContainsLowValue Property (HighLowCloseSeries)
LabelContainsLowValue Property (OpenHighLowCloseSeries)
LabelContainsOpenValue Property (CandlestickSeries)
LabelContainsOpenValue Property (OpenHighLowCloseSeries)
LabelContainsSeriesName Property
LabelContainsSizeValue Property
LabelContainsValue Property (AreaSeries)
LabelContainsValue Property (BarSeries)
LabelContainsValue Property (LineSeries)
LabelContainsValue Property (PieSeries)
LabelContainsValue Property (PointSeries)
LabelContainsValue Property (RadarAreaSeries)
LabelContainsValue Property (RadarLineSeries)
LabelContainsValue Property (RadarPointSeries)
LabelContainsXValue Property (PolarAreaSeries)
LabelContainsXValue Property (PolarLineSeries)
LabelContainsXValue Property (PolarPointSeries)
LabelContainsXValue Property (XYBubbleSeries)
LabelContainsXValue Property (XYLineSeries)
LabelContainsXValue Property (XYPointSeries)
LabelContainsXValue Property (XYZLineSeries)
LabelContainsXValue Property (XYZPointSeries)
LabelContainsYValue Property (PolarAreaSeries)
LabelContainsYValue Property (PolarLineSeries)
LabelContainsYValue Property (PolarPointSeries)
LabelContainsYValue Property (XYBubbleSeries)
LabelContainsYValue Property (XYLineSeries)
LabelContainsYValue Property (XYPointSeries)
LabelContainsYValue Property (XYZLineSeries)
LabelContainsYValue Property (XYZPointSeries)
LabelContainsZValue Property (XYZLineSeries)
LabelContainsZValue Property (XYZPointSeries)
LabelFill Property
LabelNumberFormat Property (IndexAxis)
LabelNumberFormat Property (PolarAngleAxis)
LabelNumberFormat Property (PolarRadiusAxis)
LabelNumberFormat Property (RadarIndexAxis)
LabelNumberFormat Property (RadarValueAxis)
LabelNumberFormat Property (Series)
LabelNumberFormat Property (ValueAxis)
LabelOffset Property (IndexAxis)
LabelOffset Property (PolarAngleAxis)
LabelOffset Property (PolarRadiusAxis)
LabelOffset Property (RadarIndexAxis)
LabelOffset Property (RadarValueAxis)
LabelOffset Property (ValueAxis)
labels
labels
labels
labels
labels
labels
labels

automatic text in headers
header text
headers

labels, column headers
labels, column headers
labels, column headers
labels, column headers
labels, command bar buttons
labels, headers
labels, row header
labels, row headers
labels, row headers
labels, row headers
LabelSeparator Property
LabelTextFill Property (IndexAxis)
LabelTextFill Property (PolarAngleAxis)
LabelTextFill Property (PolarRadiusAxis)
LabelTextFill Property (RadarIndexAxis)
LabelTextFill Property (RadarValueAxis)
LabelTextFill Property (Series)
LabelTextFill Property (ValueAxis)
LabelTextFont Property (IndexAxis)
LabelTextFont Property (PolarAngleAxis)
LabelTextFont Property (PolarRadiusAxis)
LabelTextFont Property (RadarIndexAxis)
LabelTextFont Property (RadarValueAxis)
LabelTextFont Property (Series)
LabelTextFont Property (ValueAxis)
LabelUnit Property (IndexAxis)
LabelUnit Property (PolarAngleAxis)
LabelUnit Property (PolarRadiusAxis)
LabelUnit Property (RadarIndexAxis)
LabelUnit Property (RadarValueAxis)
LabelUnit Property (ValueAxis)
LabelVisible Property (IndexAxis)
LabelVisible Property (PolarAngleAxis)
LabelVisible Property (PolarRadiusAxis)
LabelVisible Property (RadarIndexAxis)
LabelVisible Property (RadarValueAxis)
LabelVisible Property (Series)
LabelVisible Property (ValueAxis)
Landscape setting (PrintOrientation enum)
LandscapeRule Class

Members
Overview

LandscapeRule Constructor (LandscapeRule)
LargeFunction Field
LastColumnIndex Property
LastCondition Property
LastConditionExpression Property
LastMarkerColor Property
LastReference Property
LayoutCell Class

Members
Overview

LayoutCells Class

Members
Overview

LayoutCells Property (LayoutTemplate)
LayoutCells Property (WorksheetTemplate)
LayoutChanged Property
LayoutColumn Class

Members
Overview

LayoutColumn Property
LayoutColumnAxisModel Property
LayoutColumns Class

Members
Overview

LayoutColumns Property
LayoutDataModel Property
LayoutItemsUpdated setting (SheetAxisModelEventType enum)
LayoutMode Property
LayoutModeType enum
LayoutRow Class

Members
Overview

LayoutRow Property
LayoutRowAxisModel Property
LayoutRows Class

Members
Overview

LayoutRows Property
LayoutSpanModel Property
LayoutTemplate Class

Members
Overview

LayoutTemplate Constructor (LayoutTemplate)
LcmFunction Field
LeastWeight setting (Display Limit enum)
left margin
Left Property (Inset)
Left Property (PaddingF)
Left Property (PrintMargin)
Left Property (SpreadChart)
Left setting (ListAlignment enum)
LeftFunction Field
LegendArea Class

Members
Overview

LegendArea Constructor (LegendArea)
LegendArea Property
LegendAreaCollection Class

Members
Overview

LegendAreaHitTest Class

Members
Overview

LegendAreaHitTest Constructor (LegendAreaHitTest)
LegendAreaId Property (LegendArea)
LegendAreaId Property (Series)
LegendAreas Property
LenFunction Field
Length Property
LessThan setting (ComparisonOperator enum)
LessThanOperator Field
LessThanOrEqualOperator Field
LessThanOrEqualTo setting (ComparisonOperator enum)
Letters setting (HeaderAutoText enum)
Light Class

Members
Overview

light color, scroll bars
LightCollection Class

Members
Overview

lighting
Lights Property
limiting

currency value

Line Class

Members
Overview

line color
line color
Line Property
LinearRange Constructor (LinearRange)
LinearRange Structure
LineBorder Property (LineSeries)
LineBorder Property (PolarLineSeries)
LineBorder Property (RadarLineSeries)
LineBorder Property (XYLineSeries)
LineBorder Property (XYZLineSeries)
LineBorders Property (LineSeries)
LineBorders Property (PolarLineSeries)
LineBorders Property (RadarLineSeries)
LineBorders Property (XYLineSeries)
LineBorders Property (XYZLineSeries)
LineCollection Class

Members
Overview

LineCollection Constructor (LineCollection)
LineFill Property (LineSeries)
LineFill Property (PolarLineSeries)
LineFill Property (RadarLineSeries)
LineFill Property (XYLineSeries)
LineFills Property (LineSeries)
LineFills Property (PolarLineSeries)
LineFills Property (RadarLineSeries)
LineFills Property (XYLineSeries)
lines

grid lines
multiple in column

lines multiple
lines multiple
lines multiple
lines multiple
Lines Property
lines, grid lines
lines, grid lines
LineSeries Class

Members
Overview

LineSeries Constructor (LineSeries)
LineSeriesCollection Class

Members
Overview

LineSparklineRenderer Class

Members
Overview

LineSparklineRenderer Constructor (LineSparklineRenderer)
LineSparklineRenderer Property
LinEstFunction Field
LineWeight Property
link
link
link
link
link button
link,for button
LinkButton setting (ButtonType enum)
list

radio buttons

list box
list box cell type
list box cells, editor
list box select mode
list box, background color
list box, cell type
list box, rows displayed
list box, text color
list for combo box
list for combo box
list for combo box
list of How To’s
list of How To's
ListAlignment Enumeration
ListAlignment Property (MultiColumnComboBoxCellType)
ListAlignment Property (MultiColumnEditor)
ListBase.Enumerator<T> Structure
ListBase.ListChangedEventArgs<T> Class

Members
Overview

ListBase.ListChangedEventArgs<T> Constructor (ListBase.ListChangedEventArgs<T>)
ListBase.ListChangedEventHandler<T> Delegate
ListBehavior Property
ListBoxCellType Class

Members
Overview

ListBoxCellType Constructor (ListBoxCellType)
ListBoxEditor Class

Members
Overview

ListBoxEditor Constructor (ListBoxEditor)
ListBoxRenderer Class

Members
Overview

ListBoxRenderer Constructor (ListBoxRenderer)
ListChanged Event (PlotAreaCollection)
ListChanged Event (SeriesCollection)
ListHeight Property (MultiColumnComboBoxCellType)
ListHeight Property (MultiColumnEditor)
ListItem Class

Members
Overview

ListItem Constructor (ListItem)
ListItems Property (ComboBoxCellType)
ListItems Property (ListBoxCellType)
ListItems Property (RadioButtonListCellType)
ListOffset Property (MultiColumnComboBoxCellType)
ListOffset Property (MultiColumnEditor)
lists, filter items behavior
ListWidth Property (MultiColumnComboBoxCellType)
ListWidth Property (MultiColumnEditor)
LnFunction Field
Load Method
load on demand
load on demand

overview
overview

load on demand, allowing
load on demand, allowing
load on demand, allowing
load on demand, allowing
load on demand, allowing
load on demand, allowing
LoadControlState Method
LoadData, client-side
LoadFormulas Method (DefaultSheetDataModel)
LoadFormulas Method (FpSpread)
LoadFormulas Method (SheetView)
LoadFromTemplate Method
loading

data from files
Excel files
from text files

loading from, text files
loading page
loading, Excel files
loading, FarPoint Spread XML files
loading, view state
LoadInitRowCount Property (FpSpread)
LoadInitRowCount Property (SheetView)
LoadObject Method
LoadObjectXml Method
LoadOffsetFromBottom Property
LoadOnDemandInterval Property
LoadOnDemandMode Enumeration
LoadOnDemandMode Property
LoadOnDemandTriggerMode Enumeration
LoadOnDemandTriggerMode Property
LoadPostData Method
LoadRowIncrement Property (FpSpread)
LoadRowIncrement Property (SheetView)
LoadTextFile Method (SheetView)
LoadTextFile Method (SpreadSerializer)
LoadViewState Method (ContextMenuCollection)
LoadViewState Method (FpChart)
LoadViewState Method (FpSpread)
LoadViewState Method (FpSpread)
LoadViewState Method (MapArea)
LoadViewState Method (SheetView)
LoadViewState Method (StateList<T>)
LoadViewState Method (TouchStripCollection)
location of image
Location Property (IndexAxis)
Location Property (LabelArea)
Location Property (LegendArea)
Location Property (PlotArea)
Location Property (ValueAxis)
LockBackColor Property
locked
locked
locked
locked
locked
locked cells

importing
importing

locked cells, background color
locked cells, text color
Locked Field
Locked Property (AlternatingRow)
Locked Property (Cell)
Locked Property (Column)
Locked Property (NamedStyle)
Locked Property (Row)
Locked Property (StyleInfo)
LockForeColor Property
locking cells
locking, cells
locking, cells
locking, cells
Log10Function Field
Logarithmic Property (PolarRadiusAxis)
Logarithmic Property (RadarValueAxis)
Logarithmic Property (ValueAxis)
LogarithmicBase Property (PolarRadiusAxis)
LogarithmicBase Property (RadarValueAxis)
LogarithmicBase Property (ValueAxis)
LogEstFunction Field
LogFunction Field
LogInvFunction Field
LogNormDistFunction Field
LookupFunction Field
Loop Property
LowerFunction Field
LowMarkerColor Property
LowValues Property (CandlestickSeries)
LowValues Property (HighLowAreaSeries)
LowValues Property (HighLowBarSeries)
LowValues Property (HighLowCloseSeries)
LowValues Property (OpenHighLowCloseSeries)
maintaining state
MajorGridLine Property (IndexAxis)
MajorGridLine Property (PolarAngleAxis)
MajorGridLine Property (PolarRadiusAxis)
MajorGridLine Property (RadarIndexAxis)
MajorGridLine Property (RadarValueAxis)
MajorGridLine Property (ValueAxis)
MajorGridVisible Property (IndexAxis)
MajorGridVisible Property (PolarAngleAxis)
MajorGridVisible Property (PolarRadiusAxis)
MajorGridVisible Property (RadarIndexAxis)
MajorGridVisible Property (RadarValueAxis)
MajorGridVisible Property (ValueAxis)
MajorTickLength Property (IndexAxis)
MajorTickLength Property (PolarAngleAxis)
MajorTickLength Property (PolarRadiusAxis)
MajorTickLength Property (RadarIndexAxis)
MajorTickLength Property (RadarValueAxis)
MajorTickLength Property (ValueAxis)
MajorTickVisible Property (IndexAxis)
MajorTickVisible Property (PolarAngleAxis)
MajorTickVisible Property (PolarRadiusAxis)
MajorTickVisible Property (RadarIndexAxis)
MajorTickVisible Property (RadarValueAxis)
MajorTickVisible Property (ValueAxis)
MajorUnit Property (IndexAxis)
MajorUnit Property (PolarAngleAxis)
MajorUnit Property (PolarRadiusAxis)
MajorUnit Property (RadarIndexAxis)
MajorUnit Property (RadarValueAxis)
MajorUnit Property (ValueAxis)
management

of state

ManualMax Property
ManualMin Property
MapArea Class

Members
Overview

MapArea Constructor (MapArea)
MapAreaClick Event
MapAreaClickEventArgs Class

Members
Overview

MapAreaClickEventArgs Constructor (MapAreaClickEventArgs)
MapAreaClickEventHandler Delegate
MapAreaCollection Class

Members
Overview

MapAreaCollection Constructor (MapAreaCollection)
MapAreaInfo Class

Members
Overview

MapAreaInfo Constructor (MapAreaInfo)
MapAreaInfo Property (ChartMapArea)
MapAreaInfo Property (IChartMapArea)
MapAreaInfo Property (MapArea)
MapAreaInfo Property (MapAreaClickEventArgs)
MapAreaInfo.MapAreaType Enumeration
MapAreas Property
Mapper Property
MapperInfo Class

Members
Overview

MapperInfo Constructor (MapperInfo)
MapperInfoConverter Class

Members
Overview

MapperInfoConverter Constructor (MapperInfoConverter)
mapping

client-side event to function

margin bottom
Margin Field
margin left
Margin Property (AlternatingRow)
Margin Property (Cell)
Margin Property (Column)
Margin Property (PreviewRowInfo)
Margin Property (PrintInfo)
Margin Property (Row)
Margin Property (StyleInfo)
Margin Property (TitleInfo)
margin right
margin top
margins
margins
margins
margins
margins
margins
margins
margins
margins

cell

Marker Class

Members
Overview

MarkerCollection Class

Members
Overview

MarkerCollection Constructor (MarkerCollection)
MarkersColor Property
MarkerShape Enumeration
market
market chart
marking, cells as locked
marking, cells as locked
MarkupName Property
Mask Property
masked cell type
masked edit cell type
MaskedEditCellType Class

Members
Overview

MaskedEditCellType Constructor (MaskedEditCellType)
MaskedEditValidator Class

Members
Overview

MaskedEditValidator Constructor (MaskedEditValidator)
MaskType Property
MatchFunction Field
Max setting (AggregationType enum)
MaxAFunction Field
MaxArgs Property
MaxAxisType Property
MaxFunction Field
maximum iteration
Maximum Property (DatabarConditionalFormattingRule)
Maximum Property (IndexAxis)
Maximum Property (NumericUpDownCellType)
Maximum Property (PolarRadiusAxis)
Maximum Property (RadarValueAxis)
Maximum Property (SliderCellType)
Maximum Property (ValueAxis)
maximum value
maximum value
MaximumChange Property (DefaultSheetDataModel)
MaximumChange Property (IIterationSupport)
MaximumChange Property (SheetView)
MaximumIterations Property (DefaultSheetDataModel)
MaximumIterations Property (IIterationSupport)
MaximumIterations Property (SheetView)
MaximumValue Property (CurrencyCellType)
MaximumValue Property (DateTimeCellType)
MaximumValue Property (DoubleCellType)
MaximumValue Property (IntegerCellType)
MaximumValue Property (MaskedEditValidator)
MaximumValue Property (PercentCellType)
MaximumValueMessage Property
MaxLength Property
MaxMinAverageRequires Property
MaxRating Property
MaxValue Property (ThreeColorScaleConditionalFormattingRule)
MaxValue Property (TwoColorScaleConditionalFormattingRule)
MDetermFunction Field
MDurationFunction Field
MeasureIconSize Event
MeasureIconSizeEventArgs Class

Members
Overview

MeasureIconSizeEventArgs Constructor (MeasureIconSizeEventArgs)
MeasureIconSizeHandler Delegate
MedianFunction Field
menu

sparklines

menuitem
MenuItem Class

Members
Overview

MenuItem Constructor (MenuItem)
MenuItemClicked Event
MenuItemClickedHandler Delegate
MenuItemClickEventArgs Class

Members
Overview

MenuItemClickEventArgs Constructor (MenuItemClickEventArgs)
MenuItemCollection Class

Members
Overview

MenuItemCollection Constructor (MenuItemCollection)
MenuType Property (FilterBarCellType)
MenuType Property (MenuItemClickEventArgs)
Merge Method (Appearance)
Merge Method (Border)
Merge Method (StyleInfo)
merge policy
merged cells

importing
importing

MergePolicy Enumeration
MergePolicy Field
merging

cells
contrast with spanning
introduction

merging, cells
merging, cells
merging, cells
merging, cells
merging, cells
merging, cells
merging, cells
merging, cells automatically
merging, cells automatically
merging, cells automatically
merging, cells automatically
merging, cells automatically
merging, cells automatically
message
message
Message Property (ErrorForm)
Message Property (ExcelException)
Message Property (ExcelWarning)
Message Property (ParseException)
message row

effect of EnableClientScript

MessageRowStyle Property
Microsoft Excel

formats
formats

MidFunction Field
MidValue Property
Min setting (AggregationType enum)
MinAFunction Field
MinArgs Property
MinAxisType Property
MinFunction Field
Minimum Property (DatabarConditionalFormattingRule)
Minimum Property (IndexAxis)
Minimum Property (NumericUpDownCellType)
Minimum Property (PolarRadiusAxis)
Minimum Property (RadarValueAxis)
Minimum Property (SliderCellType)
Minimum Property (ValueAxis)
minimum value
minimum value
MinimumPrefixLength Property
MinimumValue Property (CurrencyCellType)
MinimumValue Property (DateTimeCellType)
MinimumValue Property (DoubleCellType)
MinimumValue Property (IntegerCellType)
MinimumValue Property (MaskedEditValidator)
MinimumValue Property (PercentCellType)
MinimumValueMessage Property
MinorGridLine Property (IndexAxis)
MinorGridLine Property (PolarAngleAxis)
MinorGridLine Property (PolarRadiusAxis)
MinorGridLine Property (RadarIndexAxis)
MinorGridLine Property (RadarValueAxis)
MinorGridLine Property (ValueAxis)
MinorGridVisible Property (IndexAxis)
MinorGridVisible Property (PolarAngleAxis)
MinorGridVisible Property (PolarRadiusAxis)
MinorGridVisible Property (RadarIndexAxis)
MinorGridVisible Property (RadarValueAxis)
MinorGridVisible Property (ValueAxis)
MinorTickLength Property (IndexAxis)
MinorTickLength Property (PolarAngleAxis)
MinorTickLength Property (PolarRadiusAxis)
MinorTickLength Property (RadarIndexAxis)
MinorTickLength Property (RadarValueAxis)
MinorTickLength Property (ValueAxis)
MinorTickVisible Property (IndexAxis)
MinorTickVisible Property (PolarAngleAxis)
MinorTickVisible Property (PolarRadiusAxis)
MinorTickVisible Property (RadarIndexAxis)
MinorTickVisible Property (RadarValueAxis)
MinorTickVisible Property (ValueAxis)
MinorUnit Property (IndexAxis)
MinorUnit Property (PolarAngleAxis)
MinorUnit Property (PolarRadiusAxis)
MinorUnit Property (RadarIndexAxis)
MinorUnit Property (RadarValueAxis)
MinorUnit Property (ValueAxis)
MinuteFunction Field
MinValue Property (ThreeColorScaleConditionalFormattingRule)
MinValue Property (TwoColorScaleConditionalFormattingRule)
MInverseFunction Field
MIrrFunction Field
missing, arguments
MissingArgumentExpression Class

Members
Overview

MissingArgumentExpression Constructor (MissingArgumentExpression)
MissingArgumentValue Property
MMultFunction Field
Mode Property
mode, operation
mode, operation
mode, settings
ModeFunction Field
model data binding
Model Property (FpChart)
Model Property (SpreadChart)
model, column axis
model, row axis
models

axis
axis
base
basis for customization
data
data
default
interfaces
optional interfaces
selection
selection
sorting
span
span
style
style
types

models, axis
models, axis
models, axis event
models, axis model
models, axis model
models, axis model
models, column orientation
models, custom function support
models, custom function support
models, custom name support
models, custom name support
models, custom style support
models, data
models, data
models, data event
models, data key support
models, data model
models, data model
models, data model
models, data model name
models, data source support
models, expression support
models, expression support
models, for data binding
models, hierarchy support
models, iteration support
models, movable rows and columns support
models, names
models, namespace
models, non-empty cells support
models, parent style support
models, parsing support
models, query support
models, range support
models, recalculation support
models, row orientation
models, selection
models, selection model
models, selection model
models, selection model
models, serialization
models, serialization
models, serialization
models, serialization
models, serialization support
models, serialization support
models, span
models, span
models, span
models, span model
models, span model
models, span model
models, style
models, style
models, style
models, style model
models, style model
models, style model
models, unbound row support
ModelUpdated setting (SheetAxisModelEventType enum)
ModelUpdated setting (SheetDataModelEventType enum)
modes

operation

modes, strict
ModFunction Field
ModifyObjectExpression Method
MonthFormat Property
MonthFunction Field
MostWeight setting (Display Limit enum)
Move Method (ConditionalFormattingModel)
Move Method (DefaultSheetAxisModel)
Move Method (DefaultSheetDataModel)
Move Method (DefaultSheetSpanModel)
Move Method (DefaultSheetStyleModel)
Move Method (DefaultSparklineContainer)
Move Method (IMovable)
Move Method (IRangeSupport)
Move Method (SheetViewCollection)
Move setting (CursorType enum)
MoveColumn Method (FpSpread)
MoveColumn Method (SheetView)
MoveColumns Method
MoveFilters Method (DefaultRowFilter)
MoveFilters Method (IRowFilter)
MoveNext Method
MoveRows Method
MoveToFirstColumn, client-side
MoveToLastColumn, client-side
MoveToNextCell, client-side
MoveToNextRow, client-side
MoveToPrevCell, client-side
MoveToPrevCell, client-side
MoveToSheetView Method
moving

columns

moving, columns
moving, columns
moving, columns in grouping
moving, rows
moving,columns
Mozilla Firefox

browser support

MRoundFunction Field
MultiColumnComboBoxCellType Class

Members
Overview

MultiColumnComboBoxCellType Constructor (MultiColumnComboBoxCellType)
MultiColumnEditor Class

Members
Overview

MultiColumnEditor Constructor (MultiColumnEditor)
Multiline Property (GeneralCellType)
Multiline Property (TextCellType)
MultinomialFunction Field
multiple headers
multiple lines
multiple lines
multiple lines
multiple lines
multiple option buttons
multiple sheets
multiple sheets
multiple-column combo box
multiple-line columns
multiple-line columns
MultiplyOperator Field
MultiRange setting (SelectionPolicy enum)
MultiRangeExpression Class

Members
Overview

MultiValuesFilterItem Class

Members
Overview

MultiValuesFilterItem Constructor (MultiValuesFilterItem)
mutually exclusive check box cell type
MutuallyExclusiveCheckBoxCellType Class

Members
Overview

MutuallyExclusiveCheckBoxCellType Constructor (MutuallyExclusiveCheckBoxCellType)
mvc
mvc
MvcSpreadAttribute Class

Members
Overview

MvcSpreadAttribute Constructor (MvcSpreadAttribute)
MvcSpreadEventAttribute Class

Members
Overview

MvcSpreadEventAttribute Constructor (MvcSpreadEventAttribute)
MvcSpreadEventExcludeAttribute Class

Members
Overview

MvcSpreadEventExcludeAttribute Constructor (MvcSpreadEventExcludeAttribute)
MvcSpreadModelBinder Class

Members
Overview

MvcSpreadModelBinder Constructor (MvcSpreadModelBinder)
mydatetype.htc
NAFunction Field
name (see custom name)
Name Property (CalcError)
Name Property (ChartMapArea)
Name Property (DefaultSheetDataModel)
Name Property (ExcelWarning)
Name Property (ExternalNameExpression)
Name Property (FunctionInfo)
Name Property (INameSupport)
Name Property (IntersectOperatorInfo)
Name Property (MapArea)
Name Property (NamedStyle)
Name Property (NameExpression)
Name Property (OperatorInfo)
Name Property (SheetSkin)
Name Property (UnionOperatorInfo)
NameChanged Event (DefaultSheetDataModel)
NameChanged Event (INameSupport)
NameChanging Event (DefaultSheetDataModel)
NameChanging Event (INameSupport2)
named expressions in formulas
named range

custom name

named style
named style
named style
named style
named style
named style
named style
named style
named style
named styles
named styles
named styles
named styles
named styles

editor
editor

named styles, collection
NamedStyle Class

Members
Overview

NamedStyle Constructor (NamedStyle)
NamedStyleCollection Class

Members
Overview

NamedStyleCollection Constructor (NamedStyleCollection)
NamedStyleCollectionEventArgs Class

Members
Overview

NamedStyleCollectionEventArgs Constructor (NamedStyleCollectionEventArgs)
NamedStyleCollectionEventHandler Delegate
NamedStyleCollectionEventType Enumeration
NamedStyles Property (DefaultSheetStyleModel)
NamedStyles Property (FpSpread)
NamedStyles Property (INamedStyleSupport)
NamedStyles Property (SheetView)
NameExpression Class

Members
Overview

NameExpression Constructor (NameExpression)
names

custom

names, custom
names, custom
names, custom styles
names, data model
names, expression
names, removing custom
names, sheet tab font
names, sheets
names, sheets
names, sheets
names, sheets
names, sheets
names, sheets
namespaces, Data
namespaces, Editor
namespaces, FarPoint.Web.Spread
namespaces, Model
namespaces, Renderer
NavigateUrl Property (HyperLinkCellType)
NavigateUrl Property (HyperLinkRenderer)
navigation

page nav buttons

navigation, page
navigation, page
navigation, page advancing
navigation, page position
NegateOperator Field
NegativeBorder Property
NegativeBorderColor Property
NegativeBorders Property
NegativeColor Property
NegativeFill Property
NegativeFillColor Property
NegativeFills Property
NegativeRed Property
NegativeVisible Property
NegBinomDistFunction Field
NeResize setting (CursorType enum)
nesting functions
NetWorkdaysFunction Field
Never setting (ScrollBarPolicy enum)
Never setting (TabControlPolicy enum)
NewSize Property
NewStyle Property
Newvalue Property (ItemTrackedEventArgs)
NewValue Property (PropertyChangingEventArgs)
Newvalue Property (PropertyTrackChangedEventArgs)
NewVisible Property
Next button
Next command (client-side)
next page, changing to
Next, client-side
NextButtonID Property
NextNonEmptyColumnInRow Method (BaseSheetDataModel)
NextNonEmptyColumnInRow Method (BaseSheetStyleModel)
NextNonEmptyColumnInRow Method (DefaultSheetDataModel)
NextNonEmptyColumnInRow Method (DefaultSheetDataModel.DefaultSheetDataModelEnumerator)
NextNonEmptyColumnInRow Method (DefaultSheetStyleModel)
NextNonEmptyColumnInRow Method (GroupDataModel)
NextNonEmptyColumnInRow Method (IOptimizedEnumerationSupport)
NextNonEmptyRow Method (BaseSheetDataModel)
NextNonEmptyRow Method (BaseSheetStyleModel)
NextNonEmptyRow Method (DefaultSheetDataModel)
NextNonEmptyRow Method (DefaultSheetDataModel.DefaultSheetDataModelEnumerator)
NextNonEmptyRow Method (DefaultSheetStyleModel)
NextNonEmptyRow Method (GroupDataModel)
NextNonEmptyRow Method (IOptimizedEnumerationSupport2)
NextNonEmptyRow Method (IOptimizedFilterStyleModel)
NextPrev setting (PagerMode enum)
NFunction Field
NoBevel Class

Members
Overview

NoBevel Constructor (NoBevel)
NoFill Class

Members
Overview

NoFill Constructor (NoFill)
NoFlagsSet setting (ExcelOpenFlags enum)
NoFlagsSet setting (ExcelSaveFlags enum)
NoFormulas setting (ExcelSaveFlags enum)
NoLine Class

Members
Overview

NoLine Constructor (NoLine)
NoMarker Class

Members
Overview

NoMarker Constructor (NoMarker)
NominalFunction Field
NoMvcSpreadEventAttribute Class

Members
Overview

NoMvcSpreadEventAttribute Constructor (NoMvcSpreadEventAttribute)
NonBlank setting (FilterListBehavior enum)
NonBlanks (filtering list item)
NonBlanks (filtering list item)
NonBlanksString Property (DefaultRowFilter)
NonBlanksString Property (IRowFilter)
None Field
None setting (AggregationType enum)
None setting (Centering enum)
None setting (Display Limit enum)
None setting (IncludeHeaders enum)
None setting (MergePolicy enum)
None setting (MergePolicy enum)
None setting (MergePolicy enum)
None setting (MergePolicy enum)
None setting (MergePolicy enum)
None setting (PrintNotes enum)
None setting (ResetOption enum)
None setting (SortIndicator enum)
None setting (TextDecoration enum)
NonEditModeValidation Property
NonEmptyColumnCount Property (BaseSheetDataModel)
NonEmptyColumnCount Property (BaseSheetStyleModel)
NonEmptyColumnCount Property (DefaultSheetDataModel)
NonEmptyColumnCount Property (DefaultSheetStyleModel)
NonEmptyColumnCount Property (GroupDataModel)
NonEmptyColumnCount Property (INonEmptyCells)
NonEmptyColumnCount Property (SheetView)
NonEmptyRowCount Property (BaseSheetDataModel)
NonEmptyRowCount Property (BaseSheetStyleModel)
NonEmptyRowCount Property (DefaultSheetDataModel)
NonEmptyRowCount Property (DefaultSheetStyleModel)
NonEmptyRowCount Property (GroupDataModel)
NonEmptyRowCount Property (INonEmptyCells)
NonEmptyRowCount Property (SheetView)
non-scrollable

rows and columns

Normal setting (OperationMode enum)
NormDistFunction Field
NormInvFunction Field
NormSDistFunction Field
NormSInvFunction Field
NotAvailable Property
NotBetween setting (ComparisonOperator enum)
Note Property
NotEqualOperator Field
NotEqualTo setting (ComparisonOperator enum)
notes

cells
importing Excel comments

notes, cells
notes, cells
notes, cells
notes, printing
NotFunction Field
NotifyChanged Method
NotifyDataChanged Method
NotifyFormulaChanged Method
NotifyNotSatisfied Method
NotifyRequiresChanged Method
NotSet setting (CursorType enum)
NotStructuredStorage setting (ExcelExceptionCode enum)
NowFunction Field
NPerFunction Field
NpvFunction Field
NResize setting (CursorType enum)
Null Property
NullItemBevelCollectionCodeDomSerializer Class

Members
Overview

NullItemBevelCollectionCodeDomSerializer Constructor (NullItemBevelCollectionCodeDomSerializer)
NullItemFillCollectionCodeDomSerializer Class

Members
Overview

NullItemFillCollectionCodeDomSerializer Constructor (NullItemFillCollectionCodeDomSerializer)
NullItemLineCollectionCodeDomSerializer Class

Members
Overview

NullItemLineCollectionCodeDomSerializer Constructor (NullItemLineCollectionCodeDomSerializer)
NullItemMarkerCollectionCodeDomSerializer Class

Members
Overview

NullItemMarkerCollectionCodeDomSerializer Constructor (NullItemMarkerCollectionCodeDomSerializer)
NullItemStringCollectionCodeDomSerializer Class

Members
Overview

NullItemStringCollectionCodeDomSerializer Constructor (NullItemStringCollectionCodeDomSerializer)
number cell (see general cell type)
number cell type (see integer or double cell type)
number cell type (see integer or double cell type)
Number Property
Number setting (PagerMode enum)
NumberFormat Property (CurrencyCellType)
NumberFormat Property (CurrencyCellType.EditModeSettings)
NumberFormat Property (CurrencyFormatter)
NumberFormat Property (DoubleCellType.EditModeSettings)
NumberFormat Property (GeneralCellType)
NumberFormat Property (GeneralFormatter)
NumberFormat Property (IntegerCellType)
NumberFormat Property (IntegerCellType.EditModeSettings)
Numbers setting (HeaderAutoText enum)
numbers, page displaying
numbers,in headers
numeric cell type
numeric cell type
numeric cell type
numeric cell type
numeric up-down cell type
NumericUpDownCellType Class

Members
Overview

NumericUpDownCellType Constructor (NumericUpDownCellType)
NwResize setting (CursorType enum)
object models
object models
object models
object models, axis
object models, axis
object models, axis
object models, data
object models, data
object models, data
object models, selection
object models, selection
object models, selection
object models, span
object models, span
object models, span
object models, style
object models, style
object models, style
object parentage
ObjectExpressionProvider Property
Objects Property
objects, grouping
ObliqueProjection Class

Members
Overview

ObliqueProjection Constructor (ObliqueProjection)
Oct2BinFunction Field
Oct2DecFunction Field
Oct2HexFunction Field
OddFPriceFunction Field
OddFunction Field
OddFYieldFunction Field
OddLPriceFunction Field
OddLYieldFunction Field
OddRowBackColor Property
ODF document
Office Open XML
Office2007 Property
Office2013 Property
Office2016Colorful Property
Office2016DarkGray Property
Office2016White Property
OFFSET_MIN Field
OffsetFunction Field
OldStyle Property
OldValue Property (ItemTrackedEventArgs)
OldValue Property (PropertyTrackChangedEventArgs)
onActiveCellChanged, client-side
onActiveCellChanging, client-side
OnAddColumnFooterRows Method
OnAddColumnHeaderRows Method
OnAddColumns Method (LayoutTemplate)
OnAddColumns Method (SheetView)
OnAddRowHeaderColumns Method
OnAddRows Method (LayoutTemplate)
OnAddRows Method (SheetView)
OnAggregate Method
onAutoFilterColumn, client-side
onAutoFilterColumnCompleted, client-side
onAutoFilteredColumn, client-side
onAutoFilteringColumn, client-side
OnBeforeRenderMapAreas Method (FpChart)
OnBeforeRenderMapAreas Method (SpreadChart)
OnBlurCssNegative Property
onCallBackStart, client-side
onCallBackStopped, client-side
OnChanged Method (AreaSeriesCollection)
OnChanged Method (Axis)
OnChanged Method (BarSeriesCollection)
OnChanged Method (BaseSheetAxisModel)
OnChanged Method (BaseSheetStyleModel)
OnChanged Method (BevelCollection)
OnChanged Method (ChartModel)
OnChanged Method (ConditionalFormattingModel)
OnChanged Method (DefaultSparklineContainer)
OnChanged Method (DetachmentCollection)
OnChanged Method (DoubleCollection)
OnChanged Method (DoubleCollectionCollection)
OnChanged Method (FillCollection)
OnChanged Method (LabelArea)
OnChanged Method (LabelAreaCollection)
OnChanged Method (LegendArea)
OnChanged Method (LegendAreaCollection)
OnChanged Method (Light)
OnChanged Method (LightCollection)
OnChanged Method (LineCollection)
OnChanged Method (LineSeriesCollection)
OnChanged Method (MarkerCollection)
OnChanged Method (NamedStyle)
OnChanged Method (NamedStyleCollection)
OnChanged Method (PlotArea)
OnChanged Method (PlotAreaCollection)
OnChanged Method (PointSeriesCollection)
OnChanged Method (PolarRadiusAxisCollection)
OnChanged Method (RadarValueAxisCollection)
OnChanged Method (Series)
OnChanged Method (SeriesCollection)
OnChanged Method (StringCollection)
OnChanged Method (Stripe)
OnChanged Method (StripeCollection)
OnChanged Method (ValueAxisCollection)
OnChanged Method (Wall)
OnChanging Method
OnClear Method
OnClearComplete Method
OnClearItems Method
OnClick Method
OnClientChanged Property (ComboBoxCellType)
OnClientChanged Property (ComboBoxEditor)
OnClientClick Property (ButtonCellType)
OnClientClick Property (ButtonRenderer)
OnClientClick Property (CheckBoxCellType)
OnClientClick Property (CheckBoxEditor)
OnClientClick Property (MenuItem)
OnClientClick Property (RadioButtonListCellType)
OnClientClick Property (RadioButtonListEditor)
OnClientDateSelectionChanged Property
OnClientHidden Property (AutoCompleteCellType)
OnClientHidden Property (DateCalendarCellType)
OnClientHiding Property (AutoCompleteCellType)
OnClientHiding Property (DateCalendarCellType)
OnClientItemOut Property
OnClientItemOver Property
OnClientItemSelected Property
OnClientPopulated Property
OnClientPopulating Property
OnClientShowing Property (AutoCompleteCellType)
OnClientShowing Property (DateCalendarCellType)
OnClientShown Property (AutoCompleteCellType)
OnClientShown Property (DateCalendarCellType)
onColumnDragMove, client-side
onColumnDragMoveCompleted, client-side
onColWidthChanged, client-side
onContextMenuClosed, client-side
onContextMenuOpened, client-side
onContextMenuOpening, client-side
onCopyData, client-side
onDataChanged event
OnDataChanged Method (CellRangeSegmentData)
OnDataChanged Method (SeriesDataField)
onDataChanged, client-side
OnDataModelChanged Method
OnDataModelRowInserted Method (DefaultSpreadDataViewMapper)
OnDataModelRowInserted Method (ISpreadDataViewMapper)
OnDataModelRowRemoved Method (DefaultSpreadDataViewMapper)
OnDataModelRowRemoved Method (ISpreadDataViewMapper)
OnDataReset Method (DefaultSpreadDataViewMapper)
OnDataReset Method (ISpreadDataViewMapper)
OnDataRowAdded Method (DefaultSpreadDataViewMapper)
OnDataRowAdded Method (ISpreadDataViewMapper)
OnDataRowChanged Method (DefaultSpreadDataViewMapper)
OnDataRowChanged Method (ISpreadDataViewMapper)
OnDataRowDeleted Method (DefaultSpreadDataViewMapper)
OnDataRowDeleted Method (ISpreadDataViewMapper)
OnDataRowMoved Method (DefaultSpreadDataViewMapper)
OnDataRowMoved Method (ISpreadDataViewMapper)
OnDeserialize Method (ContextMenu)
OnDeserialize Method (MenuItem)
OnDeserialize Method (TouchStrip)
OnDeserializeElement Method (MenuItem)
OnDeserializeElement Method (TouchStripItem)
one-based ref.s

in formulas

onEditStart, client-side
onEditStopped, client-side
onErrorMessageShown, client-side
OnFilterColumnDefinitionCollectionChanged Method
OnFocusCssClass Property
OnFocusCssNegative Property
OnInit Method (FpChart)
OnInit Method (FpSpread)
OnInit Method (SpreadDataSource)
OnInsert Method
OnInsertComplete Method (SheetViewCollection)
OnInsertComplete Method (SpreadDataColumnCollection)
OnItemAdded Method
OnItemRemoved Method
OnItemUpdated Method
OnListChanged Method (ConditionalFormattingIconRuleSet)
OnListChanged Method (ContextMenuCollection)
OnListChanged Method (MenuItemCollection)
OnListChanged Method (PlotAreaCollection)
OnListChanged Method (SeriesCollection)
OnListChanged Method (SpreadDataView)
OnListChanged Method (TouchStripItemCollection)
OnLoad Method (FpChart)
OnLoad Method (SpreadDataSource)
onLoadRowsStart, client-side
onLoadRowsStopped, client-side
OnMapAreaClick Method
onMenuClicked, client-side
OnMenuItemClicked Method
OnNamedStyleChanged Method
OnPreRender Method (FpChart)
OnPreRender Method (FpSpread)
OnPreRender Method (FpSpreadTemplateReplacement)
OnPreRender Method (PreviewRowTemplateContainer)
OnPreRender Method (SpreadChart)
OnPrintPDF Method
OnPropertyChanged Method (BaseSparkline)
OnPropertyChanged Method (ChartDataSetting)
OnPropertyChanged Method (ConditionalFormattingRule)
OnPropertyChanged Method (DefaultSpreadDataViewMapper)
OnPropertyChanged Method (ExcelSparklineSetting)
OnPropertyChanged Method (SpreadDataColumn)
OnPropertyChanged Method (ThreeColorScaleConditionalFormattingRule)
OnPropertyChanging Method
OnRemove Method (SheetViewCollection)
OnRemove Method (SpreadChartCollection)
OnRemoveColumnFooterRows Method
OnRemoveColumnHeaderRows Method
OnRemoveColumns Method (LayoutTemplate)
OnRemoveColumns Method (SheetView)
OnRemoveComplete Method (SheetViewCollection)
OnRemoveComplete Method (SpreadDataColumnCollection)
OnRemoveRowHeaderColumns Method
OnRemoveRows Method (LayoutTemplate)
OnRemoveRows Method (SheetView)
onRowHeightChanged, client-side
onScroll, client-side
onSelectionChanged, client-side
OnSerialize Method (ContextMenu)
OnSerialize Method (MenuItem)
OnSerialize Method (TouchStrip)
OnSerialize Method (TouchStripItem)
OnSet Method
OnSetComplete Method (SheetViewCollection)
OnSetComplete Method (SpreadDataColumnCollection)
OnStyleModelChanged Method
onTouchStripClosed
OnTouchStripItemClicked Method
onTouchStripOpened
onTouchStripOpening
OnUnload Method
OnUpdated Method (BaseSparkline)
OnUpdated Method (ExcelSparklineGroup)
OnUpdated Method (ExcelSparklineSetting)
OnValidate Method
Opacity Property
Open Method (FpSpread)
Open Method (SheetView)
OpenExcel Method (FpSpread)
OpenExcel Method (SheetView)
OpenHighLowCloseSeries Class

Members
Overview

OpenHighLowCloseSeries Constructor (OpenHighLowCloseSeries)
opening

text files
data from files
Excel files
files
Spread XML files

opening, Excel
opening, Excel files
opening, Excel files
opening, FarPoint Spread XML files
opening, text files
opening, XML
OpenValues Property (CandlestickSeries)
OpenValues Property (OpenHighLowCloseSeries)
OpenXml Method
operation mode
operation mode
operation mode
operation mode

introduction

OperationMode Enumeration
OperationMode Property
Operator Property (BinaryOperatorExpression)
Operator Property (FilterCondition)
Operator Property (TextConditionalFormattingRule)
Operator Property (UnaryComparisonConditionalFormattingRule)
Operator Property (UnaryOperatorExpression)
OperatorInfo Class

Members
Overview

operators

importing
importing

operators, base class
operators, binary
operators, expressions
operators, expressions
operators, expressions
operators, expressions
operators, unary
optimizing, data retrieval
optimizing, data retrieval
option button list (see radio button list)
option buttons
option buttons, cell type
optional

interfaces

optional, arguments
options

regional

order of precedence
order, printing page
Ordinal Property
OrFunction Field
orientation

printing

Orientation Property (DefaultSheetAxisModel)
Orientation Property (PrintInfo)
Orientation Property (SliderCellType)
orientation, axis
orientation, page printing
Origin Property (AreaSeries)
Origin Property (BarSeries)
Origin Property (ClusteredBarSeries)
OrthogonalProjection Class

Members
Overview

OrthogonalProjection Constructor (OrthogonalProjection)
outlines
Outlook-style grouping
Outlook-style grouping
Outlook-style grouping, data model
Outlook-style grouping, group
OutStyle Property
Overlap Property
Overline Property
OverlineFontStyle Enumeration
OverThenDown setting (PrintPageOrder)
overview
Owner Property (DefaultSparklineContainer)
Owner Property (ISparklineContainer)
padding

See cell margins

Padding Property (LabelArea)
Padding Property (LegendArea)
padding, cell padding
padding, cell padding
padding, cell padding
padding, cell padding
padding, cell padding
PaddingF Constructor (PaddingF)
PaddingF Structure
page

next
previous

Page command (client-side)
page footers

printing

page headers

printing

page load event
page loading

state management

page navigation
page navigation

buttons
buttons
position
settings

page navigation, position
page navigation, settings
page order, printing
page orientation, printing
page size
page size, maximum rows
page size, setting
PageBreak Field
PageBreak Property (Column)
PageBreak Property (PrintEventArgs)
PageBreak Property (Row)
PageCount Property
PageEnd Property
PageIndex Property
PageMaxAlign Property
PageNumber Property
PageOrder Property
Pager Property (CreateChildViewEventArgs)
Pager Property (FpSpread)
pager, position
PageRange setting (PrintType enum)
PagerInfo Class

Members
Overview

PagerInfo Constructor (PagerInfo)
PagerMode Enumeration
PagerPosition Enumeration
pages

defined
size (number of rows)

pages, advancing
pages, displaying numbers
pages, maximum rows
pages, navigation
pages, navigation
PageSize Property
PageStart Property
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
paint cell
Paint Method (Border)
Paint Method (Chart2DRenderer)
Paint Method (Chart3DRenderer)
Paint Method (IPdfBorderSupport)
PaintCell Method (AjaxComboBoxCellType)
PaintCell Method (BaseCellType)
PaintCell Method (BaseRenderer)
PaintCell Method (ButtonCellType)
PaintCell Method (ButtonRenderer)
PaintCell Method (CheckBoxCellType)
PaintCell Method (ColumnHeaderFilterCellType)
PaintCell Method (ComboBoxCellType)
PaintCell Method (CurrencyCellType)
PaintCell Method (DatabarConditionalFormattingRule)
PaintCell Method (DateTimeCellType)
PaintCell Method (DefaultRenderer)
PaintCell Method (DoubleCellType)
PaintCell Method (EmptyCellType)
PaintCell Method (ExtenderCellTypeBase)
PaintCell Method (FilterBarCellType)
PaintCell Method (GeneralCellType)
PaintCell Method (HyperLinkCellType)
PaintCell Method (IconSetConditionalFormattingRule)
PaintCell Method (IEnhancedPdfRenderer)
PaintCell Method (IEnhancedRenderer)
PaintCell Method (ImageCellType)
PaintCell Method (IntegerCellType)
PaintCell Method (IPdfPrintableRule)
PaintCell Method (IPdfSupport)
PaintCell Method (IPrePaintTextConditionalFormattingRule)
PaintCell Method (IRenderer)
PaintCell Method (IRenderer2)
PaintCell Method (LabelCellType)
PaintCell Method (ListBoxCellType)
PaintCell Method (ListBoxRenderer)
PaintCell Method (MultiColumnComboBoxCellType)
PaintCell Method (MutuallyExclusiveCheckBoxCellType)
PaintCell Method (PercentCellType)
PaintCell Method (PrePaintTextConditionalFormattingRule)
PaintCell Method (RadioButtonListCellType)
PaintCell Method (RegExpCellType)
PaintCell Method (TagCloudCellType)
PaintCell Method (TextCellType)
PaintSparkline Method (ColumnSparklineRenderer)
PaintSparkline Method (ExcelBaseSparkLineRenderer)
PaintSparkline Method (ISparklineRenderer)
PaintSparkline Method (LineSparklineRenderer)
PaintSparkline Method (WinLossSparklineRenderer)
PanningMode Property
Parallel Property
ParallelOptions Enumeration
parent

hierarchy
inherit formatting

Parent Field
Parent Property (AlternatingRow)
Parent Property (AlternatingRows)
Parent Property (Cell)
Parent Property (Cells)
Parent Property (Column)
Parent Property (Columns)
Parent Property (DefaultSheetAxisModel)
Parent Property (DefaultSheetDataModel)
Parent Property (DefaultSheetStyleModel)
Parent Property (Group)
Parent Property (IChildModelSupport)
Parent Property (IParentStyleModelSupport)
Parent Property (MenuItem)
Parent Property (NamedStyle)
Parent Property (Row)
Parent Property (Rows)
Parent Property (SheetView)
Parent Property (StyleInfo)
parent sheet
parent, alternating row
parent, alternating rows
parent, cell
parent, cells
parent, column
parent, columns
parent, rows
parent, rows
parent, sheet
parent, styles
parent, styles
parent, styles
parent, styles
ParenthesesExpression Class

Members
Overview

ParenthesesExpression Constructor (ParenthesesExpression)
ParentRelationName Property (DefaultSheetDataModel)
ParentRelationName Property (IChildModelSupport)
ParentRowIndex Property (DefaultSheetDataModel)
ParentRowIndex Property (IChildModelSupport)
ParentRowIndex Property (SheetView)
ParentStyleName Property (AlternatingRow)
ParentStyleName Property (Cell)
ParentStyleName Property (Column)
ParentStyleName Property (Row)
ParentStyleNameConverter Class

Members
Overview

ParentStyleNameConverter Constructor (ParentStyleNameConverter)
parentView Field
Pareto chart
Parse Method (AjaxComboBoxCellType)
Parse Method (BaseCellType)
Parse Method (BorderProperty)
Parse Method (ButtonCellType)
Parse Method (CalcError)
Parse Method (CellRange)
Parse Method (CheckBoxCellType)
Parse Method (ComboBoxCellType)
Parse Method (CurrencyCellType)
Parse Method (CurrencyFormatter)
Parse Method (DateCalendarCellType)
Parse Method (DateTimeCellType)
Parse Method (DoubleCellType)
Parse Method (GeneralCellType)
Parse Method (GeneralFormatter)
Parse Method (IEditFormatter)
Parse Method (IFormatter)
Parse Method (IntegerCellType)
Parse Method (ListBoxCellType)
Parse Method (MapAreaInfo)
Parse Method (MultiColumnComboBoxCellType)
Parse Method (MutuallyExclusiveCheckBoxCellType)
Parse Method (NumericUpDownCellType)
Parse Method (PercentCellType)
Parse Method (RadioButtonListCellType)
Parse Method (RatingCellType)
Parse Method (RegExpCellType)
Parse Method (SliderCellType)
ParseException Class

Members
Overview

ParseException Constructor (ParseException)
ParseFormula Method (DefaultSheetDataModel)
ParseFormula Method (IExpressionSupport2)
ParseFormula Method (IObjectExpressionSupport)
parsing, exceptions
parsing, format strings
parts

Web Parts

Password Property
password strength cell type
paste
Paste, client-side
pdf files

saving to

PDF, borders
PDF, printing Spread
PDF, saving Spread
PDF, support
PdfFileName Property
PearsonFunction Field
percent cell type
Percent Property (StackedAreaSeries)
Percent Property (StackedBarSeries)
Percent Property (StackedLineSeries)
Percent Property (StackedPointSeries)
percent, cell type
percent, data type
PercentCellType Class

Members
Overview

PercentCellType Constructor (PercentCellType)
percenteditor.htc file
PercentileFunction Field
PercentOperator Field
PercentRankFunction Field
percentrender.htc file
PermutFunction Field
PerspectiveAngle Property
PerspectiveProjection Class

Members
Overview

PerspectiveProjection Constructor (PerspectiveProjection)
picture
picture
picture
picture
picture cell (see image cell type)
pictures,button
pictures,button
pictures,for check box
pictures,for check box
pictures,for check box
pie plot types
PieBorder Property
PieBorders Property
PieDetachments Property
PieFill Property
PieFills Property
PiePlotArea Class

Members
Overview

PiePlotArea Constructor (PiePlotArea)
PieSeries Class

Members
Overview

PieSeries Constructor (PieSeries)
PiFunction Field
placing formula in sheet
PlayButtonID Property
PlayButtonText Property
PlayInterval Property
plot types
plot types
plot types
plot types
plot types
PlotArea Class

Members
Overview

PlotArea Property (PlotAreaHitTest)
PlotArea Property (SeriesHitTest)
PlotArea Property (SeriesInfo)
PlotAreaCollection Class

Members
Overview

PlotAreaHitTest Class

Members
Overview

PlotAreaHitTest Constructor (PlotAreaHitTest)
PlotAreas Property
PlusOperator Field
PmtFunction Field
PointBorder Property (LineSeries)
PointBorder Property (PointSeries)
PointBorder Property (PolarLineSeries)
PointBorder Property (PolarPointSeries)
PointBorder Property (RadarLineSeries)
PointBorder Property (RadarPointSeries)
PointBorder Property (XYLineSeries)
PointBorder Property (XYPointSeries)
PointBorder Property (XYZLineSeries)
PointBorder Property (XYZPointSeries)
PointBorders Property (LineSeries)
PointBorders Property (PointSeries)
PointBorders Property (PolarLineSeries)
PointBorders Property (PolarPointSeries)
PointBorders Property (RadarLineSeries)
PointBorders Property (RadarPointSeries)
PointBorders Property (XYLineSeries)
PointBorders Property (XYPointSeries)
PointBorders Property (XYZLineSeries)
PointBorders Property (XYZPointSeries)
Pointer setting (CursorType enum)
PointFill Property (LineSeries)
PointFill Property (PointSeries)
PointFill Property (PolarLineSeries)
PointFill Property (PolarPointSeries)
PointFill Property (RadarLineSeries)
PointFill Property (RadarPointSeries)
PointFill Property (XYLineSeries)
PointFill Property (XYPointSeries)
PointFill Property (XYZLineSeries)
PointFill Property (XYZPointSeries)
PointFills Property (LineSeries)
PointFills Property (PointSeries)
PointFills Property (PolarLineSeries)
PointFills Property (PolarPointSeries)
PointFills Property (RadarLineSeries)
PointFills Property (RadarPointSeries)
PointFills Property (XYLineSeries)
PointFills Property (XYPointSeries)
PointFills Property (XYZLineSeries)
PointFills Property (XYZPointSeries)
PointIndex Property (MapAreaInfo)
PointIndex Property (SeriesHitTest)
PointIndex Property (SeriesInfo)
PointMarker Property (LineSeries)
PointMarker Property (PointSeries)
PointMarker Property (PolarLineSeries)
PointMarker Property (PolarPointSeries)
PointMarker Property (RadarLineSeries)
PointMarker Property (RadarPointSeries)
PointMarker Property (XYLineSeries)
PointMarker Property (XYPointSeries)
PointMarker Property (XYZLineSeries)
PointMarker Property (XYZPointSeries)
PointMarkers Property (LineSeries)
PointMarkers Property (PointSeries)
PointMarkers Property (PolarLineSeries)
PointMarkers Property (PolarPointSeries)
PointMarkers Property (RadarLineSeries)
PointMarkers Property (RadarPointSeries)
PointMarkers Property (XYLineSeries)
PointMarkers Property (XYPointSeries)
PointMarkers Property (XYZLineSeries)
PointMarkers Property (XYZPointSeries)
PointSeries Class

Members
Overview

PointSeries Constructor (PointSeries)
PointSeriesCollection Class

Members
Overview

PoissonFunction Field
polar plot type
PolarAngleAxis Class

Members
Overview

PolarAngleAxis Constructor (PolarAngleAxis)
PolarAreaSeries Class

Members
Overview

PolarAreaSeries Constructor (PolarAreaSeries)
PolarLineSeries Class

Members
Overview

PolarLineSeries Constructor (PolarLineSeries)
PolarPlotArea Class

Members
Overview

PolarPlotArea Constructor (PolarPlotArea)
PolarPointSeries Class

Members
Overview

PolarPointSeries Constructor (PolarPointSeries)
PolarRadiusAxis Class

Members
Overview

PolarRadiusAxis Constructor (PolarRadiusAxis)
PolarRadiusAxisCollection Class

Members
Overview

PolarSeries Class

Members
Overview

policy

merging
scroll bars

policy tab control
policy, sheet name tabs
PopupPosition Property
Portrait setting (PrintOrientation enum)
Position Property
PositionalLight Class

Members
Overview

PositionalLight Constructor (PositionalLight)
positioning

command bar

PositionX Property
PositionY Property
PositionZ Property
PositiveBorder Property
PositiveBorders Property
PositiveFill Property
PositiveFills Property
postback, automatic
postback, automatic
postback, automatic
postback, automatic
postback, automatic
postback, automatic
postback, automatic
postbacks

limiting

posting back
PowerFunction Field
PpmtFunction Field
precedence

order of

pre-defined

CallBack commands

pre-defined skins
PrePaintConditionalFormattingRule Class

Members
Overview

PrePaintResult Class

Members
Overview

PrePaintResult Constructor (PrePaintResult)
PrePaintTextConditionalFormattingRule Class

Members
Overview

PrePaintTextConditionalFormattingRule Constructor (PrePaintTextConditionalFormattingRule)
PrePaintTextDecorator Property
PrePaintTextResult Class

Members
Overview

PrePaintTextResult Constructor (PrePaintTextResult)
Prev command (client-side)
Prev, client-side
preview rows
PreviewRowColumnIndex Property
PreviewRowInfo Class

Members
Overview

PreviewRowInfo Constructor (PreviewRowInfo)
PreviewRowStyle Property
PreviewRowTemplate Property
PreviewRowTemplateContainer Class

Members
Overview

PreviewRowTemplateContainer Constructor (PreviewRowTemplateContainer)
PreviewRowVisible Property
Previous button
previous page, changing to
PreviousButtonID Property
PriceDiscFunction Field
PriceFunction Field
PriceMatFunction Field
print
print
print dialog
Print, client-side
Print, client-side
PrintAbort Event
PrintAbortEventArgs Class

Members
Overview

PrintAbortEventArgs Constructor (PrintAbortEventArgs)
PrintAbortEventHandler Delegate
PrintBackground Event
PrintBackgroundEventArgs Class

Members
Overview

PrintBackgroundEventArgs Constructor (PrintBackgroundEventArgs)
PrintBackgroundEventHandler Delegate
PrintEventArgs Class

Members
Overview

PrintEventArgs Constructor (PrintEventArgs)
PrintEventHandler Delegate
PrintExternalImage Event
PrintExternalImageEnd Event
PrintExternalImageEventArgs Class

Members
Overview

PrintExternalImageEventArgs Constructor (PrintExternalImageEventArgs)
PrintExternalImageEventHandler Delegate
PrintHeader Enumeration
PrintInfo Class

Members
Overview

PrintInfo Constructor (PrintInfo)
PrintInfo Property
printing

automatically determining settings
fitting to pages
footers
footers
headers
headers
orientation
overview
overview
page footer
page header
Print icon
scaling
sheets
sizing
SmartPrint
specifying printed data
zoom

printing files

saving

printing, event arguments
printing, header
printing, headers
printing, notes
printing, page order
printing, page orientation
printing, to PDF
printing, type
PrintMargin Class

Members
Overview

PrintMargin Constructor (PrintMargin)
PrintNotes Enumeration
PrintNotes Property
PrintOrientation Enumeration
PrintPageOrder Enumeration
PrintPDF Event
PrintPDFEventArgs Class

Members
Overview

PrintPDFEventArgs Constructor (PrintPDFEventArgs)
PrintPDFEventHandler Delegate
PrintSheet Event
PrintTitle Enumeration
PrintType Enumeration
PrintType Property
Priority Property (ConditionalFormattingRule)
Priority Property (IConditionalFormattingRule)
ProbFunction Field
procedures

How To’s
How To's

ProcessGeneratedCode Method (FpChartBuilder)
ProcessGeneratedCode Method (SpreadControlBuilder)
processing

Tab key

ProcessMargin Method
ProcessRequest Method
ProcessTab Property

using

Product setting (AggregationType enum)
ProductFunction Field
Professional1 Property
Professional2 Property
Professional3 Property
programming

client-side

Projection Class

Members
Overview

Projection Constructor (Projection)
Projection Property
PromptCharacter Property
ProperFunction Field
properties, sheet axis
Property Designer FpSpread
PropertyChanged Event (BaseSparkline)
PropertyChanged Event (ChartDataSetting)
PropertyChanged Event (ConditionalFormattingRule)
PropertyChanged Event (DefaultSpreadDataViewMapper)
PropertyChanged Event (ExcelSparklineSetting)
PropertyChanged Event (IPropertyChangedNotification)
PropertyChanged Event (SpreadDataColumn)
PropertyChanged Event (SpreadDataRowView)
PropertyChanging Event
PropertyChangingEventArgs Class

Members
Overview

PropertyChangingEventArgs Constructor (PropertyChangingEventArgs)
PropertyChangingEventHandler Delegate
PropertyName Property (ItemPropertyEventArgs<T>)
PropertyName Property (ItemTrackedEventArgs)
PropertyName Property (PropertyChangingEventArgs)
PropertyName Property (PropertyTrackChangedEventArgs)
PropertyTrackChangedEventArgs Class

Members
Overview

PropertyTrackChangedEventArgs Constructor (PropertyTrackChangedEventArgs)
PropertyTrackChangedEventHandler Delegate
PropertyType Property (DoubleCollectionPropertyDescriptor)
PropertyType Property (SpreadDataColumnPropertyDescriptor)
Protect Property
protected
protected
protected
protected
protected
protecting cells
PushButton setting (ButtonType enum)
PvFunction Field
QuartileFunction Field
querying
QuotientFunction Field
R1C1 setting (ReferenceStyle enum)
radar plot types
RadarAreaSeries Class

Members
Overview

RadarAreaSeries Constructor (RadarAreaSeries)
RadarIndexAxis Class

Members
Overview

RadarIndexAxis Constructor (RadarIndexAxis)
RadarLineSeries Class

Members
Overview

RadarLineSeries Constructor (RadarLineSeries)
RadarPlotArea Class

Members
Overview

RadarPlotArea Constructor (RadarPlotArea)
RadarPointSeries Class

Members
Overview

RadarPointSeries Constructor (RadarPointSeries)
RadarSeries Class

Members
Overview

RadarValueAxis Class

Members
Overview

RadarValueAxis Constructor (RadarValueAxis)
RadarValueAxisCollection Class

Members
Overview

RadiansFunction Field
radio button list cell type
radio button list cells, editor
radio buttons
radio buttons, cell type
RadioButtonListCellType Class

Members
Overview

RadioButtonListCellType Constructor (RadioButtonListCellType)
RadioButtonListEditor Class

Members
Overview

RadioButtonListEditor Constructor (RadioButtonListEditor)
Radius Property (ChartMapArea)
Radius Property (IChartMapArea)
RailCssClass Property
RaiseChangeOnlyOnMouseUp Property
RaisePostBackEvent Method
RaisePostDataChangedEvent Method
RaisePropertyChanged Method
RandBetweenFunction Field
RandFunction Field
range

of cells
searching
sorting

range of cells

custom name

Range setting (SelectionPolicy enum)
RangeElement<T> Class

Members
Overview

RangeElement<T> Constructor (RangeElement<T>)
RangeExpression Class

Members
Overview

RangeExpression Constructor (RangeExpression)
RangeRemoved Property
Ranges Property
ranges, cells
ranges, in expressions
ranges, model support
Rank Property (Top10FilterItem)
Rank Property (TopRankedValuesConditionalFormattingRule)
RankFunction Field
RankingColors Property (TagCloudCellType)
RankingColors Property (TagCloudRenderer)
RankingFonts Property (TagCloudCellType)
RankingFonts Property (TagCloudRenderer)
RateFunction Field
rating cell type
rating cell type
RatingAlign Property
RatingCellType Class

Members
Overview

RatingCellType Constructor (RatingCellType)
RatingDirection Property
read only
read-only mode
ReadOnly Property
ReadOnly setting (OperationMode enum)
ReadXml Method (AreaSeries)
ReadXml Method (AreaSeriesCollection)
ReadXml Method (BarSeries)
ReadXml Method (BarSeriesCollection)
ReadXml Method (CandlestickSeries)
ReadXml Method (ChartModel)
ReadXml Method (ClusteredBarSeries)
ReadXml Method (DirectionalLight)
ReadXml Method (HighLowAreaSeries)
ReadXml Method (HighLowBarSeries)
ReadXml Method (HighLowCloseSeries)
ReadXml Method (IndexAxis)
ReadXml Method (LabelArea)
ReadXml Method (LabelAreaCollection)
ReadXml Method (LegendArea)
ReadXml Method (LegendAreaCollection)
ReadXml Method (Light)
ReadXml Method (LightCollection)
ReadXml Method (LineSeries)
ReadXml Method (LineSeriesCollection)
ReadXml Method (OpenHighLowCloseSeries)
ReadXml Method (PiePlotArea)
ReadXml Method (PieSeries)
ReadXml Method (PlotArea)
ReadXml Method (PlotAreaCollection)
ReadXml Method (PointSeries)
ReadXml Method (PointSeriesCollection)
ReadXml Method (PolarAngleAxis)
ReadXml Method (PolarAreaSeries)
ReadXml Method (PolarLineSeries)
ReadXml Method (PolarPlotArea)
ReadXml Method (PolarPointSeries)
ReadXml Method (PolarRadiusAxis)
ReadXml Method (PolarRadiusAxisCollection)
ReadXml Method (PolarSeries)
ReadXml Method (PositionalLight)
ReadXml Method (RadarAreaSeries)
ReadXml Method (RadarIndexAxis)
ReadXml Method (RadarLineSeries)
ReadXml Method (RadarPlotArea)
ReadXml Method (RadarPointSeries)
ReadXml Method (RadarSeries)
ReadXml Method (RadarValueAxis)
ReadXml Method (RadarValueAxisCollection)
ReadXml Method (Series)
ReadXml Method (SeriesCollection)
ReadXml Method (StackedAreaSeries)
ReadXml Method (StackedBarSeries)
ReadXml Method (StackedLineSeries)
ReadXml Method (StackedPointSeries)
ReadXml Method (Stripe)
ReadXml Method (StripeCollection)
ReadXml Method (ValueAxis)
ReadXml Method (ValueAxisCollection)
ReadXml Method (Wall)
ReadXml Method (XYBubbleSeries)
ReadXml Method (XYLineSeries)
ReadXml Method (XYPlotArea)
ReadXml Method (XYPointSeries)
ReadXml Method (XYSeries)
ReadXml Method (XYZLineSeries)
ReadXml Method (XYZPlotArea)
ReadXml Method (XYZPointSeries)
ReadXml Method (XYZSeries)
ReadXml Method (XYZSurfaceSeries)
ReadXml Method (YPlotArea)
ReadXml Method (YSeries)
real world objects
Recalculate Method (DefaultSheetDataModel)
Recalculate Method (ICalculationSupport)
Recalculate Method (SheetView)
RecalculateAll Method (DefaultSheetDataModel)
RecalculateAll Method (ICalculationSupport)
RecalculateAll Method (SheetView)
recalculates

formulas automatically

recalculation, automatic
recalculation, automatic
recalulation, model support
ReceivedFunction Field
RecreateControl Method
rectangles, focus
rectangles, focus
recursive

formula

reference

cell
circular

Reference Property
reference style, for formulas
reference style, for formulas
reference style, for formulas
ReferenceError Property (CellRangeSegmentData)
ReferenceError Property (ExcelSparkline)
ReferenceError Property (ExcelSparklineGroup)
ReferenceError Property (ExcelSparklineSetting)
ReferenceError Property (ISheetCellRangeSupport)
ReferenceExpression Class

Members
Overview

references, cell
references, circular
references, circular
references, circular
references, cross-sheet
references, external
references, in sheet
ReferenceStyle Enumeration
ReferenceStyle Property (DefaultSheetDataModel)
ReferenceStyle Property (IExpressionSupport)
ReferenceStyle Property (SheetView)
RefValues Property
RegExpCellType Class

Members
Overview

RegExpCellType Constructor (RegExpCellType)
regional settings (Windows)
regional settings (Windows)
RegisterScriptReference Method
Regroup Method
regular expression
regular expression cell type
regular expression, cell type
RegularBoldItalic Property
RegularBoldItalicFontStyle Enumeration
relation
relation
RelationName Property
ReloadFormula Method (DefaultSparklineContainer)
ReLoadFormula Method (ExcelSparkline)
ReLoadFormula Method (ExcelSparklineGroup)
ReLoadFormula Method (ExcelSparklineSetting)
ReLoadFormula Method (ISheetCellRangeSupport)
ReloadSheetCellRangeEventHandler Delegate
ReloadSheetCellRangeFormulaEventArgs Class

Members
Overview

ReloadSheetCellRangeFormulaEventArgs Constructor (ReloadSheetCellRangeFormulaEventArgs)
Remove Method (AreaSeriesCollection)
Remove Method (BarSeriesCollection)
Remove Method (BaseSheetSpanModel)
Remove Method (BevelCollection)
Remove Method (Column)
Remove Method (Columns)
Remove Method (ConditionalFormatting)
Remove Method (ConditionalFormattingModel)
Remove Method (DefaultSheetSpanModel)
Remove Method (DefaultSparklineContainer)
Remove Method (DefaultStyleCollection)
Remove Method (DetachmentCollection)
Remove Method (DoubleCollection)
Remove Method (DoubleCollectionCollection)
Remove Method (ExcelSparklineGroup)
Remove Method (FillCollection)
Remove Method (FilterColumnDefinitionCollection)
Remove Method (FilterItemValueCollection)
Remove Method (GroupInfoCollection)
Remove Method (IMovable)
Remove Method (ISheetSpanModel)
Remove Method (LabelAreaCollection)
Remove Method (LayoutColumns)
Remove Method (LayoutRows)
Remove Method (LegendAreaCollection)
Remove Method (LightCollection)
Remove Method (LineCollection)
Remove Method (LineSeriesCollection)
Remove Method (MarkerCollection)
Remove Method (NamedStyleCollection)
Remove Method (PlotAreaCollection)
Remove Method (PointSeriesCollection)
Remove Method (PolarRadiusAxisCollection)
Remove Method (RadarValueAxisCollection)
Remove Method (Row)
Remove Method (Rows)
Remove Method (SeriesCollection)
Remove Method (SheetViewCollection)
Remove Method (SmartPrintRulesCollection)
Remove Method (SpreadChartCollection)
Remove Method (SpreadDataColumnCollection)
Remove Method (SpreadDataView)
Remove Method (StringCollection)
Remove Method (StripeCollection)
Remove Method (ValueAxisCollection)
Remove Method (WorksheetTemplate)
remove, see Delete
RemoveAllRowVisibleStatesEventHandler Method
RemoveAt Method (AreaSeriesCollection)
RemoveAt Method (BarSeriesCollection)
RemoveAt Method (BevelCollection)
RemoveAt Method (DetachmentCollection)
RemoveAt Method (DoubleCollection)
RemoveAt Method (DoubleCollectionCollection)
RemoveAt Method (FillCollection)
RemoveAt Method (FilterColumnDefinitionCollection)
RemoveAt Method (FilterItemCollection)
RemoveAt Method (GroupInfoCollection)
RemoveAt Method (LabelAreaCollection)
RemoveAt Method (LegendAreaCollection)
RemoveAt Method (LightCollection)
RemoveAt Method (LineCollection)
RemoveAt Method (LineSeriesCollection)
RemoveAt Method (MarkerCollection)
RemoveAt Method (NamedStyleCollection)
RemoveAt Method (PlotAreaCollection)
RemoveAt Method (PointSeriesCollection)
RemoveAt Method (PolarRadiusAxisCollection)
RemoveAt Method (RadarValueAxisCollection)
RemoveAt Method (SeriesCollection)
RemoveAt Method (SmartPrintRulesCollection)
RemoveAt Method (StringCollection)
RemoveAt Method (StripeCollection)
RemoveAt Method (ValueAxisCollection)
RemoveColumn Method (DefaultRowFilter)
RemoveColumn Method (DefaultSheetDataModel)
RemoveColumn Method (IRowFilter)
RemoveColumns Method (ConditionalFormattingModel)
RemoveColumns Method (DefaultSheetDataModel)
RemoveColumns Method (DefaultSparklineContainer)
RemoveColumns Method (IRangeSupport)
RemoveColumns Method (SheetView)
RemoveCustomFunction Method (DefaultSheetDataModel)
RemoveCustomFunction Method (ICustomFunctionSupport)
RemoveCustomName Method (DefaultSheetDataModel)
RemoveCustomName Method (ICustomNameSupport)
RemoveGroup Method
RemoveKeyMap, client-side
RemoveRow Method
RemoveRows Method (ConditionalFormattingModel)
RemoveRows Method (DefaultSheetDataModel)
RemoveRows Method (DefaultSparklineContainer)
RemoveRows Method (IRangeSupport)
RemoveRows Method (SheetView)
RemoveSelection Method (BaseSheetSelectionModel)
RemoveSelection Method (DefaultSheetSelectionModel)
RemoveSelection Method (ISheetSelectionModel)
RemoveSpanCell Method
RemoveSparkline Method (DefaultSparklineContainer)
RemoveSparkline Method (ISparklineContainer)
removing

columns
headers (turning off)
rows
selections
sheets

removing, cell spans
removing, columns
removing, columns
removing, columns
removing, custom functions
removing, custom names
removing, grouping
removing, rows
removing, rows
removing, rows
removing, selections
removing, selections
render cell
render cell
render cell
render cell
render cell
render cell
render cell
render cell
render cell
render cell
render cell
render cell
render cell
render cell
render cell
render cell
render cell
render cell
render cell
Render Method (FpChart)
Render Method (FpSpread)
Render Method (FpSpread)
Render Method (FpSpreadTemplateReplacement)
Render Method (SpreadChart)
Render Method (SpreadDataSource)
RenderAreaMaps Method (FpChart)
RenderAreaMaps Method (SpreadChart)
RenderChildren Method
RenderCSSClass Property
RenderEditors Property
RenderEndTag Method
renderer
Renderer Field
Renderer Property (AlternatingRow)
Renderer Property (Cell)
Renderer Property (Column)
Renderer Property (ExcelSparklineGroup)
Renderer Property (ISparklineGroup)
Renderer Property (NamedStyle)
Renderer Property (Row)
Renderer Property (StyleInfo)
renderer, client-side script
renderer,currency
RendererClientScriptUrl Property (BaseCellType)
RendererClientScriptUrl Property (BaseRenderer)
RendererClientScriptUrl Property (IRenderer)
RendererClientScriptUrl Property (TagCloudRenderer)
RendererClientScriptUrl2 Method (BaseCellType)
RendererClientScriptUrl2 Method (IRenderer2)
RendererClientScriptUrl2 Method (TagCloudCellType)
RenderErrorImage Method
renderers

cell types

renderers, base
renderers, button
renderers, default
renderers, default
renderers, interface
renderers, interface
renderers, Renderer namespace
RenderImage Method (ChartImageHttpHandler)
RenderImage Method (FpChart)
RenderImageClickClientScript Method (FpChart)
RenderImageClickClientScript Method (SpreadChart)
RenderMapArea Property
RepeatColEnd Property
RepeatColStart Property
RepeatDirection Property (RadioButtonListCellType)
RepeatDirection Property (RadioButtonListEditor)
RepeatRowEnd Property
RepeatRowStart Property
ReplaceFunction Field
replacements, template
ReplacementType Enumeration
ReplacementType Property
ReplaceStyle Property
ReptFunction Field
RequestRowVisibleStates Event
RequestRowVisibleStatesEventArgs Class

Members
Overview

RequestRowVisibleStatesEventArgs Constructor (RequestRowVisibleStatesEventArgs)
RequestRowVisibleStatesEventHandler Delegate
reserved words

CallBack commands

Reset Method (Appearance)
Reset Method (Border)
Reset Method (CommandBarInfo)
Reset Method (DefaultSkins)
Reset Method (FpSpread)
Reset Method (GroupInfo)
Reset Method (HierBarInfo)
Reset Method (NamedStyle)
Reset Method (PagerInfo)
Reset Method (PreviewRowInfo)
Reset Method (SheetView)
Reset Method (StyleInfo)
Reset Method (TabInfo)
Reset Method (TitleInfo)
Reset Method (TouchInfo)
reset, options
ResetAll Method (Appearance)
ResetAll Method (Border)
ResetBackColor Method (Cell)
ResetBackColor Method (Column)
ResetBackColor Method (Row)
ResetBackColor Method (StyleInfo)
ResetBackground Method (Cell)
ResetBackground Method (Column)
ResetBackground Method (Row)
ResetBackground Method (StyleInfo)
ResetBorder Method (Cell)
ResetBorder Method (Column)
ResetBorder Method (Row)
ResetBorder Method (StyleInfo)
ResetCanFocus Method (AlternatingRow)
ResetCanFocus Method (Cell)
ResetCanFocus Method (Column)
ResetCanFocus Method (Row)
ResetCanFocus Method (StyleInfo)
ResetCellType Method (Cell)
ResetCellType Method (Column)
ResetCellType Method (Row)
ResetCellType Method (StyleInfo)
ResetEditor Method
ResetEncodeValue Method
ResetFilter Method (DefaultRowFilter)
ResetFilter Method (IRowFilter)
ResetFont Method (Cell)
ResetFont Method (Column)
ResetFont Method (Row)
ResetFont Method (StyleInfo)
ResetForeColor Method (Cell)
ResetForeColor Method (Column)
ResetForeColor Method (Row)
ResetForeColor Method (StyleInfo)
ResetFormatter Method
ResetFormula Method
ResetHeight Method
ResetHorizontalAlignment Method (Cell)
ResetHorizontalAlignment Method (Column)
ResetHorizontalAlignment Method (Row)
ResetHorizontalAlignment Method (StyleInfo)
ResetIfNoFilteredRow Property (FpSpread)
ResetIfNoFilteredRow Property (IRowFilterSlim)
ResetImeMode Method (Cell)
ResetImeMode Method (Column)
ResetImeMode Method (Row)
ResetImeMode Method (StyleInfo)
ResetLocked Method (Cell)
ResetLocked Method (Column)
ResetLocked Method (Row)
ResetLocked Method (StyleInfo)
ResetMargin Method (Cell)
ResetMargin Method (Column)
ResetMargin Method (Row)
ResetMargin Method (StyleInfo)
ResetName Method
ResetNote Method
ResetOption Enumeration
ResetOption Property (BestFitColumnRule)
ResetOption Property (LandscapeRule)
ResetOption Property (ScaleRule)
ResetOption Property (SmartPaperRule)
ResetOption Property (SmartPrintRule)
ResetParent Method
ResetProperty Method (BaseSheetAxisModel)
ResetProperty Method (DefaultSheetAxisModel)
ResetProperty Method (ISheetAxisModel)
ResetRenderer Method
resets, filters
ResetTabStop Method (Cell)
ResetTabStop Method (Column)
ResetTabStop Method (Row)
ResetTabStop Method (StyleInfo)
ResetTag Method
ResetText Method
resetting, default skin
resetting, default style
resetting, FarPoint Spread component
resetting, filter settings
resetting, filter settings
resetting, styles
ResetValue Method (Cell)
ResetValue Method (DoubleCollectionPropertyDescriptor)
ResetValue Method (SpreadDataColumnPropertyDescriptor)
ResetVerticalAlignment Method (Cell)
ResetVerticalAlignment Method (Column)
ResetVerticalAlignment Method (Row)
ResetVerticalAlignment Method (StyleInfo)
ResetViewColumnIndexes Method
ResetViewRowIndexes Method
ResetWidth Method
Resizable Field
Resizable Property (Column)
Resizable Property (Row)
resize
resizing

rows or columns

resizing, header
resizing, row or column
resizing, row or column
resizing, row or column
Restricted setting (MergePolicy enum)
Restricted setting (MergePolicy enum)
Restricted setting (MergePolicy enum)
Restricted setting (MergePolicy enum)
Restricted setting (MergePolicy enum)
Result Property
Resume Method
ResumeFormulaParsing Method (DefaultSparklineContainer)
ResumeFormulaParsing Method (ISuspendFormulaParsing)
ResumeLayout client-side
ResumeListeningDataModel Method
RetainSelectionBlock Property
retrieving data, optimizing
retrieving data, optimizing
returning

data

Reverse Property (IndexAxis)
Reverse Property (PolarAngleAxis)
Reverse Property (PolarRadiusAxis)
Reverse Property (RadarIndexAxis)
Reverse Property (RadarValueAxis)
Reverse Property (ValueAxis)
Reversed Property
RGB value
right margin
Right Property (Inset)
Right Property (PaddingF)
Right Property (PrintMargin)
Right setting (ListAlignment enum)
RightFunction Field
RightToLeft Enumeration
RightToLeft Property
RomanFunction Field
rotation
Rotation Property
RoundDownFunction Field
RoundFunction Field
RoundUpFunction Field
Row Class

Members
Overview

row edit templates
row filtering
row filtering
row filtering
row filtering

overview

row filtering, combo box
row header
row header labels
row headers

automatic text
content
custom text
default style
displaying
editor
editor
hiding
multiple
multiple columns
spans
text
text

row headers, labels
row headers, labels
row headers, labels
row headers, visible
row headers, visible
row headers, width
row headers, width
row height
row height

importing
importing

row label
row label
row label
row mode
row preview

overview

Row Property (AggregateArgs)
Row Property (BaseSparkline)
Row Property (CalcArray)
Row Property (CalcReference)
Row Property (Cell)
Row Property (CellExpression)
Row Property (CellRange)
Row Property (ConditionalFormatInfo)
Row Property (ConditionalFormattingModelEventArgs)
Row Property (ExcelSparkline)
Row Property (ExcelWarning)
Row Property (ExternalCellExpression)
Row Property (ExternalRangeExpression)
Row Property (ExternalReferenceExpression)
Row Property (ISparkline)
Row Property (MapperInfo)
Row Property (PrintEventArgs)
Row Property (RangeExpression)
Row Property (ReferenceExpression)
Row Property (RequestRowVisibleStatesEventArgs)
Row Property (SheetDataModelEventArgs)
Row Property (SheetSelectionModelEventArgs)
Row Property (SheetStyleModelEventArgs)
row template

editor
editor
overview

row templates
row top
RowAndColumnHeaders setting (ExcelOpenFlags enum)
RowAxisModel Property
RowCount Property (AggregateArgs)
RowCount Property (BaseSheetDataModel)
RowCount Property (CalcArray)
RowCount Property (CalcReference)
RowCount Property (CellExpression)
RowCount Property (CellRange)
RowCount Property (ColumnFooter)
RowCount Property (ColumnHeader)
RowCount Property (ConditionalFormattingModelEventArgs)
RowCount Property (DefaultSheetDataModel)
RowCount Property (DefaultSheetStyleModel)
RowCount Property (ExternalCellExpression)
RowCount Property (ExternalRangeExpression)
RowCount Property (ExternalReferenceExpression)
RowCount Property (GroupDataModel)
RowCount Property (ISheetDataModel)
RowCount Property (LayoutTemplate)
RowCount Property (MapperInfo)
RowCount Property (RangeExpression)
RowCount Property (ReferenceExpression)
RowCount Property (RequestRowVisibleStatesEventArgs)
RowCount Property (SheetCorner)
RowCount Property (SheetDataModelEventArgs)
RowCount Property (SheetSelectionModelEventArgs)
RowCount Property (SheetStyleModelEventArgs)
RowCount Property (SheetView)
RowEditTemplate Property (FpSpread)
RowEditTemplate Property (SheetView)
RowEditTemplateContainer Class

Members
Overview

RowEditTemplateContainer Constructor (RowEditTemplateContainer)
RowEnd Property
rowField Field
RowFilter Property
RowFunction Field
RowHeader Class

Members
Overview

RowHeader Property (FpSpread)
RowHeader Property (SheetView)
RowHeaderAutoText Property
RowHeaderAutoTextIndex Property
RowHeaderBackground Property
RowHeaderClick command (client-side)
RowHeaderClick Event
RowHeaderColumnAxisModel Property
RowHeaderDataModel Property
RowHeaderDefault Field
RowHeaders setting (ExcelOpenFlags enum)
RowHeadersCustomOnly setting (IncludeHeaders enum)
RowHeaderSpanModel Property
RowHeaderStyleModel Property
RowHeaderVisible Property
RowHeaderWidth Property
RowIndex Property
RowMode setting (OperationMode enum)
RowRelative Property (CellExpression)
RowRelative Property (ExternalCellExpression)
RowRelative Property (ExternalRangeExpression)
RowRelative Property (ExternalReferenceExpression)
RowRelative Property (RangeExpression)
RowRelative Property (ReferenceExpression)
rows
rows

appearance
exporting to Excel file
importing from Excel file
adding
adding unbound
alternating styles
default number
editor
editor
expandable
exporting to Excel file
filtering
frozen
frozen
grid lines
grouping
grouping
grouping
height
hiding
importing from Excel file
number displayed
preview row
removing
resizing
searching
setting number of
setting top
shortcut object
shortcut object
sorting
sorting

Rows Class

Members
Overview

Rows client-side
Rows Property (ColumnFooter)
Rows Property (ColumnHeader)
Rows Property (FpSpread)
Rows Property (Group)
Rows Property (ListBoxCellType)
Rows Property (ListBoxEditor)
Rows Property (RowHeader)
Rows Property (SheetCorner)
Rows Property (SheetView)
rows, active
rows, adding
rows, adding
rows, adding
rows, adding to data source
rows, adding to data source
rows, adding unbound
rows, adding unbound
rows, alternating
rows, alternating
rows, axis model
rows, background color
rows, count
rows, counting non-empty
rows, default column
rows, default filtering
rows, default header style
rows, default header style
rows, default height
rows, default row
rows, deleting
rows, editable
rows, expanding
rows, filtering
rows, filtering
rows, filtering styles
rows, frozen
rows, header
rows, header labels
rows, header labels
rows, headers
rows, inserting
rows, list box items displayed
rows, message row
rows, non-empty
rows, number to display
rows, parent
rows, parent
rows, parent row
rows, quantity
rows, removing
rows, removing
rows, removing
rows, sizable by user
rows, sizable by user
rows, sizable by user
rows, sorting
rows, sorting
rows, starting number
rows, top
rows, unbound
Rows.DefaultRow Class

Members
Overview

RowsAdded setting (SheetDataModelEventType enum)
RowsFunction Field
RowSpan Property (Cell)
RowSpan Property (LayoutCell)
RowsRemoved setting (SheetDataModelEventType enum)
RowStart Property
RowTemplate Property
RowTemplateLayoutMode setting (LayoutModeType enum)
RowVisibleStates Property
RSqFunction Field
rule

average
color scale
data bar
highlight
icon set
top ranked

RulerLine Property (IndexAxis)
RulerLine Property (PolarAngleAxis)
RulerLine Property (PolarRadiusAxis)
RulerLine Property (RadarIndexAxis)
RulerLine Property (RadarValueAxis)
RulerLine Property (ValueAxis)
RulerOffset Property (IndexAxis)
RulerOffset Property (PolarAngleAxis)
RulerOffset Property (PolarRadiusAxis)
RulerOffset Property (RadarIndexAxis)
RulerOffset Property (RadarValueAxis)
RulerOffset Property (ValueAxis)
RulerVisible Property (IndexAxis)
RulerVisible Property (PolarAngleAxis)
RulerVisible Property (PolarRadiusAxis)
RulerVisible Property (RadarIndexAxis)
RulerVisible Property (RadarValueAxis)
RulerVisible Property (ValueAxis)
rules
Rules Property
SameAppearance Method
save
Save Method (FpSpread)
Save Method (SheetSkin)
Save Method (SheetView)
SaveAlternatingRowStyles setting (ExcelSaveFlags enum)
SaveAsFiltered setting (ExcelSaveFlags enum)
SaveAsViewed setting (ExcelSaveFlags enum)
SaveBothCustomRowAndColumnHeaders setting (ExcelSaveFlags enum)
SaveChanges method
SaveChanges method
SaveControlState Method
SaveCustomColumnHeaders setting (ExcelSaveFlags enum)
SaveCustomRowHeaders setting (ExcelSaveFlags enum)
SaveExcel Method
SaveExcelToResponse Method (FpSpread)
SaveExcelToResponse Method (FpSpread)
SaveHtml Method
SaveObject Method
SaveOrLoadSheetState Event
SavePdf Method
SavePdfToResponse Method (FpSpread)
SavePdfToResponse Method (FpSpread)
SaveTextFile Method
SaveTextFileRange Method
SaveToTemplate Method
SaveViewState Method (ContextMenuCollection)
SaveViewState Method (FpChart)
SaveViewState Method (FpSpread)
SaveViewState Method (FpSpread)
SaveViewState Method (MapArea)
SaveViewState Method (SheetView)
SaveViewState Method (StateList<T>)
SaveViewState Method (TouchStripCollection)
SaveViewStateToSession Property
SaveXml Method
saving

to pdf file
to text file
data to files
files
to Excel files
to pdf files
to Spread XML files
to text files

saving changes to server
saving changes to server
saving to XML, Serializer
saving to XML, Spread
saving, Excel files
saving, Spread XML files
saving, text
saving, text
saving, to Excel files
saving, to Excel to Response
saving, to PDF
saving, to PDF to Response
saving, view state
saving, XML
ScaleRule Class

Members
Overview

ScaleRule Constructor (ScaleRule)
scripting

browser support
client-side
client-side
enabling on server
formatting example
invalid entry handling
members
other links
typical uses
validation example

scroll bars
scroll bars
scroll bars

importing from Excel
colors
displaying
importing from Excel
policy¶

scroll bars, arrow color
scroll bars, base color
scroll bars, colors
scroll bars, colors
scroll bars, colors
scroll bars, colors
scroll bars, colors
scroll bars, colors
scroll bars, colors
scroll bars, colors
scroll bars, displaying
scroll bars, face color
scroll bars, highlight color
scroll bars, light color
scroll bars, shadow color
scroll bars, shadow color
scroll bars, track color
ScrollBar3DLightColor Property
ScrollBarArrowColor Property
ScrollBarBaseColor Property
ScrollBarDarkShadowColor Property
ScrollBarFaceColor Property
ScrollBarHighlightColor Property
ScrollBarPolicy Enumeration
ScrollBarShadowColor Property
ScrollBarTrackColor Property
ScrollIncrement Property
scrolling, client side
scrolling, tab increment
ScrollingContentColumns Property
ScrollingContentHiddenDelay Property
ScrollingContentMaxHeight Property
ScrollingContentVisible Property
ScrollTo client-side
Search Method
SearchFoundFlags Enumeration
SearchFunction Field
SearchHeaders Method
searching
searching
searching, data area
searching, found flags
searching, header cells
searching, methods
searching, methods
SecondCondition Property
SecondFormula Property
SecondFunction Field
SecondValue Property
SegmentDataChangedEventArgs Class

Members
Overview

SegmentDataChangedEventArgs Constructor (SegmentDataChangedEventArgs)
SegmentDataChangedEventHandler Delegate
SegmentDataType Enumeration
Select command (client-side)
SelectedBackColor Property (ListBoxCellType)
SelectedBackColor Property (ListBoxRenderer)
SelectedBackgroundImageUrl Property
SelectedCssClass Property
SelectedForeColor Property (ListBoxCellType)
SelectedForeColor Property (ListBoxRenderer)
SelectedItem Property (MenuItemClickEventArgs)
SelectedItem Property (TouchStripItemClickEventArgs)
selecting, single-row mode
selection

effect of EnableClientScript

Selection model
Selection model
selection model, base
selection model, default
SelectionBackColor Property (SheetSkin)
SelectionBackColor Property (SheetView)
SelectionBackColorStyle Property
SelectionBackColorStyles Enumeration
SelectionBlockOptions Enumeration
SelectionBlockOptions Property
SelectionBorder Property
SelectionForeColor Property (SheetSkin)
SelectionForeColor Property (SheetView)
SelectionGripperBackColor Property
SelectionGripperLineColor Property
SelectionGripperThickness Property
SelectionModel Property
SelectionPolicy Enumeration
SelectionPolicy Property (BaseSheetSelectionModel)
SelectionPolicy Property (DefaultSheetSelectionModel)
SelectionPolicy Property (ISheetSelectionModel)
SelectionPolicy Property (SheetView)
selections

adding
appearance
background
border
clearing
customizing
operation mode
Spread Designer

selections, adding
selections, adding
selections, background color
selections, border
selections, cell in
selections, cell in
selections, cell in
selections, cell in
selections, clearing
selections, deleting
selections, deleting
selections, is selected
selections, is selected
selections, mode
selections, model
selections, model
selections, querying
selections, ranges
selections, removing
selections, removing
selections, setting
selections, setting
selections, text color
selections,clearing
SelectMethod
SelectMethod Property (FpSpread)
SelectMethod Property (SheetView)
SelectView command (client-side)
separator

currency

Seperator Property
SeResize setting (CursorType enum)
serialization
serialization, model support
serialization, of data
serialization, of presentation
serialization, of settings
serialization, of styles
serialization, Serializer
serialization, Spread
Serialize Method (Appearance)
Serialize Method (Background)
Serialize Method (BaseDropDownCellType)
Serialize Method (BaseFilterItem)
Serialize Method (BaseSparkline)
Serialize Method (Border)
Serialize Method (ButtonCellType)
Serialize Method (CalendarDropDownStyleInfo)
Serialize Method (CheckBoxCellType)
Serialize Method (ColorFilterItem)
Serialize Method (ColumnSparklineRenderer)
Serialize Method (ComboBoxCellType)
Serialize Method (CommandBarInfo)
Serialize Method (CurrencyCellType)
Serialize Method (CustomFilterItem)
Serialize Method (DateTimeCellType)
Serialize Method (DefaultRowFilter)
Serialize Method (DefaultSheetAxisModel)
Serialize Method (DefaultSheetDataModel)
Serialize Method (DefaultSheetSelectionModel)
Serialize Method (DefaultSheetSpanModel)
Serialize Method (DefaultSheetStyleModel)
Serialize Method (DefaultSparklineContainer)
Serialize Method (DoubleCellType)
Serialize Method (DoubleCollectionCollectionCodeDomSerializer)
Serialize Method (DynamicFilterItem)
Serialize Method (ExcelBaseSparkLineRenderer)
Serialize Method (ExcelSparkline)
Serialize Method (ExcelSparklineGroup)
Serialize Method (ExcelSparklineSetting)
Serialize Method (FilterCondition)
Serialize Method (FilterItemCollection)
Serialize Method (FilterItemValue)
Serialize Method (FilterItemValueCollection)
Serialize Method (GeneralCellType)
Serialize Method (GroupDataModel)
Serialize Method (GroupInfo)
Serialize Method (GroupInfoCollection)
Serialize Method (HideRowFilter)
Serialize Method (HierBarInfo)
Serialize Method (HyperLinkCellType)
Serialize Method (IconFilterItem)
Serialize Method (ImageCellType)
Serialize Method (Inset)
Serialize Method (IntegerCellType)
Serialize Method (ISerializeData)
Serialize Method (ISerializePresentation)
Serialize Method (ISerializeSettings)
Serialize Method (ISerializeStyles)
Serialize Method (ISerializeSupport)
Serialize Method (LabelCellType)
Serialize Method (LayoutTemplate)
Serialize Method (LineSparklineRenderer)
Serialize Method (ListBoxCellType)
Serialize Method (MaskedEditValidator)
Serialize Method (MultiColumnComboBoxCellType)
Serialize Method (MultiValuesFilterItem)
Serialize Method (NamedStyle)
Serialize Method (NamedStyleCollection)
Serialize Method (NullItemBevelCollectionCodeDomSerializer)
Serialize Method (NullItemFillCollectionCodeDomSerializer)
Serialize Method (NullItemLineCollectionCodeDomSerializer)
Serialize Method (NullItemMarkerCollectionCodeDomSerializer)
Serialize Method (NullItemStringCollectionCodeDomSerializer)
Serialize Method (PagerInfo)
Serialize Method (PercentCellType)
Serialize Method (PreviewRowInfo)
Serialize Method (RadioButtonListCellType)
Serialize Method (RegExpCellType)
Serialize Method (SheetSkin)
Serialize Method (StyleInfo)
Serialize Method (StyleRowFilter)
Serialize Method (TabInfo)
Serialize Method (TagCloudCellType)
Serialize Method (TextCellType)
Serialize Method (TitleInfo)
Serialize Method (Top10FilterItem)
Serialize Method (TouchInfo)
Serialize Method (WinLossSparklineRenderer)
Serialize2 Method (Border)
Serialize2 Method (ButtonCellType)
Serialize2 Method (CheckBoxCellType)
Serialize2 Method (ComboBoxCellType)
Serialize2 Method (DefaultSheetStyleModel)
Serialize2 Method (GeneralCellType)
Serialize2 Method (HyperLinkCellType)
Serialize2 Method (ImageCellType)
Serialize2 Method (ISerializeSupport2)
Serialize2 Method (LabelCellType)
Serialize2 Method (ListBoxCellType)
Serialize2 Method (RadioButtonListCellType)
Serialize2 Method (StyleInfo)
Serialize2 Method (TagCloudCellType)
Serialize2 Method (TextCellType)
SerializeByteArray Method
SerializeColor Method
SerializeColorValue Method
SerializeData Method
SerializeDateTimeFormatInfo Method
SerializeDateValue Method
SerializeEditor Method (DateCalendarCellType)
SerializeEditor Method (MutuallyExclusiveCheckBoxCellType)
SerializeEnum Method
SerializeExtenders Method
SerializeFont Method
SerializeFontValue Method
SerializeImage Method
SerializeIntArray Method
SerializeNumberFormatInfo Method
SerializeObject Method
SerializePointFArray Method
SerializePresentation Method
Serializer Class

Members
Overview

Serializer Constructor (Serializer)
serializer, Spread
SerializeSettings Method
SerializeString Method
SerializeStringArray Method
SerializeStyles Method
serializing, Serializer
serializing, styles
Series Class

Members
Overview

Series Property (ClusteredBarSeries)
Series Property (ICompositeSeries)
Series Property (PlotArea)
Series Property (SeriesHitTest)
Series Property (SeriesInfo)
Series Property (StackedAreaSeries)
Series Property (StackedBarSeries)
Series Property (StackedLineSeries)
Series Property (StackedPointSeries)
SeriesCollection Class

Members
Overview

SeriesColor Property
SeriesDataField Class

Members
Overview

SeriesDataField Constructor (SeriesDataField)
SeriesDataFieldCollection Class

Members
Overview

SeriesDataFieldCollection Constructor (SeriesDataFieldCollection)
SeriesGroup Property
SeriesGroupIndex Property
SeriesHit Property
SeriesHitTest Class

Members
Overview

SeriesHitTest Constructor (SeriesHitTest)
SeriesIndex Property (MapAreaInfo)
SeriesIndex Property (SeriesInfo)
SeriesInfo Class

Members
Overview

SeriesInfo Constructor (SeriesInfo)
SeriesName Property (IIndicator)
SeriesName Property (IndicatorChangedEventArgs)
SeriesName Property (Series)
SeriesNameDataField Property
SeriesNameDataSource Property
SeriesNameFormula Property
SeriesSumFunction Field
server

enabling client script
posting back
saving updates to

ServiceDownMethod Property
ServiceDownPath Property
ServiceMethod Property
ServicePath Property
ServiceUpMethod Property
ServiceUpPath Property
session state
SetActiveCell, client-side
SetActiveChart, client-side
SetAggregationType Method (DefaultSheetDataModel)
SetAggregationType Method (GroupDataModel)
SetAggregationType Method (IAggregationSupport)
SetArray Method (DefaultSheetDataModel)
SetArray Method (DefaultSheetStyleModel)
SetArray Method (IArraySupport)
SetAutoFilterIndex Method (BaseSheetAxisModel)
SetAutoFilterIndex Method (DefaultSheetAxisModel)
SetAutoFilterIndex Method (IAutoFilterIndexSupport)
SetCellValue Method (DefaultSpreadDataViewDataFormatter)
SetCellValue Method (ISpreadDataViewDataFormatter)
SetChildVisible Method
SetClip Method (ColumnFooter)
SetClip Method (ColumnHeader)
SetClip Method (RowHeader)
SetClip Method (SheetView)
SetClipValue Method (ColumnFooter)
SetClipValue Method (ColumnHeader)
SetClipValue Method (RowHeader)
SetClipValue Method (SheetView)
SetColumnLabel Method
SetColumnMerge Method
SetColumnSizeable Method
SetColumnSortIndicator Method
SetColumnVisible Method
SetColumnWidth Method
SetColWidth, client-side
SetConditionalFormat Method (IConditionalFormatSupport)
SetConditionalFormat Method (IConditionalFormatSupport2)
SetConditionalFormatting Method
SetDirectAltRowInfo Method (BaseSheetStyleModel)
SetDirectAltRowInfo Method (DefaultSheetStyleModel)
SetDirectAltRowInfo Method (ISheetStyleModel)
SetDirectAltRowName Method (DefaultSheetStyleModel)
SetDirectAltRowName Method (INamedStyleSupport)
SetDirectInfo Method (BaseSheetStyleModel)
SetDirectInfo Method (DefaultSheetStyleModel)
SetDirectInfo Method (ISheetStyleModel)
SetDirectName Method (DefaultSheetStyleModel)
SetDirectName Method (INamedStyleSupport)
SetDirty Method
SetExpression Method (DefaultSheetDataModel)
SetExpression Method (IExpressionSupport)
SetExpression Method (SheetView)
SetFilteredRowFormat Method
SetFlag Method (Appearance)
SetFlag Method (Border)
SetFlag Method (StyleInfo)
SetFormatString Method
SetFormula client-side
SetFormula Method (DefaultSheetDataModel)
SetFormula Method (IExpressionConsumer)
SetFormula Method (IExpressionSupport)
SetFormula Method (SheetView)
SetFormulaConditionalFormat Method
SetHiddenValue, client-side
SetImage Method
SetLocked

client-side

SetMergePolicy Method (BaseSheetAxisModel)
SetMergePolicy Method (DefaultSheetAxisModel)
SetMergePolicy Method (ISheetAxisModel)
SetModelDataColumn Method (DefaultSheetDataModel)
SetModelDataColumn Method (IDataSourceSupport)
SetModelDataColumn Method (SheetView)
SetNote Method (BaseSheetDataModel)
SetNote Method (DefaultSheetDataModel)
SetNote Method (GroupDataModel)
SetNote Method (ISheetDataModel)
SetNote Method (SheetView)
SetObjectXml Method
SetPageBreak Method (BaseSheetAxisModel)
SetPageBreak Method (DefaultSheetAxisModel)
SetPageBreak Method (IPageBreakSupport)
SetParseFormat Method (DefaultSheetStyleModel)
SetParseFormat Method (GeneralCellType)
SetParseFormat Method (IParseFormatSupport)
SetParseFormat Method (IParseFormatSupport2)
SetResizable Method (BaseSheetAxisModel)
SetResizable Method (DefaultSheetAxisModel)
SetResizable Method (ISheetAxisModel)
SetRowExpandable Method
SetRowHeight Method
SetRowLabel Method
SetRowMerge Method
SetRowSizeable Method
SetRowVisible Method
SetSelectedRange client-side
SetSelection Method (BaseSheetSelectionModel)
SetSelection Method (DefaultSheetSelectionModel)
SetSelection Method (ISheetSelectionModel)
SetSize Method (BaseSheetAxisModel)
SetSize Method (DefaultSheetAxisModel)
SetSize Method (ISheetAxisModel)
SetSortIndicator Method (BaseSheetAxisModel)
SetSortIndicator Method (DefaultSheetAxisModel)
SetSortIndicator Method (ISheetAxisModel)
SetStyleInfo Method
SetTabIndex Method (BaseCellType)
SetTabIndex Method (BaseDropDownCellType)
SetTag Method (BaseSheetAxisModel)
SetTag Method (BaseSheetDataModel)
SetTag Method (DefaultSheetAxisModel)
SetTag Method (DefaultSheetDataModel)
SetTag Method (GroupDataModel)
SetTag Method (ISheetAxisModel)
SetTag Method (ISheetDataModel)
SetTag Method (SheetView)
SetText Method
setting

active cell
active sheet
alternating rows
button type
cell background
cell reference style
cell type
cell types
column width
min, max for currency
row height

setting cell type

button
check box
combo box
date time
double
general
hyperlink
image
integer
label
list box
percent
radio button
regular expression
text

Setting Property (ExcelSparklineGroup)
Setting Property (ISparklineGroup)
Setting Property (Sparkline)
setting, active column
setting, active row
setting, active skin
setting, button type
setting, page size
setting, rows to display
settings

appearance
composite
regional
scroll bars

SetValue client-side
SetValue method

scripting example

SetValue Method (BaseSheetDataModel)
SetValue Method (DefaultSheetDataModel)
SetValue Method (DoubleCollectionPropertyDescriptor)
SetValue Method (GroupDataModel)
SetValue Method (ISheetDataModel)
SetValue Method (SheetView)
SetValue Method (SpreadDataColumnPropertyDescriptor)
SetVisible Method (BaseSheetAxisModel)
SetVisible Method (DefaultSheetAxisModel)
SetVisible Method (ISheetAxisModel)
shadow color, scroll bars
shadow color, scroll bars
shadows, scroll bars
shadows, scroll bars
Shape Property (BuiltinMarker)
Shape Property (MapArea)
shapes
SharePoint
SharingViolation setting (ExcelExceptionCode enum)
sheet corner
sheet corner
sheet corner

customizing
styles

sheet corner, style
sheet corner, style
sheet models
sheet name tabs
sheet name tabs
sheet name tabs
sheet name tabs
sheet name tabs
sheet name tabs
sheet name tabs
sheet name tabs
sheet name tabs
sheet name tabs

default names

sheet name tabs, active
sheet name tabs, border color
sheet names
sheet names, Excel files
sheet names, tabs
sheet names, tabs
sheet names, tabs
sheet names, tabs
sheet names, tabs
sheet names, tabs
sheet names, tabs
sheet names, tabs
sheet names, tabs
Sheet Property (ExcelWarning)
Sheet Property (PreviewRowTemplateContainer)
Sheet Property (RowEditTemplateContainer)
sheet skins
sheet skins
sheet skins
sheet skins

editor
editor
overview

sheet skins, default
sheet view
SheetAxisModelChangingEventArgs Class

Members
Overview

SheetAxisModelChangingEventArgs Constructor (SheetAxisModelChangingEventArgs)
SheetAxisModelChangingEventHandler Delegate
SheetAxisModelEventArgs Class

Members
Overview

SheetAxisModelEventArgs Constructor (SheetAxisModelEventArgs)
SheetAxisModelEventHandler Delegate
SheetAxisModelEventType Enumeration
SheetAxisOrientation Enumeration
SheetAxisProperty Class

Members
Overview

SheetAxisProperty Constructor (SheetAxisProperty)
SheetCellRange Class

Members
Overview

SheetCellRange Constructor (SheetCellRange)
SheetCellRangeCollection Class

Members
Overview

SheetCellRangeCollection Constructor (SheetCellRangeCollection)
SheetCellRangeContainer Property
sheetcorner
SheetCorner Class

Members
Overview

SheetCorner Property (FpSpread)
SheetCorner Property (SheetView)
SheetCornerBackground Property
SheetCornerColumnAxisModel Property
SheetCornerDataModel Property
SheetCornerRowAxisModel Property
SheetCornerSpanModel Property
SheetCornerStyle Property
SheetCornerStyleModel Property
SheetCornerStyleName Property
SheetDataModelEventArgs Class

Members
Overview

SheetDataModelEventArgs Constructor (SheetDataModelEventArgs)
SheetDataModelEventHandler Delegate
SheetDataModelEventType Enumeration
SheetGroupDataModelEventArgs Class

Members
Overview

SheetGroupDataModelEventArgs Constructor (SheetGroupDataModelEventArgs)
SheetIndex Property (PrintEventArgs)
SheetIndex Property (PrintPDFEventArgs)
SheetName Property (CellRangeSegmentData)
SheetName Property (SheetCellRange)
SheetName Property (SheetView)
SheetName Property (SpreadDataSource)
SheetRectangle Property
SheetRemoved Property
sheets

exporting to Excel file
importing from Excel file
active sheet
adding data
binding to data source
child views
corner (See sheet corner)
default sheet names
editor
editor
exporting to Excel file
grid lines
hiding
importing from Excel file
multiple
names
number of rows displayed
printing
removing
shortcut object
skins
skins
subtitle
templates
templates
title

Sheets Property
sheets, active
sheets, active
sheets, axis model
sheets, axis model
sheets, axis model
sheets, background color
sheets, background color
sheets, corner
sheets, corner
sheets, corner
sheets, corner
sheets, corner
sheets, data model
sheets, data model
sheets, data model
sheets, displaying
sheets, formulas
sheets, formulas
sheets, formulas
sheets, formulas
sheets, grid lines
sheets, grid lines
sheets, hiding
sheets, names
sheets, names
sheets, names
sheets, parent
sheets, selection model
sheets, selection model
sheets, selection model
sheets, skin (active)
sheets, skins
sheets, span model
sheets, span model
sheets, span model
sheets, style model
sheets, style model
sheets, style model
sheets, styles
SheetSelectionModelEventArgs Class

Members
Overview

SheetSelectionModelEventArgs Constructor (SheetSelectionModelEventArgs)
SheetSelectionModelEventHandler Delegate
SheetSkin Class

Members
Overview

SheetSkin Constructor (SheetSkin)
SheetSkin editor
SheetSkin editor
SheetStyleModelEventArgs Class

Members
Overview

SheetStyleModelEventArgs Constructor (SheetStyleModelEventArgs)
SheetStyleModelEventHandler Delegate
SheetStyleModelEventType Enumeration
SheetStyleProperty Class

Members
Overview

SheetStyleProperty Constructor (SheetStyleProperty)
SheetView Class

Members
Overview

SheetView Collection editor
SheetView Collection editor
SheetView Constructor (SheetView)
SheetView object
SheetView object
SheetView Property (BaseFilterItem)
SheetView Property (CellRangeSegmentData)
SheetView Property (ColorFilterItem)
SheetView Property (CreateChildViewEventArgs)
SheetView Property (CustomFilterItem)
SheetView Property (DefaultRowFilter)
SheetView Property (DynamicFilterItem)
SheetView Property (IConditionalFormattingModel)
SheetView Property (IconFilterItem)
SheetView Property (IFilterItem)
SheetView Property (IRowFilter)
SheetView Property (SheetCellRange)
SheetView Property (SheetViewStateEventArgs)
SheetView Property (SpreadCommandEventArgs)
SheetView Property (SpreadDataSource)
SheetView Property (SpreadDataView)
SheetView Property (Top10FilterItem)
SheetView.LayoutModeType Enumeration
SheetViewCollection Class

Members
Overview

SheetViewStateEventArgs Class

Members
Overview

SheetViewStateEventArgs Constructor (SheetViewStateEventArgs)
SheetViewStateEventHandler Delegate
shortcut objects

cell
cell
column
column
header
header
row
row
sheet

shortName Field
ShouldSerializeAxisColor Method
ShouldSerializeDateAxis Method
ShouldSerializeDisplayEmptyCellsAs Method
ShouldSerializeDisplayHidden Method
ShouldSerializeDisplayXAxis Method
ShouldSerializeFirstMarkerColor Method
ShouldSerializeFormula Method
ShouldSerializeHighMarkerColor Method
ShouldSerializeLastMarkerColor Method
ShouldSerializeLineWeight Method
ShouldSerializeLowMarkerColor Method
ShouldSerializeManualMax Method
ShouldSerializeManualMin Method
ShouldSerializeMarkersColor Method
ShouldSerializeMaxAxisType Method
ShouldSerializeMinAxisType Method
ShouldSerializeNegativeColor Method
ShouldSerializePrintInfo Method
ShouldSerializeRightToLeft Method
ShouldSerializeSeriesColor Method
ShouldSerializeShowFirst Method
ShouldSerializeShowHigh Method
ShouldSerializeShowLast Method
ShouldSerializeShowLow Method
ShouldSerializeShowMarkers Method
ShouldSerializeShowNegative Method
ShouldSerializeValue Method (DoubleCollectionPropertyDescriptor)
ShouldSerializeValue Method (SpreadDataColumnPropertyDescriptor)
Show setting (PrintHeader enum)
ShowBorder Property (DatabarConditionalFormattingRule)
ShowBorder Property (PrintInfo)
ShowButton Property (ComboBoxCellType)
ShowButton Property (MultiColumnComboBoxCellType)
ShowButton Property (MultiColumnEditor)
ShowColor Property
ShowColumnFooter Property (PrintInfo)
ShowColumnFooter Property (SheetSkin)
ShowColumnFooterEachPage Property
ShowColumnHeader Property (PrintInfo)
ShowColumnHeader Property (SheetSkin)
ShowConditionalFormatOnly Property (IPrePaintTextConditionalFormattingRule)
ShowConditionalFormatOnly Property (PrePaintTextConditionalFormattingRule)
ShowDefaultContextMenu Property
ShowEditor Property (IEnhancedRenderer)
ShowEditor Property (TextCellType)
ShowEllipsis Property (ButtonCellType)
ShowEllipsis Property (ButtonRenderer)
ShowEllipsis Property (ComboBoxCellType)
ShowEllipsis Property (HyperLinkCellType)
ShowEllipsis Property (HyperLinkRenderer)
ShowEllipsis Property (TextCellType)
ShowFilterBar Property (PrintInfo)
ShowFilterBar Property (SheetSkin)
ShowFilterIndicator Property (DefaultRowFilter)
ShowFilterIndicator Property (IRowFilter)
ShowFirst Property
ShowFocusRectangle Property
ShowFrozenIndicator Enumeration
ShowFrozenIndicator Property
ShowGrid Property
ShowHeaderSelection Property
ShowHiddenData Property
ShowHigh Property
ShowInDropDown Method (BaseFilterItem)
ShowInDropDown Method (ColorFilterItem)
ShowInDropDown Method (CustomFilterItem)
ShowInDropDown Method (DefaultFilterItem)
ShowInDropDown Method (DynamicFilterItem)
ShowInDropDown Method (IconFilterItem)
ShowInDropDown Method (IFilterItem)
ShowInDropDown Method (MultiValuesFilterItem)
ShowInDropDown Method (Top10FilterItem)
ShowLast Property
ShowLow Property
ShowMarkers Property
ShowNegative Property
ShowParentRow Property
ShowPDFButton Property
ShowPopupButton Property (BaseDropDownCellType)
ShowPopupButton Property (DateCalendarCellType)
ShowRowHeader Property (PrintInfo)
ShowRowHeader Property (SheetSkin)
ShowSortItems Property
ShowSubtitle Property
ShowTitle Property
ShowToday Property
ShowWholePath Property
SideWall Property (XYPlotArea)
SideWall Property (XYZPlotArea)
SideWall Property (YPlotArea)
SignFunction Field
Simple1 Property
Simple2 Property
Simple3 Property
SinFunction Field
Single setting (SelectionPolicy enum)
SingleSelect setting (OperationMode enum)
single-selection mode
SinhFunction Field
Size Field
size of control

effect of EnableClientScript

size of page
Size Property (BuiltinMarker)
Size Property (GeneralEditor)
Size Property (PlotArea)
size, column headers
SizeRepresentsArea Property
SizeToFit client-side
SizeValues Property
sizing, row or column
sizing, row or column
sizing, row or column
SkewFunction Field
skins

applying
creating
editor
editor
overview

Skins Field
skins, active
skins, custom
skins, default
skins, resetting
Skip Property
slide show cell type
slide show cell type
slider cell type
slider cell type
SliderCellType Class

Members
Overview

SliderCellType Constructor (SliderCellType)
SlideShowCellType Class

Members
Overview

SlideShowCellType Constructor (SlideShowCellType)
SlideShowServiceMethod Property
SlideShowServicePath Property
SlnFunction Field
SlopeFunction Field
SmallFunction Field
SmartPaperRule Class

Members
Overview

SmartPaperRule Constructor (SmartPaperRule)
SmartPrint feature
SmartPrintPagesTall Property
SmartPrintPagesWide Property
SmartPrintRule Class

Members
Overview

SmartPrintRules Property
SmartPrintRulesCollection Class

Members
Overview

SmartPrintRulesCollection Constructor (SmartPrintRulesCollection)
SmoothedLine Property (AreaSeries)
SmoothedLine Property (LineSeries)
SmoothedLine Property (XYLineSeries)
SmoothedLine Property (XYZLineSeries)
Solid setting (FocusBorderStyle enum)
SolidFill Class

Members
Overview

SolidFill Constructor (SolidFill)
SolidLine Class

Members
Overview

SolidLine Constructor (SolidLine)
sort indicators

customizing

Sort Method (GroupDataModel)
Sort Method (SheetView)
SortAlphabetically setting (FilterListBehavior enum)
SortAscendingImage Field
SortByLeastOccurrences setting (FilterListBehavior enum)
SortByMostOccurrences setting (FilterListBehavior enum)
SortColumn command (client-side)
SortColumn, client-side
SortColumnCommand Event
SortColumns Method
SortDescendingImage Field
SortedColumn Property
SortFrozenRows Property
SortIndicator Enumeration
SortIndicator Field
SortIndicator Property
SortInfo Class

Members
Overview

SortInfo Constructor (SortInfo)
SortInfo Property (GroupDataModel)
SortInfo Property (GroupingEventArgs)
SortInfo Property (IGroupSupport)
sorting
sorting
sorting
sorting

affect on data models
cell types
customizing images
grouping
introduction
rows or columns

sorting, allowing
sorting, ascending image
sorting, columns
sorting, data
sorting, descending image
sorting, indicator
sorting, rows
sorting, settings
sorting, tag cloud items order
SortOrder Enumeration
SortOrder Property (TagCloudCellType)
SortOrder Property (TagCloudRenderer)
SortRows Method
source identifier, data binding
Source Property (ExternalCellExpression)
Source Property (ExternalNameExpression)
Source Property (ExternalRangeExpression)
Source Property (ExternalReferenceExpression)
spaces

in text cell

spaces, in sheet names
spacing

between group names
cell

spacing, cell spacing
spacing, cell spacing
span
span model
span model
span model, base
span model, default
span model, headers
span models, header
SpanModel Property
spanned cells

importing
importing

spanning cells
spanning cells
spans

column headers
row headers

spans, cells
spans, cells
spans, model
spans, model
spans, number of columns
spans, number of rows
sparkline

add
axis
group
markers

Sparkline Class

Members
Overview

Sparkline Constructor (Sparkline)
Sparkline Property
SparklineAxisMinMax Enumeration
SparklineContainer Property
SparklineModelEventHandler Delegate
SparklineModelUpdateEventArgs Class

Members
Overview

SparklineModelUpdateEventArgs Constructor (SparklineModelUpdateEventArgs)
sparklines
SparklineType Enumeration
specifying

formula

SpecularColor Property
spin cell type
Spread

exporting to Excel
importing from Excel
exporting to Excel
importing from Excel
regional settings

Spread command
Spread command
Spread component
Spread Designer
Spread Designer

applying changes
applying changes
closing
closing
editors
exiting
files
formatting
formula bar
Formula Editor
Formula Editor
Formula toolbar
general
introduction
menus
opening
overview
selections
starting
toolbars
working with

Spread for ASP.NET
Spread for Web Forms
Spread for Web Forms
Spread object (client side)
Spread object (client side)
Spread object (client side)
Spread object (client side)
Spread object (client side)
Spread Property (AutoFilteredColumnEventArgs)
Spread Property (SpreadDataSource)
Spread Wizard

overview

Spread XML
Spread XML files

loading from
opening
saving to

Spread XML files, loading from
Spread XML files, opening
Spread XML files, saving to
SpreadChart Class

Members
Overview

SpreadChart Constructor (SpreadChart)
SpreadChartCollection Class

Members
Overview

SpreadChartCollection Constructor (SpreadChartCollection)
SpreadChartCollectionEditor Class

Members
Overview

SpreadChartCollectionEditor Constructor (SpreadChartCollectionEditor)
SpreadCommandEventArgs Class

Members
Overview

SpreadCommandEventArgs Constructor (SpreadCommandEventArgs)
SpreadCommandEventHandler Delegate
SpreadControlBuilder Class

Members
Overview

SpreadControlBuilder Constructor (SpreadControlBuilder)
SpreadDataColumn Class

Members
Overview

SpreadDataColumn Constructor (SpreadDataColumn)
SpreadDataColumnCollection Class

Members
Overview

SpreadDataColumnCollection Constructor (SpreadDataColumnCollection)
SpreadDataColumnPropertyDescriptor Class

Members
Overview

SpreadDataColumnPropertyDescriptor Constructor (SpreadDataColumnPropertyDescriptor)
SpreadDataRowView Class

Members
Overview

SpreadDataRowView Constructor (SpreadDataRowView)
SpreadDataSource Class

Members
Overview

SpreadDataSource Constructor (SpreadDataSource)
SpreadDataSourceView Class

Members
Overview

SpreadDataSourceView Constructor (SpreadDataSourceView)
SpreadDataView Class

Members
Overview

SpreadDataView Constructor (SpreadDataView)
SpreadFontStyle Class

Members
Overview

SpreadFontStyle Constructor (SpreadFontStyle)
SpreadID Property
SpreadImages Enumeration
SpreadPanningMode Enumeration
SpreadSerializer Class

Members
Overview

SpreadSerializer Constructor (SpreadSerializer)
spreadsheet control
spreadsheet objects
SpreadSheetIndexOutOfRange setting (ExcelExceptionCode enum)
SpreadSheetNameNotFound setting (ExcelExceptionCode enum)
SpreadSparklineRenderes Class

Members
Overview

SpreadSparklineRenderes Constructor (SpreadSparklineRenderes)
SQL database

state management

SqrtFunction Field
SqrtPiFunction Field
SResize setting (CursorType enum)
StackedAreaSeries Class

Members
Overview

StackedAreaSeries Constructor (StackedAreaSeries)
StackedBarSeries Class

Members
Overview

StackedBarSeries Constructor (StackedBarSeries)
StackedLineSeries Class

Members
Overview

StackedLineSeries Constructor (StackedLineSeries)
StackedPointSeries Class

Members
Overview

StackedPointSeries Constructor (StackedPointSeries)
StandardDeviation Property (AverageConditionalFormattingRule)
StandardDeviation Property (ConditionalFormatting)
StandardizeFunction Field
StarCssClass Property
stars, cell type
stars, rating
Start Field
start page
StartAngle Property (PiePlotArea)
StartAngle Property (PolarPlotArea)
StartEdit client-side
StartFactor Property
StartingColumnNumber Property
StartingRowNumber Property
StartPage Property
state

each page as requested
maintaining
session state
view state

state management

database

StateList<T> Class

Members
Overview

StateList<T> Constructor (StateList<T>)
StDev setting (AggregationType enum)
StDevAFunction Field
StDevFunction Field
StDevP setting (AggregationType enum)
StDevPAFunction Field
StDevPFunction Field
Step Property
Steps Property
StEyxFunction Field
StopButtonText Property
StopIfTrue Property (HighlightConditionalFormattingRule)
StopIfTrue Property (IStopablePrePaintConditionalFormattingRule)
StopPainting Property
streams

opening Excel files

streams, opening Excel files
strict mode
Strikeout Property
StrikeoutFontStyle Enumeration
string
string
string
string
string
string
string
string
string
string
string
string
StringCollection Class

Members
Overview

StringCollection Constructor (StringCollection)
StringSegmentData Class

Members
Overview

StringSegmentData Constructor (StringSegmentData)
Stripe Class

Members
Overview

Stripe Constructor (Stripe)
StripeCollection Class

Members
Overview

Stripes Property (IndexAxis)
Stripes Property (PolarRadiusAxis)
Stripes Property (RadarValueAxis)
Stripes Property (ValueAxis)
strongly typed
structured storage

opening

structured storage, opening
style information
style information
style model
style model
style model, base
style model, default
style model, headers
style names, sheet corner
Style Property (ConditionalFormat)
Style Property (GradientFill)
Style Property (PrePaintResult)
style sheets, setting CSS
StyleInfo

editor
editor

StyleInfo Class

Members
Overview

StyleInfo Constructor (StyleInfo)
StyleModel Property
StyleName Property (AlternatingRow)
StyleName Property (Cell)
StyleName Property (Column)
StyleName Property (Row)
StyleNameConverter Class

Members
Overview

StyleNameConverter Constructor (StyleNameConverter)
StyleRowFilter Class

Members
Overview

StyleRowFilter Constructor (StyleRowFilter)
styles

cell reference
default headers
editor
editor
effect of EnableClientScript
filtering
for cells
for cells[styles

cells]

named
sheet corner
skins overview

Styles Field
styles named
styles, background color
styles, background color
styles, cell reference
styles, cell reference style
styles, collection
styles, collection event type
styles, copy
styles, custom
styles, default
styles, default
styles, default
styles, default column header
styles, default column header
styles, default row header
styles, default row header
styles, filtering
styles, headers
styles, headers
styles, model
styles, model
styles, parent
styles, parent
styles, parent
styles, parent
styles, parent
styles, resetting
styles, resetting
styles, serialization
styles, serializing
styles, text color
styles, text color
styles, text color
styles, text color
SubSeriesIndex Property
SubstituteFunction Field
subtitles

sheet

SubtotalFunction Field
SubtractOperator Field
Success Property (PrePaintResult)
Success Property (PrePaintTextResult)
Sum setting (AggregationType enum)
SumFunction Field
SumIfFunction Field
SumIfsFunction Field
SumProductFunction Field
SumSqFunction Field
SumX2MY2Function Field
SumX2PY2Function Field
SumXMY2Function Field
support

browsers

SupportFilteredOutRowList Property
SurfaceFill Property
SurfaceLine Property
Suspend Method
SuspendFormulaParsing Method (DefaultSparklineContainer)
SuspendFormulaParsing Method (ISuspendFormulaParsing)
SuspendLayout client-side
SuspendListeningDataModel Method
Swap Method (ConditionalFormattingModel)
Swap Method (DefaultSheetAxisModel)
Swap Method (DefaultSheetDataModel)
Swap Method (DefaultSheetSpanModel)
Swap Method (DefaultSheetStyleModel)
Swap Method (DefaultSparklineContainer)
Swap Method (IMovable)
Swap Method (IRangeSupport)
SwapColumns Method
SwapRows Method
SweepAngle Property
SwitchRowColumn Method (ExcelSparklineGroup)
SwitchRowColumn Method (SpreadChart)
SwResize setting (CursorType enum)
SydFunction Field
synchronized
SyncRoot Property (DefaultStyleCollection)
SyncRoot Property (GroupInfoCollection)
SyncRoot Property (NamedStyleCollection)
SyncRoot Property (SmartPrintRulesCollection)
Tab key

handling

Tab key, handling
Tab Property
TabControlPolicy Enumeration
TabControlPolicy Property
tab-delimited files
tab-delimited string
tab-delimited string
tab-delimited string
tab-delimited string
tab-delimited string
tab-delimited string
tab-delimited string
tab-delimited string
tab-delimited string
tab-delimited string
tab-delimited string
tab-delimited string
TabIndex Property (ChartMapArea)
TabIndex Property (MapArea)
TabInfo Class

Members
Overview

TabInfo Constructor (TabInfo)
table cell
table cell

spacing

TableData Property
TabLeft command (client-side)
TableReferenceExpression Class

Members
Overview

TableReferenceExpression Constructor (TableReferenceExpression)
TabRight command (client-side)
tabs

sheet names

tabs, sheet names
tabs,border color
tabs,scroll increment
tabs,sheet names
tabs,sheet names
tabs,sheet names
tabs,sheet names
tabs,sheet names
tabs,sheet names
tabs,sheet names
tabs,sheet names
tabs,text color
TabStop Field
TabStop Property (AlternatingRow)
TabStop Property (Cell)
TabStop Property (Column)
TabStop Property (GroupInfo)
TabStop Property (Row)
TabStop Property (StyleInfo)
tag cloud cell type
tag clouds, sort order
Tag Field
Tag Property (Cell)
Tag Property (Column)
Tag Property (NumericUpDownCellType)
Tag Property (RatingCellType)
Tag Property (Row)
TagCloudCellType Class

Members
Overview

TagCloudCellType Constructor (TagCloudCellType)
TagCloudItem Class

Members
Overview

TagCloudItem Constructor (TagCloudItem)
TagCloudItems Property (TagCloudCellType)
TagCloudItems Property (TagCloudRenderer)
TagCloudRenderer Class

Members
Overview

TagCloudRenderer Constructor (TagCloudRenderer)
tags

cell type

tags, cells
tags, columns
tags, setting
TanFunction Field
TanhFunction Field
target
target
Target Property (ChartMapArea)
Target Property (HyperLinkCellType)
Target Property (HyperLinkRenderer)
TargetButtonDownID Property
TargetButtonUpID Property
TargetColumn Property
TargetModel Property (GroupDataModel)
TargetModel Property (IGroupSupport)
TargetObject Property
TargetRow Property
TBillEqFunction Field
TBillPriceFunction Field
TBillYieldFunction Field
TD element
TDistFunction Field
template

for cells
for cells[template

cells]

templates

row
row edit
sheet skins
sheet skins

templates, replacement
text

automatic header
column headers
column headers
row headers
row headers

text box

cell type

text box watermark cell type
text cell (see general cell type)
text cell type
text cell type
text colors
text colors
text colors
text colors, alternating rows
text colors, cells
text colors, cells
text colors, columns
text colors, list box
text colors, locked cells
text colors, rows
text colors, selections
text colors, styles
text displayed
text file
text files

loading from
opening
saving to

text files, loading from
text files, opening
text for button
text format
text link
Text Property (ButtonCellType)
Text Property (ButtonRenderer)
Text Property (Cell)
Text Property (CheckBoxCellType)
Text Property (CheckBoxEditor)
Text Property (FetchGroupTextEventArgs)
Text Property (Group)
Text Property (LabelArea)
Text Property (ListItem)
Text Property (MenuItem)
Text Property (MutuallyExclusiveCheckBoxCellType)
Text Property (TagCloudItem)
Text Property (TextConditionalFormattingRule)
Text Property (TitleInfo)
Text setting (CursorType enum)
text tips
text tips
text wrap
text wrap
text wrap
text wrap
text wrap
text wrap
text, automatic header
text, cell type
text, in headers
text, in headers
text, in headers
text, in headers
text, in label
text, saving
text, saving
text, setting
text, sheet name tabs
text, tab text color
TextAlign Property (CheckBoxCellType)
TextAlign Property (CheckBoxEditor)
TextAscending setting (SortOrder enum)
TextBoxEditor Property
TextBoxWatermarkCellType Class

Members
Overview

TextBoxWatermarkCellType Constructor (TextBoxWatermarkCellType)
TextCellType Class

Members
Overview

TextCellType Constructor (TextCellType)
TextColor Property
TextConditionalFormattingRule Class

Members
Overview

TextConditionalFormattingRule Constructor (TextConditionalFormattingRule)
TextConditionOperator Enumeration
TextDataField Property
TextDataSource Property
TextDecoration Enumeration
TextDecoration Property
TextDescending setting (SortOrder enum)
TextFill Property (LabelArea)
TextFill Property (LegendArea)
TextFont Property (LabelArea)
TextFont Property (LegendArea)
TextFunction Field
TextOnRight Property (ImageCellType)
TextOnRight Property (ImageRenderer)
TFunction Field
Theme Property
ThreeColorScaleConditionalFormattingRule Class

Members
Overview

ThreeColorScaleConditionalFormattingRule Constructor (ThreeColorScaleConditionalFormattingRule)
tick marks
TickBetween Property
time, cell type
TimeFunction Field
TimePeriod Enumeration
TimePeriod Property
TimePeriodConditionalFormattingRule Class

Members
Overview

TimePeriodConditionalFormattingRule Constructor (TimePeriodConditionalFormattingRule)
TimeValueFunction Field
TInvFunction Field
Title Property (IndexAxis)
Title Property (PolarAngleAxis)
Title Property (PolarRadiusAxis)
Title Property (RadarIndexAxis)
Title Property (RadarValueAxis)
Title Property (TagCloudItem)
Title Property (ValueAxis)
TitleDataField Property (IndexAxis)
TitleDataField Property (PolarAngleAxis)
TitleDataField Property (PolarRadiusAxis)
TitleDataField Property (RadarIndexAxis)
TitleDataField Property (RadarValueAxis)
TitleDataField Property (ValueAxis)
TitleDataSource Property (IndexAxis)
TitleDataSource Property (PolarAngleAxis)
TitleDataSource Property (PolarRadiusAxis)
TitleDataSource Property (RadarIndexAxis)
TitleDataSource Property (RadarValueAxis)
TitleDataSource Property (ValueAxis)
TitleInfo Class

Members
Overview

TitleInfo Constructor (TitleInfo)
TitleInfo Property (FpSpread)
TitleInfo Property (SheetView)
TitleOffset Property (IndexAxis)
TitleOffset Property (PolarAngleAxis)
TitleOffset Property (PolarRadiusAxis)
TitleOffset Property (RadarIndexAxis)
TitleOffset Property (RadarValueAxis)
TitleOffset Property (ValueAxis)
titles

overview
sheet

TitleTextFill Property (IndexAxis)
TitleTextFill Property (PolarAngleAxis)
TitleTextFill Property (PolarRadiusAxis)
TitleTextFill Property (RadarIndexAxis)
TitleTextFill Property (RadarValueAxis)
TitleTextFill Property (ValueAxis)
TitleTextFont Property (IndexAxis)
TitleTextFont Property (PolarAngleAxis)
TitleTextFont Property (PolarRadiusAxis)
TitleTextFont Property (RadarIndexAxis)
TitleTextFont Property (RadarValueAxis)
TitleTextFont Property (ValueAxis)
TitleVisible Property (IndexAxis)
TitleVisible Property (PolarAngleAxis)
TitleVisible Property (PolarRadiusAxis)
TitleVisible Property (RadarIndexAxis)
TitleVisible Property (RadarValueAxis)
TitleVisible Property (ValueAxis)
To Property
ToArray Method
ToBool Method
ToDateTime Method
TodayFunction Field
TodayMarkColor Property
ToDouble Method
ToInt Method
tool bars

scroll bars
command bar position
command buttons
page navigation
pager
sheet name tabs

tool bars, command
tool bars, command
tool bars, grouping
tool bars, grouping
tool bars, grouping
tool bars, grouping
tool bars, grouping
tool bars, hierarchy
tool bars, hierarchy
tool bars, page navigation
tool bars, page navigation
tool bars, sheet name tabs
tool bars, sheet name tabs
tool bars, sheet name tabs
toolbars

formula

ToolTip Property (HyperLinkCellType)
ToolTip Property (HyperLinkRenderer)
ToolTip Property (MapArea)
TooltipText Property
top left cell
top left cell
top margin
Top Property (Inset)
Top Property (PaddingF)
Top Property (PrintMargin)
Top Property (SpreadChart)
top row

setting

Top setting (PagerPosition enum)
Top10FilterItem Class

Members
Overview

Top10FilterItem Constructor (Top10FilterItem)
TopBevel Property (BarSeries)
TopBevel Property (HighLowBarSeries)
TopBevel Property (PieSeries)
TopBevels Property (BarSeries)
TopBevels Property (HighLowBarSeries)
TopBevels Property (PieSeries)
TopBottom setting (PagerPosition enum)
TopCommandBar setting (PagerPosition enum)
TopRankedValuesConditionalFormattingRule Class

Members
Overview

TopRankedValuesConditionalFormattingRule Constructor (TopRankedValuesConditionalFormattingRule)
TopRow Property
TopRowChanged event
TopRowChanged event
TopRowChanged event
ToString Method (AppearanceProperty)
ToString Method (BaseCellType)
ToString Method (Border)
ToString Method (BorderProperty)
ToString Method (CalcConvert)
ToString Method (CalcError)
ToString Method (Cell)
ToString Method (CellRange)
ToString Method (CellRangeSegmentData)
ToString Method (Column)
ToString Method (ColumnFooter)
ToString Method (ColumnHeader)
ToString Method (Columns.DefaultColumn)
ToString Method (FunctionInfo)
ToString Method (Inset)
ToString Method (LayoutTemplate)
ToString Method (MapAreaInfo)
ToString Method (NamedStyle)
ToString Method (OperatorInfo)
ToString Method (PrintInfo)
ToString Method (PrintMargin)
ToString Method (Row)
ToString Method (RowHeader)
ToString Method (Rows.DefaultRow)
ToString Method (SheetAxisModelEventArgs)
ToString Method (SheetAxisProperty)
ToString Method (SheetCellRange)
ToString Method (SheetSelectionModelEventArgs)
ToString Method (SheetStyleProperty)
ToString Method (SheetView)
ToTimeSpan Method
touch
touch
touch menu
touch strip
TouchInfo Class

Members
Overview

TouchInfo Constructor (TouchInfo)
TouchInfo Property
touchstrip
TouchStrip Class

Members
Overview

TouchStrip Constructor (TouchStrip)
TouchStripClosed
TouchStripCollection Class

Members
Overview

touchstripitem
TouchStripItem Class

Members
Overview

TouchStripItem Constructor (TouchStripItem)
TouchStripItemClicked Event
TouchStripItemClickedHandler Delegate
TouchStripItemClickEventArgs Class

Members
Overview

TouchStripItemClickEventArgs Constructor (TouchStripItemClickEventArgs)
TouchStripItemCollection Class

Members
Overview

TouchStripItemCollection Constructor (TouchStripItemCollection)
TouchStripOpened
TouchStripOpening
TouchStrips Property
TouchStripShowingArea Enumeration
track color, scroll bars
tracking sheet state
TrackViewState Method (FpSpread)
TrackViewState Method (MapArea)
TransferId Property
TransferImage Method (FileImageRender)
TransferImage Method (HttpHandlerImageRender)
TransferImage Method (ImageRender)
TransferImage Method (ISparklineSupportHandler)
TransposeFunction Field
TrendFunction Field
TrimFunction Field
TrimMeanFunction Field
TrueFunction Field
TruncFunction Field
TryConvert Method
TryParse Method (CalcError)
TryParse Method (CellRange)
TryToDouble Method
TTestFunction Field
tutorials

adding Spread component
binding to database
checkbook register
getting started

TwoColorScaleConditionalFormattingRule Class

Members
Overview

TwoColorScaleConditionalFormattingRule Constructor (TwoColorScaleConditionalFormattingRule)
Type Property (ConditionalFormattingModelEventArgs)
Type Property (ConditionalFormattingValue)
Type Property (ContextMenu)
Type Property (DynamicFilterItem)
Type Property (ItemEventArgs<T>)
Type Property (MapAreaInfo)
Type Property (NamedStyleCollectionEventArgs)
Type Property (SheetAxisModelEventArgs)
Type Property (SheetDataModelEventArgs)
Type Property (SheetStyleModelEventArgs)
TypeFunction Field
types of cells

exporting
importing
exporting
importing

types, buttons
types, cells
types, cells
types, cursor
types, printing range
types, replacement
UIVirtualization Property
unary, operators
UnaryComparisonConditionalFormattingRule Class

Members
Overview

UnaryComparisonConditionalFormattingRule Constructor (UnaryComparisonConditionalFormattingRule)
UnaryComparisonOperator Enumeration
UnaryOperatorExpression Class

Members
Overview

UnaryOperatorExpression Constructor (UnaryOperatorExpression)
UnaryOperatorInfo Class

Members
Overview

unbound cells, getting value
unbound rows

adding

unbound rows, adding
unbound rows, adding
UnBoundNewRowIndex Property
Unchanged Field
UncheckedImageUrl Property (CheckBoxCellType)
UncheckedImageUrl Property (CheckBoxRenderer)
Underline Property
Underline setting (Text Decoration enum)
UnderlineFontStyle Enumeration
UnfilteredRows Property (DefaultRowFilter)
UnfilteredRows Property (IRowFilter)
Ungrouped Event
UnGroupSparkline Method (Cell)
UngroupSparkline Method (SheetView)
UnionOperator Field
UnionOperatorInfo Class

Members
Overview

UnionOperatorInfo Constructor (UnionOperatorInfo)
UniqueOrDuplicatedConditionalFormattingRule Class

Members
Overview

UniqueOrDuplicatedConditionalFormattingRule Constructor (UniqueOrDuplicatedConditionalFormattingRule)
Unknown setting (ExcelExceptionCode enum)
UnparseFormula Method (DefaultSheetDataModel)
UnparseFormula Method (IExpressionSupport2)
UnparseFormula Method (IObjectExpressionSupport)
UpBorder Property
UpBorders Property
Update button (command bar)
Update button (command bar)
Update client-side
Update command (client-side)
Update event
UpdateButton setting (ReplacementType enum)
UpdateCommand Event
Updated Event (BaseSparkline)
Updated Event (ExcelSparklineGroup)
Updated Event (ExcelSparklineSetting)
Updated Event (ISparkline)
Updated Event (ISparklineGroup)
UpdatedCellRanges Property
UpdateFormulasWhenModelChanged Method
UpdateMethod
UpdateMethod Property (FpSpread)
UpdateMethod Property (SheetView)
UpdatePostBackData client-side
updates

saving

updates, automatic postback
UpdateView Method
updating

formulas automatically

UpFill Property
UpFills Property
uplevel browser
UpLine Property
UpLines Property
UpperFunction Field
Uri Property
URL
URL, editor
URL, editor
URL, in cell
URL, link for button
URL, renderer
UsableParseFormat Property
UseClipboard Property
UseContextKey Property
UseCustomPaletteForColorApproximations setting (ExcelSaveFlags enum)
UseMax Property
UseNegativeBorderColor Property
UseNegativeFillColor Property
UseOOXMLFormat setting (ExcelSaveFlags enum)
User Controls
user interaction

customizing
customizing

user selection
UserDateFormat Property
user-defined functions
user-defined names
user-defined skins
user-defined styles
user-defined styles
user-defined, functions
user-defined, functions
user-defined, names
user-defined, names
UseRowIndex Property (DefaultSheetDataModel)
UseRowIndex Property (IDataKeySupport)
UserTimeFormat Property
UseSheetSkin Property
UseSmartPrint Property
UseValue Property (ComboBoxCellType)
UseValue Property (ComboBoxEditor)
UseValue Property (MultiColumnComboBoxCellType)
UseValue Property (MultiColumnEditor)
Validate Method
ValidateEditorValue Method (BaseCellType)
ValidateEditorValue Method (BaseEditor)
ValidateEditorValue Method (CheckBoxCellType)
ValidateEditorValue Method (CheckBoxEditor)
ValidateEditorValue Method (CurrencyCellType)
ValidateEditorValue Method (DateCalendarCellType)
ValidateEditorValue Method (DateTimeCellType)
ValidateEditorValue Method (DoubleCellType)
ValidateEditorValue Method (GeneralCellType)
ValidateEditorValue Method (IEditor)
ValidateEditorValue Method (IntegerCellType)
ValidateEditorValue Method (PercentCellType)
ValidateEditorValue Method (RatingCellType)
ValidateEditorValue Method (RegExpCellType)
ValidateEditorValue Method (TextCellType)
validation

enabling on client

validation,expressions
ValidationErrorMessage Property
ValidationExpression Property (MaskedEditValidator)
ValidationExpression Property (RegExpCellType)
ValidatorCollection Class

Members
Overview

ValidatorCollection Constructor (ValidatorCollection)
Validators Property (BaseCellType)
Validators Property (BaseEditor)
Validators Property (IEditor3)
ValidChars Property
Value Property (ArrayExpression)
Value Property (BooleanExpression)
Value Property (CalcError)
Value Property (Cell)
Value Property (ConditionalFormattingValue)
Value Property (DoubleExpression)
Value Property (ErrorExpression)
Value Property (ExtraRendererSettings)
Value Property (FilterCondition)
Value Property (FilterItemValue)
Value Property (ListItem)
Value Property (MissingArgumentExpression)
Value Property (PreviewRowTemplateContainer)
Value Property (StringSegmentData)
Value Property (UnaryComparisonConditionalFormattingRule)
ValueAxis Class

Members
Overview

ValueAxis Constructor (ValueAxis)
ValueAxisCollection Class

Members
Overview

ValueFunction Field
values for combo box
Values Property (AreaSeries)
Values Property (BarSeries)
Values Property (ComboBoxCellType)
Values Property (ComboBoxEditor)
Values Property (LineSeries)
Values Property (ListBoxCellType)
Values Property (ListBoxEditor)
Values Property (PieSeries)
Values Property (PointSeries)
Values Property (RadarAreaSeries)
Values Property (RadarLineSeries)
Values Property (RadarPointSeries)
Values Property (RadioButtonListCellType)
Values Property (RadioButtonListEditor)
Values Property (XYZSurfaceSeries)
values, setting
ValuesCount Property
ValuesRequires Property
Var setting (AggregationType enum)
VarAFunction Field
VarFunction Field
VarP setting (AggregationType enum)
VarPAFunction Field
VarPFunction Field
VaryColors Property (BarSeries)
VaryColors Property (HighLowBarSeries)
VaryColors Property (LineSeries)
VaryColors Property (PieSeries)
VaryColors Property (PointSeries)
VaryColors Property (PolarLineSeries)
VaryColors Property (PolarPointSeries)
VaryColors Property (RadarLineSeries)
VaryColors Property (RadarPointSeries)
VaryColors Property (XYBubbleSeries)
VaryColors Property (XYLineSeries)
VaryColors Property (XYPointSeries)
VaryColors Property (XYZLineSeries)
VaryColors Property (XYZPointSeries)
VBScript
VdbFunction Field
verbs

Spread Designer

vertical

indent, between group names

vertical alignment
vertical grid lines
vertical grid lines
vertical grid lines
Vertical Property (LegendArea)
Vertical Property (YPlotArea)
Vertical setting (Centering enum)
Vertical setting (SheetAxisOrientation enum)
VerticalAlign Field (AppearanceProperty)
VerticalAlign Field (SheetStyleProperty)
VerticalAlign Property (AlternatingRow)
VerticalAlign Property (Appearance)
VerticalAlign Property (Cell)
VerticalAlign Property (Column)
VerticalAlign Property (GroupInfo)
VerticalAlign Property (MultiColumnComboBoxCellType)
VerticalAlign Property (MultiColumnEditor)
VerticalAlign Property (NamedStyle)
VerticalAlign Property (PreviewRowInfo)
VerticalAlign Property (Row)
VerticalAlign Property (StyleInfo)
VerticalAlign Property (TitleInfo)
VerticalScrollBarPolicy Property
view state
view state, loading
view state, saving
ViewState Property
ViewType Property
virtual mode

See load on demand.

VirtualScrollPagingFormatString Property
VirtualScrollPagingPrevRowCount Property
visible

footer
hiding rows or columns
sheets

Visible Field
Visible Property (Column)
Visible Property (ColumnFooter)
Visible Property (ColumnHeader)
Visible Property (CommandBarInfo)
Visible Property (CreateButtonEventArgs)
Visible Property (FpChart)
Visible Property (LayoutColumn)
Visible Property (LayoutRow)
Visible Property (MenuItem)
Visible Property (Row)
Visible Property (RowHeader)
Visible Property (Series)
Visible Property (SheetView)
Visible Property (SpreadChart)
Visible Property (TitleInfo)
Visible Property (Wall)
visible, child in hierarchy
visible, column headers
visible, row headers
visible, row headers
visible, setting column
visible, setting row
VisibleCount Property
visual
Visual Basic scripting
VLookupFunction Field
vs2012
Wait setting (CursorType enum)
WaitingStarCssClass Property
WaitMessage Property
wall
Wall Class

Members
Overview

Wall Constructor (Wall)
Wall Property
warning, Excel-related
WarningList Property
warnings, Excel
warnings, Excel-related
watermark

cell type

watermark cell type
watermark text box
WatermarkCssClass Property
WatermarkText Property
Web Forms spreadsheet component
Web Parts
Web, start page
WeekdayFunction Field
WeekNumFunction Field
WeibullFunction Field
Weight Property
WeightAscending setting (SortOrder enum)
WeightDescending setting (SortOrder enum)
Weights Property
Welcome to FarPoint Spread for ASP.NET
width

columns
headers

width column
width column
Width Property (Bevel)
Width Property (CircleBevel)
Width Property (Column)
Width Property (ContextMenu)
Width Property (FpChart)
Width Property (LayoutColumn)
Width Property (NoBevel)
Width Property (RowHeader)
Width Property (SolidLine)
Width Property (TouchStripItem)
Width Property (Wall)
width, column (client-side)
width, default column
width, row headers
width, row headers
Windows
Windows Azure
Windows regional settings
Windows regional settings
WinLossSparklineRenderer Class

Members
Overview

WinLossSparklineRenderer Constructor (WinLossSparklineRenderer)
WinLossSparklineRenderer Property
WorkdayFunction Field
WorksheetLayoutCell Class

Members
Overview

WorksheetLayoutCells Class

Members
Overview

WorksheetTemplate Class

Members
Overview

WorksheetTemplate Constructor (WorksheetTemplate)
WorksheetTemplate Property
wrap
wrapping
wrapping
wrapping
wrapping
wrapping
WriteXml Method (AreaSeries)
WriteXml Method (AreaSeriesCollection)
WriteXml Method (BarSeries)
WriteXml Method (BarSeriesCollection)
WriteXml Method (CandlestickSeries)
WriteXml Method (ChartModel)
WriteXml Method (ClusteredBarSeries)
WriteXml Method (DirectionalLight)
WriteXml Method (HighLowAreaSeries)
WriteXml Method (HighLowBarSeries)
WriteXml Method (HighLowCloseSeries)
WriteXml Method (IndexAxis)
WriteXml Method (LabelArea)
WriteXml Method (LabelAreaCollection)
WriteXml Method (LegendArea)
WriteXml Method (LegendAreaCollection)
WriteXml Method (Light)
WriteXml Method (LightCollection)
WriteXml Method (LineSeries)
WriteXml Method (LineSeriesCollection)
WriteXml Method (OpenHighLowCloseSeries)
WriteXml Method (PiePlotArea)
WriteXml Method (PieSeries)
WriteXml Method (PlotArea)
WriteXml Method (PlotAreaCollection)
WriteXml Method (PointSeries)
WriteXml Method (PointSeriesCollection)
WriteXml Method (PolarAngleAxis)
WriteXml Method (PolarAreaSeries)
WriteXml Method (PolarLineSeries)
WriteXml Method (PolarPlotArea)
WriteXml Method (PolarPointSeries)
WriteXml Method (PolarRadiusAxis)
WriteXml Method (PolarRadiusAxisCollection)
WriteXml Method (PolarSeries)
WriteXml Method (PositionalLight)
WriteXml Method (RadarAreaSeries)
WriteXml Method (RadarIndexAxis)
WriteXml Method (RadarLineSeries)
WriteXml Method (RadarPlotArea)
WriteXml Method (RadarPointSeries)
WriteXml Method (RadarSeries)
WriteXml Method (RadarValueAxis)
WriteXml Method (RadarValueAxisCollection)
WriteXml Method (Series)
WriteXml Method (SeriesCollection)
WriteXml Method (StackedAreaSeries)
WriteXml Method (StackedBarSeries)
WriteXml Method (StackedLineSeries)
WriteXml Method (StackedPointSeries)
WriteXml Method (Stripe)
WriteXml Method (StripeCollection)
WriteXml Method (ValueAxis)
WriteXml Method (ValueAxisCollection)
WriteXml Method (Wall)
WriteXml Method (XYBubbleSeries)
WriteXml Method (XYLineSeries)
WriteXml Method (XYPlotArea)
WriteXml Method (XYPointSeries)
WriteXml Method (XYSeries)
WriteXml Method (XYZLineSeries)
WriteXml Method (XYZPlotArea)
WriteXml Method (XYZPointSeries)
WriteXml Method (XYZSeries)
WriteXml Method (XYZSurfaceSeries)
WriteXml Method (YPlotArea)
WriteXml Method (YSeries)
XAxes Property (XYPlotArea)
XAxes Property (XYZPlotArea)
XAxis Property (PolarPlotArea)
XAxis Property (RadarPlotArea)
XAxis Property (YPlotArea)
XAxisId Property (XYSeries)
XAxisId Property (XYZSeries)
XirrFunction Field
XLSX file support
XML

Office Open Excel

XML files

opening XML files

loading from

XML files, opening
XML files, saving
XML, opening in sheet
XML, saving
XML, serialization
XML, Spread
XnpvFunction Field
XValues Property (PolarAreaSeries)
XValues Property (PolarLineSeries)
XValues Property (PolarPointSeries)
XValues Property (XYBubbleSeries)
XValues Property (XYLineSeries)
XValues Property (XYPointSeries)
XValues Property (XYZLineSeries)
XValues Property (XYZPointSeries)
XY Plot
XYBubbleSeries Class

Members
Overview

XYBubbleSeries Constructor (XYBubbleSeries)
XYLineSeries Class

Members
Overview

XYLineSeries Constructor (XYLineSeries)
XYPlotArea Class

Members
Overview

XYPlotArea Constructor (XYPlotArea)
XYPointSeries Class

Members
Overview

XYPointSeries Constructor (XYPointSeries)
XYSeries Class

Members
Overview

XYZLineSeries Class

Members
Overview

XYZLineSeries Constructor (XYZLineSeries)
XYZPlotArea Class

Members
Overview

XYZPlotArea Constructor (XYZPlotArea)
XYZPointSeries Class

Members
Overview

XYZPointSeries Constructor (XYZPointSeries)
XYZSeries Class

Members
Overview

XYZSurfaceSeries Class

Members
Overview

XYZSurfaceSeries Constructor (XYZSurfaceSeries)
Y plot
YAxes Property (PolarPlotArea)
YAxes Property (RadarPlotArea)
YAxes Property (XYPlotArea)
YAxes Property (XYZPlotArea)
YAxes Property (YPlotArea)
YAxisId Property (PolarSeries)
YAxisId Property (RadarSeries)
YAxisId Property (XYSeries)
YAxisId Property (XYZSeries)
YAxisId Property (YSeries)
YearFormat Property
YearFracFunction Field
YearFunction Field
YearMonthFormat Class

Members
Overview

YearMonthFormat Constructor (YearMonthFormat)
YearMonthFormat Property
YieldDiscFunction Field
YieldFunction Field
YieldMatFunction Field
YPlot
YPlotArea Class

Members
Overview

YPlotArea Constructor (YPlotArea)
YSeries Class

Members
Overview

YValues Property (PolarAreaSeries)
YValues Property (PolarLineSeries)
YValues Property (PolarPointSeries)
YValues Property (XYBubbleSeries)
YValues Property (XYLineSeries)
YValues Property (XYPointSeries)
YValues Property (XYZLineSeries)
YValues Property (XYZPointSeries)
ZAxes Property
ZAxis Property (XYPlotArea)
ZAxis Property (YPlotArea)
ZAxisId Property
ZIndex Property
ZoomFactor Property
ZTestFunction Field
ZValues Property (XYZLineSeries)
ZValues Property (XYZPointSeries)