What’s new in Aspose.Cells for Java 24.7

Release Highlights

Aspose.Cells for Java 24.7 enhances visual and structural document fidelity by adding new features like AZW3 ebook support, image-in-cell placement, and pivot table calculation options. This update also improves formula behavior, font rendering, and chart border control while resolving key issues related to HTML conversion, chart display, and exception handling.

New Features

• Place Picture in Cell:
  A new Picture.placeInCell() method allows positioning images inside the cell, mimicking Excel’s “Place in Cell” feature.

• AZW3 Format Export:
  Added SaveFormat.Azw3 and EbookSaveOptions(SaveFormat.Azw3) to support saving Excel content as Amazon Kindle-compatible ebooks.

• Custom Font Scanning:
  Now scans Microsoft Office cloud font caches by default for richer font availability across platforms.

• Pivot Table Calculation Options:
  New PivotTableCalculateOption and PivotTable.calculateData(PivotTableCalculateOption) allow precise control over pivot table computation.

• Sparkline and Series Management Enhancements:

  • SparklineGroupCollection.add(SparklineType) simplifies sparkline group addition.
  • SeriesCollection.swapSeries(int, int) replaces the older changeSeriesOrder() for reordering chart series.

• Extended Chart Data Table Styling:

  • New properties: hasHorizontalBorder, hasVerticalBorder, hasOutlineBorder.
  • ChartPoint.doughnutInnerRadius replaces innerRadiusPx for Doughnut charts.

• Font Control and Decorative Shape Tagging:

  • New DataLabels.applyFont() method applies font settings to all data label nodes.
  • Shape.isDecorative marks shapes as decorative for accessibility compliance.

• JSON and GridJS Enhancements:

  • JsonLoadOptions.keptSchema enables schema preservation on load.
  • GridJsWorkbook.jsonToStream() and .jsonToStreamByUid() write JSON content to output streams.

• Conversion Utility Class:
  New ConversionUtility simplifies file format transformations.

Enhancements

• Improved Font Rendering:
  Better width/height metrics for Aptos Narrow font and improved page break calculation.

• Formula Engine Upgrades:

  • Corrected handling of ASC, TEXT, and WIDECHAR functions, especially in Japanese locales.

• HTML and Image Output:

  • More consistent rendering for charts, including complete data, corrected spacing, and border styling.
  • Prevent image size overflows when using setOnePagePerSheet(true) in image export.

Bug Fixes

• Rendering Issues:

  • Fixed spacing issues in text boxes converted to PDF.
  • Resolved incomplete chart data display in HTML exports.
  • Fixed incorrect image size and missing content during rendering.

• Exception Handling:

  • Addressed NullPointerException in HTML conversion and ArrayIndexOutOfBoundsException in formula calculations.
  • Handled invalid power query formula definitions during workbook merging.

Public API and Backwards Incompatible Changes

New Properties, Methods & Classes:

• Picture.placeInCell()
• Shape.isDecorative
• PivotTableCalculateOption, calculateData(...)
• ConversionUtility, SeriesCollection.swapSeries(...)
• ChartDataTable.hasHorizontalBorder, hasVerticalBorder, hasOutlineBorder
• ChartPoint.doughnutInnerRadius
• SparklineGroupCollection.add(...)
• Cells.getCellsWithPlaceInCellPicture()
• GridJsWorkbook.jsonToStream(...), jsonToStreamByUid(...)

Obsoleted or Replaced:

• AxisBins.resetOverflow(), resetUnderflow() (internal use only)
• Chart styling: replaced hasBorderHorizontal, hasBorderVertical, hasBorderOutline
• ChartPoint.innerRadiusPx → doughnutInnerRadius
• SeriesCollection.changeSeriesOrder() → swapSeries()
• ChartDataTable.background → backgroundMode

🔍 Explore the Full Release Details

For full list of updates, please visit Aspose.Cells for Java 24.7 Release Notes.

aspose cells place in cell | azw3 save excel java | pivottable calculate options | chart datatable border properties | text function formula fix