Released: Mar 15, 2019

Atualizações na V19.3

Recursos

• Added Name.GetReferredAreas (Boolean recalculate) method to give richer data (including external references and linked data).

Correções

• Incorrect rendering of rotated shapes in Shape to image conversion.
• Pivot Table breaks when deleting rows and columns.
• Pivot table filters are cleared after load and save.
• Issues in embedded shared file URLs while converting Excel file to HTML.
• Error in a cell that calls a macro after the file is processed by Aspose.Cells.
• Wrong value in PDF in Excel to...

Released: Feb 18, 2019

Atualizações na V19.2

Recursos

• Added new Range.Hyperlinks property which gets all hyperlinks in a range.

Correções

• Different encrypted XLSX from encrypted PPTX and encrypted DOCX.
• Replace invalid characters with suitable symbols like brackets.
• Open/save removes table alternative text.
• Performance Issue with Aspose.Cells APIs.
• Text of TextBox is cut.
• Pictograms are not visible in the output PDF in Excel to PDF rendering.
• Conditional formatting in Pivot table does not work in a copied sheet.
• Content missing from HTML...

Released: Jan 17, 2019

Atualizações na V19.1

Recursos

• New feature shows all report filter pages according to a PivotField's name, the PivotField must be located in the PageFields.
• Handle overflowing cell content while saving as PDF and image.
• Added support for Excel95/5.0 XLS files.
• Added the ability to sort by cell background color.
• Detect if generated MHT file is a worksheet or not.

Released: Dec 18, 2018

Atualizações na V18.12

Recursos

• Tab name now available when single sheet workbook is converted to HTML.
• Control the loading of VBA data using LoadDataFilterOptions.
• Optimized memory performance: release original stream after loading Workbook.

Correções

• Tracked Changes lost during conversion from XLSB to XLSM and XLS to XLSM.
• Text moved after ungrouping a shape when saving an XLS to XLSX.
• Gridlines not displayed in some sheets while converting XLSX to HTML to XLSX.
• Formattings lost in HTML to XLS rendering.
• MHT to XLSX...

Released: Nov 19, 2018

Atualizações na V18.11

Recursos

• Check to see if a cell contains a circular formula.
• Fetch Pivot Table refresh date similar to Interop.Excel.

Released: Oct 18, 2018

Atualizações na V18.10

Recursos

• Read connection points from shapes.
• Change a column's fixed size width into a scalable unit.

Correções

• Issue with image source when rendering Excel to HTML file format.
• Font size changed from 6.5 to 6 while converting XLSX to HTML .
• Recognize empty tags while converting HTML to MS Excel file format.
• Sub-Total missing when rows collapsed after refresh.
• Issue in number fields while calling the Worksheet.AutoFitColumns().
• XLSB file corrupt on opening and saving.
• CSV import creates...

Released: Sep 17, 2018

Atualizações na V18.9

Recursos

• Apply text alignment to partial text inside TextBoxes.
• Export custom document properties to PDF.
• Get XML path from List Object/Table.
• Added support for stock charts in ODS files.

Released: Aug 15, 2018

Atualizações na V18.8

Recursos

• Apply text alignment to partial text inside a TextBox.
• Read/write connections in XLSB files.
• Added support for parsing formulas from revision logs to binary arrays.
• Set ContentCopyForAccessibility option while converting a spreadsheet to PDF file format.
• Encrypt an ODS file.
• Open encrypted ODS files.
• Added support reading and writing DConn in XLS files.
• Add overloads to CopyRows and CopyColumns with Paste Special options.
• Retrieve Subtotaling settings.

Released: Jul 12, 2018

Atualizações na V18.7

Recursos

• Added support for Pivot Table Slicers.
• Added support for encrypting and decrypting ODS files.
• Use List<dynamic> or List<ExpandoObject> as DataSource for importing data into worksheet.
• Added WorkbookSettings.MaxRow and WorkbookSettings.MaxColumn properties.
• Added WriteProtection.Author property.

Correções

• Round images become square images in the output PDF
• Pivot table filters not working after load and save.
• Exception "Invalid BIFF8 file" when loading an XLS file.
• Exception...

Released: Jun 19, 2018

Atualizações na V18.6

Recursos

• New APIs to create and modify Excel Slicers.
• New API to Get and Set CustomXmlPart ID.
• Improved converting line Callout to image.
• Added WorkbookRender.ToImage(pageIndex, fileName/stream) and Bitmap WorkbookRender.ToImage(int pageIndex) methods.
• Added support for DateTimeOffset format when importing custom objects.
• Relevant methods added for GetRangeAddess(), GetCellCount(), GetEntireAddress() and GetOffset().
• Convert smart art from XLSX to XLS file format.
• Convert smart art from XLS to...