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 character formatting support (cell format-runs). Cells can contain text with multiple fonts
• Added Worksheets.Remove(sheet) method, where sheet is either the name or the 1-based index.
• Added "Office 97/2000 Compatible" Encryption/Decryption to both the Application and Template objects. This is the default encryption used by Excel 97+. Two new properties were added to enable this.
• obj.DecryptPassword = "password" --must be set before the Open method
• obj.EncryptPassword = "password" --must be set before the Save and Process methods
• Added EMF image support to the picture object.
• Added new properties to the picture object, which enable the retrieval of an inserted image's dimensions relative to its lower-right row and column when using the Pictures.CreateFromFile2()
• Added several additional text orientation enumeration values used with the Style.Orientation property. There is now one for every 15 degrees

Windows® Version

• Picture was distorted and stretched when calling Pictures.CreateFromFile2() and the columns and rows under the picture were not the regular dimensions
• ColumnWidth values set between 0 and 1 didn't work as expected
• Very heavy server load was causing IIS to intermittently crash or hang
• AutoFitWidth incorrectly calculated column widths if the string value contained line breaks and wrap text was set to true
• GetDataFromExcelSheet did not always import strings correctly

Java™ Version

• Samples would not deploy properly to some application servers, notably WebSphere 5, due to ordering in the web.xml
• Conditional formatting was lost when applied to rows inserted inti the template
• The memory footprint has been reduced
• Dates inserted from a Java™ .util.Date Object did not account for daylight savings time
• Empty resultsets throw an exception when set as a datasource for FIELDNAME only datamarkers
• Pivot table drop-down boxes are not pushed down

Windows® Version

• Data range for pivot tables was not updated correctly
• Free version of Application to Template sample generates corrupted output file
• Exception thrown processing template file with auto calculation turned off

Java™ Version

• Some spreadsheets saved with manual calculation could not be used

New Features:

Cross Platform

• Added Cell.Copy method to ExcelWriter.Application object
• Added ShrinkToFit and Indent properties to SAStyle object

Issues Addressed:

Cross Platform

• In some cases a range of cells for the Pivot Table hasn't been stretched correctly
• Improved error messages
• Minor changes to the documentation and samples.

Cross Platform

• Handling of the dbNull fields
• Formula that has pre-calculated areas is causing an exception.
• Improved error messages
• ExcelWriterFree generated a corrupted file from template with only one sheet

Windows® Version

• Stretching of the data range in Pivot table
• Application to Template sample. Free version generated corrupted output file.
• Exception processing template files with auto calculation turned off Data range for pivot tables was not updated correctly

Windows® Version

• Pure .NET Template Object: New pure .NET ExcelTemplate object makes spreadsheet generation in ASP.NET even easier, and significantly improves the performance of ADO.NET data imports.
• ExcelApplication and ExcelTemplate Integration in .NET: ExcelWriter can easily pass a spreadsheet from ExcelApplication to ExcelTemplate and vice versa, allowing you to take advantage of the features in both objects.
• DocumentProperties Object: The DocumentProperties object allows you to set properties displayed on the generated file's Properties sheet in code.
• UsedRange Properties: Range.UsedRange and Cells.UsedRange return the range of used cells in a worksheet or a range of cells. This is useful if you want to apply formatting to populated cells, or assign cell values based on the location of used cells.
• BorderAround method: The BorderAround method creates a border around a range of cells. Select one of 13 border styles.
• New Chart Object Properties: SecondaryValueAxis and SecondaryCategoryAxis allow you to create and set properties for secondary value and category axes.
• New Series Object Properties: 5 new series object properties: AxisGroup, ChartType, ChartSubType, SpaceBetweenBars, and SpaceBetweenCategories.
• LockedFileRetry Registry Key: When an ExcelWriter script opens an existing spreadsheet, the spreadsheet is locked until the request is complete. To prevent failure of additional requests, ExcelWriter will retry a request that could not be processed because the spreadsheet was locked. The LockedFileRetry registry key allows you to change the length of the interval between retries.
• DataTable and DataReader support in .NET: ExcelWriter can now populate template spreadsheets from ADO.NET DataTables and DataReaders, in addition to DataSets.
• 29 New Math Functions: Acos, Asin, Atan, Atan2, Ceiling, Cos, Degrees, Even, Fact, Floor, Ln, Log, Log10, Pi, Product, Radians, Rounddown, Roundup, Sin, Sqrt, Tan, etc.
• Statistical functions: Mode, Percentile
• Date and time functions: DateValue, TimeValue, Days360
• Information functions: IsErr, IsError, Type
• Properties: LicenseKey, ContentType, and SheetsCreatedToday

Java™ Version

• Added new methods getLicenseKey, get/setContentType, getSheetsCreatedToday
• Added support for forward-only resultsets

Java™ Version

• Dependency on Data Source Wrappers Removed: Creating data markers and setting data sources are even easier without data source wrappers.
• Wrapper classes for basic data types were deprecated and removed from the distribution.
• Exception handling was streamlined between two products. SAException was removed and replaced with Java™ .lang.Exceptiion
• More descriptive (less confusing) method names were introduced for setting the datasource.
• Stripped out macros that produced corrupted output file
• Improved data marker parser (allow $#X.xxx as a valid reference to a column in an array)
• Clarified meaning of the OPTIONAL modifier (it makes the datasource or column optional; it was only for the datasource)
• Renamed all arguments of public methods to not use the VarName

• App.Open/Save threw "invalid string index".
• When the Legend's width was set to 0, Excel crashed when printing the chart.
• CategoryAxis values disappeared after setting oChart.CategoryAxis.AxisLine.LineFormatting to saxlsCreationNone.
• Generated file crashed Excel when the first worksheet was set to hidden.
• Generated file crashed Excel when cross-worksheet formulas were used.

• Calling GetDataFromExcelSheet() with IncludeFormatting = true caused extra formatting to be displayed on the spreadsheet.
• Invalid subscript error occurred when calling GetDataFromExcelSheet() with IncludeFormatting = true.
• When calling open on a spreadsheet with many externally referenced sheets, Microsoft Excel crashed.
• Setting Worksheet.WriteProtect to True did not protect charts/images.
• Chart legends are not positioned correctly when explicitly setting the width and height.
• There was memory leak in the ExcelTemplate object when using arrays as a data source.
• Referencing sheet names with Swedish characters in formula didn't work.
• Font settings were ignored for axis object, i.e. CategoryAxis or ValueAxis.

• When the Cells.GetDataFromRecordset method's ShowFieldNames parameter was set to true, the range returned by the method did not include the last row of the recordset.
• When an ExcelWriter-generated spreadsheet with a chart was opened and saved, the spreadsheet was corrupted.
• When opening an existing Excel file, calling
  • ExcelApplication.ShowHScrollBar
  • ExcelApplication.ShowVScrollBar
  • Worksheet.FreezePanes
  • Worksheet.SelectSheet
  • Worksheet.ShowGridlines
  • Worksheet.ShowRowColHeaders
  had no effect.
• In some cases, when ExcelWriter opened an existing spreadsheet and saved it, the format was corrupted.
• "Data not found" error when ExcelWriter processed a workbook that contained a data table formula.

• In single variable data markers with modifiers - e.g. %%=$MyVar(modifier) - modifiers were ignored.
• In some cases, when opening large Excel 95 files that contain many strings, ExcelWriter threw an unknown exception.
• In some cases, ExcelWriter failed to read all spreadsheet strings and threw an "Invalid string index" error.
• When passing ExcelTemplate object output to the ExcelApplication object and calling Save, ExcelWriter occasionally threw the error "A workbook must contain at least one visible sheet" when the workbook did contain a visible sheet.

• During Open/Save method calls, there is memory leak.
• Color pattern sometimes is not preserved correctly when using SAExcelApplication object to open a file.
• When opening some existing file with Far-Eastern unicode characters, ExcelWriter returns "Invalid String Index" error.
• In .NET, when calling GetDataFromDataSet by setting ShowFieldNames property to true, there is System.IndexOutOfRangeException.
• In ExcelWriter Assistant cab, when posting form data larger than 16384, sometimes the Assistant fails.
• New enumeration value added: saFileFormatExcel2002, the numerical value is 8, which corresponds to the BIFF8 format used in Excel 2002 or Excel XP.

• When using ExcelWriter Template object, the cell reference in shared formula is not calculated correctly.
• When installing ExcelWriter 4.0 on some Far-Eastern language operating system, the installation fails.
• ExcelWriter Assistant utility shows expiration message in V4.0 retail version.

• HotCell Technology allows you to update a server-side data source directly from client-side Microsoft Excel.
• ExcelWriter now includes ExcelWriter Assistant (XLWAssis.cab) which provides an upload/download control - make your Excel downloads and uploads painless and error-free.
• AnsiToUnicode and UnicodeToAnsi methods provide improved support for heterogeneous language environments.
• Improved ADO.NET support - you can now pass an ADO.NET DataSet containing a single table directly to ExcelApplication's GetDataFromDataSet method or ExcelTemplate's DataSource property.
• New Save parameter allows you to pass an ExcelApplication object to ExcelTemplate.
• Template Data Marker Modifiers provide new display options and allow you to include a data marker that is not bound to a data source without producing an error.
• Font and format optimization reduces the size of generated spreadsheets, improves performance, and prevents exceeding Excel's limits.
• String optimization reduces spreadsheet size and improves perfomance.
• ExcelApplication's ContentType property allows you to set the content type of the generated spreadsheet.
• ExcelTemplate SpreadsheetsCreatedToday property.
• Cell.ClearContents method deletes cell formulas and values.
• Worksheet.Copy method creates a copy of the specified worksheet.

• Image distortion in the CreateFromFile function
• {Min/Max}Value properties truncated float values to integers
• Template fails to populate rows from the recordset (row number was not incremented)
• Template: Numeric value for single RK values were not populated properly
• Wrong parameters passed to memset function
• Common format fields were not set for the format binary hash
• SetPageTitles error
• problem with the PageTitle being too long (unterminated string)
• vertical page breaks
• Unable to add hyperlinks to the existing file
• Print area bug (assign a new print area to a worksheet in the existing file that already has one)
• PageBreak settings are lost if existing file doesn't have xxxPAGEBREAK record
• SETUP.fNoPls flag was not transferd from the source properly
• The ptg.rwLastRow field should not be stretched down is it is equal to (MAX_ROWS_IN_WORKSHEET-1)
• Shared formulas on a field-marker row inserted into the output stream only once
• added XF.fAtrAlt the list of bits that distinguish pilot format from other cell formats (proper.xls was asserting at PutPilotFormat)
• STRING record handler (it failed to read BIFF8 strings)
• FORMULA record handler (if the formula record was part of the shared formula and evaluated into a string then the handler failed to assign string value to the first cell of the shared formula)
• Index record's DBCELL offset corrected (BIFF7, BIFF8)
• GetPrintTitles.AreaCount (Sign/unsign missmatch in declaration of PTG structures)

• ExcelTemplate property: PreserveStrings. When this property is set to True, ExcelTemplate will not convert numeric strings to numbers, but will preserve them as strings.
• ExcelApplication.Open optional parameter: ReadOnly. When this parameter is set to True, the opened spreadsheet can be read but not modified.

• BoundSheet record was not handled correctly; in some cases this caused a problem when opening an existing spreadsheet.
• AutoFitWidth and AutoFitHeight properties did not work correctly when applied to range unions.
• The ExcelTemplate object did not populate some data marker columns.

• Header/Footer character limit increased to 249 for non-Unicode content. For Unicode text, the limit is 121 characters.

• When opening an existing workbook containing a chart sheet, named range references were corrupted.
• When opening an existing spreadsheet, page setup settings were not preserved.
• CopyFromRecordset threw an exception if passed an empty recordset.
• ExcelTemplate crashed if a formula contained an empty string.
• In some client environments, including Perl and C#, ExcelWriter displayed internal debug strings.
• SeriesCollection.CategoryData did not support cell range assignments formulated as follows: {Sheet1!A1,Sheet2!A1,etc.}.

• With enhanced support for .NET, ExcelWriter is designed to function flawlessly within the .NET Framework.
• Features of the ExcelTemplate object:
  • Binding to variables: New functionality of the DataSource property. For greater flexibility in populating a workbook, you can now bind datamarkers in your template file to variables, one-dimensional or two-dimensional arrays.
  • Remove unused datamarkers: If the number of columns or fields in a particular data source is unknown, the developer may put as many datamarkers as desired in the template spreadsheet, and ExcelWriter will remove any that are not used.
• Three Worksheet properties:
  • WriteProtect for locking your Excel worksheet so that end users cannot edit or manipulate designated cells.
  • Visible to format worksheets to be visible, hidden, or very hidden.
  • Zoom to specify document appearance as a percentage of its normal size.
• 13 PageSetup properties:
  • BlackAndWhite to print in black and white.
  • Draft for optimized print speed.
  • Order to set print order.
  • PrintComments specifies whether comments should be printed in place, at the end of document or not printed.
  • PrintGridlines to print gridlines.
  • PrintHeadings to print headings.
  • PrintNotes specifies whether to print comments.
  • BottomMargin to set bottom margin.
  • FooterMargin to set footer margin.
  • HeaderMargin to set header margin.
  • LeftMargin to set left margin.
  • RightMargin to set right margin.
  • TopMargin to set top margin.
• New Range property:
  • Range.style simplifies the process for assigning a style to a range. The developer defines a custom style containing a full set of properties, defines a range and makes a simple one-line assignment statement to assign the style to the range.
• New feature of the Cells object:
  • GetDataFromRecordset and CopyFromRecordset have two new optional parameters that allows the developer to skip one or more columns in a recordset: FieldList parameter and FieldListInclude parameter.
• New features of the ExcelWriter CodeWizard:
  • Generates VB.NET script for ASP.NET.
  • Automation of script based on specific need and dataset.
  • International support.
  • Script for existing preset formats and templates.
  • Executable installation.

• When inserting a string after opening an existing file, the generated file will crash Microsoft Excel.

• RowHeight automatically set to a standard row high (12) when an assignment is made to an empty row.
• "Run-time error '-2147352567': invalid vector<T> subscript" on ExcelApplication.Open.
• With ExcelApplication.Open, formulas were inserted in incorrect cells, causing a "circular references" error on opening the spreadsheet.
• 58 - character limit in all PageSetup header properties (CenterHeader, LeftHeader, RightHeader).
• Direct assignment of a two - dimensional array to ExcelTemplate.DataSource caused an "Invalid Parameter" error in Visual Basic Script.
• Direct assignment of a two - dimensional array to Range.Value caused an "Invalid Parameter" error in Visual Basic Script.
• Large Ansi/Unicode text strings caused ExcelTemplate object to crash when generating a spreadsheet.
• When modifying an existing spreadsheet with the ExcelApplication object, PageSetup properties assigned in script were ignored.

• Bug in shared formula processing.
• Bug in pivot table processing that caused "buffer overrun" error message.
• Bug in single cell references.
• Bug in processing of empty sub-storages in existing Excel file.

• chm format documentation included.
• Sample updates.
• Added to ExcelWriterLE and Free: Style.WrapText property.

• Bug with Macros and ExcelTemplate.
• Bug with ExcelWriter Free's 500 row limitation.

• Open method opens an existing spreadsheet, allowing you to use preset formats.
• ExcelTemplate object allows you to use a template spreadsheet and associate it with ADO recordsets, variables, or arrays.
• Named ranges.
• Range.GroupRows and Range.GroupColumns allow you to outline rows and columns.
• Ranges may include non-adjacent areas.
• Range unions.
• Range intersections.
• Cell values may be assigned to a range, rather than a single cell. See, Range.Value.
• New underline styles.
• New page setup properties:
  • PrintArea
  • SetPrintTitleRows
  • SetPrintTitleColumns
  • GetPrintTitles
• New operators:
  • Concatenation (&)
  • Exponentiation (^)
• New functions:
  • And
  • Or
  • Not
  • CountIf

• New Axis property: TextRotationAngle.
• New Chart property: AutoScale.

• Cells.MergeCells reports the correct error message if cell coordinates are out of range.
• Cells.GetDataFromExcelSheet handles empty strings correctly.
• SeriesCollection.Add correctly interprets the sheet reference for a single-cell Area parameter (e.g. "Sheet2!$B$2:$B$2").

• MergeCell format is preserved correctly.
• When populating cells with long strings, the file generated might not be opened correctly. This is fixed.
• Worksheet name used in functions can have ~`@#$%&_|[]"'.characters including space.

• The AND, NOT, and OR logical worksheet functions have been added to ExcelWriter. (Not available in ExcelWriterLE or ExcelWriterFree.)
• Two SoftArtisans samples that include ExcelWriter-only features (such as generating advanced charts or reading data from an existing spreadsheet) were updated to respond to ExcelWriterLE and ExcelWriterFREE.
• Issues affecting the proper display of formulas in certain non-English versions of Microsoft® Excel, i.e. German, have been resolved.

• New chart types:
  • Bubble
  • Cylinder
  • Cone
  • Pyramid
  • Column Line - custom chart type
  • Column Line 2 Axes - custom chart type
• Supports chart data tables
• Generates charts from data in a different worksheet
• Reads existing spreadsheets
• New ASP Code Generator automatically generates an ASP script from an existing spreadsheet
• Hyperlinks
• Cell merging
• Spreadsheets may include up to 65536 rows
• Excel 95 will delete rows after 16384
• Cells may contain up to 32000 characters
• Excel 95 will delete characters after 255
• New auto fit properties:
  • AutoFitHeight
  • AutoFitWidth
• New cell range properties:
  • Cell
  • ColumnCount
  • FirstColumn
  • FirstRow
  • GetCellAt
  • Item
  • RowCount
• New property SpreadsheetsCreatedToday lets you check how many spreadsheets ExcelWriter has created today
• New property VersionEX returns the ExcelWriter edition and version number
• New PageSetup object allows you to set layout properties of a printed worksheet
• Functions can access values in a different sheet in the workbook
• New financial functions:
  • fv
  • pmt
  • pv
• New string function: concatenate
• New logical function: if
• New lookup functions:
  • Column
  • Columns
  • Hlookup
  • Row
  • Rows
  • Vlookup
• New database functions:
  • Daverage
  • Dcount
  • Dcounta
  • Dget
  • Dmax
  • Dmin
  • Dproduct
  • Dstdev
  • Dstdevp
  • Dsum
  • Dvar
  • Dvarp

• The InstallShield 1207 warning window has been removed from the ExcelWriter installation.
• MajorIncrement property of ValueAxis has been fixed to work in all cases.
• Typo corrected in the enumeration value (from "saptrnThinHorisontalStripe" to "saptrnThinHorizontalStripe")
• Fixed background and foreground color for formatting cells with solid backgrounds. Cells with background color set are now set to solid pattern by default.

• Comprehensive support for native Excel charting:
  • Column
  • Bar
  • Line
  • Pie
  • XY (Scatter)
  • Area
  • Doughnut
  • Radar
  • Surface
• Image insertion
• Border labels
• Cell backgrounds