Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Public API Changes in Aspose.Cells 8.1.1
Contents
[
Hide
]
This document describes changes to the Aspose.Cells API from version 8.1.0 to 8.1.1 that may be of interest to module and 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 Properties and Features
Added the HtmlSaveOptions.PresentationPreference Property
The HtmlSaveOptions class exposes a getter and setter for the PresentationPreference property, which can be used to render the results with a better layout when exporting spreadsheets to HTML or MHTML. The default value is false, whereas if set to true, the Aspose.Cells API exports the worksheet contents with better presentation.
Please check the detailed article on Use PresentationPreference Option for Better Layout
Added Support for Worksheet Scenarios
A scenario is a what‑if model that includes variable input cells linked together by one or more formulas. Aspose.Cells exposes a getter and setter for the Worksheet.Scenarios property along with the following classes to help developers create, manipulate, and remove scenarios.
- Scenario: Represents an individual scenario.
- ScenarioCollection: Represents a collection of scenarios.
- ScenarioInputCellCollection: Represents a list of input cells for a particular scenario.
- ScenarioInputCell: Represents an input cell from the collection of input cells for a particular scenario.
Please check the detailed article on How to Create, Manipulate or Remove Scenarios from Worksheets.
Change in Behavior for CellsException
In previous releases of the Aspose.Cells for Java API, when a potentially damaged spreadsheet was loaded into an instance of Workbook, the API tended to throw a generic exception without indicating where the problem occurred. We have changed this behavior for 8.1.1 so that the API throws an exception with a meaningful message that points out where (which cell) and what (formula expression) caused the exception when reading the template file.