Browse our Products

Aspose.Cells for .NET 26.2 Release Notes

KeySummaryCategory
CELLSNET-59382Support getting python script from cell that uses python formulaNew Feature
CELLSNET-59733Allow user to calculate defined LAMBDA function in custom calculation engineNew Feature
CELLSNET-59756Provide specific assembly for .NET 4.8New Feature
CELLSNET-59481Support ODF 1.4New Feature
CELLSNET-59727Support whether to include table names when importing NumbersNew Feature
CELLSGRIDJS-2185Support translate feature in collabrative modeNew Feature
CELLSGRIDJS-2186Support setting text for general shapeNew Feature
CELLSGRIDJS-2195Add support for merge acrossNew Feature
CELLSGRIDJS-2197Add support for the merge and center feature.New Feature
CELLSGRIDJS-2239Add support for sheet protection.New Feature
CELLSGRIDJS-2240Add support for workbook protection.New Feature
CELLSNET-59528Support copying shapes when copying columnsEnhancement
CELLSNET-59551Support simply getting all pictures which are placed in or over cells.Enhancement
CELLSNET-59724Support R/W pivotOptions since Excel 2016Enhancement
CELLSNET-59764Workbook links are not working in .xlsm or .xlsx fileEnhancement
CELLSGRIDJS-2229Add comments info in xs.getData APIEnhancement
CELLSGRIDJS-2189Chart does not render correctly after inserting or deleting rows/columns.Enhancement
CELLSGRIDJS-2193Add support for distinguishing data series in box plots using different colors.Enhancement
CELLSGRIDJS-2194Optimize the merge function of the toolbarEnhancement
CELLSGRIDJS-2196Optimize the toolbar by changing the merge button to a dropdown.Enhancement
CELLSGRIDJS-2217Sheet protection status should not have a batch insert button.Enhancement
CELLSNET-59510Text line spacing error when saving file to pdfBug
CELLSNET-59741Invalid auto shape type when copying picture.Bug
CELLSNET-59746Image transparency is incorrect when converting Excel files to PDFBug
CELLSNET-59794The calculated height of the text in the text box is different from the expected height.Bug
CELLSNET-597213-D refererence formulas are corrupted if sheet name contains a spaceBug
CELLSNET-59725Formula in the generated XLSB file shows #VALUE! but after pressing enter it becomes correct number valueBug
CELLSNET-59776Some values are lost when iterating the sorted result in calculating formulaBug
CELLSNET-59777Some values are lost when accessing cells randomly in calculation of formulasBug
CELLSNET-59766Print area is not honoredBug
CELLSNET-59674Big row numbers overlap right sibling cells and long text in cell is truncatedBug
CELLSNET-59715Winding font characters are not preserved while converting XLS to HTMLBug
CELLSNET-59722Slicers of pivot charts are not working after savingBug
CELLSNET-59748The number format is changed when converting xls to xlsx file.Bug
CELLSNET-59754Ttml was detected as htmlBug
CELLSNET-59755Help.com was detected as CSV when using stream for FileFormatUtil.DetectFileFormat()Bug
CELLSNET-59802Line shape is not copied correctly when copying rowsBug
CELLSGRIDJS-2216Checkboxes disappear in worksheet with freeze paneBug
CELLSGRIDJS-2218The validation list is obscured and not fully displayedBug
CELLSGRIDJS-2220The dropdown list is not working in GridJsBug
CELLSGRIDJS-2221The position of the validation list dropdown button should be updated after scrollingBug
CELLSGRIDJS-2222The config option for autofit rows does not work as expectedBug
CELLSGRIDJS-2250Some rows are blocked and cannot be selectedBug
CELLSGRIDJS-2219Double-clicking to edit certain cell areas is problematicBug
CELLSGRIDJS-2224The position of the highlighted row is incorrect when zooming in or outBug
CELLSGRIDJS-2225Fix the issue where gridjs cannot display graphics with text.Bug
CELLSGRIDJS-2233Bar portion of the stacked bar chart disappears.Bug
CELLSGRIDJS-2244dpr issue causing chart to zoom.Bug
CELLSGRIDJS-2245The input component has a duplicate element ID issue.Bug
CELLSNET-59745CalculateFormula() causes exception after copying range from table’s first row to all other rowsException
CELLSNET-59795NullReferenceException when calculating CalcGETPIVOTDATA function with invalid paramException
CELLSGRIDJS-2230NullReferenceException in GridJsWorkbook ExportToJson APIException

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 new property PivotOptions.ShowExpandCollapseFieldButtons.

Supports to get or set a value indicating whether to show expand/collapse field buttons.

Adds new property Picture.IsPlacedInCell.

Indicates whether to place the image in a cell or over cells.

Obsoletes Picture.PlaceInCell().

Please use IsPlacedInCell property instead.

Adds new property NumbersLoadOptions.PreserveTableName.

Indicates whether to preserve table names when importing from Numbers.

Adds new enum member OpenDocumentFormatVersionType.Odf14.

Support ODF Version 1.4.

Adds new property PivotTable.PivotTableStyle.

Gets or sets the table style settings of this pivot table.

Adds new property PivotTable.TopRightArea.

Represents the blank area at the top-right of the PivotTable (top-left for RTL sheets).

Adds new property PivotTable.FilterArea.

Gets the region of the filter area.

Adds new method PivotTable.GetButtonArea(PivotFieldType axisType).

Gets the button area for a specified axis type.

Adds new method Worksheet.GetAllPictures().

Gets all pictures including images embedded in cells and over the cells.