Aspose.Cells for .NET 21.11 Release Notes

CELLSNET-48141Support XLookup formula/functionNew Feature
CELLSNET-49614Support saving images with workbook.Save() method.New Feature
CELLSNET-49651Support saving as json file.New Feature
CELLSNET-48499Retrieve formatted cell values against certain cellsEnhancement
CELLSNET-49523Clear defined names when clearing worksheets.Enhancement
CELLSNET-48646StackOverflow exception while Excel to PDF ConversionPerformance
CELLSNET-49378Issue with Excel to HTML conversion performance and empty cellsPerformance
CELLSNET-49453Improve performance while converting Excel to HTMLPerformance
CELLSNET-480953D, the shape of the cloud changedBug
CELLSNET-49544Bug of saving external NamedRange which references to range of multiple sheetsBug
CELLSNET-49588Single type data saved differently than the original valueBug
CELLSNET-49667The result of ColorScale conditional formatting is incorrectBug
CELLSNET-49043Position of drawn line is not correct in imageBug
CELLSNET-49068Wrong PDF generated from Excel fileBug
CELLSNET-49179Axis title reference is unexpectedly removedBug
CELLSNET-49294The axis of some charts are different from those in excel filesBug
CELLSNET-49495Formula rendering overlapBug
CELLSNET-49542The horizontal axis of the chart disappearsBug
CELLSNETCORE-148Pie chart not rendering correctlyBug
CELLSNET-49193GridDesktop not working properlyBug
CELLSNET-49642Aspose.Cells.GridWeb has undeclared dependency on Newtonsoft.JsonBug
CELLSNET-49452Multiline text is not rendered fineBug
CELLSNET-49498HTML stream to Excel raising exception with the latest versionsBug
CELLSNET-49610Xml Import losing template formattingBug
CELLSNET-49671Text with Windings fonts are not properly rendered to images/HTMLBug
CELLSNETCORE-278XLSX to PDF conversion results are not openable when culture is set to NorwegianBug
CELLSNET-49560Differences in XMLBug
CELLSNET-49598Regression: Differences in XML after savingBug
CELLSNET-49630Incorrect Tick Marks on conversion to EMFBug
CELLSNET-49673Some parts of dotted lines became solid lines when converting charts to imagesBug
CELLSNET-49545HtmlCrossType.Default and HtmlCrossType.FitToCell types are brokenBug
CELLSNET-49654Macros are not working after converting XLS to XLSMBug
CELLSNET-49727Images of Mht files are not visible in IE.Bug
CELLSNET-49609“Shape to image error” when converting Excel file to PDFException
CELLSNET-49608Aspose.Cells gives errors when trying to add certain range namesException
CELLSNET-49697XLSX to PDF: Input string was not in a correct format.Exception
CELLSNETCORE-287NullPointerException when calculating formulaException
CELLSNET-49497ExportXml with XML Map throws “NullReferenceException”Exception
CELLSNET-49595ExportXml with XML Map throws “NullReferenceException” for complex Excel filesException
CELLSNET-49471Regression: GetRanges() returns NullRegression

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 enum CellValueFormatStrategy.DisplayString.

With this strategy, Cell.GetStringValue(CellValueFormatStrategy) will take the limit of column width into account when formatting cell’s values with the display style. If the formatted result exceeds the available width, one or more “#” may be returned, just like what ms excel shows for such kind of cells.

Adds WorksheetCollection.ActiveSheetName property.

Gets and sets the active sheet name of the workbook.

Adds JsonLoadOptions and JsonSaveOptions classes.

Represents the options of loading or saving the files.

Adds ImageSaveOptions.StreamProvider property.

Provide the streams if there are two or more pages.

Adds LoadFormat.Image and LoadFormat.Json enum.

Represents the image and json type.

Adds SaveFormat.Bmp, SaveFormat.Emf,SaveFormat.Gif,SaveFormat.Jpg,SaveFormat.Json and SaveFormat.Png enum

New supported save formats.

Adds FileFormatType.Emf,FileFormatType.Gif,FileFormatType.Jpg,FileFormatType.Json,FileFormatType.Png,FileFormatType.Wmf enum

New supported file format types.