Spread.Services Documentation
Developer's Guide
Get Started
Product Requirements
Installing the Product
Spread.Services License Information
Apply License to Spread.Services
End User License Agreement
Handle Redistribution
Understand the Product
Product Overview
Features Overview
Comments
Chart
Conditional Format
Data Validation
Formula
Group
Hyperlinks
Page Setup
Shape and Picture
Style
Sparkline
Theme
Table
Namespaces Overview
Customize User Interaction
Manage Workbook
Create Workbook
Open, Save and Protect Workbook
Cut or Copy Across Sheets
Enable or Disable Calculation Engine
Apply Theme
Manage Worksheet
Work with Worksheets
Range Operations
Insert And Delete Cell Ranges
Cut or Copy Cell Ranges
Merge Cells
Get Range and Range Area
Insert and Delete Rows and Columns
Work with Used Range
Freeze Panes in a Worksheet
Work with Shape And Picture
Customize Worksheets
Allow Sort
Apply Filters
Manage Hyperlinks
Apply Grouping
Create Row or Column Group
Remove a Group
Set Summary Row
Apply Style
Set Sheet Styling
Create and Set Custom Named Style
Apply Comments
Manage Formulas
Set Formula to Range
Set Table Formula
Set Array Formula
Manage Data in Spread Component
Use Chart
Create and Delete Chart
Configure Chart
Chart Title
Chart Area
Plot Area
Customize Chart Objects
Series
Configure Chart Series
Walls
Axis and Other Lines
Configure Chart Axis
Floor
Data Label
Legends
Use Sparkline
Use Table
Create and Delete Tables
Modify Tables
Apply Table Sort
Set Table Filters
Add and Delete Table Columns and Rows
Apply Table Style
Modify Table with Custom Style
Modify Table Layout
Use Pivot Table
Create Pivot Table
Pivot Table Settings
Use Slicer
Add Slicer in Table
Add Slicer in Pivot Table
Use Do Filter Operation
Apply Slicer Style
Modify Slicer with Custom Style
Modify Table Layout for Slicer Style
Import and Export .xlsx Document
Import and Export JSON Stream
Apply Conditional Formatting
Add Cell Value Rule
Add Date Occurring Rule
Add Average Rule
Add Color Scale Rule
Add Data Bar Rule
Add Top Bottom Rule
Add Unique Rule
Add Icon Sets Rule
Add Expression Rule
Apply Data Validations
Add Validations
Delete Validation
Modify Validation
Configure Print Settings via Page Setup
Configure Page Header and Footer
Configure Page Settings
Configure Paper Settings
Configure Print Area
Configure Columns to Repeat at Left
Configure Rows to Repeat at Top
Configure Sheet Print Settings
Assembly Reference
GrapeCity.Documents.Spread Assembly
Overview
Namespaces
GrapeCity.Documents.Spread Namespace
Overview
Classes
CellColorSortField
Overview
Members
CellColorSortField Constructor
Properties
Interior Property
Order Property
FontColorSortField
Overview
Members
FontColorSortField Constructor
Properties
Color Property
Order Property
IconSortField
Overview
Members
IconSortField Constructor
Properties
Icon Property
Order Property
InvalidFormulaException
Overview
Members
InvalidFormulaException Constructor
LicenseManager
Overview
Members
Methods
SetLicense Method
OpenOptions
Overview
Members
OpenOptions Constructor
Properties
DoNotRecalculateAfterOpened Property
ImportFlags Property
RangeEventArgs
Overview
Members
RangeEventArgs Constructor
Properties
Range Property
SaveOptions
Overview
Members
SaveOptions Constructor
Properties
IsCompactMode Property
SheetEventArgs
Overview
Members
SheetEventArgs Constructor
Properties
Sheet Property
SortFieldBase
Overview
Members
Properties
Key Property
Priority Property
SortOn Property
Themes
Overview
Members
Themes Constructor
Methods
Add Method
Properties
Badge Property
Banded Property
Basis Property
Berlin Property
Celestial Property
Circuit Property
Count Property
Crop Property
Damask Property
Depth Property
Dividend Property
Droplet Property
Facet Property
Feathered Property
Frame Property
Gallery Property
Headlines Property
Integral Property
Ion Property
IonBoardroom Property
Item Property
MainEvent Property
Mesh Property
Metropolitan Property
OfficeTheme Property
Organic Property
Parallax Property
Parcel Property
Quotable Property
Retrospect Property
Savon Property
Slate Property
Slice Property
VaporTrail Property
View Property
Wisp Property
WoodType Property
ValueSortField
Overview
Members
ValueSortField Constructor
ValueSortField Constructor(IRange,SortOrder)
ValueSortField Constructor(IRange,String)
Properties
CustomValues Property
DataOption Property
Order Property
Workbook
Overview
Members
Workbook Constructor
Methods
Calculate Method
Dirty Method
FromJson Method
FromJson(String) Method
FromJson(Stream) Method
IsEncryptedFile Method
IsEncryptedFile(String) Method
IsEncryptedFile(Stream) Method
Open Method
Open(String,String,OpenOptions) Method
Open(Stream,String,OpenOptions) Method
Save Method
Save(String,String,SaveOptions) Method
Save(Stream,String,SaveOptions) Method
ToJson Method
ToJson() Method
ToJson(Stream) Method
Properties
ActiveSheet Property
Author Property
AutoParse Property
Culture Property
DefaultTableStyle Property
EnableCalculation Property
IconSets Property
Names Property
PivotCaches Property
ReferenceStyle Property
SlicerCaches Property
Styles Property
TableStyles Property
Theme Property
Worksheets Property
Events
AfterSave Event
BeforeSave Event
NewSheet Event
Opened Event
SheetActivate Event
SheetBeforeDelete Event
SheetChange Event
SheetDeactivate Event
SheetSelectionChange Event
Enumerations
AboveBelow
AutoFilterOperator
BorderLineStyle
BordersIndex
CalcError
ColorDataIndex
ColorScaleType
ConditionValueTypes
ConsolidationFunction
ContainsOperator
DataBarAxisPosition
DataBarBorderType
DataBarDirection
DataBarFillType
DataBarNegativeColorType
DeleteShiftDirection
DisplayBlanksAs
DupeUnique
DynamicFilterType
FontLanguageIndex
FormatConditionOperator
FormatConditionType
FormatMode
GradientFillType
GraphicColorType
HorizontalAlignment
IconSetType
IconType
IMEModeType
ImportFlags
InsertShiftDirection
NumberFormatType
Order
PaperSize
PasteType
Pattern
PivotFieldOrientation
PrintErrors
PrintLocation
PrintQuality
ReadingOrder
ReferenceStyle
SlicerSortOrder
SortDataOption
SortOnType
SortOrder
SortOrientation
SparklineRowCol
SparkScale
SparkType
SubtotalLocationType
SubtotalType
SummaryColumn
SummaryRow
TableStyleElementType
ThemeColor
ThemeFont
TimePeriods
TopBottom
TotalsCalculation
UnderlineType
UsedRangeType
ValidationAlertStyle
ValidationOperator
ValidationType
VerticalAlignment
Visibility
Structures
Color
Overview
Members
Methods
Equals Method
FromRGB Method
FromRGB(Int32) Method
FromRGB(Int32,Int32,Int32) Method
GetHashCode Method
ToRGB Method
ToString Method
Properties
AliceBlue Property
AntiqueWhite Property
Aqua Property
Aquamarine Property
Azure Property
B Property
Beige Property
Bisque Property
Black Property
BlanchedAlmond Property
Blue Property
BlueViolet Property
Brown Property
BurlyWood Property
CadetBlue Property
Chartreuse Property
Chocolate Property
Coral Property
CornflowerBlue Property
Cornsilk Property
Crimson Property
Cyan Property
DarkBlue Property
DarkCyan Property
DarkGoldenrod Property
DarkGray Property
DarkGreen Property
DarkKhaki Property
DarkMagenta Property
DarkOliveGreen Property
DarkOrange Property
DarkOrchid Property
DarkRed Property
DarkSalmon Property
DarkSeaGreen Property
DarkSlateBlue Property
DarkSlateGray Property
DarkTurquoise Property
DarkViolet Property
DeepPink Property
DeepSkyBlue Property
DimGray Property
DodgerBlue Property
Firebrick Property
FloralWhite Property
ForestGreen Property
Fuchsia Property
G Property
Gainsboro Property
GhostWhite Property
Gold Property
Goldenrod Property
Gray Property
Green Property
GreenYellow Property
Honeydew Property
HotPink Property
IndianRed Property
Indigo Property
IsEmpty Property
Ivory Property
Khaki Property
Lavender Property
LavenderBlush Property
LawnGreen Property
LemonChiffon Property
LightBlue Property
LightCoral Property
LightCyan Property
LightGoldenrodYellow Property
LightGray Property
LightGreen Property
LightPink Property
LightSalmon Property
LightSeaGreen Property
LightSkyBlue Property
LightSlateGray Property
LightSteelBlue Property
LightYellow Property
Lime Property
LimeGreen Property
Linen Property
Magenta Property
Maroon Property
MediumAquamarine Property
MediumBlue Property
MediumOrchid Property
MediumPurple Property
MediumSeaGreen Property
MediumSlateBlue Property
MediumSpringGreen Property
MediumTurquoise Property
MediumVioletRed Property
MidnightBlue Property
MintCream Property
MistyRose Property
Moccasin Property
NavajoWhite Property
Navy Property
OldLace Property
Olive Property
OliveDrab Property
Orange Property
OrangeRed Property
Orchid Property
PaleGoldenrod Property
PaleGreen Property
PaleTurquoise Property
PaleVioletRed Property
PapayaWhip Property
PeachPuff Property
Peru Property
Pink Property
Plum Property
PowderBlue Property
Purple Property
R Property
Red Property
RosyBrown Property
RoyalBlue Property
SaddleBrown Property
Salmon Property
SandyBrown Property
SeaGreen Property
SeaShell Property
Sienna Property
Silver Property
SkyBlue Property
SlateBlue Property
SlateGray Property
Snow Property
SpringGreen Property
SteelBlue Property
Tan Property
Teal Property
Thistle Property
Tomato Property
Turquoise Property
Violet Property
Wheat Property
White Property
WhiteSmoke Property
Yellow Property
YellowGreen Property
Fields
Empty Field
Operators
Equality Operator
Inequality Operator
Interfaces
IAboveAverage
Overview
Members
Methods
Delete Method
SetFirstPriority Method
SetLastPriority Method
Properties
AboveBelow Property
AppliesTo Property
Borders Property
Font Property
Interior Property
NumberFormat Property
NumStdDev Property
Priority Property
StopIfTrue Property
Type Property
IAreas
Overview
Members
Properties
Count Property
Item Property
IAutoFilter
Overview
Members
Methods
ApplyFilter Method
ShowAllData Method
Properties
FilterMode Property
Filters Property
Range Property
Sort Property
IBorder
Overview
Members
Properties
Color Property
ColorIndex Property
LineStyle Property
ThemeColor Property
TintAndShade Property
IBorders
Overview
Members
Properties
Color Property
ColorIndex Property
Count Property
Item Property
LineStyle Property
ThemeColor Property
TintAndShade Property
ICellCollection
Overview
Members
Properties
Item Property
Item(String) Property
Item(Int32,Int32) Property
ICellColorSortField
Overview
Members
Properties
Interior Property
Order Property
IColorFormatter
Overview
Members
Methods
Format Method
Properties
HasFormatedColor Property
IColorScale
Overview
Members
Methods
Delete Method
SetFirstPriority Method
SetLastPriority Method
Properties
AppliesTo Property
ColorScaleCriteria Property
Priority Property
StopIfTrue Property
Type Property
IColorScaleCriteria
Overview
Members
Properties
Count Property
Item Property
IColorScaleCriterion
Overview
Members
Properties
FormatColor Property
Index Property
Type Property
Value Property
IColorStop
Overview
Members
Methods
Delete Method
Properties
Color Property
Position Property
ThemeColor Property
TintAndShade Property
IColorStops
Overview
Members
Methods
Add Method
Clear Method
Properties
Count Property
Item Property
IComment
Overview
Members
Methods
Delete Method
Next Method
Previous Method
Properties
Author Property
Shape Property
Text Property
Visible Property
IComments
Overview
Members
Properties
Count Property
Item Property
IConditionValue
Overview
Members
Properties
Type Property
Value Property
IDataBar
Overview
Members
Methods
Delete Method
SetFirstPriority Method
SetLastPriority Method
Properties
AppliesTo Property
AxisColor Property
AxisPosition Property
BarBorder Property
BarColor Property
BarFillType Property
Direction Property
MaxPoint Property
MinPoint Property
NegativeBarFormat Property
PercentMax Property
PercentMin Property
Priority Property
ShowValue Property
StopIfTrue Property
Type Property
IDataBarBorder
Overview
Members
Properties
Color Property
Type Property
IDisplayFormat
Overview
Members
Properties
AddIndent Property
Borders Property
Font Property
FormulaHidden Property
HorizontalAlignment Property
IndentLevel Property
Interior Property
Locked Property
MergeCells Property
NumberFormat Property
Orientation Property
ReadingOrder Property
ShrinkToFit Property
Style Property
VerticalAlignment Property
WrapText Property
IFilter
Overview
Members
Properties
Criteria1 Property
Criteria2 Property
On Property
Operator Property
IFilters
Overview
Members
Properties
Count Property
Item Property
IFont
Overview
Members
Properties
Bold Property
Color Property
ColorIndex Property
Italic Property
Name Property
Size Property
Strikethrough Property
Subscript Property
Superscript Property
ThemeColor Property
ThemeFont Property
TintAndShade Property
Underline Property
IFontColorSortField
Overview
Members
Properties
Color Property
Order Property
IFormatColor
Overview
Members
Properties
Color Property
ColorIndex Property
ThemeColor Property
TintAndShade Property
IFormatCondition
Overview
Members
Methods
Delete Method
SetFirstPriority Method
SetLastPriority Method
Properties
AppliesTo Property
Borders Property
DateOperator Property
Font Property
Formula1 Property
Formula2 Property
Interior Property
NumberFormat Property
Operator Property
Priority Property
StopIfTrue Property
Text Property
TextOperator Property
Type Property
IFormatConditions
Overview
Members
Methods
Add Method
AddAboveAverage Method
AddColorScale Method
AddDatabar Method
AddIconSetCondition Method
AddTop10 Method
AddUniqueValues Method
Delete Method
Properties
Count Property
Item Property
IFormatter
Overview
Members
Methods
Format Method
Parse Method
Properties
FormatString Property
IGraphic
Overview
Members
Methods
SetGraphicStream Method
Properties
Filename Property
Height Property
LockAspectRatio Property
Width Property
IHeaderFooter
Overview
Members
Properties
Picture Property
Text Property
IHyperlink
Overview
Members
Methods
Delete Method
Properties
Address Property
EmailSubject Property
Name Property
Range Property
ScreenTip Property
SubAddress Property
TextToDisplay Property
IHyperlinks
Overview
Members
Methods
Add Method
Delete Method
Properties
Count Property
Item Property
IIcon
Overview
Members
Properties
Index Property
Parent Property
IIconCriteria
Overview
Members
Properties
Count Property
Item Property
IIconCriterion
Overview
Members
Properties
Icon Property
Index Property
Operator Property
Type Property
Value Property
IIconSet
Overview
Members
Properties
Count Property
ID Property
Item Property
IIconSetCondition
Overview
Members
Methods
Delete Method
SetFirstPriority Method
SetLastPriority Method
Properties
AppliesTo Property
IconCriteria Property
IconSet Property
PercentileValues Property
Priority Property
ReverseOrder Property
ShowIconOnly Property
StopIfTrue Property
Type Property
IIconSets
Overview
Members
Properties
Count Property
Item Property
IIconSortField
Overview
Members
Properties
Icon Property
Order Property
IInterior
Overview
Members
Properties
Color Property
ColorIndex Property
Gradient Property
Pattern Property
PatternColor Property
PatternColorIndex Property
PatternThemeColor Property
PatternTintAndShade Property
ThemeColor Property
TintAndShade Property
ILinearGradient
Overview
Members
Properties
ColorStops Property
Degree Property
IName
Overview
Members
Methods
Delete Method
Properties
Comment Property
Name Property
RefersTo Property
RefersToR1C1 Property
INames
Overview
Members
Methods
Add Method
Clear Method
Contains Method
Properties
Count Property
Item Property
Item(String) Property
Item(Int32) Property
INegativeBarFormat
Overview
Members
Properties
BorderColor Property
BorderColorType Property
Color Property
ColorType Property
IOutline
Overview
Members
Methods
ShowLevels Method
Properties
SummaryColumn Property
SummaryRow Property
IPage
Overview
Members
Properties
CenterFooter Property
CenterHeader Property
LeftFooter Property
LeftHeader Property
RightFooter Property
RightHeader Property
IPageSetup
Overview
Members
Methods
CustomPaperSize Method
Properties
AlignMarginsHeaderFooter Property
BlackAndWhite Property
BottomMargin Property
CenterFooter Property
CenterFooterPicture Property
CenterHeader Property
CenterHeaderPicture Property
CenterHorizontally Property
CenterVertically Property
DifferentFirstPageHeaderFooter Property
Draft Property
EvenPage Property
FirstPage Property
FirstPageNumber Property
FitToPagesTall Property
FitToPagesWide Property
FooterMargin Property
HeaderMargin Property
IsPercentScale Property
LeftFooter Property
LeftFooterPicture Property
LeftHeader Property
LeftHeaderPicture Property
LeftMargin Property
OddAndEvenPagesHeaderFooter Property
Order Property
Orientation Property
PaperHeight Property
PaperSize Property
PaperWidth Property
PrintArea Property
PrintComments Property
PrintCopies Property
PrintErrors Property
PrintGridlines Property
PrintHeadings Property
PrintNotes Property
PrintPageRange Property
PrintQuality Property
PrintTitleColumns Property
PrintTitleRows Property
RightFooter Property
RightFooterPicture Property
RightHeader Property
RightHeaderPicture Property
RightMargin Property
ScaleWithDocHeaderFooter Property
TopMargin Property
Zoom Property
IPivotCache
Overview
Members
Methods
CreatePivotTable Method
Refresh Method
Properties
Index Property
RecordCount Property
RefreshDate Property
RefreshName Property
SourceData Property
IPivotCaches
Overview
Members
Methods
Create Method
Properties
Count Property
Item Property
IPivotField
Overview
Members
Methods
ClearAllFilters Method
ClearManualFilter Method
Properties
AllItemsVisible Property
CurrentPage Property
DragToColumn Property
DragToData Property
DragToHide Property
DragToPage Property
DragToRow Property
EnableMultiplePageItems Property
Function Property
LayoutSubtotalLocation Property
Name Property
Orientation Property
PivotItems Property
Position Property
SourceName Property
Subtotals Property
IPivotFields
Overview
Members
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
IPivotItem
Overview
Members
Properties
Name Property
SourceName Property
Visible Property
IPivotItems
Overview
Members
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
IPivotTable
Overview
Members
Methods
ClearAllFilters Method
ClearTable Method
Refresh Method
SubtotalLocation Method
Update Method
Properties
ColumnGrand Property
ColumnRange Property
DataBodyRange Property
DisplayContextTooltips Property
DisplayMemberPropertyTooltips Property
GrandTotalName Property
Name Property
PivotCache Property
PivotFields Property
RowGrand Property
RowRange Property
TableRange1 Property
TableStyle Property
Tag Property
IPivotTables
Overview
Members
Methods
Add Method
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
IProtectionSettings
Overview
Members
Properties
AllowDeletingColumns Property
AllowDeletingRows Property
AllowFiltering Property
AllowFormattingCells Property
AllowFormattingColumns Property
AllowFormattingRows Property
AllowInsertingColumns Property
AllowInsertingHyperlinks Property
AllowInsertingRows Property
AllowSorting Property
AllowUsingObjects Property
AllowUsingPivotTables Property
IRange
Overview
Members
Methods
Activate Method
AddComment Method
AutoFilter Method
Calculate Method
Clear Method
ClearComments Method
ClearContents Method
ClearFormats Method
ClearHyperlinks Method
ClearOutline Method
Copy Method
Cut Method
Delete Method
Dirty Method
Group Method
Insert Method
Merge Method
Select Method
Sort Method
Sort(SortOrientation,Boolean,IValueSortField[]) Method
Sort(IRange,SortOrder,SortOrientation,Boolean) Method
Ungroup Method
UnMerge Method
Properties
AddIndent Property
Areas Property
Borders Property
Cells Property
Column Property
Columns Property
ColumnWidth Property
ColumnWidthInPixel Property
Comment Property
Count Property
CurrentArray Property
DisplayFormat Property
EntireColumn Property
EntireMergeArea Property
EntireRow Property
Font Property
FormatConditions Property
Formula Property
FormulaArray Property
FormulaHidden Property
FormulaR1C1 Property
HasArray Property
HasFormula Property
HasValidation Property
Height Property
HeightInPixel Property
Hidden Property
HorizontalAlignment Property
Hyperlinks Property
IndentLevel Property
Interior Property
Item Property
Item(Int32,Int32) Property
Item(Int32) Property
Locked Property
MergeArea Property
MergeCells Property
NumberFormat Property
Orientation Property
OutlineLevel Property
ReadingOrder Property
Row Property
RowHeight Property
RowHeightInPixel Property
Rows Property
ShowDetail Property
ShrinkToFit Property
SparklineGroups Property
Style Property
Summary Property
Text Property
UseStandardHeight Property
UseStandardWidth Property
Validation Property
ValidationIsSame Property
Value Property
VerticalAlignment Property
Width Property
WidthInPixel Property
Worksheet Property
WrapText Property
IRangeProvider
Overview
Members
Properties
Item Property
Item(String) Property
Item(Int32,Int32) Property
Item(Int32,Int32,Int32,Int32) Property
IRectangularGradient
Overview
Members
Properties
Bottom Property
ColorStops Property
Left Property
Right Property
Top Property
ISlicer
Overview
Members
Methods
Delete Method
Properties
Caption Property
DisplayHeader Property
Height Property
Left Property
Name Property
NumberOfColumns Property
RowHeight Property
Shape Property
SlicerCache Property
Style Property
Top Property
Width Property
ISlicerCache
Overview
Members
Methods
ClearAllFilters Method
Delete Method
Properties
FilterCleared Property
List Property
Name Property
PivotTables Property
SlicerItems Property
Slicers Property
SortItems Property
SourceName Property
Table Property
ISlicerCaches
Overview
Members
Methods
Add Method
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
ISlicerItem
Overview
Members
Properties
Selected Property
Value Property
ISlicerItems
Overview
Members
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
ISlicerPivotTables
Overview
Members
Methods
AddPivotTable Method
RemovePivotTable Method
Properties
Count Property
Item Property
ISlicers
Overview
Members
Methods
Add Method
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
ISort
Overview
Members
Methods
Apply Method
Properties
Header Property
MatchCase Property
Orientation Property
Range Property
SortFields Property
ISortField
Overview
Members
Properties
Key Property
Priority Property
SortOn Property
ISortFields
Overview
Members
Methods
Add Method
Clear Method
Remove Method
Properties
Count Property
Item Property
ISparkAxes
Overview
Members
Properties
Horizontal Property
Vertical Property
ISparkColor
Overview
Members
Properties
Color Property
Visible Property
ISparkHorizontalAxis
Overview
Members
Properties
Axis Property
IsDateAxis Property
RightToLeftPlotOrder Property
ISparkline
Overview
Members
Properties
Location Property
SourceData Property
ISparklineGroup
Overview
Members
Methods
Delete Method
Properties
Axes Property
Count Property
DateRange Property
DisplayBlanksAs Property
DisplayHidden Property
Item Property
LineWeight Property
Location Property
PlotBy Property
Points Property
SeriesColor Property
SourceData Property
Type Property
ISparklineGroups
Overview
Members
Methods
Add Method
Clear Method
ClearGroups Method
Group Method
Ungroup Method
Properties
Count Property
Item Property
ISparkPoints
Overview
Members
Properties
Firstpoint Property
Highpoint Property
Lastpoint Property
Lowpoint Property
Markers Property
Negative Property
ISparkVerticalAxis
Overview
Members
Properties
CustomMaxScaleValue Property
CustomMinScaleValue Property
MaxScaleType Property
MinScaleType Property
IStyle
Overview
Members
Methods
Delete Method
Properties
AddIndent Property
Borders Property
BuiltIn Property
Font Property
FormulaHidden Property
HorizontalAlignment Property
IncludeAlignment Property
IncludeBorder Property
IncludeFont Property
IncludeNumber Property
IncludePatterns Property
IncludeProtection Property
IndentLevel Property
Interior Property
Locked Property
Name Property
NumberFormat Property
Orientation Property
ShrinkToFit Property
VerticalAlignment Property
WrapText Property
IStyleCollection
Overview
Members
Methods
Add Method
Contains Method
Properties
Count Property
Item Property
Item(String) Property
Item(Int32) Property
ITable
Overview
Members
Methods
Delete Method
Resize Method
Properties
AutoFilter Property
Columns Property
Comment Property
DataRange Property
DisplayName Property
HeaderRange Property
Name Property
Range Property
Rows Property
ShowAutoFilter Property
ShowAutoFilterDropDown Property
ShowHeaders Property
ShowTableStyleColumnStripes Property
ShowTableStyleFirstColumn Property
ShowTableStyleLastColumn Property
ShowTableStyleRowStripes Property
ShowTotals Property
Sort Property
TableStyle Property
TotalsRange Property
ITableColumn
Overview
Members
Methods
Delete Method
Properties
DataBodyRange Property
Index Property
Name Property
Range Property
Total Property
TotalsCalculation Property
ITableColumns
Overview
Members
Methods
Add Method
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
ITableRow
Overview
Members
Methods
Delete Method
Properties
Index Property
Range Property
ITableRows
Overview
Members
Methods
Add Method
Properties
Count Property
Item Property
ITables
Overview
Members
Methods
Add Method
Properties
Count Property
Item Property
Item(String) Property
Item(Int32) Property
ITableStyle
Overview
Members
Methods
Delete Method
Duplicate Method
Properties
BuiltIn Property
Name Property
ShowAsAvailableSlicerStyle Property
ShowAsAvailableTableStyle Property
TableStyleElements Property
ITableStyleCollection
Overview
Members
Methods
Add Method
Properties
Count Property
Item Property
Item(String) Property
Item(Int32) Property
ITableStyleElement
Overview
Members
Properties
Borders Property
Font Property
Interior Property
StripeSize Property
ITableStyleElements
Overview
Members
Properties
Count Property
Item Property
ITheme
Overview
Members
Properties
IsBuiltIn Property
Name Property
ThemeColorScheme Property
ThemeFontScheme Property
IThemeColor
Overview
Members
Properties
RGB Property
ThemeColorSchemeIndex Property
IThemeColorScheme
Overview
Members
Properties
Count Property
Item Property
IThemeFont
Overview
Members
Properties
FontLanguageIndex Property
Name Property
IThemeFonts
Overview
Members
Properties
Count Property
Item Property
IThemeFontScheme
Overview
Members
Properties
Major Property
Minor Property
ITop10
Overview
Members
Methods
Delete Method
SetFirstPriority Method
SetLastPriority Method
Properties
AppliesTo Property
Borders Property
Font Property
Interior Property
NumberFormat Property
Percent Property
Priority Property
Rank Property
StopIfTrue Property
TopBottom Property
Type Property
IUniqueValues
Overview
Members
Methods
Delete Method
SetFirstPriority Method
SetLastPriority Method
Properties
AppliesTo Property
Borders Property
DupeUnique Property
Font Property
Interior Property
NumberFormat Property
Priority Property
StopIfTrue Property
Type Property
IValidation
Overview
Members
Methods
Add Method
Delete Method
Properties
AlertStyle Property
ErrorMessage Property
ErrorTitle Property
Formula1 Property
Formula2 Property
IgnoreBlank Property
IMEMode Property
InCellDropdown Property
InputMessage Property
InputTitle Property
Operator Property
ShowError Property
ShowInputMessage Property
Type Property
Value Property
IValueSortField
Overview
Members
Properties
CustomValues Property
DataOption Property
Order Property
IWorkbook
Overview
Members
Methods
Calculate Method
Dirty Method
FromJson Method
FromJson(String) Method
FromJson(Stream) Method
IsEncryptedFile Method
IsEncryptedFile(String) Method
IsEncryptedFile(Stream) Method
Open Method
Open(String,String,OpenOptions) Method
Open(Stream,String,OpenOptions) Method
Save Method
Save(String,String,SaveOptions) Method
Save(Stream,String,SaveOptions) Method
ToJson Method
ToJson() Method
ToJson(Stream) Method
Properties
ActiveSheet Property
AutoParse Property
Culture Property
DefaultTableStyle Property
EnableCalculation Property
Names Property
PivotCaches Property
ReferenceStyle Property
SlicerCaches Property
Styles Property
TableStyles Property
Theme Property
Worksheets Property
Events
AfterSave Event
BeforeSave Event
NewSheet Event
Opened Event
SheetActivate Event
SheetBeforeDelete Event
SheetChange Event
SheetDeactivate Event
SheetSelectionChange Event
IWorksheet
Overview
Members
Methods
Activate Method
Delete Method
Evaluate Method
FreezePanes Method
GetUsedRange Method
ShowAllData Method
UnfreezePanes Method
Properties
ActiveCell Property
AutoFilter Property
AutoFilterMode Property
Cells Property
Columns Property
Comments Property
FilterMode Property
FreezeColumn Property
FreezeRow Property
Hyperlinks Property
Index Property
Name Property
Names Property
Outline Property
PageSetup Property
PivotTables Property
Protection Property
ProtectionSettings Property
Range Property
Rows Property
Selection Property
Shapes Property
SheetView Property
Sort Property
StandardHeight Property
StandardWidth Property
TabColor Property
Tables Property
UsedRange Property
Visible Property
Workbook Property
Events
Activated Event
BeforeDelete Event
Changed Event
Deactivated Event
SelectionChange Event
IWorksheets
Overview
Members
Methods
Add Method
AddAfter Method
AddBefore Method
Contains Method
IndexOf Method
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
IWorksheetView
Overview
Members
Properties
DisplayFormulas Property
DisplayGridlines Property
DisplayHeadings Property
DisplayOutline Property
DisplayRightToLeft Property
DisplayRuler Property
DisplayWhitespace Property
DisplayZeros Property
GrapeCity.Documents.Spread.Core.Style Namespace
Overview
GrapeCity.Documents.Spread.Drawing Namespace
Overview
Enumerations
ArrowheadLength
ArrowheadStyle
ArrowheadWidth
AutoShapeType
AxisCrosses
AxisGroup
AxisType
BarShape
CategoryType
ChartSplitType
ChartType
ConnectorType
DataLabelPosition
DisplayUnit
DrawingPictureType
EndStyleCap
FillType
GradientStyle
ImageType
LegendPosition
LineDashStyle
LineStyle
MarkerStyle
PatternType
PictureColorType
Placement
PresetCamera
PresetGradientType
PresetTexture
PresetThreeDFormat
RowCol
ScaleType
ShapeType
SizeRepresents
SolidColorType
TextRangeType
TextUnderlineType
TextureAlignment
TextureType
TickLabelOrientation
TickLabelPosition
TickMark
TimeUnit
TrendlineType
Interfaces
IAxes
Overview
Members
Methods
Item Method
Properties
Count Property
Parent Property
IAxis
Overview
Members
Properties
ActualCategoryType Property
AxisBetweenCategories Property
AxisGroup Property
AxisTitle Property
BaseUnit Property
BaseUnitIsAuto Property
CategoryNames Property
CategoryType Property
Crosses Property
CrossesAt Property
DisplayUnit Property
DisplayUnitCustom Property
DisplayUnitLabel Property
Format Property
HasDisplayUnitLabel Property
HasMajorGridlines Property
HasMinorGridlines Property
HasTitle Property
LogBase Property
MajorGridlines Property
MajorTickMark Property
MajorUnit Property
MajorUnitIsAuto Property
MajorUnitScale Property
MaximumScale Property
MaximumScaleIsAuto Property
MinimumScale Property
MinimumScaleIsAuto Property
MinorGridlines Property
MinorTickMark Property
MinorUnit Property
MinorUnitIsAuto Property
MinorUnitScale Property
Parent Property
ReversePlotOrder Property
ScaleType Property
TickLabelPosition Property
TickLabels Property
TickLabelSpacing Property
TickLabelSpacingIsAuto Property
TickMarkSpacing Property
Type Property
Visible Property
IAxisTitle
Overview
Members
IChart
Overview
Members
Methods
Delete Method
SetSourceData Method
SetSourceData(IRange,RowCol) Method
SetSourceData(IRange) Method
Properties
Area3DGroup Property
AreaGroups Property
AutoScaling Property
Axes Property
BackWall Property
Bar3DGroup Property
BarGroups Property
BarShape Property
ChartArea Property
ChartGroups Property
ChartTitle Property
ChartType Property
Column3DGroup Property
ColumnGroups Property
DepthPercent Property
DisplayBlanksAs Property
DoughnutGroups Property
Elevation Property
Floor Property
GapDepth Property
HasLegend Property
HasTitle Property
HeightPercent Property
Legend Property
Line3DGroup Property
LineGroups Property
Name Property
Parent Property
Perspective Property
Pie3DGroup Property
PieGroups Property
PlotArea Property
PlotVisibleOnly Property
RadarGroups Property
RightAngleAxes Property
Rotation Property
SeriesCollection Property
ShowDataLabelsOverMaximum Property
SideWall Property
SurfaceGroup Property
Walls Property
XYGroups Property
IChartArea
Overview
Members
Properties
Font Property
Format Property
Parent Property
RoundedCorners Property
IChartBars
Overview
Members
Methods
Delete Method
Properties
Format Property
Parent Property
IChartFormat
Overview
Members
Properties
Fill Property
Line Property
ThreeD Property
IChartGroup
Overview
Members
Properties
AxisGroup Property
BubbleScale Property
DoughnutHoleSize Property
DownBars Property
DropLines Property
FirstSliceAngle Property
GapWidth Property
HasDropLines Property
HasHiLoLines Property
HasSeriesLines Property
HasUpDownBars Property
HiLoLines Property
Overlap Property
Parent Property
SecondPlotSize Property
SeriesCollection Property
SeriesLines Property
ShowNegativeBubbles Property
SizeRepresents Property
SplitType Property
SplitValue Property
UpBars Property
VaryByCategories Property
IChartGroups
Overview
Members
Properties
Count Property
Item Property
Parent Property
IChartLines
Overview
Members
Methods
Delete Method
Properties
Format Property
IChartTitle
Overview
Members
Methods
Delete Method
Properties
Font Property
Format Property
Formula Property
FormulaR1C1 Property
IncludeInLayout Property
Parent Property
Text Property
TextFrame Property
IColorFormat
Overview
Members
Properties
Brightness Property
ColorType Property
ObjectThemeColor Property
RGB Property
TintAndShade Property
IConnectorFormat
Overview
Members
Methods
BeginConnect Method
BeginDisconnect Method
EndConnect Method
EndDisconnect Method
Properties
BeginConnected Property
BeginConnectedShape Property
BeginConnectionSite Property
EndConnected Property
EndConnectedShape Property
EndConnectionSite Property
Type Property
IContainer
Overview
Members
Properties
Height Property
HeightInPixel Property
Left Property
LeftInPixel Property
Top Property
TopInPixel Property
Width Property
WidthInPixel Property
ICrop
Overview
Members
Properties
PictureHeight Property
PictureOffsetX Property
PictureOffsetY Property
PictureWidth Property
ShapeHeight Property
ShapeLeft Property
ShapeTop Property
ShapeWidth Property
IDataLabel
Overview
Members
Methods
Delete Method
Properties
AutoText Property
Font Property
Format Property
NumberFormat Property
NumberFormatLinked Property
Parent Property
Position Property
Separator Property
ShowBubbleSize Property
ShowCategoryName Property
ShowLegendKey Property
ShowPercentage Property
ShowSeriesName Property
ShowValue Property
Text Property
TextFrame Property
IDataLabels
Overview
Members
Properties
AutoText Property
Count Property
Font Property
Format Property
Item Property
LeaderLines Property
NumberFormat Property
NumberFormatLinked Property
Parent Property
Position Property
Separator Property
ShowBubbleSize Property
ShowCategoryName Property
ShowLeaderLines Property
ShowLegendKey Property
ShowPercentage Property
ShowSeriesName Property
ShowValue Property
IDisplayUnitLabel
Overview
Members
Methods
Delete Method
Properties
Font Property
Format Property
Parent Property
Text Property
TextFrame Property
IFillFormat
Overview
Members
Methods
OneColorGradient Method
Patterned Method
PresetGradient Method
PresetTextured Method
Solid Method
TwoColorGradient Method
UserPicture Method
UserPicture(String) Method
UserPicture(Stream,ImageType) Method
UserTextured Method
UserTextured(String) Method
UserTextured(Stream,ImageType) Method
Properties
Color Property
GradientAngle Property
GradientDegree Property
GradientStops Property
GradientStyle Property
GradientVariant Property
Pattern Property
PatternColor Property
PresetGradientType Property
PresetTexture Property
RotateWithObject Property
TextureAlignment Property
TextureHorizontalScale Property
TextureOffsetX Property
TextureOffsetY Property
TextureVerticalScale Property
Transparency Property
Type Property
Visible Property
IFloor
Overview
Members
Properties
Format Property
Parent Property
Thickness Property
IFontFormat
Overview
Members
Properties
Bold Property
Color Property
Italic Property
Name Property
Size Property
Strikethrough Property
Subscript Property
Superscript Property
ThemeFont Property
Underline Property
IGradientStop
Overview
Members
Properties
Color Property
Position Property
Transparency Property
IGradientStops
Overview
Members
Methods
Delete Method
Insert Method
Properties
Count Property
Item Property
IGridlines
Overview
Members
Properties
Format Property
Parent Property
IGroupShapes
Overview
Members
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
ILegend
Overview
Members
Methods
Delete Method
Properties
Font Property
Format Property
IncludeInLayout Property
LegendEntries Property
Parent Property
Position Property
ILegendEntries
Overview
Members
Properties
Count Property
Item Property
Parent Property
ILegendEntry
Overview
Members
Methods
Delete Method
Properties
Font Property
Parent Property
ILineFormat
Overview
Members
Methods
OneColorGradient Method
Patterned Method
PresetGradient Method
Solid Method
TwoColorGradient Method
Properties
BeginArrowheadLength Property
BeginArrowheadStyle Property
BeginArrowheadWidth Property
Color Property
DashStyle Property
EndArrowheadLength Property
EndArrowheadStyle Property
EndArrowheadWidth Property
GradientAngle Property
GradientDegree Property
GradientStops Property
GradientStyle Property
GradientVariant Property
InsetPen Property
Pattern Property
PatternColor Property
Style Property
Transparency Property
Type Property
Visible Property
Weight Property
IPictureFormat
Overview
Members
Properties
Brightness Property
ColorType Property
Contrast Property
Crop Property
CropBottom Property
CropLeft Property
CropRight Property
CropTop Property
IPlotArea
Overview
Members
Properties
Format Property
Parent Property
IPoint
Overview
Members
Properties
DataLabel Property
Explosion Property
Format Property
Has3DEffect Property
HasDataLabel Property
InvertIfNegative Property
MarkerFormat Property
MarkerSize Property
MarkerStyle Property
Parent Property
PictureType Property
PictureUnit Property
SecondaryPlot Property
IPoints
Overview
Members
Properties
Count Property
Item Property
Parent Property
ISeries
Overview
Members
Methods
ClearFormats Method
Delete Method
Properties
AxisGroup Property
BarShape Property
BubbleSizes Property
ChartType Property
DataLabels Property
Explosion Property
Format Property
Formula Property
FormulaR1C1 Property
Has3DEffect Property
HasDataLabels Property
InvertColor Property
InvertIfNegative Property
MarkerFormat Property
MarkerSize Property
MarkerStyle Property
Name Property
Parent Property
PictureType Property
PictureUnit Property
PlotOrder Property
Points Property
Smooth Property
Trendlines Property
Values Property
XValues Property
ISeriesCollection
Overview
Members
Methods
Add Method
Add(IRange) Method
Add(IRange,RowCol) Method
Add(IRange,RowCol,Boolean,Boolean) Method
Extend Method
NewSeries Method
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
Parent Property
IShape
Overview
Members
Methods
Delete Method
Properties
AutoShapeType Property
BottomRightCell Property
Chart Property
Connector Property
ConnectorFormat Property
Fill Property
GroupItems Property
HasChart Property
Line Property
Locked Property
Name Property
Parent Property
ParentGroup Property
PictureFormat Property
Placement Property
Rotation Property
TextFrame Property
ThreeD Property
Title Property
TopLeftCell Property
Type Property
Visible Property
IShapes
Overview
Members
Methods
AddChart Method
AddChartInPixel Method
AddConnector Method
AddConnectorInPixel Method
AddPicture Method
AddPicture(String,Double,Double,Double,Double) Method
AddPicture(Stream,ImageType,Double,Double,Double,Double) Method
AddPictureInPixel Method
AddPictureInPixel(String,Double,Double,Double,Double) Method
AddPictureInPixel(Stream,ImageType,Double,Double,Double,Double) Method
AddShape Method
AddShapeInPixel Method
Properties
Count Property
Item Property
Item(Int32) Property
Item(String) Property
ITextFrame
Overview
Members
Properties
TextRange Property
ITextRange
Overview
Members
Methods
Add Method
Delete Method
Properties
Count Property
Font Property
Index Property
Item Property
Paragraphs Property
Runs Property
Text Property
Type Property
IThreeDFormat
Overview
Members
Methods
ResetRotation Method
Properties
Depth Property
Perspective Property
RotationX Property
RotationY Property
RotationZ Property
Visible Property
Z Property
ITickLabels
Overview
Members
Properties
Font Property
NumberFormat Property
NumberFormatLinked Property
Offset Property
Parent Property
ITrendline
Overview
Members
Methods
ClearFormats Method
Delete Method
Properties
Backward Property
DisplayEquation Property
DisplayRSquared Property
Format Property
Forward Property
Index Property
Intercept Property
Order Property
Parent Property
Period Property
Type Property
ITrendlines
Overview
Members
Methods
Add Method
Properties
Count Property
Item Property
Parent Property
IWall
Overview
Members
Properties
Format Property
Parent Property
Thickness Property