We’re pleased to announce the release of Spire.XLS 16.2.4. This version adds support for the LET and MAP functions. Additionally, several issues related to sorting, conditional formatting, column width display, image conversion, font settings, and Excel-to-PDF conversion have been fixed. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New Feature | SPIREXLS-6086 SPIREXLS-6087 | Added support for the LET and MAP functions.
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
sheet.Range["C1"].Text = "out";
sheet.Range["C2"].Formula = "=LET(x, 5, y, 10, x + y)";
sheet.Range["C3"].Formula = "=LET(a, 1, b, 2, c, 3, d, 4, a+b+c+d)";
sheet.Range["C4"].Formula = "=LET(outer, LET(inner, 5, inner*2), outer+10)";
sheet.Range["C5"].Formula = "=LET(x, 5, y, x*2, z, y+3, z*2)";
sheet.Range["C2"].Formula = "=MAP(A2:A4, LAMBDA(x, x*2))";
sheet.Range["D2"].Formula = "=MAP(A2:A4,LAMBDA(x,x*10+1))";
sheet.Range["A8"].Formula = "=MAP(A2:B4,C2:D4,LAMBDA(x,y,SUM(x,y)))";
|
| Bug Fix | SPIREXLS-6061 | Fixed an issue where comments were not sorted when using DataSorter.Sort(). |
| Bug Fix | SPIREXLS-6078 | Fixed an issue where ConditionalFormats.Remove() did not work correctly. |
| Bug Fix | SPIREXLS-6082 | Fixed an issue where column widths became inconsistent when opening the saved Excel file in WPS. |
| Bug Fix | SPIREXLS-6084 | Fixed an issue where images were lost when converting Office 365 Excel documents to PDF. |
| Bug Fix | SPIREXLS-6090 | Fixed an issue where setting the font size for merged cells did not take effect. |
| Bug Fix | SPIREXLS-6099 SPIREXLS-6100 | Fixed an issue where Excel-to-PDF conversion results were inconsistent. |
Click the link below to download Spire.XLS 16.2.4:
More information of Spire.XLS new release or hotfix:
