Spread for ASP.NET 13 Product Documentation
Index
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
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 (TouchStripCollection)
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)