Released: Nov 17, 2017

Updates in V17.11

Features

• Added XmlMapQuery like functionality.
• Added associated property for XMLMaps to read the RootElementName for the map.
• Protect shared workbooks with passwords.
• Added support for PasteType during Copy/Paste actions.
   

Fixes

• Scale becomes smaller - fonts issue.
• Unable to read Smart Art shape text.
• Pivot table is taking too long to refresh data.
• Direction of shape is wrong when converted to image format.
• Star shapes are not shown correctly in the output PDF.
• Characters overlap when converting to image.
• Some drawing elements are inverted while others are shifted to the right.
• Position of line objects changed while rendering spreadsheet to PDF.
• Missing total values for the calculated fields when refreshing/calculating PivotTable data.
• Error expanding data to proper columns when saving an MHTML file format to Excel file.
• LightCellsDataProvider is removing leading and trailing spaces.
• Formula calculation resolves formula unexpectedly to error.
• Saving Excel as PDF decreases column width.
• Chart legend missing in output PDF.
• Number formatting in chart is lost after saving an Excel file as PDF.
• PDF file causes error in Adobe Acrobat Reader.
• Chart to image or PDF - 3D Line Chart is not correct or rotated.
• Validation is not correctly copied from one worksheet to another.
• Style.QuotePrefix property does not work for XLSB file format.
• Specific Excel workbook becomes hidden after opening and saving.
• Columns expanded unexpectedly in the merged workbook.
• HTML string with multiple fonts corrupts the output Excel file.
• AutoFitColumns breaks HTML formatting in the output Excel file.
• Textbox font changed after ungrouping shape(s).
• The row height becomes too big after autofitting rows.
• Issue with CellColor when using the context menu to change.
• Exception when using PivotTable.RefreshData.
• Index out of range exception when saving as PDF page.
• When XLSB is converted to PDF, System.ArgumentOutOfRangeException occurs.
• ExportTableOptions.Indexes property used in ExportDataTable() method causes exception.
• Exception while loading the output XLS file (with OLE Objects, images, etc. excluded).
• R1C1Formula throws exception if formula contains character "[" .