Released: Jun 18, 2024

v7.2.0 での更新項目

機能

• Added support for calculating pivot tables:
  • Supports calculation of data fields on column and row fields.
    • Page field filtering.
    • Filters.
    • Slicers.
    • Show data as on data fields.
    • Calculated fields.
  • Access calculated pivot table data via the ExcelPivotTable.CalculatedData property of the ExcelPivotTable.GetPivotData function.
• Added support for copying drawings.
  • The types of drawings include:
    • Shapes.
    • Charts.
    • Pictures.
    • Controls.
    • Slicers.
    • Group Shapes.
  • You can copy individual drawings.
  • Copying a range will now include drawings.
  • You can set a flag to ignore drawings.
• Added support for importing and exporting fixed width text files.
• Transpose:
  • You can now transpose ranges in import and export functions.
  • You can now transpose a range copy.
• New functions are now supported in formula calculations:
  • GETPIVOTDATA.
  • MMULT.
  • MINVERSE.
  • MDETERM.
  • MUNIT.
  • TEXTSPLIT.
  • TEXTAFTER.
  • TEXTBEFORE.
  • LET.
• Added fastFull-fledged support for icon sets and databar conditional formatting in HTML-exporter, New features include:
  • Exporting full visuals of positive and negative databars with borders and axis colors, position and bar direction.
  • Custom-made embedded .svgs similar to each icon Excel supports.
  • Custom icon sets displaying appropriately and in order.
  • Icons moving with text when aligned top, middle or bottom as in Excel.
• Cell text/content now default to vertical-align bottom as data in Excel cells are bottom-aligned by default.
• Added new properties 'FirstValueCell', 'LastValueCell' and 'DimensionByValue' to ExcelWorksheet to manage cell value boundaries for a worksheet.
• Added ManualLayout property for data labels on charts. Labels can now be positioned, and their textbox resized directly. It is accessed for example via 'Chart.Series[0].DataLabel.DataLabels[0].Layout.ManualLayout'.
• Multiple data labels can now be added to the same series.

不具合の修正

• Theme colors for color scales now works correctly in the HTML exporter.
• Conditional formatting color scales now support theme color correctly.
• Formula calculation sometimes incorrectly returns #VALUE if 'IsWorksheets1Based' is true.
• Line breaks were not handled correctly on saving the workbook if multiple CR where used in combination with CRLF or LF.