Breaking Changes for Version 17.0.20231.0

Refer to the following breaking changes in each feature.

Cells

Consistent Active Cell Across Sheets

In Spread Winforms 17, the active cell is consistent across all sheets in a workbook. Spread for WinForms 16 did not select the same cell in another sheet if multiple sheets are selected. Now, this behavior is supported to enhance the compatibility with Excel.

Column Header/Footer

Customizable WrapText

Spread Winforms 17 allows to customize text wrap in column header and footer using WrapText property. Hence, now onwards, the ColumnHeaderRenderer.WordWrap property has no effect.

The WrapText property is effective only when the value of ColumnHeaderRenderer.WordWrap2 property of the SpreadSkin class is set to null. By default the Cells.WrapText value is true for the first row and column and false for the other rows and columns of the header and footer.

For example,

var activeSheet = fpSpread1.AsWorkbook().ActiveSheet;
activeSheet.ColumnHeader.RowCount = 3;
activeSheet.ColumnHeader.Cells.RowHeight = 50;
activeSheet.ColumnHeader.Cells[0, 0, 2, 0].Value = "This is just a very long text";
Console.WriteLine("WordWrap: " + ((ColumnHeaderRenderer)fpSpread1.ActiveSkin.ColumnHeaderRenderer).WordWrap);
Console.WriteLine("WordWrap2: " + ((ColumnHeaderRenderer)fpSpread1.ActiveSkin.ColumnHeaderRenderer).WordWrap2);
Console.WriteLine("WrapText cell00: " + activeSheet.ColumnHeader.Cells\[0, 0\].WrapText);
Console.WriteLine("WrapText cell10: " + activeSheet.ColumnHeader.Cells\[1, 0\].WrapText); 

Workbook/Worksheet

Deafult Theme

In Spread Winforms 17, the new Default theme has been changed to the New Office 365 default theme (2023). Note that to keep backward compatibility, the change will not affect to older versions of Spread Winforms. The new theme is supported by the flat style only. The default theme (Theme.Default) now contains setting of the new Office 365 default theme (2023). To reset to Spread Winforms 16 theme, use the below code below:

fpSpread1.AsWorkbook().Theme = Theme.GetTheme(BuiltInThemes.Office2013);

Cursor Style

The cursor style has been updated to enhance user experience when hovering over a column header, similar to Excel. Now onwards, the cursor turns into a black arrow that points down when you hover the cursor over the column header(s).

However, you can reset the old cursor style by using the following code.

fpSpread1.SetCursor (CursorType.ColumnHeader, Cursors.Arrow);

APIs

AutoCreateCalcuatedTableColumns Property

In Spread Winforms 17, the spelling of AutoCreateCalcuatedTableColumns property of the IFeatures Interface has been changed to AutoCreateCalculatedTableColumns to improve clarity and consistency.