We are glad to announce the release of Spire.XLS 13.2.4. This version supports the FLOOR.MATH formula as well as "what if analysis" goal seek and supports setting the Boolean value of addQuotationForStringValue to make the result strings have quotation marks after converting excel to CSV. Besides, this version enhances the conversion from Excel to PDF and images. Moreover, some known issues are successfully fixed in this release. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-4405 | Supports setting the Boolean value of addQuotationForStringValue to make the result strings have quotation marks after converting Excel to CSV.
Workbook workbook = new Workbook(); workbook.LoadFromFile(@"ToCSV.xlsx"); //The last parameter " true" makes the result strings have quotation marks workbook.SaveToFile(@"ToCSV.csv", ",",true); |
| New feature | SPIREXLS-4422 | Supports running "what if analysis" goal seek.
Workbook book = new Workbook(); book.LoadFromFile(inputFile); Worksheet sheet = book.Worksheets[0]; CellRange targetCell = sheet.Range["E2"]; CellRange gussCell = sheet.Range["B4"]; GoalSeek goalSeek = new GoalSeek(); GoalSeekResult result= goalSeek.TryCalculate (targetCell, 2000, gussCell); result.Determine(); |
| New feature | SPIREXLS-4386 | Supports the FLOOR.MATH formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "FLOOR.MATH(12.758,2,-1)";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx");
|
| Bug | SPIREXLS-3469 | Fixes the issue that the fonts changed after converting an Excel file to PDF. |
| Bug | SPIREXLS-4367 | Fixes the issue that the values were incorrect after referencing the external data source. |
| Bug | SPIREXLS-4402 | Fixes the issue that the content format was incorrect after converting an Excel file to PDF. |
| Bug | SPIREXLS-4403 | Fixes the issue that the content format was incorrect after converting Excel files to images with netstandard dlls. |
| Bug | SPIREXLS-4407 | Fixes the issue that the Conditional Format range was incorrect after invoking DeleteRange() method. |
| Bug | SPIREXLS-4412 | Fixes the issue that it didn't take effect to set IsTextWrapped for chart data label. |
| Bug | SPIREXLS-4420 | Fixes the issue that the application threw "OutOfMemoryError" when converting an Excel file to PDF. |
| Bug | SPIREXLS-4424 | Fixes the issue that the obtained background color of the cell range was incorrect. |
| Bug | SPIREXLS-4413 | Fixes the issue that it didn't take effect to invoke workbook.IsSaved. |
Click the link to download Spire.XLS 13.2.4:
More information of Spire.XLS new release or hotfix:
