Aspose.Cells for Python via .NET V23.11

Released: Nov 16, 2023

V23.11 中的更新

特性

  • Added support for Apple macOS ARM versions.
  • Grid Desktop:
    • Added support for copy/delete/insert/rename worksheet operations.
    • Auto extend max rows/columns when performing paste operations.
    • Added support for 'SheetPrintingPreview' and 'PdfSaveOptions'.
  • Generate ISO32000-1:2008 PDFs.
  • Localize dates on grouping fields.
  • Added support for 'LET' function.
  • Added support for keeping data when removing pivot tables.

修补程序

  • Removes all merged cells in the range when calling Cells.Unmerge().
  • Performance issue with removing named ranges.
  • Issue rendering shapes in Sheet to Image conversion.
  • XIRR producing negative results in cases where Microsoft Excel returns very large or very small values.
  • Add color filter results are incorrect.
  • Cells.UnhideRows() does not work for empty rows when IsDefaultRowHidden is true.
  • DataSorter sorting error with more than one 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 raised exception when clicking on specific cell.
  • The filter list values does not show completely as in 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.
  • 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.
  • Sheet tab display error and page display problem when converting file to HTML.
  • Wrong display of Grouped Rows in Pivot Table.
  • Position of Pivot Items has changed after refreshing the Pivot Table and rendering to PDF.
  • The generated file is corrupted.
  • Date formatting problem in the first column cell in pivot table.
  • Protected view after resaved XLS file.
  • Refreshed pivot table is not same as Excel.
  • The template remains in a 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.
  • Cell.HtmlString color:inherit throws an Exception "System.ArgumentException: Convert invalid primitive (Parameter 'text')".
  • ArgumentOutOfRangeException exception throws while opening XLSX file in TH culture.