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>deleting, See removing
<$nopage>deleting, See removing
<$nopage>displaying, See hiding
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

ActiveChart Property
ActiveCol, client-side
ActiveColumn Property
ActiveCssClass Property
ActiveImage 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 (BoxWhiskerSeriesCollection)
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 (FormulaEntryCollection)
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 (SpreadImageCollection)
Add Method (StringCollection)
Add Method (StringCollectionCollection)
Add Method (StringCollectionItem)
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)
AddedControl Method
AddFilteredOutRow Method
AddFormula Method
AddImage Method
adding

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

adding spans
adding Spread component

tutorials

AddKeyMap, client-side
AddNewCore Method
AddOperator Field
AddParsedSubObject Method
AddRange Method (AlternatingRows)
AddRange Method (AreaSeriesCollection)
AddRange Method (BarSeriesCollection)
AddRange Method (BevelCollection)
AddRange Method (BoxWhiskerSeriesCollection)
AddRange Method (Columns)
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 (Rows)
AddRange Method (SeriesCollection)
AddRange Method (SheetCellRangeCollection)
AddRange Method (SheetViewCollection)
AddRange Method (SpreadChartCollection)
AddRange Method (SpreadImageCollection)
AddRange Method (StringCollection)
AddRange Method (StringCollectionCollection)
AddRange Method (StringCollectionItem)
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)
AddWarning Method
AddWarnings Method
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

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

AlignmentX Property (LabelArea)
AlignmentX Property (LegendArea)
AlignmentY Property (LabelArea)
AlignmentY Property (LegendArea)
All (filtering list item)
All (filtering list item)
AllowClientUnlock Property
AllowColumnMove Property
AllowDBNull Property
AllowDelete Property
AllowGenerateHiddenData Property
AllowGetAllHiddenValue Property
AllowGroup Property
AllowHeaderResize Property
AllowInsert Property
AllowLoadOnDemand Property (FpSpread)
AllowLoadOnDemand Property (SheetView)
AllowPage Property
AllowParallel Property
AllowRowMove 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 (CurrencyCellType)
AllowWrap Property (DateTimeCellType)
AllowWrap Property (DefaultRenderer)
AllowWrap Property (DoubleCellType)
AllowWrap Property (GeneralCellType)
AllowWrap Property (HyperLinkCellType)
AllowWrap Property (HyperLinkRenderer)
AllowWrap Property (IntegerCellType)
AllowWrap Property (IWrapableRenderer)
AllowWrap Property (LabelCellType)
AllowWrap Property (PercentCellType)
AllowWrap Property (RegExpCellType)
AllowWrap Property (TextCellType)
AllString Property (DefaultRowFilter)
AllString Property (IRowFilter)
AlternateText Property (ChartMapArea)
AlternateText Property (FpChart)
AlternateText Property (ImageCellType)
AlternateText Property (ImageRenderer)
alternating rows
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)
AmbientColor Property
AmordegrcFunction Field
AmorlincFunction Field
anchor cells
AnchorColumn Property (BaseSheetSelectionModel)
AnchorColumn Property (DefaultSheetSelectionModel)
AnchorColumn Property (ISheetSelectionModel)
AnchorRow Property (BaseSheetSelectionModel)
AnchorRow Property (DefaultSheetSelectionModel)
AnchorRow Property (ISheetSelectionModel)
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)
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
arranging

columns
rows

ArrayExpression Class

Members
Overview

ArrayExpression Constructor (ArrayExpression)
ArraySegmentData Class

Members
Overview

ArraySegmentData Constructor (ArraySegmentData)
ArrayValue Property
ArrowImageUrl Property
Ascending Property (Group)
Ascending Property (SortInfo)
ASCII files

saving

AsinFunction Field
AsinhFunction Field
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
assigning

cell types for bound data
CSS to cell

Atan2Function Field
AtanFunction Field
AtanhFunction Field
ATLAS (see AJAX)
attaching

CSS to cell

AttachObjectExpression Method
Attributes Property
AutoCalculation Property (DefaultSheetDataModel)
AutoCalculation Property (ICalculationSupport)
AutoCalculation Property (SheetView)
AutoComplete Property
AutoCompleteCellType Class

Members
Overview

AutoCompleteCellType Constructor (AutoCompleteCellType)
AutoCompleteMode Property
AutoCompleteValue Property
AutoFilter Class

Members
Overview

AutoFilter Constructor (AutoFilter)
AutoFilter Property (MultiColumnComboBoxCellType)
AutoFilter Property (MultiColumnEditor)
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 merging
automatic text
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)
AutoOverFlow Property
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)
AutoUnderFlow Property
AveDevFunction Field
AverageAFunction Field
AverageConditionalFormattingRule Class

Members
Overview

AverageConditionalFormattingRule Constructor (AverageConditionalFormattingRule)
AverageFunction Field
AverageIfFunction Field
AverageIfsFunction Field
AverageValue Property
axis
axis
Axis Class

Members
Overview

axis model
axis model
Axis Property
AxisColor Property (DatabarConditionalFormattingRule)
AxisColor Property (ExcelSparklineSetting)
AxisId Property (PolarRadiusAxis)
AxisId Property (RadarValueAxis)
AxisId Property (ValueAxis)
AxisInfo Class

Members
Overview

AxisInfo Constructor (AxisInfo)
AxisInfo.AxisType Enumeration
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 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 (SunburstPlotArea)
BackWall Property (TreemapPlotArea)
BackWall Property (XYPlotArea)
BackWall Property (XYZPlotArea)
BackWall Property (YPlotArea)
Bar Property
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

BarSeries Class

Members
Overview

BarSeries Constructor (BarSeries)
BarSeriesCollection Class

Members
Overview

BarShape Enumeration
BarShape Property (BarSeries)
BarShape Property (HighLowBarSeries)
base models
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
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

Bin2DecFunction Field
Bin2HexFunction Field
Bin2OctFunction Field
Binary Interchange File Format
Binary Interchange File Format
BinaryOperatorExpression Class

Members
Overview

BinaryOperatorExpression Constructor (BinaryOperatorExpression)
BinaryOperatorInfo Class

Members
Overview

BinCount Property
binding

to data set

binding to data set
binding to data set

hierarchy display
limiting postbacks
managing

binding to database

tutorial

BinomDistFunction Field
BinOption Class

Members
Overview

BinOption Constructor (BinOption)
BinOption Property
BinOption.HistogramBinType Enumeration
BinSize Property
BinType Property
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 (BoxWhiskerSeries)
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 (SunburstSeries)
Border Property (TitleInfo)
Border Property (TreemapSeries)
Border Property (Wall)
Border Property (WaterfallSeries)
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

importing
importing
selection

Borders Property (SunburstSeries)
Borders Property (TreemapSeries)
Borders Property (WaterfallSeries)
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
Bottom Property (Inset)
Bottom Property (PaddingF)
Bottom Property (PrintMargin)
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 data
bound data

limiting postbacks

bound spreadsheet
BoundControl Property
Bounds Property
BoxWhiskerSeries Class

Members
Overview

BoxWhiskerSeries Constructor (BoxWhiskerSeries)
BoxWhiskerSeriesCollection Class

Members
Overview

Browse button
browsers

downlevel
support
uplevel

BubbleSize Property
built-in

CallBack commands

built-in functions
built-in skins
BuiltinMarker Class

Members
Overview

BuiltinMarker Constructor (BuiltinMarker)
button (cell)

hypertext link
image

button cell type
ButtonCellType Class

Members
Overview

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

Members
Overview

ButtonRenderer Constructor (ButtonRenderer)
buttons

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

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

Calculate Method
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 Property (RowEditTemplateContainer)
Cancel, client-side
CancelChanges Method
CancelCommand Event
CancelEdit Method (FpSpread)
CancelEdit Method (SpreadDataRowView)
CanChangeChartType Property
CanChangeChartViewType 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 (SpreadChart)
CanMove Property (SpreadImage)
CanPrint Property (IPdfPrintableRule)
CanPrint Property (SpreadChart)
CanPrint Property (SpreadImage)
CanResetValue Method (DoubleCollectionPropertyDescriptor)
CanResetValue Method (SpreadDataColumnPropertyDescriptor)
CanSelect Property (SpreadChart)
CanSelect Property (SpreadImage)
CanSelectMultipleInstances Method
CanSerializeObject Method
CanSerializeXml Property (DefaultSheetDataModel)
CanSerializeXml Property (DefaultSheetStyleModel)
CanSerializeXml Property (FilterColumnDefinition)
CanSerializeXml Property (GroupDataModel)
CanSerializeXml Property (GroupInfo)
CanSerializeXml Property (GroupInfoCollection)
CanSerializeXml Property (ICanSerializeXml)
CanSerializeXml Property (NamedStyleCollection)
CanSerializeXml Property (PreviewRowInfo)
CanSerializeXml Property (StyleInfo)
CanSize Property (SpreadChart)
CanSize Property (SpreadImage)
CanSort Property
CanSwitchRowColumn Property
CanUpdate Property
Caption Property
cascading style sheet

assigning to cell

CaseSensitive Property
Category Property (IIndicator)
Category Property (IndicatorChangedEventArgs)
CategoryFormula Property
CategoryNames Property (HistogramSeries)
CategoryNames Property (PieSeries)
CategoryNames Property (RadarSeries)
CategoryNames Property (SunburstSeries)
CategoryNames Property (TreemapSeries)
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 reference

style

cell spacing
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 types

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

CellBackColor Property
CellClick command (client-side)
CellClick Event
CellCssClass Property
CellExpression Class

Members
Overview

CellExpression Constructor (CellExpression)
CellForeColor Property
CellRange Class

Members
Overview

CellRange Constructor (CellRange)
CellRange Property (DefaultSpreadDataViewMapper)
CellRange Property (SpreadDataSource)
CellRangeConverter Class

Members
Overview

CellRangeConverter Constructor (CellRangeConverter)
CellRanges Property
CellRangeSegmentData Class

Members
Overview

CellRangeSegmentData Constructor (CellRangeSegmentData)
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, client-side
CellSpacing Property (SheetSkin)
CellSpacing Property (SheetView)
CellType Property (AlternatingRow)
CellType Property (Cell)
CellType Property (Column)
CellType Property (NamedStyle)
CellType Property (Row)
CellType Property (StyleInfo)
CellType Property (TitleInfo)
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 (BinOption)
Changed Event (BoxWhiskerSeriesCollection)
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 (StringCollectionCollection)
Changed Event (StringCollectionItem)
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
chart
chart
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
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 sheets
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
Classic Property
Classic1 Property
Classic2 Property
CleanFunction Field
Clear Method (AlternatingRows)
Clear Method (AreaSeriesCollection)
Clear Method (BarSeriesCollection)
Clear Method (BaseSheetSpanModel)
Clear Method (BevelCollection)
Clear Method (BoxWhiskerSeriesCollection)
Clear Method (Columns)
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 (Rows)
Clear Method (SeriesCollection)
Clear Method (SmartPrintRulesCollection)
Clear Method (StringCollection)
Clear Method (StringCollectionCollection)
Clear Method (StringCollectionItem)
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

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 (FloatingObject)
Click Event (FpChart)
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 validation

effects of EnableClientScript

ClientValidationFunction Property
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 (BoxWhiskerSeries)
Clone Method (CandlestickSeries)
Clone Method (ChartModel)
Clone Method (ClusteredBarSeries)
Clone Method (ClusteredBoxWhiskerSeries)
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 (FunnelSeries)
Clone Method (HighLowAreaSeries)
Clone Method (HighLowBarSeries)
Clone Method (HighLowCloseSeries)
Clone Method (HistogramBar)
Clone Method (HistogramLine)
Clone Method (HistogramSeries)
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 (ParetoSeries)
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 (SpreadImage)
Clone Method (StackedAreaSeries)
Clone Method (StackedBarSeries)
Clone Method (StackedLineSeries)
Clone Method (StackedPointSeries)
Clone Method (StringCollection)
Clone Method (StringCollectionItem)
Clone Method (Stripe)
Clone Method (StyleInfo)
Clone Method (SunburstPlotArea)
Clone Method (SunburstSeries)
Clone Method (TreemapPlotArea)
Clone Method (TreemapSeries)
Clone Method (ValidatorCollection)
Clone Method (ValueAxis)
Clone Method (Wall)
Clone Method (WaterfallSeries)
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)
CloneNodeReader Method
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)
ClusteredBoxWhiskerSeries Class

Members
Overview

ClusteredBoxWhiskerSeries Constructor (ClusteredBoxWhiskerSeries)
Code Property (ExcelException)
Code Property (ExcelWarning)
CodeFunction Field
Col Property
ColEnd Property
CollapseImage Field
collapsing

grouping

Collection Editor
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
ColStart Property
column
Column Class

Members
Overview

column footer

hiding

column headers

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

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

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 (IMatrixData)
ColumnCount Property (ISegmentMatrixData)
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
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

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, client-side
columns, width (client-side)
Columns.DefaultColumn Class

Members
Overview

ColumnsFunction Field
ColumnSpan Property (Cell)
ColumnSpan Property (LayoutCell)
ColumnSparklineRenderer Class

Members
Overview

ColumnSparklineRenderer Constructor (ColumnSparklineRenderer)
ColumnSparklineRenderer Property
ColumnWidths Property (MultiColumnComboBoxCellType)
ColumnWidths Property (MultiColumnEditor)
combined
CombinFunction Field
combo box cell
combo box cell
combo box cell type
combo box cell type
combo-box cell type
ComboBoxCellType Class

Members
Overview

ComboBoxCellType Constructor (ComboBoxCellType)
ComboBoxEditor Class

Members
Overview

ComboBoxEditor Constructor (ComboBoxEditor)
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 buttons
Command Property
CommandArgument Property
CommandBar Property
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

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
computed value

custom name

ConcatenateFunction Field
ConcatenateOperator Field
conditional formatting
conditional formatting

overview

ConditionalFormat Class

Members
Overview

ConditionalFormat Constructor (ConditionalFormat)
ConditionalFormat Property
ConditionalFormatCollection Class

Members
Overview

ConditionalFormatCollection Constructor (ConditionalFormatCollection)
ConditionalFormatDialogs Enumeration
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
ConditionalFormattingUtils.IUpdateSpread Interface
ConditionalFormattingUtils.UpdateSpreadMethod Delegate
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 (BoxWhiskerSeriesCollection)
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 (SpreadImageCollection)
Contains Method (StringCollection)
Contains Method (StringCollectionCollection)
Contains Method (StringCollectionItem)
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

ControlID Property
controls

ASP.NET AJAX extenders

Controls Property
ConvertFrom Method (CellRangeConverter)
ConvertFrom Method (CellTypeConverter)
ConvertFrom Method (MapperInfoConverter)
ConvertFrom Method (ParentStyleNameConverter)
ConvertFrom Method (StyleNameConverter)
ConvertFunction Field
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 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, 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 (BoxWhiskerSeriesCollection)
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 (StringCollectionCollection)
CopyTo Method (StringCollectionItem)
CopyTo Method (StripeCollection)
CopyTo Method (ValueAxisCollection)
corner

sheet

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 (BoxWhiskerSeries)
Count Property (BoxWhiskerSeriesCollection)
Count Property (CandlestickSeries)
Count Property (CellRangeSegmentData)
Count Property (ClusteredBarSeries)
Count Property (ClusteredBoxWhiskerSeries)
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 (FunnelSeries)
Count Property (GroupInfoCollection)
Count Property (HighLowAreaSeries)
Count Property (HighLowBarSeries)
Count Property (HighLowCloseSeries)
Count Property (HistogramSeries)
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 (StringCollectionCollection)
Count Property (StringCollectionItem)
Count Property (StripeCollection)
Count Property (SunburstSeries)
Count Property (TabInfo)
Count Property (TouchStripCollection)
Count Property (TreemapSeries)
Count Property (ValueAxisCollection)
Count Property (WaterfallSeries)
Count Property (XYBubbleSeries)
Count Property (XYLineSeries)
Count Property (XYPointSeries)
Count Property (XYZLineSeries)
Count Property (XYZPointSeries)
Count Property (XYZSurfaceSeries)
CountAFunction Field
CountBlankFunction Field
CountChanged Property
CountFunction Field
CountIfFunction Field
CountIfsFunction Field
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 (SpreadChartCollectionEditor)
CreateCollectionForm Method (SpreadImageCollectionEditor)
CreateColumnAxisModel Method (LayoutTemplate)
CreateColumnAxisModel Method (SheetView)
CreateContent Method (CheckBoxRenderer)
CreateContent Method (ComboBoxCellType)
CreateContent Method (DefaultRenderer)
CreateContent Method (GeneralCellType)
CreateContent Method (HyperLinkRenderer)
CreateContent Method (ImageRenderer)
CreateContent Method (MultiColumnComboBoxCellType)
CreateContent Method (RadioButtonListCellType)
CreateContent Method (TagCloudRenderer)
CreateContent Method (TextCellType)
CreateContext Method
CreateDataModel Method (LayoutTemplate)
CreateDataModel Method (SheetView)
CreateDataSourceSelectArguments Method
CreateDesignView Method
CreateInstance Method (CellRangeConverter)
CreateInstance Method (DesignTimeCellTypeConverter)
CreateInstance Method (SpreadChartCollectionEditor)
CreateInstance Method (SpreadImageCollectionEditor)
CreateObjectInstanceAndDeserialize Method
CreateRowAxisModel Method (LayoutTemplate)
CreateRowAxisModel Method (SheetView)
CreateSelectionModel Method
CreateSpanModel Method (LayoutTemplate)
CreateSpanModel Method (SheetView)
CreateStyleModel Method
creating

custom function
custom names
skins
styles

CritBinomFunction Field
CSS

assigning to cell

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
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
CurrentPage Property
CurrentPageIndex Property
CurrentRating Property
CurrentSize Property
CurrentVisible Property
CursorType Enumeration
custom

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

custom functions
custom HTC files
custom names
custom skins
custom styles
custom text in headers
CustomFilterItem Class

Members
Overview

CustomFilterItem Constructor (CustomFilterItem)
CustomFilterOperatorType Enumeration
customized styles

overview

customizing

data model
graphical interface
selections

cut
data

searching
sorting

data area

appearance

data binding

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

data key

editor
editor

data model
data model

customizing
optional interfaces

data plot types
Data Property (IIndicator)
Data Property (IndicatorChangedEventArgs)
Data Property (Sparkline)
data set

binding to
binding to

data types

in formulas

DataAreaDefault Field
DataAreaDefault2 Field
DataAutoCellTypes Property

using

DataBarAxisPosition Enumeration
DatabarConditionalFormattingRule Class

Members
Overview

DatabarConditionalFormattingRule Constructor (DatabarConditionalFormattingRule)
database

binding to
binding to

database state management
DataBind Method
DataChanged Event (CellRangeSegmentData)
DataChanged Event (ISegmentData)
DataChanged Event (ISegmentMatrixData)
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
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 (StringCollectionCollection)
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 time cell type
DateCalendarCellType Class

Members
Overview

DateCalendarCellType Constructor (DateCalendarCellType)
DateDifFunction Field
DateFormat Property
DateFunction Field
DatePickerMode Enumeration
DatePickerMode Property
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 symbol in currency
DecimalDigits Property (DoubleCellType)
DecimalDigits Property (DoubleCellType.EditModeSettings)
DecimalDigits Property (PercentCellType)
Decimals Property
DecodeObject Method
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_COLUMN_NAME Field
DefaultColumnWidth Property
DefaultDeserializeProp Method
DefaultFilterItem Class

Members
Overview

DefaultFilterItem Constructor (DefaultFilterItem)
DefaultHeaderStyle Property
DefaultPage
DefaultRenderer Class

Members
Overview

DefaultRenderer Constructor (DefaultRenderer)
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
DeleteColumnCommand Event
DeleteCommand Event
DeleteContext Method
DeleteMethod
DeleteMethod Property (FpSpread)
DeleteMethod Property (SheetView)
DeleteRowCommand Event
deleting, See removing
deleting, See removing
DelimiterCharacters Property
DeltaFunction Field
Depth Property (PlotArea)
Depth Property (XYZPlotArea)
DescriptionUrl Property
Deserialize Method (Appearance)
Deserialize Method (AutoFilter)
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 (ConditionalFormat)
Deserialize Method (ConditionalFormatCollection)
Deserialize Method (CurrencyCellType)
Deserialize Method (CustomFilterItem)
Deserialize Method (DateTimeCellType)
Deserialize Method (DefaultFilterItem)
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 (FilterColumnDefinition)
Deserialize Method (FilterColumnDefinitionCollection)
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 (SpreadImage)
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
DesignString Property (FpSpread)
DesignString Property (SheetView)
DesignTimeCellTypeConverter Class

Members
Overview

DesignTimeCellTypeConverter Constructor (DesignTimeCellTypeConverter)
DesignTimeOnly Property
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
dimensions
Direction Property (DatabarConditionalFormattingRule)
Direction Property (GripHitTest)
DirectionalLight Class

Members
Overview

DirectionalLight Constructor (DirectionalLight)
DirectionX Property
DirectionY Property
DirectionZ Property
Disabled Property
DisabledImgUrl Property
DiscFunction Field
display data
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, See hiding
displaying, See hiding
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
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 (FloatingObject)
Dispose Method (FpChart)
Dispose Method (FpSpread)
Dispose Method (GroupDataModel)
Dispose Method (IGroupSupport)
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
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
DProductFunction Field
DragColumnCssClass Property
DragDirection Enumeration
dragging

columns

DragRowCssClass Property
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

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

Edit, client-side
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 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)
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

EditRow Property
EditTemplateColumnCount Property
EditValue Method (SpreadChartCollectionEditor)
EditValue Method (SpreadImageCollectionEditor)
EditValue Method (StringCollectionCollectionEditor)
EditValues Property
effect
EffectFunction Field
ElementIndex Property
elevation
Elevation Property
empty areas

appearance
headers

Empty Field (DataFieldChangedEventArgs)
Empty Field (LinearRange)
Empty Field (SegmentDataChangedEventArgs)
EmptyCellType Class

Members
Overview

EmptyCellType Constructor (EmptyCellType)
EmptyStarCssClass Property
EmptyValueMessage Property
EmptyValueStyle Enumeration
EmptyValueStyle Property
Enable Property
EnableAjaxCall Property (FormulaExtender)
EnableAjaxCall Property (FpSpread)
EnableCaching Property
EnableClickEvent Property (FloatingObject)
EnableClickEvent Property (FpChart)
EnableClientScript Property
EnableContextMenu Property
EnableCrossSheetReference Property
Enabled Property (AutoFilter)
Enabled Property (MenuItem)
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
EnhanceStringCollection Class

Members
Overview

EnsureDataBound Method
entity
EnumFormulas Property
EnumNotes Property
EnumRowFormulas Property
EnumTags Property
EnumValues Property
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)
ErfcFunction Field
ErfFunction Field
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
ErrorTypeFunction Field
ErrorValue Property
EuroConvertFunction Field
EuroFunction Field
Evaluate Method (BinaryOperatorInfo)
Evaluate Method (ConditionalFormatting)
Evaluate Method (FunctionInfo)
Evaluate Method (ICalcResolver)
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 formats
Excel formats
ExcelBaseSparkLineRenderer Class

Members
Overview

ExcelException Class

Members
Overview

ExcelException Constructor (ExcelException)
ExcelExceptionCode Enumeration
ExcelOpenFlags Enumeration
ExcelSaveFlag Enumeration (overview)
ExcelSaveFlags Enumeration
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

ExcelWarning Constructor (ExcelWarning)
ExcelWarningCode Enumeration
ExcelWarningList Class

Members
Overview

ExcelWarningList Constructor (ExcelWarningList)
exception handling
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

ExpandRow Method
ExpandRow, client-side
ExpandView command (client-side)
ExpFunction Field
ExponDistFunction Field
ExponentOperator Field
ExportExcel Event
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 (see regular expression cell type)
Expression Class

Members
Overview

ExpressionConsumerFormulaInfo Class

Members
Overview

ExpressionConsumerFormulaInfo Constructor (ExpressionConsumerFormulaInfo)
expressions

names in formulas

extender
ExtenderCellType Class

Members
Overview

ExtenderCellType Constructor (ExtenderCellType)
ExtenderCellTypeBase Class

Members
Overview

ExtenderCssClass Property
extenders

ASP.NET AJAX

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)
FactDoubleFunction Field
FactFunction Field
FalseFunction Field
FarPoint Spread for ASP.NET

Import and Export Reference

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.CalcEngine Assembly

Overview

FarPoint.CalcEngine Namespace

Overview

FarPoint.Excel Assembly

Overview

FarPoint.Excel 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 (ExcelWarningList)
FileName Property (SaveExcelEventArgs)
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

fill
Fill Class

Members
Overview

Fill Property (BoxWhiskerSeries)
Fill Property (ChartModel)
Fill Property (LabelArea)
Fill Property (LegendArea)
Fill Property (Stripe)
Fill Property (SunburstSeries)
Fill Property (TreemapSeries)
Fill Property (Wall)
Fill Property (WaterfallSeries)
FillCollection Class

Members
Overview

FillCollection Constructor (FillCollection)
FillColor Property
FilledStarCssClass Property
Fills Property (SunburstSeries)
Fills Property (TreemapSeries)
Fills Property (WaterfallSeries)
filter
filter
filter bar

customizing images

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 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

custom filter
enhanced
filter bar
hiding row
setting style

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
FilterMatchingMode Enumeration
FilterMatchingSource Enumeration
FilterMenuType Enumeration
FilterMode Property
Filters Property
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 (BaseSheetAxisModel)
FireChanged Method (BaseSheetDataModel)
FireChanged Method (BaseSheetStyleModel)
FireChanged Method (DefaultSheetAxisModel)
FireChanged Method (DefaultSheetDataModel)
FireChanged Method (DefaultSparklineContainer)
FireChanged Method (ExcelSparklineSetting)
FireChanged Method (GroupDataModel)
FireChanging Method
FireClearItems Method
Firefox

browser support

FireItemAdded Method
FireItemRemoved Method
FireItemUpdated Method
FirePropertyChanged Method
FireUpdated Method (BaseSparkline)
FireUpdated Method (ExcelSparklineGroup)
FireUpdated Method (ExcelSparklineSetting)
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
FixedFunction Field
FixedPoint Property (CurrencyCellType)
FixedPoint Property (CurrencyCellType.EditModeSettings)
FixedPoint Property (CurrencyFormatter)
FixedPoint Property (DoubleCellType)
FixedPoint Property (DoubleCellType.EditModeSettings)
FixedPoint Property (PercentCellType)
Flag Property
FlatColumnFooter Property
FlatColumnHeader Property
FlatRowHeader Property
floating image
FloatingObject Class

Members
Overview

FloatingObject Constructor (FloatingObject)
floating-point number (cell type)
FloorFunction Field
FlushData Method (FpSpread)
FlushData Method (SheetView)
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 (FpSpread)
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

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 (FpSpread)
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
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)
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 (ILabelFormatter)
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)
formatting

conditional
conditional
inheriting

formatting information (importing)
formula
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 (FormulaEntry)
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
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
FormulaEntries Property
FormulaEntry Class

Members
Overview

FormulaEntry Constructor (FormulaEntry)
FormulaEntryCollection Class

Members
Overview

FormulaEntryCollection Constructor (FormulaEntryCollection)
FormulaExtender Class

Members
Overview

FormulaExtender Constructor (FormulaExtender)
FormulaRestrictedCondition Enumeration
FormulaRestrictedException Class

Members
Overview

FormulaRestrictedException Constructor (FormulaRestrictedException)
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

FpCategoryAttribute Class

Members
Overview

FpCategoryAttribute Constructor (FpCategoryAttribute)
FpChart Class

Members
Overview

FpChart Constructor (FpChart)
FpChartBuilder Class

Members
Overview

FpChartBuilder Constructor (FpChartBuilder)
FpSpread Class

Members
Overview

FpSpread Constructor (FpSpread)
FpSpread Designer
FpSpread Property
fpspread.htc file
FpSpreadAdapter Property
FpSpreadTemplateReplacement Class

Members
Overview

FpSpreadTemplateReplacement Constructor (FpSpreadTemplateReplacement)
FrequencyFunction Field
From Property
frozen columns

overview
overview

frozen rows

overview
overview

FrozenColumnCount Property
FrozenIndicatorImage Field
FrozenRowCount Property
FTestFunction Field
Function Property
FunctionExpression Class

Members
Overview

FunctionExpression Constructor (FunctionExpression)
FunctionInfo Class

Members
Overview

FunctionName Property
functions

importing
custom
nesting in formula

FunnelSeries Class

Members
Overview

FunnelSeries Constructor (FunnelSeries)
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 (BoxWhiskerSeries)
GapWidth Property (CandlestickSeries)
GapWidth Property (ClusteredBarSeries)
GapWidth Property (ClusteredBoxWhiskerSeries)
GapWidth Property (FunnelSeries)
GapWidth Property (HighLowBarSeries)
GapWidth Property (HighLowCloseSeries)
GapWidth Property (HistogramBar)
GapWidth Property (HistogramSeries)
GapWidth Property (OpenHighLowCloseSeries)
GapWidth Property (StackedBarSeries)
GapWidth Property (WaterfallSeries)
GcdFunction Field
general cell type
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
GenerateSegmentMatrix Method
generic cell type (see general cell type)
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
GetCateGoryNames Method (SunburstSeries)
GetCategoryNames Method (TreemapSeries)
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 (CurrencyCellType)
GetDropDownControl Method (DateTimeCellType)
GetDropDownControl Method (DoubleCellType)
GetDropDownControl Method (IntegerCellType)
GetDropDownControl Method (PercentCellType)
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)
GetEditStyle Method (StringCollectionCollectionEditor)
GetEditStyle Method (StringCollectionItemEditor)
GetEditValue Method
GetEnumerator Method (AreaSeriesCollection)
GetEnumerator Method (BarSeriesCollection)
GetEnumerator Method (BaseSheetSelectionModel)
GetEnumerator Method (BaseSheetSpanModel)
GetEnumerator Method (BevelCollection)
GetEnumerator Method (BorderProperty)
GetEnumerator Method (BoxWhiskerSeriesCollection)
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 (StringCollectionCollection)
GetEnumerator Method (StringCollectionItem)
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
GetGroupIndex 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 (StringCollectionCollectionEditor)
GetItems Method (TagCloudRenderer)
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 (Appearance)
GetObjectData Method (AverageConditionalFormattingRule)
GetObjectData Method (Background)
GetObjectData Method (BaseSparkline)
GetObjectData Method (BetweenValuesConditionalFormattingRule)
GetObjectData Method (BinOption)
GetObjectData Method (BlankConditionalFormattingRule)
GetObjectData Method (Border)
GetObjectData Method (CellRange)
GetObjectData Method (ColumnSparklineRenderer)
GetObjectData Method (ConditionalFormat)
GetObjectData Method (ConditionalFormattingRule)
GetObjectData Method (ContextMenuStyle)
GetObjectData Method (DatabarConditionalFormattingRule)
GetObjectData Method (DefaultSheetAxisModel)
GetObjectData Method (DefaultSheetDataModel)
GetObjectData Method (DefaultSheetSelectionModel)
GetObjectData Method (DefaultSheetSpanModel)
GetObjectData Method (DefaultSheetStyleModel)
GetObjectData Method (DefaultSparklineContainer)
GetObjectData Method (ErrorConditionalFormattingRule)
GetObjectData Method (ExcelBaseSparkLineRenderer)
GetObjectData Method (ExcelSparkline)
GetObjectData Method (ExcelSparklineGroup)
GetObjectData Method (ExcelSparklineSetting)
GetObjectData Method (FormulaConditionalFormattingRule)
GetObjectData Method (GeneralFormatter)
GetObjectData Method (HighlightConditionalFormattingRule)
GetObjectData Method (IconSetConditionalFormattingRule)
GetObjectData Method (LineSparklineRenderer)
GetObjectData Method (NamedStyle)
GetObjectData Method (ParseException)
GetObjectData Method (PrePaintTextConditionalFormattingRule)
GetObjectData Method (PrintInfo)
GetObjectData Method (SheetSkin)
GetObjectData Method (StringCollectionCollection)
GetObjectData Method (StyleInfo)
GetObjectData Method (SunburstPlotArea)
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 (BoxWhiskerSeries)
GetSchema Method (BoxWhiskerSeriesCollection)
GetSchema Method (CandlestickSeries)
GetSchema Method (ChartModel)
GetSchema Method (ClusteredBarSeries)
GetSchema Method (ClusteredBoxWhiskerSeries)
GetSchema Method (DirectionalLight)
GetSchema Method (HighLowAreaSeries)
GetSchema Method (HighLowBarSeries)
GetSchema Method (HighLowCloseSeries)
GetSchema Method (HistogramSeries)
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 (SunburstPlotArea)
GetSchema Method (SunburstSeries)
GetSchema Method (TreemapPlotArea)
GetSchema Method (TreemapSeries)
GetSchema Method (ValueAxis)
GetSchema Method (ValueAxisCollection)
GetSchema Method (Wall)
GetSchema Method (WaterfallSeries)
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 (IMatrixData)
GetValue Method (IObjectExpressionSupport)
GetValue Method (ISegmentData)
GetValue Method (ISegmentMatrixData)
GetValue Method (ISheetDataModel)
GetValue Method (RowEditTemplateContainer)
GetValue Method (SheetView)
GetValue Method (SpreadDataColumnPropertyDescriptor)
GetValue Method (SunburstSeries)
GetValue Method (TreemapSeries)
GetValue, client-side
GetValueFromText Method
GetView Method
GetViewColumnFromModelColumn Method
GetViewNames Method
GetViewRowFromModelRow Method
GetVisible Method (BaseSheetAxisModel)
GetVisible Method (DefaultSheetAxisModel)
GetVisible Method (ISheetAxisModel)
GetVisibleCount Method
GetWeights Method
GetWeightStrings Method
GetWindowFontSyle 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 cell (see image cell type)
Graphics Property
gray areas (See empty areas)
GrayAreaCursorImageUrl Property
GrayAreaCursorType Property
GreaterThanOperator Field
GreaterThanOrEqualOperator Field
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
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

HandleCssClass Property
Handled Property (SheetViewStateEventArgs)
Handled Property (SpreadCommandEventArgs)
HandleImageUrl Property
HarMeanFunction Field
HasSpaceAfterFirstKeyword Property
HasSpaceBefore Property
Header Property (PrintEventArgs)
Header Property (PrintInfo)
Header Property (PrintMargin)
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

height

headers
rows

Height Property (Bevel)
Height Property (CircleBevel)
Height Property (ColumnFooter)
Height Property (ColumnHeader)
Height Property (FilterBar)
Height Property (FloatingObject)
Height Property (FpChart)
Height Property (LayoutRow)
Height Property (MenuItem)
Height Property (NoBevel)
Height Property (Row)
Height Property (TitleInfo)
Hex2BinFunction Field
Hex2DecFunction Field
Hex2OctFunction Field
hidden

cells when spanned

hidden cells
hidden columns

importing
importing

hidden rows

importing
importing

HideColumnCommand Event
HideMessage, client-side
HideMessage, client-side
HideRowCommand Event
HideRowFilter Class

Members
Overview

HideRowFilter Constructor (HideRowFilter)
hiding

columns
filtering rows
footer
grid lines
rows
sheets

HierarchicalView Property
hierarchy

bar
displaying data
expandable rows
grouping
views

hierarchy buttons
HierBar Property
HierBarInfo Class

Members
Overview

HierBarInfo Constructor (HierBarInfo)
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)
histogram
HistogramBar Class

Members
Overview

HistogramBar Constructor (HistogramBar)
HistogramLine Class

Members
Overview

HistogramLine Constructor (HistogramLine)
HistogramSeries Class

Members
Overview

HistogramSeries Constructor (HistogramSeries)
HitTest Class

Members
Overview

HitTest Method (Chart2DRenderer)
HitTest Method (Chart3DRenderer)
HitTest Method (FpChart)
HLookupFunction Field
HoleSize Property
HomePage
horizontal alignment
horizontal grid lines
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
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 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
ICalcResolver 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
IconSetConditionalFormattingRule Class

Members
Overview

IconSetConditionalFormattingRule Constructor (IconSetConditionalFormattingRule)
IconSetStyle Property
IconUrl Property
ICSSClassSupport Interface
ICustomFunctionSupport Interface
ICustomFunctionSupport2 Interface
ICustomNameSupport Interface
ICustomNameSupport2 Interface
ID Property (SpreadChart)
ID Property (SpreadImage)
IDataKeySupport Interface
IDataSourceSupport Interface
IDataSourceSupport2 Interface
IDateCellType Interface
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
ILabelFormatter Interface
ImAbsFunction Field
image
image button
image cell type
Image Property (ImageFill)
Image Property (PrintExternalImageEventArgs)
ImageAlign Property (FpChart)
ImageAlign Property (ImageCellType)
ImageAlign Property (ImageRenderer)
ImageButtonHoverColor Property
ImageButtonTheme Enumeration
ImageCellType Class

Members
Overview

ImageCellType Constructor (ImageCellType)
ImageDescriptionLabelID Property
ImageDirty Property (ImageRender)
ImageDirty Property (SpreadImageRender)
ImageFill Class

Members
Overview

ImageFill Constructor (ImageFill)
ImageRectangle Property
ImageRender Class

Members
Overview

ImageRender Property (FloatingObject)
ImageRender Property (FpChart)
ImageRenderer Class

Members
Overview

ImageRenderer Constructor (ImageRenderer)
images

changing command buttons
customizing in interface

Images Property (PrintInfo)
Images Property (SheetView)
ImageTitleLabelID Property
ImageTransferStorage Enumeration
ImageTransferStorage Property
ImageType Enumeration
ImageUrl Property (ButtonCellType)
ImageUrl Property (ButtonRenderer)
ImageUrl Property (FileImageRender)
ImageUrl Property (FloatingObject)
ImageUrl Property (HyperLinkCellType)
ImageUrl Property (HyperLinkRenderer)
ImageUrl Property (ImageCellType)
ImageUrl Property (ImageRenderer)
ImageUrl Property (MenuItem)
ImaginaryFunction Field
ImArgumentFunction Field
IMatrixData Interface
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
IMixSeries Interface
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
INamedStyleSupport Interface
INameSupport Interface
INameSupport2 Interface
IncludeCellLocked Property
IncludeHeaders Enumeration
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 (BoxWhiskerSeriesCollection)
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 (SpreadImageCollection)
IndexOf Method (StringCollection)
IndexOf Method (StringCollectionCollection)
IndexOf Method (StringCollectionItem)
IndexOf Method (StripeCollection)
IndexOf Method (ValueAxisCollection)
indicator

filtering

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
inheriting formatting
Init Method
InitialValue Property
InitPropArray Method
InitStyle Method
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 (BoxWhiskerSeriesCollection)
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 (SpreadImageCollection)
Insert Method (StringCollection)
Insert Method (StringCollectionCollection)
Insert Method (StringCollectionItem)
Insert Method (StripeCollection)
Insert Method (ValueAxisCollection)
Insert, client-side
InsertAt Method
InsertColumnCommand Event
InsertCommand Event
InsertMethod
InsertMethod Property (FpSpread)
InsertMethod Property (SheetView)
InsertRange Method (AreaSeriesCollection)
InsertRange Method (BarSeriesCollection)
InsertRange Method (BevelCollection)
InsertRange Method (BoxWhiskerSeriesCollection)
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 (StringCollectionCollection)
InsertRange Method (StringCollectionItem)
InsertRange Method (StripeCollection)
InsertRange Method (ValueAxisCollection)
InsertRowCommand Event
Inset Class

Members
Overview

Inset Constructor (Inset)
InstanceGuid Property (FloatingObject)
InstanceGuid Property (FpChart)
InStyle Property
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
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 (AutoFilter)
Interval Property (ScaleRule)
IntFunction Field
IntRateFunction Field
invalid entries
invalid parameter
InvalidateRowFilter Method (IFilterSupport)
InvalidateRowFilter Method (SheetView)
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
IsColorSet 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
ISegmentMatrixData 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)
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
IsFiltered Method (DefaultRowFilter)
IsFiltered Method (IRowFilter)
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
IsOverflowBin Property
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)
IsProtectedStructure Property
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
IsTotal Method
IsTrackingViewState Property (ContextMenu)
IsTrackingViewState Property (FormulaEntryCollection)
IsTrackingViewState Property (SheetView)
IsTrackingViewState Property (StateManaged)
IsUnderflowBin Property
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 (BoxWhiskerSeriesCollection)
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 (EnhanceStringCollection)
Item Property (ExcelSparklineGroup)
Item Property (ExcelWarningList)
Item Property (FillCollection)
Item Property (FilterColumnDefinitionCollection)
Item Property (FilterItemCollection)
Item Property (FormulaEntryCollection)
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 (SpreadImageCollection)
Item Property (StringCollection)
Item Property (StringCollectionCollection)
Item Property (StringCollectionItem)
Item Property (StripeCollection)
Item Property (TabInfo)
Item Property (TouchStripItemCollection)
Item Property (ValueAxisCollection)
Item Property (WorksheetLayoutCells)
ItemAdded Event (ExcelSparklineGroup)
ItemAdded Event (INotifyItemChanged)
ItemBackColor Property
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)
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)
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)
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 Property
Keyword Property
KurtFunction Field
label cell type
Label Property (Column)
Label Property (CreateButtonEventArgs)
Label Property (Row)
Label Property (Rows.DefaultRow)
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 (SunburstSeries)
LabelContainsCategoryName Property (TreemapSeries)
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 (BoxWhiskerSeries)
LabelContainsValue Property (LineSeries)
LabelContainsValue Property (PieSeries)
LabelContainsValue Property (PointSeries)
LabelContainsValue Property (RadarAreaSeries)
LabelContainsValue Property (RadarLineSeries)
LabelContainsValue Property (RadarPointSeries)
LabelContainsValue Property (SunburstSeries)
LabelContainsValue Property (TreemapSeries)
LabelContainsValue Property (WaterfallSeries)
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)
LabelOption Enumeration
LabelOption Property
labels

automatic text in headers
header text
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 (FunnelSeries)
LabelVisible Property (IndexAxis)
LabelVisible Property (PolarAngleAxis)
LabelVisible Property (PolarRadiusAxis)
LabelVisible Property (RadarIndexAxis)
LabelVisible Property (RadarValueAxis)
LabelVisible Property (Series)
LabelVisible Property (SunburstSeries)
LabelVisible Property (TreemapSeries)
LabelVisible Property (ValueAxis)
LabelVisible Property (WaterfallSeries)
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
LayoutMode Property
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
LeadColumn Property (BaseSheetSelectionModel)
LeadColumn Property (DefaultSheetSelectionModel)
LeadColumn Property (ISheetSelectionModel)
LeadRow Property (BaseSheetSelectionModel)
LeadRow Property (DefaultSheetSelectionModel)
LeadRow Property (ISheetSelectionModel)
Left Property (FloatingObject)
Left Property (Inset)
Left Property (PaddingF)
Left Property (PrintMargin)
Left Property (SpreadChart)
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
LessThanOperator Field
LessThanOrEqualOperator Field
Light Class

Members
Overview

LightCollection Class

Members
Overview

lighting
Lights Property
limiting

currency value

Line Class

Members
Overview

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 Property
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 button
list

radio buttons

list box cell type
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)
ListWidth Property (MultiColumnComboBoxCellType)
ListWidth Property (MultiColumnEditor)
LnFunction Field
Load Method
load on demand
load on demand

overview
overview

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 page
LoadInitRowCount Property (FpSpread)
LoadInitRowCount Property (SheetView)
LoadObject Method
LoadObjectXml Method
LoadOffsetFromBottom Property
LoadOnDemandInterval Property
LoadOnDemandMode Enumeration
LoadOnDemandMode Property
LoadOnDemandTriggerMode Enumeration
LoadOnDemandTriggerMode Property
LoadPostData Method (FpChart)
LoadPostData Method (SpreadImage)
LoadRowIncrement Property (FpSpread)
LoadRowIncrement Property (SheetView)
LoadTextFile Method (SheetView)
LoadTextFile Method (SpreadSerializer)
LoadViewState Method (ContextMenuCollection)
LoadViewState Method (FloatingObject)
LoadViewState Method (FormulaEntryCollection)
LoadViewState Method (FormulaExtender)
LoadViewState Method (FpChart)
LoadViewState Method (FpSpread)
LoadViewState Method (MapArea)
LoadViewState Method (SheetView)
LoadViewState Method (StateList<T>)
LoadViewState Method (StateManaged)
LoadViewState Method (TouchStripCollection)
Location Property (IndexAxis)
Location Property (LabelArea)
Location Property (LegendArea)
Location Property (PlotArea)
Location Property (ValueAxis)
LockBackColor Property
locked cells

importing
importing

Locked Field
Locked Property (AlternatingRow)
Locked Property (Cell)
Locked Property (Column)
Locked Property (NamedStyle)
Locked Property (Row)
Locked Property (StyleInfo)
LockForeColor Property
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 Field
Margin Property (AlternatingRow)
Margin Property (Cell)
Margin Property (Column)
Margin Property (PreviewRowInfo)
Margin Property (PrintInfo)
Margin Property (Row)
Margin Property (StyleInfo)
Margin Property (TitleInfo)
margins

cell

Marker Class

Members
Overview

MarkerCollection Class

Members
Overview

MarkerCollection Constructor (MarkerCollection)
MarkersColor Property
MarkerShape Enumeration
market
market chart
MarkupName Property
Mask Property
masked edit cell type
MaskedEditCellType Class

Members
Overview

MaskedEditCellType Constructor (MaskedEditCellType)
MaskedEditValidator Class

Members
Overview

MaskedEditValidator Constructor (MaskedEditValidator)
MaskType Property
MatchFunction Field
MatchingMode Property
MatchingSource Property
MaxAFunction Field
MaxArgs Property
MaxAxisType Property
MaxFilteredItem 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)
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

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
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)
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)
MinPrefixLength Property
MinuteFunction Field
MinValue Property (ThreeColorScaleConditionalFormattingRule)
MinValue Property (TwoColorScaleConditionalFormattingRule)
MInverseFunction Field
MIrrFunction Field
MissingArgumentExpression Class

Members
Overview

MissingArgumentExpression Constructor (MissingArgumentExpression)
MissingArgumentValue Property
MMultFunction Field
Mode Property
ModeFunction Field
model data binding
Model Property (FpChart)
Model Property (SpreadChart)
models

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

modes

operation

ModFunction Field
ModifyObjectExpression Method
MonthFormat Property
MonthFunction Field
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)
MoveColumn Method (FpSpread)
MoveColumn Method (SheetView)
MoveColumns Method
MoveFilters Method (DefaultRowFilter)
MoveFilters Method (IRowFilter)
MoveNext Method
MoveRow Method (FpSpread)
MoveRow Method (SheetView)
MoveRows Method
MoveToFirstColumn, client-side
MoveToLastColumn, client-side
MoveToNextCell, client-side
MoveToNextCellThenControl Property
MoveToNextRow, client-side
MoveToPrevCell, client-side
MoveToPrevCell, client-side
MoveToPreviousCellThenControl Property
MoveToSheetView Method
moving

columns

Mozilla Firefox

browser support

MRoundFunction Field
MultiColumnComboBoxCellType Class

Members
Overview

MultiColumnComboBoxCellType Constructor (MultiColumnComboBoxCellType)
MultiColumnEditor Class

Members
Overview

MultiColumnEditor Constructor (MultiColumnEditor)
Multiline Property (CurrencyCellType)
Multiline Property (DateTimeCellType)
Multiline Property (DoubleCellType)
Multiline Property (GeneralCellType)
Multiline Property (IntegerCellType)
Multiline Property (PercentCellType)
Multiline Property (RegExpCellType)
Multiline Property (TextCellType)
MultinomialFunction Field
multiple headers
multiple sheets
multiple sheets
multiple-column combo box
multiple-line columns
multiple-line columns
MultiplyOperator Field
MultiRangeExpression Class

Members
Overview

MultiValuesFilterItem Class

Members
Overview

MultiValuesFilterItem Constructor (MultiValuesFilterItem)
MutuallyExclusiveCheckBoxCellType Class

Members
Overview

MutuallyExclusiveCheckBoxCellType Constructor (MutuallyExclusiveCheckBoxCellType)
mvc
mvc
mydatetype.htc
NAFunction Field
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 styles

editor
editor

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

NavigateUrl Property (HyperLinkCellType)
NavigateUrl Property (HyperLinkRenderer)
navigation

page nav buttons

NegateOperator Field
NegativeBorder Property
NegativeBorderColor Property
NegativeBorders Property
NegativeColor Property
NegativeFill Property
NegativeFillColor Property
NegativeFills Property
NegativeRed Property
NegativeVisible Property
NegBinomDistFunction Field
nesting functions
NetWorkdaysFunction Field
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)
NFunction Field
NoBevel Class

Members
Overview

NoBevel Constructor (NoBevel)
NoFill Class

Members
Overview

NoFill Constructor (NoFill)
NoLine Class

Members
Overview

NoLine Constructor (NoLine)
NoMarker Class

Members
Overview

NoMarker Constructor (NoMarker)
NominalFunction Field
NonBlanks (filtering list item)
NonBlanks (filtering list item)
NonBlanksString Property (DefaultRowFilter)
NonBlanksString Property (IRowFilter)
None Field
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

NormDistFunction Field
NormInvFunction Field
NormSDistFunction Field
NormSInvFunction Field
NotANumberAsZero Property
NotAvailable Property
Note Property
NotEqualOperator Field
notes

cells
importing Excel comments

NotFunction Field
NotifyChanged Method
NotifyDataChanged Method
NotifyFormulaChanged Method
NotifyNotSatisfied Method
NotifyRequiresChanged Method
NowFunction Field
NPerFunction Field
NpvFunction Field
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 pad
Number Property
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)
numeric cell type
NumericUpDownCellType Class

Members
Overview

NumericUpDownCellType Constructor (NumericUpDownCellType)
object models
object models
object parentage
ObjectExpressionProvider Property
Objects Property
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
OnAdd Method
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
OnButtonCmd Method
onCallBackStart, client-side
onCallBackStopped, client-side
OnCancel Method
OnCellClick Method
OnChanged Method (AreaSeriesCollection)
OnChanged Method (Axis)
OnChanged Method (BarSeriesCollection)
OnChanged Method (BaseSheetAxisModel)
OnChanged Method (BaseSheetDataModel)
OnChanged Method (BaseSheetStyleModel)
OnChanged Method (BevelCollection)
OnChanged Method (BinOption)
OnChanged Method (BoxWhiskerSeriesCollection)
OnChanged Method (ChartModel)
OnChanged Method (ConditionalFormattingModel)
OnChanged Method (DefaultSheetDataModel)
OnChanged Method (DefaultSparklineContainer)
OnChanged Method (DetachmentCollection)
OnChanged Method (DoubleCollection)
OnChanged Method (DoubleCollectionCollection)
OnChanged Method (FillCollection)
OnChanged Method (HistogramSeries)
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 (StringCollectionCollection)
OnChanged Method (StringCollectionItem)
OnChanged Method (Stripe)
OnChanged Method (StripeCollection)
OnChanged Method (ValueAxisCollection)
OnChanged Method (Wall)
OnChanged Method (YPlotArea)
OnChanging Method
OnChildView Method
OnClear Method
OnClearComplete Method
OnClearItems Method
OnClick Method (FloatingObject)
OnClick Method (FpChart)
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
OnColumnHeaderClick Method
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 (DefaultRowFilter)
OnDataModelChanged Method (SheetView)
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)
OnDataSourceViewChanged Method
OnDelete Method
OnDeserialization Method
OnDeserialize Method (ContextMenu)
OnDeserialize Method (MenuItem)
OnDeserialize Method (TouchStrip)
OnDeserializeElement Method (MenuItem)
OnDeserializeElement Method (TouchStripItem)
one-based ref.s

in formulas

OnEdit Method
onEditStart, client-side
onEditStopped, client-side
onErrorMessageShown, client-side
OnExpandView Method
OnFilterColumnDefinitionCollectionChanged Method
OnFirstPage Method
OnFocusCssClass Property
OnFocusCssNegative Property
OnInit Method (FormulaExtender)
OnInit Method (FpChart)
OnInit Method (FpSpread)
OnInit Method (SpreadDataSource)
OnInsert Method (FpSpread)
OnInsert Method (SheetViewCollection)
OnInsert Method (SpreadChartCollection)
OnInsert Method (SpreadImageCollection)
OnInsertComplete Method (SheetViewCollection)
OnInsertComplete Method (SpreadDataColumnCollection)
OnItemAdded Method
OnItemRemoved Method
OnItemUpdated Method
OnLastPage Method
OnListChanged Method (ConditionalFormattingIconRuleSet)
OnListChanged Method (ContextMenuCollection)
OnListChanged Method (MenuItemCollection)
OnListChanged Method (PlotAreaCollection)
OnListChanged Method (SeriesCollection)
OnListChanged Method (SpreadDataView)
OnListChanged Method (TouchStripItemCollection)
OnLoad Method (FloatingObject)
OnLoad Method (FormulaExtender)
OnLoad Method (FpChart)
OnLoad Method (FpSpread)
OnLoad Method (SpreadDataSource)
OnLoadOnDemand Method
onLoadRowsStart, client-side
onLoadRowsStopped, client-side
OnMapAreaClick Method
onMenuClicked, client-side
OnMenuItemClicked Method
OnNamedStyleChanged Method
OnNextPage Method
OnPage Method
OnPreRender Method (FpChart)
OnPreRender Method (FpSpread)
OnPreRender Method (FpSpreadTemplateReplacement)
OnPreRender Method (PreviewRowTemplateContainer)
OnPreRender Method (RowEditTemplateContainer)
OnPreRender Method (SpreadChart)
OnPrevPage Method
OnPrint Method
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)
OnRemove Method (SpreadImageCollection)
OnRemoveColumnFooterRows Method
OnRemoveColumnHeaderRows Method
OnRemoveColumns Method (LayoutTemplate)
OnRemoveColumns Method (SheetView)
OnRemoveComplete Method (SheetViewCollection)
OnRemoveComplete Method (SpreadDataColumnCollection)
OnRemoveRowHeaderColumns Method
OnRemoveRows Method (LayoutTemplate)
OnRemoveRows Method (SheetView)
OnRowHeaderClick Method
onRowHeightChanged, client-side
OnSaveExcel Method
onScroll, client-side
OnSelect Method
onSelectionChanged, client-side
OnSelectView Method
OnSerialize Method (ContextMenu)
OnSerialize Method (MenuItem)
OnSerialize Method (TouchStrip)
OnSerialize Method (TouchStripItem)
OnSet Method
OnSetComplete Method (SheetViewCollection)
OnSetComplete Method (SpreadDataColumnCollection)
OnSortColumn Method
OnStyleModelChanged Method
OnTabLeft Method
OnTabRight Method
onTouchStripClosed
OnTouchStripItemClicked Method
onTouchStripOpened
onTouchStripOpening
OnUnload Method (FloatingObject)
OnUnload Method (FpChart)
OnUpdate Method
OnUpdated Method (BaseSparkline)
OnUpdated Method (ExcelSparklineGroup)
OnUpdated Method (ExcelSparklineSetting)
OnUpdateDownLevel Method
OnUpdateRenderEditors Method
OnUpdateRowEditTemplate Method
OnUpdateUpperLevel Method
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

OpenValues Property (CandlestickSeries)
OpenValues Property (OpenHighLowCloseSeries)
OpenXml Method
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

option button list (see radio button list)
optional

interfaces

options

regional

order of precedence
Ordinal Property
OrFunction Field
orientation

printing

Orientation Property (DefaultSheetAxisModel)
Orientation Property (PrintInfo)
Orientation Property (SliderCellType)
Origin Property (AreaSeries)
Origin Property (BarSeries)
Origin Property (ClusteredBarSeries)
OrthogonalProjection Class

Members
Overview

OrthogonalProjection Constructor (OrthogonalProjection)
Outlook-style grouping
Outlook-style grouping
OutStyle Property
OverFlowValue Property
Overlap Property (ClusteredBarSeries)
Overlap Property (ClusteredBoxWhiskerSeries)
Overline Property
OverlineFontStyle Enumeration
overview
Owner Property (DefaultSparklineContainer)
Owner Property (ISparklineContainer)
padding

See cell margins

Padding Property (LabelArea)
Padding Property (LegendArea)
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

buttons
buttons
position
settings

page size
PageBreak Field
PageBreak Property (Column)
PageBreak Property (PrintEventArgs)
PageBreak Property (Row)
PageCount Property
PageEnd Property
PageIndex Property (SpreadChart)
PageIndex Property (SpreadImage)
PageMaxAlign Property
PageNumber Property
PageOrder Property
Pager Property (CreateChildViewEventArgs)
Pager Property (FpSpread)
PagerInfo Class

Members
Overview

PagerInfo Constructor (PagerInfo)
PagerMode Enumeration
PagerPosition Enumeration
pages

defined
size (number of rows)

PageSize Property
PageStart Property
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
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
Pareto chart
ParetoLine Property
ParetoSeries Class

Members
Overview

ParetoSeries Constructor (ParetoSeries)
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)
parts

Web Parts

password
Password Property (SaveExcelEventArgs)
Password Property (TextCellType)
paste
Paste, client-side
pdf files

saving to

PdfFileName Property
PdfSecurity Property
PearsonFunction Field
percent cell type
Percent Property (StackedAreaSeries)
Percent Property (StackedBarSeries)
Percent Property (StackedLineSeries)
Percent Property (StackedPointSeries)
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 cell (see image cell type)
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 (AxisInfo)
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)
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 (HistogramLine)
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

popup
PopupPosition Property
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
postbacks

limiting

posting back
PowerFunction Field
PpmtFunction Field
precedence

order of

pre-defined

CallBack commands

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

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

ProductFunction Field
Professional1 Property
Professional2 Property
Professional3 Property
programming

client-side

Projection Class

Members
Overview

Projection Constructor (Projection)
Projection Property
PromptCharacter Property
ProperFunction Field
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
protecting cells
PvFunction Field
QuartileCalculationType Enumeration
QuartileFunction Field
QuartileMethod Property
QuartileMethodType Enumeration
QuotientFunction Field
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
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 (FpChart)
RaisePostBackEvent Method (SpreadImage)
RaisePostDataChangedEvent Method (FpChart)
RaisePostDataChangedEvent Method (SpreadImage)
RaisePropertyChanged Method
RandBetweenFunction Field
RandFunction Field
range

of cells
searching
sorting

range of cells

custom name

RangeElement<T> Class

Members
Overview

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

Members
Overview

RangeExpression Constructor (RangeExpression)
RangeRemoved Property
Ranges Property
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
RatingAlign Property
RatingCellType Class

Members
Overview

RatingCellType Constructor (RatingCellType)
RatingDirection Property
ReadOnly Property
ReadXml Method (AreaSeries)
ReadXml Method (AreaSeriesCollection)
ReadXml Method (BarSeries)
ReadXml Method (BarSeriesCollection)
ReadXml Method (BoxWhiskerSeries)
ReadXml Method (BoxWhiskerSeriesCollection)
ReadXml Method (CandlestickSeries)
ReadXml Method (ChartModel)
ReadXml Method (ClusteredBarSeries)
ReadXml Method (ClusteredBoxWhiskerSeries)
ReadXml Method (DirectionalLight)
ReadXml Method (HighLowAreaSeries)
ReadXml Method (HighLowBarSeries)
ReadXml Method (HighLowCloseSeries)
ReadXml Method (HistogramBar)
ReadXml Method (HistogramLine)
ReadXml Method (HistogramSeries)
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 (SunburstPlotArea)
ReadXml Method (SunburstSeries)
ReadXml Method (TreemapPlotArea)
ReadXml Method (TreemapSeries)
ReadXml Method (ValueAxis)
ReadXml Method (ValueAxisCollection)
ReadXml Method (Wall)
ReadXml Method (WaterfallSeries)
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

ReceivedFunction Field
RecreateControl Method
recursive

formula

reference

cell
circular

Reference Property
ReferenceError Property (CellRangeSegmentData)
ReferenceError Property (ExcelSparkline)
ReferenceError Property (ExcelSparklineGroup)
ReferenceError Property (ExcelSparklineSetting)
ReferenceError Property (ISheetCellRangeSupport)
ReferenceExpression Class

Members
Overview

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
RegisterSingleCss Method
RegisterSingleScript Method
Regroup Method
regular expression cell type
RegularBoldItalic Property
RegularBoldItalicFontStyle Enumeration
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 (BoxWhiskerSeriesCollection)
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 (FormulaEntryCollection)
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 (SpreadImageCollection)
Remove Method (StringCollection)
Remove Method (StringCollectionCollection)
Remove Method (StringCollectionItem)
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 (BoxWhiskerSeriesCollection)
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 (StringCollectionCollection)
RemoveAt Method (StringCollectionItem)
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)
RemovedControl Method
RemoveFormula Method
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

Render Method (FloatingObject)
Render Method (FpChart)
Render Method (FpSpread)
Render Method (FpSpreadTemplateReplacement)
Render Method (SpreadChart)
Render Method (SpreadDataSource)
Render Method (SpreadImage)
RenderAreaMaps Method (FpChart)
RenderAreaMaps Method (SpreadChart)
RenderBeginTag Method
RenderChildren Method
RenderControl Method
RenderCoveredCell Property
RenderCSSClass Property
RenderEditors Property
RenderEndTag Method
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)
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

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
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)
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)
ResetFilteredColumn Method
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)
ResetOverFlowValue Method
ResetParent Method
ResetProperty Method (BaseSheetAxisModel)
ResetProperty Method (DefaultSheetAxisModel)
ResetProperty Method (ISheetAxisModel)
ResetRenderer Method
ResetTabStop Method (Cell)
ResetTabStop Method (Column)
ResetTabStop Method (Row)
ResetTabStop Method (StyleInfo)
ResetTag Method
ResetText Method
ResetUnderFlowValue Method
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

Resolve Method
Result Property
Resume Method
ResumeFormulaParsing Method (DefaultSparklineContainer)
ResumeFormulaParsing Method (ISuspendFormulaParsing)
ResumeLayout client-side
ResumeListeningDataModel Method
RetainSelectionBlock Property
returning

data

Reverse Property (IndexAxis)
Reverse Property (PolarAngleAxis)
Reverse Property (PolarRadiusAxis)
Reverse Property (RadarIndexAxis)
Reverse Property (RadarValueAxis)
Reverse Property (ValueAxis)
Reversed Property
Right Property (Inset)
Right Property (PaddingF)
Right Property (PrintMargin)
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

overview

row headers

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

row height

importing
importing

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
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 (IMatrixData)
RowCount Property (ISegmentMatrixData)
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
RowHeaderSpanModel Property
RowHeaderStyleModel Property
RowHeaderVisible Property
RowHeaderWidth Property
RowIndex Property
RowRelative Property (CellExpression)
RowRelative Property (ExternalCellExpression)
RowRelative Property (ExternalRangeExpression)
RowRelative Property (ExternalReferenceExpression)
RowRelative Property (RangeExpression)
RowRelative Property (ReferenceExpression)
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.DefaultRow Class

Members
Overview

RowsFunction Field
RowSpan Property (Cell)
RowSpan Property (LayoutCell)
RowStart Property
RowTemplate Property
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)
SaveChanges method
SaveChanges method
SaveControlState Method
SaveExcel Method
SaveExcelEventArgs Class

Members
Overview

SaveExcelEventArgs Constructor (SaveExcelEventArgs)
SaveExcelEventHandler Delegate
SaveExcelToResponse Method
SaveHtml Method
SaveImageToBytes Method
SaveObject Method
SaveOrLoadSheetState Event
SavePdf Method
SavePdfToResponse Method
SaveTextFile Method
SaveTextFileRange Method
SaveToTemplate Method
SaveViewState Method (ContextMenuCollection)
SaveViewState Method (FloatingObject)
SaveViewState Method (FormulaEntryCollection)
SaveViewState Method (FormulaExtender)
SaveViewState Method (FpChart)
SaveViewState Method (FpSpread)
SaveViewState Method (MapArea)
SaveViewState Method (SheetView)
SaveViewState Method (StateList<T>)
SaveViewState Method (StateManaged)
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
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

importing from Excel
colors
displaying
importing from Excel
policy¶

ScrollBar3DLightColor Property
ScrollBarArrowColor Property
ScrollBarBaseColor Property
ScrollBarDarkShadowColor Property
ScrollBarFaceColor Property
ScrollBarHighlightColor Property
ScrollBarPolicy Enumeration
ScrollBarShadowColor Property
ScrollBarTrackColor Property
ScrollIncrement Property
scrolling, client side
ScrollingContentColumns Property
ScrollingContentHiddenDelay Property
ScrollingContentMaxHeight Property
ScrollingContentVisible Property
ScrollTo client-side
Search Method
SearchFoundFlags Enumeration
SearchFunction Field
SearchHeaders Method
searching
searching
SecondCondition Property
SecondFormula Property
SecondFunction Field
SecondValue Property
security
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)
selection

effect of EnableClientScript

Selection model
Selection model
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

SelectMethod
SelectMethod Property (FpSpread)
SelectMethod Property (SheetView)
SelectView command (client-side)
separator

currency

Seperator Property
Serialize Method (Appearance)
Serialize Method (AutoFilter)
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 (ConditionalFormat)
Serialize Method (ConditionalFormatCollection)
Serialize Method (CurrencyCellType)
Serialize Method (CustomFilterItem)
Serialize Method (DateTimeCellType)
Serialize Method (DefaultFilterItem)
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 (FilterColumnDefinition)
Serialize Method (FilterColumnDefinitionCollection)
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 (SpreadImage)
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 (DefaultSheetDataModel)
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)
SerializeSettings Method
SerializeString Method
SerializeStringArray Method
SerializeStyles Method
Series Class

Members
Overview

Series Property (ClusteredBarSeries)
Series Property (ClusteredBoxWhiskerSeries)
Series Property (ICompositeSeries)
Series Property (IMixSeries)
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)
SeriesElementHitTest Class

Members
Overview

SeriesElementHitTest Constructor (SeriesElementHitTest)
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 (HistogramSeries)
SeriesName Property (IIndicator)
SeriesName Property (IndicatorChangedEventArgs)
SeriesName Property (ParetoSeries)
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)
SetAnchor Method (BaseSheetSelectionModel)
SetAnchor Method (DefaultSheetSelectionModel)
SetAnchor Method (ISheetSelectionModel)
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)
SetColumnFilterBy Method
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)
SetFilteredColumn Method
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
SetIsFiltered 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)
SetProtect Method
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)
settings

appearance
composite
regional
scroll bars

SetTotal Method
SetTotals Method
SetupEventHandlers Method
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)
Shape Property (BuiltinMarker)
Shape Property (MapArea)
shapes
SharePoint
sheet corner
sheet corner

customizing
styles

sheet name tabs

default names

Sheet Property (ExcelWarning)
Sheet Property (PreviewRowTemplateContainer)
Sheet Property (RowEditTemplateContainer)
sheet skins
sheet skins

editor
editor
overview

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
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 (SpreadImage)
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)
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)
ShowConnectorLine Property
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)
ShowExcelButton Property
ShowExcelSecurityPopup Property
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)
ShowInnerPoints Property
ShowLast Property
ShowLow Property
ShowMarkers Property
ShowMeanLine Property
ShowMeanMarkers Property
ShowNegative Property
ShowOutlierPoints Property
ShowParentRow Property
ShowPDFButton Property
ShowPDFSecurityPopup Property
ShowPopupButton Property (BaseDropDownCellType)
ShowPopupButton Property (CurrencyCellType)
ShowPopupButton Property (DateCalendarCellType)
ShowPopupButton Property (DateTimeCellType)
ShowPopupButton Property (DoubleCellType)
ShowPopupButton Property (IntegerCellType)
ShowPopupButton Property (PercentCellType)
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
SinhFunction Field
Size Field
size of control

effect of EnableClientScript

Size Property (BuiltinMarker)
Size Property (GeneralEditor)
Size Property (PlotArea)
SizeRepresentsArea Property
SizeToFit client-side
SizeValues Property
SkewFunction Field
skins

applying
creating
editor
editor
overview

Skins Field
Skip Property
slide show 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)
SolidFill Class

Members
Overview

SolidFill Constructor (SolidFill)
SolidLine Class

Members
Overview

SolidLine Constructor (SolidLine)
sort indicators

customizing

Sort Method (GroupDataModel)
Sort Method (SheetView)
SortAscendingImage Field
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

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

SortOrder Enumeration
SortOrder Property (TagCloudCellType)
SortOrder Property (TagCloudRenderer)
SortRows Method
SortType Enumeration
Source Property (ExternalCellExpression)
Source Property (ExternalNameExpression)
Source Property (ExternalRangeExpression)
Source Property (ExternalReferenceExpression)
spaces

in text cell

spacing

between group names
cell

span model
span model
SpanModel Property
spanned cells

importing
importing

spanning cells
spanning cells
spans

column headers
row headers

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 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 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

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
SpreadImage Class

Members
Overview

SpreadImage Constructor (SpreadImage)
SpreadImageCollection Class

Members
Overview

SpreadImageCollection Constructor (SpreadImageCollection)
SpreadImageCollectionEditor Class

Members
Overview

SpreadImageCollectionEditor Constructor (SpreadImageCollectionEditor)
SpreadImageRender Class

Members
Overview

SpreadImageRender Constructor (SpreadImageRender)
SpreadImages Enumeration
SpreadPanningMode Enumeration
SpreadSerializer Class

Members
Overview

SpreadSerializer Constructor (SpreadSerializer)
spreadsheet objects
SpreadSparklineRenderes Class

Members
Overview

SpreadSparklineRenderes Constructor (SpreadSparklineRenderes)
SQL database

state management

SqrtFunction Field
SqrtPiFunction Field
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
Start Field
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>)
StateManaged Class

Members
Overview

StateManaged Constructor (StateManaged)
StDevAFunction Field
StDevFunction Field
StDevPAFunction Field
StDevPFunction Field
Step Property
Steps Property
StEyxFunction Field
StopButtonText Property
StopIfTrue Property (HighlightConditionalFormattingRule)
StopIfTrue Property (IStopablePrePaintConditionalFormattingRule)
StopPainting Property
streams

opening Excel files

Strikeout Property
StrikeoutFontStyle Enumeration
StringCollection Class

Members
Overview

StringCollection Constructor (StringCollection)
StringCollectionCollection Class

Members
Overview

StringCollectionCollection Constructor (StringCollectionCollection)
StringCollectionCollectionEditor Class

Members
Overview

StringCollectionCollectionEditor Constructor (StringCollectionCollectionEditor)
StringCollectionItem Class

Members
Overview

StringCollectionItem Constructor (StringCollectionItem)
StringCollectionItemEditor Class

Members
Overview

StringCollectionItemEditor Constructor (StringCollectionItemEditor)
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

style model
style model
Style Property (ConditionalFormat)
Style Property (GradientFill)
Style Property (PrePaintResult)
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
SubSeriesIndex Property
SubstituteFunction Field
subtitles

sheet

SubtotalFunction Field
SubtractOperator Field
Success Property (PrePaintResult)
Success Property (PrePaintTextResult)
SumFunction Field
SumIfFunction Field
SumIfsFunction Field
SumProductFunction Field
SumSqFunction Field
SumX2MY2Function Field
SumX2PY2Function Field
SumXMY2Function Field
SunburstPlotArea Class

Members
Overview

SunburstPlotArea Constructor (SunburstPlotArea)
SunburstSeries Class

Members
Overview

SunburstSeries Constructor (SunburstSeries)
support

browsers

SupportFilteredOutRowList Property
SurfaceFill Property
SurfaceLine Property
Suspend Method
SuspendFormulaParsing Method (DefaultSparklineContainer)
SuspendFormulaParsing Method (ISuspendFormulaParsing)
SuspendGrouping Property
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)
SydFunction Field
SyncRoot Property (DefaultStyleCollection)
SyncRoot Property (GroupInfoCollection)
SyncRoot Property (NamedStyleCollection)
SyncRoot Property (SmartPrintRulesCollection)
Tab key

handling

Tab Property
TabControlPolicy Enumeration
TabControlPolicy Property
tab-delimited files
TabIndex Property (ChartMapArea)
TabIndex Property (FpSpread)
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

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 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

TanFunction Field
TanhFunction Field
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

text

automatic header
column headers
column headers
row headers
row headers

text box

cell type

text cell (see general cell type)
text cell type
text file
text files

loading from
opening
saving to

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 tips
TextAlign Property (CheckBoxCellType)
TextAlign Property (CheckBoxEditor)
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
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
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

toolbars

formula

ToolTip Property (HyperLinkCellType)
ToolTip Property (HyperLinkRenderer)
ToolTip Property (MapArea)
TooltipText Property
Top Property (FloatingObject)
Top Property (Inset)
Top Property (PaddingF)
Top Property (PrintMargin)
Top Property (SpreadChart)
top row

setting

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)
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
TrackViewState Method (FormulaEntryCollection)
TrackViewState Method (FormulaExtender)
TrackViewState Method (FpSpread)
TrackViewState Method (MapArea)
TrackViewState Method (StateManaged)
TransferId Property
TransferImage Method (FileImageRender)
TransferImage Method (HttpHandlerImageRender)
TransferImage Method (ImageRender)
TransferImage Method (ISparklineSupportHandler)
TransferImage Method (SpreadImageRender)
TransposeFunction Field
TreemapPlotArea Class

Members
Overview

TreemapPlotArea Constructor (TreemapPlotArea)
TreemapSeries Class

Members
Overview

TreemapSeries Constructor (TreemapSeries)
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 (AxisInfo)
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

UIVirtualization Property
UnaryComparisonConditionalFormattingRule Class

Members
Overview

UnaryComparisonConditionalFormattingRule Constructor (UnaryComparisonConditionalFormattingRule)
UnaryComparisonOperator Enumeration
UnaryOperatorExpression Class

Members
Overview

UnaryOperatorExpression Constructor (UnaryOperatorExpression)
UnaryOperatorInfo Class

Members
Overview

unbound rows

adding

UnBoundNewRowIndex Property
Unchanged Field
UncheckedImageUrl Property (CheckBoxCellType)
UncheckedImageUrl Property (CheckBoxRenderer)
UnderFlowValue Property
Underline Property
UnderlineFontStyle Enumeration
UnfilteredRows Property (DefaultRowFilter)
UnfilteredRows Property (IRowFilter)
Ungrouped Event
UnGroupSparkline Method (Cell)
UngroupSparkline Method (SheetView)
UnhideColumnCommand Event
UnhideRowCommand Event
UnionOperator Field
UnionOperatorInfo Class

Members
Overview

UnionOperatorInfo Constructor (UnionOperatorInfo)
UniqueOrDuplicatedConditionalFormattingRule Class

Members
Overview

UniqueOrDuplicatedConditionalFormattingRule Constructor (UniqueOrDuplicatedConditionalFormattingRule)
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
Update Property
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

UpdateSpread Property
UpdateView Method
updating

formulas automatically

UpFill Property
UpFills Property
uplevel browser
UpLine Property
UpLines Property
UpperFunction Field
Uri Property
UsableParseFormat Property
UseClipboard Property
UseContextKey Property
UseMax Property
UseNegativeBorderColor Property
UseNegativeFillColor Property
User Controls
user interaction

customizing
customizing

user selection
UserDateFormat Property
user-defined functions
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

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 Property (AreaSeries)
Values Property (BarSeries)
Values Property (BoxWhiskerSeries)
Values Property (ComboBoxCellType)
Values Property (ComboBoxEditor)
Values Property (HistogramSeries)
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 (SunburstSeries)
Values Property (TreemapSeries)
Values Property (WaterfallSeries)
Values Property (XYZSurfaceSeries)
ValuesCount Property
ValuesRequires Property
VarAFunction Field
VarFunction Field
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 Property (LegendArea)
Vertical Property (SeriesDataField)
Vertical Property (YPlotArea)
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
viewcolumn Field
viewrow Field
ViewState Property (FormulaEntryCollection)
ViewState Property (MenuItem)
ViewState Property (StateManaged)
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 (FloatingObject)
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 (SpreadImage)
Visible Property (TitleInfo)
Visible Property (Wall)
VisibleCount Property
visual
Visual Basic scripting
VLookupFunction Field
vs2012
WaitingStarCssClass Property
WaitMessage Property
wall
Wall Class

Members
Overview

Wall Constructor (Wall)
Wall Property
WarningList Property
waterfall
WaterfallSeries Class

Members
Overview

WaterfallSeries Constructor (WaterfallSeries)
watermark

cell type

watermark text box
WatermarkCssClass Property
WatermarkText Property
Web Forms spreadsheet component
Web Parts
WeekdayFunction Field
WeekNumFunction Field
WeibullFunction Field
Weight Property
Weights Property
Welcome to FarPoint Spread for ASP.NET
width

columns
headers

Width Property (Bevel)
Width Property (CircleBevel)
Width Property (Column)
Width Property (ContextMenu)
Width Property (FloatingObject)
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)
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
WriteXml Method (AreaSeries)
WriteXml Method (AreaSeriesCollection)
WriteXml Method (BarSeries)
WriteXml Method (BarSeriesCollection)
WriteXml Method (BoxWhiskerSeries)
WriteXml Method (BoxWhiskerSeriesCollection)
WriteXml Method (CandlestickSeries)
WriteXml Method (ChartModel)
WriteXml Method (ClusteredBarSeries)
WriteXml Method (ClusteredBoxWhiskerSeries)
WriteXml Method (DirectionalLight)
WriteXml Method (HighLowAreaSeries)
WriteXml Method (HighLowBarSeries)
WriteXml Method (HighLowCloseSeries)
WriteXml Method (HistogramSeries)
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 (SunburstPlotArea)
WriteXml Method (SunburstSeries)
WriteXml Method (TreemapPlotArea)
WriteXml Method (TreemapSeries)
WriteXml Method (ValueAxis)
WriteXml Method (ValueAxisCollection)
WriteXml Method (Wall)
WriteXml Method (WaterfallSeries)
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, 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 (SpreadChart)
ZIndex Property (SpreadImage)
ZoomFactor Property
ZTestFunction Field
ZValues Property (XYZLineSeries)
ZValues Property (XYZPointSeries)