Spire.Office 11.1.0 is released

Spire.Office 11.1.0 is released

2026-01-30 10:08:38

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.