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.