Aspose.Cells for .NET 19.11 Release Notes
| Key | Summary | Category |
|---|---|---|
| CELLSNET-44956 | Support to hide selected ranges and sort the displayed results of Pivot Table | New Feature |
| CELLSNET-46852 | Support reading and writing table whose data source is a query table in the XLS file. | New Feature |
| CELLSNET-46967 | Support to get indent size in unit of pixels | New Feature |
| CELLSNET-46973 | Excel formula not working in generated XLS file | Enhancement |
| CELLSNET-46981 | Support to read/write with memory stream for Workbook.ImportXml and Workbook.ExportXml | Enhancement |
| CELLSNET-46905 | No changes for link source saved in XLS file | Enhancement |
| CELLSNET-46898 | The background of the 3D model turns blue | Bug |
| CELLSNET-46314 | Issues while refreshing Pivot Table with “Show value as % of grand total” | Bug |
| CELLSNET-46789 | CalculateData method does not work correctly with PDF format | Bug |
| CELLSNET-46955 | HTML to Excel file raises exception “Item has already been added” | Bug |
| CELLSNET-46987 | Can’t calculate formula when referencing cells | Bug |
| CELLSNET-46968 | The indirect formula does not work properly in MS Excel | Bug |
| CELLSNET-46991 | XLSX file is corrupted. | Bug |
| CELLSNET-46994 | #Value! in the output Excel file (Opened in Excel 365)after calling the Calculate Formula | Bug |
| CELLSNET-47001 | CalculateFormula() causes NullReferenceException | Bug |
| CELLSNET-46953 | Content is cut when printing | Bug |
| CELLSNET-46966 | Right Border missing when HorizontalAlignment is set to Fill | Bug |
| CELLSNET-45362 | Tile picture options don’t work for chart backgrounds in XLS files | Bug |
| CELLSNET-46949 | OLE objects become pictures when copying worksheets | Bug |
| CELLSNET-46963 | Chart labels lose formatting after saving Excel file | Bug |
| CELLSNET-46965 | Calling Chart.Calculate() on an empty chart that has an empty auto-text title throws an error | Bug |
| CELLSNET-46971 | The newly copied sheet is un-hiding any hidden columns and also resetting columns width | Bug |
| CELLSNET-46972 | Comma removed from chart titles once Excel file is decrypted | Bug |
| CELLSNET-46912 | StackOverflowException thrown while converting XLSX to HTML | 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 methods: Validation.AddArea(CellArea,bool,bool),AddAreas(CellArea[], bool, bool),RemoveAreas(CellArea[])
Adds/Removes validation settings from given area(s) with performance consideration.
Adds Workbook.ImportXml(Stream stream, string sheetName, int row, int col) method.
Imports an XML file stream into the workbook.
Adds Workbook.ExportXml(string mapName, Stream stream) method.
Export XML data to a stream.
Adds HtmlSaveOptions.ExportArea property
Gets or Sets the exporting CellArea of current active Worksheet. If you set this attribute, the print area of the current active Worksheet will be omitted. Only the specified area will be exported when saving the file to HTML.
Adds classes : DataMashup,PowerQueryFormula,PowerQueryFormulaCollection,PowerQueryFormulaItem and PowerQueryFormulaItemCollection
Gets info in the DataMashup.
Adds DBConnection.SeverCommand property.
Gets and sets a second command text string that is persisted when PivotTable server-based page fields are in use.
Adds CellsHelper.GetTextWidth() method.
Gets the width of the text in the unit of points.