Lançamentos do Aspose.Cells for .NET

Released: Jul 13, 2021

Atualizações na V21.7

Funcionalidades

  • Added the option to apply conditional formatting on Pivot Tables.
  • Added the ability to create conditional formatting on PivotTable via PivotField in row area, column area and data area.
  • GridWeb - You can now run formulas similar to GridDesktop feature.
  • Added GridWeb rows and columns grouping feature.
  • Added the ability to preserve text formatting while converting from HTML to XLSX.
  • Added the ability to show cell comments (rich text) exactly as in Microsoft Excel.
  • Added support for...

Released: Jun 16, 2021

Atualizações na V21.6

Funcionalidades

  • Added the ability to get the value of SlicerCacheItem in the Slicer.SlicerCache.SlicerCacheItems collection.
  • Added support for custom Slicer styles in XLSB.
  • Added the ability to set user defined formulas as array-formulas and at the same time provide values as calculated results for those formulas.
  • Added the ability to embed fonts with ANSI encoding.
  • Added the ability to check if a worksheet is empty.

Correções

  • Deep copy of Workbook after calculation with CreateCalcChain setting...

Released: May 14, 2021

Atualizações na V21.5

Funcionalidades

  • Added support for binding Slicer Reports with pivot tables and pivot charts.
  • Added support for importing free HTML with SVG images.
  • Added support for referring to spill range with #.
  • Added support for moving existing columns in GridWeb.
  • Added support for exporting all worksheets to CSV.
  • Improved ArgumentException on CalculateFormula method.
  • Improved support for ELSE function when converting XLS to XLSX.
  • Added support for setting global PageOrientationType.
  • Improved performance...

Released: Apr 14, 2021

Atualizações na V21.4

Funcionalidades

  • Added support for getting display style with cache enabled.
  • Added the ability to render data with cell coordinates when converting Microsoft Excel to HTML.
  • Added support for Crypto with BouncyCastle API.
  • Added support for XML maps by XSD.
  • Added the ability to group data with Horizontal Smart Markers and a nested data sources.
  • Added support for collapsible rows along with Smart markers.
  • Added support for adding WebP images to XLSX files.

Correções

  • HTML style tag consumes 4Gb...

Released: Mar 11, 2021

Atualizações na V21.3

Funcionalidades

  • Added the ability to clear all merge areas on a sheet.
  • Added the ability to digitally sign Microsoft Signature Lines in Microsoft Excel spreadsheets.
  • Added Digest algorithm.
  • Added the ability to convert a Signature Line to an image.
  • Added support for copying QueryTable when copying workbooks.

Correções

  • Native chart color palette is not preserved.
  • Workbook.Settings.RemovePersonalInformation is not effective.
  • The generated file is corrupted when saving xls file with embedded word...

Released: Feb 5, 2021

Atualizações na V21.2

Funcionalidades

  • Added support for column percentage display to PivotTable.
  • You can now use LightCells API with XLSB files.
  • Updated data source when changing Waterfall chart to Column chart.
  • Added support for updating display icons in embedded JPG, ZIP and MSG objects.

Correções

  • Hang on CalculateFormula.
  • Cells.DeleteBlankRows never finishes (infinite loop) on a particular worksheet.
  • Loading xlsb results with OOM exception.
  • Wrong position of some polylines when saving .html files.
  • Arrow position...

Released: Jan 15, 2021

Atualizações na V21.1

Funcionalidades

  • Added support for Microsoft .NET 5.0.
  • Added the ability to switch row/column data series.
  • Added OleObject.SetEmbeddedObject() method.
  • Added the ability to get the data source range of the chart.

Correções

  • SmartArt shapes are not rendered fine in Excel to PDF conversion.
  • Shapes are not positioned correctly in Excel to PDF conversions.
  • Arrow graph is incomplete.
  • Diagram blocks are shifted when converting to HTML.
  • Invalid CSS and HTML markup when converting XLSX to HTML.
  • Unencoded...

Released: Dec 17, 2020

Atualizações na V20.12

Funcionalidades

  • IFS formulas can now be wrapped with curly braces after saving.
  • Added support for formulas with Sheet() function.
  • Reduced output size when converting to HTML.
  • Added the ability to display additional columns when text is overlapping next cells.
  • Added the ability to remove ODS macros in Workbook.RemoveMacro.
  • Added support for h1 tag when setting Cell.HtmlString.

Correções

  • New worksheet is missing mc:Ignorable="x14ac xr xr2 xr3”.
  • Conversion complex XLSM to HTML takes a lot of time...

Released: Nov 12, 2020

Atualizações na V20.11

Funcionalidades

  • Improved support for locale-dependent formatting pattern “aaaa” for year in Spain region.

Correções

  • Warning raised while adding 29 sheets and opening the output XLS file in Microsoft Excel.
  • Text was cut when rendering PDF.
  • An image becomes all white and some text corruption in other images/shapes.
  • Slicer on different table generates corrupted file.
  • XLSB file is corrupted after load and save.
  • Chart field containing dates has different format in PDF format.
  • Aspose.Cells generates...

Released: Sep 10, 2020

Atualizações na V20.9

Funcionalidades

  • Added support for getting and setting slicer shape properties.
  • GridWeb client API now supports adding and removing comments.
  • Added new properties to the public API.
  • Improved support for freezing and splitting worksheets.

Correções

  • Fixed an issue where chart does not allow treating #N/A as empty cells when saving as PDF.
  • Fixed an issue where Kaiti font is not properly rendered.
  • Fixed an issue where query tables are not loaded from ODS file.
  • Fixed an issue where macros should be...