What's new in Aspose.Cells for Java

This page describes the most interesting new Aspose.Cells features introduced in recent releases.

Aspose.Cells for Java 24.6

  • Enhancements for rendering: color saturation and color temperature adjustment, duotones, Webp images
  • Enhancements for PivotTable: merging range, “Show Values as” of PivotField
  • Support Range.ToHtml()/ToImage() for user’s convenience to manipulate range data

Aspose.Cells for Java 24.5

  • Support new functions: XMATCH, XOR
  • Support to transpose data of the range
  • Support to get properties of advanced filter settings
  • Support to render picture placed in cell to pdf/image

Aspose.Cells for Java 24.4

  • Provide simple implementations of interrupt monitor for user’s convenience
  • Support to embed attachments when converting OLE Object to pdf
  • Support to render auto shape of ChartX to image
  • Support to embed image into cell(“Place in Cell” operation for picture in ms excel)
  • Enhancements for importing Numbers file: merged cells, hidden rows/columns, …etc.

Aspose.Cells for Java 24.3

  • Support to import AZW3 file
  • Support to save ods with odf 1.3 standard
  • Support to calculate EVALUATE function

Aspose.Cells for Java 24.2

  • Support new functions: TEXTAFTER,TEXTBEFORE,TEXTSPLIT,TOROW,TOCOL
  • Support detecting oxps format
  • Improve performance for sorting large dataset

Aspose.Cells for Java 24.1

  • Support jakarta.servlet for GridWeb
  • Support to import csv data with user specified header rows/columns and total rows/columns per sheet
  • Support to export html with custom styles
  • Support auto filling for merged areas
  • Support auto filling data from right to left and bottom to up

Aspose.Cells for Java 23.12

  • Support for PDF/A-2 and PDF/A-3 compliance while converting to pdf
  • Support calculating discrete grouping of pivot table
  • Support to export cells data to generic list
  • Support to import cross references using linked tables for smart markers
  • Support MAKEARRAY function for formulas

Aspose.Cells for Java 23.11

  • Support to convert spreadsheets to PDF file version 1.7(ISO32000-1:2008)

Aspose.Cells for Java 23.10

  • Support to set hyperlinks directly to a Range
  • Support to copy multiple worksheets simultaneously
  • Support to check whether one range is empty for cells data

Aspose.Cells for Java 23.9

  • Support to calculate new functions in formula: LAMBDA,LET,MAP,SCAN
  • Support to import/export EPUB files
  • Support to filter chart series

Aspose.Cells for Java 23.8

  • Support to preserve padding space in formulas
  • Support to replace/insert text with formatting for richtext of cell

Aspose.Cells for Java 23.7

  • Enhanced file format detection for some new formats such as visio file, OneNote package file.

Aspose.Cells for Java 23.6

  • Support to export and highlight revision logs
  • Support to traverse existing Row objects from RowCollection in reversed order
  • Support to refresh multiple consolidation ranges of pivottable

Aspose.Cells for Java 23.5

  • Support to update external references of external sheet data to the local sheet of current workbook
  • Support to render Checkbox control as interactive control instead of static picture in GridWeb
  • Support to select PivotArea and format it
  • Support to add watermark while converting to pdf

Aspose.Cells for Java 23.4

  • Support to calculate function ENCODEURL
  • Support to complete the construction of an equation shape by inserting relevant nodes step by step
  • Support to calculate formula expression as array formula without setting it to a cell object
  • Support to save xlsb file in LightCells mode
  • Support to check whether one font is installed or available
  • Support to set formula to specified cell in the ListObject
  • Support to save workbook as xhtml
  • Support to render activex control and form control for GridWeb

Aspose.Cells for Java 23.3

  • Support to set/read/save new functions: LET, ENCODEURL
  • Support to link data sources to external links when calling formula calculation

Aspose.Cells for Java 23.2

  • Support to set/read/save new functions: SCAN, LAMBDA
  • Support to export style to json

Aspose.Cells for Java 23.1

  • Support new functions: CHOOSEROWS, CHOOSECOLS, HSTACK, VSTACK
  • Support to get author and date time from revisions

Aspose.Cells for Java 22.12

  • Support to export excel to JSON with multi-layered hierarchy structure

Aspose.Cells for Java 22.11

  • Support to distinguish between dynamic array formula and legacy array formula
  • Support to read/save dynamic array formulas for xlsb file format

Aspose.Cells for Java 22.10

  • Support to add and update chart with CRTX template file

Aspose.Cells for Java 22.9

  • Support to set table formula for cells
  • Support to set dynamic array formula with custom function and calculation engine
  • Support to set preset gradient settings for gradient fill format
  • Support to apply outlline borders with Theme colors for Range

Aspose.Cells for Java 22.8

  • Support exporting comments and notes as displayed on sheet to html
  • Support specifying worksheets to output while converting to pdf/xps

Aspose.Cells for Java 22.7

  • Support to read OOXML format template files which contains abnormal zip data and cannot be processed by java’s ZipInputStream
  • Support to export html to a single file with page header/footer
  • Support to get absolute position and size of Range(in points)

Aspose.Cells for Java 22.6

  • Improvement for calculating and tracing formulas with formula calculation chain

Aspose.Cells for Java 22.5

  • Improvement for memory performance of setting cells formula while saving workbook in LightCells mode

Aspose.Cells for Java 22.4

  • Enhanced options to control blank cells for exporting CSV.
  • Support complicated split and update of conditional formatting for insert/delete operations

Aspose.Cells for Java 22.3

  • Support to re-calculate cells which depend on defined name when the defined name is changed and workbook’s calculation chain is enabled.
  • Support to get cell’s leafs recursively according to formulas' calculation chain

Aspose.Cells for Java 22.2

  • Support to extract defined names from NameCollection by speicified scope filter

Aspose.Cells for Java 22.1

  • Support to generate editable pptx
  • Support to import large csv into multiple worksheets when data row/column exceeding limit
  • Support to import csv with LightCells
  • Support to remove specified external link
  • Support to keep formulas while removing external links

Aspose.Cells for Java 21.12

  • Support converting Excel to SQL Scripts
  • Support importing and exporting plain xml data
  • Support to read as much data as possible from corrupted xls file
  • Support to interrupt the process of SmartMarker
  • Improve performance for adding ranges for conditional formatting and validation
  • Set priority as highest for the newly added format condition, just like the behavior of ms excel

Aspose.Cells for Java 21.11

  • Support calculating XLookup formula/function.
  • Integrate saving json and images to saving workbook.
  • Improve performance while converting Excel to HTML.