What's New in Spread.NET v15

Spread.NET v15.3.20225.0 - September 2, 2022

We are happy to announce the release of Spread.NET v15.3.20225.0. This release includes an important fix for a reported issue from our WinForms customers. For full details about the issue fixed in this release, please see the release notes here.

Spread.NET v15.2.20223.0 - July 26, 2022

We are happy to announce the release of Spread.NET v15.2.20223.0. This release includes important fixes for customer reported issues. For full details about the issues fixed in this release please see the release notes here

Spread.NET v15.1.20221.0 - April 26, 2022

We are happy to announce the release of Spread.NET v15.1.20221.0. This release introduces important changes and new features:

Baseline .NET Framework Reference Changed from .NET 4.5.2 to .NET 4.6.2

Dependencies

Microsoft has announced the end of Long Term Support for .NET 4.5.2 will happen today, April 26, 2022, in their blog post from last year, so all GrapeCity Spread.NET components will now be built using .NET 4.6.2 as the baseline .NET Framework. All customers with projects still targeting .NET 4.5.2 will need to change the target Framework version for their projects to .NET 4.6.2 or later.

In addition, we have also dropped support for the .NET 5 platform target, as that platform target was never included for LTS by Microsoft and will be no longer supported as of May 8, 2022. For full details, please see Product Requirements.

New NuGet Package introduced for GrapeCity.Spread.WinForms.Design

NuGet

This release introduces a new NuGet package, GrapeCity.Spread.WinForms.Design, which contains the Spread Designer run-time component and associated dialogs and other user interface elements. This package can be referenced when you want to show the Spread Designer dialogs (for example, the Border Editor Dialog) or show the Spread Designer in run-time inside your application. For full details, please see Adding NuGet Package for Spread Designer.

Cell Styles UI in Spread Designer

Cell Styles

The Spread Designer now supports setting built-in Theme Styles using the new Styles panel and drop-down in the ribbon bar. All the standard Excel built-in styles are available, and custom styles can be easily created and reused. For full details, please see Cell Styles Gallery.

Enter Formulas Using '+' and '-'

Entering cell formulas has always previously required starting the formula with: '=‘ but many customers have requested that formulas starting with '+' and '-' should also be recognized. Starting in this release, Spread will automatically recognize and parse formulas entered by the end-user, starting with '+' and '-' when AllowUserFormulas is true. Please see Allowing the User to Enter Formulas - Using Plus or Minus Sign for complete details.

Crop Shape Picture

Pictures in a shape can now be cropped using the ICrop interface to specify offset coordinates and crop width and height. This useful enhancement makes it much easier to get exactly the part of an image that you want to show. For full details, please see Working with Images - Crop Images.

Automatic Number Format

This release introduces new enhanced behavior for the default General format concerning numbers. Numbers are formatted to be displayed just as they are typed initially in the cell, but the value displayed may be rounded if the full value can't fit in the cell, or the cell might even show "##...#" indicating that the value can't fit. With the new behavior:

  • With Decimals: If a number is longer than 11 characters, including the decimal place, the decimals are rounded to show a maximum of 11 characters

For example, 123456.7891234 is rounded off to 123456.7891

  • Without Decimals: If a number is longer than 11 characters and there are no decimals, the number is changed to a Scientific format

For example, 123451234512 is rounded off to 1.23451E+11

For full details, please see Working with Cell Formats - General Format.

Inline Cell Images

Inline Cell Images

This feature enables the developer or end-user to directly load and display inline cell images in the worksheet without using ImageCellType. The Image object can be set directly to the cell or using CellImageAttribute to specify an Image property in a Custom Data Type using IRichValue, which can display both the image and the value in the cell at the same time. For full details, please see Adding an Image in a Cell.

Formatted Number Cell Value

This feature associates a specified format string with a cell value and allows the format string to follow the value when used in formulas. The format string can be a number or a date-time format. When a formula references the cell, then it will automatically pick up the format to apply in the formula cell if there is not already a cell format applied to that cell. For full details, please see Formatting a Cell Value.

Enhanced Excel-Compatible Keyboard Shortcuts: Ctrl+PgUp and Ctrl+PgDn

This feature must be enabled using FpSpread.Features.ExcelCompatibleKeyboardShortcuts = true, which will update the key mappings to support the most common Excel keyboard shortcuts automatically. This support now includes mappings for Ctrl+PageUp and Ctrl+PageDown to navigate the previous and next worksheets in the workbook as in Excel. For full details about these new shortcuts and the many others supported when this feature is enabled, please see Excel-Compatible Keyboard Shortcuts.

What's New in Spread.NET v15 - November 17, 2021

This release features new platform controls for .NET 4.5.2+, .NET Core 3.1, and .NET 6.0, and major enhancements for calculations, data visualization, rich text and more:

  • NuGet package for .NET 4.5.2+, .NET Core 3.1, and .NET 5.0 and .NET 6.0 WinForms applications
  • Use NuGet Package Manager to add Spread in your WinForms projects
  • 17 new Enhanced Sparkline Visual Functions
    • Area
    • Area
    • BoxPlot
    • Bullet
    • Cascade
    • Gauge KPI
    • HBar
    • Histogram
    • Image
    • Month Calendar
    • Pareto
    • Pie
    • Scatter
    • Spread
    • Stacked
    • Vari
    • VBar
    • Year Calendar
  • Hide sparkline group indicator (customer requested)
  • LAMBDA Function enables creating custom functions using formulas
  • 7 new LAMBDA helper functions
    • MAP
    • REDUCE
    • SCAN
    • MAKEARRAY
    • BYROW
    • BYCOL
    • ISOMITTED
  • Keep white-space characters in formulas
  • Name Manager enhanced to resize and expand formula text box for longer multi-line formulas
  • Support double-byte characters in custom names
  • Freeform: Shape and Freeform: Scribble supported (with Features.EnhancedShapeEngine enabled)
  • CameraShape enhancements: now supported with Enhanced Shape Engine and can switch reference range with formulas in custom name
  • Bind table to data source (customer requested)
  • Negative red numbers along axis and data label of charts (customer requested)
  • Customizable cursors for shapes (customer requested)
  • Customize shape dragging context menu (customer requested)
  • Cell Comments using Enhanced Shape Engine with Rich Text content and styles like Excel
  • Rich Text import/export in XLSX with multiple fonts, text styles, and colors, including superscript and subscript
  • Enhanced border rendering (BorderCollapse.Enhanced) loads XLSX borders exactly like Excel
  • Enhanced Conditional Formatting dialog (resizable, new Duplicate Rule button)
  • Enhanced printing support of default cell type (when LegacyBehaviors.Style is not used)
  • Insert cut/copied cells
  • Enhanced Excel-compatible keyboard shortcuts and actions (with Features.ExcelCompatibleKeyboardShortcuts)
    • TAB, SHIFT+TAB in table cells navigates tables like Excel
    • CTRL+A selects adjacent cells, then the entire worksheet, or table data area, then the entire table, then the entire worksheet
    • CTRL+SHIFT+'+' insert cut/copied cells
    • Auto-Expand table like Excel (using Features.AutoExpandTable)
    • Auto-apply formulas to table columns like Excel (using Features.AutoCreateCalculatedColumns)
  • Export ComboBoxCellType as DataValidation using flat-style mode (e.g. not using LegacyBehaviors.Style) (customer requested)
  • Display image from file path using ImageCellType (customer requested)
  • 26 new VSTO-like APIs
    • IRange.AutoFill
    • IRange.BorderAround
    • IRange.Characters
    • IRange.Dirty
    • IRange.FillDown
    • IRange.FillLeft
    • IRange.FillRight
    • IRange.FillUp
    • IRange.HasRichDataType
    • IRange.Height
    • IRange.Left
    • IRange.Next
    • IRange.Previous
    • IRange.Resize
    • IRange.Show
    • IRange.ShowCard
    • IRange.SpecialCells
    • IRange.Top
    • IRange.UseStandardHeight
    • IRange.UseStandardWidth
    • IRange.Width
    • IWorksheet.Next
    • IWorksheet.Previous
    • IWorksheet.StandardHeight
    • IWorksheet.StandardWidth
    • IWorksheet.UsedRange