What's New in Spread.NET v16

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.

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.

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.

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: