What’s new in Aspose.Cells for Java 24.1

Release Highlights

Aspose.Cells for Java 24.1 delivers valuable enhancements including JSON smart marker support, Jakarta Servlet integration for GridWeb, and better HTML output rendering for mobile devices. It also resolves critical issues across formula evaluation, image rendering, chart exports, and worksheet scaling in PDF/HTML conversions.

New Features

• Jakarta Servlet Support for GridWeb Java:
  Added compatibility with jakarta.servlet, enabling deployment in Jakarta EE environments.

• Mobile-Friendly HTML with Highlighted Sheet Tabs:
  Improved HTML output now supports visually distinct sheet tabs for enhanced navigation on mobile platforms.

• Smart Marker Support for JSON Data Source:
  Smart markers can now directly consume JSON data, streamlining dynamic report generation from structured JSON sources.

Enhancements

• Pivot Field Blank Handling:
  Enhanced behavior of pivot tables to display the first datetime group item when the field contains blank values, improving analytical accuracy.

Bug Fixes

• Image and Shape Rendering:

  • Fixed missing text in shapes during Excel to image conversion.
  • Corrected text color inconsistencies in shapes and text boxes when saving to HTML.

• Formula Calculation:

  • Improved accuracy of calculateFormula() method.
  • Resolved inconsistencies across multiple formula evaluations.

• Chart and Pivot Table Issues:

  • Addressed chart display unit label linkage corruption in XLS.
  • Exception handling improved for quarter-based pivot grouping.

• File Conversion and HTML Export:

  • Fixed layout distortion in histogram charts during XLSX to HTML conversion.
  • Corrected HTML output when named ranges include icons.
  • Prevented extra columns from appearing in HTML exports.

• GridWeb Fixes:

  • Fixed cell editing in newly created sheets.
  • Resolved preview mode value discrepancies.

• PDF and CSV Issues:

  • Addressed scaling differences between Aspose-generated and Excel-generated PDFs.
  • Improved smart marker layout when line-by-line replacement is disabled.

• Exception Handling:

  • Resolved NullPointerException and ArrayIndexOutOfBoundsException during HTML conversion and sample file loading.

Public API and Backwards Incompatible Changes

New Properties:

• TxtLoadOptions.MaxRowCount / MaxColumnCount:
  Allows limiting row/column import from CSV. Large datasets are split into multiple worksheets.

• TxtLoadOptions.HeaderRowsCount / HeaderColumnsCount:
  Enables header duplication for extended worksheets during CSV import.

• HtmlSaveOptions.CssStyles:
  Allows customization of additional CSS styles in the HTML formatter.

New Methods:

• PivotField.GroupBy(double, boolean):
  Adds grouping capability for numeric or datetime pivot fields.

New Enums and Properties:

• PptxSaveOptions.ExportViewType and enum SlideViewType:
  Controls whether Excel to PPTX conversion uses “View” or “Printing” mode.

🔍 Explore the Full Release Details

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

json smart marker java | jakarta servlet gridweb | mobile excel html output | aspose cells formula bug | pivot field group blank