Spread.NET
DefaultSheetSpanModel

Following are the breaking changes for DefaultSheetSpanModel.

Deprecated Methods AddRows

These methods no longer have effect when attached to SheetView. This is because while adding span cell, its location will be checked against other features like Table, ArrayFormula, and if they are called directly from the model, the check against other features can't be made, which can result in wrong data.

For a case where span model is already attached to SheetView, it is recommended to use SheetView.MoveRange/SwapRange/CopyRange methods to ensure the data integrity of all features.

DefaultSheetSpanModel spanModel = fpSpread1.ActiveSheet.Models.Span as DefaultSheetSpanModel;
spanModel.Move(0,0,4,4,2,2); //has effect and is recommmended

For a case where span model is stand alone and not attached to SheetView, the above methods still have effect.

DefaultSheetSpanModel spanModel = new DefaultSheetSpanModel();
spanModel.Move(0,0,4,4,2,2); //has effect
AddColumns
RemoveRows
RemoveColumns
Move
MoveRows
MoveColumns
Copy
CopyRows
CopyColumns
Swap
SwapRows
SwapColumns
Deprecated Interfaces IRangeSupport Interface Due to above reasons, the interface IRangeSupport of DefaultSheetSpanModel will be considered deprecated when attached to SheetView.
IDeserializationCallback Interface IDeserializationCallback of DefaultSheetSpanModel won't have effect anymore.
Creating Spans Invalid Spans

When stand alone DefaultSheetSpanModel is created and assigned to SheetView, invalid data of span model will be ignored and only valid data will be added. For example,

fpSpread1.ActiveSheet.AddTable(1,1,6,6);
DefaultSheetSpanModel sheetSpan = new DefaultSheetSpanModel();
sheetSpan.Add(0,0,2,2);
fpSpread1.ActiveSheet.Models.Span = sheetSpan; //contains invalid span
fpSpread1.ActiveSheet.GetSpanCell(0,0); //returns null
Span with RowCount and ColumnCount equal to 1 Spread WinForms 12 will not add a span cell with rowCount and columnCount equal to 1.

Back to Breaking Changes for Version 12.45.20181.0.