Aspose.Cells for .NET 23.10 Release Notes

CELLSNET-54117Support adaptive paste operation when size of target range is different from source rangeNew Feature
CELLSNET-54317Add new API for setting range hyperlinks directly on RangeNew Feature
CELLSNET-54328Support to copy multiple worksheets simultaneously and preserve dependenciesNew Feature
CELLSNET-54269Improve the performance for setting formula with sheet reference for large amount of cellsEnhancement
CELLSNET-54299Update to SkiaSharp 2.88.6 because of the CVE-2023-4863 vulnerability in SkiaSharp 2.88.3Enhancement
CELLSNET-54236Ignore the threaded comments when printing comments in place.Enhancement
CELLSNET-54321Support to check whether one range is empty for cells dataEnhancement
CELLSNET-54067DataSorter sorting errorBug
CELLSNET-54129Using nested XLOOKUP formulas appear as #VALUE on the saved image via SheetRender.ToImageBug
CELLSNET-54294WORKDAY function gets error value when using empty cell or 0Bug
CELLSNET-54318When calculating TRIM function for another cell (having single digit number), it gives blank value in Japanese localeBug
CELLSNET-54218Chart lines in output SVG are misalignedBug
CELLSNET-54283Bubble chart labels are distorted when saving the chart to imageBug
CELLSNET-54108Format cell as text but the pre zeros still be removed in cell content in GridDesktopBug
CELLSNET-54109Enter text in Chinese input mode then use tab key to move to next cell, it will copy the cell content from previous cell in GridDesktopBug
CELLSGRIDJS-905Gridjs-spreadsheet rendering issue with freeze panes on high DPI screensBug
CELLSGRIDJS-907Gridjs selector can be misaligned when sheet has freeze panesBug
CELLSGRIDJS-914Highlight disappears when clicked on textboxBug
CELLSNET-54291XLSX to PDF - file layout difference between Excel and Aspose.Cells renderingBug
CELLSNET-54216Copying worksheets causes file corruptBug
CELLSNET-54247Importing XML into a table with a Total Row corrupts the spreadsheetBug
CELLSNET-54285CommentShape cannot be displayed according to the size of background imageBug
CELLSNET-54287Crop picture make picture emptyBug
CELLSNET-54290Share picture data between drawing shapes and VML shapes.Bug
CELLSNET-54310Remove user form designer info when removing module from VBA project.Bug
CELLSNET-54327AllowEditRanges are not copied with Worksheet.Copy()Bug
CELLSGRIDJS-906GrisJS crash when disabling freeze pane for two spreadsheetsBug
CELLSNET-54209FilteredNSeries is missing in the copied worksheetBug
CELLSNET-54205Calculating the nested MAP function caused StackOverflowExceptionException
CELLSNET-54240Aspose.Cells Delete Worksheet - Value cannot be null exceptionException
CELLSNET-54355Aspose.Cells.CellsException: OverflowException: Arithmetic operation resulted in an overflow on Workbook.CalculateFormulaException
CELLSNET-54201Exception is thrown when refreshing pivottableException
CELLSNET-54208An exception occurred while resaving the fileException

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 GlobalizationSettings.GetDefaultSheetName() method

Supports custom sheet name for automatically added worksheets.

Adds MsoFormatPicture.TopCropInch/BottomCropInch/LeftCropInch/RightCropInch properties.

Gets and sets the crop size of picture in unit of inches.

Adds Range.IsBlank() method.

Indicates whether the range does not contain any value.

Adds Range.AddHyperlink(String,String,String) method

Adds a hyperlink to a range.

Adds VbaModuleCollection.AddUserForm() method

Adds user form for VBA project.

Adds WorksheetCollection.AddCopy(Worksheet[], string[]) method

Supports adding and copying some worksheets together.