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

• 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
  

• 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 the PreserveStrings property in ExcelWriter when using OfficeWriter in Reporting Services.
    The following key must be added to web.config to turn on this setting:
    <appSettings>
    <add key="PreserveStrings" value="True" />
    </appSettings>
    

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

Issues 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.
• ColumnProperties.AutoFitWidth threw exception on column containing formula with currency formatting
• 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
• 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
  

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

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

New Features:

• Bulk row insertion and deletion are now possible with new InsertRows and DeleteRows methods. Dramatically improves performance compared to 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 & values in the input file will not be overwritten
• Added support for ADOMD DataReader as a data source

Issues Addressed:

• Excel throws “data may have been lost” error when opening file generated by ExcelApplication
• Images in custom headers and footers are 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 is thrown when opening certain files created in Excel 2007
• Some formatting is lost when using ApplyStyle method on very large areas of cells
• ExcelApplication flipped cell foreground and background colors
• An error occurs when opening spreadsheets generated by POI library which did not conform to Excel specification
• ExcelTemplate did not stretch data validation region correctly
• Charts created with ExcelApplication vary in size depending on number of series added
• CreateHyperlink method did not work properly in version 6.6.1

Issues Addressed with SQL Server Reporting Services

• 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
  

New Features:

• Charts: CategoryAxis can now take a date type - new enum, TimeUnit.
• Formulas: Added support for MEDIAN function
• Added AllowPartiallyTrustedCallersAttribute to the ExcelWriter .NET assembly so that it can be called from partially trusted code

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
• When attempting to install OfficeWriter Reporting Services integration, Installer fails to detect Reporting Services installation
  

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”
  

Issues Addressed:

• Workbook.ReadOnly property had no effect
• A File Corruption issue was introduced in 6.5 release of ExcelApplication COM (SAXLW6COM.dll)
• Adding hyperlinks with CreateHyperlink() caused virtual memory problem on client machine
• Hyperlinks were 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 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 occurred when opening certain spreadsheets with ExcelApplication
• Error occurred opening spreadsheets containing references to external Workbooks
  

Issues 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.setUseRCFormulaNotation(true)
• ExcelTemplate throws runtime error when template contains conditional formatting
• ExcelApplication throws exception when opening a file with multiple passwords
• Formulas with local names are corrupted when worksheets deleted with ExcelApplication
• Inconsistent default values occur when setting only one dimension using setFitToPagesWide and setFitToPagesTall
• Named ranges are not updated by row/column insertion or deletion
  

Issues Addressed:

Windows® Version

• Automatic installation of Reporting Services Integration fails for SQL Server 2000
• Publishing of "SoftArtisans" samples aborts on attempt to install "Excel-Product Sales 2005"
  

New Features:

• Support for .NET 2.0
• Set conditional formatting programatically with the new ConditionalFormat object
• Set data validation programmatically with the new DataValidation object
• ExcelTemplate object now takes collections as a DataSource
• Preserve data marker modifier tells ExcelTemplate to always insert strings as strings and not try to convert them to a number. Useful for preserving strings at the column level.
• Convert data marker modifier tells ExcelTemplate to always try to convert a string value to a number
• Support for R1C1 notation
• FirstPageNumberAuto property for automatic page numbering

Issues Addressed:

• DeleteRow() caused formula corruption
• Error generated when setting CenterHeader and CenterFooter
• Error when calling MergeCells() multiple times after setting a border
• Error when calling Area.AutoFitWidth()
• Could not change font color on Y-Axis of a chart
• Formula parser does not handle escaped single quotes correctly
• (ExcelWriter COM only) Setting Range.Value caused loss of formatting in other parts of a worksheet

New Features:

• CategoryAxis.TextRotationAngle now allows you to set the rotation angle of text on a chart's category axis
• Formula support is available for positive unary operator
• The performance of the ExcelTemplate object has been improved

Issues Addressed:

• Setting the color of a chart's major and minor gridlines had no effect
• Setting chart data label fonts had no effect
• Chart references were not updated after Worksheets.CopySheet
• Worksheet-level named ranges were corrupted after Worksheets.CopySheet
• Worksheet-level named ranges were not updated when a worksheet was deleted
• Calling ApplyStyle with a named style set cell-fill color to black
• Worksheet-level named ranges disappeared in files opened and saved with ExcelApplication
• Formulas with quoted worksheet names were truncated
• INDEX and MATCH functions were handled improperly
• Performance issue occurred when manipulating spreadsheets with many named ranges
• Web queries disappeared from files opened with ExcelApplication
• Deleting rows from adjacent ranges produced a Range with a negative number of rows
• In some cases, ExcelTemplate failed to preserve conditional formatting
• An error occured when saving a workbook after using ApplyStyle

New Features:

• The ApplyStyle method can now accept user-defined named styles from an existing workbook, as well as styles defined through the ExcelWriter API
• A merged cell that contains data markers will be repeated - rather than stretched - when the data markers are populated
• Page breaks are pushed down when new data markers are inserted and populated

New Feature:

Windows® Version

• New ExcelTemplate.SetRowDataSource methods allow you to use a DataView, DataSet, or DataTable as a data source for a row

New Feature:

Java™ Version

• New ExcelTemplate.SetRowDataSource methods allow you to use a ResultSet as a data source for a row

Issues Addressed:

• Named objects and ranges did not observe grid events. For example, when a row or column was inserted or deleted, named ranges were not updated to reflect the grid change
• Various problems with the CopySheet method
• Error when using named ranges in formulas
• Complex formulas throw formula parser exception
• Named ranges are now indexed correctly
• Unable to change the color of a Chart Title
• Issue with pivot tables created with COM ExcelApplication object when opened in Excel 2000 only - missing dropdowns for PageFields and incorrect image placement
• File size optimization issue with ExcelApplication object (pure .NET and Java™)

New Features:

• ExcelApplication now allows you to insert currency symbols
• New in Documentation:Tutorial on working with PivotTables

Issues Addressed:

• ExcelApplication's formula parser now interprets nested functions with cell reference arguments
• ColumnProperties.autoFitWidth works correctly
• Formulas using the SUMPRODUCT function that were added with ExcelApplication now calculate when the workbook is opened in Excel
• The spreadsheet's footer appears correctly when horizontal page breaks are inserted

• Pure .NET Application Object
  • No dependency on COM; no need to register DLLs
  • Run different versions side-by-side
• Refactored API/Object Model - More intuitive and straightforward
  • Conforms to platform expectations
  • Properties, enumerations, indexers on .NET
• Complete API for charting
  • Manipulate existing charts created in Excel
  • Create or modify any type of Excel chart
  • Remove unwanted charts
  • More customization than is possible through Excel
• Create, modify, and delete visual Excel features, including:
  • Comments
  • Drawing objects and shapes
  • Images
• Insert and delete rows and columns
• Formula support for all built-in Excel functions
• Read formulas from an existing spreadsheet
• Support for 3D ranges
• Full control of the worksheets collection – insert, remove, reorder
• Layer styles or apply parts of styles to:
  • Cells
  • Areas
  • Ranges
  • Rows
  • Columns

New Features:

Windows® Version

• NA() function support. The NA function returns the error value #N/A when no value is available
• Support for array formulas in templates
• Vertical and horizontal scrollbars are now visible by default in spreadsheets generated by ExcelApplication

Issues Addressed:

Windows® Version

• Installer failed with 2005 system dates
• Memory leak with GetDataFromExcelSheet
• Degree symbols in templates were corrupted in the generated spreadsheet
• ExcelApplication object failed when processing some spreadsheets where the Normal style was formatted in Excel by the user
• In some cases, ExcelTemplate did not preserve French characters
• In Reporting Services edition, incorrect rendering extension names were displayed in Reporting Services Report Manager. "SA Word Template export filter" was replaced with "Word (.doc) designed by OfficeWriter" and "SA Excel Template export filter" was replaced with "Excel (.xls) designed by OfficeWriter."

Windows® Version

• Support for Microsoft SQL Server Reporting Services - included in Enterprise Edition and new Reporting Services Edition
• Ability to generate Pivot Table reports from code using PivotTable and PivotField objects

New Feature:

Windows® Version

• In the Desktop Edition only, the ExcelWriter COM Application and Template Objects are now marked "safe for scripting." This allows for the objects to be used within Internet Explorer

Issues Addressed:

Cross Platform

• When opening (with either the Template or COM Application object) a spreadsheet that was a) encrypted b) had workbook-level protection enabled and c) contained data validation fields, the generated spreadsheet caused Excel to crash
• Improved performance of the Template object for SQL MONEY fields

Windows® Version

• The COM interface definitions between the Desktop Edition and the Server Editions were not the same
• COM Interop wrapper referenced an earlier version of the COM Application Object. This resulted in various errors when using the Application Object from .NET

Windows® Version

• Added full char