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=e2FuY2hvcjpvd2Q4NjJ9&locale=en_GB&version=2)
OfficeWriter 8.6.2
ExcelWriter
No changes were made to ExcelWriter in 8.6.2
WordWriter
New Features
All new features are implemented for WordTemplate DOCX/DOCM only unless otherwise indicated.
- Ability to ignore certain merge fields when processing with WordTemplate
Reporting Services Integration
No changes were made to Reporting Services Integration in 8.6.2
Installer
Issues Resolved
- Installer fails on certain environments with SharePoint 2010 and SSRS 2008 R2 in integrated mode
![](/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpvd2Q4NjF9&locale=en_GB&version=2)
OfficeWriter 8.6.1
ExcelWriter
New Features
All new features are implemented for XLSX/XLSM files only unless otherwise indicated.
Issues Resolved
All issues are resolved in ExcelApplication for XLSX/XLSM files only unless otherwise indicated.
- Custom pivot table styles were corrupted after opening and saving the file
- Minor chart tick line position and visibility were set incorrectly
- Copying and deleting a worksheet with custom print properties caused corrupt output
- ExcelWriter threw Invalid ST_PatternType error on save
- Importing large 0 values with ImportData caused corrupt output
- Setting ShowEquation and ShowRSquaredValue had no effect (XLS files only)
WordWriter
New Features
All new features are implemented for WordTemplate DOCX/DOCM only unless otherwise indicated.
Issues Resolved
All issues are resolved in WordTemplate DOCX/DOCM only unless otherwise indicated.
- WordWriter threw invalid hexidecimal character error on machines with multi-core CPUs
Reporting Services Integration
Issues Resolved
- ImportTemplate button not disabled in report view in Excel and Word Designers
- Word designer hangs when viewing reports with long parameter names, long report names, or are stored in deeply nested report server directories
Installer
Issues Resolved
![](/plugins/servlet/confluence/placeholder/macro?definition=e2FuY2hvcjpvd2Q4NjB9&locale=en_GB&version=2)
OfficeWriter 8.6.0
Release September 25, 2013
ExcelWriter
New Features
All new features are implemented for XLSX/XLSM files only unless otherwise indicated.
- Enhanced performance for opening files with extensive formulas in ExcelApplication
- ExcelApplication PivotTable API supports classic layout
- Sparkline support for ExcelTemplate
- Sparklines that point to data markers are updated
- Sparklines in data marker rows are copied for each new row
Issues Resolved
All issues are resolved in ExcelApplication for XLSX/XLSM files only unless otherwise indicated.
- Cell references in data labels for Excel 2013 files were not preserved
- ExcelWriter throws index out of bounds exception when setting ColumnProperties.Width to 0 if the column contains an anchor for an image
- PivotTables created from mixed case data (i.e. "Half Price" vs. "half price") produced corrupt output
- Special characters written to Cell.Value were not encoded correctly
- ExcelTemplate throws key not present in dictionary exception when a worksheet with data markers and a text box is deleted with Worksheets.Delete(String)
WordWriter
No changes were made to WordWriter in 8.6.0
Reporting Services Integration
New Features
- New OfficeWriter Designer .NET with support for 64-bit and 32-bit Excel
- Import an existing Excel template into an RDL through the OfficeWriter Designer for Excel
- Import an existing Word template into an RDL through the OfficeWriter DEsigner for Word
![](/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
- ExcelApplication support for remaining Excel 2007, 2010, and 2013 formulas:
- Excel 2007:
- DATESTRING, LEFTB, LENB, MIDB, NUMBERSTRING
- IFERROR, DBCS, USDOLLAR, GETPIVOTDATA
- EFFECT, FVSCHEDULE, INTRATE, MDURATION, NOMINAL, RECEIVED, TBILLEQ, XIRR, XNPV
- ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, CUMIMPT, CUMPRINC, DISC, DOLLARDE, DOLLARFR, DURATION, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PRICE, PRICEDISC, PRICEMAT, TBILLPRICE, TBILLYIELD, YIELD, YIELDDISC, YIELDMAT
- COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD
- BESSELI, BESSELJ, BESSELK, BESSELY, COMPLEX, CONVERT, DELTA, ERF, ERFC, GESTEP
- IMABS, IMAGINARY, IMARGUMENT, IMCONJUGATE, IMCOS, IMDIV, IMEXP, IMLN, IMLOG10, IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSIN, IMSQRT, IMSUB, IMSUM
- BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
- CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBSETCOUNT, CUBEVALUE
- Excel 2010:
- NETWORKDAYS.INTL, WORKDAY.INTL
- ERF.PRECISE, ERFC.PRECISE
- AGGREGATE, CEILING.PRECISE, FLOOR.PRECISE, ISO.CEILING
- BETA.DIST, BETA.INV, BINOM.DIST, BINOM.INV, CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT, CHISQ.TEST, CONFIDENCE.NORM, CONFIDENCE.T, COVARIANCE.P, COVARIANCE.S, F.DIST, F.DIST.RT, F.INV, F.INV.RT, F.TEST, GAMMA.DIST, GAMMA.INV, LOGNORM.DIST, LOGNORM.INV, MODE.MULT, MODE.SNGL, NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV, PERCENTILE.EXC, PERCENTILE.INC, PERCENTRANK.EXC, PERCENTRANK.INC, QUARTILE.EXC, QUARTILE.INC, RANK.AVG, RANK.EQ, STDEV.P, STDEV.S, VAR.P, VAR.S, T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T, T.TEST, ECMA.CEILING, EXPON.DIST, GAMMALN.PRECISE, HYPEGEOM.DIST, NEGBINOM.DIST, POISSON.DIST, WEIBULL.DIST, Z.TEST
- Excel 2013:
- ACOT, ACOTH, ARABIC, BASE, CEILING.MATH, COMBINA, COT, COTH, CSC, CSCH, DECIMAL, FLOOR.MATH, SEC, SECH
- BION.DIST.RANGE, GAMMA, GAUSS, PERMUTATIONA, PHI, SKEW.P
- BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR, IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH, IMTAN
- DAYS, ISOWEEKNUM
- ENCODEURL, FILTERXML, WEBSERVICE
- FORMULATEXT, IFNA, ISFORMULA, NUMBERVALUE, PDURATION, RRI, SHEET, SHEETS, UNICHAR, UNICODE, XOR
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
- ExcelTemplate threw "Stream does not support reading" exception when running against .NET 4.5
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
- WordTemplate threw "Stream does not support reading" exception when running against .NET 4.5
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.