We are excited to announce the release of Spire.Office 9.12.0. In this version, Spire.Doc supports finding text in paragraphs; Spire.XLS supports the SEC, WRAPCOLS, PERCENTOF, REPTARRAY, SUBSTITUTES functions; Spire.Presentation enhances the conversion from PowerPoint to PDF; Spire.PDF supports setting automatic rotation orientation when performing multi-page printing; Spire.Barcode fixes the issue that the scanning result of QR code was incorrect; Spire.OCR improves the memory reclamation efficiency and recognition speed. More details are listed below.
In this version, the most recent versions of Spire.Doc, Spire.XLS, Spire.Presentation, Spire.PDF, Spire.Barcode, Spire.Email, Spire.DocViewer.Forms, Spire.PdfViewer.Asp, Spire.PdfViewer.Forms, Spire.Spreadsheet, Spire.OfficeViewer.Forms, Spire.DataExport, Spire.DataExport.ResourceMgr are included.
DLL Versions:
- Spire.Doc 12.12.12
- Spire.XLS 14.12.2
- Spire.Presentation 9.12.1
- Spire.PDF 10.12.4
- Spire.Barcode 7.3.5
- Spire.Email 6.6.0
- Spire.DocViewer.Forms 8.8.3
- Spire.PdfViewer.Asp 7.12.23
- Spire.PdfViewer.Forms 7.12.23
- Spire.Spreadsheet 7.5.2
- Spire.OfficeViewer.Forms 8.7.15
- Spire.DataExport 4.9.0
- Spire.DataExport.ResourceMgr 2.1.0
Click the link to get the version Spire.Office 9.12.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 |
| New feature | SPIREDOC-10946 | Supports finding text in paragraphs.
paragraph.FindAllString(); paragraph.FindAllPattern(); |
| Bug | SPIREDOC-10322 | Fixes the issue that the program threw an "Encoder invalid" error when converting Word documents to PDF documents. |
| Bug | SPIREDOC-10873 | Fixes the issue that the equations were not correctly converted when using the officeMath.FromMathMLCode method. |
| Bug | SPIREDOC-10900 | Fixes the issue that the equations were not fully displayed after converting HTML documents to Word documents. |
| Bug | SPIREDOC-10910 | Fixes the issue that the program threw a "System.ArgumentException: 'List level must be less than 8 and greater than 0.' " exception when loading ODT files. |
| Bug | SPIREDOC-11002 | Fixes the issue that the program threw a "System.InvalidOperationException: 'Operation is not valid due to the current state of the object.' " exception when converting Word documents to PDF documents: |
| Bug | SPIREDOC-11035 | Fixes the issue that some content was out of order after converting Word documents to PDF documents. |
Spire.XLS
| Category | ID | Description |
| New feature | SPIREXLS-5561 | Supports the SEC function. |
| New feature | SPIREXLS-5562 | Supports the WRAPCOLS function. |
| New feature | SPIREXLS-5563 | Supports the WRAPROWS function. |
| New feature | SPIREXLS-5574 | Supports the VSTACK function. |
| New feature | SPIREXLS-5577 | Supports the PERCENTOF function. |
| New feature | SPIREXLS-5578 | Supports the REPTARRAY function. |
| New feature | SPIREXLS-5592 | Support the SECH function. |
| New feature | SPIREXLS-5607 | Supports the IMTAN function. |
| New feature | SPIREXLS-5614 | Supports the IMCSC function. |
| New feature | SPIREXLS-5615 | Supports the IMCOT function. |
| New feature | SPIREXLS-5616 | Supports the IMSEC function. |
| New feature | SPIREXLS-5623 | Supports the SUBSTITUTES function. |
| Bug | SPIREXLS-5576 | Fixes the issue that the content was being shrunk when printing Excel documents using a dot matrix printer. |
| Bug | SPIREXLS-5584 | Fixes the issue that the formatting was incorrect when converting Excel documents to PDF. |
| Bug | SPIREXLS-5610 | Fixes the issue that the text position in legends was incorrect when converting Excel documents to PDF. |
Spire.Presentation
| Category | ID | Description |
| Bug | SPIREPPT-2584 | Fixes the issue that hyperlinks were lost after converting PowerPoint to PDF. |
| Bug | SPIREPPT-2640 | Fixes the issue that the program threw an exception when assigning a value to a chart with an empty data source. |
| Bug | SPIREPPT-2677 | Fixes the issue that the program threw Spire.Presentation.DocumentUnkownFormatException: "Microsoft PowerPoint 2007 file is corrupted." exception when loading a document using the netstandard dll. |
| Bug | SPIREPPT-2679 | Fixes the issue that pictures were lost after converting HTML to PowerPoint. |
| Bug | SPIREPPT-2682 | Fixes the issue that the program threw Spire.Presentation.AppException: "Property not found" exception when loading documents. |
Spire.PDF
| Category | ID | Description |
| New feature | SPIREPDF-7034 | Supports setting automatic rotation orientation when performing multi-page printing.
PdfMultiPageLayout printParameters = pdf.PrintSettings.SelectMultiPageLayout(1, 2); printParameters.AutoRotate = true; pdf.PrintSettings.Duplex = Duplex.Horizontal; |
| New feature | SPIREPDF-7197 | Supports retrieving the jump-to page associated with a button.
PdfDocument doc = new PdfDocument();
doc.LoadFromFile(inputFile);
PdfFormWidget formWidget = (PdfFormWidget)doc.Form;
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine("btnAction:");
for (int i = 0; i < formWidget.FieldsWidget.Count; ++i)
{
var field = formWidget.FieldsWidget[i] as PdfButtonWidgetFieldWidget;
if (field.Actions.MouseUp != null && field.Actions.MouseUp is PdfNamedAction)
{
var mouseUp = (PdfNamedAction)field.Actions.MouseUp;
stringBuilder.AppendLine(formWidget.FieldsWidget[i].Name + "-MouseUp-" + mouseUp.Destination.ToString());
}
else if (field.Actions.MouseDown != null && field.Actions.MouseDown is PdfNamedAction)
{
var mouseDown = (PdfNamedAction)field.Actions.MouseDown;
stringBuilder.AppendLine(formWidget.FieldsWidget[i].Name + "-MouseDown--" + mouseDown.Destination.ToString());
}
else if (field.Actions.MouseDown != null && field.Actions.MouseDown is PdfUriAction)
{
var mouseDown = (PdfUriAction)field.Actions.MouseDown;
stringBuilder.AppendLine(formWidget.FieldsWidget[i].Name + "-MouseDown--" + mouseDown.Uri.ToString());
}
else if (field.Actions.MouseUp != null && field.Actions.MouseUp is PdfUriAction)
{
var mouseUp = (PdfUriAction)field.Actions.MouseUp;
stringBuilder.AppendLine(formWidget.FieldsWidget[i].Name + "-MouseUp-" + mouseUp.Uri.ToString());
}
}
File.WriteAllText(outputFile, stringBuilder.ToString());
doc.Dispose();
|
| Bug | SPIREPDF-7169 | Fixes the issue that content was lost when printing PDF documents. |
| Bug | SPIREPDF-7182 | Fixes the issue that colors were incorrect when printing PDF documents. |
| Bug | SPIREPDF-7185 | Fixes the issue that form field flattening failed. |
| Bug | SPIREPDF-7195 | Fixes the issue that the System.NullReferenceException: 'Object reference not set to an instance of an object.' occurred when converting PDF to SVG. |
| Bug | SPIREPDF-7203 | Fixes the issue that text content missed when converting PDF to images. |
| Bug | SPIREPDF-7208 | Fixes the issue that the generated PDFA documents did not comply with PDF version standards. |
| Bug | SPIREPDF-7232 | Fixes the issue that only the watermark on the first page could be deleted when removing PdfWatermarkAnnotationWidget. |
| Bug | SPIREPDF-7240 | Fixes the issue that the System.IndexOutOfRangeException: 'Index was outside the bounds of the array.' occurred when converting PDF to PDFA3A. |
Spire.Barcode
| Category | ID | Description |
| Bug | SPIREBARCODE-227 SPIREBARCODE-248 SPIREBARCODE-250 |
Fixes the issue that the scanning result of QR code was incorrect. |
Spire.OCR
| Category | ID | Description |
| Bug | SPIREOCR-78 | Improves the memory reclamation efficiency and recognition speed |
| Bug | SPIREOCR-13 SPIREOCR-58 SPIREOCR-65 |
Fixes the issue that the obtained text coordinates were incorrect. |
| Bug | SPIREOCR-14 | Fixes the issue that the recognition result of inverted text was incorrect. |
| Bug | SPIREOCR-15 | Fixes the issue that the program crashed when scanning pictures in web projects. |
| Bug | SPIREOCR-16 SPIREOCR-21 |
Fixes the issue that the recognition result of certain text was incorrect. |
| Bug | SPIREOCR-17 SPIREOCR-24 |
Fixes the issue that the program threw "Error occurred during ocr." exception when scanning images under multi-threading. |
| Bug | SPIREOCR-18 | Fixes the issue that the program threw "Error occurred during ocr." exception when scanning images under Windows Server 2016 OS. |
| Bug | SPIREOCR-23 SPIREOCR-34 SPIREOCR-36 |
Fixes the issue that certain text was not recognized. |
| Bug | SPIREOCR-39 | Fixes the issue that the program crashed when scanning images in a web project. |
| Bug | SPIREOCR-66 | Fixes the issue that the program threw "Error occurred during ocr." exception when the folder name in the model path contains spaces. |
