.
Below are a list of added features and bug fixes that are incorporated for each minor build of OfficeWriter 9.x
OfficeWriter 9.1
ExcelWriter
New Features
All new features are implemented for XLSX/XLSM files only unless otherwise indicated.
- Ability to implement custom / non-implemented calculation engine formulas (see WB.RegisterCustomFunction)
- New calculation engine formulas (see Calculation Engine Supported Formulas)
- Ability to calculate formulas in an area (see Area.CalculateFormulas)
- Ability to remove formulas from a workbook or worksheet (see Workbook.RemoveFormulas or Worksheet.RemoveFormulas)
- Ability to sort areas (see Area.Sort)
- Ability to save an image of an area (see Area.SaveImage)
- Ability to save an image of a chart (see Chart.SaveImage)
- Ability to specify the layout of a Pivot Table (see PivotTable.PivotTableLayout)
Enhancements
All enhancements are implemented for XLSX/XLSM files only unless otherwise indicated.
- Large speed and memory performance enhancements for Worksheets.CopySheet
Bug Fixes
- Issue when reading/writing certain PageSetup object properties resolved.
PowerPointWriter
- No changes were made to PowerPointWriter in 9.1
WordWriter
New Features
No changes were made to WordWriter in 9.1
Reporting Services Integration
New Features
- The Word Designer .NET has been released
- A large number of ExcelTemplate and WordTemplate properties now are available in Reporting Services (see Setting Global ExcelTemplate and WordTemplate Properties in Reporting Services).
- Ability to use the calculation engine for SSRS (see Activating Post-Processing ExcelApplication Features in SSRS).
Installer
- The OfficeWriter installer no longer removes V8 License keys when installing OfficeWriter 9.
- The OfficeWriter installer no longer automatically installs the OfficeWriter Designer. Please install the OfficeWriter Designer .NET separately.
OfficeWriter 9.0
ExcelWriter
New Features
- Calculation Engine for ExcelApplication (see Calculation Engine Supported Formulas)
PowerPointWriter
New Features
- Template Object (see PowerPointTemplate API)
- Application Object: Copy Slide, Delete Slide, Align Images, Document Properties
WordWriter
New Features
- Add missing outer HTML tags to HTML documents used with the document modifier
Reporting Services Integration
No changes were made to Reporting Services Integration in 9.0.0
Installer
New Features
- Handles multiple license keys
- Automatically selects components to install based on license keys