Lancements de Spread.NET

Released: Jul 28, 2021

Mises à jour de 14.2

Fonctionnalités

  • Frozen Trailing Stick-To-Edge Option - This enhancement affects the layout of frozen trailing columns and rows. These columns are always displayed on the right side, or on the left if RightToLeft is true. This new feature allows you to set a new property, FpSpread.FrozenTrailingStickToEdge.
  • Frozen Line Color - The Frozen Line Color lets you specify a color for the lines drawn between the non-scrollable and scrollable areas of the worksheet.
  • Clipboard Paste To Visible Cells Only...

Released: May 20, 2021

Mises à jour de 14.1

Fonctionnalités

New CalculationOnDemandMode and CellValueChanged Event

  • This enhancement gives developers control over the calculation of on-demand behavior and recalculation of dependent cells. Setting CalculationOnDemandMode to Off will force dependent cells to immediately recalculate - triggering the new CellValueChanged event for each of those cells. This event is used to handle changes to calculated cells caused by formulas, which is useful for tracking all workbook changes.

Performance...

Released: Nov 17, 2020

Mises à jour de 14

Fonctionnalités

Microsoft .NET 5.0 and Microsoft .NET Core 3.1 Windows Forms Controls

  • This release includes a new NuGet package GrapeCity.Spread.WinForms for .NET 5 and .NET Core 3.1 WinForms. Users can create WinForms applications using the Spread controls in .NET 5 and .NET Core 3.1 and port existing WinForms projects using GrapeCity Spread. NET controls.
    • Design-time support is limited in the new platforms, so it is recommended to keep using the full-framework (Microsoft .NET 4.5.2 and later...

Released: Aug 5, 2020

Mises à jour de 13.45.20203.0

Fonctionnalités

  • New API allows users to check cell validation status.

Correctifs

  • NullReferenceException is not thrown while printing to PDF format.
  • The formula entered in a cell is retained as it is in Spread Designer.
  • Row tag can now be restored while using XML.
  • Subscripts appear incorrectly in the application.
  • Images are exported with different names when exporting form Spread to Microsoft Excel.
  • There is no effect on performance when *.ss6 file in code-behind is loaded with FormulaTextBox...

Released: Nov 6, 2019

Mises à jour de 13

Fonctionnalités

  • New Enhanced Shape Engine.
  • Shape property bindings for making rich interactive shapes.
  • Copy-paste enhancements between Microsoft Excel and Spread.NET.
  • Slicers for table filtering.
  • VisualFunctions for custom data visualization.
  • Enhanced XLOOKUP and XMATCH with support for new "search_mode 0 - All" to return all matching items in an array.
  • Automatic formatting of formula values.
  • Automatic adjustment of row header width to size with the text as the sheet is scrolled down...

Released: May 28, 2019

Mises à jour de 12 Service Pack 1

Fonctionnalités

  • Dynamic Array Support - You can now enter cell formulas that return array values which “spill” into empty adjacent cells. This powerful feature is a new alternative to array formulas and includes support for seven new formula functions and the new operators for spilled range (#) and range intersection (@).
  • New Spread Designer Enhancements - The Spread Designer tool now supports the Formulas tab with tools for Defined Names, Formula Auditing and Calculation. This new UI also...

Released: Dec 5, 2018

Mises à jour de 12

Fonctionnalités

Performance improvements in data binding, design-time, and encrypted Excel files

  • Data Binding: Internal logic improvements that move data binding support into the core spreadsheet models enhances performance, especially for common use cases involving calculations with bound data.
  • Encrypted XLSX: Internal logic improvements moving encryption/decryption support into the core spreadsheet models enhances performance when importing or exporting password-protected Excel files.
  • Design...

Released: Jul 25, 2018

Mises à jour de 11 Service Pack 2

Fonctionnalités

  • Digital Signatures on DLLs - Starting with this release, each assembly of Spread.NET 11 will be signed with the GrapeCity digital signature.
  • Important Breaking Changes in Spread.NET 11 Components and Controls
    • The minimum target framework version is changed from .NET 4.0 to .NET 4.5.2. Microsoft has dropped support for .NET 4.0, 4.5, and 4.5.1 and implemented support for "quirking" in the latest supported frameworks. This change affects all assemblies of Spread.NET 11.
  • Important...

Released: Apr 25, 2018

Mises à jour de 11 Service Pack 1

Fonctionnalités

  • Windows Forms - Now supports filtering by Color on No Fill, like Excel.
  • ASP.NET - To reduce the view state size for cases with many hidden cells, new property AllowGenerateHiddenData can be set to false. This property is much more powerful than AllowGetAllHiddenValue - when AllowGenerateHiddenData is set to false, then all hidden values in the sheet are kept server-side, reducing the size of view state and also improving the security of the page for cases where the hidden values...

Released: Dec 6, 2017

Mises à jour de 11

Fonctionnalités

  • Performance Improvements - Up to 80% faster and using a fraction of the memory. Spread.NET 11 can import, export, and calculate your Excel documents faster than ever before.
  • New Calculation Functions - This new version adds more than 130 new calculation functions, bringing the total number to 462. Support for array formulas (entered using Ctrl+Shift+Enter) enable advanced matrix and array calculations and the new CircularFormula event fires to inform you when the user enters a...