Spread.NET
Obsolete API

With the introduction of a completely new calculation engine, enhanced user interface, newly integrated styles and optimized import and export capabilities; Spread for WinForms 11 exhibits high performance with faster data access and low memory footprint, as compared to Spread for WinForms 10.

Hence, it is highly recommended to get rid of obsolete APIs and upgrade your code with new APIs that will not just deliver high run-time performance but will also enable you to achieve considerably greater amount of efficiency and increased competency in terms of saving time, efforts and resources.

The following table lists the obsolete API (classes and interfaces along with their corresponding obsolete properties, methods, events and constructors) from versions prior to Spread for WinForms 11 that are supported for backwards compatibility in this version of the product, but might not be supported in future versions. Please review your existing projects and update them according to the options described in the table.

Obsolete Class/Interface

Obsolete Property/Method/

Event/Constructor

Replaced With

 

 

 

HistogramBar class

LegendAreaId property No replacement. This property is deprecated now.
VaryColors property No replacement. This property is ReadOnly now.
AutoOrigin property No replacement. This property is ReadOnly now.
Origin property No replacement. This property is ReadOnly now.
Visible property No replacement. This property is ReadOnly now.
CategoryNames property No replacement. This property is ReadOnly and is not recommended to be modified by users.
Values property No replacement. This property is ReadOnly and is not recommended to be modified by users.
SeriesNameDataSource property No replacement. This property is ReadOnly and is not recommended to be modified by users.
SeriesNameDataField property No replacement. This property is ReadOnly now.

SeriesName property

No replacement. This property is ReadOnly now.

 

FunnelSeries class

VaryColors property No replacement. This property is ReadOnly now.
AutoOrigin property No replacement. This property is ReadOnly now.
Origin property No replacement. This property is ReadOnly now.
HistogramSeries class YAxisId property No replacement. This property is ReadOnly now.

 

 

 

 

 

 

HistogramLine class

LegendAreaId property No replacement. This property is deprecated now.
VaryColors property No replacement. This property is ReadOnly now.
Visible property No replacement. This property is ReadOnly now.
CategoryNames property No replacement. This property is ReadOnly and is not recommended to be modified by users.
Values property No replacement. This property is ReadOnly now.
SeriesNameDataSource property No replacement. This property is ReadOnly now.
LineBorders property No replacement. This property is ReadOnly and is not recommended to be modified by users.
LineFills property No replacement. This property is ReadOnly and is not recommended to be modified by users.
PointBorders property No replacement. This property is ReadOnly and is not recommended to be modified by users.
PointFills property No replacement. This property is ReadOnly and is not recommended to be modified by users.
PointFill property No replacement. This property is ReadOnly and is not recommended to be modified by users.

PointBorder property

No replacement. This property is ReadOnly and is not recommended to be modified by users.

PointMarkers property

No replacement. This property is ReadOnly and is not recommended to be modified by users.

SeriesName property

No replacement. This property is ReadOnly now.

SeriesNameDataField property

No replacement. This property is ReadOnly now.

SmoothedLine property

No replacement. This property is ReadOnly now.
IConditionalFormattingModel interface

AdjustSplittingConditionalFormattings

method

No replacement. This method is deprecated now.

 

 

 

 

ConfitionalFormattingModel class

SuspendRulePriorityChanging

event

No replacement. This method is deprecated now.

ResumeRulePriorityChanging

event

No replacement. This method is deprecated now.

RulePriorityChangingSuspended

event

No replacement. This method is deprecated now.
AddRows method This method is deprecated now. Only the event will be fired. As a replacement, you can use SheetView.AddRows method.
AddColumns method This method is deprecated now. Only the event will be fired. As a replacement, you can use SheetView.AddColumns method.
RemoveColumns method This method is deprecated now. Only the event will be fired. As a replacement, you can use SheetView.RemoveColumns method.
RemoveRows method This method is deprecated now. Only the event will be fired. As a replacement, you can use SheetView.RemoveRows method.
Clear method This method still has effect. You can use SheetView.Clear method instead.
Copy method This method is deprecated now. Only the event will be fired. As a replacement, you can use SheetView.Copy method.

Move method

This method is deprecated now. Only the event will be fired. As a replacement, you can use SheetView.Move method.

Swap method

This method is deprecated now. Only the event will be fired. As a replacement, you can use SheetView.Swap method.
ExpressionConsumerFormulaInfo class Entire class is obsolete Entire class is deprecated.

 

 

ConditionalFormatting class

DoubleValues property No replacement. This property is deprecated now.
ValuesCount property No replacement. This property is deprecated now.
Evaluate method No replacement. This method is deprecated now.

Changed event

No replacement. This event still has effect but using it is not recommended in this version of the product.

ConditionalFormattingSplit

No replacement. This method is deprecated now.
DataBarConditionalFormattingRule class Constructor No replacement. This constructor is deprecated now and is not recommended anymore.
PaintCell method No replacement. This method is not supported anymore. Users are not recommended to override or call this method.

IConditionalFormattingRuleCellRangeInvalidatingRequest

interface

Entire interface is obsolete Entire interface is deprecated.

IExpressionConsumer interface

Entire interface is obsolete Entire interface is deprecated.

ISupportFindFormulaDependent interface

Entire interface is obsolete Entire interface is deprecated.

IObjectExpressionSupport interface

Entire interface is obsolete Entire interface is deprecated.

FormulaConditionalFormattingRule class

Execute method No replacement. This method is not supported anymore. Users are not recommended to override or call this method.

 SheetView class

SetFormulaConditionalFormat No replacement. This method is for old conditional format. Users are recommended to use the new and enhanced conditional format instead.
SetConditionalFormat method No replacement. This method is for old conditional format. Users are recommended to use the new and enhanced conditional format instead.
GetConditionalFormats method No replacement. This method is for old conditional format. Users are recommended to use the new and enhanced conditional format instead.

IndexAxis class

LabelNumberFormat method No replacement. This method has been deprecated. Use the new LabelFormatter instead.

PolarAxis class

LabelNumberFormat method No replacement. This method has been deprecated. Use the new LabelFormatter instead.

RadarAxis class

LabelNumberFormat method No replacement. This method has been deprecated. Use the new LabelFormatter instead.

Series class

LabelNumberFormat method No replacement. This method has been deprecated. Use the new LabelFormatter instead.

IOptimizedFilterStyleModel

NextNonEmptyRow This API is deprecated.

IConFilterItem interface

Icon method This method has been deprecated. Use IconSetIndex method in order to get the icon information.

AggregationDataModel class

GetExpression method This method has been deprecated. Use GetFormula(int,int) in order to get the formula.

ITableModelSupport interface

AdjustExpressionWhenCopyRange method No replacement. This method is intended for internal use and is now deprecated.

DefaultSheetDataModel class

GetExpression method This method has been deprecated. Use GetFormula(int,int) in order to get the formula.
SetExpression method This method has been deprecated. Use SetFormula(int,int, string) in order to set the formula.

Return to Updating Projects.