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

Released: May 23, 2018

Updates in V18.5

Features

• Added support for Strict Open XML Spreadsheet format.

Fixes

• The color of the image should be black when converting to PDF.
• Page Setup PrintErrorType not working in Excel to PDF rendering.
• PageSetup.PrintDraft does not take effect while Saving to PDF.
• System.OutOfMemoryException while converting Excel file to PDF.
• Page field named "Absent item Yes" is lost on Refresh.
• Calculation error when using calculation chain and defined name.
• A few columns disappear when importing an Excel file...

Released: Apr 18, 2018

Updates in V18.4

Features

• Set Pdf Page size when using the Chart.ToPdf method.
• Added support for rendering Histograms in Microsoft Excel 2016 charts.
• Added FilterMode property.
• Added support for additional cell modification in cellModifiedOnAjax.
• Process standard LINK elements during backward conversion.

Fixes

• Excel to PDF rendering - header/footer problem.
• When auto-fit a column, Aspose.Cells do not consider the row height when the cell is text wrapped.
• Issue with auto-fit columns operation with wrapping text...

Released: Mar 15, 2018

Updates in V18.3

Features

• Group pivot fields in a Pivot Table.

Fixes

• Exception during backward HTML-to-Cells conversion.
• Add property to the StyleFlag to not override the QuotePrefix value.
• ActiveX control becomes a picture when copying a sheet from one workbook to another.
• Data validation - GridWeb should display a dialog with an error message.
• Workbook.CalculateFormula hangs infinitely when setting specific value to the cell.
• Underline of text "KEY DRIVERS:" is broken in the output image.
• Besides broken...

Released: Feb 6, 2018

Updates in V18.2

Features

• Added ImportTableOptions.IsFormulas option when converting cell content to a Hyperlink.
• Set comment margins.
• Added WorkbookSetting.StreamProvider to control external resources.

Fixes

• Unsupported external stylesheet during round trip conversion.
• DDE link is not present inside Worksheets.ExternalLinks.
• Aspose.Cells.GridWeb does not enter text like Microsoft Excel when wrap text is enabled.
• Image properties (Title and Subject) are lost in Shape to image conversion.
• Inverted characters in...

Released: Dec 14, 2017

Updates in V17.12

Features

• Obtain CSS separately from HTML markup when exporting to HTML using streams.
• Implemented Cell.FormulaLocal functionality, which is similar to Microsoft Interop FormulaLocal.
• Added support for Office-Add-Ins when rendering Excel files to PDF.
• Update "Keep change history" when sharing workbooks.

Fixes

• Text in cells is overlapping with other cells.
• Images are confused in a picture shape with texture fill.
• Refreshing PivotTable corrupts MS Excel file.
• Array formula involving "MEDIAN" is...

Released: Nov 17, 2017

Updates in V17.11

Features

• Added XmlMapQuery like functionality.
• Added associated property for XMLMaps to read the RootElementName for the map.
• Protect shared workbooks with passwords.
• Added support for PasteType during Copy/Paste actions.
   

Fixes

• Scale becomes smaller - fonts issue.
• Unable to read Smart Art shape text.
• Pivot table is taking too long to refresh data.
• Direction of shape is wrong when converted to image format.
• Star shapes are not shown correctly in the output PDF.
• Characters overlap when converting...