What's New in Spread.NET v15

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