# Release Notes for Version 16.0.20221.0

undefined

## Content

This set of release notes includes enhancements from the previous release, resolved issues and version details.

## Enhancements from the Previous Release

This version of the product has the following enhancements from the previous release:

* Spread for WinForms now allows you to use NumberFormat property to support the [column footer format in flat style](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-columnfooter.html#i-heading-set-column-footer-format).
* Users can now add the Data Table formula to a range of cells [using DataTable method](https://developer.mescius.com/spreadnet/docs/latest/online-win/using-datatable-formula.html).
* Users can now use the [goal seek feature](https://developer.mescius.com/spreadnet/docs/latest/online-win/goal-seek-dialog.html) for what-if analysis in worksheets.
* Users can now set the width of the line between the frozen and non-frozen areas of the worksheet using [FrozenLineThickness option](https://developer.mescius.com/spreadnet/docs/latest/online-formula/image-function.html).
* Spread for WinForms now supports the “[Center Across Selection](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-cellalign.html#i-heading-center-across-selection)” horizontal alignment option.
* Users can now have historical time-based data and predicted values using [Forecast dialog](https://developer.mescius.com/spreadnet/docs/latest/online-win/forecast-sheet-dialog.html).
* Spread for WinForms provides the feature to [remove duplicate values](https://developer.mescius.com/spreadnet/docs/latest/online-win/remove-duplicates.html) in a range.
* The existing IMAGE function is now renamed as GC.IMAGE and [the new IMAGE function](https://developer.mescius.com/spreadnet/docs/latest/online-formula/image-function.html) in Spread.NET will allow the user to insert an image into a cell from the source location.
* Worksheet protection is now extended to display variety of password protection and lock options displayed in the [Protect Sheet dialog](https://developer.mescius.com/spreadnet/docs/latest/online-win/protecting-a-worksheet.html).
* The [PictureEffectType enumeration](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-images.html) provides values for different types of artistic effects.
* Spread for WinForms now supports [rich text editing](https://developer.mescius.com/spreadnet/docs/latest/online-win/rich-text-editing-design.html) that lets user input RichText directly from Spread.
* Users can now use the [Insert Function dialog](https://developer.mescius.com/spreadnet/docs/latest/online-win/insert-function-dialog.html) box to insert the correct formula and arguments in cells.
* Users can now fill the comment block with gradient effects or manipulate it via the [Fill Effects dialog](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-cells-comment.html#i-heading-gradient-fill-effect).
* User can now Copy/Paste multi-range by setting RichClipboard property and format multi-range using format cell dialog.
* Users can add replies to the comments in the Spread UI using [threaded comment in UI](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-cells-comment.html#i-heading-gradient-fill-effect).
* Spread for WinForms now supports the [Text to Columns feature](https://developer.mescius.com/spreadnet/docs/latest/online-win/text-to-columns.html) that allows you to parse the text of one cell into many columns using delimiter.
* Spread for WinForms now exposes a [new BuiltInDialogs class](https://developer.mescius.com/spreadnet/docs/latest/online-win/work-with-builtin-dialog.html) that allows you to open built-in dialogs at runtime.
* Spread for WinForms now supports [new text and array functions](https://developer.mescius.com/spreadnet/docs/latest/online-formula/textafter-function.html).
* Spread for WinForms now supports all new [Forecast functions.](https://developer.mescius.com/spreadnet/docs/latest/online-formula/forecast-ets.html)

## Resolved Issues

The following issues have been resolved since the last release.

* FontSizeChanged event is updated to fit the content automatically with row height when the user changes settings using UI.
* Fixed error message in exported Excel file.
* Fixed the issue where copying a row and pasting it into a row containing locked cells.
* Fixed the issue to type Korean vowels normally.
* Fixed the performance issue while loading XLSX files.
* Fixed the issue where applying "[$-ko-KR]mmm" to a cell format, displayed it in English abbreviations.
* Fixed the issue where the EditModeStarting event could not be fired after starting editing.
* XML is now working correctly while opening XML using Open() method on a form.
* Fixed the performance of Workbookset.Calculate() method.
* Fixed the issue where license file was generated incorrectly when using the build configuration name with whitespace characters.
* Fixed an issue where setting horizontal scroll using events resulted in bidirectional scrolling.
* Fixed an issue where the “Merge cells” checkbox in the Alignment tab of the Format cells dialog was disabled.
* Fixed the issue where the value of the DataField property was lost after upgrading from v13 to v15.
* The “RecalculateAll” method now works correctly independent of the AutoCalculation value.
* Fixed the delay that occurs after calling the PrintSheet() method.
* [Designer] Fixed the issue where the Spread Designer did not appear normally while using multiple monitors, when loading for the first time.
* [Designer] Korean name of Sparkline is now properly shown.
* Excel files can be loaded without any exception when using BackgroundWorker class to show progress indicator.

## File Versions

Spread for WinForms installs the following file versions on your system. See [Installed Files](/spreadnet/docs/latest/readme/installedfiles/installfilesspwin) for the exact location of these files.

| **File** | **Version** |
| ---- | ------- |
| FarPoint.Win.Spread.dll | 16.0.20221.0 |
| FarPoint.Win.Spread.Html.dll | 16.0.20221.0 |
| FarPoint.Win.dll | 16.0.20221.0 |
| FarPoint.Win.Design.dll | 16.0.20221.0 |
| FarPoint.Win.Spread.Design.dll | 16.0.20221.0 |
| FarPoint.PluginCalendar.WinForms.dll | 16.0.20221.0 |
| FarPoint.SpreadDesigner.exe | 16.0.20221.0 |
| FarPoint.CalcEngine.dll | 16.0.20221.0 |
| FarPoint.Excel.dll | 16.0.20221.0 |
| FarPoint.Win.Ink.dll | 16.0.20221.0 |
| FarPoint.Win.TextRenderer.dll | 16.0.20221.0 |
| FarPoint.PDF.dll | 16.0.20221.0 |
| FarPoint.Win.Chart.dll | 16.0.20221.0 |
| FarPoint.Win.Chart.Design.dll | 16.0.20221.0 |
| GrapeCity.Win.PluginInputMan.Design.dll | 16.0.20221.0 |
| GrapeCity.Win.PluginInputMan.dll | 16.0.20221.0 |
| GrapeCity.CalcEngine.dll | 16.0.20221.0 |
| GrapeCity.Spreadsheet.dll | 16.0.20221.0 |
| GrapeCity.Spreadsheet.Win.dll | 16.0.20221.0 |