Public API Changes in Aspose.Cells 8.0.0

This page lists public API changes that were introduced in Aspose.Cells 8.0.0. It includes not only new and obsoleted public methods, but also a description of any changes in the behavior behind the scenes in Aspose.Cells which may affect the existing code.

Added MemorySetting to LoadOptions & WorkbookSettings

Starting from v8.0.0 of Aspose.Cells for Java, we have provided the memory usage options for performance considerations. The MemorySetting property is now available in LoadOptions & WorkbookSettings classes.

Example

Demonstrates how to read an Excel file (having large size) in optimized mode.

Java

 //Initialize LoadOptions

LoadOptions options = new LoadOptions();

//Set memory preferences

options.setMemorySetting(MemorySetting.MEMORY_PREFERENCE);

//Instantiate the Workbook with an object of LoadOptions

Workbook book = new Workbook(myDir + "large.xlsx", options);

Demonstrates how to write a large dataset to a worksheet in optimized mode.

Java

 //Instantiate a new Workbook

Workbook book = new Workbook();

//Set the memory preferences for WorkbookSettings

book.getSettings().setMemorySetting(MemorySetting.MEMORY_PREFERENCE);

//Input large data into the cells

//.........

Please check the detailed article on Optimizing Memory while Working with Large File.

Implementations of Row & Cell have changed

In previous versions, Row and Cell objects were kept in memory to represent the corresponding row and cell in a Worksheet. The same instance was returned whenever RowCollection[int index] or Cells[int row, int column] were retrieved. For memory performance considerations, only the properties and data of Row and Cell are kept in memory from now on. Hence, the Row and Cell objects have become wrappers of the aforementioned properties.

Example

Demonstrates how to compare the Cell and Row objects from now on.

Java

 //..

row1.equals(row2);


cell1.equals(cell2);

//..

Because the Row and Cell objects are instantiated according to the invocation, they will not be kept and managed in memory by the Cells component. Therefore, after some insertion and deletion operations, the Row and Column indexes may not be updated, or, even worse, these objects may become invalid.

Example

For instance, the following code snippet will return invalid results using 8.0.0 and above,

Java

 Cell cell = cells.get("A2");

System.out.println(cell.getName() + ":" + cell.getValue());

cells.insertRange(CellArea.createCellArea("A1", "A1"), ShiftType.DOWN);

System.out.println(cell.getName() + ":" + cell.getValue());

With the new version, the Cell object may become invalid or refer to A2 with an unwanted value. In order to avoid such a situation, get the Row or Cell objects again from the cells collection to retrieve the correct result.

Java

 Cell cell = cells.get("A2");

System.out.println(cell.getName() + ":" + cell.getValue());

cells.insertRange(CellArea.createCellArea("A1", "A1"), ShiftType.DOWN);

//Fetch the cell reference again

Cell cell = cells.get("A3");

System.out.println(cell.getName() + ":" + cell.getValue());

RowCollection does not inherit CollectionBase anymore because there is no Row object in its inner list.

Cell.StringValue Behavior Changed

In previous versions, the special pattern _ was ignored while formatting cell values, whereas the special character * always produced one character in the formatted result. From this version, we have changed the logic to handle special characters _ and * in order to make the formatted result the same as the Excel application. For instance, the custom cell format _(\$* #,##0.00_) used to represent value 123 produced the result as "$ 123.00". With the new version, Cell.StringValue will contain the result as "$123.00", which is the same behavior exhibited by the Excel application when copying the cell to text or exporting to CSV.

Added CreatedTime to PdfSaveOptions

Now users can get or set the PDF creation time when saving a spreadsheet to PDF using the PdfSaveOptions class.

Added ShowFormulas to Worksheet

From now on, users can use the Boolean ShowFormulas property of Worksheet to switch the view between formulas and values of a given worksheet.

Added Ooxml to FileFormatType

A new constant Ooxml has been added to the FileFormatType class to represent the encrypted Office Open XML file such as XLSX, DOCX, PPTX and more.

Obsoleted FilterColumnCollection of AutoFilter

With Aspose.Cells for Java, the getFilterColumnCollection method has been marked obsolete. It is suggested to use AutoFilter.getFilterColumns method instead.

Replaced SeriesCollection.SecondCatergoryData with SeriesCollection.SecondCategoryData

We have corrected the typographical error in the method name SeriesCollection.getSecondCatergoryData. You may use SeriesCollection.getSecondCategoryData from now on, whereas the original method SeriesCollection.getSecondCatergoryData has been marked obsolete.