Browse our Products

Aspose.Cells for .NET 25.10 Release Notes

KeySummaryCategory
CELLSNET-58944Provide option to determine how to output significant digits for numeric valuesNew Feature
CELLSNET-59052Support to process exported cell with custom ExportTableOptions when ExportAsString is trueEnhancement
CELLSNET-59074Support to parse datetime with calendar of Japanese Emperor ReignEnhancement
CELLSNET-59078Support to refresh dynamic array formulas by default when calculating formulas for WorkbookEnhancement
CELLSNET-59045Improve compatibility with PdfBox library for the generated pdf file while converting to pdfEnhancement
CELLSNET-59114Support to calculate style for pivot table while rendering pivot table range to imageEnhancement
CELLSNET-59071Export advanced charts of Excel 2016 to docxEnhancement
CELLSNET-59123Support to populate comment on a cell using Smart MarkersEnhancement
CELLSNET-51941XLSX to PDF: Shapes messed up after conversionBug
CELLSNET-54573Incomplete TextBox display when converting files to PdfBug
CELLSNET-56230A vertical green line appears from top to bottom when saving file to pdfBug
CELLSNET-57564Green line unnecessary appeared when rendering an Excel file to PDFBug
CELLSNET-58127Some images resized during Excel to PDF conversionBug
CELLSNET-58605The result file crashes when adding auto shape with AutoShapeType.LineCalloutWithAccentBar4 typeBug
CELLSNET-58606The result file crashes when adding auto shape with AutoShapeType.LineCalloutNoBorder4 typeBug
CELLSNET-59155Trapezoid position is incorrect when rendering xlsx to pdfBug
CELLSNET-58960Hyperlink formula cells lose background(conditional formatting) when converting file to html or pdfBug
CELLSNET-58966Range object returns “#VALUE!” errors whereas Excel returns valuesBug
CELLSNET-58994Values do not match when converting Excel file to PDF with enabled PdfSaveOptions.CalculateFormulaBug
CELLSNET-59009The reference is set to #REF! for data connection after calling Cells.DeleteRows methodBug
CELLSNET-59032Set value cannot display in the output Excel fileBug
CELLSNET-59039ROW and COLUMN functions for range data produce incorrect result in calculating array formulasBug
CELLSNET-59043IFERROR for long text in array formula was calculated as false but ms excel calculates it as trueBug
CELLSNET-59044XLSX to PDF: Incorrect formula result when workbook filename contains ‘]’Bug
CELLSNET-59110Workbook.RefreshDynamicArrayFormulas() did not calculate some cells correctly when there are recursive referencesBug
CELLSNET-59111FILTER function caused resultant data out of order when the target range has default value at the tailBug
CELLSNET-58979The font of values changes (Arial Narrow -> Calibri)  when rendering in the EMF imageBug
CELLSNET-58980The bar chart uses red bars (using shadow property) are not rendered in the output imageBug
CELLSNET-59015Chart to image is excluding data labels from the imageBug
CELLSNET-59081LegendEntry.IsDeleted does not work as expected for the series whose state changed from disabled to enabledBug
CELLSNET-59016Cell.HtmlString does not apply styles for the contentsBug
CELLSNET-59011Cells are not merged when using parameter group:merge in smart markersBug
CELLSNET-59077Ignore invalid horizontal or vertical page breaks when saving as .ods file formatBug
CELLSNET-59103Copying formulas with cell referecing other sheets is not working as excelBug
CELLSNET-59124Table’s column formula was not copied when importing data with false value for “InsertRows” optionBug
CELLSNET-59125Importing data with true for “InsertRows” option caused invalid formulaBug
CELLSNET-59117ArgumentOutOfRangeException on Workbook.RefreshDynamicArrayFormulas(true) methodException

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.

Changes behavior of Workbook.CalculateFormula(…) methods for refreshing dynamic array formulas.

Dynamic array formulas are becoming more and more popular in more and more users’ cases. Old versions of Aspose.Cells required users to call Workbook.RefreshDynamicArrayFormulas(…) explicitly before calling Workbook.CalculateFormula() if there are dynamic array formulas that need to be refreshed. Starting from 25.10, we include this step into Workbook.CalculateFormula(…) automatically. So users do not need to explicitly call Workbook.RefreshDynamicArrayFormulas(…) anymore before calculating formulas for the workbook.

Adds property RefreshDynamicArrayFormula for CalculationOptions.

Indicates whether dynamic array formulas in a workbook should be refreshed automatically when using this CalculationOptions to calculate formulas.

Adds property UserSpecifiedRefreshDynamicArrayFormula for CalculationOptions.

Indicates whether user has specified CalculationOptions.RefreshDynamicArrayFormula property explicitly. If true, then use the specified value to determine whether to refresh dynamic array formulas. If false, whether refresh dynamic array formulas depends on what kind of formulas need to be calculated with this CalculationOptions. If it is to calculate formulas for the whole workbook, then dynamic array formulas will be refreshed automatically. If it is to calculate formulas for one cell or worksheet, then dynamic array formulas will not be refreshed.

Adds SignificantDigitsType enum.

Represents the type of significant digits for outputting numeric values.

Adds SignificantDigitsType property for WorkbookSettings and CellsHelper.

Indicates how to control the significant digits when outputing numeric values.

Obsoletes SignificantDigits property of WorkbookSettings and CellsHelper.

Uses SignificantDigitsType instead.

Adds property SplitTablesByBlankRow for MarkdownSaveOptions.

Indicates whether blank rows in the worksheet should be treated as table separators when exporting to Markdown.

Adds property WorkbookSettings.MaxUniqueItemsPerField.

Represents the limitation of unique items per pivot field.