Aspose.Cells for .NET 21.12 Release Notes

KeySummaryCategory
CELLSNET-49680Support converting Excel to SQL Scripts.New Feature
CELLSNET-49717Support converting Excel to xml dataNew Feature
CELLSNET-49853Support importing xml dataNew Feature
CELLSNET-48190Update priorities when adding new format conditionEnhancement
CELLSNET-49758Sorting with DataSorter affects table formattingEnhancement
CELLSNET-49828FormatConditionCollection.AddCondition() gives different behavior for the formulaEnhancement
CELLSNET-49981Add filter option for revision logs while create workbook from template fileEnhancement
CELLSNET-49739Ignore 3D references for conditional formatting when copying to another workbookEnhancement
CELLSNET-49984Read some data from corrupted xls file.Enhancement
CELLSNET-49990Support setting custom totals row formula of table.Enhancement
CELLSNET-49825Performance issue with ExportImagesAsBase64 attribute in Excel to HTML conversionPerformance
CELLSNET-49827RefersTo of defined range is incorrectly escapedBug
CELLSNET-49759Empty cells are still exported as empty XML elementsBug
CELLSNET-49817Text is not center aligned with ‘Credit Suisse Type Light’ font while rendering to EmfBug
CELLSNET-49864Words appearing in reverse order for Right-to-Left text in XLSX to PDF renderingBug
CELLSNET-49873Xlsx to pdf: Page break is different comparing with Excel generated pdfBug
CELLSNET-49922Characters do not fit on one page and print position is changed in Excel to PDF renderingBug
CELLSNET-49998Cannot view specific XLS file with HTML markupBug
CELLSNET-49742Differences in chart1.xml after savingBug
CELLSNET-49875XLSX to EMF overlapping Tick MarksBug
CELLSNET-49904Chart to PNG dates not converted properlyBug
CELLSNET-49905Regression: Issue when converting chart to PNGBug
CELLSNET-49969Overflow error when saving XLS document to XLSX/XSLMBug
CELLSNET-49760Merged Area displays wrong when converting to html.Bug
CELLSNET-49789Excel original grid should not be changed when saving html fileBug
CELLSNET-49850Picture: FitToCell parameter is not working in image smart markersBug
CELLSNET-49870The header gets wider when combining multiple sheets in Excel spreadsheetsBug
CELLSNET-49898Show border of the cells while fit images to the cells using Smart MarkersBug
CELLSNET-49924Aspose-generated XLSX files opening with errorBug
CELLSNETCORE-301Add worksheet fail when Hyperlink has a null addressBug
CELLSNET-49812Exception when open ODS fileException
CELLSNET-49876Exception when re-saving an XLSX fileException
CELLSNET-49943System.NullReferenceException when copying WorkbookException

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.

More constraints for adding areas for Validation.

We have changed the area model for Validation and Conditional formatting for performance consideration. The new model requires more constraints for the added areas sequence. For Validation.AddArea(CellArea cellArea, bool checkIntersection, bool checkEdge) and Validation.AddAreas(CellArea[] areas, bool checkIntersection, bool checkEdge), if the two “check” parameters are false, user needs to make sure that the added areas are sorted in ascending order by the top-left corners. Otherwise unexpected result may be got for other operations. In new version, because the performance of adding large amount of areas has been improved significantly, we don’t think Validation.AddArea(CellArea cellArea) will be bottleneck anymore. So we think users may just call AddArea(CellArea cellArea) directly, without the need of using those two special methods.

Changed behavior for adding format condition into FormatConditionCollection.

For FormatConditionCollection.AddCondition(…) methods, old versions make the priority of newly added one as the lowest. It is different from ms excel’s behavior. From this version, just as what you will get for the operation in ms excel, we make the newly added format condition’s priority as the highest.

Adds AbstractInterruptMonitor.TerminateWithoutException property.

This property denotes when an interruption has been required for a process, whether the process should be terminated by an Exception or just exit quietly. By default this property is false, that is, process will be terminated by an Exception when it is interrupted.

Adds WorkbookSettings.ResourceProvider property.

Renamed property for WorkbookSettings.StreamProvider to make it more suitable for its function and easier for users to understand.

Adds LoadDataFilterOptions.Revision option.

Some template files may contain large amount of revision logs and that cause poor performance for loading the workbook. User may use this option to control whether those revision logs should be loaded or not.

Obsoletes WorkbookSettings.StreamProvider property.

Please use WorkbookSettings.ResourceProvider property instead.

Deletes the obsolete property PdfSaveOptions.StreamProvider.

Please use WorkbookSettings.ResourceProvider property instead.

Adds JsonLoadOptions.MultipleWorksheets property.

Indicates whether importing each attribute of JsonObject object as one worksheet when all child nodes are array nodes.

Adds FileFormatType.SqlScript, SaveFormat.SqlScript and SqlScriptSaveOptions

Represents the options of saving sql script.

Adds SaveFormat.Xml, LoadFormat.Xml, XmlSaveOptions and XmlLoadOptions

Represents the options of R/W xml files.

Adds HtmlSaveOptions.SaveAsSingleFile property.

Indicates whether saving excel as a single file.

Adds JsonLoadOptions.MultipleWorksheets property.

Indicates whether loading the data of Json file to multiple worksheets

Adds PdfSaveOptions.Producer property.

Gets and sets producer of generated pdf document.

Adds ListColumn.GetCustomTotalsRowFormula() and ListColumn.SetCustomTotalsRowFormula() methods

Gets and sets the custom formula of totals row in the table.