PDF

What's New:

Added support for creating Pdf documents with PDF/A1-B compliance. Added support for rendering barcode inside pdf document. Added support for deleting pages from the existing documents. Added support for creating Line Annotation. Added support for extracting text from the existing documents. Added support for creating tables without binding to any datasource. Added support for recognizing page-breaks during Html to Pdf Conversion. Added support for enabling client-scripts during Html to Pdf Conversion.

What's Fixed:

Memory leakage issue while trying to load the emf file in to the Pdf has been fixed. PDF which was not returning the control when counting Form Fields, now returns the control. PDF which was not changing the checkbox status for the Acrobat form, now changes the checkbox status correctly. Issue with Html To Pdf conversion which was generating a blank page if it contains images and css files using FromString method has been fixed. PIE charts which was showing up as a wireframe chart instead of solid colors, now displays solid colors. Control is now returned to the procedure which calls while saving the documnent. EMF Images are now rendered properly.

XlsIO

What's New:

Added an ability to freeze pane in xlsx format. Added an ability to show/hide gridlines in xlsx format. Added an ability to ignore error indicator in xlsx format. Added an ability to parse sheet level properties in xlsx. Added support to apply IsStringPreserved property to range of cells. Added properties for show/hide vertical and horizontal scrollbar. Added ability to open csv files in read only mode. Added an ability to save as csv format in web application. Added support for working with XlsIO in medium trust. Implemented properties to set calculation mode. An ability to get/set RGB color in xlsx is implemented. An ability to set gridline color is implemented. Added support for split pane in xlsx format. Added support for sheet view properties such as right to left, zoom, page break preview in xlsx format. Added an ability to set summary settings for group in xlsx format. Added support for advanced conditional formatting visualizations in xlsx. Added support for worksheet password protection and protection option in xlsx. Added support for workbook window/structure protection in xlsx. Support for deleting multiple rows and columns with improved performance is added. Added support for preserving VML form controls in xlsx.

What's Fixed:

Issue with Pivot table which was getting corrupted while resaving xls with XlsIO, nomore gets corrupted while resaving. System hanging issue while exporting more records(above 65536) with data validation in xlsx has been fixed. Error is nomore thrown while opening the file saved by XlsIO. DisplayText property which was returning wrong value for currency, now returns the correct value. Header image can now be drawn correctly in chart worksheet. XlsIO can now correctly render a metafile image in a header. XlsIO nomore throws "Unexpected xml tag" exception while opening the existing excel 2007 spreadsheet. Unhandled Exception nomore occurs while opening the existing spreadsheet in XlsIO. IndexOutOfRangeException is nomore thrown while resaving xls in XlsIO. Missing iprop.dll in Windows 2008 Server (64 bit). This issue has been fixed. Issue with the output file has been fixed and it is nomore corrupted while copying from one workbook to another. Issue with the output file has been fixed and it is nomore corrupted and the cell value is nomore changed when resaving the file with XlsIO. ArgumentOutOfRangeException" is nomore raised while opening the xlsx file with XlsIO. NotImplementedException" is nomore thrown while opening the xlsx file with XlsIO. Changes to the template xls file now gets updated in latest version. ArgumentException is nomore thrown when opening the file using XlsIO. Issue while copying worksheets from XLSM workbook which corrupts the document, has been fixed.

DocIO

What's New:

Added feature for Footnote/endnote generation for .docx format. Added feature for Mail merge writing support for .docx format. Added feature to find and replace the control character. Added feature to preserve the Form controls. Added feature to preserve the formatting of the existing place holder while replacing. Added support for nested Mailmerge for tables. Added feature to preserve shapes while converting Doc to HTML. Added feature to Find and replace with control characters like newline, carriage return. Added feature to preserve image bullets when converting doc to docx. Improved docx reading support. Now .docx support which are in .doc format. Below are the features in specific that are added for this version: Mail merge reading, Form fields preservation, footnote/Endnote preservation, Fill effects, Back color and Watermark preservation and Autoshapes preservation. Added support for removing comments from the document. Added feature to open the document in readonly mode. Added feature to protect document by specifying the protection type for .docx format.

What's Fixed

Inserting table in header/footer which was not working properly, now works properly. ReplaceFirst which was failing to work in Tables now works properly. Importing content method now works correctly when there is more than one comment. Alignment problem when cloning or importcontent the document has been fixed. Bookmarks which were missing while opening the document, are now available. Addition and removal of cells to the existing table now works properly without any issues. 'Unable to cast object of type' exception is nomore thrown in this version while merging the document. The tables which were not converted properly, while converting doc to HTML are now coverted properly. Issue with the document which gets corrupted while mail merging the cloned document has been fixed. MailMerge.ExecuteGroup now works properly when the table start and end in different record. Table cell text wrapping now works correctly. Bullets for paragraph can now be inserted with new line without any issues. Cloning and adding comments which were not working, now works correctly. Exception is nomore thrown while importing the HTML file into the Doc file. "Index out of range" exception is nomore thrown when accessing a paragraph collection. Table of content which was not working when having same style, now works correctly. WParagraph Alignment which was not working in office 2000 machine now works properly. Cellborders style which was changing after deleting a column from a table has been fixed. Issue while resaving the docx file, where right to left alignment becomes left to right has been fixed. Format settings using TableFormat now gets applied for tables without any issues. Table border settings now works properly. Issue while converting Doc to text, which was not working properly ignoring the CR/LF, now works properly.

Calculate

What's Fixed:

Issue with Parsing function arguments failing to work, when the first character in a literal string argument is a comma has been fixed. Issue with the CONCATENATE function failing to strip interior quotes for string arguments with embedded quotes, has been fixed.

Grouping

What's Fixed:

Issue with Enum type fields in a complex field not getting initialized, has been fixed. Issue with number string expressions has been fixed.

PDF

What's New:

Added support for creating Pdf documents with PDF/A1-B compliance. Added support for rendering barcode inside pdf document. Added support for deleting pages from the existing documents. Added support for creating Line Annotation. Added support for extracting text from the existing documents. Added support for creating tables without binding to any datasource. Added support for recognizing page-breaks during Html to Pdf Conversion. Added support for enabling client-scripts during Html to Pdf Conversion.

What's Fixed:

Memory leakage issue while trying to load the emf file in to the Pdf has been fixed. PDF which was not returning the control when counting Form Fields, now returns the control. PDF which was not changing the checkbox status for the Acrobat form, now changes the checkbox status correctly. Issue with Html To Pdf conversion which was generating a blank page if it contains images and css files using FromString method has been fixed. PIE charts which was showing up as a wireframe chart instead of solid colors, now displays solid colors. Control is now returned to the procedure which calls while saving the documnent. EMF Images are now rendered properly.

XlsIO

What's New:

Added an ability to freeze pane in xlsx format. Added an ability to show/hide gridlines in xlsx format. Added an ability to ignore error indicator in xlsx format. Added an ability to parse sheet level properties in xlsx. Added support to apply IsStringPreserved property to range of cells. Added properties for show/hide vertical and horizontal scrollbar. Added ability to open csv files in read only mode. Added an ability to save as csv format in web application. Added support for working with XlsIO in medium trust. Implemented properties to set calculation mode. An ability to get/set RGB color in xlsx is implemented. An ability to set gridline color is implemented. Added support for split pane in xlsx format. Added support for sheet view properties such as right to left, zoom, page break preview in xlsx format. Added an ability to set summary settings for group in xlsx format. Added support for advanced conditional formatting visualizations in xlsx. Added support for worksheet password protection and protection option in xlsx. Added support for workbook window/structure protection in xlsx. Support for deleting multiple rows and columns with improved performance is added. Added support for preserving VML form controls in xlsx.

What's Fixed:

Issue with Pivot table which was getting corrupted while resaving xls with XlsIO, nomore gets corrupted while resaving. System hanging issue while exporting more records(above 65536) with data validation in xlsx has been fixed. Error is nomore thrown while opening the file saved by XlsIO. DisplayText property which was returning wrong value for currency, now returns the correct value. Header image can now be drawn correctly in chart worksheet. XlsIO can now correctly render a metafile image in a header. XlsIO nomore throws "Unexpected xml tag" exception while opening the existing excel 2007 spreadsheet. Unhandled Exception nomore occurs while opening the existing spreadsheet in XlsIO. IndexOutOfRangeException is nomore thrown while resaving xls in XlsIO. Missing iprop.dll in Windows 2008 Server (64 bit). This issue has been fixed. Issue with the output file has been fixed and it is nomore corrupted while copying from one workbook to another. Issue with the output file has been fixed and it is nomore corrupted and the cell value is nomore changed when resaving the file with XlsIO. ArgumentOutOfRangeException" is nomore raised while opening the xlsx file with XlsIO. NotImplementedException" is nomore thrown while opening the xlsx file with XlsIO. Changes to the template xls file now gets updated in latest version. ArgumentException is nomore thrown when opening the file using XlsIO. Issue while copying worksheets from XLSM workbook which corrupts the document, has been fixed.

DocIO

What's New:

Added feature for Footnote/endnote generation for .docx format. Added feature for Mail merge writing support for .docx format. Added feature to find and replace the control character. Added feature to preserve the Form controls. Added feature to preserve the formatting of the existing place holder while replacing. Added support for nested Mailmerge for tables. Added feature to preserve shapes while converting Doc to HTML. Added feature to Find and replace with control characters like newline, carriage return. Added feature to preserve image bullets when converting doc to docx. Improved docx reading support. Now .docx support which are in .doc format. Below are the features in specific that are added for this version: Mail merge reading, Form fields preservation, footnote/Endnote preservation, Fill effects, Back color and Watermark preservation and Autoshapes preservation. Added support for removing comments from the document. Added feature to open the document in readonly mode. Added feature to protect document by specifying the protection type for .docx format.

What's Fixed

Inserting table in header/footer which was not working properly, now works properly. ReplaceFirst which was failing to work in Tables now works properly. Importing content method now works correctly when there is more than one comment. Alignment problem when cloning or importcontent the document has been fixed. Bookmarks which were missing while opening the document, are now available. Addition and removal of cells to the existing table now works properly without any issues. 'Unable to cast object of type' exception is nomore thrown in this version while merging the document. The tables which were not converted properly, while converting doc to HTML are now coverted properly. Issue with the document which gets corrupted while mail merging the cloned document has been fixed. MailMerge.ExecuteGroup now works properly when the table start and end in different record. Table cell text wrapping now works correctly. Bullets for paragraph can now be inserted with new line without any issues. Cloning and adding comments which were not working, now works correctly. Exception is nomore thrown while importing the HTML file into the Doc file. "Index out of range" exception is nomore thrown when accessing a paragraph collection. Table of content which was not working when having same style, now works correctly. WParagraph Alignment which was not working in office 2000 machine now works properly. Cellborders style which was changing after deleting a column from a table has been fixed. Issue while resaving the docx file, where right to left alignment becomes left to right has been fixed. Format settings using TableFormat now gets applied for tables without any issues. Table border settings now works properly. Issue while converting Doc to text, which was not working properly ignoring the CR/LF, now works properly.

Calculate

What's Fixed:

Issue with Parsing function arguments failing to work, when the first character in a literal string argument is a comma has been fixed. Issue with the CONCATENATE function failing to strip interior quotes for string arguments with embedded quotes, has been fixed.

Grouping

What's Fixed:

Issue with Enum type fields in a complex field not getting initialized, has been fixed. Issue with number string expressions has been fixed.

PDF

What's New:

Added ability to embed U3D files for 3-D annotation. Added support for converting Web pages with authentication scheme. Added ability to create PDF booklet. Added ability to sign existing document.

What's Fixed:

Issue with Inserting the page at the index 0 has been fixed. Issue with Essential PDF file size being large, when rendering images with small file size, has been fixed. Issue with Pages in collection, which after merging couldn't be accessed, has been fixed. Exception is nolonger thrown while form flattening has been fixed. Exception 'Can't draw table', which was thrown when we add an empty row, has been fixed. Document information that was not displaying properly has been fixed.

XlsIO

What's New:

Implemented properties for scrolling to particular row/column. Support for compound file format with managed code. Added an ability to get UsedRange in a sheet for data without formatting.

What's Fixed:

Argument Exception is nomore thrown when opening a file. Exception is nolonger thrown while deleting a row after inserting comment. CopyToClipboard method which was taking more time to execute when compared to saveAs method, now takes comparitively lesser time. Excel crash nomore happens, when moving WorkSheet in Excel2007. Copying worksheet to chart workbook nomore causes corruption in excel2003. Exception while writing sheet with merged cells to XML format has been fixed. Null pointer exception is nomore thrown when a series is removed from template with hidden legend. Memory usage is now reduced, while using IgnoreErrorOptions. Issue with time taken while using Autofit column with 60000 rows in XlsIO, has been fixed. Exception, which was thrown while importing data table in Excel 2007, has been fixed.

DocIO

What's New:

Added support for nested mail merge. Added support for Doc to HTML conversion. Added support for text box fill effects and margin. Added properties for getting group names in document and field names in a group. Support for form field shading off/on has been added. Added support to remove paragraphs that contain mail merge fields with no data from the document. Added support to compress image while writing to the document. Added feature for ReplaceFirst option in a document. Added support for image hyperlink. Added support for msoblipDIB image format. Added support for forward-only find and replace. Added support to skip image parsing while opening the document. Added support to automatically map between names of fields in the data source and names of mail merge fields in the document. Added support for accept/reject track changes. Added support to get and replace commented document range. Added support to read the MS Word 2007(Docx) files. Implemented following elements preservations: Character formatting, Paragraph formatting, Paragraph border, Page Setup, Textboxes, Bookmarks, Breaks, Hyperlink, Columns, Tables, Chart, Pictures, Header/footer with image.

What's Fixed

Mailmerge ClearFiled property setting now works fine with ExecuteGroup. ArgumentNullException is nomore thrown while opening the document. Field merging now works properly in the textbox. Exception isnomore thrown while using the MailMerge ExecuteGroup. Merging two or more tables nomore shows any empty fields without values. Issue while using TextSelection.GetOneRange().Text, which changes text formatting, has been fixed. Problem with merging fields inside the text box with more than 60 records has been fixed. "DivideByZeroException" is nomore thrown when saving the document. InvalidCastException is nomore thrown while cloning a section. ArgumentException is no longer thrown while cloning a document. CreateDate field which had issues in updating the field can now update the field properly. Horizontal line which was not getting displayed while merging, now gets displayed properly. Hyperlink can now identify the type correctly. Exception is no longer thrown while opening the document with lists. Issue with font which was changed from default to standard, after entering one line text has been fixed. CreateDate field format now remains unchanged while opening the document. Changing text format using TextRange nolonger changes the prior and next line's format.

Calculate

What's New:

Added support in IF function calculation for two arguments. Earlier versions were not able to properly compute an IF function call, when only two arguments were passed. Added support for new property AllowShortCircuitIFs. If this property is true, IF functions involving nested functions calls, will only compute the necessary alternative. In previous versions, IF functions involving nested function calls were computing unnecessary alternative depending upon the actual arguments involved. In CalcWorkBook.CalculateAll, we have added a code to mark all the calculations with a new calculation ID, so that the CalcEngine can recognize the calculations which are newly performed.

Grouping

What's Fixed:

QueryValue event which had issues with return Value Type now functions properly.

PDF

What's New:

Added ability to embed U3D files for 3D annotation. Added support for converting webpages with authentication scheme. Added ability to create PDF booklet. Added ability to sign existing document.

What's Fixed:

Issue with Inserting the page at the index 0, has been fixed. Issue with Essential PDF, whose file size is large, when rendering images with small file size, has been fixed. Issue with Pages in collection, which, after merging couldn't be accessed, has been fixed. Exception while form flattening has been fixed. Exception 'Can't draw table' that was getting thrown, when we add an empty row, has been fixed. Document information which was not displaying properly, has been fixed.

XlsIO

What's New:

Implemented properties for Scrolling to particular row/column. Support for Compound file format with managed code. Added an ability to get UsedRange in a sheet for data without formatting.

What's Fixed:

Argument Exception when opening a file has been fixed. Exception while deleting a row after inserting comment has been fixed. CopyToClipboard method which was taking more time to execute when compared to saveAs method, has been fixed. Excel crash issue, when moving WorkSheet in Excel2007, has been fixed. Copying worksheet to chart workbook causes corruption in excel2003, has been fixed. Exception while writing sheet with merged cells to XML format, has been fixed. Null pointer exception when a series is removed from template with hidden legend, has been fixed. High Memory usage issue, while using IgnoreErrorOptions, has been fixed. Issue with Time taken while using Autofit column with 60000 rows in XlsIO, has been fixed. Exception which was thrown, while importing data table in Excel 2007, has been fixed.

DocIO

What's New:

Added support for nested mailmerge. Added support for Doc to HTML conversion. Added support for Textbox fill effects and margin. Added properties for getting group names in document and field names in a group. Support for Form field shading off/on has been added. Added support to remove paragraphs that contain mail merge fields with no data from the document. Added support to compress image while writing to the document. Added feature for ReplaceFirst option in a document. Added support for image hyperlink. Added support for msoblipDIB image format. Added support for forward only find and replace. Added support to Skip image parsing while opening the document Added support to automatically map between names of fields in the data source and names of mail merge fields in the document. Added support for accept/reject track changes. Added support to get and replace commented document range. Added support to read the docx files. Implemented following elements preservations: Character formatting, Paragraph formatting, Paragraph border, Page Setup, Textboxes, Bookmarks, Breaks, Hyperlink, Columns, Tables, Chart, Pictures, Header/footer with imageList

What's Fixed

Issue with setting Mailmerge ClearFiled property which doesn't work with ExecuteGroup has been fixed. ArgumentNullException thrown while opening the document has been fixed. Problem with merging field inside the textbox has been fixed. Exception thrown while using the MailMerge ExecuteGroup has been fixed. Issue while merging two or more tables displays some of the fields without values has been fixed. Issue while using TextSelection.GetOneRange().Text changes text formatting has been fixed. Problem with merging fields inside the textbox with more than 60 records has been fixed. "DivideByZeroException" which was thrown while saving the document has been fixed. InvalidCastException while cloning a section has been fixed. ArgumentException thrown while cloning a document has been fixed. Issue with CreateDate field not updating the field properly has been fixed. Issue with horizontal line not getting displayed while merging has been fixed. Issue with hyperlink, which was not identifying the type correctly, has been fixed. Exception thrown while opening the document with lists has been fixed. Issue with Font which was changed from default to standard, after entering one line text has been fixed. While opening the document CreateDate field format is changed issue has been fixed. Changing text format using TextRange will change the prior and next line's format also issue has been fixed.

Calculate

What's New:

Added support in IF function calculation for two arguments. Earlier versions could not properly compute an IF function call if only two arguments were passed. Added support for new property AllowShortCircuitIFs. If this property is true, IF functions involving nested functions calls will only compute the necessary alternative. In previous versions, IF functions involving nested function calls may have computed the unnecessary alternative depending upon the actual arguments involved. In CalcWorkBook.CalculateAll, added code to mark all calculations with a new calculation ID so the CalcEngine can recognize the calculations as newly performed.

Grouping

What's Fixed:

Issues with return Value Type from QueryValue event has been fixed.

PDF

What's New:

Added ability to embed U3D files for 3D annotation. Added support for converting webpages with authentication scheme. Added ability to create PDF booklet. Added ability to sign existing document.

What's Fixed:

Issue with Inserting the page at the index 0, has been fixed. Issue with Essential PDF, whose file size is large, when rendering images with small file size, has been fixed. Issue with Pages in collection, which, after merging couldn't be accessed, has been fixed. Exception while form flattening has been fixed. Exception 'Can't draw table' that was getting thrown, when we add an empty row, has been fixed. Document information which was not displaying properly, has been fixed.

XlsIO

What's New:

Implemented properties for Scrolling to particular row/column. Support for Compound file format with managed code.

What's Fixed:

Argument Exception when opening a file has been fixed. Exception while deleting a row after inserting comment has been fixed. CopyToClipboard method which was taking more time to execute when compared to saveAs method, has been fixed. Excel crash issue, when moving WorkSheet in Excel2007, has been fixed. Copying worksheet to chart workbook causes corruption in excel2003, has been fixed. Exception while writing sheet with merged cells to XML format, has been fixed. Null pointer exception when a series is removed from template with hidden legend, has been fixed. High Memory usage issue, while using IgnoreErrorOptions, has been fixed. Issue with Time taken while using Autofit column with 60000 rows in XlsIO, has been fixed. Exception which was thrown, while importing data table in Excel 2007, has been fixed.

DocIO

What's New:

Added support for nested mailmerge. Added support for Doc to HTML conversion. Added support for Textbox fill effects and margin. Added properties for getting group names in document and field names in a group. Support for Form field shading off/on has been added. Added support to remove paragraphs that contain mail merge fields with no data from the document. Added support to compress image while writing to the document. Added feature for ReplaceFirst option in a document. Added support for image hyperlink. Added support for msoblipDIB image format. Added support for forward only find and replace. Added support to Skip image parsing while opening the document Added support to automatically map between names of fields in the data source and names of mail merge fields in the document. Added support for accept/reject track changes. Added support to get and replace commented document range.

What's Fixed

Issue with setting Mailmerge ClearFiled property which doesn't work with ExecuteGroup has been fixed. ArgumentNullException thrown while opening the document has been fixed. Problem with merging field inside the textbox has been fixed. Exception thrown while using the MailMerge ExecuteGroup has been fixed. Issue while using TextSelection.GetOneRange().Text changes text formatting has been fixed. Problem with merging fields inside the textbox with more than 60 records has been fixed. "DivideByZeroException" which was thrown while saving the document has been fixed. InvalidCastException while cloning a section has been fixed. ArgumentException thrown while cloning a document has been fixed. Issue with CreateDate field not updating the field properly has been fixed. Issue with horizontal line not getting displayed while merging has been fixed. Issue with hyperlink, which was not identifying the type correctly, has been fixed. Exception thrown while opening the document with lists has been fixed. Issue with Font which was changed from default to standard, after entering one line text has been fixed. While opening the document CreateDate field format is changed issue has been fixed.

Calculate

What's New:

Added support in IF function calculation for two arguments. Earlier versions could not properly compute an IF function call if only two arguments were passed. Added support for new property AllowShortCircuitIFs. If this property is true, IF functions involving nested functions calls will only compute the necessary alternative. In previous versions, IF functions involving nested function calls may have computed the unnecessary alternative depending upon the actual arguments involved. In CalcWorkBook.CalculateAll, added code to mark all calculations with a new calculation ID so the CalcEngine can recognize the calculations as newly performed.

Grouping

What's Fixed:

Issues with return Value Type from QueryValue event has been fixed.

PDF

What's New:

Added support for reading, existing PDF document from stream, disk and bytes. Added ability to merge and append multiple PDF document. Added ability to split PDF. Added ability to import pages from other document. Added support for merging bookmarks, when merging multiple documents Added support for reading forms. Added support for merging multiple forms. Added support for form filling. Added support for Form and field flattening. Added support for opening excrypted document. Added support encrypting existing document. Added support for creating PDF templates. Added support for sorting in PDF light table. Added support for setting row height. Added support for ignoring column format for headers. Improved support for HTML to PDF conversion.

What's Fixed:

Issue with PDF document version not set properly, if it is less than 1.5, has been fixed. NullReference Exception occuring issue while opening a PDF document has been fixed. Issue with Meta File image not displayed properly in PDF, has been fixed. Issue with empty PDF getting generated after merging two files, has been fixed. Improper contents issue, while converting from Html-Pdf, has been fixed. A TargetInvocationException is being thrown when trying to Publish an ITable in WinXP 64bit machines, has been fixed. While converting HTML to PDF, several blank pages are added at the end of the document has been fixed. Issue with EMF image, which was not rendered properly in the PDF document, has been fixed. Some content is cut off when converting HTML to PDF / RTF to PDF, has been fixed. Argument Exception thrown issue, while converting HTML to PDF by using Bitmap image type, has been fixed. Data which was not rendering properly, as the RTF original file, has been fixed. Issue with Data that is cut at end of the page, and also alignment changes issues, has been fixed. Exception which was thrown, when the file is opened with an OS in Italian and Excel 2007, has been fixed.

XlsIO

What's New:

Added support for writing page breaks in Excel 2007 .xlsx format. Added support for Charts in Excel 2007 .xlsx format. Added support for external formulas. Improved performance for reading error indicator documents. Added support for image styles preservation.

What's Fixed:

Parse exception thrown issue when the file is opened with German regional settings has been fixed. Error message which was displayed while downloading the file with pivot table, has been fixed. Issue with AutofitColumns property not working properly with the particular column, has been fixed. Unable to open Excel-File. Throws an " Index out of bounds" exception has been fixed. Issue with multiple rows not getting copied properly, has been fixed. Exception which was thrown, on opening a file has been fixed. Issue with DropDown list item not working properly, when resaving the file through XlsIO, has been fixed. Argument Exception was unhandled, which was thrown, while passing "=" to XlsIO, has been fixed. Wrong color shown while accessing the Foreground color of chart has been fixed. Cell backcolor value which was not returned properly, has been fixed. File crash issue in Office 2003 sp3 has been fixed. Issue with file getting corrupted, while setting richtext formatting to range of cells has been fixed. While setting NumberFormat as "[$-409]#,##0.0###", it shows wrong value for the DisplayText property has been fixed. Error occurred when Workbook.Protect() method is used, has been fixed. Exception thrown issue, while opening a file, has been fixed. Unable to open xlsx file containing formulas with invalid name error, has been fixed. Need proper exception title for unsupported file formats, has been fixed. Unable to open the xlsx file "Index was out of range exception" has been fixed. Issue while inserting a new row, some comments inserted in the rows are moved incorrectly, has been fixed. An item with the same key has already been added exception occurred, while opening the template has been fixed. File corrupted issue, when the workbook was protected, has been fixed. File crash issue, after opening the document using XlsIO, has been fixed. While Copying the chart data in another worksheet, source data range are not displayed, has been fixed. Object reference not set to an instance of an object exception is raised while opening the file, has been fixed.

What's Issues:

If XlsIO is unable to read any .xlsx files then please send it to support@syncfusion.com and we will fix it at the earliest.

DocIO

What's New:

Added support for Built in styles. Added support for inserting Table of Contents. Added ability to insert page numbers with formatting. Added support for writing Office 2007 .Docx files. Added limited support for converting .Doc files to .Docx files. Added ability to insert Html formatted strings in paragraphs. Added ability to set margin for textbox. Added support for find and replacing Hyperlinks. Added support for find and replace string with document contents.

What's Fixed

File crashing issue while opening DocIO generated file in MS Word 2000 has been fixed. Issue with bookmarks not working properly, when creating large number of bookmarks, has been fixed. Incorrect character and page count returned issue in Windows server 2003 64 bit machine has been fixed. Issue with opening a document, which has an image whose scale factor of width is greater than 3000%, has been fixed. Exception thrown issue, while replacing a boomark content which is inside the textbox has been fixed. Outline numbering lost issue, while viewing the file in Office 2003 sp3 and Office 2007, has been fixed. The Exception, "Cells count in sourceDescriptor is greater than destination", which was raised while trying to open the file, has been fixed. Issue with Padding not working for cell level formatting has been fixed. Exception on opening the document has been fixed. Argument Exception which was thrown on navigating to a particular Bookmark has been fixed. BookMark Formatting Issue has been fixed. Header formatting issue which was not properly applied to the merged document, has been fixed. Corrupted text shown issue, while trying to open the text file in the browser using document Save() Method has been fixed. ArgumentNullException raised issue, while opening the document has been fixed. Issue with documents which are generated using DocIO, cannot be opened by DocIO, has been fixed. Issue with Bookmark in DocIO, which is case-sensitive, has been fixed. DLS exception which was raised, while opening the file with table, has been fixed. Issue with grid lines of table not shown properly if CellSpacing is set to 0, has been fixed. Error messages are displayed while opening the document generated by DocIO, has been fixed. Issue with Textbox TextFormat property returning the default values, has been fixed. The clone method should be multi-thread safe.While running threads, it throws an exception has been fixed. While opening the document it throws "Document image format is incorrect", has been fixed. Paragraph Text property throws "Index was out of range" exception, has been fixed. File corrupted issue, while opening the document, has been fixed. "Cannot open storage" exception which was raised, while multithreading the document, has been fixed. Issue with multithread environment, where find and replace is not working, has been fixed. Throws "Index out of Range exception" while opening and saving the merged document, has been fixed. IndexOutOfRangeException exception which was raised, while using lists, has been fixed. Issue with MailMerge.ClearFields property, which does not clear anything, has been fixed. While opening the document, it removes the spaces in the datefield has been fixed. Issue with Table left indent property which was not working properly in the document, has been fixed. CopyToClipboard method performance has been improved.

Calculate

What's Fixed:

Formula that has intermediate results with a thousands separator results invalid expression, has been fixed. Issue with formula, where % sign results invalid expression, has been fixed. Issue with Parsing function arguments failing to work, when the first character in a literal string argument is a comma has been fixed. Issue with the CONCATENATE function failing to strip interior quotes for string arguments with embedded quotes has been fixed.

Grouping

What's Fixed:

Issue with Enum type fields in a complex field not getting initialized, has been fixed. Issue with number string expressions has been fixed. Issues with return Value Type from QueryValue event has been fixed.

PDF

What's New:

Added support for reading, existing PDF document from stream, disk and bytes. Added ability to merge and append multiple PDF document. Added ability to split PDF. Added ability to import pages from other document. Added support for merging bookmarks, when merging multiple documents Added support for reading forms. Added support for merging multiple forms. Added support for form filling. Added support for Form and field flattening. Added support for opening excrypted document. Added support encrypting existing document. Added support for creating PDF templates. Added support for sorting in PDF light table. Added support for setting row height. Added support for ignoring column format for headers. Improved support for HTML to PDF conversion.

What's Fixed:

Issue with PDF document version not set properly, if it is less than 1.5, has been fixed. NullReference Exception occuring issue while opening a PDF document has been fixed. Issue with Meta File image not displayed properly in PDF, has been fixed. Issue with empty PDF getting generated after merging two files, has been fixed. Improper contents issue, while converting from Html-Pdf, has been fixed. A TargetInvocationException is being thrown when trying to Publish an ITable in WinXP 64bit machines, has been fixed. While converting HTML to PDF, several blank pages are added at the end of the document has been fixed. Issue with EMF image, which was not rendered properly in the PDF document, has been fixed. Some content is cut off when converting HTML to PDF / RTF to PDF, has been fixed. Argument Exception thrown issue, while converting HTML to PDF by using Bitmap image type, has been fixed. Data which was not rendering properly, as the RTF original file, has been fixed. Exception which was thrown, when the file is opened with an OS in Italian and Excel 2007, has been fixed.

XlsIO

What's New:

Added support for writing page breaks in Excel 2007 .xlsx format. Added support for Charts in Excel 2007 .xlsx format. Added support for external formulas. Improved performance for reading error indicator documents. Added support for image styles preservation.

What's Fixed:

Parse exception thrown issue when the file is opened with German regional settings has been fixed. Error message which was displayed while downloading the file with pivot table, has been fixed. Issue with AutofitColumns property not working properly with the particular column, has been fixed. Unable to open Excel-File. Throws an " Index out of bounds" exception has been fixed. Issue with multiple rows not getting copied properly, has been fixed. Exception which was thrown, on opening a file has been fixed. Issue with DropDown list item not working properly, when resaving the file through XlsIO, has been fixed. Argument Exception was unhandled, which was thrown, while passing "=" to XlsIO, has been fixed. Wrong color shown while accessing the Foreground color of chart has been fixed. Cell backcolor value which was not returned properly, has been fixed. File crash issue in Office 2003 sp3 has been fixed. Issue with file getting corrupted, while setting richtext formatting to range of cells has been fixed. While setting NumberFormat as "[$-409]#,##0.0###", it shows wrong value for the DisplayText property has been fixed. Error occurred when Workbook.Protect() method is used, has been fixed. Exception thrown issue, while opening a file, has been fixed. Unable to open xlsx file containing formulas with invalid name error, has been fixed. Need proper exception title for unsupported file formats, has been fixed. Unable to open the xlsx file "Index was out of range exception" has been fixed. Issue while inserting a new row, some comments inserted in the rows are moved incorrectly, has been fixed. An item with the same key has already been added exception occurred, while opening the template has been fixed. File corrupted issue, when the workbook was protected, has been fixed. File crash issue, after opening the document using XlsIO, has been fixed. While Copying the chart data in another worksheet, source data range are not displayed, has been fixed. Object reference not set to an instance of an object exception is raised while opening the file, has been fixed.

What's Fixed:

If XlsIO is unable to read any .xlsx files then please send it to support@syncfusion.com and we will fix it at the earliest.

DocIO

What's New:

Added support for Built in styles. Added support for inserting Table of Contents. Added ability to insert page numbers with formatting. Added support for writing Office 2007 .Docx files. Added limited support for converting .Doc files to .Docx files. Added ability to insert Html formatted strings in paragraphs. Added ability to set margin for textbox. Added support for find and replacing Hyperlinks. Added support for find and replace string with document contents.

What's Fixed

File crashing issue while opening DocIO generated file in MS Word 2000 has been fixed. Issue with bookmarks not working properly, when creating large number of bookmarks, has been fixed. Incorrect character and page count returned issue in Windows server 2003 64 bit machine has been fixed. Issue with opening a document, which has an image whose scale factor of width is greater than 3000%, has been fixed. Exception thrown issue, while replacing a boomark content which is inside the textbox has been fixed. Outline numbering lost issue, while viewing the file in Office 2003 sp3 and Office 2007, has been fixed. The Exception, "Cells count in sourceDescriptor is greater than destination", which was raised while trying to open the file, has been fixed. Issue with Padding not working for cell level formatting has been fixed. Exception which was occuring while opening the document has been fixed. Argument Exception which was thrown on navigating to a particular Bookmark has been fixed. BookMark Formatting Issue has been fixed. Header formatting issue which was not properly applied to the merged document, has been fixed. Corrupted text shown issue, while trying to open the text file in the browser using document Save() Method has been fixed. Issue with documents which are generated using DocIO, cannot be opened by DocIO, has been fixed. Issue with Bookmark in DocIO, which is case-sensitive, has been fixed. DLS exception which was raised, while opening the file with table, has been fixed. Issue with Textbox TextFormat property returning the default values, has been fixed. The clone method should be multi-thread safe.While running threads, it throws an exception has been fixed. "Cannot open storage" exception which was raised, while multithreading the document, has been fixed. Throws "Index out of Range exception" while opening and saving the merged document, has been fixed. IndexOutOfRangeException exception which was raised, while using lists, has been fixed. While opening the document, it removes the spaces in the datefield has been fixed. Issue with Table left indent property which was not working properly in the document, has been fixed.

Calculate

What's Fixed:

Formula that has intermediate results with a thousands separator results invalid expression, has been fixed. Issue with formula, where % sign results invalid expression, has been fixed. Issue with Parsing function arguments failing to work, when the first character in a literal string argument is a comma has been fixed. Issue with the CONCATENATE function failing to strip interior quotes for string arguments with embedded quotes has been fixed.

Grouping

What's Fixed:

Issues with return Value Type from QueryValue event has been fixed.

PDF

What's New:

Added support for reading existing PDF document from stream, disk and bytes. Added ability to Merge and append multiple PDF document Added ability to split PDF Added ability to import pages from other document. Added support for merging bookmarks when merging multiple document Added support for reading forms Added support for merging multiple forms Added support for form filling Added support for Form and field flattening Added support for opening excrypted document Added support encrypting existing document Added support for creating PDF templates Added support for sorting in Pdf light table Added support for setting row height. Added support for ignoring column format for headers Improved support for HTML to PDF conversion.

What's Fixed:

Issue with PDF document version not set properly, if it is less than 1.5, has been fixed. NullReference Exception which occured while opening a PDF document has been fixed. Issue with Meta File image not displayed properly in PDF, has been fixed. Issue with empty PDF getting generated after merging two files, has been fixed. Improper contents issue, while converting from Html-Pdf, has been fixed. A TargetInvocationException is being thrown when trying to Publish an ITable in WinXP 64bit machines, has been fixed. While converting HTML to PDF, several blank pages are added at the end of the document has been fixed. EMF image is not rendered properly in the PDF document has been fixed. Some content is cut off when converting HTML to PDF / RTF to PDF has been fixed. Argument Exception is thrown while converting HTML to PDF by using Bitmap image type has been fixed. Data is not rendering properly as the RTF original file has been fixed. Exception is thrown when the file is opened with an OS in Italian and Excel 2007 has been fixed.

XlsIO

What's New:

Improved performance for reading error indicator documents. Added support for image styles preservation. Added support for writing page breaks in Excel 2007 .xlsx format. Added support for external formulas. Added support for Charts in Excel 2007 .xlsx format

What's Fixed:

Parse exception thrown issue when the file is opened with German regional settings has been fixed. Error message which was displayed while downloading the file with pivot table, has been fixed. Issue with AutofitColumns property not working properly with the particular column, has been fixed. Unable to open Excel-File. Throws an " Index out of bounds" exception has been fixed. Issue with multiple rows not getting copied properly, has been fixed. Exception which was thrown, on opening a file has been fixed. Issue with DropDown list item not working properly, when resaving the file through XlsIO, has been fixed. Argument Exception was unhandled, which was thrown, while passing "=" to XlsIO, has been fixed. Wrong color shown while accessing the Foreground color of chart has been fixed. Cell backcolor value which was not returned properly, has been fixed. File crash issue in Office 2003 sp3 has been fixed. Issue with file getting corrupted while setting richtext formatting to range of cells has been fixed. The file gets corrupted while setting richtext formatting to range of cells. While setting NumberFormat as "[$-409]#,##0.0###", it shows wrong value for the DisplayText property has been fixed. Error occurred when Workbook.Protect() method is used, has been fixed. Exception thrown while opening a file has been fixed. Unable to open xlsx file containing formulas with invalid name error has been fixed. Need proper exception title for unsupported file formats has been fixed. Unable to open the xlsx file "Index was out of range exception" has been fixed. When insert a new row some comments inserted in the rows are moved incorrectly has been fixed. An item with the same key has already been added exception occurred while opening the template has been fixed. File gets corrupted when the workbook was protected has been fixed. File crash after open the document using XlsIO has been fixed. To copy the chart data in another worksheet the source data range are not displayed has been fixed. Object reference not set to an instance of an object has been fixed.

DocIO

What's New:

Added support for Built in styles Added support for inserting Table of Contents Added ability to insert page numbers with formatting Added support for writing Office 2007 .Docx files Added limited support for converting .Doc files to .Docx files. Added ability to insert Html formatted strings in paragraphs. Added ability to set margin for textbox. Added support for find and replacing Hyperlinks. Added support for find and replace string with document contents.

What's Fixed

File crashing issue while opening DocIO generated file in MS Word 2000 has been fixed. Issue with bookmarks not working properly, when creating large number of bookmarks, has been fixed. Incorrect character and page count returning issue in Windows server 2003 64 bit machine has been fixed. Issue with opening a document, which has an image whose scale factor of width is greater than 3000%, has been fixed. Exception thrown issue, while replacing a boomark content which is inside the textbox has been fixed. Outline numbering lost issue, while viewing the file in Office 2003 sp3 and Office 2007, has been fixed. The Exception, "Cells count in sourceDescriptor is greater than destination", which was raised while trying to open the file has been fixed. Issue with Padding not working for cell level formatting, has been fixed. Exception which was occuring while opening the document, has been fixed. Argument Exception which was thrown on navigating to a particular Bookmark, has been fixed. BookMark Formatting issue has been fixed. Header formatting issue which was not properly applied to the merged document, has been fixed. Corrupted text shown issue, while trying to open the text file in the browser using document Save() Method has been fixed. Issue with documents which are generated using DocIO, cannot be opened by DocIO, has been fixed. Bookmark in DocIO is case-sensitive has been fixed. DLS exception is raised while opening the file with table, has been fixed. Textbox TextFormat property returns the default values has been fixed. The clone method should be multi-thread safe.While running threads, it throws an exception has been fixed. Cannot open storage exception raise while multithreading the document has been fixed. Throws " Index out of Range exception" while opening and saving the merged document has been fixed. IndexOutOfRangeException exception is raised while using lists has been fixed. While opening the document, it removes the spaces in the datefield has been fixed. Table left indent property is not working properly in the document has been fixed.

Calculate

What's Fixed:

Formula that has intermediate results with a thousands seperator results invalid expression has been fixed. % sign in the formula results invalid expression has been fixed. Issue with Parsing function arguments failing to work, when the first character in a literal string argument is a comma has been fixed. Issue with the CONCATENATE function failing to strip interior quotes for string arguments with embedded quotes has been fixed.

Grouping

What's Fixed:

Issues with return Value Type from QueryValue event has been fixed. Issue with Enum type fields in a complex field not getting initialized, has been fixed. Issue with number string expressions has been fixed

XlsIO

What's New:

Advanced support for Excel 2007 (.xlsx) file format. Copying cells with conditional formatting. Preserve shapes in charts. Improved support for working with styles in Biff8 format. Open password protected worksheet with structure option.

What's Fixed:

Exporting a range which has empty cells in the first row, is fixed. Exception being thrown while autofitting rows has been fixed. Runtime error 50290 is thrown in SAP environment is fixed. Exception, 'An item with the same key has already been added', which occurs on opening a file, is fixed. PrintTitleRows doesn't work properly on giving null value, is fixed. Rows not visible while resaving the workbook, is fixed. Need fix for the issue 'Argument Range Exception' in 6.2.0.32 code base, has been fixed.

DocIO

What's Fixed:

Incorrect result while removing bookmark content, is fixed. IndexOutOfRange exception raised while using Mail merge executegroup, is fixed. Formatting not applied when the bookmark content is empty, is fixed. Bookmark not found with euro-sign in template issue, is fixed. TextFormField not preserving new lines, is fixed.

PDF

What's Fixed:

Tab spacing getting ignored when drawing strings has been fixed. MeasureString returning wrong width for single space has been fixed. OutOfMemoryException being raised while converting HTML to Pdf, is fixed.

XlsIO

What's New:

Basic support for Excel 2007 XML-based file format. Objects preservation when opening and saving Excel 2007 format.

What's Fixed:

Fixed issue with chart color when the file is opened through Office 2007. Fixed issues with formula that gets changed when resaved with XlsIO. Chart area gets shrunk while resaving with XlsIO. IAddInFunction.Name throws NullReference exception. Fixed issue with inserting rows that throws "ArgumentOutOfRange" exception. Fixed issue with exporting a range which has empty cells in the first row of Data table.

DocIO

What's New:

Form creation and Form filling. Replacing place holders with document elements. Support for setting Background / Watermark. Enhanced support for Bookmark preservations and replacement. Enhanced support for Table creation. Spell check preservation.

What's Fixed:

FindAll method generates unexpected output when searching for a particular text. Fixed issue with bullets in table that are not preserved when cloning and merging. Performing Mail Merge raises argument exception. Fixed issue that throws "Not enough memory" exception while resaving the document using MS Word. Fixed issue with formatting that are changed while cloning the document.

PDF

What's New:

Version 5.2 of Essential PDF is a complete rewrite, so the APIs are not compatible with the previous version of Essential PDF. HTML Pagination that will prevent text truncation at page breaks. Support for converting HTML to PDF from streams. Improved support for RTF files. Improved performance with rendering images and document generation. Insert page labels. Sign document with Certify signatures. Bullets and Lists support.

What's Fixed:

Calculate

What's New:

Extended UseNoAmpersandQuotes to support controlling quotes. Added more excel like functions:- DOLLAR, FIXED, ISTEXT, ISNONTEXT, FALSE, TRUE, ISBLANK, ISNA, ISERR, ISLOGICAL, TRIM, UPPER and LOWER.

What's Fixed:

Recursive Refresh call on ValueChanged causes app hung with complex formulas. Min /Max library functions not handling empty args as Excel does. Not able to concatenate multiple values with ampersand. Engine not considering values that starts with +/ - as formula.

XlsIO

What's New:

Performance in terms of time taken and memory usage has been greatly improved. Users should typically see 2-5x improvement in performance. Find external formulas in the worksheets using HadExternalFormula. Remove the green indicator from the top left hand corner of the cell containing the error. Encryption and Decryption support. Preserve hyperlinks when copying worksheets. Vista compatibility.

What's Fixed:

Layout being changed while copying worksheets. IWorksheet.PageSetup.FirstPageNumber property is not setting the value properly. Orientation being changed from Portrait to Landscape when sheet.PageSetupZoom property is set. IRange.Text property returns null when a cell has a Date time or Number - use the IRange.Value property instead.

DocIO

What's New:

Preserving AutoShapes, FootNotes, EndNotes and Comments in Templates. Append Symbols, Comments, FootNotes and EndNotes to a document. Vista Compatibility.

What's Fixed:

Fixed issue with invisible images in a table. Fixed issue with preserving the originality of the image in a template document. Fixed issue with the length of the stream that returns as 0. Fixed issue with nested table preservation. Fixed issues with Doc to Txt conversion. Fixed issue with find and replace inside the table.

PDF

What's New:

Support for filling forms created with "Adobe 6.0 compatible" format in Adobe life cycle. Vista compatibility.

What's Fixed:

Rendering large TIFF images into PDF. Fixed issue with retaining the vertical alignment while flattening Multiline text box. Fixed issue with TextShape settings. Fixed issue with converting RTF documents with hyperlinks to PDF. Fixed issue with gradient Fill in DrawPolygon.

Calculate

What's New:

Added support for sheet ranges. Setting the new property CalcEngine.SupportsSheetRanges to true makes the engine supports sheet ranges like =SUM(Sheet1:Sheet3!A1) and =SUM(Sheet1:Sheet3!A1:B4). CalcEngine.GetValueFromArg has been made virtual to allow access to the processing of function arguments during computations. CalQuick.CreateEngine is a new virtual method that allows for the use of derived CalcEngine objects within a derived CalcQuick class.

HTMLUI

What's Fixed:

CSS header style not affected, when changed at run time using the InnerHTML property. Vertical alignment for the 'tr' tag is not rendered properly in the HTMLUI Control. Double Click event is not raised for the IHTMLElement objects. OuterHTML is not get updated when an attribute from an HTML element is removed. Print and PrintPreview does not show the custom control in the second preview page. Printer prints a page by splitting the images between bottom of one page and top of another page.

XlsIO

What's New:

Support for gradients and textures in chart. Autosizing comments. ExcelExportDataTableOptions.DetectColumnTypes has been added to detect column types. IHFEngine interface has been added to create/edit strings required by header/footer. IWorksheets.AddCopyAfter() and IWorksheets.AddCopyBefore() methods have been added to position worksheets after copying them. Support for charts with templatemarkers. Import datatable to a named range. IRange.BorderAround, IRange.BorderInside and IRange.BorderNone properties have been added to support inserting borders around ranges.

What's Fixed:

Fixed issue with image in the copied sheet getting resized. Fixed issue with copying worksheet between workbooks [Japanese] Background color disappears in pictures when template was modified using XlsIO. PrintTitleRow settings not getting copied over when a worksheet is copied into another workbook. Fixed issues with applying multiple conditional formatting to intersecting ranges.

DocIO

What's New:

Support for navigation through the bookmarks in a template document and to insert paragraph items such as text, tables and images into the bookmarks. Insert images to the Header/Footer section of a document. Insert RTL (Right to Left) language text to a document. Support for setting paragraph tab stop width position in a document.

What's Fixed:

Preservation of Bookmarks, Images, Custom Properties, Date fields in a template document. Fixed issues with table border lines conversion to PDF. Fixed issues with cloning and merging template documents bigger than 2MB. Preservation of a paragraph text having a specific heading style. Find and replace functionality where place holder text has one or two tab spaces in a template document.

PDF

What's New:

Column overflow support. Merging table cells in grid model. Booklets support. Reading and Writing XMP tags. Support for modifying LZW encoded PDF documents. Enhanced support for TIFF images.

What's Fixed:

Digital signature issuer name conflict and multiple signing. Fixed issues with HTML to PDF conversion in VS2005. Fixed issues with horizontal merging of table cells in flow model. Fixed issues with Page number in Cliprectangle overload. Fixed issues with table default width, table underlined header text and table position

Calculate

What's New:

Overload of PullUpdatedValue. Bench marking calculations in debug library builds. OffSet function added. Index and Match functions added. Support for using ranges as binary operands. Must set CalcEngine.SupportRangeOperands property to enable this support. ActiveCell, SupportRangeOperands and UseDatesInCalculations properties.

What's Fixed:

Empty cells are not being treated as false in logical calculations. Formulas are incorrectly being marked as having circular references. If calculated result returns an value that is expressed in exponential notation and this value is passed to another function, an invalid argument error results. Problem in SumIf calculation if criteria is a reference.

HTMLUI

What's New:

FindDialog to show the text selected in the control inside the textbox as like in VisualStudio. Ctrl+C keyboard shortcut to copy the text.

What's Fixed:

Document.BeginUpdate() method has no effect. Any change to the html elements displayed in the document making the control to scroll up to the top. Problem with the difference in the positioning of the OL list items. Problem with the p tag inside the li tag is displayed in the next line of the bullet. Improper tab cycling through the input tags.

XlsIO

What's New:

Exporting boolean values from worksheet when using ExportDataTable method. Formatting text in Header and Footer.IHFEngine that can parse, create, edit strings requir