We’re excited to announce the release of Spire.Office 11.1.0. In this version, Spire.Doc supports creating and manipulating VAB macros in Word files; Spire.XLS supports converting a specified cell range to HTML; Spire.Presentationm supports highlighting text based on regular expression matches; Spire.PDF supports saving files in PDF 2.0 version. Moreover, a large number of bugs have been successfully fixed in this update.
In this version, the most recent versions of Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.Barcode, Spire.DocViewer, Spire.PDFViewer, and Spire.Email are included.
DLL Versions:
- Spire.Doc.dll v14.1.12
- Spire.PDF.dll v12.1.6
- Spire.XLS.dll v16.1.4
- Spire.Presentation.dll v11.1.1
- Spire.Barcode.dll v7.5.0
- Spire.Email.dll v6.8.0
- Spire.DocViewer.Forms.dll v8.9.5
- Spire.PdfViewer.Asp.dll v8.2.9
- Spire.PdfViewer.Forms.dll v8.2.9
- Spire.Spreadsheet.dll v7.5.3
- Spire.OfficeViewer.Forms.dll v8.8.1
Click the link to get the version Spire.Office 11.1.0:
More information of Spire.Office new release or hotfix:
Here is a list of changes made in this release
Spre.doc
| Category | ID | Description |
| New Feature | SPIREDOC-3929 | Added support for configuring formula conversion to MathML when converting Word to HTML.
HtmlExportOptions options = doc.HtmlExportOptions; options.OfficeMathOutputMode = HtmlOfficeMathOutputMode.MathML; |
| New Feature | SPIREDOC-9868 | Added support for deleting specified pages and blank pages.
doc.RemoveBlankPages(); // Delete blank pages
doc.RemovePages(new List {0,1,3}); // Delete specified pages
|
| New Feature | SPIREDOC-11489 | Added support for creating and manipulating VBA macros.
Document doc = new Document();
doc.AddSection().AddParagraph().AppendText("wertyuiop[]fghjk");
// Add VBA project to document
VbaProject vbaProject = new VbaProject();
vbaProject.Name = "SampleVBAMacro";
doc.VbaProject = vbaProject;
// Add modules to VBA project
// Module 1
VbaModule vbaModule1 = doc.VbaProject.Modules.Add("SampleModule1", VbaModuleType.StdModule);
vbaModule1.SourceCode = @"
Sub DocumnetInfo()
MsgBox ""create time: "" &Now()
MsgBox ""Pages:"" & ActiveDocument.Range.ComputeStatistics(wdStatisticPages)
End Sub
Sub WriteHello()
Selection.TypeText Text:=""Hello World!""
End Sub";
// Module 2
VbaModule vbaModule2 = doc.VbaProject.Modules.Add("SampleModule2", VbaModuleType.StdModule);
vbaModule2.SourceCode = @"
Sub InsertCurrentDate()
Selection.TypeText Text:=Format(Now(),""yyyy-mm-dd hh:mm:ss"")
End Sub
Sub IndentParagraph()
Selection.ParagraphFormat.LeftIndent = InchesToPoints(0.5)
End Sub";
doc.SaveToFile("result.docm", FileFormat.Docm);
doc.Close();
|
| New Feature | SPIREDOC-11598 | Added GetRevisionInfos() method to retrieve full revision information from the document.
Document doc = new Document();
doc.LoadFromFile("input.docx");
StringBuilder sb = new StringBuilder();
RevisionInfoCollection revisionInfoCollection = doc.GetRevisionInfos();
foreach (RevisionInfo revisionInfo in revisionInfoCollection)
{
sb.AppendLine("[author]:" + revisionInfo.Author + "\r\n" + " [RevisionType]:" + revisionInfo.RevisionType + "\r\n" + " [DateTime]:" + revisionInfo.DateTime.ToString() + "\r\n" + " [OwnerObject]:" + revisionInfo.OwnerObject + "\r\n" + " [OwnerObject.Owner]:" + revisionInfo.OwnerObject.Owner + "\r\n");
if (revisionInfo.OwnerObject is TextRange textRange)
{
TextRange range = (TextRange)textRange;
sb.AppendLine($"TextRange - Content:{range.Text}");
}
}
File.WriteAllText(outputFile, sb.ToString());
doc.Dispose();
|
| Bug Fix | SPIREDOC-11523 | Fixed the issue where the program hangs when converting Word to PDF. |
| Bug Fix | SPIREDOC-11632 | Fixed the issue where line breaks are incorrect when adding multi-line watermarks. |
| Bug Fix | SPIREDOC-11692 | Fixed the issue where table of contents fields fail to update. |
| Bug Fix | SPIREDOC-11703 | Fixed the issue where the result is incorrect when converting Markdown to Word. |
| Bug Fix | SPIREDOC-11706 | Fixed the issue where document saving takes a long time when adding multi-line text with "\r\n". |
| Bug Fix | SPIREDOC-11727 | Fixed the issue where extra blank paragraphs appear when adding HTML to Word. |
| Bug Fix | SPIREDOC-11744 | Fixed the issue where images are blurry when converting Word to HTML. |
| Bug Fix | SPIREDOC-11767 | Fixed the issue where content is inconsistent when loading and saving RTF files. |
| Bug Fix | SPIREDOC-10843 | Fixed the issue where the program hung for a long time when using new FixedLayoutDocument(document). |
| Bug Fix | SPIREDOC-11532 | Fixed the issue where the program hung for a long time when converting Word documents to PDF. |
| Bug Fix | SPIREDOC-11758 | Fixed the issue where an incorrect numbering format was returned when retrieving lists. |
| Bug Fix | SPIREDOC-11728 SPIREDOC-11730 SPIREDOC-11731 | Fixed the issue where incorrect content was generated when converting Word documents to PDF. |
Spre.XLS
| Category | ID | Description |
| New Feature | SPIREXLS-5948 | Added support for the BYROW and BYCOL functions.
// Use BYROW to calculate the average of each row sheet.Range["G2"].Formula = "=BYROW(B2:F2, LAMBDA(row, AVERAGE(row)))"; // Use BYCOL to calculate the average of each column sheet.Range["B8"].Formula = "=BYCOL(B2:B7, LAMBDA(col, AVERAGE(col)))"; |
| New Feature | SPIREXLS-5980 | Added support for converting a specified cell range to HTML.
Workbook workbook = new Workbook(); workbook.LoadFromFile(inputFile); Worksheet sheet = workbook.Worksheets[0]; CellRange cell = sheet.Range["A1:B3"]; string html = cell.HtmlString; File.WriteAllText(outputFile, html); |
| New Feature | SPIREXLS-5983 | Added support for transposing rows and columns when copying a cell range.
CopyRangeOptions options = CopyRangeOptions.Transpose | CopyRangeOptions.All; sheet["A1:C4"].Copy(sheet["D2:G3"], options); sheet["A1:B5"].Copy(sheet["D5"], options); workbook.SaveToFile(outputFile); |
| New Feature | SPIREXLS-6018 | Added support for converting Excel files to PDF/UA-compliant documents.
Workbook workbook = new Workbook(); workbook.LoadFromFile(inputFile); workbook.ConverterSetting.PdfConformanceLevel = Spire.Xls.Pdf.PdfConformanceLevel.Pdf_UA1; workbook.SaveToFile(outputFile, FileFormat.PDF); workbook.Dispose(); |
| Bug Fix | SPIREXLS-6044 | Fixed an issue where OLE objects in the document could not be deleted successfully. |
Spire.Presentation
| Category | ID | Description |
| New Feature | - | Added support for highlighting text based on regular expression matches.
// Simple word matching Regex regex = new Regex(@"\bhello\b"); IAutoShape shape = (IAutoShape)ppt.Slides[0].Shapes[0]; TextHighLightingOptions options = new TextHighLightingOptions(); shape.TextFrame.HighLightRegex(regex, Color.Red, options); |
| New Feature | SPIREPPT-3051 | Fixed the issue where some content was lost during PPTX-to-PDF conversion. |
| Bug Fix | SPIREPPT-3058 | Fixed the issue where the configured default font was not applied during PPTX-to-PDF conversion. |
Spire.PDF
| Category | ID | Description |
| New Feature | SPIREPDF-5365 | Supports getting and setting the PDF 2.0 version.
// Retrieve PdfFileInfo info = doc.FileInfo; PdfVersion version = info.Version; // Settings doc.FileInfo.Version = PdfVersion.Version2_0; |
| Bug Fix | SPIREPDF-6905 | Fixes the issue where text color was rendered incorrectly when converting PDF to images. |
| Bug Fix | SPIREPDF-7866 | Fixes the issue where memory was not properly released during text replacement. |
| Bug Fix | SPIREPDF-7875 | Fixes the issue where QR codes were missing after converting PDF to PDF/A or images. |
| Bug Fix | SPIREPDF-7884 | Fixes the issue where an ArgumentOutOfRangeException was thrown when loading XPS files. |
| Bug Fix | SPIREPDF-7892 | Fixes the issue where text extraction failed under certain conditions. |
| Bug Fix | SPIREPDF-7867 | Fixes the issue where rendering effects were incorrect when converting PDF to Word. |
| Bug Fix | SPIREPDF-7097 | Fixes the issue where content copied from the result document was incorrect after converting PDF to PDF/A-3B. |
| Bug Fix | SPIREPDF-7841 | Fixes the page numbering style issue when using ChromeHtmlConverter to convert HTML to PDF for printing. |
| Bug Fix | SPIREPDF-7847 | Fixes the issue where obtaining font properties of text box fields threw an "ArgumentOutOfRangeException". |
| Bug Fix | SPIREPDF-7888 | Optimizes timestamp requests by reducing calls to timestamp servers and improving validation. |