Aspose.Cells for .NET Releases

Released: Jun 16, 2017

Updates in 17.6.0

Features

  • Enquote all attribute values in HTML.
  • Support for new Office 365 functions.
  • Support a table as the data source of a chart.
  • Copy PageSetup settings from an existing worksheet.

Fixes

  • Removed older Web.config settings of Aspose.Cells.GridWeb like force script_path and forcepath.
  • Exception message is wrong - The count of Hyperlinks cannot be larger than 66530.
  • Excel footer in the output PDF is not italic - it should be Arial 9 and italic.
  • Some part of subscript labels are cut and shifted to...

Released: May 15, 2017

Updates in V17.5.0

Features

  • Support for PDF/A-1a compliance in PdfSaveOptions.
  • Remove existing PrinterSettings in Excel files.
  • Implemented Custom Page Size options for worksheets.
  • Support for exporting HTML cell data to DataTable.

Fixes

  • OutOfMemory error during image rendering.
  • Converting XLS to SpreadsheetML having filters corrupts the output file.
  • Saving Excel to PDF rotates the image.
  • Wrong styles when save to HTML with css prefix.
  • Text alignment of the vertically rotated text is wrong in the output HTML.
  • Text...

Released: Apr 19, 2017

Updates in V17.4.0

Features

  • Added support for "Lock project for viewing" protection options in VBA Projects.
  • Password protect VBA projects.
  • Implemented sort warning features.

Fixes

  • PivotTable Grouping and Pivot Report Filter selection disappear when loading in GridWeb.
  • Sparklines disappear after rendering to PDF.
  • Sparklines disappear after re-saving the file.
  • OutOfMemoryException while saving CSV to PDF.
  • Format tag in the SpreadsheetML content keeps hanging on loading.
  • Remove some calls to string.ToUpper() method...

Released: Mar 15, 2017

Updates in V17.3.0

Features

  • Support for Custom Total and Grand Total labels in pivot tables.
  • Synchronize the paging of the two grids.    
  • Validate updated cells only and ignore validation of other cells.

Fixes

  • Change in pivot data source adds additional LinkSource.
  • The shape is skewed/tilted with its text "1" position changed.
  • Text in a shape is inverted while rendering worksheet to image.
  • Angle of the picture in spreadsheet is slightly different.
  • Auto shape objects have rendered incorrectly.
  • PrintArea doesn't manage...

Released: Feb 15, 2017

Updates in V17.2.0

Features

  • Trim blank rows and columns while exporting spreadsheets to CSV format.
  • Bind a worksheet to a Customized Collection object.
  • Added undo/redo feature to SortRange.
  • Added Split Panes feature to Aspose.Cells.GridDesktop.
  • Auto-rename duplicate column names while exporting data to a DataTable.
  • New utility method to retrieve all fonts names in a workbook.

Fixes

  • System.NotImplementedException at WebWorksheet.CreateSubtotal method.
  • Exception is thrown on loading Excel file.
  • When call Pictures...

Released: Jan 12, 2017

Updates in V17.1.0

Features

  • Bind Worksheets to a Customized Collection object.
  • Bind Worksheets to a DataSet object at Run Time.
  • Improved performance of PivotTable.RefreshData.
  • Improved performance of GETPIVOTDATA.

Fixes

  • MS Excel 2016 XLSX file containing Waterfall charts cannot be opened via Aspose.Cells APIs.
  • Output Excel file is not good when converting an HTML file to Excel file format.
  • Issue with Date format in German locale when rendering an Excel file to PDF.
  • Formulas with GETPIVOTDATA are not being...

Released: Dec 13, 2016

Updates in V16.12.0

Features

  • Load specific worksheets in the Workbook (for MS Excel 2007/2010).
  • Support OTS file format.
  • Expand/Collapse grouped rows/columns (Aspose.Cells.GridWeb).

Fixes

  • Date values prior to 2000 are incorrectly parsed.
  • Fraction formatting gave incorrect formatted result.
  • Make the font substitution mechanism as per .NET's default behaviour.
  • API is not able to locate default fonts in Linux under Mono.
  • Low performance while calculating the formulas for second time.
  • Performance considerations for...

Released: Nov 11, 2016

Updates in V16.11.0

Features

  • Support for MINIF and MAXIF functions.
  • Mimics MS Excel behavior when the "Enter" key is pressed.
  • Web links on a spreadsheet are now opened on the same page where the GridWeb is loaded.

Fixes

  • UpdateLinkedDataSource() doesn't work when a Workbook is loaded from a stream.
  • Deprecated .size() function used in acwmain.js.
  • Set focus on the formula back when inserting a formula with wrong parameters (invalid formula).
  • Performance issue with GetPivotData function.
  • Issue with SheetRender...

Released: Oct 11, 2016

Updates in V16.10.0

Features

  • Import XML maps by defining an array of only some columns that are related to the XML map.
  • Support for Custom Functions in Aspose.Cells.GridWeb.

Fixes

  • API hides the row containing the DIV tag with style display:none.
  • API does not import the contents between the DIV tags having style display:block.
  • API does not import contents between the DIV tags of HTML.
  • PivotTable.GetCellByDisplayName returns null for anything over the 256th field.
  • Formula in Table or ListObject does not propagate...

Released: Sep 12, 2016

Updates in V9.0.0

Features

  • Read/write values from/to ActiveX ComboBox controls.
  • Use Aspose.Cells.GridDesktop in WPF applications.

Fixes

  • Import of HTML fails when script tag uses CDATA.
  • Contents are missing while converting HTML to XLSX.
  • Unable to convert background or foreground colors from HTML.
  • Error message is shown when double-clicking on any value of the PivotTable in the output file.
  • The resultant file becomes corrupted when open and save the XLS file.
  • Final XLSX file has a lack of the caption styles while...