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

The OfficeWriter Change Log lists the new features and bug fixes in every supported minor and major build of the product.
Current supported builds are v10.0.0 - v11.0

OfficeWriter includes several components that are developed on separately, so features and fixes are listed by component:

  • ExcelWriter - .NET API
  • WordWriter - .NET API
  • PowerPointWriter - .NET API
  • Reporting Services - SSRS Integration, including the OfficeWriter Designer and Renderers for Excel and Word
  • Installer - Components not related to the functionality of the product, including the installer and license key manager.

Jump to:

OfficeWriter 12.x

Releases
  • OfficeWriter 12.0.0

OfficeWriter 12.0.0

Excel Writer

New Features
  • Ability to password protect exported PDFs
  • Improved encryption
  • Ability to display blanks on a chart
  • Ability to duplicate column names in a pivot table
Bug Fixes
  • Fix for center across selection cells
  • Fix for unmerging cells
  • Improved support for table formulas
  • Fix for VML color names followed by number

Power Point Writer

New Features
  • Ability to replace a hyperlink in PowerPointTemplate
Bug Fixes
  • Fix for multiple passes of slide copies

 

OfficeWriter 11.x

Releases:

 

OfficeWriter 11.0.0

WordWriter

New Features

  • Ability to open, edit, and save .docx files with WordApplication

PowerPointWriter

New Features

  • Ability to iterate through the tables on a slide and get the cells within a table
  • Ability to set the style on table cells within a slide, including background color and font
  • Ability to get the contents of table cells

ExcelWriter

New Features

All new features are implemented for XLSX/XLSM files only unless otherwise indicated.

  • Support for Unicode character encodings when rendering workbooks to PDF
  • Support for Print Titles when rendering workbooks to PDF

Bug Fixes

  • Fix for PrintAreas not taking effect when rendering to PDF in certain situations
  • Fix for issue where setting the style on a cell could affect the style on the entire column
  • Ability to correctly read and save files with conditional formats in pivot tables
  • Fix for reading and parsing of formulas using named ranges that point to other worksheets
  • Fix to support conditional formats that apply to multiple areas
  • Fix to correctly read and preserve Office 2013 chart types with certain types of data lables

Reporting Services Integration

New Features

  • Support for SQL Server Reporting Services 2016

 

OfficeWriter 10.x

Releases:

OfficeWriter 10.1.2

Reporting Services Integration

Bug Fix

  • Fix issue where The Designer .NET would display error "There was an error opening this RDL file. It may not be valid" when opening some RDLs with a 2016 file format.

OfficeWriter 10.1

ExcelWriter

New Features

All new features are implemented for XLSX/XLSM files only unless otherwise indicated.

  • Large performance enhancments
  • Improved rendering of datapoint interiors
  • Improved datetime format support when rendering
  • Improved rendering of data labels as percent
  • Improved support of rendering legend entries

Bug Fixes

  • Fix for duplicated named styles

  • Fix rendering for text being clipped of when text alignment is right

PowerPointWriter

Bug Fixes

  • Fix for PowerPointTemplate and repeat slide
  • Fix for PowerPointTemplate and null values in data sets
  • Fix for PowerPointTemplate and images being cached incorrectly
  • Fix for PowerPointTemplate improved support for master slides and layouts
  • Fix for PowerPointTemplate and invalid characters

WordWriter

Bug Fixes

  • Allowing repeat blocks to be inside of if fields when updating+unlinking the if field.

Reporting Services Integration

New Features

  • Support for SQL Services Reporting Services 2016

OfficeWriter 10.0

ExcelWriter

New Features

All new features are implemented for XLSX/XLSM files only unless otherwise indicated.

  • Ability to save an area to a PDF file
  • Ability to save a worksheet or workbook to a PDF file
  • Conditional formats are rendered when saving to an image or PDF
  • Comments are rendered when saving to an image or PDF
  • Tables are rendered when saving to an image or PDF
  • Some basic shapes are rendered when saving to an image or PDF
  • Additional formulas supported in the calculation engine (see Calculation Engine Supported Formulas) 
  • Support for arrays when calculating formulas

Bug Fixes

  • Fix for data validation formula was not correctly updated

  • Fix for invalid Unicode characters not being properly escaped in comments

  • Fix for formula parser where it would throw exception on conditional formats

  • Fix for array formulas on data marker rows in Excel Template would not update correctly

  • Fix for series vary by colors not being correctly set in all versions of Excel

  • Fix for external references were not always working in ExcelTemplate

  • Fix for title overlay not always working in Excel 2013

  • Fix for calling multiple deletes on worksheets were styles span the whole worksheet

  • Fix for default row and height not always being preserved

  • Fix for merged cell borders not always being preserved 

  • Fix for reading files with small alpha values

  • Better support for preserving existing equations

PowerPointWriter

Bug Fixes

  • Fix for PowerPointTemplate throwing exception in multi-threaded environments.

WordWriter

Bug Fixes

  • Better support for 3 of 9 barcode and Calibri fonts in .doc files

  • Fix for concurrency issue in a multi-threaded environment.

Reporting Services Integration

New Features

  • The Designer .NET supports adding, editing, and inserting Reporting Services formulas into reports
  • The Excel Designer .NET supports creating and editing database queries through MSQuery
  • It is now possible to create a new report from scratch from the Excel Designer .NET, in addition to importing existing reports

 

OfficeWriter 9.x

Releases:

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

OfficeWriter 9.1

ExcelWriter

New Features

All new features are implemented for XLSX/XLSM files only unless otherwise indicated.

Enhancements

All enhancements are implemented for XLSX/XLSM files only unless otherwise indicated.

Bug Fixes

  • Issue when reading/writing certain PageSetup object properties resolved. 

PowerPointWriter

  • No changes were made to PowerPointWriter in 9.1 

WordWriter

New Features

No changes were made to WordWriter in 9.1 

Reporting Services Integration

New Features

Installer

  • The OfficeWriter installer no longer removes V8 License keys when installing OfficeWriter 9.
  • The OfficeWriter installer no longer automatically installs the OfficeWriter Designer. Please install the OfficeWriter Designer .NET separately.

 

OfficeWriter 9.0

ExcelWriter

New Features

PowerPointWriter

New Features

  • Template Object (see PowerPointTemplate API)
  • Application Object: Copy Slide, Delete Slide, Align Images, Document Properties

WordWriter

New Features

  • Add missing outer HTML tags to HTML documents used with the document modifier

Reporting Services Integration

No changes were made to Reporting Services Integration in 9.0.0

Installer

New Features

  • Handles multiple license keys
  • Automatically selects components to install based on license keys

 

OfficeWriter 8.x

Releases:

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.

OfficeWriter 4.x

Releases:

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

OfficeWriter 4.6.1

Released July 5, 2011

ExcelWriter 7.6.1

Features Added

  • ExcelApplication is now 20% faster and requires 20% less memory

Issues Resolved

  • Specific formula caused "Unreadable Content" error in XLSX file processed by ExcelTemplate in SSRS
  • ExcelWriter would return the wrong default character width for Calibri - size 11
  • ExcelApplication threw an exception when parsing some SSRS 2008 generated Excel files
  • Chart text was not properly set to "Automatic" by default
  • Data Series in charts were sometimes not sequenced correctly
  • GetHeader and GetFooter threw NullReferenceException when called on newly created worksheets

WordWriter 4.6.1

There were no changes made for 4.6.1.

Reporting Services Integration 4.6.1

Issues Resolved

  • Specific formula caused "Unreadable Content" error in XLSX file processed by ExcelTemplate in SSRS
  • Opening an RDL in the OfficeWriter Designer threw a "Type Mismatch" error with certain regional settings

OfficeWriter 4.6.0

Released April 4, 2011

ExcelWriter 7.6.0

Features Added

  • Data markers in Pivot Table cells are no longer processed explicitly (with data being brought in) or implicitly (with blank rows added to the sheet), as described in the new EWTemplates and Pivot Tables (deprecated) page
    • Pivot Table templates no longer require dummy data
    • Pivot Table templates no longer require edit copies set not to refresh on open
    • Shapes and Charts can be placed beside Pivot Tables
  • Sparklines now preserved in Excel 2010 created file when processed by ExcelTemplate

Issues Resolved

  • ExcelTemplate threw an error on Excel 2010-created files with Excel 2003-format pivot tables
  • Shapes such as charts stretched when placed next to pivot tables that were filled using ExcelTemplate
  • ExcelWriter generated files no longer open in protected mode in Excel 2010

WordWriter 4.6.0

Features Added

  • Since the WordTemplate COM-callable wrapper is no longer installed, WordWriter is no longer installed in the Global Assembly Cache (GAC).

Issues resolved

  • Some files processed by WordTemplate, then WordApplication, caused errors when opened in Word 2010
  • WordWriter threw an error when repeat blocks were in tables in templates created using Word 2010

Reporting Services Integration 4.6.0

Issues Resolved

  • Reporting Services 2008 R2 formulas did not work in OfficeWriter Reporting Services integration for Word
  • OfficeWriter Designer did not read Reporting Services 2008 formulas from the RDL files

Installer

Features Added

  • ExcelWriter COM and the WordTemplate COM-callable wrapper are no longer automatically installed during the OfficeWriter installation process. Bits are available upon request.

OfficeWriter 4.5.1

Released January 25, 2011

ExcelWriter 7.5.1

Features Added

Issues Resolved

  • Issues with PivotCharts in ExcelTemplate
    • PivotCharts missing data in ExcelTemplate reports when streamed to client
    • PivotCharts lose series formatting in OOXML (Excel 2007) file format
  • ExcelTemplate did not work with template files created in Excel 2010
  • ExcelTemplate did not throw an error if file format limits on the number of characters in a cell were exceeded.
  • Processing certain files with comments using ExcelTemplate created a corrupt file
  • Calling ExcelTemplate.Process() on files were certain formulas threw an "Unrecognizable symbol" exception.
  • ExcelApplication did not throw an error if file format limits on the number of characters in a cell were exceeded.
  • Horizontal page breaks could not be inserted on worksheets created using Worksheets.CopySheet
  • PageSetup attributes were not applied to worksheets created using Worksheets.CopySheet
  • Merging some spreadsheets created using Crystal Reports resulted in a corrupt workbook.
  • A number of Charting API issues in ExcelApplication
    • Setting Series.Label.ContainsValue broke formatting
    • Setting DataPoint.Interior.Pattern corrupted some files
    • Data Labels set in code not visible in Excel 2003
    • Picture chart fills cause an exception to be thrown when patterns are read
    • ExcelApplication fails to parse Legend visibility correctly
    • Some files were corrupted when a Series was removed from a SeriesCollection
    • Setting a CategoryData formula to a multi-column range threw an invalid formula exception
  • ColumnProperties.AutoFitWidth() entered an infinite loop on columns with certain NumberFormat settings
  • Cell.Formula threw an exception when attempting to read a formula referencing an external workbook using VLookup
  • Some files generated with ExcelTemplate created corrupt files when opened and saved in ExcelApplication

WordWriter 4.5.1

Issues Resolved

  • WordTemplate created a corrupted file when processing two IF fields
  • WordTempalte threw an exception or produced a corrupt file when processing a template with IF fields containing other fields
  • Merging a document with a programmatically-created table into another document threw an index out of bounds exception
  • After replacing an object in a header or footer using Element.SearchAndReplace, the next call to SearchAndReplace() threw a WordWriterException
  • Watermark object can now access watermarks in input files
  • Watermark was not able to insert new watermarks
  • Setting some table styles using WordApplication caused formatting issues and corrupted tables
  • Merging two documents using Document.Append caused corrupted output in some cases
  • Opening and saving a file created using a non-English version of Word caused formatting issues

Reporting Services Integration 4.5.1

Features Added

  • OfficeWriter Designer now supports reports built using Report Builder 3.0

Issues Resolved

  • Reporting Services reports created with the OfficeWriter Designer broke reports when an Oracle data source was used.

Installer

Issues Resolved

  • License Key Manager threw error when being run on a machine with no SoftArtisans license keys in the registry.

OfficeWriter 4.5.0

Released September 21, 2010

ExcelWriter 7.5.0

Features Added

Issues Resolved

  • ExcelTemplate can now process files created using Microsoft's OOXML SDK
    • Process method no longer throws exception when processing a worksheet copied using Microsoft's OOXML SDK
    • Process method no longer throws exception when processing a workbook with a large number of worksheets copied using Microsoft's OOXML SDK
  • Issues with deleting worksheets in workbooks
    • Deleting a Worksheet in a Workbook with Worksheet-level named ranges no longer corrupts the output spreadsheet
    • Deleting a Worksheet in a Workbook with Workbook-level named ranges no longer throws an "Unable to parse formula" exception when Save is called
    • Calling PageSetup.SetPrintTitleRows or PageSetup.SetPrintTitleColumns on the last sheet of a workbook, then deleting the worksheet no longer throws exception on Save
  • Improved Grouping and Nesting Support
    • Headers and Footers are no longer printed when the data source is empty
    • Data marker modifiers now also work on %%value() markers
    • Merged cells are now preserved in spreadsheets with Grouping and Nesting
    • Conditional formatting copied from a header or footer to a data marker row using paste special -> formats is now preserved
    • Shared formulas in headers or footers are changed to equivalent regular formulas, rather than causing a corrupt output spreadsheet
  • ExcelTemplate.Process() issues with some templates
    • Process no longer fails on a small number of template files that had previously caused it to fail
    • Process no longer throws a "Cannot find last DBCELL record" after being first opened in ExcelApplication
    • Process no longer throws a "Sheet was not in expected location" error after being first opened in ExcelApplication
  • Shape.FillTransparency no longer inverts its value
  • Cell values on sheets created using Worksheets.CopySheet no longer reference incorrect values
  • Calling ColumnProperties.AutoFitWidth() on a column with a custom NumberFormat no longer causes an Out of Memory exception
  • R1C1-style formulas no longer cause an "Unable to parse formula" exception
  • Improved ability to handle spreadsheets generated by Crystal Reports
    • ExcelWriter can now open some files generated by Crystal Reports that had previously been impossible to open
    • Small bmp files can now be copied from Excel spreadsheets generated through Crystal Reports

WordWriter 4.5.0

Features Added

  • WordWriter SharePoint Integration
    • WordWriter can now use SharePoint Lists and Views as data sources
    • WordWriter can now save documents as Document Library items or List Item attachments
  • New WordTemplate.SaveExtension property returns the extension of the template file that has been opened
  • New Document.Append method appends one Document to another, preserving all Sections, including header and footers plus other section formatting
  • WordWriter now supports Grouping and Nesting with the WordTemplate object

Issues resolved

  • Improved WordTemplate support for Open Office XML format
    • Newline characters now handled correctly by WordTemplate in the Open Office XML file format
    • Support for all Open Office XML file extensions (.docm, .dotx, and .dotm all are now supported)
  • Deleting table rows containing merge fields within a bookmark no longer damages the bookmark, allowing the template to populate without corrupting the output document
  • Binding an empty DataTable to a template using WordTemplate.SetRepeatBlock no longer throws an exception, but instead removes bookmark
  • Inserting content into a header with field no longer causes a corrupt document
  • Custom styles preserved when two Document objects are merged using the Document.InsertAfter method
  • Word documents with images with text wrapping settings other than "Inline with Text" no longer corrupted when opened and saved using WordApplication
  • Setting TableFormatting.AutoWidth to true no longer fails to have any effect; columns set to Auto using Table.SetPreferredColumnWidthUnits will now have their widths automatically calculated

Reporting Services Integration 4.5.0

No changes were made for 4.5.0

OfficeWriter 4.1.0

Released November 30, 2009

ExcelWriter 7.1.0

Features Added

  • ExcelTemplate can process files created with Microsoft's Office Open XML (OOXML) SDK
  • Nesting and grouping formatting enabled for OOXML files. For more information, see Creating Data Markers

Issues Resolved

  • Compiler error thrown while using ChartType enumeration in Visual Studio 2008
  • Several issues addressed regarding support for files created by the native Excel renderer from SQL Server Reporting Services 2008
    • Accessing worksheets threw object reference exceptions
    • Creating a chart and adding a series corrupted the output file
    • Adding or removing rows or columns, copying worksheets, or creating a named range threw an internal casting exception
    • Creating a range from one or more areas threw a parser exception
    • Accessing or changing colors in the Palette threw Invalid Color Index exception
  • Several issues addressed regarding support for files created by the native Excel renderer from SQL Server Reporting Services 2005
    • Missing shared string table from some spreadsheets threw Object Reference exception
    • ColumnProperty.ApplyStyle() failed to get Style interface unless Worksheet.PopulatedCells was first accessed
  • ExcelWriter did not process three-letter columns correctly when referencing cells, for example "AAA4"
  • AutoFitWidth threw IndexOutOfBounds exception for column with formula formatted as number
  • Calling ApplyStyle() or SetStyle() on a ColumnProperties object referencing a column with a formula in it threw an Object Reference exception
  • Setting CharacterRun.Font properties for more than 586 cells corrupted the file
  • Setting CORREL function with Application object displayed "#VALUE" until user clicked on the cell
  • ExcelTemplate.ExcludeMacros property now available when working with OOXML files
  • Strings that looked like data markers after a formula is evaluated were treated like data markers
  • The wrong content-type header was being sent when streaming OOXML files to the user, causing some browsers to treat them as BIFF8 (.xls) files
  • ExcelTemplate no longer inserts a 0 for Null values brought into an OOXML template using a DataReader

WordWriter 4.1.0

Features Added

  • WordTemplate can evaluate formulas for Word 2007 OOXML file format files (.docx/.docm). For more information, see Creating Merge Fields

Issues Resolved

  • Deleting an element in a table made in Word 2007 corrupted the output document in some cases
  • Deleting a row in a table also deleted the value in the first cell of the next row
  • In some cases documents with embedded images threw Out of Memory exceptions
  • Calling Document.Search() on a document with an empty field threw a stack overflow exception
  • Inserting many images with WordTemplate caused some images not to display

Reporting Services Integration 4.1.0

Issues resolved

  • OfficeWriter Designer threw an error when attempting to publish a 2008 RDL with a Report Global embedded using the Insert Formula button
  • OfficeWriter Designer threw data source exception when a query was associated with a row in a table in a Word Document
  • OfficeWriter Designer did not allow exporting Excel 2007 files with macros as RDLs
  • OfficeWriter Designer's RDL parser thew an Unknown Exception for report model data sources with field names containing fewer than 5 characters

OfficeWriter 4.0.0

Released June 3, 2009

ExcelWriter 7.0.0

Features Added

  • ExcelWriter is written in pure C# .NET and no longer has a dependency on the J# runtime
  • ExcelTemplate supports Excel 2007 OpenOXML (OOXML) files with .xlsx, .xlsm, .xltx, and .xltm extensions
  • Support for creating and viewing ExcelWriter files in Excel 2007
  • Ability to iterate over all named ranges in a worksheet or workbook
  • New Shape.FillTransparency property added
  • Ability to bind data to an individual worksheet with the DataBindingProperties object
  • Support for unicode in data markers
  • New Cell.GetTextHeight and GetTextWidth methods for autofitting merged cells
  • New InsertRows() and InsertColumns() methods
  • Performance improvements:
    • ExcelTemplate + ExcelApplication
      1. Processes binary (XLS) files up to 50% faster
      2. Blank cell optimizations results in 400% improvement in speed and memory usage when using ExcelTemplate and ExcelApplication together
    • ExcelTemplate
      1. Formulas are processed up to twice as fast
      2. Reduced memory usage
      3. Ability to bind data only to a specific worksheet
    • ExcelApplication
      1. Faster algorithm for style optimization
      2. Improved performance when opening existing files and setting column widths
      3. Formulas can be inserted up to 8 times faster and improved performance for the formula parser
      4. Improved autofit algorithm

WordWriter 4.0.0

Featured Added

  • Support for Office Open XML (OOXML) files in WordTemplate with .docx, docm, dotx, dotm file extensions
  • Support for creating and viewing files in Word 2007 including:
    • Support for new themes, styles, table formatting options, hapes, charts, and diagrams
  • Written in pure #C .NET and no longer depends on J# runtime
  • Ability to evaluate IF fields
  • New EnableNextFields property
  • New SetMailMerge functionality to mimic Microsoft Word mail merge
  • Improvements to performance
    • WordTemplate uses 40x less memory with OOXML files when processing large files or importing large amounts of data
    • WordTemplate is 35% when processing large binary (DOC) files
    • WordApplication is up to 6x faster when processing binary files
  • HMTLtoWord open source project for importing HTML into WordWriter documents

Reporting Services Integration 4.0.0

Features Added

  • Full SQL Server Reporting Services 2008 support
    The OfficeWriter Designer now supports the embedding of Excel and Word within reports for SQL Server Reporting Services 2008.

  • Add real Excel and Word to reports designed in Visual Studio 2008
    The OfficeWriter Designer also now supports reports designed in Visual Studio 2008 and Report Builder 2.0, allowing the addition of Excel and Word versions to an existing report.

  • Office Open XML Format support
    In SoftArtisans OfficeWriter version 4, the Office Open XML format (.docx and .xlsx; .docm and .xlsm) is now supported.

  • Significant performance improvements
    Improvements with memory efficiency in underlying ExcelWriter and WordWriter DLLs can lead to significant performance gains

  • Unicode Field Names in Data Markers
    Data markers can now include any Unicode character except brackets [] and braces {}

  • Unicode Data Source Names with Excel Reports
    Excel reports now accept any Unicode character in data source names

  • No labels