We are excited to announce the release of Spire.XLS 15.4.0. This version introduces more than ten new formulas, such as RANK.AVG, PERCENTILE.INC, and BINOM.DIST. It also enhances the conversion from Excel to PDF. Besides, a lot known issues are fixed successfully in this version, such as the issue where the structure protection password was lost when saving Excel documents. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-5695 | Supports the RANK.AVG formula.
workbook.Worksheets[0].Range["E9"].Formula = "=RANK.AVG(10,A1:A6)"; |
| New feature | SPIREXLS-5696 | Supports the RANK.EQ formula.
//Default descending order workbook.Worksheets[0].Range["E9"].Formula = "=RANK.EQ(10,A1:A6)"; |
| New feature | SPIREXLS-5722 | Supports the PERCENTILE.INC formula.
workbook.Worksheets[0].Range["D2"].Formula = "=PERCENTILE.INC(\"\", 0.3)"; |
| New feature | SPIREXLS-5723 | Supports the PERCENTILE.EXC formula.
workbook.Worksheets[0].Range["D2"].Formula = "=PERCENTILE.EXC(\"\", 0.3)"; |
| New feature | SPIREXLS-5729 | Supports the BINOM.DIST formula.
workbook.Worksheets[0].Range["D2"].Formula = "=BINOM.DIST(A7, A11, A12, FALSE)"; |
| New feature | SPIREXLS-5730 | Supports the BINOM.INV formula.
workbook.Worksheets[0].Range["D2"].Formula = "=BINOM.INV(A7, A12, A13)"; |
| New feature | SPIREXLS-5734 | Supports the NEGBINOM.DIST formula.
workbook.Worksheets[0].Range["C10"].Formula = "=NEGBINOM.DIST(10,5,1,TRUE)"; |
| New feature | SPIREXLS-5738 | Supports the BINOM.DIST.RANGE formula.
workbook.Worksheets[0].Range["C6"].Formula = "=BINOM.DIST.RANGE(10, 2, 5)"; |
| New feature | SPIREXLS-5739 | Supports the BETA.DIST formula.
workbook.Worksheets[0].Range["C7"].Formula = "=BETA.DIST(3, 0, 5, TRUE, 1, 5)"; |
| New feature | SPIREXLS-5740 | Supports the BETA.INV formula.
workbook.Worksheets[0].Range["C7"].Formula = "=BETA.INV(0.685470581, 8, -1, 1, 3)"; |
| New feature | SPIREXLS-5742 | Supports the ROUNDBANK formula.
workbook.Worksheets[0].Range["B3"].Formula = "=ROUNDBANK(1245585, -1)"; |
| New feature | SPIREXLS-5743 | Supports the GAMMA formula.
workbook.Worksheets[0].Range["B3"].Formula = "=GAMMA(ss)"; |
| New feature | SPIREXLS-5744 | Supports the GAMMA.DIST formula.
workbook.Worksheets[0].Range["B10"].Formula = "=GAMMA.DIST(10.0001131, 9, 0, TRUE)"; |
| New feature | SPIREXLS-5745 | Supports the GAMMA.INV formula.
workbook.Worksheets[0].Range["B10"].Formula = "=GAMMA.INV(0.068094, 0, 2)"; |
| New feature | SPIREXLS-5748 | Supports the TAKE formula.
workbook.Worksheets[0].Range["J16"].Formula = "=TAKE(A1:F6,3)"; |
| New feature | SPIREXLS-5751 | Supports the HSTACK formula.
workbook.Worksheets[0].Range["G26"].Formula = "=HSTACK(E1:F7,G1:G6)"; |
| Bug | SPIREXLS-5653 | Fixes the issue where content was not fully displayed when converting Excel to PDF. |
| Bug | SPIREXLS-5706 | Fixes the issue where the program threw an "ArgumentOutOfRangeException" when loading Excel documents. |
| Bug | SPIREXLS-5713 | Fixes the issue where incorrect data was generated when converting Excel to PDF. |
| Bug | SPIREXLS-5716 | Fixes the issue where charts were incorrect when converting Excel to PDF. |
| Bug | SPIREXLS-5719 | Fixes the issue where content was stretched when converting Excel to PDF. |
| Bug | SPIREXLS-5721 | Fixes the issue where the structure protection password was lost when saving Excel documents. |
| Bug | SPIREXLS-5735 | Fixes the issue where setting FormatConditionType.ColorScale had no effect or produced incorrect results. |
| Bug | SPIREXLS-5749 | Improves behavior to prevent throwing "InvalidOperationException: Cannot find font installed on the system" when no fonts are available on the system. |
Click the link to download Spire.XLS 15.4.0:
More information of Spire.XLS new release or hotfix:
