Public API Changes in Aspose.Cells 8.1.1

Added HtmlSaveOptions.PresentationPreference Property

The HtmlSaveOptions class has exposed PresentationPreference property which can be used to render the results with better layout when exporting spreadsheets to HTML or MHTML. The default value is false. whereas if set to true, the Aspose.Cells API will export the worksheet contents with better presentation.

Added Support for Worksheet Scenarios

A scenario is named what-if model that includes variable input cells linked together by one or more formulas accordingly. Aspose.Cells API has exposed Worksheet.Scenarios property along with the following classes in order to facilitate the users in creating, manipulating and removing scenarios from worksheets,

  1. Scenario: Represents an individual scenario.
  2. ScenarioCollection: Represents a collection of scenarios.
  3. ScenarioInputCellCollection: Represents a list of input-cells for a particular scenario.
  4. ScenarioInputCell: Represents an input-cell from the collection of input-cells for a particular scenario.