OfficeWriter 10.1.2

Reporting Services Integration

Bug Fix

• Fix issue where The Designer .NET would display error "There was an error opening this RDL file. It may not be valid" when opening some RDLs with a 2016 file format.

OfficeWriter 10.1

ExcelWriter

New Features

All new features are implemented for XLSX/XLSM files only unless otherwise indicated.

• Large performance enhancments
• Improved rendering of datapoint interiors
• Improved datetime format support when rendering
• Improved rendering of data labels as percent
• Improved support of rendering legend entries

Bug Fixes

• Fix for duplicated named styles

• Fix rendering for text being clipped of when text alignment is right

PowerPointWriter

Bug Fixes

• Fix for PowerPointTemplate and repeat slide
• Fix for PowerPointTemplate and null values in data sets
• Fix for PowerPointTemplate and images being cached incorrectly
• Fix for PowerPointTemplate improved support for master slides and layouts
• Fix for PowerPointTemplate and invalid characters

WordWriter

Bug Fixes

• Allowing repeat blocks to be inside of if fields when updating+unlinking the if field.

Reporting Services Integration

New Features

• Support for SQL Services Reporting Services 2016

OfficeWriter 10.0

ExcelWriter

New Features

All new features are implemented for XLSX/XLSM files only unless otherwise indicated.

• Ability to save an area to a PDF file
• Ability to save a worksheet or workbook to a PDF file
• Conditional formats are rendered when saving to an image or PDF
• Comments are rendered when saving to an image or PDF
• Tables are rendered when saving to an image or PDF
• Some basic shapes are rendered when saving to an image or PDF
• Additional formulas supported in the calculation engine (see Calculation Engine Supported Formulas) 
• Support for arrays when calculating formulas

Bug Fixes

• Fix for data validation formula was not correctly updated

• Fix for invalid Unicode characters not being properly escaped in comments

• Fix for formula parser where it would throw exception on conditional formats

• Fix for array formulas on data marker rows in Excel Template would not update correctly

• Fix for series vary by colors not being correctly set in all versions of Excel

• Fix for external references were not always working in ExcelTemplate

• Fix for title overlay not always working in Excel 2013

• Fix for calling multiple deletes on worksheets were styles span the whole worksheet

• Fix for default row and height not always being preserved

• Fix for merged cell borders not always being preserved 

• Fix for reading files with small alpha values

• Better support for preserving existing equations

PowerPointWriter

Bug Fixes

• Fix for PowerPointTemplate throwing exception in multi-threaded environments.

WordWriter

Bug Fixes

• Better support for 3 of 9 barcode and Calibri fonts in .doc files

• Fix for concurrency issue in a multi-threaded environment.

Reporting Services Integration

New Features

• The Designer .NET supports adding, editing, and inserting Reporting Services formulas into reports
• The Excel Designer .NET supports creating and editing database queries through MSQuery
• It is now possible to create a new report from scratch from the Excel Designer .NET, in addition to importing existing reports