Aspose.Cells for .NET Releases
Released: Mar 15, 2019
Updates in V19.3
Features
- Added Name.GetReferredAreas (Boolean recalculate) method to give richer data (including external references and linked data).
Fixes
- 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 PDF...
Released: Feb 18, 2019
Updates in V19.2
Features
- Added new Range.Hyperlinks property which gets all hyperlinks in a range.
Fixes
- 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 to...
Released: Jan 17, 2019
Updates in V19.1
Features
- 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
Updates in V18.12
Features
- 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.
Fixes
- 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
Updates in V18.11
Features
- Check to see if a cell contains a circular formula.
- Fetch Pivot Table refresh date similar to Interop.Excel.
Released: Oct 18, 2018
Updates in V18.10
Features
- Read connection points from shapes.
- Change a column's fixed size width into a scalable unit.
Fixes
- 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 incorrect...
Released: Sep 17, 2018
Updates in V18.9
Features
- 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
Updates in V18.8
Features
- 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
Updates in V18.7
Features
- 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.
Fixes
- 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 when...
Released: Jun 19, 2018
Updates in V18.6
Features
- 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...