OfficeWriter Documentation
.
OfficeWriter v8 Docs
Page tree
ConfigureSpace tools
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 16 Next »

Below are a list of added features and bug fixes that are incorporated for each minor build of OfficeWriter 8.x

OfficeWriter 8.5.0

Release 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

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.

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

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

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

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.

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.

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

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.
  • No labels