What’s new in the Aspose.Cells for Java 23.3

Release Highlights

Aspose.Cells for Java 23.3 introduces SmartArt-to-group object conversion, enhanced HTML margin support, and improved formula calculation for pivot data fields. It also includes fixes for PDF rendering accuracy, chart label placement, and HTML-to-Excel fidelity.

New Features

• SmartArt to Group Object Conversion
  • Enhanced logic to convert SmartArt elements into group objects within the Excel structure.

Enhancements

• GridWeb LoadOption Support

  • Enables customized document loading in web environments via LoadOption.

• HTML Rendering

  • Now honors <img> tag margins during HTML import.

Bug Fixes

• Chart and Image Rendering

  • Fixed incorrect rendering of characters and legend height.
  • Restored series lines in Scatter charts and missing data labels in copied workbooks.

• Excel-to-PDF Conversion

  • Resolved misaligned axis points, unreadable output with iText, and numeric display showing #.

• HTML Conversion Issues

  • Fixed conversion errors due to malformed chart object cells.
  • Corrected layout in HTML with hidden rows and formatting inconsistencies in HTML-to-Excel conversion.

• Formula and Pivot Table Handling

  • Corrected pivot field formatting behavior and getCalculatedValue() not retrieving data properly.

• Exceptions

  • Addressed IllegalArgumentException during HTML export.
  • Fixed issues with CSV to PDF rendering and opening password-protected ODS files.

Public API and Backward Incompatible Changes

• Added:

  • CalculationOptions.LinkedDataSources: Enables external data linkage during formula evaluation.
  • Chart.isReferedByChart(int, int): Checks if a cell is referenced by any chart.
  • PasteOptions.IgnoreLinksToOriginalFile: Prevents linking during range copying.
  • PivotArea, PivotTableSelectionType, and PivotTable.format(PivotArea, Style): Enables precise formatting of pivot areas.
  • SheetSet.Active: Retrieves active worksheet set.
  • StyleModifyFlag.FontVerticalText: Controls vertical font layout.
  • WarningType.InvalidOperator: Identifies invalid Excel operators.

• Obsoleted:

  • SvgSaveOptions and related members — now replaced by ImageSaveOptions(SaveFormat.SVG).
  • HtmlLoadOptions.ConvertFormulasData → replaced with HtmlLoadOptions.HasFormula.
  • PivotGlobalizationSettings.getTextOfProtection() → replaced with getTextOfProtectedName(String).

🔍 Explore the Full Release Details

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

smartart to group | chart to image | html to excel | pivot formatting | excel to pdf