Page tree
Skip to end of metadata
Go to start of metadata

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

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

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

  • Unable to install OfficeWriter 8.5.1 or 8.6.0.

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

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

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

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
  • 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

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