Spread.NET 15

Released: Nov 17, 2021

15 中的更新

功能

  • Microsoft .NET 6 Support and Nuget Package - Using NuGet Package Manager in Microsoft Visual Studio, you can now easily add the Spread.NET Windows Forms controls in your projects targeting Microsoft .NET 6, .NET 5, .NET Core 3.1, and .NET 4.5.2.
  • Added 17 Sparkline Visual Functions - The new sparkline types are Area, Box Plot, Bullet, Cascade, Gauge KPI, HBar, Histogram, Image, Month Calendar, Pareto, Pie, Scatter, Spread, Stacked, Vari, VBar, and Year Calendar. These new sparkline functions provide a wide variety of built-in data visualizations for various data types and use cases. They can be created directly in cells using formulas or through the Spread Designer tool.
  • New LAMBDA Function Enables Creating Custom Functions Using Formulas - Added a new LAMBDA Function which lets users create new custom functions using custom names and formulas.
  • Added 7 LAMBDA Helper Functions and Related Enhancements - To help create advanced LAMBDA Functions for specific use cases, seven new LAMBDA Helper Functions are now supported: BYCOL, BYROW, ISOMITTED, MAKEARRAY, MAP, REDUCE, and SCAN.
  • Freeform: Shape, Freeform: Scribble and Camera Shape Enhancements - The new tools allow users to create, open or close custom shapes quickly and easily, just like in Microsoft Excel. The Camera Shape has been enhanced to support the new Enhanced Shape Engine. It supports using formulas inside custom names to dynamically switch the Camera Shape range using a cell value or a Cell Type such as Check Box or Combo Box.
  • Table Binding Enhancements - Table Binding enhancements in this release provide run-time support for table data binding directly to any .NET data source. ITable supports AutoGenerateColumns and DataSource properties, and ITableColumn supports DataField and CellType properties. This new support provides two-way direct binding to the data source values, with changes immediately updated.
  • Rich Text: Import XLSX with Cells Containing Multiple Fonts, Text Styles, Colors, Superscript and Subscript - Rich Text Import is easily enabled using FpSpread.Features.RichText which allows imports of XLSX documents containing rich text formatting in cells, including multiple fonts, text styles, colors, superscripts, and subscripts.
  • Enhanced Border Rendering and Printing Support - Enhanced Border Rendering has been improved to allow importing XLSX files containing complex merged cells with various types and widths of cell borders exactly as in Excel. Printing Support in this release has also been enhanced when using the default flat style to support printing of all cells as they appear, including gradient fills, accounting formats, and more.
  • Enhanced Conditional Format Dialog - The Enhanced Conditional Format dialog supports the Duplicate Rule button and resizing the dialog, making it easier to manage the conditional formats in your worksheets. This dialog is displayed in run-time using the API ConditionalFormattingUtils.ShowConditionalFormattingManagerForm.
  • Insert Cut/Copied Cells - The new Insert Cut/Copied Cells enhancement in this release can be enabled using FpSpread.Features.RichClipboard and is part of a broad set of enhancements to copy/paste behaviors to make Spread behave more Excel-like. This includes displaying the animated dashed-line border around the copied or cut range and new context menu items for Insert Copied Cells or Insert Cut Cells when a range has been copied or cut and enhanced Insert dialog for inserting rows or columns.
  • Enhanced Excel-Compatible Keyboard Shortcuts and Actions:
    • CTRL + A to select table cells, table ranges, worksheets, or adjacent non-empty cells.
    • TAB and SHIFT + TAB are used to navigate table cells or adjacent cells.
    • AutoCreateCalculatedTableColumns enable new behavior when typing formulas in table cells, automatically applying the formula to the other table column cells.
  • Export ComboBoxCellType as Data Validation - Added the ability to export ComboBoxCellType as a Data Validation List to XLSX files, using ExcelSaveFlags.ComboAsDataValidation. Import of Data Validation Lists in XLSX files as ComboBoxCellType is also supported using ExcelOpenFlags.DataValidationAsCombo.
  • Display Image From File Path Using ImageCellType - Improved ImageCellType in this release to allow the image to be loaded automatically by setting the value in the cell to the image's file path. Duplicate images are automatically cached and reused across cells to optimize use cases with many images.
  • Added 26 New VSTO-like APIs for IRange and IWorksheet:
    • IRange.AutoFill - auto-fills the range to a specified target range.
    • IRange.HasRichDataType - returns true if the range contains a rich cell data type object.
    • IRange.Resize - resizes the range.
    • IRange.Width - returns the width of the range in points.
    • IRange.Top - returns the top coordinate of the range relative to the top of the worksheet in points.
    • IRange.Height - returns the height of the range in points.
    • IRange.Left - returns the left coordinate of the range relative to the left of the worksheet in points.
    • IRange.UseStandardWidth - sets or returns whether the columns in the range use standard width.
    • IRange.UseStandardHeight - sets or returns whether the rows in the range are standard height.
    • IRange.ShowCard - shows the data card for the rich cell data type object in the range.
    • IRange.Show - scrolls the worksheet to show the specified cell (IRange must be one cell).
    • IRange.Next - emulates the TAB key to navigate to the next editable cell.
    • IRange.Previous - emulates the SHIFT + TAB key to navigate to the previous editable cell.
    • IRange.FillDown - fills the range down using the values in the top cells.
    • IRange.FillLeft - fills the range left using the values in the right cells.
    • IRange.FillRight - fills the range right using the values in the left cells.
    • IRange.FillUp - fills the range up using the values in the bottom cells.
    • IRange.Dirty - designates the cells in the range to be recalculated in the next calculation cycle.
    • IRange.BorderAround - sets the specified borders around the cells in the range (outline border).
    • IRange.Characters - gets the Characters for applying formatting to part of the cell value.
    • IRange.SpecialCells - gets the cells in the range of the specified type.
    • IWorksheet.UsedRange - returns the range in the worksheet containing values.
    • IWorksheet.StandardWidth - sets or returns the standard column width in the worksheet.
    • IWorksheet.StandardHeight - sets or returns the standard row height in the worksheet.
    • IWorksheet.Next - emulates the TAB key to navigate to the next editable cell.
    • IWorksheet.Previous - emulates the SHIFT + TAB key to navigate to the previous editable cell.