Aspose.Cells for .NET 23.6 Release Notes
|Support to traverse Row/Cell in RowCollection/Row in reversed order
|Support refreshing multiple consolidation ranges of pivottable
|Support to show chart sheet in GridJs
|Support to filter by datetime in GridJs
|Support to render activex control and form control for checkbox in GridJs
|Row with no data should be taken as blank and removed by Cells.DeleteBlankRows() even if there is merged cells intersect with it
|Chart does not get updated when writing new lines to a listobject with Aspose.Cells
|Support extending rows when setting formula to totals row in the table
|Detect Gzip Fileformat
|Cell overflow content is not always rendered in GridJs
|Support to set loading gif in loadoptions for GridJs
|Layer display solution for background image
|Arrow Shapes placed incorrectly after conversion to HTML
|Arrow Shapes placed incorrectly after conversion to PDF
|Text is upside down in some shapes - Excel to PDF conversion
|Letters in the shapes become upside down in Excel to PDF conversion
|RadioButtons are not displayed correctly in PDF and HTML
|Tildes in a CONCATENATE function are turned into commas
|Conditional formatting rule “not between” works differently than Excel
|Comments are deleted when deleting blank rows
|Generated xlsx file with volatile dependencies is not fully compatible with Open Xml SDK
|Time part “08:00” in ms excel was formatted as “8:00” by Aspose.Cells
|Last row is cut off while converting workbook to PDF with OnePagePerSheet set to true
|XmlMap references not shifting when rows are imported
|Xml Import does not preserve column widths
|Excel Tiff generation takes too much time
|PDF conversion is making a few extra empty pages
|The header and formats are not aligned properly when importing html to excel
|Saving HTML has visual issues with tables
|File crash when adding data to the total row of the table
|Provide some options/means to keep the format (style) for the values inserted into the Table/List Object
|Style of Totals row covered by style of previous row when showing totals row.of the table
|PowerQueries lost after replacement
|Font and font size is not set to all lines in the textbox when exporting to XLS
|Pivot table rows are not merged in PDF when the grand total is added
|Aspose moves a graph beneath a table when totals row is enabled while excel does not
|InsertCutCells - Cutting rows and then inserting them somewhere else does not maintain formula references
|The value of merged cells changed when copying columns
|Chart is not being moved down after adding rows
|Horizontal data in a chart is not expanded.
|When a sheet with ActiveX controls is copied to another workbook, some differences/issues occurred
|Copied shapes become free forms
|shape id changed after being saved and reloaded
|Cell background color fill size is not exactly matched
|Loading XLSX: Un-representable DateTime exception
|Exception for image loading in slow 3g network
|Edit focus cell out of the view when the soft keyboard shows in mobile device
|Sometimes single click on cell does not trigger cell select in mobile device
|Exception throw: ‘Shape to image Error!’
|Range merge exception while refreshing pivot table
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 .NET. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.
Changes behavior of Cells.DeleteBlankRows() method
In old versions, we did not take a row as blank if it intersects some merged cells so it will not be deleted. From 23.6, if one row intersects some merged cells only and has no cell data or other related objects, it will be taken as blank and will be deleted.
Changes behavior of constructing save options with mismatched save format
For constructing specific save options with save format, sometimes user may provide unmatched format as the parameter. In old version the unmatched format may be accepted directly, this may cause ambiguities and even unexpected result. From 23.6, we reset the unmatched save format to a default one which matches the specific save options. Those influenced save options and default format are: OoxmlSaveOptions-xlsx, HtmlSaveOptions-html, OdsSaveOptions-ods, XlsSaveOptions-xls.
Adds RowCollection.GetEnumerator(bool reversed, bool sync) method
Provides user the ability of traversing Row objects in the collection in reversed order.
Obsoletes XlsSaveOptions.IsTemplate method
For template file, please create save options by XlsSaveOptions(SaveFormat.Xlt). Otherwise create it by XlsSaveOptions().
Adds ImageBinarizationMethod enum
Specifies the method used to binarize image.
Adds ImageOrPrintOptions.TiffBinarizationMethod property
Gets and sets method used while converting images to 1 bpp format when ImageType is Tiff and TiffCompression is equal to Ccitt3 or Ccitt4.
Adds ListColumn.GetDataStyle() and ListColumn.SetDataStyle(Style) methods.
Gets and sets the style of the column in the table.
Adds ListObject.PutCellFormula(int,int,string,bool) method.
Sets the formula to table.
Adds RevisionLogCollection.HighlightChanges(HighlightChangesOptions) method and HighlightChangesOptions class.
Exports and highlights all revision logs to a new worksheet.
Adds FileFormatType.GZip enum.
It’s used to detect whether the file is GZip file.