Below are a list of added features and bug fixes that are incorporated for each minor build of OfficeWriter 8.x
OfficeWriter 8.3.0
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
OfficeWriter 8.2.1
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
OfficeWriter 8.2.0
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
OfficeWriter 8.1.2
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.
OfficeWriter 8.1.1
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.
OfficeWriter 8.1.0
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
OfficeWriter 8.0.0
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.