Public API Changes in Aspose.Cells 8.1.0

This document describes changes to the Aspose.Cells API from version 8.0.2 to 8.1.0 that may be of interest to module/application developers. It includes not only new and updated public methods, but also a description of any changes in the behavior behind the scenes in Aspose.Cells.

Added HtmlSaveOptions.ExportHiddenWorksheet Property

The HtmlSaveOptions class has exposed the ExportHiddenWorksheet property, which can be used to specify whether hidden worksheets are exported to HTML format. The default value is true; if set to false, Aspose.Cells will not export hidden worksheet contents.

Please check the detailed article on Prevent Exporting Hidden Worksheet

Added Cell.StringValueWithoutFormat Property

StringValueWithoutFormat property has been added to the Cell class in order to facilitate developers in retrieving the cell value without any formatting applied.

The code snippet below demonstrates the usage of the Cell.getStringValueWithoutFormat method as compared to cell.getDisplayStringValue by creating a spreadsheet from scratch and applying a number format to one of the cells.

Java

 //Create an instance of Workbook

Workbook book = new Workbook();

//Access first worksheet

Worksheet sheet = book.getWorksheets().get(0);

//Access A1 cell

Cell cell = sheet.getCells().get("A1");

//Put a value cell and convert it to number

cell.putValue("123456", true);

//Create a new Style object and add it to Workbook's Style Collection

int index = book.getStyles().add();

Style style = book.getStyles().get(index);

//Set Number format for Style object

style.setNumber(3);

//Create an instance of StyleFlag class

//and set NumberFormat to true

StyleFlag flag = new StyleFlag();

flag.setNumberFormat(true);

//Set the style of A1 cell

cell.setStyle(style, flag);

//Get formatted string value 

String formatted = cell.getDisplayStringValue();

System.out.println("Formatted String Value: " +formatted);

//Get un‑formatted string value

String unformatted = cell.getStringValueWithoutFormat();

System.out.println("Un‑formatted String Value: " + unformatted);

Output of the above code is as follows:

Formatted String Value: 123,456
Un‑formatted String Value: 123456

Obsolete Bytes, Characters, CharactersWithSpaces, Lines, Paragraphs Properties

Many properties from the BuiltInDocumentPropertyCollection class have been marked obsolete starting from Aspose.Cells for Java 8.1.0. These properties include Bytes, Characters, CharactersWithSpaces, Lines, and Paragraphs. The reason is that the aforementioned properties are of no use in preserving Excel spreadsheets because Excel omits them, whereas these properties were originally written for Word documents and PowerPoint presentations.