Spire.Office 9.8.0 is released

2024-09-02 01:15:00

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
Click the link to get the version Spire.Office 9.8.0:
*More information of Spire.Office new release or hotfix:

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);
Save the resulting PDF document to a stream:
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.