We're pleased to announce the release of Spire.XLS 14.2.1. This version supports setting the clipping position of header and footer images. In addition, some known issues that occurred when converting XLSX documents to PDF or images 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-5038 | Supports setting the clipping position of header and footer images.
sheet.PageSetup.LeftHeaderPictureCropTop=6.15; sheet.PageSetup.LeftHeaderPictureCropBottom=7.15; sheet.PageSetup.LeftHeaderPictureCropLeft =7.15; sheet.PageSetup.LeftHeaderPictureCropRight = 6.15; sheet.PageSetup.LeftFooterPictureCropTop=0.15; sheet.PageSetup.LeftFooterPictureCropBottom=0.15; sheet.PageSetup.LeftFooterPictureCropLeft =0.15; sheet.PageSetup.LeftFooterPictureCropRight =0.15; sheet.PageSetup.CenterHeaderPictureCropTop=0.15; sheet,PageSetup.CenterHeaderPictureCropBottom=0.15; sheet.PageSetup.CenterHeaderPictureCropLeft=0.15; sheet.PageSetup.CenterHeaderPictureCropRight =0.15; sheet.PageSetup.CenterFooterPictureCropTop=0.15; sheet.PageSetup.CenterFooterPictureCropBottom=0.15; sheet.PageSetup.CenterFooterPictureCropLeft =0.15; sheet.PageSetup.CenterFooterPictureCropRight=0.15; sheet.PageSetup.RightHeaderPictureCropTop=0.15; sheet.PageSetup.RightHeaderPictureCropBottom=0.15; sheet.PageSetup.RightHeaderPictureCropLeft=0.15; sheet.PageSetup.RightHeaderPictureCropRight=0.15; sheet.PageSetup.RightFooterPictureCropTop=0.15; sheet.PageSetup.RightFooterPictureCropBottom=0.15; sheet.PageSetup.RightFooterPictureCropLeft=0.15; |
| Bug | SPIREXLS-5066 | Fixes the issue that the comments in the resulting document were not displayed in Office365 after calling the cellRange.ClearContents() method. |
| Bug | SPIREXLS-5073 | Fixes the issue that when the sheet name contained the special character \t, the \t was read as x0009. |
| Bug | SPIREXLS-5080 | Fixes the issue that the content was incorrect when converting XLSX documents to PDF documents. |
| Bug | SPIREXLS-5083 | Fixes the issue that the application threw "System.ArgumentException" when converting XLSX documents to PDF documents |
| Bug | SPIREXLS-5084 | Fixes the issue that the text content was overlapped when converting XLSX documents to images. |
| Bug | SPIREXLS-5090 | Fixes the issue that the "Operation is not supported on this platform" exception occurred when deploying the .netstand2.0 dlls on the .NET7.0 platform. |
Click the link to download Spire.XLS 14.2.1:
More information of Spire.XLS new release or hotfix:
