What's New in Spread.NET v17

Spread.NET v17.1 - April 25, 2024

Spread.NET v17.1 is here and includes many new exciting features and enhancements that primarily focus on the Spread WinForms control.

Error Bar Support in Charts

Spread charts now support error bars for the following series types:

Bar
Line
Area
XYLine
XYPoint
ClusteredBar
HighLowClose
Candlestick

Various APIs have been added to support these:

fpSpread1.ActiveSheet.AddChart(new CellRange(0, 0, 3, 6), typeof(FarPoint.Win.Chart.ClusteredBarSeries), 600, 300, 50, 50);
fpSpread1.ActiveSheet.SetClip(0, 1, 1, 5, "1.2\t0\t-12.5\t-5\t15");
fpSpread1.ActiveSheet.SetClip(1, 0, 1, 6, "1\t-15.43\t-11\t16\t0\t17.5");
fpSpread1.ActiveSheet.SetClip(2, 0, 1, 6, "2\t7\t12\0\t-10\t10\t0");
if (fpSpread1.ActiveSheet.Charts[0].Model.PlotAreas[0].Series[0] is ClusteredBarSeries cluster)
{
  foreach (BarSeries series in cluster.Series)
  {
    ErrorBars errorBar = series.SetErrorBarsVisible(true);
    errorBar.ValueType = ErrorBarValueType.StandardError;
    errorBar.Type = FarPoint.Win.Chart.ErrorBarType.Both;
  }
}

Error bars are supported for import and export to XML and XLSX files and are also supported in the Spread Chart Designer:

Error Bar Support in Charts using .NET Spreadsheet WinForms Component

For more information, see our Spread WinForms Error Bars documentation.

Column Style for Group Footers

In this new release, Column Styles can now be set on group footers. These can be set with the new IGroupFooterStyleSupport interface:

SheetView STestActiveSheet = fpSpread1.ActiveSheet;
STestActiveSheet.RowCount = 6;
STestActiveSheet.ColumnCount = 4;
STestActiveSheet.Cells[0, 0, 3, 0].Value = 1;
STestActiveSheet.Cells[4, 0, 5, 0].Value = 2;
STestActiveSheet.Cells[0, 2, 3, 2].Value = DateTime.Today;
DefaultGroupFooterCollection defaultGroupFooterCol = new DefaultGroupFooterCollection(6, 4);
DefaultGroupFooter defaultGroupFooter = defaultGroupFooterCol[0];
ISheetDataModel model = defaultGroupFooter.DataModel as ISheetDataModel;
(model as IAggregationSupport).SetCellAggregationType(0, 2, AggregationType.Avg);
TestFpSpread.ActiveSheet.DefaultGroupFooter = defaultGroupFooterCol;

GroupDataModel gdm = new GroupDataModel(STestActiveSheet.Models.Data);
STestActiveSheet.Models.Data = gdm;
gdm.Group(new SortInfo[] { new SortInfo(0, true) }, null);
TestFpSpread.ActiveSheet.GroupFooterVisible = true;
var style = new StyleInfo();
style.BackColor = System.Drawing.Color.LightBlue;
DateTimeCellType dt = new DateTimeCellType();
dt.DateTimeFormat = DateTimeFormat.UserDefined;
dt.UserDefinedFormat = "dd.MM.yyyy HH:mm:ss";
style.CellType = dt;
style.HorizontalAlignment = CellHorizontalAlignment.Left;
for (int i = 0; i < gdm.Groups.Count; i++)
{
  var group = (Group)gdm.Groups[i];        
  group.GroupFooter.StyleManager.SetColumnStyle(2, style);
}

Column Style for Group Footers in .NET Spreadsheet Component

Check out the Spread WinForms Set Column Style in Group Footer documentation to learn more.

MultiOption CellType Compact Mode

The MultiOption CellType in Spread WinForms now supports a compact mode, which changes how a MultiOption CellType displays. This can be set with the new Compact property:

fpSpread1.ActiveSheet.Columns[0].Width = 200;
MultiOptionCellType cellType = new MultiOptionCellType();
cellType.Items = new string[] { "Diffuse", "A", "B" };
cellType.Compact = true;
cellType.Orientation = RadioOrientation.Horizontal;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = cellType;

MultiOption CellType Compact Mode in C# Spreadsheets — Compact: False

See the Setting a Multiple Option Cell documentation for more details.

CellType Dialogs

The CellType Dialog has been updated internally to now use the built-in dialogue similar to the dialogs introduced in v17:

public static Form CellTypes(FpSpread spread, CellType.ICellType cellType);

TabStrip Button Customization

The behavior of TabStrip buttons can now be customized via the TabStrip.ButtonClick event. In the following example, the code changes the default functionality of the previous and next TabStrip buttons. Instead of horizontally scrolling through the Sheet tabs, it will now also set the next or previous sheet as Active:

fpSpread1.Sheets.Count = 8;
fpSpread1.TabStrip.ButtonClick += TabStrip_ButtonClick; 
private void TabStrip_ButtonClick(object sender, TabStripButtonClickEventArgs e)
{
  Debug.WriteLine($"TabStrip_ButtonClick. {sender}. {e.Button}");
  if (e.Button == TabStripButton.Next)
  {
    fpSpread1.ActiveSheetIndex += 1;
  }
  else if (e.Button == TabStripButton.Previous)
  {
    fpSpread1.ActiveSheetIndex -= 1;
  }
}

Default Tab Strip Functionality - C# Spreadsheet — Default TabStrip Functionality

.NET Spreadsheet Component TabStrip Button Customization — Customized TabStrip Functionality

Read the Customize Tab Strip Behavior documentation for more detail.

Double Click Fill Down

Formulas in Spread .NET can now be filled down by double-clicking on the fill handle at the bottom right corner of a selected cell. Doing so will automatically copy the formula down to the end of your data, matching the rows in adjacent columns.

fpSpread1.ActiveSheet.Cells[0, 0].Value = 1;
fpSpread1.ActiveSheet.Cells[1, 0].Value = 2;
fpSpread1.ActiveSheet.Cells[2, 0].Value = 3;
fpSpread1.ActiveSheet.Cells[3, 0].Value = 4;
fpSpread1.ActiveSheet.Cells[4, 0].Value = 5;
fpSpread1.ActiveSheet.Cells[0, 1].Formula = "PRODUCT(A1,5)";

Double Click Fill Down in .NET Spreadsheets

To learn more, see our Using Double Click to Fill Cells documentation.

Number Format for Status Bar

Numbers that appear in the Status Bar at the bottom of the Spread instance can now be formatted based on the same format as the active cell.

Spread.NET v17 - December 26, 2023

Spread.NET v17 is here and includes many new exciting features and enhancements.

Spread Ribbon Control

The Spread Ribbon Control is a new addition to Spread.NET, allowing you to insert the Designer ribbon into your application for use with Spread.NET. This includes contextual ribbon tabs, buttons, menus, and Error Handling. You simply create the ribbon bar instance and attach it to an FpSpread instance:

ribbonBar1.Attach(fpSpread1);

You can also override built-in commands using the CommandExecuting and CommandExecuted events and manually execute commands using the ExecuteCommand function.

What's New in Spread.NET v17

Spread.NET v17.1 - April 25, 2024

Error Bar Support in Charts

Column Style for Group Footers

MultiOption CellType Compact Mode

CellType Dialogs

TabStrip Button Customization

Double Click Fill Down

Number Format for Status Bar

Spread.NET v17 - December 26, 2023

Spread Ribbon Control

Workbook Enhancements

Header and Footer Wrap Text

Printing Enhancements

Saving to HTML

Built-In Themes

Office 365 Default Theme 2023

Custom Document Properties

Get Last Row/Column of Cell Range

ColumnDragMoveCompleting / RowDragMoveCompleting Events

Hide Borders of Spilled Dynamic Array

Paste Options for Rich Clipboard

GoTo First/Last Sheet

Copy Method of IWorksheets

Scrolling Left and Right with Mouse Wheel

Calculation Enhancements

EVALUATE Function

IRange.HasSpill API

Chart Enhancements

Multi-Level Category Labels

Chart Sheet

Embedded Shapes with Charts

Shape Enhancements

Shape with Curve Annotation

Insert Pictures in Cells

Vertical Text in Shapes

.NET 8 Support

Shortcut Keys

Performance Improvements