Aspose.Cells for Java 17.4.0 Release Notes

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 VbaProject.Protect(bool islockedForViewing,string password) method

Protects or unprotects the VBA project.

Adds VbaProject.IsProtected property

Indicates whether the vba project is protected.

Adds VbaProject.IslockedForViewing property

Indicates whether the VBA project is locked for viewing.

Adds CopyOptions.ExtendToAdjacentRange property

Indicates whether extend ranges when copying the range to adjacent range.

 Workbook wb = new Workbook("sample.xlsx");

Worksheet ws = wb.getWorksheets().get("Sheet1");

CopyOptions co = new CopyOptions();

co.setExtendToAdjacentRange(true);

Cells cells = ws.getCells();

cells.copyRows(cells, 0, 1, 1, co);

Deletes obsoleted Workbook.ValidateFormula(string formula) method

Adds DataSorter.SortAsNumber property

Indicates whether sorting anything that looks like a number.

Usage Examples

Please check the list of help topics added in the Aspose.Cells Wiki docs:

• Specifying Sort Warning While Sorting Data
• Password Protect the VBA Project of Excel Workbook
• Find out if VBA Project is Protected
• Check if VBA Project is Protected and Locked for Viewing
• Specifying DBNum Custom Pattern Formatting