We're pleased to announce the release of Spire.XLS 15.4.4. This version adds support for several new formulas, and also supports auto-fitting row height in merged cells spanning multiple columns in a single row. Besides, some issues that occurred when converting Excel to PDF and saving files have been successfully fixed. More details are shown below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-5697 | Supports auto-fitting row height in merged cells spanning multiple columns in a single row.
Workbook workbook = new Workbook(); workbook.LoadFromFile(@"in.xlsx"); Worksheet sheet= workbook.Worksheets[0]; AutoFitterOptions options = new AutoFitterOptions(); options.AutoFitMergedCells = true; //the first parameter is the merged row sheet.AutoFitRow(9, 1, sheet.LastColumn, options); workbook.SaveToFile(@"out.xlsx", Spire.Xls.FileFormat.Version2016); workbook.Dispose(); |
| New feature | SPIREXLS-5746 SPIREXLS-5768 SPIREXLS-5769 SPIREXLS-5774 |
Supports the GAMMALN.PRECISE, LOGNORM.INV, LOGNORM.DIST, and GAUSS formulas.
sheet.Range["C2"].Formula = "=GAUSS(A1)"; sheet.Range["C3"].Formula = "=LOGNORM.DIST(A2, A3, A4, A5)"; sheet.Range["C4"].Formula = "=GAMMALN.PRECISE(1.5)"; sheet.Range["C5"].Formula = "=LOGNORM.INV(0.5, 0, 1)"; |
| Bug | SPIREXLS-5555 | Fixes the issue where data was incomplete when converting Excel to PDF with the SheetFitToPage=true property. |
| Bug | SPIREXLS-5724 | Fixes the inconsistency issue when converting Excel to PDF. |
| Bug | SPIREXLS-5725 | Fixes the issue where the text was displayed incorrectly when converting Excel to PDF. |
| Bug | SPIREXLS-5767 | Fixes the issue that the XML data for ColumnWidth did not comply with OpenXML standards. |
| Bug | SPIREXLS-5775 | Fixes the issue that it was where failed to update the associated sheets when modifying the row count in a sheet. |
| Bug | SPIREXLS-5777 | Fixes the issue where shapes were incorrect in the saved Excel file. |
| Bug | SPIREXLS-5778 | Fixed the issue that the IFERROR formula returned incorrect values. |
Click the link to download Spire.XLS 15.4.4:
More information of Spire.XLS new release or hotfix:
