Spread.NET
SheetView

Following are the breaking changes for SheetView.

SheetView.SheetName

In Spread for WinForms 10, a user could set any string value for the sheet name. While exporting, any character considered invalid("?:/\\*[]") in Excel was converted to "_".

In Spread for WinForms 11, the sheet name is validated as soon as a value is assigned to SheetView.Name. An exception is thrown when a character considered invalid is assigned to a sheet name.

SheetView.ClearRange(int row, int column, int rowCount, int columnCount, bool dataOnly,ClipboardCopyOptions copyOptions)

When option is ClipboardCopyOptions.AsString, ClipboardCopyOptions.AsStringSkipHidden and ClipboardCopyOptions.Value:

In Spread for WinForms 11, calling ClearRange will now also clear the formula of cells in the range.

When option is ClipboardCopyOptions.Formula:

In Spread for WinForms 10, when the row formula and cell formula exist simultaneously, this method used to clear only the cell formula and not the row formula.

In Spread for WinForms 11, when the row formula and cell formula exist simultaneously, this method clears both the cell formula and the row formula.

SheetView.AddCustomName()

In Spread for Winforms 11, if the custom name provided by a user contains an invalid character, the custom name would not be added to the sheet.

SheetView.Protect

In Spread for Winforms 11, the default value of Protect is changed from true to false. Also, the default value of StyleInfo.Locked is modified from false to true. This change keeps the worksheet unlocked after the export to Excel operation has been executed by the user (like in Excel).

               

Back to Spread for WinForms Breaking Changes.