Spire.Office 11.2.0 is released

Spire.Office 11.2.0 is released

2026-02-28 10:24:43

We’re pleased to announce the release of Spire.Office 11.2.0. In this version, Spire.Doc supports hiding rows in a table; Spire.XLS supports LET and MAP functions; Spire.PDF supports configuring text color when replacing text in PDF pages; Spire.Presentation enhances the conversion from PowerPoint to PDF. Meanwhile, a large number of known bugs has been fixed.

In this version, the most recent versions of Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.Barcode, Spire.DocViewer, Spire.PDFViewer, Spire.Email, Spire.Spreadsheet, and Spire.OfficeViewer are included.

DLL Versions:

  • Spire.Doc.dll v14.2.7
  • Spire.Pdf.dll v12.2.14
  • Spire.XLS.dll v16.2.4
  • Spire.Presentation.dll v11.2.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.2.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-11444 Added support for hiding rows in tables.
Spire.Doc.Document doc = new Spire.Doc.Document();
doc.LoadFromFile(inputFile1);TableRow row = doc.FirstSection.Body.Tables[0].FirstRow;
row.Hidden = true;doc.SaveToFile(outputDocxFile1);doc = new Document(outputDocxFile1);
row = doc.FirstSection.Body.Tables[0].FirstRow;
Assert.True(row.Hidden);
foreach (TableCell cell in row.Cells)
{
    foreach (Paragraph para in cell.Paragraphs)
    {
        foreach (ParagraphBase run in para.ChildObjects)
        {
            if (run is TextRange || run is Break || run is Symbol)
            {
                Assert.True(run.CharacterFormat.Hidden);
            }
        }
    }
}
Adjustment - Removed the interfaces and classes under the namespace “Spire.Doc.Interface”:
IDocumentSerializable,
IXDLSAttributeReader,
IXDLSAttributeWriter,
IXDLSContentReader,
IXDLSContentWriter,
IXDLSFactory,
IXDLSSerializableCollection
Adjustment - Removed the interfaces and classes under the namespace “Spire.Doc.Documents.XML”:
DocumentSerializable,
DocumentSerializableCollection,
XDLSHolder,
XDLSReader
Adjustment - Removed the IShapeAttrSource interface.
Adjustment - Removed the following public methods from ShapeBase:
public object GetDirectShapeAttr(int key)
public object FetchInheritedShapeAttr(int key)
public object FetchShapeAttr(int key)
public void SetShapeAttr(int key, object value)
public void RemoveShapeAttr(int key)
public object GetDirectShapeAttribute(int key)
public object GetInheritedShapeAttribute(int key)
public object GetShapeAttribute(int key)
public void SetShapeAttribute(int key, object value)
public void RemoveShapeAttribute(int key)
public bool HasKey(int key)
Bug Fix SPIREDOC-11799 Fixed the issue where converting Word to PDF results inconsistent output.

Spre.XLS

Category ID Description
New Feature SPIREXLS-6086 SPIREXLS-6087 Added support for the LET and MAP functions.
Workbook workbook = new Workbook();
            Worksheet sheet = workbook.Worksheets[0];
            sheet.Range["C1"].Text = "out";
            sheet.Range["C2"].Formula = "=LET(x, 5, y, 10, x + y)";
            sheet.Range["C3"].Formula = "=LET(a, 1, b, 2, c, 3, d, 4, a+b+c+d)";
            sheet.Range["C4"].Formula = "=LET(outer, LET(inner, 5, inner*2), outer+10)";
            sheet.Range["C5"].Formula = "=LET(x, 5, y, x*2, z, y+3, z*2)"; 
            sheet.Range["C2"].Formula = "=MAP(A2:A4, LAMBDA(x, x*2))";
            sheet.Range["D2"].Formula = "=MAP(A2:A4,LAMBDA(x,x*10+1))";
            sheet.Range["A8"].Formula = "=MAP(A2:B4,C2:D4,LAMBDA(x,y,SUM(x,y)))";
Bug Fix SPIREXLS-6061 Fixed an issue where comments were not sorted when using DataSorter.Sort().
Bug Fix SPIREXLS-6078 Fixed an issue where ConditionalFormats.Remove() did not work correctly.
Bug Fix SPIREXLS-6082 Fixed an issue where column widths became inconsistent when opening the saved Excel file in WPS.
Bug Fix SPIREXLS-6084 Fixed an issue where images were lost when converting Office 365 Excel documents to PDF.
Bug Fix SPIREXLS-6090 Fixed an issue where setting the font size for merged cells did not take effect.
Bug Fix SPIREXLS-6099 SPIREXLS-6100 Fixed an issue where Excel-to-PDF conversion results were inconsistent.

Spire.Presentation

Category ID Description
Category ID Description
Bug Fix SPIREPPT-2841 Fixed the issue where rendering effects were inconsistent when converting PowerPoint to SVG.
Bug Fix SPIREPPT-3073 Fixed the issue that extraneous log information was generated when converting PowerPoint to PDF.
Bug Fix SPIREPPT-3073 Fixed the issue that charts were missing when converting PowerPoint to PDF.

Spire.PDF

Category ID Description
Optimization SPIREPDF-7881 Optimizes the compression functionality for netstandard DLLs to improve the file compression ratio.
New Feature SPIREPDF-7780 Added support for the PdfHatchStyle interface to create Hatch Brushes.
PdfDocument pdf = new PdfDocument();
foreach (PdfHatchStyle type in Enum.GetValues(typeof(PdfHatchStyle)))
{
    PdfPageBase page = pdf.Pages.Add();
    PdfCanvas canves = page.Canvas;
    Color foreColor = Color.FromArgb(255, 255, 255, 0);
    Color backColor = Color.FromArgb(255, 78, 167, 46);
    page.Canvas.DrawString(type.ToString(), new PdfTrueTypeFont(new System.Drawing.Font("Arial", 16)), new PdfSolidBrush(Color.Black), new PointF(0, 0), true);
    PdfHatchBrush brush = new PdfHatchBrush(type, foreColor, backColor);
    canves.DrawRectangle(brush, 100, 100, 300, 200);
}
pdf.SaveToFile(output);
pdf.Dispose();
New Feature SPIREPDF-7907 Added support for configuring text color when replacing text in PDF pages.
PdfTextReplacer textReplacer = new PdfTextReplacer(page);
textReplacer.Options = textReplaceOptions;
textReplacer.ReplaceAllText("文档", "文件", Color.Red);
Bug Fix SPIREPDF-7871 Fixed the issue where the program hung when converting PDF to images.
Bug Fix SPIREPDF-7882 Fixed the issue where the seal was rendered incorrectly when converting OFD to images.
Bug Fix SPIREPDF-7915 Fixed the issue where the output was incorrect when converting XPS to PDF.
Bug Fix SPIREPDF-7922 Fixed the issue that PDF bookmark destinations were altered.
Bug Fix SPIREPDF-7943 Fixed the issue where added bookmarks appeared in incorrect positions.
Bug Fix SPIREPDF-7945 Fixed the issue where an "Invalid font metrics" exception was thrown when converting PDF to PDF/A-2B.
Bug Fix SPIREPDF-7946 Fixed the issue where an “InvalidOperationException” was thrown when converting PDF to PDF/A-2B.
Bug Fix SPIREPDF-7949 Fixed the issue where an "Object reference not set to an instance of an object" exception was thrown when converting OFD to PDF.
Bug Fix SPIREPDF-7853 Fixes an issue where converting PDF to images resulted in incorrect rendering.
Bug Fix SPIREPDF-7920 Fixes an issue where shadows were offset when converting PDF to images.
Bug Fix SPIREPDF-7952 Fixes an issue where adding images to a PDF resulted in slow execution and excessively large file sizes.
Bug Fix SPIREPDF-7953 Fixes a NullReferenceException thrown when drawing the "MS Gothic" font onto a page.