What’s new in Aspose.Cells for Java 24.12

Release Highlights

Aspose.Cells for Java 24.12 delivers enhanced formula and pivot table control, improved HTML export, and advanced update monitoring capabilities. This release also resolves major rendering and compatibility issues across PDF, image, and HTML output formats.

New Features

• Formula Change Monitoring:
  The new AbstractFormulaChangeMonitor enables tracking formula changes during insert/delete operations. This is integrated via InsertOptions and DeleteOptions.

• Pivot Filter API Overhaul:

  • Replaced PivotFilterCollection.add() with type-specific methods like addValueFilter(), addTop10Filter(), addLabelFilter(), and addDateFilter().
  • Added pivotField.filterByTop10(), filterByValue(), filterByLabel(), and filterByDate() for clearer usage.
  • New methods for retrieving filter settings: getTop10Value(), getNumberValues(), getLabels(), getDateTimeValues().
  • Added enums like FilterCategory, PivotFilterType.none, and new FilterOperatorType options (notBeginsWith, notEndsWith).

• Enhanced HTML Export Control:

  • HtmlSaveOptions.disableCss: Use inline styles only, avoiding external stylesheets.
  • SaveOptions.checkExcelRestriction: Ensures saved files conform to Excel limitations.

• GridJS Update Monitoring:

  • GridUpdateMonitor and GridJsWorkbook.updateMonitor provide hooks to track grid changes in browser-based environments.

• Extended Pivot Field Metadata:

  • PivotField.regionType: Identifies where the field appears in a PivotTable.
  • PivotField.isValueFields: Indicates if the field represents multiple value fields.
  • PivotField.clearFilter() method for quick reset.

• Support for Long Text and Superscripts in EMF:

  • Improved rendering for superscript content and fixed long text truncation beyond Excel’s 32767-character limit.

Enhancements

• Text and Chart Improvements:

  • Accurate text positioning, gradient fills, font styles, and horizontal axis data during PDF/image conversions.

• Insert/Delete Enhancements:

  • Overloaded insertColumns(), deleteColumns(), and deleteRows() now accept InsertOptions/DeleteOptions for fine-grained control.

• Style-Aware Text Replacement:

  • ReplaceOptions.styleFlags allows selective formatting changes when replacing text.

• Power Query Metadata:

  • Added PowerQueryFormula.groupName and clarified formula types via PowerQueryFormulaType.

Bug Fixes

• Rendering Issues:

  • Corrected display of 3D chart gradients, superscripts, and data alignment in PDF and EMF.
  • Fixed HTML conversion background color and chart graphic errors.

• Formula Evaluation:

  • Addressed incorrect results for MROUND and other formulas after calling workbook.calculateFormula().

• File Conversion & Parsing:

  • Resolved NumberFormatException on PDF export with percentage strings.
  • Fixed NullPointerException and Invalid ValidationType errors during Excel file loading.

• JDK 21 Compatibility:

  • Prevented crash in SheetRender.toImage() under JDK 21 environments.

Public API and Backwards Incompatible Changes

New Classes & Properties:

• AbstractFormulaChangeMonitor
• InsertOptions.formulaChangeMonitor, DeleteOptions.formulaChangeMonitor
• PivotField.regionType, isValueFields, clearFilter()
• PivotFilter.useWholeDay, filterCategory, valueFieldIndex
• GridUpdateMonitor, GridJsWorkbook.updateMonitor
• ReplaceOptions.styleFlags
• HtmlSaveOptions.disableCss, SaveOptions.checkExcelRestriction

Obsoleted or Replaced:

• PivotFilter.autoFilter → use explicit type filter methods
• PivotFilter.measureFldIndex → use valueFieldIndex
• PivotFilterType.* updated for clarity (e.g., DateNewerThan → DateAfter)
• WarningInfo.warningType → use warningInfo.type

🔍 Explore the Full Release Details

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

track formula changes excel java | pivotfilter api refactor | htmlsaveoptions disable css | replace style flags aspose | xlsx to pdf text position fix