News & Releases
|
|
Spire.XLS 11.1 supports using newly added formulas of MS Excel2019
We are happy to announce the release of Spire.XLS 11.1. This version optimizes the conversion from Excel to HTML, supports using the newly added formulas of MS Excel2019 to do calculations, adds some new features such as the availability of removing borders of pictures, the conversion from shape to picture and so forth. In addition, it also enhances the conversion from Excel to PDF/HTML and fixes the issues occurred when loading and saving documents. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| Optimization | SPIREXLS-2965 | Optimizes the speed of converting Excel to HTML. |
| New feature | SPIREXLS-2244 | Supports calculating newly added CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN of MS Excel2019. |
| New feature | SPIREXLS-2872 | Supports the function of not displaying the title of bubble chart.
chart.HasChartTitle = false; |
| New feature | SPIREXLS-2254 | Supports the function of removing the borders of pictures.
picture.Line.Visible = false or picture.Line.Weight = 0 |
| New feature | SPIREXLS-2990 | Supports the function of converting shape to picture.
Image img = shape.SaveToImage();
shape.SaveToImage(string fileName);
shape.SaveToImage(string fileName, ImageFormat imageFormat);
shape.SaveToImage(Stream fileStream);
shape.SaveToImage(Stream fileStream, ImageFormat imageFormat);
|
| New feature | SPIREXLS-3059 | Supports the function of compressing pictures in Excel.
Workbook book = new Workbook();
book.LoadFromFile(input);
foreach (Worksheet sheet in book.Worksheets)
{
foreach (ExcelPicture picture in sheet.Pictures)
{
picture.Compress(30);
}
}
book.SaveToFile(result, ExcelVersion.Version97to2003);
|
| Bug | SPIREXLS-2424 | Fixes the issue that getting the chart title failed. |
| Bug | SPIREXLS-2912 | Fixes the issue that the date data was incorrectly wrapped when converting Excel to PDF. |
| Bug | SPIREXLS-3002 | Fixes the issue that the application threw System.OverflowException when loading file. |
| Bug | SPIREXLS-3007 | Fixes the issue that the application threw System.ArgumentOutOfRangeException when loading and saving files. |
| Bug | SPIREXLS-3008 | Fixes the issue that the data bar of the conditional format was not displayed correctly when converting Excel to PDF. |
| Bug | SPIREXLS-3013 | Fixes the issue that creating a pivot table failed in the environment with Win10 64-bit and Italy region setting. |
| Bug | SPIREXLS-3018 | Fixes the issue that the text boxes could not be copied correctly. |
| Bug | SPIREXLS-3020 | Fixes the issue that the text font indentation was changed from condensed to standard when copying cell content. |
| Bug | SPIREXLS-3021 SPIREXLS-3037 SPIREXLS-3053 |
Fixes the issue that the application hung when converting Excel to Html. |
| Bug | SPIREXLS-3033 | Fixes the issue that the format of date data was incorrect when importing sheet data to data table. |
| Bug | SPIREXLS-3034 | Fixes the issue that inserting and deleting rows took a long time. |
| Bug | SPIREXLS-3041 | Fixes the issue that the data of the category label in the chart was incorrect when saving the chart to images. |
| Bug | SPIREXLS-3044 | Fixes the issue that the characters were garbled when converting CSV file with Turkish ISO-8859-9 encoding to xlsx file. |
Click the link to download Spire.XLS 11.1:
More information of Spire.XLS new release or hotfix:
