# Release Notes for Version 15.0.20211.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 supports .NET 6 platform. You can check out its [product requirements](https://developer.mescius.com/spreadnet/docs/latest/online-win/product_reqs20.html), [how to add Nuget packages in a .NET 6 project](https://developer.mescius.com/spreadnet/docs/latest/online-win/adding-nuget-package-spread-windows-forms.html), and [how to migrate from .NET Framework](https://developer.mescius.com/spreadnet/docs/latest/online-win/migrate_net_framework_project_to_netcore31_net5.html).
* Users can add [enhanced sparklines as visual functions](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-sparkline-func.html) in the spreadsheet. There are 17 different sparkline types to choose from, and you can add them through the Spread Designer as well.
* [Column, line, and winloss sparklines](https://developer.mescius.com/spreadnet/docs/latest/online-win/columnline-sparkline.html) can now be set using formula functions as well.
* Users can [hide sparkline group indicators](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-sparktype.html#i-heading-hide-group-indicator) by using the SparklineGroupRenderer property.
* The [camera shape](https://developer.mescius.com/spreadnet/docs/latest/online-win/camerashape-enhanced.html) is enhanced to inherit and use all the features of the Enhanced Shape Engine.
* Spread for Winforms provides the [enhanced border option](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-cellborder.html) to paint borders the same as in Excel.
* [New keyboard shortcuts](https://developer.mescius.com/spreadnet/docs/latest/online-win/using_excel_compatible_keyboard_shortcuts.html) are added for Excel compatibility.
* Extend table rows or columns automatically using the [AutoExpandTable property](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-tableresize.html#i-heading-automatically-extend-table-rows-or-columns).
* Automatically fill a column with the entered formula in the table by using the [AutoCreateCalculatedColumns property](https://developer.mescius.com/spreadnet/docs/latest/online-win/tableformula.html#i-heading-automatically-create-calculated-columns).
* Spread for Winforms allows you to [insert cells, cut or copied cell ranges](https://developer.mescius.com/spreadnet/docs/latest/online-win/insert-cells.html) in a spreadsheet using the context menu.
* The new [LAMBDA Function](https://developer.mescius.com/spreadnet/docs/latest/online-formula/functionLambda.html) is introduced to enable users to create new custom functions using custom names and formulas.
* Seven new LAMBDA helper functions are added to help create advanced LAMBDA functions - [BYCOL](https://developer.mescius.com/spreadnet/docs/latest/online-formula/functionBycol.html), [BYROW](https://developer.mescius.com/spreadnet/docs/latest/online-formula/functionByrow.html), [ISOMMITED](https://developer.mescius.com/spreadnet/docs/latest/online-formula/functionIsomitted.html), [MAKEARRAY](https://developer.mescius.com/spreadnet/docs/latest/online-formula/functionMakearray.html), [MAP](https://developer.mescius.com/spreadnet/docs/latest/online-formula/functionMap.html), [REDUCE](https://developer.mescius.com/spreadnet/docs/latest/online-formula/functionReduce.html), and [SCAN](https://developer.mescius.com/spreadnet/docs/latest/online-formula/functionScan.html).
* Users can now [protect and unprotect worksheets](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-spd-menu-data.html) in Spread Designer.
* Bind tables to a data source using the new [ITable and ITableColumn interfaces](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-tablebind.html).
* Display negative data label values and value axis labels of a chart in red color using the [LabelNegativeRed property](https://developer.mescius.com/spreadnet/docs/latest/online-win/fpchart-style-labels.html#i-heading-display-negative-numbers-in-red). ExcelIO supports using Excel format codes for displaying negative red labels.
* Add [rich text in cells](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-cells-richtext.html) and use formatting options such as fonts, text styles, colors, superscripts, and subscripts. ExcelIO supports rich text by setting the [FpSpread.Features.RichText property](https://developer.mescius.com/spreadnet/docs/latest/online-win/FarPoint.Win.Spread~FarPoint.Win.Spread.IFeatures~RichText.html) to True.
* Create open and closed custom shapes using annotation mode options such as the [Freeform shape and Freeform scribble](https://developer.mescius.com/spreadnet/docs/latest/online-win/working-with-shapes.html#i-heading-drawing-freeform).
* Spread for Winforms supports [adding comments to cells in a worksheet](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-cells-comment.html), powered by the new Enhanced Shape Engine.
* The conditional format dialog has been improved and now supports the [Duplicate Rule button and resizing the dialog](https://developer.mescius.com/spreadnet/docs/latest/online-win/SDconditionalDialog.html#i-heading-rules-manager-dialog).
* Retain the suffix and prefix whitespace characters of the formula expression by using the [ReserveFormulaWhiteSpaces enumeration](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-formulaplace.html).
* The textbox height in the [Name Manager](https://developer.mescius.com/spreadnet/docs/latest/online-win/SDNameManager.html) dialog can now be resized.
* Users can now [directly assign the image paths in cell values](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-setimagecell.html) when working with Image Cell Type.
* New shape and image-related [cursor type options](https://developer.mescius.com/spreadnet/docs/latest/online-win/FarPoint.Win.Spread~FarPoint.Win.Spread.CursorType.html) are added to [set the cursor or pointer](https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-cntrlcursor.html) to appear differently for different parts of the spreadsheet.
* New VSTO-like APIs are added in [IRange](https://developer.mescius.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange_members.html) and [IWorksheet](https://developer.mescius.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IWorksheet_members.html) interfaces. Refer to the [full list here](/spreadnet/docs/latest/readme/rnotes/rnotesSpWin/release-notesv15/vsto-api).

## Resolved Issues

The following issues have been resolved since the last release.

* The memory issue when printing a sheet is resolved.
* When printing PDF, the borders of row-spanned cells do not extrude to the page header.
* Spread works correctly in design time when using .NET 5.
* Formulas evaluate successfully in imported worksheets.
* Selection style of sheet is rendered correctly when using SelectionStyles.SelectionColors.
* Value of the cell is correct when ResetValue is called.
* Using the GetOwnerPrintColumnPageBreaks method multiple times does not throw argument exceptions.
* Viewport scroll works correctly when removing and subsequently adding rows to a sheet based on another sheet.
* Performance issue involving processes is resolved.
* Custom format for thousand separator is displayed correctly.
* Formula starting with a negative sign is retained if the sheet is removed from Spread.
* PageBreak settings of all rows are set correctly during XML import.
* Hidden column cannot be resized by end-user when ResizeIndicator is not visible.
* Sheet tab height is displayed correctly when applying the Office2013 theme.
* Header font is updated correctly when changed using DefaultStyle of ColumnHeader.
* Paper size is consistent while performing the print operation.
* Excel file exported to Spread displays correctly when subsequently exported to PDF.
* Drag Fill's context menu is scaled correctly with a high DPI setting.
* Spread for Winforms now works correctly for Finland regional settings.
* Combo box cells display correctly after upgrading Spread version in project.
* Parent row values are retained after creating hierarchical view.
* The calculation performance is resolved when using drag fill.
* The location of the picture is retained when using print and print preview.
* Custom skin for Spread is applied correctly.
* Values are formatted correctly when using de-DE (German) locale.

## 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 | 15.0.20211.0 |
| FarPoint.Win.Spread.Html.dll | 15.0.20211.0 |
| FarPoint.Win.dll | 15.0.20211.0 |
| FarPoint.Win.Design.dll | 15.0.20211.0 |
| FarPoint.Win.Spread.Design.dll | 15.0.20211.0 |
| FarPoint.PluginCalendar.WinForms.dll | 15.0.20211.0 |
| FarPoint.SpreadDesigner.exe | 15.0.20211.0 |
| FarPoint.CalcEngine.dll | 15.0.20211.0 |
| FarPoint.Excel.dll | 15.0.20211.0 |
| FarPoint.Win.Ink.dll | 15.0.20211.0 |
| FarPoint.Win.TextRenderer.dll | 15.0.20211.0 |
| FarPoint.PDF.dll | 15.0.20211.0 |
| FarPoint.Win.Chart.dll | 15.0.20211.0 |
| FarPoint.Win.Chart.Design.dll | 15.0.20211.0 |
| FarPoint.Localization.dll | 15.0.20211.0 |
| GrapeCity.Win.PluginInputMan.Design.dll | 15.0.20211.0 |
| GrapeCity.Win.PluginInputMan.dll | 15.0.20211.0 |
| GrapeCity.CalcEngine.dll | 15.0.20211.0 |
| GrapeCity.Spreadsheet.dll | 15.0.20211.0 |
| GrapeCity.Spreadsheet.Win.dll | 15.0.20211.0 |