Aspose.Cells for .NET 18.12 Release Notes

KeySummaryCategory
CELLSNET-46479Tab name not available when single sheet workbook is converted to HTMLNew Feature
CELLSNET-46503Control loading of VBA data using LoadDataFilterOptionsNew Feature
CELLSNET-42414Tracked Changes lost during conversion from XLSB to XLSM and XLS to XLSMEnhancement
CELLSNET-46090Text moved a little bit after ungrouping the shape when saving an XLS to XLSXEnhancement
CELLSNET-46439Optimization for memory performance: release original stream after loading WorkbookPerformance
CELLSNET-46371Gridlines not displayed in some sheets while converting XLSX->HTML->XLSXBug
CELLSNET-46447Formattings lost in HTML to XLS renderingBug
CELLSNET-46494MHT to XLSX conversion - cell content problemBug
CELLSNET-46468MS Excel prompts an error when opening the output fileBug
CELLSNET-46487Non-English locale formula not workingBug
CELLSNET-46489Deleting a row with an index and reading the row with the same index returns Cell.ValuType: IsNullBug
CELLSNET-46406Unable to open password protected ODS documentBug
CELLSNET-46466Bottom text under the bar code is missing in MS Excel to PDF renderingBug
CELLSNET-46470The image is missing after rendition to TIFF outputBug
CELLSNET-46499Images are not rendered properly when converted from Excel to PDFBug
CELLSNET-46443Extra text appeared in the image rendered from MS Excel chartBug
CELLSNET-46450Rendered image from MS Excel chart has more axis units than the original chartBug
CELLSNET-46451Issue when rendering the template file (containing the chart) to PDF file formatBug
CELLSNET-46454Legend order rendered differently from Excel chart in session 0 vs. session 1Bug
CELLSNET-46471Can’t set color marker LineWithDataMarkers in XLS file formatBug
CELLSNET-42729Text is displaced when SmartArt charts are rendered as HTML file formatBug
CELLSNET-46462Text repeated while replacing tag with textBug
CELLSNET-46483Error after converting document with Custom UI xml from XLSB to XLSMBug
CELLSNET-46495Issues found while converting chart to imageBug
CELLSNET-46486Exception raised while converting XLS to PDFException
CELLSNET-46472PivotTable.GetChildren() raises exception “Invalid Cell Name”Exception
CELLSNET-46452Exception “NullReferenceException” when loading an XLSB file formatException
CELLSNET-46456ArgumentException on loading workbookException
CELLSNET-46460Exception while accessing TextBox.HtmlText from the XLSException

Public API and Backwards Incompatible Changes

The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for Java. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Adds HtmlSaveOptions.ExportSingleTab property

Indicates whether exporting the single tab when the file only has one worksheet in it.The default value is false.

Adds HtmlSaveOptions.ExportPrintAreaOnly property

Indicates if only exporting the print area to html file. The default value is false.

Deletes obsoleted Workbook.Initialize() method

Use Workbook constructor instead.

Deletes obsoleted Workbook.Styles property

Use Workbook.CreateStyle() to create and manipulate style for workbook instead of StyleCollection.Add(); Use Workbook.GetNamedStyle(string) to get named style instead of StyleCollection.

Deletes obsoleted Workbook.CheckWriteProtectedPassword() method

Use WorkbookSettings.WriteProtection.ValidatePassword method instead.

Adds LoadDataFilterOptions.VBA enum

The option to used to ignore VBA projects while loading template file.

Adds Style.InvariantCustom property

Gets the culture-independent pattern string for number format (including the pattern string for built-in number).

Adds FindOptions.ValueTypeSensitive property

Indicates whether searched cell value type should be same with the searched key.

Obsoletes FindOptions.SearchNext property

Use FindOptions.SearchBackward property instead, true value for this new property corresponds to false of SearchNext.

Deletes obsoleted Cells.FindString, FindStringStartsWith, FindStringEndsWith, FindStringContains and FindNumber methods

Use Cells.Find (object,Cell,FindOptions) method instead. To get the same results with methods FindNumber, FindString, please set FindOptions.ValueTypeSensitive as true.

Deletes obsoleted Cells.ImportGridView(System.Web.UI.WebControls.GridView,int ,int , bool ,bool ,bool ) method

Use Cells.ImportGridView (System.Web.UI.WebControls.GridView gridView,int firstRow,int firstColumn,ImportTableOptions options) method. instead.

Deletes obsoleted Cells.Start property

Use Cells.FirstCell property instead.

Deletes obsoleted Cells.End property

Use Cells.LastCell property instead.

Deletes Cells[int] property

Use Cells.GetEnumerator() method to iterate all cells in this worksheet instead.

Deletes obsoleted Cells.ImportDataColumn() methods

Use Cells.ImportData (DataTable,int,int,ImportTableOptions) method instead.

Deletes obsoleted Cells.ImportDataReader() methods

Use Cells.ImportData (IDataReader, int, int,ImportTableOptions) method instead.

Deletes obsoleted Shape.Rotation property

Use Shape.RotationAngle property instead.

Deletes obsoleted Validation.AreaList property

Use Validation.Areas property instead.

Deletes obsoleted Style constructor

Use CellsFactory.CreateStyle() or Workbook.CreateStyle() method instead.

Deletes obsoleted Shape.IsPrinted property

Use Shape.IsPrintable property instead.

Deletes obsoleted PivotItem.Move(int) method

Using PivotItem.Move(int , bool ) method instead.

Deletes obsoleted Cells.ExportDataTable(int, int, int, int,bool, bool),Cells.ExportDataTable(int, int, int, int,object[]), Cells.ExportDataTable(int, int, int, int,bool),  Cells.ExportDataTable(DataTable, int, int[],int, bool) and Cells.ExportDataTable(DataTable,int, int, int, bool, bool) methods

Use ExportDataTable(firstRow,firstColumn, totalRows, totalColumns,ExportTableOptions) method instead.