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 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 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.