Home     Products      Support      Corporate     Sign In 
OfficeWriter Version Differences
   
  Differences Between V8.0 AND V8.1:
  divider
  Excel Reporting | New Features:
  divider
 
bullet Axis.LinkedToSource and SeriesDataLabel.LinkedToSource for ExcelApplication
bullet Improved support for tables in OOXML files for ExcelApplication
   
  Excel Reporting | Issue Addressed:
  divider
 
Template Object
bullet No exception thrown when rows of imported data exceeds file format limit
bullet Cultures with different thousand separators cause corrupt output in OOXML files
bullet Rows pushed down when using pivot tables in OOXML files
   
 
Application Object
bullet Getting a data label for a data point puts x-axis values in chart legend
bullet Deleting a row with conditional formatting causes a file error in Excel 2007/2010
bullet Hyperlink.Href returns null value instead of a valid link
bullet Exception thrown if chart legend has a background fill
bullet SoftArtisans.OfficeWriter.ExcelWriter.XMLModel at index does not exist (OOXML)
bullet Unable to create hyperlinks in a merged area adjacent to another merged area (OOXML)
bullet UseRCFormulaNotation always returned false (OOXML)
   
  Word Reporting | New Features:
  divider
 
bullet Ability to unlink IF fields after they are evaluated by WordWriter (OOXML)
   
  Word Reporting | Issue Addressed:
  divider
 
bullet InsertRow takes the formatting from the first row of a table in WordApplication
bullet WordTemplate ‘Image’ modifier does not scale images correctly (OOXML)
   
  For Reporting Services | New Features:
  divider
 
bullet New skin for Office 2007/2010 ribbon in Excel and Word
bullet OfficeWriter Designer supports creating and viewing reports in Office 2010
bullet Full SQL Server Reporting Services 2012 support
   
  For Reporting Services | Issue Addressed:
  divider
 
bullet Designer in Excel hangs when previewing reports after changing multiple parameter values
   
   
  Differences Between V4.6.1 AND V8.0:
  divider
  Excel Reporting | New Features:
  divider
 
bullet Complete support for Excel 2007/2010 (XLSX) file formats with ExcelApplication
bullet Redesigned installer
   
  Excel Reporting | Issue Addressed:
  divider
 
bullet Deleting the last remaining worksheet in a Workbook throws an exception on call to Save instead of on Delete
bullet Passing a non-seekable Stream object to a method when creating a picture will throw an exception
bullet Merged cells next to data markers on adjacent rows causes corrupt output
bullet License Manager tool displays popup twice when upgrading OfficeWriter key
bullet ExcelWriter allowed setting of invalid font sizes, which resulted in warnings in Excel 2010
bullet Incorrect default character width ysed for default font
   
  Word Reporting | New Features:
  divider
 
bullet Ability to include arbitrary RTF or HTML documents in merge fields with WordTemplate
bullet Redesigned installer
   
  For Reporting Services | New Features:
  divider
 
bullet Redesigned installer
   
   
  Differences Between V4.6 AND V4.6.1:
  divider
  Excel Reporting | New Features:
  divider
 
bullet ExcelApplication is now 20% faster and requires 20% less memory
   
  Excel Reporting | Issue Addressed:
  divider
 
bullet Specific formula caused "Unreadable Content" error in XLSX file processed by ExcelTemplate in SSRS
bullet ExcelWriter would return the wrong default character width for Calibri - size 11
bullet ExcelApplication threw an exception when parsing some SSRS 2008 generated Excel files
bullet Chart text was not properly set to "Automatic" by default
bullet Data Series in charts were sometimes not sequenced correctly
bullet GetHeader and GetFooter threw NullReferenceException when called on newly created worksheets
   
  Word Reporting
  divider
  There were no changes to WordWriter between 4.6 and 4.6.1.
   
  For Reporting Services | Issue Addressed:
  divider
 
bullet Specific formula caused "Unreadable Content" error in XLSX file processed by ExcelTemplate in SSRS
bullet Opening an RDL in the OfficeWriter Designer threw a "Type Mismatch" error with certain regional settings
   
   
  Differences Between V4.5.1 AND V4.6:
  divider
  Excel Reporting | New Features:
  divider
 
bullet 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
bullet Sparklines now preserved in Excel 2010 created file when processed by ExcelTemplate
bullet 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:
  divider
 
bullet ExcelTemplate threw an error on Excel 2010-created files with Excel 2003-format pivot tables
bullet Shapes such as charts stretched when placed next to pivot tables that were filled using ExcelTemplate
bullet ExcelWriter generated files no longer open in protected mode in Excel 2010
   
  Word Reporting |New Features:
  divider
 
bullet 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: divider
 
bullet Some files processed by WordTemplate, then WordApplication, caused errors when opened in Word 2010
bullet WordWriter threw an error when repeat blocks were in tables in templates created using Word 2010
   
  For Reporting Services | New Features:
  divider
 
bullet Reporting Services 2008 R2 formulas are now supported in OfficeWriter Reporting Services Integration for Word
bullet Reporting Services Designer nor supports Reporting Services 2008 formulas
   
  For Reporting Services | Issue Addressed:
  divider
 
bullet Reporting Services 2008 R2 formulas did not work in OfficeWriter Reporting Services integration for Word
bullet OfficeWriter Designer did not read Reporting Services 2008 formulas from the RDL files
   
   
  Differences Between V4.5 AND V4.5.1:
  divider
  Excel Reporting | New Features:
  divider
 
bullet ExcelWriter can now insert images into headers and footers using the new HeaderFooterPicture object.
bullet The new HeaderFooterSection object allows greater control over headers and footers
bullet The new ChartFillPattern class provides values for all Excel 2003 patterns
bullet 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:
  divider
 
bullet 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
bullet ExcelTemplate did not work with template files created in Excel 2010
bullet ExcelTemplate did not throw an error if file format limits on the number of characters in a cell were exceeded
bullet Processing certain files with comments using ExcelTemplate created a corrupt file
bullet Calling ExcelTemplate.Process() on files were certain formulas threw an "Unrecognizable symbol" exception.
bullet ExcelApplication did not throw an error if file format limits on the number of characters in a cell were exceeded.
bullet Horizontal page breaks could not be inserted on worksheets created using Worksheets.CopySheet
bullet PageSetup attributes were not applied to worksheets created using Worksheets.CopySheet
bullet Merging some spreadsheets created using Crystal Reports resulted in a corrupt workbook.
bullet License Key Manager threw error when being run on a machine with no SoftArtisans license keys in the registry.
bullet 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
bullet ColumnProperties.AutoFitWidth() entered an infinite loop on columns with certain NumberFormat settings
bullet Cell.Formula threw an exception when attempting to read a formula referencing an external workbook using VLookup
bullet Some files generated with ExcelTemplate created corrupt files when opened and saved in ExcelApplication
   
  Word Reporting | Issue Addressed:
  divider
 
bullet WordTemplate created a corrupted file when processing two IF fields
bullet WordTemplate threw an exception or produced a corrupt file when processing a template with IF fields containing other fields
bullet Merging a document with a programmatically-created table into another document threw an index out of bounds exception
bullet After replacing an object in a header or footer using Element.SearchAndReplace, the next call to SearchAndReplace() threw a WordWriterException
bullet Watermark object can now access watermarks in input files
bullet Watermark was not able to insert new watermarks
bullet Setting some table styles using WordApplication caused formatting issues and corrupted tables
bullet Merging two documents using Document.Append caused corrupted output in some cases
bullet Opening and saving a file created using a non-English version of Word caused formatting issues
bullet License Key Manager threw error when being run on a machine with no SoftArtisans license keys in the registry.
   
  For Reporting Services | New Features:
  divider
 
bullet OfficeWriter Designer now supports reports built using Report Builder 3.0
bullet OfficeWriter Designer now supports Excel 2010
   
  ExcelWriter COM | Issue Addressed:
  divider
 
bullet 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:
  divider
  Excel Reporting | New Features:
  divider
 
bullet 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:
  divider
 
bullet 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
bullet 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
bullet 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
bullet 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
bullet Shape.FillTransparency no longer inverts its value
bullet Cell values on sheets created using Worksheets.CopySheet no longer reference incorrect values
bullet Calling ColumnProperties.AutoFitWidth() on a column with a custom NumberFormat no longer causes an Out of Memory exception
bullet R1C1-style formulas no longer cause an "Unable to parse formula" exception
bullet ExcelWriter COM uses memory more efficiently than did ExcelWriter COM version 7.0 and 7.1, reducing server instability
bullet 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:
 
bullet 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
bullet New WordTemplate.SaveExtension property returns the extension of the template file that has been opened
bullet New Document.Append method appends one Document to another, preserving all Sections, including header and footers plus other section formatting
bullet WordWriter now supports Grouping and Nesting with the WordTemplate object
   
   
  Word Reporting | Issue Addressed:
 
bullet 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)
bullet Deleting table rows containing merge fields within a bookmark no longer damages the bookmark, allowing the template to populate without corrupting the output document
bullet Binding an empty DataTable to a template using WordTemplate.SetRepeatBlock no longer throws an exception, but instead removes bookmark
bullet Inserting content into a header with field no longer causes a corrupt document
bullet Custom styles preserved when two Document objects are merged using the Document.InsertAfter method
bullet Word documents with images with text wrapping settings other than "Inline with Text" no longer corrupted when opened and saved using WordApplication
bullet 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:
  divider
  Excel Reporting | New Features:
  divider
 
bullet ExcelTemplate can process files created with Microsoft's Open Office XML (OOXML) SDK
bullet Nesting and grouping formatting enabled for OOXML files. For more information, see Creating Data Markers
   
   
  Excel Reporting | Issue Addressed:
  divider
 
bullet 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
bullet 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
bullet ExcelWriter did not process three-letter columns correctly when referencing cells, for example "AAA4"
bullet AutoFitWidth threw IndexOutOfBounds exception for column with formula formatted as number
bullet Calling ApplyStyle() or SetStyle() on a ColumnProperties object referencing a column with a formula in it threw an Object Reference exception
bullet Setting CharacterRun.Font properties for more than 586 cells corrupted the file
bullet Setting CORREL function with Application object displayed "#VALUE" until user clicked on the cell
bullet ExcelTemplate.ExcludeMacros property now available when working with OOXML files
bullet Strings that looked like data markers after a formula is evaluated were treated like data markers
bullet 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:
  divider
 
bullet WordTemplate can evaluate formulas. For more information, see Creating Merge Fields
   
   
  Word Reporting | Issue Addressed:
  divider
 
bullet Deleting an element in a table made in Word 2007 corrupted the output document in some cases
bullet Deleting a row in a table also deleted the value in the first cell of the next row
bullet In some cases documents with embedded images threw Out of Memory exceptions
bullet Calling Document.Search() on a document with an empty field threw a stack overflow exception
bullet Inserting many images with WordTemplate caused some images not to display
   
   
  Reporting Services Integration |Issue Addressed:
  divider
 
bullet OfficeWriter Designer threw an error when attempting to publish a 2008 RDL with a Report Global embedded using the Insert Formula button
bullet OfficeWriter Designer threw data source exception when a query was associated with a row in a table in a Word Document
bullet OfficeWriter Designer did not allow exporting Excel 2007 files with macros as RDLs
bullet 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:
  divider
  Excel Reporting | New Features:
  divider
 
bullet 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
bullet Office 2007 templates in Excel and Word
bullet It is now possible to iterate over all of the named ranges in a worksheet or workbook.
bullet New property Shape.FillTransparency added, which takes a real number from 0 (opaque) to 1 (transparent).
bullet It is now possible to bind data only to an individual worksheet using the new DataBindingProperties object in ExcelTemplate
bullet 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.
bullet All re-written in C#. No more dependency on J# run-time
bullet Support for Unicode Data Markers
bullet New GetTextHeight() and GetTextWidth() methods to assist with autofitting merged cells
bullet New InsertRows() and InsertColumns() methods for bulk insertion of rows and columns
bullet 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:
  divider
 
bullet 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
bullet Office 2007 templates in Excel and Word
bullet All re-written in C#. No more dependency on J# run-time
bullet IF field evaluation
bullet Processing large binary Word files is up to 6 times faster with WordApplication and 35% faster with WordTemplate
bullet Processing large files or importing data with WordTemplate uses 40 times less memory with OOXML files (.docx and .docm)
bullet HTMLtoWord (new open source project for importing HTML-formatted text into WordWriter documents)
bullet Generate mailing labels easily with the new EnableNextFields property
bullet Use the new SetMailMerge() method to perform mail merges that closely match Microsoft Word mail merge functionality.
   
   
  Reporting Services Integration | New Features:
  divider
 
bullet Office 2007
Now has support for Office 2007 OpenXML files with .xlsx, .xlsm, docx or docm extensions
bullet 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.
bullet Full Support for Visual Studio 2008
OfficeWriter Reporting Services integration now supports RDLs edited in Visual Studio 2008
bullet 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
bullet 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.
bullet Support for Report Model data sources and Report Builder 2.0
bullet Enabling of Office Writer for Reporting Services properties from the web.config file of the report server application
bullet Improved support for images
Our Word designer now provides the ability to insert images
bullet Shared DataSource support
Shared DataSources are now preserved when publishing the report from OfficeWriter Designer
bullet 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:
divider
  Excel Reporting | New Features:
  divider
 
bullet ExcelTemplate now supports unicode characters in data markers. Field names with unicode characters must be within square brackets
   
  Excel Reporting | Issue Addressed:
  divider
 
bullet Setting MaxRows to 65535 caused file corruption
bullet ExcelTemplate lost an hour in certain timezones with daylight savings time
bullet ExcelTemplate Process method failed, throwing an object reference error, in certain applications with multiple SetDataSource calls
bullet AutoFitWidth did not work in destination worksheet after calling CopyPaste method
bullet 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
bullet ChartHeight property did not work in versions 6.8.1 and 6.9.1
bullet VLOOKUP formula inserted with ExcelApplication did not behave correctly in Excel 2003
bullet Error "Failed to get value of cell..." when attempting to retrieve the value of a cell containing a hyperlink with ExcelApplication
bullet Array formulas not preserved when processed with ExcelTemplate
   
   
  Word Reporting | New Features:
  divider
 
bullet WordTemplate can now evaluate IF fields on the server using the new UpdateIfFields property
   
  Word Reporting | Issue Addressed:
  divider
 
bullet Merged documents containing shapes and floating images caused Word to crash
bullet Section formatting was not preserved properly in merged documents
bullet Table formatting was not preserved properly in merged documents
bullet Some merged documents had incorrect font formatting
bullet Watermark inserted with WordApplication did not take effect
bullet Accessing headers/footers in a document with multiple sections removed existing header/footer content
   
  Reporting Services Integration | New Features:
  divider
 
bullet Support for SQL 2008
bullet Support for RDL generated in Visual Studio 2008 and Report Builder 2.0
bullet Support for Reporting Services in SharePoint integration mode. See this KB article: http://support.softartisans.com/kbview.aspx?ID=1278
bullet Support for Forms Authentication
bullet Support for Report Model data sources
bullet 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:
  divider
 
bullet 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:
divider
  Excel Reporting | New Features:
  divider
 
bullet 64-bit support
bullet IIS 7.0 support
bullet Faster algorithm for style optimization in ExcelApplication
bullet Improved performance when opening existing files with ExcelApplication
bullet Improved performance when setting column width
bullet Reduced memory usage by ExcelTemplate
bullet Optimized performance of ExcelApplication’s formula parser. Formulas can now be inserted up to 8 times faster.
bullet Blank cell optimizations produce up to 400% improvement in speed and memory usage when using ExcelTemplate together with ExcelApplication
bullet Improved autofit algorithm
bullet New methods added to assist with autofitting merged cells: GetTextHeight and GetTextWidth
bullet New InsertColumns and InsertRows methods for bulk insertion of columns/rows
   
  Excel Reporting | Issue Addressed:
  divider
 
bullet 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.
bullet ExcelApplication .NET unable to open certain files created by COM version of ExcelWriter.
bullet Issue with ExcelApplication COM version when using Style.Number and Cells.MergeCells in combination.
bullet Issue with Daylight Savings Time
bullet ExcelApplication unable to open spreadsheet generated by SSRS default Excel renderer.
bullet Calling the DeleteColumn method on a worksheet with a horizontal freeze pane caused Excel to crash when opening the generated file.
bullet 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
bullet Unhandled exception in ExcelApplication COM caused message box
bullet Importing certain types of JPGs caused exception "Index was outside the bounds of the array"
bullet File corruption when generating encrypted workbooks with Pivot Tables
bullet ExcelApplication.Open threw exception "Error parsing Excel stream: unexpected token: PROTECT" with certain files
bullet Opening and saving certain Excelwriter COM-generated spreadsheets with ExcelWriter .NET caused file corruption.
bullet Numbers exceeding Excel's limit of 15 digits were being rounded up rather than truncated. ExcelWriter's behavior now matches MS Excel's.
bullet "Unsupported Function" error when opening spreadsheet with DateDif function.
bullet Excel crashed when changing font in OfficeWriter-generated spreadsheet containing character runs
bullet CopySheet did not copy local named ranges correctly (this also affected print titles)
bullet Error "Failed to get Style inteface; Failed to create new CellStyleModel" when calling ApplyStyle method
bullet Error "Value was either too large or too small for a Decimal" when autofitting an area containg NaN double values
bullet Creating spreadsheet with over 40 worksheets and applying many styles caused error "Failed to get Style interface"
bullet In version 6.8.1, SetCellDataSource converted certain strings to numbers
bullet ColumnProperties.AutoFitWidth threw exception when column contained formulas with currency formatting
bullet Calling Worksheet.DeleteColumn()" on a worksheet with freezepanes caused Excel to crash when opening output file
bullet Error accessing cell value in spreadsheet generated by SSRS generic Excel renderer
bullet Password-protected workbook generated by ExcelWriter version 6.8.1 did not prompt user for password when opened
bullet Errors calling ApplyStyle or AutoFitWidth on large areas
bullet PlotArea and Legend were not centered in generated file
   
   
  Word Reporting | New Features:
  divider
 
bullet 64-bit support
bullet IIS 7.0 support
bullet HtmlToWord - New open source project for importing HTML-formatted text into WordWriter documents
bullet Improved generation of mailing labels with new EnableNextFields property
bullet 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:
  divider
 
bullet Document properties NumCharacters, NumWords and NumParagraphs incorrectly returned 0.
bullet Table.AddRows and Table.InsertRows shifted cells to the right
bullet Row inserted in nested table had incorrect formatting
bullet Inserting tables into table cells sometimes caused corrupt documents
bullet Table inserted in table cell was too wide
bullet Lists and paragraphs inserted into existing table cells sometimes resulted in incorrect formatting or corrupted files
bullet Some elements inserted after a table appeared as if inside a table cell.
bullet Adding a watermark to a document caused corruption of character formatting and tables
bullet Documents created with certain fonts threw an exception. WordWriter now supports more font types
bullet Calling hyperlink.GetUrlString() on an existing hyperlink in a Word document caused an exception
bullet Adding a watermark caused corruption of character formatting and tables
bullet Adding watermark to certain files caused NullPointerException
bullet Footnotes were not preserved when copying one document into another
bullet Header and footer missing after opening and saving a document with an image in the header with WordApplication
bullet Daylight Savings Time issue with .NET 2.0 on Windows 2003
   
  Reporting Services Integration | New Features:
  divider
 
bullet 64-bit support
bullet 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.
bullet Ability to insert images with Word designer
   
  Reporting Services Integration | Issue Addressed:
  divider
 
bullet Shared DataSources are now preserved when publishing report from OfficeWriter Designer.
bullet 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."
bullet 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:
divider
  Excel Reporting | New Features:
  divider
 
bullet 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.
bullet Check if a given cell is merged with the new IsMerged property of the Cell object.
bullet Unmerge cells with the new Unmerge method on the Cell object.
bullet Get the parent workbook of a given worksheet with the new Workbook property of the Worksheet object.
   
  Excel Reporting | Issue Addressed:
  divider
 
bullet Autofilters not positioned correctly after changing column width.
bullet ExcelApplication threw exception: Cannot read past end of data buffer when attempting to open spreadsheet created with POI containing named ranges.
bullet ExcelApplication threw exception: Error parsing Excel stream: unexpected token when attempting to open a particular file.
bullet Formatting applied programmatically to an empty cell got lost when value entered by end-user.
bullet Performance issue in .NET 2.0 when importing doubles and dates with ExcelTemplate object.
bullet Certain spreadsheets generated with ExcelApplication did not open properly in OpenOffice and StarOffice.
bullet 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().
bullet ExcelApplication .NET failed to open workbook generated by ExcelApplication COM.
bullet AutoFitWidth threw an InvalidOperationException in a multi-threaded environment.
bullet Added ability to open and manipulate spreadsheets generated by Reporting Services "out of the box" Excel export option.
bullet Chart in ExcelWriter-generated workbook altered when another MS Excel file is open on the client machine.
bullet Embedded xls files were not preserved when opening spreadsheet with ExcelApplication.
bullet Accessing PopulatedCells property caused file size to increase
   
   
  Word Reporting | Issue Addressed:
  divider
 
bullet In .NET 2.0, attempting to insert a JPG with the WordTemplate object failed with the error: "Mismatching types for source and destination arrays"
bullet In .NET 2.0, performance problems when reading text from a document with the WordApplication object
bullet InsertTextAfter method didn't work properly for new rows created with Table.InsertRows
bullet 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
bullet Improved handling of ordinal modifier in merge fields
bullet MS Word 2000 threw error when cursor hovered over button in document generated by WordTemplate
bullet IndexOutOfBoundsException when merging certain documents with WordApplication.
bullet Default style of generated document was Header instead of Normal
bullet 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:
divider
  Excel Reporting | Issue Addressed:
  divider
 
bullet 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
bullet Images in custom headers and footers not preserved
bullet Chart DataTable overlapped the chart area
bullet Excel throws "Method 'Range' of object '_Global' failed" error when opening certain spreadsheet which was processed by both the ExcelTemplate and ExcelApplication objects.
bullet "Exception during hydration" error when opening certain file created in Excel 2007.
bullet Some formatting lost when using ApplyStyle method on very large areas of cells
bullet ExcelApplication flipped cell foreground and background colors
bullet Error opening spreadsheet generated by POI library which did not conform to Excel specification
bullet ExcelTemplate did not stretch data validation region correctly
bullet Charts created with ExcelApplication varied in size depending on number of series added
bullet CreateHyperlink method did not work properly in version 6.6.1
   
  Excel Reporting | New Features:
  divider
 
bullet Bulk row insertion and deletion are now possible with new InsertRows and DeleteRows methods. Dramatically improves performance over row-by-row insertion and deletion.
bullet Added properties for setting the position of a chart’s Data Table: X, Y, Width, and Height
bullet 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
bullet Added support for ADOMD data reader as a data source
   
   
  Word Reporting | Issue Addressed:
  divider
 
bullet Rows not lined up correctly in tables inserted with WordApplication object
bullet Mergefield.GetFieldName threw exception or did not return correct merge field name
bullet WordApplication.Open did not explicitly release the handle on the input stream
bullet Error occured when opening document containing text boxes
bullet Corrupt output file generated from certain complex template containing many images
bullet WordTemplate did not preserve "ordinal" formatting modifier of merge fields
bullet SetWatermark didn't work properly in version 3.6.1
   
  Reporting Services Integration |Issues Addressed:
  divider
 
bullet OfficeWriter Designer installer did not detect Office 2007
bullet An error when viewing report was created by OfficeWriter Designer in Office 2007
bullet The Publish Button did not work after template converted to Office 2007
   
   
   
 
Differences Between V3.5.4 AND V3.6.1:
divider
  Excel Reporting | Issues Addressed:
  divider
 
bullet STDEV formula did not accept cell ranges
bullet Certain ValueAxis properties could not be read or written
bullet Conditional formatting added through the API had no effect when running .NET 2.0
bullet Unable to read or write the Text or Href properties of an existing Hyperlink
bullet Data shifted incorrectly when deleting column in spreadsheet with frozen pane
bullet Frozen pane shifted incorrectly when deleting or inserting rows/columns to the right or above the frozen pane
bullet Error on ExcelApplication.Open() with certain spreadsheets: "Exception during hydration; Error parsing MsoDrawing stream"
bullet Error on ExcelApplication.Open() with certain spreadsheets: "Object reference not set to an instance of an object"
bullet Corrupt output file when processing certain spreadsheets with ExcelApplication
bullet Error "Index not supported for the type Row [or Column] Resized" when setting RowProperties or ColumnProperties
bullet Out of memory error when processing template created with Japanese Excel
bullet Hyperlink referencing the same workbook was not being preserved correctly
bullet Error "Postion X out of range; must be 0 <= position < X" When copying worksheet multiple times
bullet Named range offset incorrect when inserting/deleting rows/columns
bullet Image protection lost when opening and saving a spreadsheet with ExcelWriter COM
bullet Incorrect version number in type library description for ExcelWriter COM
bullet Buffer overrun in ExcelWriter COM'
bullet ExcelApplication .NET failed to open certain spreadsheets which were generated by ExcelWriter COM
   
   
   
 
Differences Between V3.5.3 AND V3.5.4:
divider
  Excel Reporting | Issues Addressed:
  divider
 
bullet Unicode strings in page header/footer were not handled properly, causing error: "Page footer exceeds 124 characters"
bullet Error: "Cannot read past end of data buffer." when opening spreadsheet containing data validation with error alert
bullet Hyperlinked area not stretched when row/column inserted
bullet Error "Unsupported error string" when reading certain cell values
bullet Formulas with references to named ranges were corrupted when opening/saving workbook
bullet Error opening workbook with formulas containing arrays of values
bullet Freeze Panes not updated when row/column inserted
bullet 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:
  divider
 
bullet SetPageOrientation property did not work correctly
bullet Formatting was not applied properly to non-ascii characters
bullet Files created from templates containing certain Word 2003 features could be opened but not saved in Microsoft Word
bullet MergeField.GetFieldName() generated error or returned extra characters
bullet WordTemplate.Save streaming option failed in ASP on machine with .NET 2.0 installed
   
   
   
 
Differences Between V3.5.2 AND V3.5.3:
divider
  Excel Reporting | Issue Addressed:
  divider
 
bullet Workbook.ReadOnly property had no effect
bullet File Corruption issue introduced in 6.5 release of ExcelApplication COM (SAXLW6COM.dll)
bullet Adding hyperlinks with CreateHyperlink() caused virtual memory problem on client machine
bullet Hyperlinks not inserted correctly into newly created Worksheets
bullet Problem passing spreadsheets between ExcelApplication and ExcelTemplate: Dynamically-created Worksheets not bound to data.
bullet Error parsing formula: "=MOD(ROW(),2)=0"
bullet Performance problem reintroduced in 3.5.2 when processing spreadsheets with many named ranges
bullet Certain decimal values were truncated when reading from an existing spreadsheet using Cell.Value
bullet NullPointerException error when opening certain spreadsheets with ExcelApplication
bullet Error opening spreadsheets containing references to external Workbooks
   
   
   
 
Differences Between V3.5.1 AND V3.5.2:
divider
  Excel Reporting | Issue Addressed:
  divider
 
bullet Error opening certain spreadsheets: "Unable to parse formula: Column references must be between 1 and 256 and cannot loop"
bullet SeriesCollection.CreateSeries(Area) throws parse error in r1c1 mode
bullet Area.GetDimensions() unaffected by Workbook.UseRCFormulaNotation property
bullet ExcelTemplate throws runtime error when template contains conditional formatting.
bullet ExcelApplication throws exception when opening a file with multiple passwords
bullet Formulas with local names corrupted when worksheets deleted with ExcelApplication
bullet Inconsistent default values when setting only one dimension using FitToPagesWide and FitToPagesTall properties
bullet Named ranges not updated by row/column insertion or deletion
   
   
  Word Reporting | Issue Addressed:
  divider
 
bullet Changed method signatures for SetDataSource and SetRepeatBlock
  Removed overloads for IEnumerable
  Added overloads for IEnumerator and ICollections
   
   
  Reporting Services Integration | Issue Addressed:
  divider
 
bullet Automatic installation of Reporting Services Integration fails
   



Copyright 2010 © SoftArtisans, Inc. All Rights Reserved.

Site Map     |     Privacy Policy     |     Contact Us