Aspose.Cells for .NET 18.2 Release Notes
| Key | Summary | Category |
|---|---|---|
| CELLSNET-45889 | Convert cell content to Hyperlink - ImportTableOptions.IsFormulas option | New Feature |
| CELLSNET-45886 | Set comment’s margins | New Feature |
| CELLSNET-45855 | Provide WorkbookSetting.StreamProvider to control external resources | New Feature |
| CELLSNET-45845 | Unsupported external stylesheet during round trip conversion | Enhancement |
| CELLSNET-45888 | DDE link is not present inside Worksheets.ExternalLinks | Enhancement |
| CELLSNET-45893 | Aspose.Cells.GridWeb does not enter text like Microsoft Excel when wrap text is enabled | Enhancement |
| CELLSNET-45833 | Image properties (Title and Subject) are lost in Shape to image conversion | Bug |
| CELLSNET-45822 | Inverted characters in labels when converting Excel to PDF | Bug |
| CELLSNET-45776 | Some columns data is not fully expanded/displayed when saving an MHtml file to Excel file format | Bug |
| CELLSNET-44829 | Output HTML does not match with Microsoft Excel | Bug |
| CELLSNET-44319 | Pivot table filter value is not retained upon refresh | Bug |
| CELLSNET-45887 | ‘#VALUE!’ error for ArrayFormula’s calculation | Bug |
| CELLSNET-45883 | 3D Pie chart - is not rendered good in the output PDF | Bug |
| CELLSNET-45881 | Opening and saving the input Excel file causes Red Protected View warning in MS Excel | Bug |
| CELLSNET-45880 | Part of x-axis labels are rendered in the second line in chart | Bug |
| CELLSNET-45864 | EMF converted from Aspose.Cells is not exactly accurate | Bug |
| CELLSNET-45885 | The type (attribute) of external link is changed after open/save | Bug |
| CELLSNET-45872 | Unable to read Excel data connection when its type is CSV | Bug |
| CELLSNET-45868 | PrintTitleRows property value disappears after open and save by Aspose.Cells | Bug |
| CELLSNET-45865 | Special characters used in a column name is not working - Smart Markers issue | Bug |
| CELLSNET-45858 | Change of link source is impacting contents of drop-downs | Bug |
| CELLSNET-45857 | Corrupted file when copying sheet from one workbook to another | Bug |
| CELLSNET-45901 | Textbox alignment lost when rendered to PDF | Bug |
| CELLSNET-45875 | Cell value is lost and some part of x-axis labels are rendered in the second line | Bug |
| CELLSNET-45873 | Implementation of interactive control for groups of radio buttons in GridWeb | Bug |
| CELLSNET-45902 | Worksheet becomes over sized and unresponsive when navigating to or clicking it in Aspose.Cells.GridWeb | Bug |
| CELLSNET-45849 | Image is getting outside of grid worksheet size | Bug |
| CELLSNET-45824 | Images in Excel file are not shown in normal size when importing the file into Aspose.Cells.GridDesktop | Bug |
| CELLSNET-45874 | Exception “Input string was not in a correct format” when importing the Excel file into Aspose.Cells.GridWeb | 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 LoadDataFilterOptions.DefinedNames enum
Indicates whether loading defined Name objects when loading template file.
Changes the behavior of LoadDataFilterOptions.Formula enum
In older versions we always load defined Name objects when loading formulas. Now we provide separate enum for defined Name objects explicitly, so Formula enum will only denote that formulas should be loaded now, no matter the defined Name objects will be loaded or not. However, one thing should be noted, commonly defined Name objects are used by formulas, if user only loads formulas and does not load the defined Name objects, the cell formula which refers to those Names will become corrupted and may cause Exception. So, generally if user wants to load formulas, the defined Name objects should be loaded too. But user can load only defined Name objects without loading formulas.
Add SheetType.Dialog enum
Represents dialog sheet.
Adds WorkbookSettings.MaxRowsOfSharedFormula property
Gets and sets the max row number of shared formula. The shared formula will be split to several shared formula if the total rows of shared formula is greater than it.
Adds WorkbookSettings.StreamProvider property
Gets and sets the stream provider for external resource.
Adds ShapeTextAlignment.IsAutoMargin property
Indicates whether the margin of the text frame is atuomatic.
Adds ImportTableOptions.IsFormulas property
Represents which column in the datatable should be imported as formulas.