Released: Aug 5, 2020

13.45.20203.0 での更新項目

機能

• New API allows users to check cell validation status.

不具合の修正

• 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 presence...

Released: Nov 6, 2019

13 での更新項目

機能

• 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.
• BackgroundImage in...

Released: May 28, 2019

12 Service Pack 1 での更新項目

機能

• 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 supports enabling...

Released: Dec 5, 2018

12 での更新項目

機能

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 Time: Switched...

Released: Jul 25, 2018

11 Service Pack 2 での更新項目

機能

• 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 Breaking...

Released: Apr 25, 2018

11 Service Pack 1 での更新項目

機能

• 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 on the sheet...

Released: Dec 6, 2017

11 での更新項目

機能

• 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 formula which...

Released: Aug 4, 2017

10 SP2 での更新項目

機能

WinForms

• Added Spread Designer events.
  • Open
  • Save
  • Print with PrintOption enums ToPrinter and ToPDF
• Supports 300 High DPI in .NET framework 4.7.

不具合の修正

WinForms

• Chart lines are now imported correctly.
• Text is now displayed correctly.
• Title and subtitle text is now displayed correctly.
• Percentage value over Int32.MaxValue can now be set to GeneralCellType.
• SelectionChanging event now returns the correct range when selected from the keyboard.
• The thickness of borders is now uniform.
• The Pixel...

Released: Nov 18, 2016

10 での更新項目

機能

• New Charts - Pareto, Histogram, Waterfall, Funnel, BoxWhisker, Sunburst and Treemap.
• New Cell Types - GcCharMask, GcComboBox, GcMask, GcNumber, GcTextBox and GcTimeSpan.
• Enhanced Printing - Add security to your generated PDF files by password protecting them.

不具合の修正

Spread for WinForms

• Missing borders fixed when overflow text is too long.
• Right-aligned text now overflows to adjacent cells.
• SetColumnVisible now works in specific situations.
• Ctrl-X no longer changes the formula reference style...