Aspose.Cells for .NET 新版本發表

Released: Mar 8, 2024

V24.3 中的更新

特性

  • Added support for EVALUATE function.
  • Improved filtering in GridDesktop.
  • Support for rich text when using formula editor box.
  • Convert Microsoft Excel spreadsheets to ODS using ODF 1.3 standard.
  • Support for processing navigation links when converting AZW3 to XLSX.

修補程式

  • The ratios of width and height do not change simultaneously when Picture.IsLockAspectRatio is set to true.
  • Data shift failed after calling InsertRange method.
  • ISERROR function returns false for NPER #NUM! error.
  • Calling...

Released: Feb 6, 2024

V24.2 中的更新

特性

  • Added support for the TOROW/TOCOL functions.
  • Show "convert to number" menu for cells which have a number stored as text.
  • Added support for copying/pasting image and HTML content to GridDesktop.
  • Added key word search support for filter list to GridDesktop.
  • Added support for clear filter operation to GridDesktop.
  • Added support for number filter for GridDesktop.
  • Added support for detecting OXPS format.
  • Added support for parsing color attribute containing "var" or "rgba" fields.
  • Improved large...

Released: Jan 10, 2024

V24.1 中的更新

特性

  • Added the ability to keep the header row in each worksheet when converting a CSV to Microsoft Excel.
  • Added support for Microsoft .NET 8.
  • Added a new GridDesktop auto-fill feature.
  • Added support for adding custom styles when exporting files to HTML.
  • Added auto-fill support for the merge area.
  • Added support for setting wrap using the UI.
  • Added support for setting text rotation using the UI.
  • Auto-fill data from right to left and bottom to up.
  • Show the active sheet background in the bottom tab...

Released: Dec 12, 2023

V23.12 中的更新

特性

  • Added the option to show or hide formula warning messages in GridDesktop.
  • Added support for rendering a rotated picture in GridDesktop.
  • Added support for adjusting worksheet order in GridDesktop.
  • Added support for rendering rotated cell text.
  • Added support for PDF/A-2b (ISO 19005-2), PDF/A-2u (ISO 19005-2), PDF/A-2a (ISO 19005-2), PDF/A-3b (ISO 19005-3), PDF/A-3u (ISO 19005-3) and PDF/A-3a (ISO 19005-3) compliance while converting workbooks to PDF.
  • You can now keep missing data when...

Released: Nov 9, 2023

V23.11 中的更新

特性

  • 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...

Released: Oct 12, 2023

V23.10 中的更新

特性

  • Added support for adaptive paste operation when size of target range is different from source range.
  • Added new API for setting range hyperlinks directly on Range.
  • Added support for copying multiple worksheets simultaneously and preserving dependencies.
  • Improved performance for setting formulas with sheet references for large amount of cells.
  • Updated to SkiaSharp 2.88.6.
  • You can now ignore the threaded comments when printing comments in place.
  • Added support for checking whether one cell range...

Released: Sep 13, 2023

V23.9 中的更新

特性

  • Added support for calculating LAMBDA, MAP and SCAN functions.
  • Added support for parsing and calculating formulas with user defined custom function and definition.
  • Added support for excluding specific data when exporting data to DataTable.
  • Added localization support to GridDesktop.
  • Added support for picture click event to GridDesktop.
  • You can now auto extend empty rows/columns when scrolling down/right like Microsoft Excel.
  • Added support for selecting text within a textbox control while in...

Released: Aug 9, 2023

V23.8 中的更新

特性

  • Added support for validating formula expressions.
  • Added support for preserving padding spaces in formulas.
  • Added support for list validation.
  • Added the ability to replace text with rich formatting text.
  • Added support for using Aspose.Cells in AWS lambda function projects.
  • Improved the UI display for dropdown lists with long lists of data.
  • Added support for text length and decimal validation.

修補程式

  • Formulas of some conditional formattings can be ignored when saving XLSB.
  • CHAR function returns...

Released: Jul 13, 2023

V23.7 中的更新

特性

  • GridWeb Textbox control added support for rendering background color and border.
  • GridJs added support for rendering ActiveX control and form control as option button.
  • GridJs ComboBox added support for rendering ActiveX control and form control.
  • Added server-side 'saveback' for Combobox selected value.
  • Added 'clearHighlights' and 'updateHighlightStyle' API.
  • GridJs added support for sheet loaded events.
  • Added support for Microsoft Visio file type detection.
  • Added support for Microsoft OneNote...

Released: Jun 8, 2023

V23.6 中的更新

特性

  • Added support for traversing row/cell in reverse order.
  • Added support for refreshing multiple consolidation ranges in a pivot table.
  • Added support for showing chart sheets.
  • Added support for filtering by datetime.
  • Added support for rendering checkboxes as an ActiveX control or form control.
  • Added support for extending rows when setting a total formula.
  • Improved detection of Gzip files.
  • Improved display of background image layers.

修補程式

  • Chart does not get updated when writing new lines to a...