What’s new in Aspose.Cells for Java 24.6

Release Highlights

Aspose.Cells for Java 24.6 focuses on boosting rendering accuracy, formula evaluation, and pivot table controls. This release introduces capabilities like range-to-image and range-to-HTML conversions, new JSON export options, and smarter handling of pivot display settings, while removing deprecated shape properties for a cleaner API.

New Features

• Convert Range to Image or HTML:
  Added Range.toImage() and Range.toHtml() methods, allowing developers to export specific worksheet areas to image or HTML formats.

• Enhanced JSON Export from Excel:
  New Range.toJson(JsonSaveOptions) method and JsonSaveOptions.toExcelStruct flag support exporting Excel data to JSON in structured formats.

• Pivot Display Enhancements:

  • PivotField.showValuesAs() now controls how data values are displayed (e.g., percentage, difference).
  • Introduced PivotShowValuesSetting class to manage advanced pivot display options.
  • New enum PivotItemPositionType to control item positioning within pivot base fields.
  • Added PivotItem.isFormula to check if a pivot item is calculated.

Enhancements

• Formula and Workbook Handling:

  • Smart marker now reliably maps HashMap data sources.
  • Improved behavior of Cells.clearContents(CellArea): now throws an error when intersecting array formulas.

• Image Rendering Enhancements:

  • More accurate EMF and PDF exports with full image rendering.
  • Fixed Wingdings font rendering in WordArt shapes.

• Shape API Modernization:

  • Replaced old properties like Shape.positionX, HeightInChart, etc., with modern counterparts (Shape.X, Shape.HeightInShape, etc.).
  • Deprecated Shape.textFrame, replaced by Shape.textBody.textAlignment.

Bug Fixes

• Rendering Bugs:

  • Fixed truncated curved lines and missing pictures when exporting to PDF.
  • Resolved formatting loss when exporting XLSB to HTML.
  • Addressed thickened gridlines in image output.

• Data and Layout Issues:

  • Corrected misplaced chart labels when serializing/deserializing workbook as byte arrays.
  • Fixed HTML export issues including extra <div> tags, data loss, and font-family extraction problems.

• Formula Evaluation and Locale Issues:

  • Fully calculates formulas in large workbooks, even without opening in Excel.
  • Fixed WORKDAY function issues with holiday cell references.
  • Resolved NullPointerException for ASC function under JAPAN locale.

• Excel File Handling:

  • Resolved errors when merging XLSX files with Power Queries.
  • Fixed picture display issues when converting MHT to Excel.
  • Resolved workbook loading errors using LightCellsDataHandler.

Public API and Backwards Incompatible Changes

New Methods and Classes:

• Range.toImage(), Range.toHtml(), Range.toJson(JsonSaveOptions)
• PivotField.showValuesAs(), PivotField.showValuesSetting
• PivotTable.getFields(PivotFieldType)
• PivotShowValuesSetting, PivotItemPositionType, AdvancedFilter

Updated Behavior:

• Cells.clearContents(CellArea) now throws an exception if partially intersects array formulas.

Obsoleted or Removed:

• Shape.isLockAspectRatio → use Shape.isAspectRatioLocked
• Shape.textFrame → use Shape.textBody.textAlignment
• Deprecated methods like FormatCharacters(int, int, Font) → use new overload with StyleFlag
• Deprecated shape positional properties (e.g., PositionX, HeightInChart) replaced with X, HeightInShape

🔍 Explore the Full Release Details

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

excel range to image java | pivot show values as | excel to json export | smart marker hashmap fix | wingdings font wordart pdf