We are excited to announce the release of Spire.Office 9.8.0. In this version, Spire.PDF supports converting HTML to PDF using the Chrome; Spire.XLS supports enabling revision mode and obtaining custom properties of worksheets; Spire.Presentation supports converting PowerPoint documents to Markdown files; Spire.OCR supports configuring OCR models, languages, and dependency libraries. Besides, a lot of known issues are fixed successfully in this version. More details are listed below.
In this version, the most recent versions of Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.Email, Spire.DocViewer, Spire.PDFViewer, Spire.Spreadsheet, Spire.OfficeViewer, Spire.DataExport, and Spire.Barcode are included.
DLL Versions:
- Spire.Doc.dll v12.8.12
- Spire.Pdf.dll v10.8.1
- Spire.XLS.dll v14.8.2
- Spire.Presentation.dll v9.8.3
- Spire.Barcode.dll v7.3.3
- Spire.Email.dll v6.6.0
- Spire.DocViewer.Forms.dll v8.8.1
- Spire.PdfViewer.Asp.dll v7.12.23
- Spire.PdfViewer.Forms.dll v7.12.23
- Spire.Spreadsheet.dll v7.5.2
- Spire.OfficeViewer.Forms.dll v8.7.15
- Spire.DataExport.dll 4.9.0
- Spire.DataExport.ResourceMgr.dll v2.1.0
Here is a list of changes made in this release
Spire.Doc
Category | ID | Description |
Bug | SPIREDOC-10644 | Fixes the issue that the image data was failed to be filled during mail merge. |
Bug | SPIREDOC-10219 | Fixes the issue that extra blank pages are generated when converting Word to OFD. |
Bug | SPIREDOC-10365 | Fixes the issue that the VBA was lost after saving Docm. |
Bug | SPIREDOC-10389 | Fixes the issue that the application threw the exception "Wrong Word version" when loading Word documents encrypted using the WPS tool. |
Bug | SPIREDOC-10425 | Fixes the issue that the application threw the exception 'System. ArgumentNullException' when converting Word to PDF. |
Bug | SPIREDOC-10456 | Fixes the issue that the borderless text boxes added using the WPS tool were not successfully parsed. |
Bug | SPIREDOC-10554 | Fixes the issue that the images didn't display when adding HTML that contains the image paths starting with https. |
Bug | SPIREDOC-10587 | Fixes the issue that the application threw the exception "Unknown boolean value" when converting Word to PDF. |
Bug | SPIREDOC-10738 | Fixes the issue that the customXml appeared after replacing text. |
Bug | SPIREDOC-10743 | Optimizes the file size for converting Word to OFD. |
Spire.XLS
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 = xcp.Name; string value = xcp.Value; } |
New feature | SPIREXLS-5306 | Supports obtaining the original document name of the embedded OLE object.
ole.OleOriginName |
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-5271 | Fixes the issue that the cell data was inaccurate when converting Excel to images. |
Bug | SPIREXLS-5298 | Fixes the issue that the cell contents were lost when converting Excel to PDF. |
Bug | SPIREXLS-5304 | Fixes the issue that the row height was incorrect when converting Excel to PDF. |
Bug | SPIREXLS-5309 | Fixes the issue that the pagination was incorrect when converting Excel to PDF. |
Bug | SPIREXLS-5320 | Fixes the issue that the first 10 data entries were incorrect after adding a "FilterTop10" filter in a worksheet. |
Bug | SPIREXLS-5196 | Fixes the issue that the checkbox was not converted to image format when converting Excel to PDF. |
Bug | SPIREXLS-5305 | Fixes the issue that multiple calls to the ApplyStyleToRange method in pivot tables result in incorrect results. |
Bug | SPIREXLS-5308 | Fixes the issue that setting the color transparency of rich text did not take effect. |
Bug | SPIREXLS-5317 | Fixes the issue that the Filter formula is calculated incorrectly. |
Bug | SPIREXLS-5330 | Fixes the issue that pivot table column names are incorrect when converting Excel to images. |
Bug | SPIREXLS-5345 | Fixes the issue that the text location is incorrect when converting Excel to PDF. |
Bug | SPIREXLS-5349 | Fixes the issue that ChartSheet retrieval is incorrect. |
Bug | SPIREXLS-5352 | Fixes the issue that cell content is incorrect when converting Excel to HTML or images. |
Spire.PDF
Category | ID | Description |
New feature | SPIREPDF-5742 | Adds the PreserveAllowedMetadata property to support preserving XMP data when converting PDF to PDFA format documents.
PdfStandardsConverter converter = new PdfStandardsConverter(stream); converter.Options.PreserveAllowedMetadata = true; |
New feature | - | Supports converting HTML to PDF using the Chrome plugin. Save the resulting PDF document to a file: string chromeLocation = baseDirectory + "chrome\\Chrome-bin\\chrome.exe"; ChromeHtmlConverter converter = new ChromeHtmlConverter(chromeLocation); ConvertOptions options = new ConvertOptions(); options.Timeout = 10 * 1000; options.PageSettings = new PageSettings() { PaperWidth = 8.77, PaperHeight = 6.20, MarginBottom = 0, MarginTop = 0, MarginLeft = 0, MarginRight = 0 }; converter.ConvertToPdf("https://www.e-iceblue.com/", outputFile, options); var pdfAsStream = new MemoryStream(); string chromeLocation = baseDirectory + "chrome\\Chrome-bin\\chrome.exe"; ChromeHtmlConverter converter = new ChromeHtmlConverter(chromeLocation); ConvertOptions options = new ConvertOptions(); options.Timeout = 10 * 1000; options.PageSettings = new PageSettings() { PaperWidth = 8.77, PaperHeight = 6.2, MarginBottom = 0, MarginTop = 0, MarginLeft = 0, MarginRight = 0 }; converter.ConvertToPdf("https://www.e-iceblue.com/", pdfAsStream, options); |
New feature | SPIREPDF-6820 | Optimizes the layout of Excel documents converted from PDF documents. Use the new code: pdfDocument.ConvertOptions.SetPdfToXlsxOptions(new XlsxLineLayoutOptions(true, false, false)); //bool convertToMultipleSheet, bool rotatedText, bool splitCell |
Optimization | SPIREPDF-5744 | Optimizes the time consumption of PDF to image conversion. |
Bug | SPIREPDF-6789 | Fixes the issue that the program reported an error when printing PDF documents. |
Bug | SPIREPDF-6806 | Fixes the issue that images in PDF documents converted from XPS documents were not displayed in the PDF.js viewer. |
Bug | SPIREPDF-6848 | Fixes the issue that the border was lost after filling the text field with content and opening the document in Google Chrome or previewing it in Adobe when printing. |
Bug | SPIREPDF-6896 | Fixes the issue that the program threw System.NullReferenceException when converting a PDF document to a PDFA1B document. |
Bug | SPIREPDF-6898 SPIREPDF-6899 |
Fixes the issue that the program threw System.NullReferenceException when extracting text from PDF documents. |
Bug | SPIREPDF-6906 | Fixes the issue that the program threw System.ArgumentNullException when converting PDF documents to images. |
Bug | SPIREPDF-6832 | Fixes the issue that verification of signature validity was inaccurate. |
Bug | SPIREPDF-6836 | Fixes the issue that removing the PdfWatermarkAnnotationWidget object failed. |
Bug | SPIREPDF-6875 | Fixes the issue that printing PDF to B5 paper size was incorrect. |
Bug | SPIREPDF-2659 SPIREPDF-4454 |
Fixes the issue that importing and exporting form data (in FDF, XFDF, and XML formats) was incorrect. |
Bug | SPIREPDF-6797 | Fixes the issue that highlighting covered the text after converting PDF to images. |
Bug | SPIREPDF-6896 | Fixes the issue that the program threw an exception System.NullReferenceException when converting an OFD document to a PDF document. |
Bug | SPIREPDF-6908 | Fixes the issue that the contents were blank after converting a PDF document to images. |
Bug | SPIREPDF-6910 | Fixes the issue that it failed to get the action script of annotations. |
Bug | SPIREPDF-6922 | Fixes the issue that the program threw an exception System.ArgumentException when importing FDF file data to PDF. |
Bug | SPIREPDF-6925 | Fixes the issue that spaces were lost when copying content to Notepad after adding content to a PDF document using the PdfTaggedContent interface. |
Bug | SPIREPDF-6929 SPIREPDF-6940 |
Fixes the issue that the program threw an exception System.OutOfMemoryException when converting a PDF document to images. |
Bug | SPIREPDF-6941 | Fixes the issue that signatures were reversed by mirroring after flattening form fields. |
Bug | SPIREPDF-6949 | Fixes the issue that the program threw an exception System.NullReferenceException when converting a PDF document to an Excel document. |
Bug | SPIREPDF-6968 | Fixes the issue that the program threw an exception System.NullReferenceException when loading a PDF document. |
Spire.Presentation
Category | ID | Description |
New feature | - | Supports converting PowerPoint documents to Markdown files.
Presentation ppt = new Presentation(); ppt.LoadFromFile("1.pptx"); ppt.SaveToFile("1.md", FileFormat.Markdown); ppt.Dispose(); |
Bug | SPIREPPT-2522 | Fixes the issue that the waterfall chart is displayed incorrectly after modifying its data. |
Bug | SPIREPPT-2534 | Fixes the issue that the program threw System.ArgumentException when setting document property "_MarkAsFinal". |
Bug | SPIREPPT-2535 | Fixes the issue that the tilt angle of text was lost after converting slides to pictures. |
Bug | SPIREPPT-2547 | Fixes the issue that the application threw the exception "System.ArgumentOutOfRangeException" when copying slides to a new PowerPoint presentation. |
Bug | SPIREPPT-2549 | Fixes the issue that the message "PowerPoint found a problem with content" prompted when opening the resulting file generated after copying slides to a new PowerPoint presentation. |
Spire.OCR
Category | ID | Description |
New feature | - | Adds the ConfigureOptions class and new method ConfigureDependencies(ConfigureOptions configureOptions), which supports configuring OCR models, languages, and dependency libraries.
OcrScanner scanner = new OcrScanner(); // Create a new instance of the ConfigureOptions class to set up the scanner configuration ConfigureOptions configureOptions = new ConfigureOptions(); // Set the path to the model configureOptions.ModelPath = @"D:\Model&Lib\Model\V4.Server"; // Set the path to the dependency libraries configureOptions.LibPath = @"D:\Model&Lib\Lib\V2.7\Net\X64"; // Specify the language configureOptions.Language = "Chinese"; // Apply the configuration options to the scanner using the ConfigureDependencies method scanner.ConfigureDependencies(configureOptions); scanner.Scan("test.tif"); |
Spire.OfficeViewer
Category | ID | Description |
Bug | SPIREPPT-2502 | Fixes the issue that the warning watermark of presentations cannot be removed after applying a valid license. |