OfficeWriter Version Differences

Home Products Support Corporate

Differences Between V8.0 AND V8.1:

Excel Reporting | New Features:

	Axis.LinkedToSource and SeriesDataLabel.LinkedToSource for ExcelApplication
	Improved support for tables in OOXML files for ExcelApplication

Excel Reporting | Issue Addressed:

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
	SoftArtisans.OfficeWriter.ExcelWriter.XMLModel at index does not exist (OOXML)
	Unable to create hyperlinks in a merged area adjacent to another merged area (OOXML)
	UseRCFormulaNotation always returned false (OOXML)

Word Reporting | New Features:

Ability to unlink IF fields after they are evaluated by WordWriter (OOXML)

Word Reporting | Issue Addressed:

	InsertRow takes the formatting from the first row of a table in WordApplication
	WordTemplate ‘Image’ modifier does not scale images correctly (OOXML)

For Reporting Services | New Features:

	New skin for Office 2007/2010 ribbon in Excel and Word
	OfficeWriter Designer supports creating and viewing reports in Office 2010
	Full SQL Server Reporting Services 2012 support

For Reporting Services | Issue Addressed:

Designer in Excel hangs when previewing reports after changing multiple parameter values

Differences Between V4.6.1 AND V8.0:

Excel Reporting | New Features:

	Complete support for Excel 2007/2010 (XLSX) file formats with ExcelApplication
	Redesigned installer

Excel Reporting | Issue Addressed:

	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

Word Reporting | New Features:

	Ability to include arbitrary RTF or HTML documents in merge fields with WordTemplate
	Redesigned installer

For Reporting Services | New Features:

Redesigned installer

Differences Between V4.6 AND V4.6.1:

Excel Reporting | New Features:

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

Excel Reporting | Issue Addressed:

	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

Word Reporting

There were no changes to WordWriter between 4.6 and 4.6.1.

For Reporting Services | Issue Addressed:

	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

Differences Between V4.5.1 AND V4.6:

Excel Reporting | New Features:

	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 Templates and Pivot Tables 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
	Improved support for files created with Excel 2010
	- ExcelApplication: Excel 2003 (XLS/BIFF8) format files created in Excel 2010 are now supported
	- ExcelTemplate: Excel 2003 (XLS/BIFF8) and Excel 2007 (XLSX/OpenXML) format files created in Excel 2010 are now supported

Excel Reporting | Issue Addressed:

	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

Word Reporting |New Features:

	WordTemplate COM-callable wrapper is no longer automatically installed
	- COM-callable wrapper is available upon request
	- Since it is no longer needed in the default installation, WordWriter is no longer installed in the GAC by the automatic installer

Word Reporting | Issue Addressed:

	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

For Reporting Services | New Features:

	Reporting Services 2008 R2 formulas are now supported in OfficeWriter Reporting Services Integration for Word
	Reporting Services Designer nor supports Reporting Services 2008 formulas

For Reporting Services | Issue Addressed:

	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

Differences Between V4.5 AND V4.5.1:

Excel Reporting | New Features:

	ExcelWriter can now insert images into headers and footers using the new HeaderFooterPicture object.
	The new HeaderFooterSection object allows greater control over headers and footers
	The new ChartFillPattern class provides values for all Excel 2003 patterns
	The new SeriesDataLabel.DataLabelPlacement property allows you to explicitly set the location of the data label on each data point in a Series using the DataLabelPlacementType enum

Excel Reporting | Issue Addressed:

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.

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

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

Word Reporting | Issue Addressed:

	WordTemplate created a corrupted file when processing two IF fields
	WordTemplate 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
	License Key Manager threw error when being run on a machine with no SoftArtisans license keys in the registry.

For Reporting Services | New Features:

	OfficeWriter Designer now supports reports built using Report Builder 3.0
	OfficeWriter Designer now supports Excel 2010

ExcelWriter COM | Issue Addressed:

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

Differences Between V4.1 AND V4.5:

Excel Reporting | New Features:

ExcelWriter SharePoint Integration

-	ExcelWriter can now use SharePoint Lists and Views as data sources
-	ExcelWriter can now output spreadsheets to Document Libraries or as List Item attachments

Excel Reporting | Issue Addressed:

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

ExcelWriter COM uses memory more efficiently than did ExcelWriter COM version 7.0 and 7.1, reducing server instability

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

Word Reporting | New Features:

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

Word Reporting | Issue Addressed:

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

Differences Between V4.0 AND V4.1:

Excel Reporting | New Features:

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

Excel Reporting | Issue Addressed:

Compiler error thrown while using ChartType enumeration in Visual Studio 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

-	Accessing worksheets threw object reference exceptions
-	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

Word Reporting | New Features:

WordTemplate can evaluate formulas. For more information, see Creating Merge Fields

Word Reporting | Issue Addressed:

	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 |Issue Addressed:

	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

Differences Between V3.9.2 AND V4.0:

Excel Reporting | New Features:

ExcelTemplate now has support for Excel 2007 OpenXML files with .xlsx or .xlsm extensions

-	This provides many new options such as support for more then a million rows and 16K columns
-	Virtually unlimited unique colors
-	No limit to number of conditional formats
-	Unlimited number of styles per workbook
-	Up to 32K characters per cell

Office 2007 templates in Excel and Word

It is now possible to iterate over all of the named ranges in a worksheet or workbook.

New property Shape.FillTransparency added, which takes a real number from 0 (opaque) to 1 (transparent).

It is now possible to bind data only to an individual worksheet using the new DataBindingProperties object in ExcelTemplate

SofArtisans.OfficeWriter.ExcelWriter.dll contains only the pure .NET ExcelApplication and ExcelTemplate classes. The legacy .NET wrapper classes for ExcelWriter COM are no longer included.

All re-written in C#. No more dependency on J# run-time

Support for Unicode Data Markers

New GetTextHeight() and GetTextWidth() methods to assist with autofitting merged cells

New InsertRows() and InsertColumns() methods for bulk insertion of rows and columns

Performance improvements:

-	ExcelApplication and ExcelTemplate process binary (.xls) files up to 50% faster
-	Files with many formulas are processed up to twice as fast with ExcelTemplate
-	New data binding method allows you to bind a data source with only the data markers in a specific worksheet
-	faster algorithm for style optimization in ExcelApplication
-	Improved performance when opening existing files with ExcelApplication
-	Improved performance when setting column width with ExcelApplication
-	Improved performance of ExcelApplication's formula parser. Formulas can now be inserted up to 8 times faster.
-	Reduced memory usage by ExcelTemplate
-	Blank cell optimizations product up to 400% improvement in speed and memory usage when using ExcelTemplate with ExcelApplication
-	Improved autofit algorithm

Word Reporting | New Features:

Office Open XML (OOXML) File Support. The WordTemplate object now supports .docx and .docm files with all their new features including:

-	Support for new themes, styles and table formatting options
-	Support for new shapes, charts and diagrams

Office 2007 templates in Excel and Word

All re-written in C#. No more dependency on J# run-time

IF field evaluation

Processing large binary Word files is up to 6 times faster with WordApplication and 35% faster with WordTemplate

Processing large files or importing data with WordTemplate uses 40 times less memory with OOXML files (.docx and .docm)

HTMLtoWord (new open source project for importing HTML-formatted text into WordWriter documents)

Generate mailing labels easily with the new EnableNextFields property

Use the new SetMailMerge() method to perform mail merges that closely match Microsoft Word mail merge functionality.

Reporting Services Integration | New Features:

	Office 2007 Now has support for Office 2007 OpenXML files with .xlsx, .xlsm, docx or docm extensions
	Full SQL Server Reporting Services 2008 Support Our designer now supports the embedding of Excel and Word within reports for SQL Server Reporting Services releases up to SQL Server 2008.
	Full Support for Visual Studio 2008 OfficeWriter Reporting Services integration now supports RDLs edited in Visual Studio 2008
	Support for Reporting Services in SharePoint integration mode OfficeWriter Reporting Services includes support now for the new SharePoint integration mode in SQL Server 2008 Reporting Services
	Forms Authentication with the OfficeWriter Designer When a user attempts to connect to a report server with forms authentication, he or she will be prompted to enter a username and a password.
	Support for Report Model data sources and Report Builder 2.0
	Enabling of Office Writer for Reporting Services properties from the web.config file of the report server application
	Improved support for images Our Word designer now provides the ability to insert images
	Shared DataSource support Shared DataSources are now preserved when publishing the report from OfficeWriter Designer
	Data Types now preserved OfficeWriter renderers now access the original value in order to preserve the underlying data type.

Differences Between V3.9.1 AND V3.9.2:

Excel Reporting | New Features:

ExcelTemplate now supports unicode characters in data markers. Field names with unicode characters must be within square brackets

Excel Reporting | Issue Addressed:

	Setting MaxRows to 65535 caused file corruption
	ExcelTemplate lost an hour in certain timezones with daylight savings time
	ExcelTemplate Process method failed, throwing an object reference error, in certain applications with multiple SetDataSource calls
	AutoFitWidth did not work in destination worksheet after calling CopyPaste method
	Save method threw "Index out of range" exception in certain cases when creating multiple styles with ExcelApplication. This issue was introduced in ExcelWriter version 6.9.1
	ChartHeight property did not work in versions 6.8.1 and 6.9.1
	VLOOKUP formula inserted with ExcelApplication did not behave correctly in Excel 2003
	Error "Failed to get value of cell..." when attempting to retrieve the value of a cell containing a hyperlink with ExcelApplication
	Array formulas not preserved when processed with ExcelTemplate

Word Reporting | New Features:

WordTemplate can now evaluate IF fields on the server using the new UpdateIfFields property

Word Reporting | Issue Addressed:

	Merged documents containing shapes and floating images caused Word to crash
	Section formatting was not preserved properly in merged documents
	Table formatting was not preserved properly in merged documents
	Some merged documents had incorrect font formatting
	Watermark inserted with WordApplication did not take effect
	Accessing headers/footers in a document with multiple sections removed existing header/footer content

Reporting Services Integration | New Features:

	Support for SQL 2008
	Support for RDL generated in Visual Studio 2008 and Report Builder 2.0
	Support for Reporting Services in SharePoint integration mode. See this KB article: http://support.softartisans.com/kbview.aspx?ID=1278
	Support for Forms Authentication
	Support for Report Model data sources
	Ability to enable certain WordWriter properties when using OfficeWriter in Reporting Services, including processing NEXT fields and IF fields.

The following keys must be added to web.config to turn on these settings:
	<appSettings> <add key="EnableNextFields" value="True" /> <add key="UpdateIfFields" value="True" /> </appSettings>

Reporting Services Integration | Issue Addressed:

Word reports with merge fields in the header or footer that were not also in the main body of the document threw exception "This merge field is used in the source template, but it doesn't exist in the data source"

Differences Between V3.8.1 AND V3.9.1:

Excel Reporting | New Features:

	64-bit support
	IIS 7.0 support
	Faster algorithm for style optimization in ExcelApplication
	Improved performance when opening existing files with ExcelApplication
	Improved performance when setting column width
	Reduced memory usage by ExcelTemplate
	Optimized performance of ExcelApplication’s formula parser. Formulas can now be inserted up to 8 times faster.
	Blank cell optimizations produce up to 400% improvement in speed and memory usage when using ExcelTemplate together with ExcelApplication
	Improved autofit algorithm
	New methods added to assist with autofitting merged cells: GetTextHeight and GetTextWidth
	New InsertColumns and InsertRows methods for bulk insertion of columns/rows

Excel Reporting | Issue Addressed:

	Chart data range in ExcelWriter-generated spreadsheet changed when another MS Excel file was open. Now all chart data ranges are created with absolute rather than relative references.
	ExcelApplication .NET unable to open certain files created by COM version of ExcelWriter.
	Issue with ExcelApplication COM version when using Style.Number and Cells.MergeCells in combination.
	Issue with Daylight Savings Time
	ExcelApplication unable to open spreadsheet generated by SSRS default Excel renderer.
	Calling the DeleteColumn method on a worksheet with a horizontal freeze pane caused Excel to crash when opening the generated file.
	Various issues with CopyPaste method
	Exception thrown if copied Area has formula referencing another workbook
	Currency formatting not copied correctly
	error "System.Exception: Index: 65535, Size: 1" when copying certain files
	Some borders missing from copied Area
	Some cells had unintended bold formatting after copying from another workbook
	Error "Failed to get style xf index" when calling CopyPaste many times
	Unhandled exception in ExcelApplication COM caused message box
	Importing certain types of JPGs caused exception "Index was outside the bounds of the array"
	File corruption when generating encrypted workbooks with Pivot Tables
	ExcelApplication.Open threw exception "Error parsing Excel stream: unexpected token: PROTECT" with certain files
	Opening and saving certain Excelwriter COM-generated spreadsheets with ExcelWriter .NET caused file corruption.
	Numbers exceeding Excel's limit of 15 digits were being rounded up rather than truncated. ExcelWriter's behavior now matches MS Excel's.
	"Unsupported Function" error when opening spreadsheet with DateDif function.
	Excel crashed when changing font in OfficeWriter-generated spreadsheet containing character runs
	CopySheet did not copy local named ranges correctly (this also affected print titles)
	Error "Failed to get Style inteface; Failed to create new CellStyleModel" when calling ApplyStyle method
	Error "Value was either too large or too small for a Decimal" when autofitting an area containg NaN double values
	Creating spreadsheet with over 40 worksheets and applying many styles caused error "Failed to get Style interface"
	In version 6.8.1, SetCellDataSource converted certain strings to numbers
	ColumnProperties.AutoFitWidth threw exception when column contained formulas with currency formatting
	Calling Worksheet.DeleteColumn()" on a worksheet with freezepanes caused Excel to crash when opening output file
	Error accessing cell value in spreadsheet generated by SSRS generic Excel renderer
	Password-protected workbook generated by ExcelWriter version 6.8.1 did not prompt user for password when opened
	Errors calling ApplyStyle or AutoFitWidth on large areas
	PlotArea and Legend were not centered in generated file

Word Reporting | New Features:

	64-bit support
	IIS 7.0 support
	HtmlToWord - New open source project for importing HTML-formatted text into WordWriter documents
	Improved generation of mailing labels with new EnableNextFields property
	New SetMailMerge method provides an additional mail merge option that more closely matches MS Word mail merge functionality. SetMailMerge treats the entire page as a repeat block without requiring the addition of bookmarks, allowing reuse of existing MS Word mail merge templates.

Word Reporting | Issue Addressed:

	Document properties NumCharacters, NumWords and NumParagraphs incorrectly returned 0.
	Table.AddRows and Table.InsertRows shifted cells to the right
	Row inserted in nested table had incorrect formatting
	Inserting tables into table cells sometimes caused corrupt documents
	Table inserted in table cell was too wide
	Lists and paragraphs inserted into existing table cells sometimes resulted in incorrect formatting or corrupted files
	Some elements inserted after a table appeared as if inside a table cell.
	Adding a watermark to a document caused corruption of character formatting and tables
	Documents created with certain fonts threw an exception. WordWriter now supports more font types
	Calling hyperlink.GetUrlString() on an existing hyperlink in a Word document caused an exception
	Adding a watermark caused corruption of character formatting and tables
	Adding watermark to certain files caused NullPointerException
	Footnotes were not preserved when copying one document into another
	Header and footer missing after opening and saving a document with an image in the header with WordApplication
	Daylight Savings Time issue with .NET 2.0 on Windows 2003

Reporting Services Integration | New Features:

	64-bit support
	Support for SQL Server 2008 CTP6. The OfficeWriter Designer will work with any version of SQL Server up to the most recent CTP of SQL Server 2008 (CTP6 - February 2008). To get the special builds of the OfficeWriter renderers for CTP6, contact SoftArtisans.
	Ability to insert images with Word designer

Reporting Services Integration | Issue Addressed:

	Shared DataSources are now preserved when publishing report from OfficeWriter Designer.
	If a user added and then removed a bookmark with the OfficeWriter Designer Word Add-In, a link to the Selection Query data source was left in the RDL, causing a runtime error "The following bookmark can't be found in the template."
	Values were inserted as strings. The OfficeWriter renderers now access the original value in order to preserve the underlying data type.

Differences Between V3.7.1 AND V3.8.1:

Excel Reporting | New Features:

	Copy and paste an area of cells from one worksheet into another with the new CopyPaste method. Current version can copy values, formatting, formulas, merged cells and comments. Additional features will be added in future versions.
	Check if a given cell is merged with the new IsMerged property of the Cell object.
	Unmerge cells with the new Unmerge method on the Cell object.
	Get the parent workbook of a given worksheet with the new Workbook property of the Worksheet object.

Excel Reporting | Issue Addressed:

	Autofilters not positioned correctly after changing column width.
	ExcelApplication threw exception: Cannot read past end of data buffer when attempting to open spreadsheet created with POI containing named ranges.
	ExcelApplication threw exception: Error parsing Excel stream: unexpected token when attempting to open a particular file.
	Formatting applied programmatically to an empty cell got lost when value entered by end-user.
	Performance issue in .NET 2.0 when importing doubles and dates with ExcelTemplate object.
	Certain spreadsheets generated with ExcelApplication did not open properly in OpenOffice and StarOffice.
	Excel 2000 crashed when hitting left navigation arrow on spreadsheet which was generated by setting any worksheet’s visibility to hidden before a call to Worksheet.Select().
	ExcelApplication .NET failed to open workbook generated by ExcelApplication COM.
	AutoFitWidth threw an InvalidOperationException in a multi-threaded environment.
	Added ability to open and manipulate spreadsheets generated by Reporting Services "out of the box" Excel export option.
	Chart in ExcelWriter-generated workbook altered when another MS Excel file is open on the client machine.
	Embedded xls files were not preserved when opening spreadsheet with ExcelApplication.
	Accessing PopulatedCells property caused file size to increase

Word Reporting | Issue Addressed:

	In .NET 2.0, attempting to insert a JPG with the WordTemplate object failed with the error: "Mismatching types for source and destination arrays"
	In .NET 2.0, performance problems when reading text from a document with the WordApplication object
	InsertTextAfter method didn't work properly for new rows created with Table.InsertRows
	Merge field syntax error (`Error parsing datamarker') received even though the merge field was already corrected. Caused by hidden change information stored in the Word file. WordTemplate now ignores mergefield strings which cannot be parsed
	Improved handling of ordinal modifier in merge fields
	MS Word 2000 threw error when cursor hovered over button in document generated by WordTemplate
	IndexOutOfBoundsException when merging certain documents with WordApplication.
	Default style of generated document was Header instead of Normal
	NumColumns property did not handle tables whose rows contain variable numbers of columns. Removed property Table.NumColumns and replaced it with a method that takes the row as a parameter - Table.GetNumColumns(row). Note: This causes a backwards compatability issue between 3.8.1 and previous versions. Learn more: http://support.softartisans.com/kbview.aspx?ID=1232

Differences Between V3.6.1 AND V3.7.1:

Excel Reporting | Issue Addressed:

	Excel throws "Data may have been lost" error when opening file generated by ExcelApplication. Caused by incorrect handling of shared formulas when opening existing spreadsheet
	Images in custom headers and footers not preserved
	Chart DataTable overlapped the chart area
	Excel throws "Method 'Range' of object '_Global' failed" error when opening certain spreadsheet which was processed by both the ExcelTemplate and ExcelApplication objects.
	"Exception during hydration" error when opening certain file created in Excel 2007.
	Some formatting lost when using ApplyStyle method on very large areas of cells
	ExcelApplication flipped cell foreground and background colors
	Error opening spreadsheet generated by POI library which did not conform to Excel specification
	ExcelTemplate did not stretch data validation region correctly
	Charts created with ExcelApplication varied in size depending on number of series added
	CreateHyperlink method did not work properly in version 6.6.1

Excel Reporting | New Features:

	Bulk row insertion and deletion are now possible with new InsertRows and DeleteRows methods. Dramatically improves performance over row-by-row insertion and deletion.
	Added properties for setting the position of a chart’s Data Table: X, Y, Width, and Height
	Added IgnoreNulls property to the DataImportProperties object. If set to true, NULL values in the data set are ignored and formulas and values in the input file will not be overwritten
	Added support for ADOMD data reader as a data source

Word Reporting | Issue Addressed:

	Rows not lined up correctly in tables inserted with WordApplication object
	Mergefield.GetFieldName threw exception or did not return correct merge field name
	WordApplication.Open did not explicitly release the handle on the input stream
	Error occured when opening document containing text boxes
	Corrupt output file generated from certain complex template containing many images
	WordTemplate did not preserve "ordinal" formatting modifier of merge fields
	SetWatermark didn't work properly in version 3.6.1

Reporting Services Integration |Issues Addressed:

	OfficeWriter Designer installer did not detect Office 2007
	An error when viewing report was created by OfficeWriter Designer in Office 2007
	The Publish Button did not work after template converted to Office 2007

Differences Between V3.5.4 AND V3.6.1:

Excel Reporting | Issues Addressed:

	STDEV formula did not accept cell ranges
	Certain ValueAxis properties could not be read or written
	Conditional formatting added through the API had no effect when running .NET 2.0
	Unable to read or write the Text or Href properties of an existing Hyperlink
	Data shifted incorrectly when deleting column in spreadsheet with frozen pane
	Frozen pane shifted incorrectly when deleting or inserting rows/columns to the right or above the frozen pane
	Error on ExcelApplication.Open() with certain spreadsheets: "Exception during hydration; Error parsing MsoDrawing stream"
	Error on ExcelApplication.Open() with certain spreadsheets: "Object reference not set to an instance of an object"
	Corrupt output file when processing certain spreadsheets with ExcelApplication
	Error "Index not supported for the type Row [or Column] Resized" when setting RowProperties or ColumnProperties
	Out of memory error when processing template created with Japanese Excel
	Hyperlink referencing the same workbook was not being preserved correctly
	Error "Postion X out of range; must be 0 <= position < X" When copying worksheet multiple times
	Named range offset incorrect when inserting/deleting rows/columns
	Image protection lost when opening and saving a spreadsheet with ExcelWriter COM
	Incorrect version number in type library description for ExcelWriter COM
	Buffer overrun in ExcelWriter COM'
	ExcelApplication .NET failed to open certain spreadsheets which were generated by ExcelWriter COM

Differences Between V3.5.3 AND V3.5.4:

Excel Reporting | Issues Addressed:

	Unicode strings in page header/footer were not handled properly, causing error: "Page footer exceeds 124 characters"
	Error: "Cannot read past end of data buffer." when opening spreadsheet containing data validation with error alert
	Hyperlinked area not stretched when row/column inserted
	Error "Unsupported error string" when reading certain cell values
	Formulas with references to named ranges were corrupted when opening/saving workbook
	Error opening workbook with formulas containing arrays of values
	Freeze Panes not updated when row/column inserted
	Deleting worksheets, columns or rows in workbook containing named ranges caused error: "Postion n out of range; must be 0 <= position < n"

Word Reporting | Issues Addressed:

	SetPageOrientation property did not work correctly
	Formatting was not applied properly to non-ascii characters
	Files created from templates containing certain Word 2003 features could be opened but not saved in Microsoft Word
	MergeField.GetFieldName() generated error or returned extra characters
	WordTemplate.Save streaming option failed in ASP on machine with .NET 2.0 installed

Differences Between V3.5.2 AND V3.5.3:

Excel Reporting | Issue Addressed:

	Workbook.ReadOnly property had no effect
	File Corruption issue introduced in 6.5 release of ExcelApplication COM (SAXLW6COM.dll)
	Adding hyperlinks with CreateHyperlink() caused virtual memory problem on client machine
	Hyperlinks not inserted correctly into newly created Worksheets
	Problem passing spreadsheets between ExcelApplication and ExcelTemplate: Dynamically-created Worksheets not bound to data.
	Error parsing formula: "=MOD(ROW(),2)=0"
	Performance problem reintroduced in 3.5.2 when processing spreadsheets with many named ranges
	Certain decimal values were truncated when reading from an existing spreadsheet using Cell.Value
	NullPointerException error when opening certain spreadsheets with ExcelApplication
	Error opening spreadsheets containing references to external Workbooks

Differences Between V3.5.1 AND V3.5.2:

Excel Reporting | Issue Addressed:

	Error opening certain spreadsheets: "Unable to parse formula: Column references must be between 1 and 256 and cannot loop"
	SeriesCollection.CreateSeries(Area) throws parse error in r1c1 mode
	Area.GetDimensions() unaffected by Workbook.UseRCFormulaNotation property
	ExcelTemplate throws runtime error when template contains conditional formatting.
	ExcelApplication throws exception when opening a file with multiple passwords
	Formulas with local names corrupted when worksheets deleted with ExcelApplication
	Inconsistent default values when setting only one dimension using FitToPagesWide and FitToPagesTall properties
	Named ranges not updated by row/column insertion or deletion