Released: Nov 16, 2025

V1.8.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 11, 2025

V1.8 での更新項目

機能

• 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 8, 2021

V1.7.3 での更新項目

機能

• Custom format strings can now contain color names in square brackets, compatible with Microsoft Excel color specifiers.
• Names of ranges can now include backslash and question mark symbols.
• Extended the set of expression types in which blank cells are promoted to zeros or empty strings when referenced from formulas.

不具合の修正

• Fixed missing parentheses when ExcelImporter imports shared formulas.
• Fixed horizontal barcharts showing overlapped labels.

Released: May 19, 2021

V1.7.2 での更新項目

機能

• Microsoft .NET 5.0 support - The Spreadsheet.WinForms distribution now includes assemblies for .NET 5.0.
• ExcelExporter now truncates sheet names to fit within a maximum of 30 characters as supported by Microsoft Excel.

不具合の修正

• ExcelImporter fix for default false value of validations' showErrorMessage attribute.
• SUMIF and AVERAGEIF fixes for multiple-column ranges.

Released: Jun 29, 2020

V1.7.1 での更新項目

機能

• New AllowResizeCells property specifies whether users can resize rows and columns by dragging cell borders.
• New ReadConditionalFormats property lets you disable the importing of conditional formats.
• Updated AutoFillCopyOnly to only make the auto-fill tool copy values instead of extrapolating new values from selection.
• Validation drop-down can now display values from a named cell range.

不具合の修正

• Fixed style-related crashes in ExcelExporter.
• Fixed rendering of multi-line text when wrapping is...

Released: Aug 18, 2017

V1.7 での更新項目

機能

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

Released: May 26, 2017

V1.6 での更新項目

機能

• Improved XLSX Import and Export - The ExcelExporter and ExcelImporter classes are now several times faster than before and the results are more accurate.
• Miscellaneous
  • The CsvExporter class can now export partial worksheets through the new Export overload.
  • The ImageExporter can take into consideration the worksheet zoom through the new EnableZoom property.
  • The WorkbookPrinter now exposes a Landscape property, which can be used to specify page orientation.
  • The WorkbookView expoxes new Cut...