Below are a list of added features and bug fixes that are incorporated for each minor build of OfficeWriter 8.x
![](/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpvd2Q4NTF9&locale=en_GB&version=2)
OfficeWriter 8.5.1
Release July 1, 2013
ExcelWriter
New Features
All new features are implemented for XLSX files only unless otherwise indicated
- ImportData() option to treat merged cells as though they aren't merged
- Available also in XLS files
- ExcelTemplate and ExcelApplication Save() returns a generated XLSX file as a new memory stream
Issues Resolved
All issues are resolved in ExcelApplication for XLSX files only unless otherwise indicated
- Accessing a character runs in merged cells caused an error when using CopyPaste
- Setting a formula on a merged area had no effect
- Image files are locked after inserting with ExcelApplication
- Unable to modify an image after inserting with ExcelApplication
- Unable to close a file stream for an image after inserting with ExcelApplication
- CopySheet causes output files to crash in Excel 2013
- 2013 call-out data label formatting was stripped out of files
- Convert Strings (released in 8.4) does not affect column headers
- Series.ScatterValues returns an empty string for scatter charts
- Delay the parsing of invalid shared formulas
- Sheet names that start with C or R are not wrapped in quotations when referenced in formulas
- Files bloat after copying a selection with filters and freeze panes
WordWriter
No changes were made to WordWriter in 8.5.1.
Reporting Services Integration
New Features
- ExcelTemplate.LicenseKey and WordTemplate.LicenseKey can be set globally in web.config for SSRS
- OfficeWriter Designer for Excel can now 'View' reports with multi-valued parameters
Issues Resolved
- OfficeWriter Designer for Word detects incorrect Word version in regions where decimal separator is a comma
- Designer installer correctly checks for required Microsoft security updates.
Installer
New Features
- Installer works on machines with .NET 4.0 and 4.5
- License Key manager works on machines with .NET 4.0 and 4.5
- Installer works with SSRS 2012 in SharePoint integrated mode against SharePoint 2010 and 2013
![](/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpvdzg1MH0&locale=en_GB&version=2)
OfficeWriter 8.5.0
Released May 8, 2013
ExcelWriter
New Features
- ExcelTemplate allows data markers in tab names of XLSX/XLSM files
Issues Resolved
All issues are resolved in ExcelApplication for XLSX files only unless otherwise indicated
- CopySheet between workbooks
- Print titles and print areas are now copied
- Normal font is copied
- Column widths from original workbook copied
- Auto filters copied correctly
- Fixes to formulas
- File with worksheet range created on workbook level throws error on open
- Unable to parse conditional format formulas with multiple escape quotes
- Delayed parsing of formulas from Open to only when necessary (see KB post for more information)
- Textboxes/Shapes
- Textboxes containing formulas resulted in corrupt output
- Textbox with Japanese type facing throws object reference exception
- Textbox with no text is not editable after open/save
- Shape.Text returned empty string instead of cached text
- Setting Shape.Text on an existing text box containing a formula had no affect
- Textboxes, images, shapes containing formulas not recognized as valid file
- FitToPagesWide did not work in XLSX files
- Deleting a column changes VBA UsedRange property to apply to entire worksheet
- XLSX files with grouped Active-X controls not recognized as valid files
- Custom page size throws error
- Category Axis and Value Axis not displaying correctly in Excel 2010
- Error processing chart with two named ranges as data source
WordWriter
New Features
- Document modifier now supports insert DOCX files into DOCX/DOCM files
Reporting Services Integration
New Features
Issues Resolved
- OfficeWriter Designer can now install against 32-bit Office 2013
![](/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpvdzg0MH0&locale=en_GB&version=2)
OfficeWriter 8.4.0
Released February 12, 2013
ExcelWriter
New Features
Issues Resolved
- XLSX files with worksheets created by CreateWorksheet() do not open on a Blackberry
- Hyperlinks copied with CopySheet do not update the display name in Excel 2007
- Using SetConditionalFormat to copy conditional formats between workbooks corrupts the formatting
- ExcelWriter removes VBA digital signatures from XLSM files when opened with ExcelApplication
- ActiveX objects converted to images in XLSM files opened with ExcelApplication
- Certain named styles caused worksheet count to be zero
- ExcelApplication does not handle array formulas that contain external references in XLSX files
WordWriter
New Features
Reporting Services Integration
No changes were made the Reporting Services Integration for OfficeWriter 8.4.0.
![](/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpvdzgzMH0&locale=en_GB&version=2)
OfficeWriter 8.3.0
Released November 1, 2012
ExcelWriter
All changes are for ExcelApplication in XLSX files unless otherwise indicated.
Features Added
- Ability to set auto filters programmatically
- ExcelWriter can parse the following 2007 formulas:
- IsEven, IsOdd, FactDouble, GCD, LCM, MROUND, Multinomial, Quotient, Seriessum, sqrpi, sumifs, Edate, EoMonth, Networkdays, Weeknum, Workday, Yearfrac
- ExcelTemplate and ExcelApplication: Support for opening ExcelWriter-generated OOXML files on iPhone, iPad
Issues Resolved
- ExcelWriter fails to add worksheets that contain formulas that it cannot parse
- Error thrown when 3D charts data source referenced a name range
- Shared VLOOKUP formula referencing named range threw exception
- CopySheet did not update the chart series formula
- Setting PageSetUp properties before calling CopySheet threw a Null reference exception
- Error when legacy shapes contain line breaks in text
- Error when Excel form controls contain line breaks in text
- Formulas that referenced external workbooks threw an exception
WordWriter
Features Added
- WordTemplateTemplate and WordApplication: Support for opening WordWriter-generated OOXML files on iPhone, iPad
Issues Resolved
- WordTemplate opened in protected mode if importing no rows of data in DOC files
Reporting Services Integration
Issues Resolved
- SSRS 2008 R2 formulas not correctly deleted from the OfficeWriter Designer for Excel
- Designer corrupted an RDL file if the report contained more than 10 SSRS formulas
![](/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpvdzgyMX0&locale=en_GB&version=2)
OfficeWriter 8.2.1
Released July 10, 2012
ExcelWriter
Issues Resolved
- SettingsLineAreaScatter.ShowDropLines always read as True
- Copying worksheets that contained tables with Worksheets.CopySheet produced corrupt output
- Null reference exception thrown when modifying certain XLSX files generated by Apache POI
- "Value cannot be parsed as a number" exception thrown when trying to parse Cell.Value on a Swedish machine
WordWriter
No changes were made for v8.2.1
Reporting Services Integration
Issues Resolved
- Designer threw "Compile error: Method or data member not found" when publishing reports to or retrieving reports from the report server
![](/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpvdzgyMH0&locale=en_GB&version=2)
OfficeWriter 8.2.0
Released June 27, 2012
ExcelWriter
Features Added
Issues Resolved
Template Object
Application Object
- Active X objects in Excel 2010 XLSM files are converted into images
- "Given key was not present" exception thrown when a list box form control is on a chart sheet
- Using a named range in a data validation causes ExcelWriter to ignore certain worksheets
- ExcelWriter generated XLSX files are set to 300 dpi by default instead of 600 dpi
- ExcelWriter is unable to read certain cell values in files generated by SSRS 2012 built in EXCEL export option
- RowProperties.Style and RowProperties.ApplyStyle() do not set the styles correctly if the cell value is written before the style is applied
- FreezePane.ColumnNumber returns the incorrect value
- If RANDBETWEEN was dragged between cells in a file, ExcelWriter throws an exception
- ExcelWriter is accessing a static dictionary in a non-thread safe manner
- ExcelWriter throws exception on certain files generated with Apache POI
WordWriter
Features Added
Reporting Services Integration
Features Added
- Support for native SQL Server Reporting Services 2012
- Updated Designer copyright dates
Issues Resolved
- Formulas in some SSRS 2008 reports disappeared after opening the report in Visual Studio
Installer
Features Added
- Updated End User License Agreement
- OfficeWriter Designer Installer provides useful message when trying to install against a 64-bit version of Office
Issues Resolved
- License Key Manager version doesn't match release version
- Installer did not unpack SSRS dlls under Program Files
![](/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpvdzgxMn0&locale=en_GB&version=2)
OfficeWriter 8.1.2
Released April 30, 2012
ExcelWriter, WordWriter, Reporting Services Integration, and Installer
Issues Resolved
- OfficeWriter 8 was not FIPS compliant, which prevented installing or running OfficeWriter 8 on FIPS-enabled machines. This fix has been applied to all OfficeWriter 8 components.
![](/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpvdzgxMX0&locale=en_GB&version=2)
OfficeWriter 8.1.1
Released April 19, 2012
ExcelWriter and WordWriter
No changes were made for v8.1.1
Reporting Services Integration and Installer
Issues Resolved
- The OfficeWriter Designer 8.1.0 installer required VB6 (for Office 2007) to be installed. The OfficeWriter Designer 8.1.1 installer requires etiher VB6 (Office 2007) or VB7 (Office 2010) to be installed.
![](/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpvdzgxMH0&locale=en_GB&version=2)
OfficeWriter 8.1.0
Released March 28, 2012
ExcelWriter
Features Added
Issues Resolved
Template Object
- No exception thrown when rows of imported data exceeds file format limit
- Cultures with different thousand separators cause corrupt output in OOXML files
- Rows pushed down when using pivot tables in OOXML files
Application Object
- Getting a data label for a data point puts x-axis values in chart legend
- Deleting a row with conditional formatting causes a file error in Excel 2007/2010
- Hyperlink.Href returns null value instead of a valid link
- Exception thrown if chart legend has a background fill
The following fixes apply only to OOXML files:
- SoftArtisans.OfficeWriter.ExcelWriter.XMLModel at index does not exist exception thrown
- Unable to create hyperlinks in a merged area adjacent to another merged area
- Workbook.UseRCFormulaNotation always returned false
WordWriter
Features Added
Issues Resolved
- Table.InsertRows takes the formatting from the first row of the table
- WordTemplate image modifier does not scale images correctly in OOXML files
Reporting Services Integration
Features Added
- New ribbon design for Office 2007/2010 in Excel and Word
- OfficeWriter Designer support for Office 2010
Issues Resolved
- Designer in Excel hangs when previewing reports after changing multiple parameter values
Installer
Features Added
- Redesigned and improved installer for the OfficeWriter Designer
![](/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpvdzgwMH0&locale=en_GB&version=2)
OfficeWriter 8.0.0
Released November 30, 2011
ExcelWriter
Features Added
- Complete support for Excel 2007/2010 (XLSX) file formats with ExcelApplication
Issues Resolved
- Deleting the last remaining worksheet in a Workbook throws an exception on call to Save instead of on Delete
- Passing a non-seekable Stream object to a method when creating a picture will throw an exception
- Merged cells next to data markers on adjacent rows causes corrupt output
- License Manager tool displays popup twice when upgrading OfficeWriter key
- ExcelWriter allowed setting of invalid font sizes, which resulted in warnings in Excel 2010
- Incorrect default character width ysed for default font
WordWriter
Features Added
Reporting Services Integration
No changes were made for 8.0.0.
Installer
Features Added
- Redesigned and improved kit for installing .NET, Reporting Services, and SharePoint solutions on 32-bit and 64-bit systems.