Aspose.Cells for .NET 22.9 Release Notes

CELLSNET-51935Support discrete group data for xls fileNew Feature
CELLSNET-51925Support preset gradient settings for gradient fillNew Feature
CELLSNET-51740Support to set table formula for the datatableEnhancement
CELLSNET-51853Support to convert ozm to lbm for CONVERT functionEnhancement
CELLSNET-51931Improve the recognization of user’s input for Style.Custom to built-inEnhancement
CELLSNET-51709Support multiple tables in a worksheet of .NumbersEnhancement
CELLSNET-51810Support to export empty cells as null to JsonEnhancement
CELLSNET-51811Enhance the function of detecting whether the first row is header rowEnhancement
CELLSNET-51910Support to apply outline borders with ThemeColor to RangeEnhancement
CELLSNET-51928Support reading and writing protected range with SHA-512 algorithm of xlsbEnhancement
CELLSNET-51743Some symbols changed after converting Excel file to PDFBug
CELLSNET-51747mm becomes “??” in pdfBug
CELLSNET-50960Re-saved XLSM file (containing a pivot table) got corruptedBug
CELLSNET-51506External connections are corrupted in genreated fileBug
CELLSNET-51735Wrong text bold style on converting Excel pivot table to PDFBug
CELLSNET-51761When XLS file with Pivot table is converted to XLSM, the data connections details got deletedBug
CELLSNET-51899XLS to XLSM conversion - MS Excel could not open the the output XLSM fileBug
CELLSNET-51716Dynamic array formula does not populate spilled cellsBug
CELLSNET-51753Some formulas are not calculated to update the data across the sheets upon changing selectionBug
CELLSNET-51800Values from XLSX are incorrect in the output PDFBug
CELLSNET-51801Recalculation of a workbook is slow after calculating with calculation chainBug
CELLSNET-51897HLOOKUP value is incorrectBug
CELLSNET-51187Vertical dotted lines misaligned with labels on axis in chart to SVG renderingBug
CELLSNET-51734System.Security.Cryptography.Pkcs 6.0.1 dependency requires .NET Core 3.1Bug
CELLSNET-51912When converting Excel To PDF, the resultant PDF does not show axis correctlyBug
CELLSNET-51744Gridweb keeps jumping backBug
CELLSNET-51608Number is hidden behind red/green circle when exporting Excel to HTML on docker (Azure cloud kubernetes)Bug
CELLSNET-51864Issue with calculating “PageSetup.Zoom” with HorizontalPageBreaksBug
CELLSNET-51938XLSX to PDF: Character spacing is wrongBug
CELLSNET-51226Add identifier attribute for chart/group in Excel WorkbookBug
CELLSNET-51461Unnecessary borders are added for the data in Excel to DOCX conversionBug
CELLSNET-51736Cell borders got lost in the resultant PDFBug
CELLSNET-51738Invalid record for single cell caused generated file corruptedBug
CELLSNET-51760Worksheet.AutoFitColumns is not working rightBug
CELLSNET-51770Merged Cells does not work fine when saving as PowerPoint fileBug
CELLSNET-51771Afer cells are merged some data are lost in the generaed PowerPoint fileBug
CELLSNET-51772Connection info is getting changed when converting XLS file to XLSMBug
CELLSNET-51778Converting an XLS file to XLSM is deleting few chars at the end of the link in named rangesBug
CELLSNET-51785DOCX » Html table » Excel sheet does not convert properlyBug
CELLSNET-51825AutoFit worked differently in v22.1.0 and v22.8.0Bug
CELLSNET-51829XLS to XLSM file conversion caused some custom properties lostBug
CELLSNET-51830Input document stream is prematurely disposed after creating Workbook for particular fileBug
CELLSNET-51865XLS worksheet has no data while you can see filled rows in ExcelBug
CELLSNET-51880XLSB to XLSM conversion - the output XLSM file is corruptedBug
CELLSNET-51898XLS to XLSM conversion - the output XLSM file is corruptedBug
CELLSNET-51921Cannot apply a copied style without setting its flags to explicit or using a flagBug
CELLSNET-51922Cell protection is lost after opening and re-saving the XLSX fileBug
CELLSNET-51923DataTable Column Caption property is not honored and rendered in the output Excel when importing dataBug
CELLSNET-51924Incorrect locale in chart text elementsBug
CELLSNET-51944The name of built-in styles does not automaitcally change according to regionBug
CELLSNET-51848Calculating workbook throws Stackoverflow exceptionException
CELLSNET-51965Exception when importing an XLSX file with Accounting formatting into Aspose.Cells.GridDesktopException
CELLSNET-51961Exception “Index was out of range” when rendering an ODS to PDFException
CELLSNET-51863System.StackOverflowException in CollectionBase.ExistsException

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 Cell.SetTableFormula(…) methods

Support to set formulas for range of cells to create two-variable data table and one-variable data table.

Adds Cell.SetDynamicArrayFormula(string arrayFormula, FormulaParseOptions options, object[][] values, bool calculateRange, bool calculateValue, CalculationOptions copts) method

Support to set dynamic array formula with custom options for calculation, especially when there are functions which need user’s custom engine for calculation in the formula.

Adds Workbook.RefreshDynamicArrayFormulas(bool calculate, CalculationOptions copts) method

Support to refresh dynamic array formulas with custom options for calculation, especially when there are functions which need user’s custom engine for calculation functions in the dynamic array formulas.

Adds ChartFrame.TextOptions property.

Represents the font options of the chart’s text.

Adds ExportRangeToJsonOptions.ExportEmptyCells property.

Indicates whether exporting null if the cells are empty.

Add NumbersLoadOptions constructor.

Represents the options of loading numbers.

Adds enum LoadNumbersTableType.

Represnts the type of loading multi tables in a worksheet of the Mac .numbers.

Adds ProtectedRange.IsProtectedWithPassword property.

Inidicates whether the range is protected with password.

Adds ImportTableOptions.ExportCaptionAsFieldName properties

Indicates whether exporting caption as field name when importing data table.

Adds TextOptions.LanguageCode property.

Gets and sets the language code of the font.

Adds enum PresetThemeGradientType.

Represents the preset theme gradient type.

Adds GradientFill.SetPresetThemeGradient() method.

Sets the preset theme gradient type.

Adds override Style.SetBorder() methods.

Sets the borders with various kinds of color.

Adds Range.SetOutlineBorder() and Range.SetOutlineBorders() methods

Sets the borders of the range with various kinds of color.