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

Release Highlights

Aspose.Cells for Java 23.10 addresses critical rendering issues in Excel to PDF and HTML, including vertical text alignment, locale-based number spacing, and advanced chart rendering. It improves formula reliability, introduces globalized sheet naming, and enhances support for workbook interactivity through hyperlinks and VBA user forms.

Enhancements

• Improved Locale Rendering:

  • Fixed spacing issues in numeric output for regional settings like es-ES, fr-FR, and it-IT.
  • Enhanced “Shrink to Fit” and numeric display for multilingual HTML output.

• Advanced Chart and Shape Rendering Fixes:

  • Corrected appearance of advanced MS Excel charts in PDF.
  • Resolved rounded rectangle shape rendering and label disappearance in charts.
  • Improved retention of character spacing and data label positioning during chart-to-image conversion.

• Stability Fixes for Formula and Pivot Handling:

  • Resolved hanging issue in calculateFormula().
  • Fixed IndexOutOfBoundsException in PivotTable.calculateData().

Bug Fixes

• HTML Export Accuracy:

  • Fixed cell misalignment, number clipping, and content offset in HTML output.
  • Corrected behavior for Shrink to Fit, vertical text, and punctuation alignment.

• PDF Rendering:

  • Enhanced fidelity in graph exports, particularly for label positioning, graph appearance, and rounded rectangle shapes.

Public API and Backward Incompatible Changes

• New Methods and Properties:

  • GlobalizationSettings.getDefaultSheetName()

    • Allows customization of default worksheet names during automatic sheet addition.

  • MsoFormatPicture.getTopCropInch() / setTopCropInch() (and similar for Bottom, Left, Right)

    • Enables cropping images in inches for precise control over embedded visuals.

  • Range.isBlank()

    • Checks if a range is entirely empty.

  • Range.addHyperlink(String text, String address, String tooltip)

    • Adds hyperlinks directly to ranges.

  • VbaModuleCollection.addUserForm()

    • Supports adding custom VBA user forms.

  • WorksheetCollection.addCopy(Worksheet[], String[])

    • Facilitates batch copying of worksheets with custom names.

🔍 Explore the Full Release Details

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

excel to pdf | pivot table | shrink to fit | vba userform | html export