We are excited to announce the release of Spire.XLS 14.9.5. The latest version supports adding filters to row fields/column fields of pivot tables. Furthermore, some known bugs are successfully fixed in this update, such as the issue that the content is incorrect when converting Excel documents to images. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5255 Supports adding filters to row fields/column fields of pivot tables. XlsPivotTable pt1 = workbook.Worksheets["PivotTable_1"].PivotTables[0] as XlsPivotTable; pt1.RowFields[0].AddValueFilter(PivotValueFilterType.Between, pt1.DataFields[0], 100000, 1000000); pt1.ColumnFields[0].AddValueFilter(PivotValueFilterType.Between, pt1.DataFields[0], 100000, 1000000); pt1.CalculateData(); New feature SPIREXLS-5393 Supports the issue…
We are happy to announce the release of Spire.XLS 14.9.1. This version supports identify OLE objects in Msg format and disabling DTD processing. It also implements the support for the BAHTTEXT formula. Moreover, some known issues are fixed successfully in this version, such as the issue that the result of data summing using MarkerDesigner function was incorrect. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5307 Adds the 'OleObjectType.Msg' type to identify OLE objects in Msg format. Workbook wb = new Workbook(); wb.LoadFromFile(inputFile); Worksheet sheet =wb.Worksheets[0]; OleObjectType type;…
We are excited to announce the release of Spire.XLS 14.8.2. This version supports enabling revision mode and setting global custom font folders. What’s more, some known bugs are fixed in this update, such as the issue that the checkbox was not converted to image format when converting Excel to PDF. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5254 Supports enabling revision mode. Workbook.TrackedChanges=true;//default value is false New feature SPIREXLS-5348 Supports setting global custom font folders. Workbook.SetGlobalCustomFontsFolders(string[] fontPath); Bug SPIREXLS-5196 Fixes the issue that the checkbox was not…
We're pleased to announce the release of Spire.XLS 14.7.2. This version supports obtaining the custom properties of a worksheet and the original document name of the embedded OLE object. What’s more, the issues that occurred when converting Excel to image and PDF has been successfully resolved. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5274 Supports obtaining custom properties of worksheets. Workbook workbook = new Workbook (); workbook.LoadFromFile("funds-test.xlsx"); ICustomPropertiesCollection customProperties = workbook.Worksheets[0].CustomProperties; for (int i = 0; i < customProperties.Count; i++) { XlsCustomProperty xcp = customProperties[i]; string name…
We're pleased to announce the release of Spire.XLS 14.6.6. This version supports converting Excel to Markdown format, and fixes some issues that occurred when converting Excel to image/HTML, and adding filter to Excel PivotTable. More details are shown below. Here is a list of changes made in this release Category ID Description New feature - Supports converting Excel to Markdown format. Workbook workbook = new Workbook(); workbook.LoadFromFile("input.xlsx"); workbook.SaveToFile("output.md",FileFormat.Markdown); Bug SPIREXLS-5191 Fixes the issue that the application threw "ArgumentOutOfRangeException" when setting "horizontal" and "vertical" type borders. Bug SPIREXLS-5243 Fixes the issue that the effect was incorrect when calling "Worksheet.Activate()" method. Bug…
We're pleased to announce the release of Spire.XLS 14.5.3. This version supports adding images to the first page header and footer, obtaining active selection range, as well as finding cells based on regular expressions. In addition, some known issues that occurred when converting Excel to PDF/ images, importing data into Excel, and autofitting columns 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-5128 Supports adding images to the first page header and footer. //Load image System.Drawing.Image bufferedImage = System.Drawing.Image.FromFile(inputFile_Img); //Set image on first page…
We are pleased to announce the release of Spire.XLS 14.3.3. This version supports PivotTable grouping functionality. In addition, it also supports adding the FindAll() method to CellRange and setting "Repeat All Item Labels" for PivotTable. Some known issues have also been successfully fixed in this version, such as the issue that the content was incorrect after saving Excel files. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-765 Supports PivotTable grouping function. XlsPivotTable pt = worksheet.PivotTables[0] as XlsPivotTable; IPivotField field = pt.RowFields[0]; DateTime start = new DateTime(2024, 5,…
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;…
Page 1 of 6
page 1