Aspose.Cells for .NET 22.7 Release Notes
| Key | Summary | Category |
|---|---|---|
| CELLSNET-51296 | Gridweb keeps jumping back to top when trying to copy and paste | Enhancement |
| CELLSNET-51355 | And Range.Top, Left, Width ,Height in unit of points | Enhancement |
| CELLSNET-51367 | Convert all sheets to one page when saving as html. | Enhancement |
| CELLSNET-51486 | The text rendered as small squares | Bug |
| CELLSNET-51492 | Default font is not applied when converting XLSX to HTML | Bug |
| CELLSNET-51306 | Pivot table styles not copied properly using the latest version of Aspose.Cells for .NET | Bug |
| CELLSNET-51268 | Problem with COUNTIFS formula treating 0 incorrectly | Bug |
| CELLSNET-51297 | Cell.GetPrecedents() does not provide all precedents when the formula references to defined name | Bug |
| CELLSNET-51399 | Print_Titles named range and MATCH function returns #NAME error | Bug |
| CELLSNET-51456 | cells jump when do ctrl+c ctrl+v when GridWeb height is set to 100% | Bug |
| CELLSNET-51457 | context menu does not show when height is set to 100% after some rows | Bug |
| CELLSNET-51471 | validation list does not show in empty cell | Bug |
| CELLSNET-51469 | Text in image is missing after converting to pdf | Bug |
| CELLSNET-51476 | Arrow element becomes distorted in image | Bug |
| CELLSNET-51001 | Shape object on the chart is not positioned well | Bug |
| CELLSNET-51156 | Chart to image conversion - Different display of chart in the output image | Bug |
| CELLSNET-51213 | 3-D Pie chart not properly rendered - Chart to image conversion | Bug |
| CELLSNET-51472 | Chart labels are missing from SVG when set to outside end | Bug |
| CELLSNET-51491 | Wrong values used in chart series when rendering to image or HTML | Bug |
| CELLSNET-51525 | Waterfall chart is different when exported to HTML/PNG or PDF | Bug |
| CELLSNET-51353 | Converting an XLSB file with DDE link to XLSM file is changing the DDE application position in link | Bug |
| CELLSNET-51376 | Page size is automatically changed from A4 ? Letter for a sheet | Bug |
| CELLSNET-51379 | External Link of type OLE in XLS file is being read as of type DDE | Bug |
| CELLSNET-51402 | The content is shifted content out of cell when saving html file | Bug |
| CELLSNET-51417 | Links from shape to sheet in file are removed after upgrade from 22.5 to 22.6.1 | Bug |
| CELLSNET-51418 | An external link of type xlPathMissing is changed to normal externalLinkPath type in XLSB to XLSM conversion | Bug |
| CELLSNET-51420 | Differences in the document properties in app.xml file | Bug |
| CELLSNET-51427 | External link containing special character “#” which is not escaped by Aspose.Cells | Bug |
| CELLSNET-51482 | Combining sheets from different workbooks results in corrupt file that can crash MS Excel | Bug |
| CELLSNET-51507 | Number values from XLSX file read as 0 | Bug |
| CELLSNET-51280 | Exception while saving ODS file (RB-60121) | Exception |
| CELLSNET-51483 | File Loading is failing with exception “Source array was not long enough…” | Exception |
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.
Adds Cells.GetDependentsInCalculation(int,int,bool) method
Gets all cells whose calculated result depends on the cell specified by row and column according to current calculation chain. For the cell which is empty and has not been instantiated in current cells model, user may use this method instead of Cell.GetDependentsInCalculation(bool) because the later one needs to instantiate the cell object into current cells model at first.
Changes cell’s Left/Right border for Cell.GetStyle() when the adjacent column is hidden
In old versions, if the adjacent column is hidden for one cell, then this cell’s Left/Right border will not be checked with the adjacent cell, so the returned border may be different from what shown in ms excel’s dialog when setting this cell’s border. From 22.7, we make the returned border always be the actual value(which should be consistent with the border of its adjacent cell) of the cell for Cell.GetStyle(). If user needs what shown for the cell in ms excel(when the adjacent column is hidden, the shown border may be the one of next visible column), user may try Cell.GetDisplayStyle().
Add Range.Top, Range.Left, Range.Height and Range.Width properties.
Gets the position and size of the range in unit of points.
Delete class PowerQueryFormulaCollction and add class PowerQueryFormulaCollection class.
There is a typo in the old class.
Add HtmlSaveOptions.ExportPageFooters and HtmlSaveOptions.ExportPageHeaders properties.
Indicates whether exporting headers and footers when saving as a single html file.
Adds HtmlSaveOptions.ShowAllSheets property.
Indicates whether showing all sheets when saving as a single html file.
Obsoletes HtmlSaveOptions.ExportHeadings property and add HtmlSaveOptions.ExportRowColumnHeadings property.
Please use HtmlSaveOptions.ExportRowColumnHeadings instead.
Obsoletes Chart.ToImage(string, ImageFormat) and add Chart.ToImage(string, ImageType)
Please use Chart.ToImage(string, ImageType) instead.
Obsoletes Chart.ToImage(Stream, ImageFormat) and add Chart.ToImage(Stream, ImageType)
Please use Chart.ToImage(Stream, ImageType) instead.
Obsoletes Shape.ToImage(Stream, ImageFormat) and add Shape.ToImage(Stream, ImageType)
Please use Shape.ToImage(Stream, ImageType) instead.