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

Support notification of formula changes when inserting/deleting cell range
Support lambda functions of BYROW and BYCOL
Support to render LinearGradientBrush, PathGradientBrush, HatchBrush and TextrueBrush to pcl
Support to place inline styling/formatting instead of css when saving html
Support to add font color, cell color as data sorter key
Support to update order and add group to PowerQueryFormulas
Enhancements for filters of PivotField such as multiple filters, filter whole day
Support refreshing formula reference after inserting/deleteing row/column in GridJs
Support update monitor for GridJs
Support center alignement across columns for GridJs

Aspose.Cells for Java 24.11

Support xlsx to pcl conversion
Support to get source of external source for PivotTable
Support to get table relationships in excel sheet
Support to get formatted string of cells in multi-threads
Support “PlaceInCell” picture for MemoryPreference mode and formula calculation
Support importing/exporting rich values such as errors, entities
Support adding SignatureLine just like in Excel
Improvement for generated SVG to make it behavior in the same way for different frameworks
Enhancement for adding free form shapes
Support to set number format type for different data types such as date, time, currency… for GridJs
Support to render borders for row/column’s style for GridJs
Enhancement for rendering and editing of GridJs

Aspose.Cells for Java 24.10

Support to get source of pivot table from corresponding external connection
Support to create compact pivot tables
Improve converting pivot area to range
Support to read CHM file
Support to ignore disorder cells/rows instead of giving exception when importing OOXML template files
Support more options for deleting blank rows/columns
Support to set different number format types for GridJs
Support Lazy loading for GridJs
Improve splitting text for rich text cell values for GridJs

Aspose.Cells for Java 24.9

Support to create Checkbox for cell and render Checkbox to pdf
Support to export equation content to MathML and LaTex
Support to export cell address when saving HTML
Support parsing feature property bags of xlsx
Optimization for releasing image resources when saving PDF
Support to get formulas of pivot calculated item/field
Improvement for performance of calculating grouped pivot field
Support to detect OLE(Object Linking and Embedding) format
Enhancement of formulas in GridJs: show formulas and formula explanation, use formulas as parameters for setting verification
Support for syntax checking and spell correction for user input in GridJs
Support to show time control for mobile device when cell format is time in GridJs
Improve effect of validation editing and failure prompts of GridJs for mobile device

Aspose.Cells for Java 24.8

Support new functions: VALUETOTEXT, ARRAYTOTEXT
Support sorting pivot table by pivot field item
Support to visit all cells that contain “Place in Cell” pictures
Support to keep document properties without encryption when encrypting file
Support editing formulas with blank spaces for GridWeb
Support configuration to show or hide invisible shapes in GridJs
Improve features of GridJs such as settings, editing formulas, input checking

Aspose.Cells for Java 24.7

Support DROP function in formulas
Improve the performance of calculating LET and MAKEARRAY functions with complex parameters
Support outline of the star characters in chart
Support making an object as decorative
Supporting swapping series
Improve the display of TreeMap Chart
Support converting picture of “overed cell” to “in cell”
Support to load local Office cloud font by default
Support to keep json schema when importing json data
Support exporting to AZW3 format file
Support to auto set height after setting wrap for cell for GridJS
Support json generation using stream writer way for GridJS

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.

Getting Started