Spread.NET 18 Read Me
In This Topic
    Obsolete API
    In This Topic

    With the introduction of a completely new calculation engine, enhanced user interface, newly integrated styles and optimized import and export capabilities; Spread for WinForms 12 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 12 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.