Aspose.Cells for .NET 16.12.0 Release Notes

CELLSNET-41702Load specific worksheets in the Workbook (for MS Excel 2007/2010)New Feature 
CELLSNET-44943Support OTS file format New Feature 
CELLSNET-44862Expand/Collapse grouped rows/columns (Aspose.Cells.GridWeb)New Feature 
CELLSNET-44965Date values prior to 2000 are incorrectly parsedEnhancement 
CELLSNET-44954Fraction formatting gave incorrect formatted resultEnhancement 
CELLSNET-44944Make the font substitution mechanism as per .NET’s default behaviourEnhancement 
CELLSNET-44935API is not able to locate default fonts in Linux under MonoEnhancement 
CELLSNET-44899Low performance while calculating the formulas for second timePerformance
CELLSNET-44967Performance considerations for NameCollection.Remove methodPerformance
CELLSNET-44964Aspose.Cells is hanging when CalculateFormula() is used on Workbook.Performance
CELLSNET-44819Unable to save source Excel file into HTML and it gets time outPerformance
CELLSNET-44960Pivot Table formatting is lost while converting spreadsheet to PDF file format Bug 
CELLSNET-44951Row data is misplaced while rendering spreadsheet to PDF after refreshing Pivot TableBug 
CELLSNET-44950Cell shading is missing while rendering spreadsheet to PDF after refreshing Pivot TableBug 
CELLSNET-44949Blank columns are missing while rendering spreadsheet to PDF after refreshing Pivot TableBug 
CELLSNET-44930Column is missing in Pivot Table after refreshing and conversion to PDFBug 
CELLSNET-44929Data is missing in Pivot Table after refreshing and conversion to PDFBug 
CELLSNET-44908Spreadsheet containing slicers gets corrupted after simple resave operationBug 
CELLSNET-44206Calling RefreshData on pivot table corrupts resultant spreadsheetBug 
CELLSNET-44184Refreshing pivot tables and charts generate corrupt XLSX fileBug 
CELLSNET-44974Cell shading is messed up while refreshing the Pivot Table and rendering to PDFBug 
CELLSNET-44972Cell Shading applied to wrong cell while refreshing Pivot Table and rendering to PDFBug 
CELLSNET-44963Save to PDF creates extra borders for the rowsBug 
CELLSNET-44927Datatype considered as DateTime if custom format contains MagentaBug 
CELLSNET-44921Row height has been changed after simple re-save operationBug 
CELLSNET-44916Workbook.CalculateFormula() method calculates the value of cell B8 wronglyBug 
CELLSNET-44910An additional character 4 appears on converting an ODS to PDF file formatBug 
CELLSNET-44958Font substitution does not occur with FontConfigs.PreferSystemFontSubstitutes set to trueBug 
CELLSNET-44937Excel to PDF rendering - Some words are cut into two in the merged areaBug 
CELLSNET-44933Exporting Excel Charts to SVGBug 
CELLSNET-44914Margin on the right hand side is bigger than in MS Excel when printed or saved as PDF Bug 
CELLSNET-44931Save to PDF creates extra blank page.Bug 
CELLSNET-44926PNG image of the chart does not match with MS-Excel chartBug 
CELLSNET-44912Time used to convert XLS to XLSX is highBug 
CELLSNET-44905PDF export displays 0 on stack chartsBug 
CELLSNET-44902Issue with chart’s data series in Excel to PDF renderingBug 
CELLSNET-44897Image of the chart with title Life is not correctBug 
CELLSNET-44890Series DataLabel value and percentage showing VALUE and PERCENTAGE after simple resaveBug 
CELLSNET-44883X-axis (Data Table) is not the same in the rendered PDF fileBug 
CELLSNET-44833Incorrect rendering of lines while converting spreadsheet to PDFBug 
CELLSNET-44831API renders extra legend with SheetRender when ImageOrPrintOptions.OnlyArea is set to falseBug 
CELLSNET-44803Chart’s data stacked portion missing in the output Chart after using Chart.Calculate() methodBug 
CELLSNET-44979Aspose is enabling split option on freeze panes while saving it in XLSB formatBug 
CELLSNET-44953Cell.Copy does not copy format from one workbook to anotherBug 
CELLSNET-44945RTL sheets are converted to LTR while converting XLSX to ODSBug 
CELLSNET-44922Defined Name Print_Area is changed after re-save operationBug 
CELLSNET-44920Conditional Formatting rule has been changed after simple re-save operationBug 
CELLSNET-44918Shape image replacement functionality works incorrect on x86 OS Bug 
CELLSNET-44915Style not applied correctly to Excel row when setting default styleBug 
CELLSNET-44913Issue with chart names: not able to generate unique nameBug 
CELLSNET-44911Inconsistent cell style API call results regarding bordersBug 
CELLSNET-44904Opening and re-saving unmodified Excel file is getting a promptBug 
CELLSNET-44959Contents disappear after scroll down and then up again while switching another worksheet (GridWeb) Bug 
CELLSNET-44925Contents will disappear after scroll down and then up again in one worksheet (GridWeb)Bug 
CELLSNET-44906Gridweb - Error message when cells are changedBug 
CELLSNET-44860Fixed rows are duplicated when scroll down and up again (GridWeb)Bug 
CELLSNET-44859GridWeb loads the worksheet incompleteBug 
CELLSNET-44858Scrollbar postback never ends (GridWeb) Bug 
CELLSNET-44734GridWeb’s visible area changes when cell is left via TAB or Enter keyBug 
CELLSNET-44907CellsException due to line break inside cell spanning multiple rowsException 
CELLSNET-44893Aspose.Cell ArithmeticException when calling Chart.ToImage through a CLR compatible C++ DLLException 
CELLSNET-44876CellsException: Shape to image error, while converting spreadsheet to PDFException 

Public API and Backwards Incompatible Changes

The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for .NET. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Adds BuiltInDocumentPropertyCollection.ScaleCrop and BuiltInDocumentPropertyCollection.LinksUpToDate properties.

Gets and sets some builtin document properties.

Deletes obsoleted DataLabels.Rotation property.

Use DataLabels.RotationAngle property instead.

Deletes obsoleted Title.Rotation property.

Use Title.RotationAngle property instead.

Deletes obsoleted DataLabels.Background property.

Use DataLabels.BackgroundMode property instead.

Deletes obsoleted DisplayUnitLabel.Rotation property.

Use DisplayUnitLabel.RotationAngle property instead.

JAVA Deletes obsoleted Title.getCharacters() method.

Use Title.characters() method instead.

Adds LoadFilter class and LoadOptions.LoadFilter property.

Allows user to control what data should be loaded while loading a Workbook from template file.

Obsoletes LoadOptions.LoadDataFilterOptions property.

Use LoadOptions.LoadFilter property instead. Example: LoadOptions.LoadFilter = new LoadFilter(LoadDataFilterOptions.All & ~LoadDataFilterOptions.Chart);

Obsoletes LoadOptions.OnlyLoadDocumentProperties property.

Use LoadOptions.LoadFilter property instead. Usage: LoadOptions.LoadFilter = new LoadFilter(LoadDataFilterOptions.DocumentProperties);

Obsoletes LoadOptions.LoadDataAndFormatting property.

Use LoadOptions.LoadFilter property instead. Usage: LoadOptions.LoadFilter = new LoadFilter(LoadDataFilterOptions.CellData);

Obsoletes LoadOptions.LoadDataOptions property.

Use LoadFilter property instead, user may extend LoadFilter to filter the worksheet and data.

Adds Workbook.ExportXml(string mapName, string path) method.

Export XML data.

Adds enum FileFormatType.OTS.

Represents the OTS file format.

Adds WorksheetCollection.CreateRange() method.

Creates a range.

Adds FontConfigs.PreferSystemFontSubstitutes property.

Indicate whether to use system font substitutes first or not when a font is not present and the substitute of this font is not set.