Spread.NET 15.1.20221.0

Released: Apr 26, 2022

Aggiornamenti in 15.1.20221.0

Funzionalità

  • Baseline Microsoft .NET Framework reference has been changed from .NET 4.5.2 to .NET 4.6.2 - All GrapeCity Spread.NET components are 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, support for the .NET 5 platform target has also been dropped.
  • Added new NuGet Package for GrapeCity.Spread.WinForms.Design - 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.
  • Cell Styles UI in Spread Designer - 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 Microsoft Excel built-in styles are available and custom styles can be easily created and reused.
  • Enter Formulas Using '+' and '-' - Entering cell formulas has always previously required starting the formula with: '=‘. Starting in this release, Spread will automatically recognize and parse formulas entered by the end-user, starting with '+' and '-' when AllowUserFormulas is true.
  • 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 enhancement makes it much easier to get exactly the part of an image that you want to show.
  • 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.
  • 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.
  • 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.
  • 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.