Released: Sep 8, 2022

Actualizaciones en V22.9

Características

• Added support for discrete grouping of data in XLS files.
• Added support for preset settings for gradient fill.
• Added support for setting table formula in datatable.
• Added support for converting OZM to LBM using the CONVERT function.
• Improved the recognition of user’s input for 'Style.Custom'.
• Added support for multiple tables in a worksheet of .Numbers files.
• Added support for exporting empty cells as null to JSON.
• Improved the ability to detect whether the first row is header row.
• Added support for applying outline borders with ThemeColor to Range.
• Added support for reading and writing a protected range with SHA-512 in XLSB files.

Correcciones

• Some symbols changed after converting Excel file to PDF.
• mm becomes “??” in PDF.
• Re-saved XLSM file (containing a pivot table) got corrupted.
• External connections are corrupted in generated file.
• Wrong text bold style on converting Excel pivot table to PDF.
• When XLS file with Pivot table is converted to XLSM, the data connections details got deleted.
• XLS to XLSM conversion - MS Excel could not open the output XLSM file.
• Dynamic array formula does not populate spilled cells.
• Some formulas are not calculated to update the data across the sheets upon changing selection.
• Values from XLSX are incorrect in the output PDF.
• Recalculation of a workbook is slow after calculating with calculation chain.
• HLOOKUP value is incorrect.
• Vertical dotted lines misaligned with labels on axis in chart to SVG rendering.
• System.Security.Cryptography.Pkcs 6.0.1 dependency requires .NET Core 3.1.
• When converting Excel to PDF, the resultant PDF does not show axis correctly.
• Gridweb keeps jumping back.
• Number is hidden behind red/green circle when exporting Excel to HTML on docker (Azure cloud kubernetes).
• Issue with calculating “PageSetup.Zoom” with HorizontalPageBreaks.
• XLSX to PDF: Character spacing is wrong.
• Add identifier attribute for chart/group in Excel Workbook.
• Unnecessary borders are added for the data in Excel to DOCX conversion.
• Cell borders got lost in the resultant PDF.
• Invalid record for single cell caused generated file corrupted.
• Worksheet.AutoFitColumns is not working right.
• Merged Cells does not work fine when saving as PowerPoint file.
• After cells are merged some data are lost in the generated PowerPoint file.
• Connection info is getting changed when converting XLS file to XLSM.
• Converting an XLS file to XLSM is deleting few chars at the end of the link in named ranges.
• DOCX » Html table » Excel sheet does not convert properly.
• AutoFit worked differently in v22.1.0 and v22.8.0.
• XLS to XLSM file conversion caused some custom properties lost.
• Input document stream is prematurely disposed after creating Workbook for particular file.
• XLS worksheet has no data while you can see filled rows in Excel.
• XLSB to XLSM conversion - the output XLSM file is corrupted.
• XLS to XLSM conversion - the output XLSM file is corrupted.
• Cannot apply a copied style without setting its flags to explicit or using a flag.
• Cell protection is lost after opening and re-saving the XLSX file.
• DataTable Column Caption property is not honored and rendered in the output Excel when importing data.
• Incorrect locale in chart text elements.
• The name of built-in styles does not automatically change according to region.
• Calculating workbook throws Stackoverflow exception.
• Exception when importing an XLSX file with Accounting formatting into Aspose.Cells.GridDesktop.
• Exception “Index was out of range” when rendering an ODS to PDF.
• System.StackOverflowException in CollectionBase.Exists.