Aspose.Cells for Java 18.12 Release Notes

CELLSJAVA-42745Does not get connection points as its returned type is ‘zo[]’New Feature
CELLSJAVA-42662Provide ability to export range as HTMLNew Feature
CELLSJAVA-42746Data bars are missing when XLSX is converted to HTMLNew Feature
CELLSJAVA-42747Value still exists when XLSX is converted to HTML file formatNew Feature
CELLSJAVA-42748LightCells API fails to load a huge fileEnhancement
CELLSJAVA-42727Text formatting is missing in HTML output of MS Excel rangeBug
CELLSJAVA-42744Icon Sets become misaligned when XLSX is converted to HTMLBug
CELLSJAVA-42772Exporting named range data is not correctly rendered to HTML (Java)Bug
CELLSJAVA-42753An issue found in Named RangeBug
CELLSJAVA-42764Validation always returns true for ‘getInCellDropDown()’ methodBug
CELLSJAVA-42768Wrong culture custom format gets returned for different locales (Germany, French, Italy and Spain)Bug
CELLSJAVA-42758Excel To PDF conversion - Gauge chart rendering issueBug
CELLSJAVA-42761PDF rendition throws OutOfMemoryError exceptionBug
CELLSJAVA-42759CellsException while converting filesException
CELLSJAVA-42755Exception “NullPointerException” when instantiating the XLSX file(s)Exception
CELLSJAVA-42762NumberFormatException while processing filesException
CELLSJAVA-42774NullPointerException when loading a CSVException
CELLSJAVA-42765Exception “com.aspose.cells.CellsException” when rendering an Excel file to PDF file formatException
CELLSJAVA-42754“IllegalStateException: Invalid encoding: null” when instantiating an XLS file formatException

Public API and Backwards Incompatible Changes

The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for Java. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Adds HtmlSaveOptions.ExportSingleTab property

Indicates whether exporting the single tab when the file only has one worksheet in it.The default value is false.

Adds HtmlSaveOptions.ExportPrintAreaOnly property

Indicates if only exporting the print area to html file. The default value is false.

Deletes obsoleted Workbook.Initialize() method

Use Workbook constructor instead.

Deletes obsoleted Workbook.Styles property

Use Workbook.CreateStyle() to create and manipulate style for workbook instead of StyleCollection.Add(); Use Workbook.GetNamedStyle(string) to get named style instead of StyleCollection.

Deletes obsoleted Workbook.CheckWriteProtectedPassword() method

Use WorkbookSettings.WriteProtection.ValidatePassword method instead.

Adds LoadDataFilterOptions.VBA enum

The option to used to ignore VBA projects while loading template file.

Adds Style.InvariantCustom property

Gets the culture-independent pattern string for number format (including the pattern string for built-in number).

Adds FindOptions.ValueTypeSensitive property

Indicates whether searched cell value type should be same with the searched key.

Obsoletes FindOptions.SearchNext property

Use FindOptions.SearchBackward property instead, true value for this new property corresponds to false of SearchNext.

Deletes obsoleted Cells.FindString, FindStringStartsWith, FindStringEndsWith, FindStringContains and FindNumber methods

Use Cells.Find (object,Cell,FindOptions) method instead. To get the same results with methods FindNumber, FindString, please set FindOptions.ValueTypeSensitive as true.

Deletes obsoleted Cells.ImportGridView(System.Web.UI.WebControls.GridView,int ,int , bool ,bool ,bool ) method

Use Cells.ImportGridView (System.Web.UI.WebControls.GridView gridView,int firstRow,int firstColumn,ImportTableOptions options) method. instead.

Deletes obsoleted Cells.Start property

Use Cells.FirstCell property instead.

Deletes obsoleted Cells.End property

Use Cells.LastCell property instead.

Deletes Cells[int] property

Use Cells.GetEnumerator() method to iterate all cells in this worksheet instead.

Deletes obsoleted Cells.ImportDataColumn() methods

Use Cells.ImportData (DataTable,int,int,ImportTableOptions) method instead.

Deletes obsoleted Cells.ImportDataReader() methods

Use Cells.ImportData (IDataReader, int, int,ImportTableOptions) method instead.

Deletes obsoleted Shape.Rotation property

Use Shape.RotationAngle property instead.

Deletes obsoleted Validation.AreaList property

Use Validation.Areas property instead.

Deletes obsoleted Style constructor

Use CellsFactory.CreateStyle() or Workbook.CreateStyle() method instead.

Deletes obsoleted Shape.IsPrinted property

Use Shape.IsPrintable property instead.

Deletes obsoleted PivotItem.Move(int) method

Using PivotItem.Move(int , bool ) method instead.

Deletes obsoleted Cells.ExportDataTable(int, int, int, int,bool, bool),Cells.ExportDataTable(int, int, int, int,object[]), Cells.ExportDataTable(int, int, int, int,bool), Cells.ExportDataTable(DataTable, int, int[],int, bool) and Cells.ExportDataTable(DataTable,int, int, int, bool, bool) methods

Use ExportDataTable(firstRow,firstColumn, totalRows, totalColumns,ExportTableOptions) method instead.

Adds ExtPage.setServlet(HttpServletRequest req,HttpServletResponse resp)

Initializes servlet context for ExtPage.

Adds ExtPage.getBean() method

Gets GridWebBean instance from ExtPage.

Deletes ExtPage.getBean(HttpServletRequest req) method

Use ExtPage.getBean() instead.

Adds ExtPage.Maxholders property

Indicates maximum GridWeb instances for server to be kept (creating every new page or refreshing is considered as a new control instance), default value is 1000.

Adds ExtPage.Memoryinstanceexpires property

Indicates the expiry time in seconds of control instance on server, if the time expires, it will be removed on the server, default value is 3600, about one hour.

Adds ExtPage.MemoryCleanRateTime property

Indicates every time duration in seconds to do the check work, to check whether control instance is expired, if expired it removes it, default value is 7200, about two hours.