Released: Nov 16, 2025

V1.4.1 中的更新

特性

• Optimized Calculation Engine
  • Performance in large multi-sheet workbooks has been improved by introducing spatial indexing of cell data, leading to 2-3 times faster initial and incremental formula calculations.
• Added New Functions
  • SUMIFS adds the cells in a range that meet multiple criteria.
  • COUNTIFS counts the number of cells specified by a given set of conditions or criteria.
  • CONCAT merges text from several ranges and/or individual strings.
  • TEXTJOIN combines text from multiple ranges or...

Released: Jun 8, 2025

V1.4 中的更新

特性

• Spilled Arrays
  • Formulas can now run arithmetic operations on whole ranges and return two-dimensional arrays as results. Elements from such arrays are assigned to adjacent cells to the one that calculates the formula. For example, you could show element-wise sum of ranges by setting a single formula in =A1:C3+E1:F3 format. If a cell from the spill range already contains a value, the formula returns a #SPILL error. Apart from arithmetic calculations, spilled arrays can also be returned by...

Released: Nov 23, 2021

V1.3.2 中的更新

特性

• Added Microsoft .NET 5 support - The Spreadsheet.WPF distribution now includes assemblies for .NET 5. Locally installed assemblies don't show automatically in toolbox at this time, you can add them to projects either manually or through Nuget package manager.
• Miscellaneous
  • Custom format strings can now contain color names in square brackets, compatible with Microsoft Excel color specifiers.
  • Extends the set of expression types in which blank cells are promoted to zeros or empty strings when...

Released: Jul 7, 2020

V1.3.1 中的更新

特性

• Localization improvements:
  • Cells can now display right-to-left text.
  • Added right-to-left text support in PdfExporter.
• Validation dropdown can now display values from a named cell range.
• Enabled AutoFillCopyOnly to make auto-fill tool only copy values instead of extrapolating new values from a selection.

修補程式

• Fix for PdfExporter when creating incorrect PDF files on Chinese versions of Microsoft Windows.
• ExcelExporter fix for format warnings in Microsoft Excel when opening a worksheet with a...

Released: Oct 17, 2017

V1.3 中的更新

特性

• Auto-filtering - Worksheets now support auto-filtering.
• Miscellaneous - The ExcelImporter class now exposes a ReadConditionalFormats property, which can be used to prevent the importing of conditional formats.

Released: Aug 23, 2017

V1.2 中的更新

特性

• UI Localization - The standard forms can now be localized using XML files that map interface element identifiers to strings. Ready-made localization files for French, German, Chinese, Korean, Spanish, Portuguese and Russian are provided in the Localization folder under the component's installation root.
• Grouping and Outlining - Rows and columns can now be grouped. To group or ungroup a range of rows or columns, use the Group or Ungroup methods of the RowRange and ColumnRange classes.
• New...

Released: May 26, 2017

V1.1 中的更新

特性

• Improved XLSX Import and Export - The ExcelExporter and ExcelImporter classes are now several times faster than before and the results are more accurate. Various problems and inconsistencies were fixed. Both classes now expose a View property, if you set the View property of the ExcelExporter, the exporter will also export view information, such as the active tab and selection. Alternatively, setting this property during import, will cause the view information to be imported.
• Miscellaneous...

Released: May 16, 2016

V1 中的更新

特性

User Interaction

• Virtualized scrolling.
• Copy and paste to/from Windows clipboard.
• Automatic scrolling while dragging items with the mouse.
• Multiple object selection.
• Tool-tips.
• Full undo/redo support.
• Grouping and outlining of rows and columns.

Programming

• Programmatic access to all workbook elements.
• Numerous properties for customizing appearance and behavior.
• Numerous utility methods.
• Rich event set.

Import and Export

• Export images in bmp, jpeg, gif, tiff, png formats.
• Export Portable...