.
...
- 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
- RemoveExtraDataMarkers available in SSRS for Excel reports
- PreserveFields and UnlinkIfFields available in SSRS for Word reports
Issues Resolved
- OfficeWriter Designer can now install against 32-bit Office 2013
| Anchor | ||||
|---|---|---|---|---|
|
OfficeWriter 8.4.0
...
- PivotTable API for OOXML files with ExcelApplication
- Create PivotTables from scratch
- Modify existing PivotTables
- Change the data source for PivotTables copied with Worksheets.CopySheet(Worksheet, Int32, String)
- Support for Excel 2007 statistical formulas
- Convert numeric strings to integers with DataImportProperties.ConvertStrings for Worksheet.ImportData with ExcelApplication
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
...
- 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
...
- 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
...
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
...
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
...
- Worksheets.CopySheet extended to support copying worksheets between workbooks
Issues Resolved
Template Object
- ExcelTemplate.BindData did not import data from a System.Data.OleDbDataReader
...
- 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
...
- 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
...
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.
...
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.
...
- Axis.LinkedtoSource and SeriesDataLabel.LinkedToSource for ExcelApplication
- Improved support for tables in OOXML files for ExcelApplication
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
...
- Ability to unlink IF fields in OOXML files after they are evaluated by WordTemplate with WordTemplate.UnlinkIFFields
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
...
- 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
...
- 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
...