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

Release Highlights

Aspose.Cells for Java 23.4 introduces XHTML and OneNote file format detection, enhanced array formula evaluation, and SVG/PDF export fidelity. It also strengthens cross-format conversion accuracy and adds fine-grained control over pivot tables, fonts, and VBA project encoding.

Enhancements

• CSS Writing Mode Support

  • Adds support for vertical text display using writing-mode: vertical-rl.

• LightCells for XLSB

  • Save large XLSB files efficiently via XlsbSaveOptions.LightCellsDataProvider.

• Improved Recalculation

  • Fixes incorrect or skipped formula evaluation, including MIRR and cross-sheet references.

• Pivot Table Targeting

  • Now supports OnlyData and OnlyLabel properties in PivotArea for refined selections.

Bug Fixes

• Rendering Accuracy

  • Fixed chart legend scaling, line positioning, and wavy fill rendering in PDF and SVG.
  • Addressed hidden text and shape distortion in Excel-to-ODS, HTML, and SVG output.

• HTML and ODS Conversion

  • Fixed data loss and misalignment in HTML-to-Excel.
  • Ensured pie chart color, plot presence, and angle preservation in ODS exports.

• Excel Behavior Consistency

  • Resolved UID inconsistencies on repeated save.
  • Fixed issues with list formatting, formula display, and OneNote detection.

Public API and Backward Incompatible Changes

• New Additions:
  • XlsbSaveOptions.LightCellsDataProvider: Enables LightCells write mode for XLSB.
  • Worksheet.calculateArrayFormula(...): Evaluates dynamic array formulas.
  • CalculationOptions.CharacterEncoding: Controls character encoding during formula parsing.
  • EquationNode and derived classes: Build and customize equation shapes programmatically.
  • FileFormatType.XHtml and FileFormat.OneNote: Recognize XHTML and OneNote files.
  • FontConfigs.isFontAvailable(String): Checks font availability.
  • LoadOptions.ignoreUselessShapes: Skip non-essential shapes during load.
  • PivotArea.onlyData and onlyLabel: Specify what parts of pivot data to select.
  • SaveFormat.XHtml: Enables XHTML output format.
  • ListObject.putCellFormula(...): Insert formulas directly into table cells.
  • VbaProject.encoding: Control VBA script encoding.
  • XmlSaveOptions.sheetNameAsElementName and dataAsAttribute: Customize XML structure during export.

🔍 Explore the Full Release Details

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

xhtml export | svg rendering | array formula | pivot area | xlsb lightcells