Released: Nov 16, 2025

Actualizaciones en V1.4.1

Características

• 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...

Released: Jun 8, 2025

Actualizaciones en V1.4

Características

• 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...

Released: Nov 23, 2021

Actualizaciones en V1.3.2

Características

• 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...

Released: Jul 7, 2020

Actualizaciones en V1.3.1

Características

• 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.

Correcciones

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

Released: Oct 17, 2017

Actualizaciones en V1.3

Características

• 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

Actualizaciones en V1.2

Características

• 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...

Released: May 26, 2017

Actualizaciones en V1.1

Características

• 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...

Released: May 16, 2016

Actualizaciones en V1

Características

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...