GrapeCity.Spread.WinForms
16.2.1.14
See the version list below for details.
dotnet add package GrapeCity.Spread.WinForms --version 16.2.1.14
NuGet\Install-Package GrapeCity.Spread.WinForms -Version 16.2.1.14
<PackageReference Include="GrapeCity.Spread.WinForms" Version="16.2.1.14" />
paket add GrapeCity.Spread.WinForms --version 16.2.1.14
#r "nuget: GrapeCity.Spread.WinForms, 16.2.1.14"
// Install GrapeCity.Spread.WinForms as a Cake Addin #addin nuget:?package=GrapeCity.Spread.WinForms&version=16.2.1.14 // Install GrapeCity.Spread.WinForms as a Cake Tool #tool nuget:?package=GrapeCity.Spread.WinForms&version=16.2.1.14
Enterprise Spreadsheet Solutions for .NET Developers
GrapeCity Spread WinForms (GcSpread) is a multi-functional spreadsheet that professional Visual Studio developers use to create windows and web applications for analysis, dashboard, data collection and management, scientific, financial and other similar programs. GcSpread includes .NET spreadsheet components, template designers, charting components, extensive API, and more. The object model closely mirrors Excel and models the Visual Studio Tools for Office API so it is intuitive to use.
GcSpread supports many popular features such as native Excel input and output, a powerful and extensible calculation engine with over 500+ functions and support for custom functions, iterative calculations, dynamic arrays, custom cell data types, charting, tables, slicers, sparklines, conditional formatting, international localization, printing, sorting, filtering, drag-fill, grouping, undo/redo, data validation, input controls, and much, much more.
For more detailed information about the features and other spreadsheet .NET components for ASP.NET and WPF included with the license for GcSpread, please see https://www.grapecity.com/spreadnet.
GcSpread is licensed per-developer and a free 30-day evaluation trial license is automatically generated on first use. To read the End User License Agreement (EULA) please see https://www.grapecity.com/legal/eula.
For more details about pricing and licensing for Spread.NET, please see https://grapecity.com/spreadnet/pricing.
To inquire about licensing and volume discounts, please contact GrapeCity sales at us.sales@grapecity.com.
The online GrapeCity Spread WinForms sample browser is available at https://www.grapecity.com/spreadnet/demos
The online Spread.NET documentation is available at https://www.grapecity.com/spreadnet/docs/
To download the online installer for installing the Spread.NET ASP.NET and/or WPF components, please see https://www.grapecity.com/spreadnet/download.
The full source code for the samples including projects and solutions for Visual Studio 2022 is available at: https://cdn.grapecity.com/SpreadNET/demos/winforms/explorer/code.zip
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Framework | net462 is compatible. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
-
.NETFramework 4.6.2
- No dependencies.
-
net6.0
- No dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
18.0.0 | 642 | 12/5/2024 |
17.2.0 | 1,114 | 11/12/2024 |
17.1.0 | 3,616 | 4/25/2024 |
17.0.5 | 319 | 5/28/2024 |
17.0.4 | 917 | 4/2/2024 |
17.0.3 | 3,200 | 3/1/2024 |
17.0.1 | 2,614 | 1/5/2024 |
17.0.0 | 2,259 | 12/22/2023 |
16.2.1.14 | 4,318 | 11/14/2023 |
16.2.0.1475 | 5,043 | 7/26/2023 |
16.1.0.1458 | 14,365 | 5/16/2023 |
16.0.3.3 | 6,218 | 2/23/2023 |
16.0.2.1018 | 4,944 | 1/9/2023 |
16.0.1 | 4,691 | 12/2/2022 |
16.0.0 | 4,900 | 11/1/2022 |
15.3.0 | 18,300 | 9/2/2022 |
15.2.0 | 6,087 | 7/26/2022 |
15.1.0 | 10,856 | 4/26/2022 |
15.0.1 | 8,784 | 11/17/2021 |
15.0.0 | 6,884 | 11/17/2021 |
14.2.0 | 5,733 | 7/28/2021 |
14.1.0 | 5,074 | 5/26/2021 |
14.0.0 | 6,588 | 11/3/2020 |
# Changes from version 16.2.1:
- ArgumentException when getting the cell value from the Cell using Spread 16. (SPNET-34172)
#Changes in version 16.2.0:
* This release contains no new enhancements
- [Release Notes](https://www.grapecity.com/spreadnet/docs/latest/readme/rnotesSpWin.html)
#Changes in version 16.1.0:
* [Form Controls] (https://www.grapecity.com/spreadnet/docs/latest/online-win/form-controls.html)
* [Shape 3D Rotation] (https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-shape-rotate.html)
* Save a Sheet as an Image including row or column headers.
* Scroll Ribbon Gallery with Spin Buttons in the Designer.
* [Data Table Formula Performance] (https://www.grapecity.com/spreadnet/docs/latest/online-win/using-datatable-formula.html) has been enhanced, in addition to full date column selection.
#Changes in version 16.0.0:
* [Rich Text Editing](https://www.grapecity.com/spreadnet/docs/latest/online-win/rich-text-editing-design.html) lets users input rich text with multiple text colors and font styles directly in cells while editing.
* [Copy/Paste Multiple Ranges](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cntrlclipopts.html#i-heading-enable-multi-range-selection-for-copy-paste) and [Format Multiple Ranges](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-seladdremove.html#i-heading-working-with-multi-range-selections) using the [Cell Format Dialog](https://www.grapecity.com/spreadnet/docs/latest/online-win/work-with-builtin-dialog.html#i-heading-format-cells-dialog).
* [Center Across Selection](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cellalign.html#i-heading-center-across-selection) instead of merging cells allows more flexible cell selection by the end-user.
* Add replies to [Threaded Comments](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cells-comment.html#i-heading-threaded-comments) directly in the sheet and create [New Threaded comments](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cells-comment.html#i-heading-using-code) for cells.
* [Fill Effects Dialog](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cells-comment.html#i-heading-using-runtime-ui) lets users fill the cell comment block with [Gradient Fill Effects](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cells-comment.html#i-heading-gradient-fill-effects).
* [Picture Effects](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-images.html#i-heading-picture-adjustments) draws images using different types of artistic effects.
* [Number Format for Column Footer Cells](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-columnfooter.html#i-heading-set-column-footer-format)
* [Set Frozen Line Width](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-rowcol-freeze.html#i-heading-set-frozen-line-width) for the line between frozen and non-frozen areas.
* 14 new Text and Array Formula Functions
- [CHOOSECOLS](https://www.grapecity.com/spreadnet/docs/latest/online-formula/choose-cols-function.html) returns the specified columns from an array
- [CHOOSEROWS](https://www.grapecity.com/spreadnet/docs/latest/online-formula/choose-rows-function.html) returns the specified rows from an array
- [DROP](https://www.grapecity.com/spreadnet/docs/latest/online-formula/drop-function.html) drops rows or columns from array start or end
- [EXPAND](https://www.grapecity.com/spreadnet/docs/latest/online-formula/expand-function.html) expands an array to the specified dimensions
- [HSTACK](https://www.grapecity.com/spreadnet/docs/latest/online-formula/hstack-function.html) stacks arrays horizontally
- [TAKE](https://www.grapecity.com/spreadnet/docs/latest/online-formula/take-function.html) returns rows or columns from array start or end
- [TEXTAFTER](https://www.grapecity.com/spreadnet/docs/latest/online-formula/textafter-function.html) returns text that’s after delimiting characters
- [TEXTBEFORE](https://www.grapecity.com/spreadnet/docs/latest/online-formula/textbefore-function.html) returns text that’s before delimiting characters
- [TEXTSPLIT](https://www.grapecity.com/spreadnet/docs/latest/online-formula/textsplit-function.html) splits text into rows or columns using delimiters
- [TOCOL](https://www.grapecity.com/spreadnet/docs/latest/online-formula/tocol-function.html) returns the array as one column
- [TOROW](https://www.grapecity.com/spreadnet/docs/latest/online-formula/torow-function.html) returns the array as one row
- [VSTACK](https://www.grapecity.com/spreadnet/docs/latest/online-formula/vstack-function.html) stacks arrays vertically
- [WRAPCOLS](https://www.grapecity.com/spreadnet/docs/latest/online-formula/wrap-cols-function.html) wraps a column array into a 2D array
- [WRAPROWS](https://www.grapecity.com/spreadnet/docs/latest/online-formula/wrap-rows.html) wraps a row array into a 2D array
* 4 new functions for forecasting using Exponential Triple Smoothing (ETS)
- [FORECAST.ETS](https://www.grapecity.com/spreadnet/docs/latest/online-formula/forecast-ets.html) forecasts values from historical values using Exponential Triple Smoothing (ETS)
- [FORECAST.ETS.CONFINT](https://www.grapecity.com/spreadnet/docs/latest/online-formula/forecast-confint.html) returns a confidence interval for the forecast value at a specified date
- [FORECAST.ETS.SEASONALITY](https://www.grapecity.com/spreadnet/docs/latest/online-formula/forecast-season.html) returns the length of the seasonal pattern detected from historical values
- [FORECAST.ETS.STAT](https://www.grapecity.com/spreadnet/docs/latest/online-formula/forecast-statistics.html) returns a statistical value as a result of applying Exponential Triple Smoothing (ETS)
* 1 new function for embedding an image in a cell
- [IMAGE](https://www.grapecity.com/spreadnet/docs/latest/online-formula/image-function.html) displays the specified image from a source URL in the cell with optional alternate text for accessibility (supports BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP image formats)
- [IMAGE Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/image-sparkline.html) is renamed to GC.IMAGE
* 7 new [Built-In Dialogs](https://www.grapecity.com/spreadnet/docs/latest/online-win/work-with-builtin-dialog.html) for end-users
- [Insert Function Dialog](https://www.grapecity.com/spreadnet/docs/latest/online-win/insert-function-dialog.html) inserts a formula function and its arguments in the active cell, or show the dialog in code using [ToggleInsertFunction](https://www.grapecity.com/spreadnet/docs/latest/online-win/work-with-builtin-dialog.html#i-heading-insert-function-dialog).
- [Sheet Protection Options](https://www.grapecity.com/spreadnet/docs/latest/online-win/protecting-a-worksheet.html) locks the sheet to specify which actions the user is allowed to do using the [Protect Sheet Dialog](https://www.grapecity.com/spreadnet/docs/latest/online-win/FarPoint.Win.Spread~FarPoint.Win.Spread.ProtectSheetDialog_members.html) or [Protect Method](https://www.grapecity.com/spreadnet/docs/latest/online-win/protecting-a-worksheet.html#i-heading-using-code).
- [Forecast Sheet](https://www.grapecity.com/spreadnet/docs/latest/online-win/forecast-sheet-dialog.html) creates a new sheet to forecast future values using the new FORECAST.ETS and related functions, or show the dialog in code using the [Forecast Sheet Dialog](https://www.grapecity.com/spreadnet/docs/latest/online-win/work-with-builtin-dialog.html#i-heading-create-forecast-worksheet-dialog).
- Users can now perform advanced what-if analysis with [Goal Seek](https://www.grapecity.com/spreadnet/docs/latest/online-win/goal-seek-dialog.html) using the new [Goal Seek Dialog](https://www.grapecity.com/spreadnet/docs/latest/online-win/work-with-builtin-dialog.html#i-heading-goal-seek-dialog) or [Goal Seek Method](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-formula-goalseek.html).
- Users can now add a [Calculated Data Table](https://www.grapecity.com/spreadnet/docs/latest/online-win/using-datatable-formula.html) in a range of cells using the new [Data Table Dialog](https://www.grapecity.com/spreadnet/docs/latest/online-win/work-with-builtin-dialog.html#i-heading-data-table-dialog) or [DataTable Method](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~DataTable.html).
- Users can now [Remove Duplicates](https://www.grapecity.com/spreadnet/docs/latest/online-win/remove-duplicates.html) in the selected range using the [Remove Duplicates Dialog](https://www.grapecity.com/spreadnet/docs/latest/online-win/work-with-builtin-dialog.html#i-heading-remove-duplicates-dialog) or [RemoveDuplicates Method](https://www.grapecity.com/spreadnet/docs/latest/online-win/remove-duplicates.html#i-heading-using-code).
- Users can now use [Text-To-Columns](https://www.grapecity.com/spreadnet/docs/latest/online-win/text-to-columns.html) to split delimited text in a range of cells across the columns in a target range using [Text-To-Columns Dialog](https://www.grapecity.com/spreadnet/docs/latest/online-win/work-with-builtin-dialog.html#i-heading-convert-text-to-columns-wizard-dialog) or [TextToColumns Method](https://www.grapecity.com/spreadnet/docs/latest/online-win/text-to-columns.html#i-heading-using-code).
#Changes in version 15.3.0:
* This release contains no new enhancements
- [Release Notes](https://www.grapecity.com/spreadnet/docs/latest/readme/rnotesSpWin.html)
#Changes in version 15.2.0:
* This release contains no new enhancements
- [Release Notes](https://www.grapecity.com/spreadnet/docs/latest/readme/rnotesSpWin.html)
#Changes in version 15.1.0:
* Baseline .NET Framework version changed from .NET 4.5.2 to .NET 4.6.2 (see [MS blog](https://devblogs.microsoft.com/dotnet/net-framework-4-5-2-4-6-4-6-1-will-reach-end-of-support-on-april-26-2022/))
- [Product Requirements](https://www.grapecity.com/spreadnet/docs/latest/online-win/product_reqs20.html)
- [Handling Redistribution](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-redistprod.html)
- [Enable DPI Support](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-dpisupport.html)
* [New NuGet Package introduced for GrapeCity.Spread.WinForms.Design](https://www.grapecity.com/spreadnet/docs/latest/online-win/SDnugetpackage.html) containing design-time support UI and the Spread Designer component for showing the designer in run-time.
* [New Cell Styles UI in Spread Designer](https://www.grapecity.com/spreadnet/docs/latest/online-win/SDCellStyles.html): Apply built-in cell styles that automatically change with the Theme as in Excel.
* [Use '+' and '-' to enter formulas in cells and the FormulaTextBox](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-formulaallowuser.html#i-heading-using-plus-or-minus-sign): Users can now enter formulas this way as in Excel.
* [Crop Shape Picture using ICrop](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-images.html#i-heading-crop-images): use the ICrop interface to specify PictureOffsetX, PictureOffsetY, PictureWidth, and PictureHeight for cropping the picture in a shape.
* [Automatic Number Format](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cells-format.html#i-heading-general-format): built-in automatic number format applied in all cells where there is no custom number format (flat-style mode only – LegacyBehaviors.Style can't be set).
* [Inline Cell Image](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cells-image.html): set image object to cell, or local file path, or base-64 encoded image
* [Formatted Number Cell Value](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cells-formatcellvalue.html): Number value and format string together in one object, enabling consistent automatic formatting of the number values across calculation cycles; the format is applied to the value instead of the cell.
- This feature is currently part of [ExcelApi BETA](https://docs.microsoft.com/en-us/javascript/api/excel/excel.formattednumbercellvalue?view=excel-js-preview)
- [New Excel Compatible Keyboard Shortcuts](https://www.grapecity.com/spreadnet/docs/latest/online-win/using_excel_compatible_keyboard_shortcuts.html): New shortcuts CTRL+PageUp and CTRL+PageDown navigate to Next Sheet and Previous Sheet when FpSpread.Features.ExcelCompatibleKeyboardShortcuts is enabled.
#Changes in version 15.0.0:
* .NET 6 Supported:
- [Product Requirements](https://www.grapecity.com/spreadnet/docs/latest/online-win/product_reqs20.html)
- [How to Add NuGet Packages in a .NET 6 Project](https://www.grapecity.com/spreadnet/docs/latest/online-win/adding-nuget-package-spread-windows-forms.html)
- [How to Migrate From .NET Framework](https://www.grapecity.com/spreadnet/docs/latest/online-win/migrate_net_framework_project_to_netcore31_net5.html)
* 20 [Enhanced Sparkline Visual Functions](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-sparkline-func.html) in the spreadsheet.
- [Column Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/columnline-sparkline.html)
- [Line Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/columnline-sparkline.html)
- [Win-Loss Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/columnline-sparkline.html)
- [Area Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/area-sparkline.html)
- [BoxPlot Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/boxplot-sparkline.html)
- [Bullet Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/bullet-sparkline.html)
- [Cascade Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/cascade-sparkline.html)
- [Gauge Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/gauge-kpi-sparkline.html)
- [Hbar Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/hbar-vbar-sparkline.html)
- [Vbar Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/hbar-vbar-sparkline.html)
- [Histogram Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/histogram-sparkline.html)
- [Image Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/image-sparkline.html)
- [Month Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/month-year-sparkline.html)
- [Year Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/month-year-sparkline.html)
- [Pareto Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/pareto-sparkline.html)
- [Pie Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/pie-sparkline.html)
- [Scatter Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/scatter-sparkline.html)
- [Spread Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/spread-sparkline.html)
- [Stacked Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/stacked-sparkline.html)
- [Vari Sparkline Function](https://www.grapecity.com/spreadnet/docs/latest/online-win/vari-sparkline.html)
* Users can [Hide Sparkline Group Indicators](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-sparktype.html#i-heading-hide-group-indicator) by using the SparklineGroupRenderer property.
* [Enhanced Camera Shape](https://www.grapecity.com/spreadnet/docs/latest/online-win/camerashape-enhanced.html) is inherits and use all the features of the Enhanced Shape Engine.
* Spread for Winforms provides the [Enhanced Border Option](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cellborder.html) to paint borders the same as in Excel.
* New [Keyboard Shortcuts are added for Excel Compatibility](https://www.grapecity.com/spreadnet/docs/latest/online-win/using_excel_compatible_keyboard_shortcuts.html).
* [Extend Table Rows or Columns Automatically](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-tableresize.html#i-heading-automatically-extend-table-rows-or-columns) using the AutoExpandTable property.
* Automatically fill a column with the entered formula in the table by using the [AutoCreateCalculatedColumns Property](https://www.grapecity.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://www.grapecity.com/spreadnet/docs/latest/online-win/insert-cells.html) in a spreadsheet using the context menu.
* The new [LAMBDA Function](https://www.grapecity.com/spreadnet/docs/latest/online-formula/functionLambda.html) is introduced to enable users to create new custom functions using custom names and formulas.
* 7 new LAMBDA helper functions are added to help create advanced LAMBDA functions
- [BYCOL](https://www.grapecity.com/spreadnet/docs/latest/online-formula/functionBycol.html) applies a LAMBDA to each column in an array
- [BYROW](https://www.grapecity.com/spreadnet/docs/latest/online-formula/functionByrow.html) applies a LAMBDA to each row in an array
- [ISOMMITED](https://www.grapecity.com/spreadnet/docs/latest/online-formula/functionIsomitted.html) specifies whether an optional LAMBDA parameter was specified
- [MAKEARRAY](https://www.grapecity.com/spreadnet/docs/latest/online-formula/functionMakearray.html) applies a LAMBDA to each cell in a new array to initialize the contents
- [MAP](https://www.grapecity.com/spreadnet/docs/latest/online-formula/functionMap.html) applies a LAMBDA to each element of a set of arrays and returns a new array
- [REDUCE](https://www.grapecity.com/spreadnet/docs/latest/online-formula/functionReduce.html) applies a LAMBDA each element of an array using an accumulator and returns the accumulated value
- [SCAN](https://www.grapecity.com/spreadnet/docs/latest/online-formula/functionScan.html) applies a LAMBDA to each element of an array using an accumulator and returns a new array of accumulated values
* Users can now [Protect and Unprotect Worksheets](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-spd-menu-data.html) in Spread Designer.
* [Bind Tables to a Data Source](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-tablebind.html) using the new ITable and ITableColumn interfaces.
* [Display Negative Data Label Values and Value Axis Labels of a Chart in Red Color](https://www.grapecity.com/spreadnet/docs/latest/online-win/fpchart-style-labels.html#i-heading-display-negative-numbers-in-red) using the LabelNegativeRed property. ExcelIO supports using Excel format codes for displaying negative red labels.
* Add [Rich Text in Cells](https://www.grapecity.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 to True.
- [IFeatures.RichText](https://www.grapecity.com/spreadnet/docs/latest/online-win/FarPoint.Win.Spread~FarPoint.Win.Spread.IFeatures~RichText.html)
* Create open and closed custom shapes using annotation mode options such as the [Freeform shape and Freeform scribble](https://www.grapecity.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, powered by the new Enhanced Shape Engine](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cells-comment.html).
* The conditional format dialog has been improved and now supports the [Duplicate Rule Button](https://www.grapecity.com/spreadnet/docs/latest/online-win/SDconditionalDialog.html#i-heading-rules-manager-dialog) and resizing the dialog.
* [Retain the Suffix and Prefix Whitespace](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-formulaplace.html) characters of the formula expression by using the ReserveFormulaWhiteSpaces enumeration.
* The [Textbox Height in the Name Manager Dialog](https://www.grapecity.com/spreadnet/docs/latest/online-win/SDNameManager.html) can now be resized.
* Users can now directly assign the [Image Paths in Cell Values](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-setimagecell.html) when working with Image Cell Type.
* New [Shape and Image-related Cursor Type Options](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cntrlcursor.html) are added to set the cursor or pointer to appear differently for different parts of the spreadsheet.
- [CursorType](https://www.grapecity.com/spreadnet/docs/latest/online-win/FarPoint.Win.Spread~FarPoint.Win.Spread.CursorType.html)
* [26 New VSTO-like APIs](https://www.grapecity.com/spreadnet/docs/latest/readme/vsto-api.html) are added in IRange and IWorksheet interfaces.
- [IRange.AutoFill](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~AutoFill.html)
- [IRange.HasRichDataType](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~HasRichDataType.html)
- [IRange.Resize](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~Resize.html)
- [IRange.Width](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~Width.html)
- [IRange.Top](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~Top.html)
- [IRange.Height](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~Height.html)
- [IRange.Left](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~Left.html)
- [IRange.UseStandardWidth](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~UseStandardWidth.html)
- [IRange.UseStandardHeight](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~UseStandardHeight.html)
- [IRange.ShowCard](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~ShowCard.html)
- [IRange.Show](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~Show.html)
- [IRange.Next](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~Next.html)
- [IRange.Previous](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~Previous.html)
- [IRange.FillDown](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~FillDown.html)
- [IRange.FillLeft](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~FillLeft.html)
- [IRange.FillRight](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~FillRight.html)
- [IRange.FillUp](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~FillUp.html)
- [IRange.Dirty](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~Dirty.html)
- [IRange.BorderAround](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~BorderAround.html)
- [IRange.Characters](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~Characters.html)
- [IRange.SpecialCells](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IRange~SpecialCells.html)
- [IWorksheet.UsedRange](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IWorksheet~UsedRange.html)
- [IWorksheet.StandardWidth](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IWorksheet~StandardWidth.html)
- [IWorksheet.StandardHeight](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IWorksheet~StandardHeight.html)
- [IWorksheet.Next](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IWorksheet~Next.html)
- [IWorksheet.Previous](https://www.grapecity.com/spreadnet/docs/latest/online-win/GrapeCity.Spreadsheet~GrapeCity.Spreadsheet.IWorksheet~Previous.html)
# Changes in version 14.2.0:
* Users can now set the [FrozenTrailingStickToEdge Option](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-rowcol-freeze.html#i-heading-set-trailing-frozen-rows-or-columns) to control whether to display the blank space between the data rows and columns, and the frozen trailing rows and columns.
* Spread Winforms also provides the option to [Set the Frozen Line Color](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-rowcol-freeze.html#i-heading-set-frozen-line-color) with FrozenLineColor option.
* Users can now [Set Whether to Paste the Clipboard Values in Invisible Cells, Rows, and Columns](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cntrlclipopts.html#i-heading-disabling-pasting-in-invisible-cells) by using the PasteSkipInvisibleRange option.
* Users can [Hide the Rows and Columns Outlines](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-outline-using.html) using ShowOutline option.
# Changes in version 14.1.0:
* Users can [Use the CacheOptions enumeration to Improve the Performance]( https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-perfimprovements.html#i-heading-improve-performance-using-cacheoptions) of specific formula functions, such as LOOKUP and MATCH type formulas with exact match.
* Spread Winforms supports [Tracing Precedents and Dependents Cells](https://www.grapecity.com/spreadnet/docs/latest/online-win/precedents-dependents.html) in spreadsheets along with fetching external references.
* Users can now add [Percentage Labels in Pie Chart](https://www.grapecity.com/spreadnet/docs/latest/online-win/fpchart-make-pie.html).
* Users can now [Hide and Unhide Sheets Using Tab Strip Context Menu](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-sheethide.html).
* New formula functions ARRAYTOTEXT and VALUETOTEXT have been introduced to return text values from different non-text values:
- [ARRAYTOTEXT](https://www.grapecity.com/spreadnet/docs/latest/online-formula/FunctionARRAYTOTEXT.html) returns a text value from an array
- [VALUETOTEXT](https://www.grapecity.com/spreadnet/docs/latest/online-formula/FunctionVALUETOTEXT.html) returns a text value from a value
* [Scroll by Pixel through Mouse Wheel](https://www.grapecity.com/spreadnet/docs/latest/online-win/spwin-cntrlscrollbars.html) is now supported in Spread Winforms.
# Fixed Issues
- [Release Notes](https://www.grapecity.com/spreadnet/docs/latest/readme/rnotesSpWin.html)