Skip to main content Skip to footer

What's New in Spread.NET v16

Spread.NET v16.2.20231.0 - July 27, 2023

Spread.NET v16.2.20231.0 is here and includes some important fixes for customer-reported issues.

Resolved Customer-Reported Issues:

  • The FarPoint.Localization.dll would be missing after installing version 16.

  • An InvalidOperationException would occur when binding data to Spread.

  • Superscripts that were set via the Spread Designer would not be maintained.

  • An ExcecutionEngineException would be triggered in certain circumstances.

  • ToIndex would always return 1.

  • The move indicator for multi rows/columns would not move correctly in certain circumstances.


Spread.NET v16.1.20231.0 - May 17, 2023

Spread.NET v16.1.20231.0 is here and includes some new features and important fixes for customer-reported issues.

Support for Form Controls - WinForms

Spread for WinForms has included support for adding Form Controls to a worksheet. Form Controls are objects that we can insert into the worksheet to work with data and handle the data as specified. Form controls can easily be referenced and interact with cell data. 

There are 9 different types of Form controls

  • Button
  • Combo Box
  • Check Box
  • Spin Button
  • List Box
  • Option Button
  • Group Box
  • Label

Spread.NET's new Form Controls

Check out our documentation to learn more about the new Form Controls. 

Support for 3D Rotation for Shapes – WinForms

Spread for WinForms has added support for 3D shape rotation.

fpSpread1.AsWorkbook().ActiveSheet.Shapes[0].ThreeD.RotationY = 45;


Save Worksheet as an Image Format – WinForms

Spread for WinForms supports saving a worksheet as an image format, including the row and column header.

fpSpread1.ActiveSheet.SaveImage(0, 0, 10, 10, includedAreas: WorksheetSubType.RowHeader | WorksheetSubType.ColumnHeader | WorksheetSubType.ColumnFooter);

Enhancements to the Performance of the Data Table Formula Feature and Full Date Column Selection – WinForms

Spread for WinForms has improved the performance of the Data Table formula feature. This will affect the following:

  • Dependency tree (in case there are a lot of same R1C1 formulas in same column)

  • Visualization Function (include enhanced sparklines)

  • RichValue support (from calculation, not RichText)

  • And of course, the Data Table

Spread’s Designer Enhancement: Supports Scroll through the Ribbon Gallery using Spin Buttons – WinForms

Spread for WinForms Designer has enhanced its UI, now allowing users to scroll though the Spread Designer's Ribbon using spin buttons. 

Support to Scroll the Spread Designer's Ribbon Using Spin Buttons

Resolved Customer-Reported Issues:

  • Fixed the issue where Korean was not typed correctly in TextCellType, when not in editing mode.
  • Fixed the issue where after using the SetColumnMerge method, when saving as Excel, the merged cells were displayed without being merged in Excel.
  • Fixed the issue where memory leaks occurred while showing FpSpreadDesigner at runtime.
  • Fixed the issue where an error occurred when importing Excel files.
  • Fixed the issue where a free 30-day evaluation trial license was not automatically generated on the first use.
  • Fixed the issue where the context menu items was displayed in Japanese instead of Korean.


Spread.NET v16 - November 7, 2022

Spread.NET v16 is here and includes many new features and important fixes for customer-reported issues. 

Formatting, Styling, and Data Entry:

Rich Text Editing lets users input rich text with multiple text colors and font styles directly in cells while editing.

Spread.NET v16 - Rich Text EditingSpread.NET v16 - Rich Text Editing

Copy/Paste Multiple Ranges and Format Multiple Ranges using the Format Cell Dialog.

Spread.NET v16 Format Cells Dialog

Center Across Selection instead of merging cells allows more flexible cell selection by the end-user.

Add replies to Threaded Comments directly in the sheet and create New Threaded Comments for cells.

Spread.NET v16 Threaded Comment Enhancement

Fill Effects Dialog lets users fill the comment block with Gradient Fill Effects.

Spread.NET v16 - Fill Effects Dialog

Picture Effects draw images using different types of artistic effects.

Spread.NET v16 Picture Adjustments

In Spread, you can style the Number Format for Column Footer Cells.

Spread.NET v16 - Number Format Cells

Set Frozen Line Width for the line between frozen and non-frozen areas.

Spread.NET v16 Set Frozen Line Width

14 New Text and Array Functions:
    1. CHOOSECOLS: The function returns the specified columns from an array.
    2. CHOOSEROWS: The function returns the specified rows from an array.
    3. DROP: The function excludes a specified number of rows or columns from the start or end of an array. You might find this function useful to remove headers and footers in a worksheet report to return only the data.
    4. EXPAND: This function expands or pads an array to the specified row and column dimensions.
    5. HSTACK: The function appends arrays horizontally and in sequence to return a larger array.
    6. TAKE:The function returns a specified number of contiguous rows or columns from the start or end of an array.
    7. TEXTAFTER: This function returns text that occurs after a given character or string.
    8. TEXTBEFORE: This function returns text that occurs before a given character or string.
    9. TEXTSPLIT: This function splits text strings by using column and row delimiters.
    10. TOCOL: This function returns the array in a single column.
    11. TOROW: The function returns the array in a single row.
    12. VSTACK: The function appends arrays vertically and in sequence to return a larger array.
    13. WRAPCOLS: This function wraps the provided row or column of values by columns after a specified number of elements to form a new array.
    14. WRAPROWS: This function wraps the provided row or column of values by rows after a specified number of elements to form a new array.
4 New Forecasting Functions using Exponential Triple Smoothing (ETS):
    1. FORECAST.ETS: This function calculates or predicts a future value based on existing values by using the AAA version of the Exponential Triple Smoothing (ETS) algorithm.
    2. FORECAST.ETS.CONFINT: This function returns a confidence interval for the forecast value at the specified target date. Using confidence intervals can help grasp the accuracy of the predicted model. A smaller interval would imply more confidence in the prediction for this specific point.
    3. FORECAST.ETS.SEASONALITY: This function returns the length of the repetitive pattern the application detects for the specified time series.
    4. FORECAST.ETS.STAT:This function return a statistical value as a result of time series forecasting. Statistic type indicates which statistic is requested by this function.
New IMAGE Function:

Spread now supports the new Excel IMAGE Function (and IMAGE Sparkline Function is renamed to GC.IMAGE)

Spread.NET v16 IMAGE Function

New Built-in Dialogs:

Spread now supports many new Built-In Dialogs for end-users: