Released: Nov 9, 2023

Aggiornamenti in V23.11

Funzionalità

• Added support for copy/delete/insert/rename worksheet operations to GridDesktop.
• Auto extend max rows/columns when performing paste operations in GridDesktop.
• Added support for 'SheetPrintingPreview' and 'PdfSaveOptions' in GridDesktop.
• You can now insert text boxes, form control for radio buttons, check boxes and combo boxes.
• Generate ISO32000-1:2008 PDFs.
• Localize dates on grouping fields.
• Added support for inserting common shapes.
• Show gradient fill for cell backgrounds.
• Added support for 'LET' function.
• Improved rendering of wrapped text.

Correzioni

• Removes all merged cells in the range when calling Cells.Unmerge().
• Performance issue with removing Named Ranges.
• Issue with rendering shapes in Sheet to Image conversion.
• XIRR producing negative results in cases where Excel returns very large or very small values.
• Add color filter results are incorrect.
• Cells.UnhideRows() cannot work for empty rows when IsDefaultRowHidden is true.
• DataSorter sorting error with more than 1 sort key.
• InsertCutCells breaks cell reference.
• Hidden rows are incorrect after applying auto-filter.
• Graph lines disappear when converted to PDF or PNG.
• Chart with incorrect values when saving to image.
• Template replacement failed when calling Chart.ChangeTemplate method.
• System.OverflowException: 'Value was either too large or too small for an Int32' at Aspose.Cells.Charts.Chart.Calculate method.
• The Value and Category axis is not the same as Excel when doing chart to image.
• The chart type changed after resaving the XLSX file.
• The chart is not displayed correctly after the conversion.
• GridDesktop raise exception when click on the specific cell for the customer's file.
• The filter list values does not show completely as in MS-Excel when the sheet has hidden rows.
• Cell format UI and add/edit hyperlink UI have no localization info in resource file for GridDesktop.
• Image/shape rendered at wrong position in razor page.
• Selecting textbox control and then scrolling the page will make the render position of the text out of the textbox.
• Cell text is not wrapped for distributed vertical alignment while saving file to PDF.
• Picture is missing when converting to XPS.
• Printing problem with Bold and Underline in Arial.
• Vertical Alignment not coming in style.
• Sheet tab display error and page display confusion when converting file to HTML.
• Retain filter information in Pivot table when the source table is cleared.
• Wrong displaying of Grouped Rows in Pivot Table.
• Position of the Pivot Items have changed after refreshing the Pivot Table and rendering to PDF.
• Date formatting problem in the first column cells in the pivot table.
• Protected view after resaved the XLS file.
• Refreshed pivot table is not same as MS Excel.
• Support detecting whether worksheet names should be wrapped in single quotes.
• The template remains in the shared state after setting Workbook.Settings.Shared to false.
• Excel file corrupted when adding pivot table, pivot chart and slicer to it.
• Setting default Style on a cell (PivotFieldType.Row) in pivot table corrupts the file.
• Conditional formatting is lost when saving a particular spreadsheet to PDF.
• Cell text does not render while cell style fill effects has two color gradient setting.
• ArgumentOutOfRangeException occurred when calling Cell.GetConditionalFormattingResult() method.
• ArgumentOutOfRangeException exception throws while opening XLSX file in TH culture.