Browse our Products

Aspose.Cells for .NET 17.12 Release Notes

KeySummaryCategory
CELLSNET-45358Obtain CSS separately from HTML markup when exporting to HTML using streamsNew Feature 
CELLSNET-45697Implement Cell.FormulaLocal similar to Microsoft Interop FormulaLocalNew Feature 
CELLSNET-45801Support for Office-Add-Ins in Excel to PDF renderingNew Feature 
CELLSNET-45796Smart Markers - How to auto populate data to second worksheet if data is too large and cannot be inserted into a single sheet New Feature 
CELLSNET-45791Update “Keep change history” when Sharing WorkbookNew Feature 
CELLSNET-45746Text in the cells are overlapping with other cells on Aspose.Cells.GridDesktopNew Feature 
CELLSNET-45774Images are confused in a picture shape with texture fillEnhancement 
CELLSNET-45731Refreshing PivotTable corrupts MS Excel fileBug 
CELLSNET-45794Array formula involving “MEDIAN” is calculated as blankBug 
CELLSNET-45779Cell text alignment is changed in the converted imageBug 
CELLSNET-45772One page lost when converting worksheet to imageBug 
CELLSNET-45764Status of DataBars is incorrect in the output PDF Bug 
CELLSNET-45785Series “Nominale in Essere (mln)” Data Labels positioning is wrongBug 
CELLSNET-45775Second vertical axis label is missing when converting chart to imageBug 
CELLSNET-45762Chart.Calculate is taking more time and not workingBug 
CELLSNET-45799Absolute path changes to relative path when re-saving an XLSX fileBug 
CELLSNET-45797SetArrayFormula - Not being treated as array formulaBug 
CELLSNET-45792Merged cells lost on copy paste the column to next columnsBug 
CELLSNET-45784Inserting a column causes MS Excel to prompt an error messageBug 
CELLSNET-45778Comment settings changed on opening and saving the MS Excel fileBug 
CELLSNET-45773Fill format is changed for all text shapes in workbook instead of selected oneBug 
CELLSNET-45770Xlsx file is corrupted after loading and savingBug 
CELLSNET-45769The default value of the OoxmlSaveOptions.ExportCellName property is true instead of falseBug 
CELLSNET-45768Workbook.Save(Stream stream, SaveFormat saveFormat) fails if stream does not support SeekBug 
CELLSNET-45780Issue with displaying worksheet data in right to leftBug 
CELLSNET-45745Error when clicking scroll bar on Aspose.Cells.GridDesktopBug 
CELLSNET-45777Shape to Image error occurs while converting Excel file to PDF Exception 
CELLSNET-45804Exception on opening an Excel (Strict Open XML Spreadsheet) fileException 
CELLSNET-45798Index was outside the bounds of the array - Exception while rendering Excel fileException 
CELLSNET-45795You must enter data for validation criteria - exception occurs while saving the workbookException 
CELLSNET-45781ArgumentOutOfRangeException occurs when worksheet is copied to another workbookException 

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 HtmlSaveOptions.TableCssId property

Gets and sets the prefix of the type css name such as tr,col,td and so on, they are contained in the table element which has the specific TableCssId attribute. The default value is “”.

Adds Cell.FormulaLocal property

Gets the local formatted formula which may vary according to different locale settings for separators, built in Names, function names, …etc. Those locales are dependent.

Adds GlobalizationSettings.GetLocalFunctionName(string standardName) method

Gets the locale dependent function name according to given standard function name.

Adds GlobalizationSettings.GetLocalBuiltInName(string standardName) method

Gets the locale dependent text for built-in Name according to given standard text.

Adds GlobalizationSettings.ListSeparator property

Gets the separator for list, parameters of function, …etc.

Adds GlobalizationSettings.RowSeparatorOfFormulaArray property

Gets the separator for rows in array data in formula.

Adds GlobalizationSettings.ColumnSeparatorOfFormulaArray property

Gets the separator for the items in array’s row data in formula.

Adds HtmlSaveOptions.ExportWorksheetCSSSeparately property

Indicates whether exporting the worksheet css separately. The default value is false.

Adds LoadDataFilterOptions.Structure to replace LoadDataFilterOptions.None

LoadDataFilterOptions.None gave ambiguous directions and caused confusion. It was designed to denote that load nothing for worksheet data. Now we provide new one (member), i.e., Structure to replace it.

Adds DataLabelShapeType enum

Specifies the preset shape geometry that is to be used for a chart.

Adds DataLabels.ShapeType property

Gets or sets shape type of data label.

Deletes some obsoleted FileFormatType

Deletes obsoleted file format types.

Added WorksheetCollection.RevisionLogs property, RevisionLogCollection class and Revisions.RevisionLog class

Gets setting of revision log.

Adds enum MsoDrawingType.WebExtension

Represents the web extension shape.

Usage Examples

Please check the list of help topics added in the Aspose.Cells Wiki docs:


 
 English