We are pleased to announce the release of Spire.XLS 15.2.3. The latest version supports preserving the original format in the ExportDataTable() function. Moreover, several known bugs are fixed successfully in this update, such as the issue that Japanese characters were converted to English characters after updating the pivot table. More details are shown below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-568 | Supports preserving the original format in the ExportDataTable() function.
ExportTableOptions op = new ExportTableOptions(); op.ExportColumnNames = true; op.KeepDataType = true; var r = sheet.Range["A1:M7"]; |
| New feature | SPIREXLS-5539 | Supports the MUNIT function.
Workbook workbook = new Workbook(); workbook.Worksheets[0].Range["C2"].Formula = "=MUNIT(5)"; workbook.Worksheets[0].Range["C8"].Formula = "=MUNIT(0)"; workbook.Worksheets[0].Range["A1"].Formula = "=FLOOR.PRECISE(3.2)"; workbook.Worksheets[0].Range["D1"].Formula = "CSC(-2)"; workbook.Worksheets[0].Range["A3"].Formula = "=IMCSCH(\"4 + 3i\")"; workbook.CalculateAllValue(); |
| New feature | SPIREXLS-5540 | Supports the FLOOR function. |
| New feature | SPIREXLS-5541 | Supports the PRECISE function. |
| New feature | SPIREXLS-5681 | Supports the CSC function. |
| New feature | SPIREXLS-5682 | Supports the IMCOSH function. |
| New feature | SPIREXLS-5683 | Supports the IMSINH function. |
| New feature | SPIREXLS-5684 | Supports the IMSECH function. |
| Bug | SPIREXLS-5674 | Fixes the issue that document opening errors occurred when setting the language region to "Hungarian". |
| Bug | SPIREXLS-5675 | Fixes the issue that Japanese characters were converted to English characters after updating the pivot table. |
| Bug | SPIREXLS-5680 | Fixes the issue that the date format was inconsistent after converting a sheet to an image. |
| Bug | SPIREXLS-5686 | Fixes the issue that black color was resulted when setting the sheet tab color to Color.Empty. |
| Bug | SPIREXLS-5692 | Fixes the issue that the formula generated in German mode was incorrect. |
| Bug | SPIREXLS-5708 | Fixes the issue that saving a shape to an image caused a NullReferenceException. |
Click the link to download Spire.XLS 15.2.3:
More information of Spire.XLS new release or hotfix:
