Aspose.Cells for .NET V16.12.0 released

Released: Dec 13, 2016

Updates in V16.12.0

Features

  • Load specific worksheets in the Workbook (for MS Excel 2007/2010).
  • Support OTS file format.
  • Expand/Collapse grouped rows/columns (Aspose.Cells.GridWeb).

Fixes

  • Date values prior to 2000 are incorrectly parsed.
  • Fraction formatting gave incorrect formatted result.
  • Make the font substitution mechanism as per .NET's default behaviour.
  • API is not able to locate default fonts in Linux under Mono.
  • Low performance while calculating the formulas for second time.
  • Performance considerations for NameCollection.Remove method.
  • Aspose.Cells is hanging when CalculateFormula() is used on Workbook.
  • Unable to save source Excel file into HTML and it gets time out.
  • Pivot Table formatting is lost while converting spreadsheet to PDF file format.
  • Row data is misplaced while rendering spreadsheet to PDF after refreshing Pivot Table.
  • Cell shading is missing while rendering spreadsheet to PDF after refreshing Pivot Table.
  • Blank columns are missing while rendering spreadsheet to PDF after refreshing Pivot Table.
  • Column is missing in Pivot Table after refreshing and conversion to PDF.
  • Data is missing in Pivot Table after refreshing and conversion to PDF.
  • Spreadsheet containing slicers gets corrupted after simple resave operation.
  • Calling RefreshData on pivot table corrupts resultant spreadsheet.
  • Refreshing pivot tables and charts generate corrupt XLSX file.
  • Cell shading is messed up while refreshing the Pivot Table and rendering to PDF.
  • Cell Shading applied to wrong cell while refreshing Pivot Table and rendering to PDF.
  • Save to PDF creates extra borders for the rows.
  • Datatype considered as DateTime if custom format contains Magenta.
  • Row height has been changed after simple re-save operation.
  • Workbook.CalculateFormula() method calculates the value of cell B8 wrongly.
  • An additional character 4 appears on converting an ODS to PDF file format.
  • Font substitution does not occur with FontConfigs.PreferSystemFontSubstitutes set to true.
  • Excel to PDF rendering - Some words are cut into two in the merged area.
  • Margin on the right hand side is bigger than in MS Excel when printed or saved as PDF.
  • Save to PDF creates extra blank page.
  • PNG image of the chart does not match with MS-Excel chart.
  • Time used to convert XLS to XLSX is high.
  • PDF export displays 0 on stack charts.
  • Issue with chart's data series in Excel to PDF rendering.
  • Image of the chart with title Life is not correct.
  • Series DataLabel value and percentage showing VALUE and PERCENTAGE after simple resave.
  • X-axis (Data Table) is not the same in the rendered PDF file.
  • Incorrect rendering of lines while converting spreadsheet to PDF.
  • API renders extra legend with SheetRender when ImageOrPrintOptions.OnlyArea is set to false.
  • Chart's data stacked portion missing in the output Chart after using Chart.Calculate() method.
  • Aspose is enabling split option on freeze panes while saving it in XLSB format.
  • Cell.Copy does not copy format from one workbook to another.
  • RTL sheets are converted to LTR while converting XLSX to ODS.
  • Defined Name Print_Area is changed after re-save operation.
  • Conditional Formatting rule has been changed after simple re-save operation.
  • Shape image replacement functionality works incorrect on x86 OS.
  • Style not applied correctly to Excel row when setting default style.
  • Issue with chart names: not able to generate unique name.
  • Inconsistent cell style API call results regarding borders.
  • Opening and re-saving unmodified Excel file is getting a prompt.
  • Contents disappear after scroll down and then up again while switching another worksheet (GridWeb).
  • Contents will disappear after scroll down and then up again in one worksheet (GridWeb).
  • Gridweb - Error message when cells are changed.
  • Fixed rows are duplicated when scroll down and up again (GridWeb).
  • GridWeb loads the worksheet incomplete.
  • Scrollbar postback never ends (GridWeb).
  • GridWeb's visible area changes when cell is left via TAB or Enter key.
  • CellsException due to line break inside cell spanning multiple rows.
  • Aspose.Cell ArithmeticException when calling Chart.ToImage through a CLR compatible C++ DLL.
  • CellsException: Shape to image error, while converting spreadsheet to PDF.