#Changes in version 16.2.0:

• This release contains no new enhancements

• Release Notes

#Changes in version 16.1.0:

• [Form Controls] (https://developer.mescius.com/spreadnet/docs/latest/online-win/form-controls.html)
• [Shape 3D Rotation] (https://developer.mescius.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://developer.mescius.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 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 Cell Format 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.
• Fill Effects Dialog lets users fill the cell comment block with Gradient Fill Effects.
• Picture Effects draws images using different types of artistic effects.
• Number Format for Column Footer Cells
• Set Frozen Line Width for the line between frozen and non-frozen areas.
• 14 new Text and Array Formula Functions

• CHOOSECOLS returns the specified columns from an array
• CHOOSEROWS returns the specified rows from an array
• DROP drops rows or columns from array start or end
• EXPAND expands an array to the specified dimensions
• HSTACK stacks arrays horizontally
• TAKE returns rows or columns from array start or end
• TEXTAFTER returns text that’s after delimiting characters
• TEXTBEFORE returns text that’s before delimiting characters
• TEXTSPLIT splits text into rows or columns using delimiters
• TOCOL returns the array as one column
• TOROW returns the array as one row
• VSTACK stacks arrays vertically
• WRAPCOLS wraps a column array into a 2D array
• WRAPROWS wraps a row array into a 2D array

• 4 new functions for forecasting using Exponential Triple Smoothing (ETS)

• FORECAST.ETS forecasts values from historical values using Exponential Triple Smoothing (ETS)
• FORECAST.ETS.CONFINT returns a confidence interval for the forecast value at a specified date
• FORECAST.ETS.SEASONALITY returns the length of the seasonal pattern detected from historical values
• FORECAST.ETS.STAT returns a statistical value as a result of applying Exponential Triple Smoothing (ETS)

• 1 new function for embedding an image in a cell

• IMAGE 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 is renamed to GC.IMAGE

• 7 new Built-In Dialogs for end-users

• Insert Function Dialog inserts a formula function and its arguments in the active cell, or show the dialog in code using ToggleInsertFunction.
• Sheet Protection Options locks the sheet to specify which actions the user is allowed to do using the Protect Sheet Dialog or Protect Method.
• Forecast Sheet 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.
• Users can now perform advanced what-if analysis with Goal Seek using the new Goal Seek Dialog or Goal Seek Method.
• Users can now add a Calculated Data Table in a range of cells using the new Data Table Dialog or DataTable Method.
• Users can now Remove Duplicates in the selected range using the Remove Duplicates Dialog or RemoveDuplicates Method.
• Users can now use Text-To-Columns to split delimited text in a range of cells across the columns in a target range using Text-To-Columns Dialog or TextToColumns Method.

#Changes in version 15.3.0:

• This release contains no new enhancements

• Release Notes

#Changes in version 15.2.0:

• This release contains no new enhancements

• Release Notes

#Changes in version 15.1.0:

• Baseline .NET Framework version changed from .NET 4.5.2 to .NET 4.6.2 (see MS blog)

• Product Requirements
• Handling Redistribution
• Enable DPI Support

• New NuGet Package introduced for GrapeCity.Spread.WinForms.Design containing design-time support UI and the Spread Designer component for showing the designer in run-time.
• New Cell Styles UI in Spread Designer: Apply built-in cell styles that automatically change with the Theme as in Excel.
• Use '+' and '-' to enter formulas in cells and the FormulaTextBox: Users can now enter formulas this way as in Excel.
• Crop Shape Picture using ICrop: use the ICrop interface to specify PictureOffsetX, PictureOffsetY, PictureWidth, and PictureHeight for cropping the picture in a shape.
• Automatic Number 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: set image object to cell, or local file path, or base-64 encoded image
• Formatted Number Cell Value: 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
• New Excel Compatible Keyboard Shortcuts: 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
• How to Add NuGet Packages in a .NET 6 Project
• How to Migrate From .NET Framework

• 20 Enhanced Sparkline Visual Functions in the spreadsheet.

• Column Sparkline Function
• Line Sparkline Function
• Win-Loss Sparkline Function
• Area Sparkline Function
• BoxPlot Sparkline Function
• Bullet Sparkline Function
• Cascade Sparkline Function
• Gauge Sparkline Function
• Hbar Sparkline Function
• Vbar Sparkline Function
• Histogram Sparkline Function
• Image Sparkline Function
• Month Sparkline Function
• Year Sparkline Function
• Pareto Sparkline Function
• Pie Sparkline Function
• Scatter Sparkline Function
• Spread Sparkline Function
• Stacked Sparkline Function
• Vari Sparkline Function

• Users can Hide Sparkline Group Indicators by using the SparklineGroupRenderer property.
• Enhanced Camera Shape is inherits and use all the features of the Enhanced Shape Engine.
• Spread for Winforms provides the Enhanced Border Option to paint borders the same as in Excel.
• New Keyboard Shortcuts are added for Excel Compatibility.
• Extend Table Rows or Columns Automatically using the AutoExpandTable property.
• Automatically fill a column with the entered formula in the table by using the AutoCreateCalculatedColumns Property.
• Spread for Winforms allows you to Insert Cells, Cut or Copied Cell Ranges in a spreadsheet using the context menu.
• The new LAMBDA Function 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 applies a LAMBDA to each column in an array
• BYROW applies a LAMBDA to each row in an array
• ISOMMITED specifies whether an optional LAMBDA parameter was specified
• MAKEARRAY applies a LAMBDA to each cell in a new array to initialize the contents
• MAP applies a LAMBDA to each element of a set of arrays and returns a new array
• REDUCE applies a LAMBDA each element of an array using an accumulator and returns the accumulated value
• SCAN 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 in Spread Designer.
• Bind Tables to a Data Source using the new ITable and ITableColumn interfaces.
• Display Negative Data Label Values and Value Axis Labels of a Chart in Red Color using the LabelNegativeRed property. ExcelIO supports using Excel format codes for displaying negative red labels.
• Add Rich Text in Cells 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

• Create open and closed custom shapes using annotation mode options such as the Freeform shape and Freeform scribble.
• Spread for Winforms supports Adding Comments to Cells in a worksheet, 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.
• Retain the Suffix and Prefix Whitespace characters of the formula expression by using the ReserveFormulaWhiteSpaces enumeration.
• The Textbox Height in the Name Manager Dialog can now be resized.
• Users can now directly assign the Image Paths in Cell Values when working with Image Cell Type.
• New Shape and Image-related Cursor Type Options are added to set the cursor or pointer to appear differently for different parts of the spreadsheet.

• CursorType

• 26 New VSTO-like APIs are added in IRange and IWorksheet interfaces.

• IRange.AutoFill
• IRange.HasRichDataType
• IRange.Resize
• IRange.Width
• IRange.Top
• IRange.Height
• IRange.Left
• IRange.UseStandardWidth
• IRange.UseStandardHeight
• IRange.ShowCard
• IRange.Show
• IRange.Next
• IRange.Previous
• IRange.FillDown
• IRange.FillLeft
• IRange.FillRight
• IRange.FillUp
• IRange.Dirty
• IRange.BorderAround
• IRange.Characters
• IRange.SpecialCells
• IWorksheet.UsedRange
• IWorksheet.StandardWidth
• IWorksheet.StandardHeight
• IWorksheet.Next
• IWorksheet.Previous

Changes in version 14.2.0:

• Users can now set the FrozenTrailingStickToEdge Option 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 with FrozenLineColor option.
• Users can now Set Whether to Paste the Clipboard Values in Invisible Cells, Rows, and Columns by using the PasteSkipInvisibleRange option.
• Users can Hide the Rows and Columns Outlines using ShowOutline option.

Changes in version 14.1.0:

• Users can Use the CacheOptions enumeration to Improve the Performance of specific formula functions, such as LOOKUP and MATCH type formulas with exact match.
• Spread Winforms supports Tracing Precedents and Dependents Cells in spreadsheets along with fetching external references.
• Users can now add Percentage Labels in Pie Chart.
• Users can now Hide and Unhide Sheets Using Tab Strip Context Menu.
• New formula functions ARRAYTOTEXT and VALUETOTEXT have been introduced to return text values from different non-text values:

• ARRAYTOTEXT returns a text value from an array
• VALUETOTEXT returns a text value from a value

• Scroll by Pixel through Mouse Wheel is now supported in Spread Winforms.

Fixed Issues

• Release Notes