Reporting Edition

Fixes

#7868: Parsing function arguments now work when the first character in a literal string argument is a comma.
#7869: The Concatenate function will now strip interior quotes for string arguments containing embedded quotes.

Features

#4799 - Support has been added for creating and manipulating Word 2010 files based on the Word 2010 schema.

Fixes

#4162 - The issue concerning lines being marked for deletion in certain Word documents has been fixed.
#4752, #4899, #4968, #5872 - The issue with retrieving merge fields in a document has been fixed
#4814 - The issue with preserving table size has been fixed.
#4849 - An exception is no longer thrown when opening a DocIO-generated document using VSTO.
#4888 - An "Index out of Range" exception is no longer thrown when opening a document.
#5010 - The issue with parsing the table header property for Word (97-2003) has been fixed.
#5025, #5653 - The issue with preserving custom document properties has been fixed.
#5053 - The issue with preserving styles for a particular Word document has been fixed.
#5091 - The issue with the BookmarkNavigator.InsertParagraph method has been corrected.
#5333 - The issue with paragraph justification in a Word document after cloning has been fixed.
#5503 - The issue has been fixed with page orientation that was caused when adding a new section.
#5538 - List preservation when resaving a document to Word 2007 format has been corrected.
#5569 - The issue with applying a cell border to an existing table has been fixed
#5575 - The issue concerning table alignment after cloning a Word document has been fixed.
#5637 - The paragraph format properties "SpaceAfterAuto" and "SpaceBeforeAuto" have been added.
#5669 - A word document will no longer be corrupted when saving to Word 2007 format.
#5946 - The preservation of font substitution information in Word (97-2003) has been corrected.
#4034, #4867, #4869, #4870, #4883, #4884, #4894, #4909, #4950, #5056, #5140, #5355, #5730 - Formatting issues have been fixed regarding importing HTML content into a Word document.
#5167 - Formatting issues during Word to HTML conversion have been fixed.
#3373, #4737, #4740, #4762, #4901, #4954, #4977, #4989, #5112, #5156, #5169, #5186, #5308, #5238, #5281, #5286, #5287, #5379, #5588, #5625, #5947, #5273, #5843, #5682, #5262, #5513 - Formatting issues during Word to PDF conversion have been fixed.
#5203, #5426, #5488, #5661, #5301 - Formatting issues during RTF to Word conversion have been fixed.
#5527 - Formatting issues during Word to RTF conversion have been fixed.
#5023 - An exception is no longer thrown during text to Word conversion.
#5027 - An extra empty paragraph will no longer be added during text to Word conversion.
#4880 - Headers and footers will now be correctly preserved during Word to text conversion.

Features

#5313 - Support for time-stamping a digital signature has been added.
#5041 - Support for 128- and 256-bit AES encryption has been added.
#5266 - Support for collapsing the bookmark tree of a document has been added.

Fixes

#5723 - Multiple selections can now be made using PdfLoadedListBoxField.
#4914 - PdfPage height will no longer be returned as a negative value.
#5416 - Alignments can now be set for nested PDF grid cells.
#4642 - When a table row splits across pages, the euro symbol in the second page will no longer be returned as question marks.
#5725 - Pages are now removed in the correct order from PdfLoadedDocument.
#5414 - The ImportPageRange method no longer hangs if the PDF document has empty bytes at the end.
#5847 - An "illegal header check sum" exception is no longer thrown when decrypting documents in Acrobat 6.0 standards.
#5532 - The pages of the merged documents will now be preserved.
#5351 - Height of the PdfGrid row no longer increases if text length is larger.
#5273 - Paper size is now preserved properly when converting a Word document to a PDF.
#5187 - The size of the check mark of the PdfCheckBoxField can now be changed.
#5155 - Location of the PdfLoadedTextWebLink annotation can now be retrieved properly.
#5291 - Bookmarks can now be inserted at the zero index position.
#5314 - Contents are now preserved in documents after a merge operation.
#5154 - Bold text is now preserved in EMF to PDF conversion.
#4964 - A PDF bookmark no longer generates garbage text when merging.
#4829 - Cell border color is now properly applied in PdfGrid.
#4901 - Text formatting issues are now fixed in DOC to PDF conversion.
#2150 - The HTML converter now properly converts HTML to a PDF.
#4803 - Page breaks are now preserved properly in HTML-to-PDF conversion.
#4953 - Image extraction no longer hangs when extracting from specific documents.
#4696 - Row spanning is now properly performed in PdfGrid.
#4635 - Wrapped text in HTML is now preserved properly in HTML-to-PDF conversion.
#4831 - Bookmarks are now preserved properly in documents created with Essential PDF and edited using Acrobat.
#5143 - Issues in EMF-to-PDF conversion have been fixed.
#5361 - Unicode text is now preserved properly in DOC-to-PDF conversion.
#5971 - The pages of an existing PDF document can now be rotated properly.
#5972 - PDF documents are no longer corrupted when converting HTML to a PDF concurrently in multiple threads.

Features

#5312 - Pivot chart support has been implemented.
#5021 - Support for an Option button has been added.
#3528 - Support has been added for chart title shadows.
#5500 - Overloads for the Open and OpenReadOnly methods of IWorkbook has been added.
#5142 - The NameRange property has been added to retrieve the series name range.
#161 - New properties-HasFormulaStringValue and HasFormulaNumberValue-have been added to IRange.
#4827 - The ability to toggle leader lines in pie charts has been added.
#5239 - The ability to compress an XLSX file to reduce size has been added.
#5279 - Excel to Pdf conversion has been enhanced.

Fixes

#5119 - Category axis labels can now be set to "Auto".
#5829 - Sparklines no longer cause a "Not supported" exception to be thrown.
#5717 - Images will now convert properly.
#5662 - XLSM files no longer hang when opening and they no longer throw an exception.
#5646 - Pie charts now appear correctly after refreshing values.
#5597 - Opening a document in Excel 2007 no longer throws an "Excel Reach Unreachable Code" warning.
#5192 - InsertRow no longer freezes an execution.
#5781 - XlsIO now preserves the headings option in the XLTM-XLSM.
#4905 - Cell styles are now displayed properly.
#5779 - An active cell will no longer change when saving XLTM as XLSM.
#5645 - Comments will work properly.
#5213 - Pictures that have "Don't Size" set will no longer resize.
#5710 - An image's alternative text is now correct in HTML.
#4577 - Formulas are now recalculated when opening in Excel.
#5449 - The Excel bold and italicize font buttons now work in an XlsIO generared file.
#5339 - When borders are added, background color of neighboring cells.
#5509 - Locking once cell no longer locks the entire sheet.
#5650 - An "Argument out of Range" exception is no longer thrown when FastRecordParsing is on.
#5425 - An "Argument out of Range" exception is no longer thrown when opening files.
#5413 - Files with images can now be read in MAC OS.
#5165 - The font size of a chart's vertical axis will be preserved when copied from one workbook to another.
#5506 - Formulas will now be computed properly when exported to a data table.
#5539 - Custom cell styles will now be preserved properly.
#5554 - An "Argument Exception" is no longer thrown in Excel2007Border.
#5391 - When changing the color of a series in a chart using XlsIO, that color will persist when opening in Excel 2000.
#5561 - Row and column grand total of a pivot table can now be disabled.
#5570 - An "Argument out of Range" exception is no longer thrown with FastRecordParsing.
#5599 - The PivotTable RowGrand and ColGrand properties now work correctly.
#5497 - XlsIO will preserve cell border settings.
#5589 - A "System Argument out of Range" exception is no longer thrown when opening an XLSX file as a stream from input in an HTML tag.
#5486 - A cross-thread error no longer occurs in XlsIO.
#5124 - AddCopy will now preserve the chart axis properly.
#5225 - An exception is no longer thrown when inserting rows.
#176 - Sheet names are no longer case-sensitive.
#5260 - Shapes will no longer add border color after using AddCopy.
#5277 - Pictures will not appear with borders after resaving.
#5375 - Macro-enabled workbooks will no longer be corrupted.
#5525 - The progress event will now be triggered for XLSX formats.
#5158 - Formulas will now be recalculated when opening in Excel 2002.
#4276 - An XML exception is no longer thrown when opening certain files.
#5394 - After resaving a file with XlsIO, macros accessing the shape will no longer throw an exception.
#5423 - An exception will no longer be thrown when reference text range is larger than data range.
#5163 - The AddCopy method now preserves formulas properly.
#5103 - Page breaks are now preserved and added to an existing sheet.
#5257 - Files with comments are no longer corrupted.
#4611 - Problems with reading the last column of an Excel file have been corrected.
#5149 - The Open method no longer throws an exception when parsing a sheet.
#5270 - A "Not Supported" exception is no longer thrown when opening a file.
#4923 - Cell backgroud colors will now transfer with Worksheets.AddCopy.
#5055 - The sheet Activate() method now works properly.
#5902 - The SaveAs method no longer throws a "Memory Insufficient" exception.
#5008 - When resaving, the chart axis will now be shown in the output.
#4948 - The Insert Row method no longer corrupts an XLS file.
#5018 - The Open method no longer throws a "Key Not Founf" exception.
#4962 - Image size is now preserved by the AddPicture method.
#5182 - The SaveAs method no longer throws an exception when serializing tables.
#5083 - Output files are no longer corrupted.
#4999 - Renaming a chart no longer throws an exception.
#5153 - Exceptions will no longer be thrown in heaps when XlsIO is multi-threaded.
#4969 - Files are no longer corrupted when saving as Excel 2003 to Excel 2007.
#4928 - Accounting number text is now valid.
#5081 - XlsIO no longer throws an "Unexpected XML Tag" exception.
#4940 - The visibility of axis unit labels will now be preserved.
#4915 - The SaveAs method no longer throws an "Argument out of Range" exception.
#4564 - Problems with the chart title have been corrected.
#5102 - XLSM files will no longer be corrupted.
#5126 - Files no longer hang when opened using XlsIO.
#4984 - Chart formatting will no longer be lost.
#4924 - XlsIO will now parse custom number formats.
#4983 - Chart titles no longer throw an error.
#4903 - OpenFromXML no longer throws an exception.
#5090 - Textbox background color will now be preserved.
#4569 - Title and plot area will now be preserved properly.
#4904 - XlsIO will now parse XML files with number values.
#4836 - Files with VSTO code no longer throw and exception.
#4878 - XlsIO will now recognize the cell contents of an XML file.
#4770 - Output files are no longer corrupted.
#4793 - An "Argument out of Range" exception is no longer thrown when opening documents.
#4801 - An exception is no longer thrown when inserting images.
#4945 - XlsIO output file size is now correct.
#4658 - XlsIO pivot tables are not case sensitive, similar to Excel pivot tables.
#4646 - An error is no longer thrown in an Excel output file when resaving using XlsIO.
#4647 - With RTF text in cells, text color can now be changed to "Auto" in a range of cells.
#4794 - An exception is no longer thrown when inserting a row and accessing style.
#4807 - XMLReader no longer throws an exception when reading an XML spreadsheet.
#4902 - Empty string formulas now behave correctly relative to empty string values when importing an XML spreadsheet
#4538 - Writing long text no longer corrupts a file.
#4866 - The "Type Case" exception is no longer thrown.
#4644 - Files are no longer corrupted after setting DV Error text.
#4772 - User-defined formats are now correct.
#4820 - An exception is no longer thrown when opening an saving an XLSX file.
#4795 - Line gradient properties no longer thrown an exception.
#3618 - The problem with formulas not evaluating has been fixed.
#4625 - The "REF!" error no longer occurs when writing formulas.
#4558 - A protected worksheet no longer causes an XLS file to open in a protected view.

Fixes

#4411 - The issue has been resolved concerning enum-type fields in a complex field not being initialized.
#5301 - The issue with number-string expressions has been resolved.

Fixes

#7868: Parsing function arguments now work when the first character in a literal string argument is a comma.
#7869: The Concatenate function will now strip interior quotes for string arguments containing embedded quotes.

Features

#4799 - Support has been added for creating and manipulating Word 2010 files based on the Word 2010 schema.

Fixes

#4162 - The issue concerning lines being marked for deletion in certain Word documents has been fixed.
#4752, #4899, #4968, #5872 - The issue with retrieving merge fields in a document has been fixed
#4814 - The issue with preserving table size has been fixed.
#4849 - An exception is no longer thrown when opening a DocIO-generated document using VSTO.
#4888 - An "Index out of Range" exception is no longer thrown when opening a document.
#5010 - The issue with parsing the table header property for Word (97-2003) has been fixed.
#5025, #5653 - The issue with preserving custom document properties has been fixed.
#5053 - The issue with preserving styles for a particular Word document has been fixed.
#5091 - The issue with the BookmarkNavigator.InsertParagraph method has been corrected.
#5333 - The issue with paragraph justification in a Word document after cloning has been fixed.
#5503 - The issue has been fixed with page orientation that was caused when adding a new section.
#5538 - List preservation when resaving a document to Word 2007 format has been corrected.
#5569 - The issue with applying a cell border to an existing table has been fixed
#5575 - The issue concerning table alignment after cloning a Word document has been fixed.
#5637 - The paragraph format properties "SpaceAfterAuto" and "SpaceBeforeAuto" have been added.
#5669 - A word document will no longer be corrupted when saving to Word 2007 format.
#5946 - The preservation of font substitution information in Word (97-2003) has been corrected.
#4034, #4867, #4869, #4870, #4883, #4884, #4894, #4909, #4950, #5056, #5140, #5355, #5730 - Formatting issues have been fixed regarding importing HTML content into a Word document.
#5167 - Formatting issues during Word to HTML conversion have been fixed.
#3373, #4737, #4740, #4762, #4901, #4954, #4977, #4989, #5112, #5156, #5169, #5186, #5308, #5238, #5281, #5286, #5287, #5379, #5588, #5625, #5947, #5273, #5843, #5682, #5262, #5513 - Formatting issues during Word to PDF conversion have been fixed.
#5203, #5426, #5488, #5661, #5301 - Formatting issues during RTF to Word conversion have been fixed.
#5527 - Formatting issues during Word to RTF conversion have been fixed.
#5023 - An exception is no longer thrown during text to Word conversion.
#5027 - An extra empty paragraph will no longer be added during text to Word conversion.
#4880 - Headers and footers will now be correctly preserved during Word to text conversion.

Features

#5313 - Support for time-stamping a digital signature has been added.
#5041 - Support for 128- and 256-bit AES encryption has been added.
#5266 - Support for collapsing the bookmark tree of a document has been added.

Fixes

#5723 - Multiple selections can now be made using PdfLoadedListBoxField.
#4914 - PdfPage height will no longer be returned as a negative value.
#5416 - Alignments can now be set for nested PDF grid cells.
#4642 - When a table row splits across pages, the euro symbol in the second page will no longer be returned as question marks.
#5725 - Pages are now removed in the correct order from PdfLoadedDocument.
#5414 - The ImportPageRange method no longer hangs if the PDF document has empty bytes at the end.
#5847 - An "illegal header check sum" exception is no longer thrown when decrypting documents in Acrobat 6.0 standards.
#5532 - The pages of the merged documents will now be preserved.
#5351 - Height of the PdfGrid row no longer increases if text length is larger.
#5273 - Paper size is now preserved properly when converting a Word document to a PDF.
#5187 - The size of the check mark of the PdfCheckBoxField can now be changed.
#5155 - Location of the PdfLoadedTextWebLink annotation can now be retrieved properly.
#5291 - Bookmarks can now be inserted at the zero index position.
#5314 - Contents are now preserved in documents after a merge operation.
#5154 - Bold text is now preserved in EMF to PDF conversion.
#4964 - A PDF bookmark no longer generates garbage text when merging.
#4829 - Cell border color is now properly applied in PdfGrid.
#4901 - Text formatting issues are now fixed in DOC to PDF conversion.
#2150 - The HTML converter now properly converts HTML to a PDF.
#4803 - Page breaks are now preserved properly in HTML-to-PDF conversion.
#4953 - Image extraction no longer hangs when extracting from specific documents.
#4696 - Row spanning is now properly performed in PdfGrid.
#4635 - Wrapped text in HTML is now preserved properly in HTML-to-PDF conversion.
#4831 - Bookmarks are now preserved properly in documents created with Essential PDF and edited using Acrobat.
#5143 - Issues in EMF-to-PDF conversion have been fixed.
#5361 - Unicode text is now preserved properly in DOC-to-PDF conversion.
#5971 - The pages of an existing PDF document can now be rotated properly.
#5972 - PDF documents are no longer corrupted when converting HTML to a PDF concurrently in multiple threads.

Features

#5312 - Pivot chart support has been implemented.
#5021 - Support for an Option button has been added.
#3528 - Support has been added for chart title shadows.
#5500 - Overloads for the Open and OpenReadOnly methods of IWorkbook has been added.
#5142 - The NameRange property has been added to retrieve the series name range.
#161 - New properties-HasFormulaStringValue and HasFormulaNumberValue-have been added to IRange.
#4827 - The ability to toggle leader lines in pie charts has been added.
#5239 - The ability to compress an XLSX file to reduce size has been added.
#5279 - Excel to Pdf conversion has been enhanced.

Fixes

#5119 - Category axis labels can now be set to "Auto".
#5829 - Sparklines no longer cause a "Not supported" exception to be thrown.
#5717 - Images will now convert properly.
#5662 - XLSM files no longer hang when opening and they no longer throw an exception.
#5646 - Pie charts now appear correctly after refreshing values.
#5597 - Opening a document in Excel 2007 no longer throws an "Excel Reach Unreachable Code" warning.
#5192 - InsertRow no longer freezes an execution.
#5781 - XlsIO now preserves the headings option in the XLTM-XLSM.
#4905 - Cell styles are now displayed properly.
#5779 - An active cell will no longer change when saving XLTM as XLSM.
#5645 - Comments will work properly.
#5213 - Pictures that have "Don't Size" set will no longer resize.
#5710 - An image's alternative text is now correct in HTML.
#4577 - Formulas are now recalculated when opening in Excel.
#5449 - The Excel bold and italicize font buttons now work in an XlsIO generared file.
#5339 - When borders are added, background color of neighboring cells.
#5509 - Locking once cell no longer locks the entire sheet.
#5650 - An "Argument out of Range" exception is no longer thrown when FastRecordParsing is on.
#5425 - An "Argument out of Range" exception is no longer thrown when opening files.
#5413 - Files with images can now be read in MAC OS.
#5165 - The font size of a chart's vertical axis will be preserved when copied from one workbook to another.
#5506 - Formulas will now be computed properly when exported to a data table.
#5539 - Custom cell styles will now be preserved properly.
#5554 - An "Argument Exception" is no longer thrown in Excel2007Border.
#5391 - When changing the color of a series in a chart using XlsIO, that color will persist when opening in Excel 2000.
#5561 - Row and column grand total of a pivot table can now be disabled.
#5570 - An "Argument out of Range" exception is no longer thrown with FastRecordParsing.
#5599 - The PivotTable RowGrand and ColGrand properties now work correctly.
#5497 - XlsIO will preserve cell border settings.
#5589 - A "System Argument out of Range" exception is no longer thrown when opening an XLSX file as a stream from input in an HTML tag.
#5486 - A cross-thread error no longer occurs in XlsIO.
#5124 - AddCopy will now preserve the chart axis properly.
#5225 - An exception is no longer thrown when inserting rows.
#176 - Sheet names are no longer case-sensitive.
#5260 - Shapes will no longer add border color after using AddCopy.
#5277 - Pictures will not appear with borders after resaving.
#5375 - Macro-enabled workbooks will no longer be corrupted.
#5525 - The progress event will now be triggered for XLSX formats.
#5158 - Formulas will now be recalculated when opening in Excel 2002.
#4276 - An XML exception is no longer thrown when opening certain files.
#5394 - After resaving a file with XlsIO, macros accessing the shape will no longer throw an exception.
#5423 - An exception will no longer be thrown when reference text range is larger than data range.
#5163 - The AddCopy method now preserves formulas properly.
#5103 - Page breaks are now preserved and added to an existing sheet.
#5257 - Files with comments are no longer corrupted.
#4611 - Problems with reading the last column of an Excel file have been corrected.
#5149 - The Open method no longer throws an exception when parsing a sheet.
#5270 - A "Not Supported" exception is no longer thrown when opening a file.
#4923 - Cell backgroud colors will now transfer with Worksheets.AddCopy.
#5055 - The sheet Activate() method now works properly.
#5902 - The SaveAs method no longer throws a "Memory Insufficient" exception.
#5008 - When resaving, the chart axis will now be shown in the output.
#4948 - The Insert Row method no longer corrupts an XLS file.
#5018 - The Open method no longer throws a "Key Not Founf" exception.
#4962 - Image size is now preserved by the AddPicture method.
#5182 - The SaveAs method no longer throws an exception when serializing tables.
#5083 - Output files are no longer corrupted.
#4999 - Renaming a chart no longer throws an exception.
#5153 - Exceptions will no longer be thrown in heaps when XlsIO is multi-threaded.
#4969 - Files are no longer corrupted when saving as Excel 2003 to Excel 2007.
#4928 - Accounting number text is now valid.
#5081 - XlsIO no longer throws an "Unexpected XML Tag" exception.
#4940 - The visibility of axis unit labels will now be preserved.
#4915 - The SaveAs method no longer throws an "Argument out of Range" exception.
#4564 - Problems with the chart title have been corrected.
#5102 - XLSM files will no longer be corrupted.
#5126 - Files no longer hang when opened using XlsIO.
#4984 - Chart formatting will no longer be lost.
#4924 - XlsIO will now parse custom number formats.
#4983 - Chart titles no longer throw an error.
#4903 - OpenFromXML no longer throws an exception.
#5090 - Textbox background color will now be preserved.
#4569 - Title and plot area will now be preserved properly.
#4904 - XlsIO will now parse XML files with number values.
#4836 - Files with VSTO code no longer throw and exception.
#4878 - XlsIO will now recognize the cell contents of an XML file.
#4770 - Output files are no longer corrupted.
#4793 - An "Argument out of Range" exception is no longer thrown when opening documents.
#4801 - An exception is no longer thrown when inserting images.
#4945 - XlsIO output file size is now correct.
#4658 - XlsIO pivot tables are not case sensitive, similar to Excel pivot tables.
#4646 - An error is no longer thrown in an Excel output file when resaving using XlsIO.
#4647 - With RTF text in cells, text color can now be changed to "Auto" in a range of cells.
#4794 - An exception is no longer thrown when inserting a row and accessing style.
#4807 - XMLReader no longer throws an exception when reading an XML spreadsheet.
#4902 - Empty string formulas now behave correctly relative to empty string values when importing an XML spreadsheet
#4538 - Writing long text no longer corrupts a file.
#4866 - The "Type Case" exception is no longer thrown.
#4644 - Files are no longer corrupted after setting DV Error text.
#4772 - User-defined formats are now correct.
#4820 - An exception is no longer thrown when opening an saving an XLSX file.
#4795 - Line gradient properties no longer thrown an exception.
#3618 - The problem with formulas not evaluating has been fixed.
#4625 - The "REF!" error no longer occurs when writing formulas.
#4558 - A protected worksheet no longer causes an XLS file to open in a protected view.

Features

#5083 - Array type property for "Record" class.

Features

#4799 - Support has been added for creating and manipulating Word 2010 files based on the Word 2010 schema.

Fixes

#4162 - The issue concerning lines being marked for deletion in certain Word documents has been fixed.
#4752, #4899, #4968, #5872 - The issue with retrieving merge fields in a document has been fixed
#4814 - The issue with preserving table size has been fixed.
#4849 - An exception is no longer thrown when opening a DocIO-generated document using VSTO.
#4888 - An "Index out of Range" exception is no longer thrown when opening a document.
#5010 - The issue with parsing the table header property for Word (97-2003) has been fixed.
#5025, #5653 - The issue with preserving custom document properties has been fixed.
#5053 - The issue with preserving styles for a particular Word document has been fixed.
#5091 - The issue with the BookmarkNavigator.InsertParagraph method has been corrected.
#5333 - The issue with paragraph justification in a Word document after cloning has been fixed.
#5503 - The issue has been fixed with page orientation that was caused when adding a new section.
#5538 - List preservation when resaving a document to Word 2007 format has been corrected.
#5569 - The issue with applying a cell border to an existing table has been fixed
#5575 - The issue concerning table alignment after cloning a Word document has been fixed.
#5637 - The paragraph format properties "SpaceAfterAuto" and "SpaceBeforeAuto" have been added.
#5669 - A word document will no longer be corrupted when saving to Word 2007 format.
#5946 - The preservation of font substitution information in Word (97-2003) has been corrected.

Features

#5266 - Support for collapsing the bookmark tree of a document has been added.

Fixes

#5723 - Multiple selections can now be made using PdfLoadedListBoxField.
#4914 - PdfPage height will no longer be returned as a negative value.
#5416 - Alignments can now be set for nested PDF grid cells.
#4642 - When a table row splits across pages, the euro symbol in the second page will no longer be returned as question marks.
#5725 - Pages are now removed in the correct order from PdfLoadedDocument.
#5414 - The ImportPageRange method no longer hangs if the PDF document has empty bytes at the end.
#5847 - An "illegal header check sum" exception is no longer thrown when decrypting documents in Acrobat 6.0 standards.
#5532 - The pages of the merged documents will now be preserved.
#5351 - Height of the PdfGrid row no longer increases if text length is larger.
#5273 - Paper size is now preserved properly when converting a Word document to a PDF.
#5187 - The size of the check mark of the PdfCheckBoxField can now be changed.
#5155 - Location of the PdfLoadedTextWebLink annotation can now be retrieved properly.
#5291 - Bookmarks can now be inserted at the zero index position.
#5314 - Contents are now preserved in documents after a merge operation.
#5154 - Bold text is now preserved in EMF to PDF conversion.
#4964 - A PDF bookmark no longer generates garbage text when merging.
#4829 - Cell border color is now properly applied in PdfGrid.
#4901 - Text formatting issues are now fixed in DOC to PDF conversion.
#2150 - The HTML converter now properly converts HTML to a PDF.
#4803 - Page breaks are now preserved properly in HTML-to-PDF conversion.
#4953 - Image extraction no longer hangs when extracting from specific documents.
#4696 - Row spanning is now properly performed in PdfGrid.
#4635 - Wrapped text in HTML is now preserved properly in HTML-to-PDF conversion.
#4831 - Bookmarks are now preserved properly in documents created with Essential PDF and edited using Acrobat.
#5143 - Issues in EMF-to-PDF conversion have been fixed.
#5361 - Unicode text is now preserved properly in DOC-to-PDF conversion.
#5971 - The pages of an existing PDF document can now be rotated properly.
#5972 - PDF documents are no longer corrupted when converting HTML to a PDF concurrently in multiple threads.

Features

#5312 - Pivot chart support has been implemented.
#5021 - Support for an Option button has been added.
#3528 - Support has been added for chart title shadows.
#5500 - Overloads for the Open and OpenReadOnly methods of IWorkbook has been added.
#5142 - The NameRange property has been added to retrieve the series name range.
#161 - New properties-HasFormulaStringValue and HasFormulaNumberValue-have been added to IRange.
#4827 - The ability to toggle leader lines in pie charts has been added.
#5239 - The ability to compress an XLSX file to reduce size has been added.

Fixes

#5119 - Category axis labels can now be set to "Auto".
#5144 - The issue with the image stream in Silverlight being unsupported or invalid has been fixed.
#4774 - Excel files now open properly in Silverlight.
#5829 - Sparklines no longer cause a "Not supported" exception to be thrown.
#5717 - Images will now convert properly.
#5662 - XLSM files no longer hang when opening and they no longer throw an exception.
#4640 - The open method no longer throws an exception in Silverlight.
#5646 - Pie charts now appear correctly after refreshing values.
#5597 - Opening a document in Excel 2007 no longer throws an "Excel Reach Unreachable Code" warning.
#5192 - InsertRow no longer freezes an execution.
#5781 - XlsIO now preserves the headings option in the XLTM-XLSM.
#4905 - Cell styles are now displayed properly.
#5779 - An active cell will no longer change when saving XLTM as XLSM.
#5645 - Comments will work properly.
#5213 - Pictures that have "Don't Size" set will no longer resize.
#5710 - An image's alternative text is now correct in HTML.
#4577 - Formulas are now recalculated when opening in Excel.
#5449 - The Excel bold and italicize font buttons now work in an XlsIO generared file.
#5339 - When borders are added, background color of neighboring cells.
#5509 - Locking once cell no longer locks the entire sheet.
#5650 - An "Argument out of Range" exception is no longer thrown when FastRecordParsing is on.
#5425 - An "Argument out of Range" exception is no longer thrown when opening files.
#5413 - Files with images can now be read in MAC OS.
#5165 - The font size of a chart's vertical axis will be preserved when copied from one workbook to another.
#5506 - Formulas will now be computed properly when exported to a data table.
#5539 - Custom cell styles will now be preserved properly.
#5554 - An "Argument Exception" is no longer thrown in Excel2007Border.
#5391 - When changing the color of a series in a chart using XlsIO, that color will persist when opening in Excel 2000.
#5561 - Row and column grand total of a pivot table can now be disabled.
#5570 - An "Argument out of Range" exception is no longer thrown with FastRecordParsing.
#5599 - The PivotTable RowGrand and ColGrand properties now work correctly.
#5497 - XlsIO will preserve cell border settings.
#5589 - A "System Argument out of Range" exception is no longer thrown when opening an XLSX file as a stream from input in an HTML tag.
#5486 - A cross-thread error no longer occurs in XlsIO.
#5124 - AddCopy will now preserve the chart axis properly.
#5225 - An exception is no longer thrown when inserting rows.
#176 - Sheet names are no longer case-sensitive.
#5260 - Shapes will no longer add border color after using AddCopy.
#5277 - Pictures will not appear with borders after resaving.
#5375 - Macro-enabled workbooks will no longer be corrupted.
#5525 - The progress event will now be triggered for XLSX formats.
#5158 - Formulas will now be recalculated when opening in Excel 2002.
#4276 - An XML exception is no longer thrown when opening certain files.
#5394 - After resaving a file with XlsIO, macros accessing the shape will no longer throw an exception.
#5423 - An exception will no longer be thrown when reference text range is larger than data range.
#5163 - The AddCopy method now preserves formulas properly.
#5103 - Page breaks are now preserved and added to an existing sheet.
#5257 - Files with comments are no longer corrupted.
#4611 - Problems with reading the last column of an Excel file have been corrected.
#5149 - The Open method no longer throws an exception when parsing a sheet.
#5270 - A "Not Supported" exception is no longer thrown when opening a file.
#4923 - Cell backgroud colors will now transfer with Worksheets.AddCopy.
#5055 - The sheet Activate() method now works properly.
#5902 - The SaveAs method no longer throws a "Memory Insufficient" exception.
#5008 - When resaving, the chart axis will now be shown in the output.
#4948 - The Insert Row method no longer corrupts an XLS file.
#5018 - The Open method no longer throws a "Key Not Founf" exception.
#4962 - Image size is now preserved by the AddPicture method.
#5182 - The SaveAs method no longer throws an exception when serializing tables.
#5083 - Output files are no longer corrupted.
#4999 - Renaming a chart no longer throws an exception.
#5153 - Exceptions will no longer be thrown in heaps when XlsIO is multi-threaded.
#4969 - Files are no longer corrupted when saving as Excel 2003 to Excel 2007.
#4928 - Accounting number text is now valid.
#5081 - XlsIO no longer throws an "Unexpected XML Tag" exception.
#4940 - The visibility of axis unit labels will now be preserved.
#4915 - The SaveAs method no longer throws an "Argument out of Range" exception.
#4564 - Problems with the chart title have been corrected.
#5102 - XLSM files will no longer be corrupted.
#5126 - Files no longer hang when opened using XlsIO.
#4984 - Chart formatting will no longer be lost.
#4924 - XlsIO will now parse custom number formats.
#4983 - Chart titles no longer throw an error.
#4903 - OpenFromXML no longer throws an exception.
#5090 - Textbox background color will now be preserved.
#4569 - Title and plot area will now be preserved properly.
#4904 - XlsIO will now parse XML files with number values.
#4836 - Files with VSTO code no longer throw and exception.
#4878 - XlsIO will now recognize the cell contents of an XML file.
#4770 - Output files are no longer corrupted.
#4793 - An "Argument out of Range" exception is no longer thrown when opening documents.
#4801 - An exception is no longer thrown when inserting images.
#4945 - XlsIO output file size is now correct.
#4658 - XlsIO pivot tables are not case sensitive, similar to Excel pivot tables.
#4646 - An error is no longer thrown in an Excel output file when resaving using XlsIO.
#4647 - With RTF text in cells, text color can now be changed to "Auto" in a range of cells.
#4794 - An exception is no longer thrown when inserting a row and accessing style.
#4807 - XMLReader no longer throws an exception when reading an XML spreadsheet.
#4902 - Empty string formulas now behave correctly relative to empty string values when importing an XML spreadsheet
#4538 - Writing long text no longer corrupts a file.
#4866 - The "Type Case" exception is no longer thrown.
#4644 - Files are no longer corrupted after setting DV Error text.
#4772 - User-defined formats are now correct.
#4820 - An exception is no longer thrown when opening an saving an XLSX file.
#4795 - Line gradient properties no longer thrown an exception.
#3618 - The problem with formulas not evaluating has been fixed.
#4625 - The "REF!" error no longer occurs when writing formulas.
#4558 - A protected worksheet no longer causes an XLS file to open in a protected view.

Fixes

#4931 - The calculate functions NORMSINV and NORMSDIST no longer return incorrect results.
#5214 - Formulas with NamedRanges now return correct values.
#5320 - ROUND function no longer return incorrect result.

Features

#4799 - Support has been added for creating and manipulating Word 2010 files based on the Word 2010 schema.

Fixes

#4162 - The issue concerning lines being marked for deletion in certain Word documents has been fixed.
#4752, #4899, #4968, #5872 - The issue with retrieving merge fields in a document has been fixed
#4814 - The issue with preserving table size has been fixed.
#4849 - An exception is no longer thrown when opening a DocIO-generated document using VSTO.
#4888 - An "Index out of Range" exception is no longer thrown when opening a document.
#5010 - The issue with parsing the table header property for Word (97-2003) has been fixed.
#5025, #5653 - The issue with preserving custom document properties has been fixed.
#5053 - The issue with preserving styles for a particular Word document has been fixed.
#5091 - The issue with the BookmarkNavigator.InsertParagraph method has been corrected.
#5333 - The issue with paragraph justification in a Word document after cloning has been fixed.
#5503 - The issue has been fixed with page orientation that was caused when adding a new section.
#5538 - List preservation when resaving a document to Word 2007 format has been corrected.
#5569 - The issue with applying a cell border to an existing table has been fixed
#5575 - The issue concerning table alignment after cloning a Word document has been fixed.
#5637 - The paragraph format properties "SpaceAfterAuto" and "SpaceBeforeAuto" have been added.
#5669 - A word document will no longer be corrupted when saving to Word 2007 format.
#5946 - The preservation of font substitution information in Word (97-2003) has been corrected.
#4034, #4867, #4869, #4870, #4883, #4884, #4894, #4909, #4950, #5056, #5140, #5355, #5730 - Formatting issues have been fixed regarding importing HTML content into a Word document.
#5167 - Formatting issues during Word to HTML conversion have been fixed.
#3373, #4737, #4740, #4762, #4901, #4954, #4977, #4989, #5112, #5156, #5169, #5186, #5308, #5238, #5281, #5286, #5287, #5379, #5588, #5625, #5947, #5273, #5843, #5682, #5262, #5513 - Formatting issues during Word to PDF conversion have been fixed.
#5203, #5426, #5488, #5661, #5301 - Formatting issues during RTF to Word conversion have been fixed.
#5527 - Formatting issues during Word to RTF conversion have been fixed.
#5023 - An exception is no longer thrown during text to Word conversion.
#5027 - An extra empty paragraph will no longer be added during text to Word conversion.
#4880 - Headers and footers will now be correctly preserved during Word to text conversion.

Features

#5313 - Support for time-stamping a digital signature has been added.
#5041 - Support for 128- and 256-bit AES encryption has been added.
#5266 - Support for collapsing the bookmark tree of a document has been added.

Fixes

#5723 - Multiple selections can now be made using PdfLoadedListBoxField.
#4914 - PdfPage height will no longer be returned as a negative value.
#5416 - Alignments can now be set for nested PDF grid cells.
#4642 - When a table row splits across pages, the euro symbol in the second page will no longer be returned as question marks.
#5725 - Pages are now removed in the correct order from PdfLoadedDocument.
#5414 - The ImportPageRange method no longer hangs if the PDF document has empty bytes at the end.
#5847 - An "illegal header check sum" exception is no longer thrown when decrypting documents in Acrobat 6.0 standards.
#5532 - The pages of the merged documents will now be preserved.
#5351 - Height of the PdfGrid row no longer increases if text length is larger.
#5273 - Paper size is now preserved properly when converting a Word document to a PDF.
#5187 - The size of the check mark of the PdfCheckBoxField can now be changed.
#5155 - Location of the PdfLoadedTextWebLink annotation can now be retrieved properly.
#5291 - Bookmarks can now be inserted at the zero index position.
#5314 - Contents are now preserved in documents after a merge operation.
#5154 - Bold text is now preserved in EMF to PDF conversion.
#4964 - A PDF bookmark no longer generates garbage text when merging.
#4829 - Cell border color is now properly applied in PdfGrid.
#4901 - Text formatting issues are now fixed in DOC to PDF conversion.
#2150 - The HTML converter now properly converts HTML to a PDF.
#4803 - Page breaks are now preserved properly in HTML-to-PDF conversion.
#4953 - Image extraction no longer hangs when extracting from specific documents.
#4696 - Row spanning is now properly performed in PdfGrid.
#4635 - Wrapped text in HTML is now preserved properly in HTML-to-PDF conversion.
#4831 - Bookmarks are now preserved properly in documents created with Essential PDF and edited using Acrobat.
#5143 - Issues in EMF-to-PDF conversion have been fixed.
#5361 - Unicode text is now preserved properly in DOC-to-PDF conversion.
#5971 - The pages of an existing PDF document can now be rotated properly.
#5972 - PDF documents are no longer corrupted when converting HTML to a PDF concurrently in multiple threads.

Features

#5312 - Pivot chart support has been implemented.
#5021 - Support for an Option button has been added.
#3528 - Support has been added for chart title shadows.
#5500 - Overloads for the Open and OpenReadOnly methods of IWorkbook has been added.
#5142 - The NameRange property has been added to retrieve the series name range.
#161 - New properties-HasFormulaStringValue and HasFormulaNumberValue-have been added to IRange.
#4827 - The ability to toggle leader lines in pie charts has been added.
#5239 - The ability to compress an XLSX file to reduce size has been added.
#5279 - Excel to Pdf conversion has been enhanced.

Fixes

#5119 - Category axis labels can now be set to "Auto".
#5829 - Sparklines no longer cause a "Not supported" exception to be thrown.
#5717 - Images will now convert properly.
#5662 - XLSM files no longer hang when opening and they no longer throw an exception.
#5646 - Pie charts now appear correctly after refreshing values.
#5597 - Opening a document in Excel 2007 no longer throws an "Excel Reach Unreachable Code" warning.
#5192 - InsertRow no longer freezes an execution.
#5781 - XlsIO now preserves the headings option in the XLTM-XLSM.
#4905 - Cell styles are now displayed properly.
#5779 - An active cell will no longer change when saving XLTM as XLSM.
#5645 - Comments will work properly.
#5213 - Pictures that have "Don't Size" set will no longer resize.
#5710 - An image's alternative text is now correct in HTML.
#4577 - Formulas are now recalculated when opening in Excel.
#5449 - The Excel bold and italicize font buttons now work in an XlsIO generared file.
#5339 - When borders are added, background color of neighboring cells.
#5509 - Locking once cell no longer locks the entire sheet.
#5650 - An "Argument out of Range" exception is no longer thrown when FastRecordParsing is on.
#5425 - An "Argument out of Range" exception is no longer thrown when opening files.
#5413 - Files with images can now be read in MAC OS.
#5165 - The font size of a chart's vertical axis will be preserved when copied from one workbook to another.
#5506 - Formulas will now be computed properly when exported to a data table.
#5539 - Custom cell styles will now be preserved properly.
#5554 - An "Argument Exception" is no longer thrown in Excel2007Border.
#5391 - When changing the color of a series in a chart using XlsIO, that color will persist when opening in Excel 2000.
#5561 - Row and column grand total of a pivot table can now be disabled.
#5570 - An "Argument out of Range" exception is no longer thrown with FastRecordParsing.
#5599 - The PivotTable RowGrand and ColGrand properties now work correctly.
#5497 - XlsIO will preserve cell border settings.
#5589 - A "System Argument out of Range" exception is no longer thrown when opening an XLSX file as a stream from input in an HTML tag.
#5486 - A cross-thread error no longer occurs in XlsIO.
#5124 - AddCopy will now preserve the chart axis properly.
#5225 - An exception is no longer thrown when inserting rows.
#176 - Sheet names are no longer case-sensitive.
#5260 - Shapes will no longer add border color after using AddCopy.
#5277 - Pictures will not appear with borders after resaving.
#5375 - Macro-enabled workbooks will no longer be corrupted.
#5525 - The progress event will now be triggered for XLSX formats.
#5158 - Formulas will now be recalculated when opening in Excel 2002.
#4276 - An XML exception is no longer thrown when opening certain files.
#5394 - After resaving a file with XlsIO, macros accessing the shape will no longer throw an exception.
#5423 - An exception will no longer be thrown when reference text range is larger than data range.
#5163 - The AddCopy method now preserves formulas properly.
#5103 - Page breaks are now preserved and added to an existing sheet.
#5257 - Files with comments are no longer corrupted.
#4611 - Problems with reading the last column of an Excel file have been corrected.
#5149 - The Open method no longer throws an exception when parsing a sheet.
#5270 - A "Not Supported" exception is no longer thrown when opening a file.
#4923 - Cell backgroud colors will now transfer with Worksheets.AddCopy.
#5055 - The sheet Activate() method now works properly.
#5902 - The SaveAs method no longer throws a "Memory Insufficient" exception.
#5008 - When resaving, the chart axis will now be shown in the output.
#4948 - The Insert Row method no longer corrupts an XLS file.
#5018 - The Open method no longer throws a "Key Not Founf" exception.
#4962 - Image size is now preserved by the AddPicture method.
#5182 - The SaveAs method no longer throws an exception when serializing tables.
#5083 - Output files are no longer corrupted.
#4999 - Renaming a chart no longer throws an exception.
#5153 - Exceptions will no longer be thrown in heaps when XlsIO is multi-threaded.
#4969 - Files are no longer corrupted when saving as Excel 2003 to Excel 2007.
#4928 - Accounting number text is now valid.
#5081 - XlsIO no longer throws an "Unexpected XML Tag" exception.
#4940 - The visibility of axis unit labels will now be preserved.
#4915 - The SaveAs method no longer throws an "Argument out of Range" exception.
#4564 - Problems with the chart title have been corrected.
#5102 - XLSM files will no longer be corrupted.
#5126 - Files no longer hang when opened using XlsIO.
#4984 - Chart formatting will no longer be lost.
#4924 - XlsIO will now parse custom number formats.
#4983 - Chart titles no longer throw an error.
#4903 - OpenFromXML no longer throws an exception.
#5090 - Textbox background color will now be preserved.
#4569 - Title and plot area will now be preserved properly.
#4904 - XlsIO will now parse XML files with number values.
#4836 - Files with VSTO code no longer throw and exception.
#4878 - XlsIO will now recognize the cell contents of an XML file.
#4770 - Output files are no longer corrupted.
#4793 - An "Argument out of Range" exception is no longer thrown when opening documents.
#4801 - An exception is no longer thrown when inserting images.
#4945 - XlsIO output file size is now correct.
#4658 - XlsIO pivot tables are not case sensitive, similar to Excel pivot tables.
#4646 - An error is no longer thrown in an Excel output file when resaving using XlsIO.
#4647 - With RTF text in cells, text color can now be changed to "Auto" in a range of cells.
#4794 - An exception is no longer thrown when inserting a row and accessing style.
#4807 - XMLReader no longer throws an exception when reading an XML spreadsheet.
#4902 - Empty string formulas now behave correctly relative to empty string values when importing an XML spreadsheet
#4538 - Writing long text no longer corrupts a file.
#4866 - The "Type Case" exception is no longer thrown.
#4644 - Files are no longer corrupted after setting DV Error text.
#4772 - User-defined formats are now correct.
#4820 - An exception is no longer thrown when opening an saving an XLSX file.
#4795 - Line gradient properties no longer thrown an exception.
#3618 - The problem with formulas not evaluating has been fixed.
#4625 - The "REF!" error no longer occurs when writing formulas.
#4558 - A protected worksheet no longer causes an XLS file to open in a protected view.

Fixes

#4186 - The problem has been fixed concerning adding or deleting records with the UseLazyUniformChildListRelation setting.
#4996 - The issue in RecordFilter with trailing white space in the grouping engine has been fixed.

Features

#4799 - Support has been added for creating and manipulating Word 2010 files based on the Word 2010 schema.

Fixes

#4162 - The issue concerning lines being marked for deletion in certain Word documents has been fixed.
#4752, #4899, #4968, #5872 - The issue with retrieving merge fields in a document has been fixed
#4814 - The issue with preserving table size has been fixed.
#4849 - An exception is no longer thrown when opening a DocIO-generated document using VSTO.
#4888 - An "Index out of Range" exception is no longer thrown when opening a document.
#5010 - The issue with parsing the table header property for Word (97-2003) has been fixed.
#5025, #5653 - The issue with preserving custom document properties has been fixed.
#5053 - The issue with preserving styles for a particular Word document has been fixed.
#5091 - The issue with the BookmarkNavigator.InsertParagraph method has been corrected.
#5333 - The issue with paragraph justification in a Word document after cloning has been fixed.
#5503 - The issue has been fixed with page orientation that was caused when adding a new section.
#5538 - List preservation when resaving a document to Word 2007 format has been corrected.
#5569 - The issue with applying a cell border to an existing table has been fixed
#5575 - The issue concerning table alignment after cloning a Word document has been fixed.
#5637 - The paragraph format properties "SpaceAfterAuto" and "SpaceBeforeAuto" have been added.
#5669 - A word document will no longer be corrupted when saving to Word 2007 format.
#5946 - The preservation of font substitution information in Word (97-2003) has been corrected.
#4034, #4867, #4869, #4870, #4883, #4884, #4894, #4909, #4950, #5056, #5140, #5355, #5730 - Formatting issues have been fixed regarding importing HTML content into a Word document.
#5167 - Formatting issues during Word to HTML conversion have been fixed.
#3373, #4737, #4740, #4762, #4901, #4954, #4977, #4989, #5112, #5156, #5169, #5186, #5308, #5238, #5281, #5286, #5287, #5379, #5588, #5625, #5947, #5273, #5843, #5682, #5262, #5513 - Formatting issues during Word to PDF conversion have been fixed.
#5203, #5426, #5488, #5661, #5301 - Formatting issues during RTF to Word conversion have been fixed.
#5527 - Formatting issues during Word to RTF conversion have been fixed.
#5023 - An exception is no longer thrown during text to Word conversion.
#5027 - An extra empty paragraph will no longer be added during text to Word conversion.
#4880 - Headers and footers will now be correctly preserved during Word to text conversion.

Features

#5313 - Support for time-stamping a digital signature has been added.
#5041 - Support for 128- and 256-bit AES encryption has been added.
#5266 - Support for collapsing the bookmark tree of a document has been added.

Fixes

#5723 - Multiple selections can now be made using PdfLoadedListBoxField.
#4914 - PdfPage height will no longer be returned as a negative value.
#5416 - Alignments can now be set for nested PDF grid cells.
#4642 - When a table row splits across pages, the euro symbol in the second page will no longer be returned as question marks.
#5725 - Pages are now removed in the correct order from PdfLoadedDocument.
#5414 - The ImportPageRange method no longer hangs if the PDF document has empty bytes at the end.
#5847 - An "illegal header check sum" exception is no longer thrown when decrypting documents in Acrobat 6.0 standards.
#5532 - The pages of the merged documents will now be preserved.
#5351 - Height of the PdfGrid row no longer increases if text length is larger.
#5273 - Paper size is now preserved properly when converting a Word document to a PDF.
#5187 - The size of the check mark of the PdfCheckBoxField can now be changed.
#5155 - Location of the PdfLoadedTextWebLink annotation can now be retrieved properly.
#5291 - Bookmarks can now be inserted at the zero index position.
#5314 - Contents are now preserved in documents after a merge operation.
#5154 - Bold text is now preserved in EMF to PDF conversion.
#4964 - A PDF bookmark no longer generates garbage text when merging.
#4829 - Cell border color is now properly applied in PdfGrid.
#4901 - Text formatting issues are now fixed in DOC to PDF conversion.
#2150 - The HTML converter now properly converts HTML to a PDF.
#4803 - Page breaks are now preserved properly in HTML-to-PDF conversion.
#4953 - Image extraction no longer hangs when extracting from specific documents.
#4696 - Row spanning is now properly performed in PdfGrid.
#4635 - Wrapped text in HTML is now preserved properly in HTML-to-PDF conversion.
#4831 - Bookmarks are now preserved properly in documents created with Essential PDF and edited using Acrobat.
#5143 - Issues in EMF-to-PDF conversion have been fixed.
#5361 - Unicode text is now preserved properly in DOC-to-PDF conversion.
#5971 - The pages of an existing PDF document can now be rotated properly.
#5972 - PDF documents are no longer corrupted when converting HTML to a PDF concurrently in multiple threads.

Features

#5312 - Pivot chart support has been implemented.
#5021 - Support for an Option button has been added.
#3528 - Support has been added for chart title shadows.
#5500 - Overloads for the Open and OpenReadOnly methods of IWorkbook has been added.
#5142 - The NameRange property has been added to retrieve the series name range.
#161 - New properties-HasFormulaStringValue and HasFormulaNumberValue-have been added to IRange.
#4827 - The ability to toggle leader lines in pie charts has been added.
#5239 - The ability to compress an XLSX file to reduce size has been added.
#5279 - Excel to Pdf conversion has been enhanced.

Fixes

#5119 - Category axis labels can now be set to "Auto".
#5829 - Sparklines no longer cause a "Not supported" exception to be thrown.
#5717 - Images will now convert properly.
#5662 - XLSM files no longer hang when opening and they no longer throw an exception.
#5646 - Pie charts now appear correctly after refreshing values.
#5597 - Opening a document in Excel 2007 no longer throws an "Excel Reach Unreachable Code" warning.
#5192 - InsertRow no longer freezes an execution.
#5781 - XlsIO now preserves the headings option in the XLTM-XLSM.
#4905 - Cell styles are now displayed properly.
#5779 - An active cell will no longer change when saving XLTM as XLSM.
#5645 - Comments will work properly.
#5213 - Pictures that have "Don't Size" set will no longer resize.
#5710 - An image's alternative text is now correct in HTML.
#4577 - Formulas are now recalculated when opening in Excel.
#5449 - The Excel bold and italicize font buttons now work in an XlsIO generared file.
#5339 - When borders are added, background color of neighboring cells.
#5509 - Locking once cell no longer locks the entire sheet.
#5650 - An "Argument out of Range" exception is no longer thrown when FastRecordParsing is on.
#5425 - An "Argument out of Range" exception is no longer thrown when opening files.
#5413 - Files with images can now be read in MAC OS.
#5165 - The font size of a chart's vertical axis will be preserved when copied from one workbook to another.
#5506 - Formulas will now be computed properly when exported to a data table.
#5539 - Custom cell styles will now be preserved properly.
#5554 - An "Argument Exception" is no longer thrown in Excel2007Border.
#5391 - When changing the color of a series in a chart using XlsIO, that color will persist when opening in Excel 2000.
#5561 - Row and column grand total of a pivot table can now be disabled.
#5570 - An "Argument out of Range" exception is no longer thrown with FastRecordParsing.
#5599 - The PivotTable RowGrand and ColGrand properties now work correctly.
#5497 - XlsIO will preserve cell border settings.
#5589 - A "System Argument out of Range" exception is no longer thrown when opening an XLSX file as a stream from input in an HTML tag.
#5486 - A cross-thread error no longer occurs in XlsIO.
#5124 - AddCopy will now preserve the chart axis properly.
#5225 - An exception is no longer thrown when inserting rows.
#176 - Sheet names are no longer case-sensitive.
#5260 - Shapes will no longer add border color after using AddCopy.
#5277 - Pictures will not appear with borders after resaving.
#5375 - Macro-enabled workbooks will no longer be corrupted.
#5525 - The progress event will now be triggered for XLSX formats.
#5158 - Formulas will now be recalculated when opening in Excel 2002.
#4276 - An XML exception is no longer thrown when opening certain files.
#5394 - After resaving a file with XlsIO, macros accessing the shape will no longer throw an exception.
#5423 - An exception will no longer be thrown when reference text range is larger than data range.
#5163 - The AddCopy method now preserves formulas properly.
#5103 - Page breaks are now preserved and added to an existing sheet.
#5257 - Files with comments are no longer corrupted.
#4611 - Problems with reading the last column of an Excel file have been corrected.
#5149 - The Open method no longer throws an exception when parsing a sheet.
#5270 - A "Not Supported" exception is no longer thrown when opening a file.
#4923 - Cell backgroud colors will now transfer with Worksheets.AddCopy.
#5055 - The sheet Activate() method now works properly.
#5902 - The SaveAs method no longer throws a "Memory Insufficient" exception.
#5008 - When resaving, the chart axis will now be shown in the output.
#4948 - The Insert Row method no longer corrupts an XLS file.
#5018 - The Open method no longer throws a "Key Not Founf" exception.
#4962 - Image size is now preserved by the AddPicture method.
#5182 - The SaveAs method no longer throws an exception when serializing tables.
#5083 - Output files are no longer corrupted.
#4999 - Renaming a chart no longer throws an exception.
#5153 - Exceptions will no longer be thrown in heaps when XlsIO is multi-threaded.
#4969 - Files are no longer corrupted when saving as Excel 2003 to Excel 2007.
#4928 - Accounting number text is now valid.
#5081 - XlsIO no longer throws an "Unexpected XML Tag" exception.
#4940 - The visibility of axis unit labels will now be preserved.
#4915 - The SaveAs method no longer throws an "Argument out of Range" exception.
#4564 - Problems with the chart title have been corrected.
#5102 - XLSM files will no longer be corrupted.
#5126 - Files no longer hang when opened using XlsIO.
#4984 - Chart formatting will no longer be lost.
#4924 - XlsIO will now parse custom number formats.
#4983 - Chart titles no longer throw an error.
#4903 - OpenFromXML no longer throws an exception.
#5090 - Textbox background color will now be preserved.
#4569 - Title and plot area will now be preserved properly.
#4904 - XlsIO will now parse XML files with number values.
#4836 - Files with VSTO code no longer throw and exception.
#4878 - XlsIO will now recognize the cell contents of an XML file.
#4770 - Output files are no longer corrupted.
#4793 - An "Argument out of Range" exception is no longer thrown when opening documents.
#4801 - An exception is no longer thrown when inserting images.
#4945 - XlsIO output file size is now correct.
#4658 - XlsIO pivot tables are not case sensitive, similar to Excel pivot tables.
#4646 - An error is no longer thrown in an Excel output file when resaving using XlsIO.
#4647 - With RTF text in cells, text color can now be changed to "Auto" in a range of cells.
#4794 - An exception is no longer thrown when inserting a row and accessing style.
#4807 - XMLReader no longer throws an exception when reading an XML spreadsheet.
#4902 - Empty string formulas now behave correctly relative to empty string values when importing an XML spreadsheet
#4538 - Writing long text no longer corrupts a file.
#4866 - The "Type Case" exception is no longer thrown.
#4644 - Files are no longer corrupted after setting DV Error text.
#4772 - User-defined formats are now correct.
#4820 - An exception is no longer thrown when opening an saving an XLSX file.
#4795 - Line gradient properties no longer thrown an exception.
#3618 - The problem with formulas not evaluating has been fixed.
#4625 - The "REF!" error no longer occurs when writing formulas.
#4558 - A protected worksheet no longer causes an XLS file to open in a protected view.

ASP.NET	Calculate	DocIO	PDF	XlsIO	Grouping
ASP.NET MVC		DocIO	PDF	XlsIO
Windows Forms	Calculate	DocIO	PDF	XlsIO	Grouping
WPF	Calculate	DocIO	PDF	XlsIO	Grouping
Silverlight		DocIO	PDF	XlsIO

Fixes

#7868: Parsing function arguments now work when the first character in a literal string argument is a comma.

#7869: The Concatenate function will now strip interior quotes for string arguments containing embedded quotes.

Features

#4799 - Support has been added for creating and manipulating Word 2010 files based on the Word 2010 schema.

Fixes

#4162 - The issue concerning lines being marked for deletion in certain Word documents has been fixed.

#4752, #4899, #4968, #5872 - The issue with retrieving merge fields in a document has been fixed

#4814 - The issue with preserving table size has been fixed.

#4849 - An exception is no longer thrown when opening a DocIO-generated document using VSTO.

#4888 - An "Index out of Range" exception is no longer thrown when opening a document.

#5010 - The issue with parsing the table header property for Word (97-2003) has been fixed.

#5025, #5653 - The issue with preserving custom document properties has been fixed.

#5053 - The issue with preserving styles for a particular Word document has been fixed.

#5091 - The issue with the BookmarkNavigator.InsertParagraph method has been corrected.

#5333 - The issue with paragraph justification in a Word document after cloning has been fixed.

#5503 - The issue has been fixed with page orientation that was caused when adding a new section.

#5538 - List preservation when resaving a document to Word 2007 format has been corrected.

#5569 - The issue with applying a cell border to an existing table has been fixed

#5575 - The issue concerning table alignment after cloning a Word document has been fixed.

#5637 - The paragraph format properties "SpaceAfterAuto" and "SpaceBeforeAuto" have been added.

#5669 - A word document will no longer be corrupted when saving to Word 2007 format.

#5946 - The preservation of font substitution information in Word (97-2003) has been corrected.

#4034, #4867, #4869, #4870, #4883, #4884, #4894, #4909, #4950, #5056, #5140, #5355, #5730 - Formatting issues have been fixed regarding importing HTML content into a Word document.

#5167 - Formatting issues during Word to HTML conversion have been fixed.

#3373, #4737, #4740, #4762, #4901, #4954, #4977, #4989, #5112, #5156, #5169, #5186, #5308, #5238, #5281, #5286, #5287, #5379, #5588, #5625, #5947, #5273, #5843, #5682, #5262, #5513 - Formatting issues during Word to PDF conversion have been fixed.

#5203, #5426, #5488, #5661, #5301 - Formatting issues during RTF to Word conversion have been fixed.

#5527 - Formatting issues during Word to RTF conversion have been fixed.

#5023 - An exception is no longer thrown during text to Word conversion.

#5027 - An extra empty paragraph will no longer be added during text to Word conversion.

#4880 - Headers and footers will now be correctly preserved during Word to text conversion.

Features

#5313 - Support for time-stamping a digital signature has been added.

#5041 - Support for 128- and 256-bit AES encryption has been added.

#5266 - Support for collapsing the bookmark tree of a document has been added.

Fixes

#5723 - Multiple selections can now be made using PdfLoadedListBoxField.

#4914 - PdfPage height will no longer be returned as a negative value.

#5416 - Alignments can now be set for nested PDF grid cells.

#4642 - When a table row splits across pages, the euro symbol in the second page will no longer be returned as question marks.

#5725 - Pages are now removed in the correct order from PdfLoadedDocument.

#5414 - The ImportPageRange method no longer hangs if the PDF document has empty bytes at the end.

#5847 - An "illegal header check sum" exception is no longer thrown when decrypting documents in Acrobat 6.0 standards.

#5532 - The pages of the merged documents will now be preserved.

#5351 - Height of the PdfGrid row no longer increases if text length is larger.

#5273 - Paper size is now preserved properly when converting a Word document to a PDF.

#5187 - The size of the check mark of the PdfCheckBoxField can now be changed.

#5155 - Location of the PdfLoadedTextWebLink annotation can now be retrieved properly.

#5291 - Bookmarks can now be inserted at the zero index position.

#5314 - Contents are now preserved in documents after a merge operation.

#5154 - Bold text is now preserved in EMF to PDF conversion.

#4964 - A PDF bookmark no longer generates garbage text when merging.

#4829 - Cell border color is now properly applied in PdfGrid.

#4901 - Text formatting issues are now fixed in DOC to PDF conversion.

#2150 - The HTML converter now properly converts HTML to a PDF.

#4803 - Page breaks are now preserved properly in HTML-to-PDF conversion.

#4953 - Image extraction no longer hangs when extracting from specific documents.

#4696 - Row spanning is now properly performed in PdfGrid.

#4635 - Wrapped text in HTML is now preserved properly in HTML-to-PDF conversion.

#4831 - Bookmarks are now preserved properly in documents created with Essential PDF and edited using Acrobat.

#5143 - Issues in EMF-to-PDF conversion have been fixed.

#5361 - Unicode text is now preserved properly in DOC-to-PDF conversion.

#5971 - The pages of an existing PDF document can now be rotated properly.

#5972 - PDF documents are no longer corrupted when converting HTML to a PDF concurrently in multiple threads.

Features

#5312 - Pivot chart support has been implemented.

#5021 - Support for an Option button has been added.

#3528 - Support has been added for chart title shadows.

#5500 - Overloads for the Open and OpenReadOnly methods of IWorkbook has been added.

#5142 - The NameRange property has been added to retrieve the series name range.

#161 - New properties-HasFormulaStringValue and HasFormulaNumberValue-have been added to IRange.

#4827 - The ability to toggle leader lines in pie charts has been added.

#5239 - The ability to compress an XLSX file to reduce size has been added.

#5279 - Excel to Pdf conversion has been enhanced.

Fixes

#5119 - Category axis labels can now be set to "Auto".

#5829 - Sparklines no longer cause a "Not supported" exception to be thrown.

#5717 - Images will now convert properly.

#5662 - XLSM files no longer hang when opening and they no longer throw an exception.

#5646 - Pie charts now appear correctly after refreshing values.