What’s new in Aspose.Cells for Java 24.11

Release Highlights

Aspose.Cells for Java 24.11 introduces support for converting Excel files to PCL (Printer Command Language), accessing workbook data models, and creating advanced shapes via freeform paths. This release also enhances multi-threaded access to cell values, improves text splitting precision, and fixes critical conversion and formula calculation bugs.

New Features

• Export to PCL Format:
  New SaveFormat.Pcl and PclSaveOptions enable converting Excel spreadsheets into PCL documents for print automation workflows.

• Multi-threaded Formatted Value Retrieval:
  Added thread-safe support for getting cell’s formatted value, enabling concurrent performance operations.

• Shape Path Drawing API:

  • Methods like moveTo(), lineTo(), cubicBezierTo(), arcTo(), and close() allow precise custom shape path creation.
  • ShapeCollection.addFreeform() and addSignatureLine() extend workbook annotation and customization.

• Data Model Access Support:

  • New classes DataModel, DataModelTable, and DataModelRelationship expose Excel’s PowerPivot-like data model.
  • Access via Workbook.getDataModel().

• Enhanced Text Splitting (textToColumns) Behavior:

  • Method now returns the column count filled after split.
  • Automatically applies number formatting based on TxtLoadOptions.loadStyleStrategy.

• Shape Textbox Control:

  • Added TextBoxOptions and vertical alignment control via ShapeTextVerticalAlignmentType.

Enhancements

• Smart Marker JSON Support Expanded:
  Further improved behavior when skipping unmatched tags and processing JSON with rich formats.

• Power Query Updates:

  • Unified formula property: PowerQueryFormulaParameter.formulaDefinition
  • Added PowerQueryFormulaType to distinguish formula categories.

• Workbook Settings Enhancements:

  • defaultImageResolution, discardImageEditData, and propertiesFollowChartPoint for tighter control over image and chart export fidelity.

• Sorting Enhancements:

  • Added DataSorter.addColorKey(...) for color-based sort logic.

• Improved Shape and Pivot Handling:

  • PivotItem.isDetailHidden replaces isHideDetail
  • PivotItem.isCalculatedItem replaces isFormula

Bug Fixes

• PDF and Image Export:

  • Fixed improper image rendering and layout inconsistencies in XLSX to PDF conversion.
  • Resolved image loss and formatting problems when converting from MHT to Excel.

• Formula and Lookup Issues:

  • Fixed XMATCH inaccuracies with specific modes.
  • Resolved NegativeArraySizeException and ArrayIndexOutOfBoundsException from lookup and formula evaluation.

• Pivot Table and Text Conversion Bugs:

  • Addressed parsing failures in certain pivot tables.
  • Corrected textToColumns() to return the correct column count and maintain number formats.

• Alt Text & SheetSet Enhancements:

  • Retrieve alt text from pictures placed in cells.
  • SheetSet(String... sheetNames) supports variadic sheet selection.

Public API and Backwards Incompatible Changes

New Classes and Enums:

• PclSaveOptions, TextBoxOptions, DataModel, DataModelTable, DataModelRelationship
• SaveFormat.Pcl, ErrorCellValueType, PowerQueryFormulaType, ShapeTextVerticalAlignmentType, SignatureType

New Properties & Methods:

• Workbook.dataModel
• Cell.getRichValue()
• Cell.setFormula(...) with FormulaParseOptions
• DeleteBlankOptions.drawingsAsBlank, startIndex, endIndex
• Shape.textBoxOptions
• ShapePath.moveTo(), lineTo(), cubicBezierTo(), arcTo(), close()

Obsoleted:

• PivotItem.isHideDetail → use isDetailHidden
• PivotItem.isFormula → use isCalculatedItem
• PowerQueryFormulaParameter.parameterDefinition → use formulaDefinition
• PowerQueryFormulaParameterCollection removed; parameters consolidated into PowerQueryFormulas
• FindOptions.seachOrderByRows → use corrected spelling searchOrderByRows

🔍 Explore the Full Release Details

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

excel to pcl conversion java | texttocolumns format fix | multi thread get cell value | excel shape freeform draw | workbook data model java