Spire.Office 11.2.0 is released

2026-02-28 10:24:43

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:

https://www.e-iceblue.com/Download/download-office-for-net-now.html

More information of Spire.Office new release or hotfix:

https://www.e-iceblue.com/forum/spire-office-new-release-or-hotfix-t4764.html

Here is a list of changes made in this release

Spre.doc

CategoryIDDescription
New featureSPIREDOC-11444Added 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 FixSPIREDOC-11799Fixed the issue where converting Word to PDF results inconsistent output.

Spre.XLS

CategoryIDDescription
New FeatureSPIREXLS-6086 SPIREXLS-6087Added 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 FixSPIREXLS-6061Fixed an issue where comments were not sorted when using DataSorter.Sort().
Bug FixSPIREXLS-6078Fixed an issue where ConditionalFormats.Remove() did not work correctly.
Bug FixSPIREXLS-6082Fixed an issue where column widths became inconsistent when opening the saved Excel file in WPS.
Bug FixSPIREXLS-6084Fixed an issue where images were lost when converting Office 365 Excel documents to PDF.
Bug FixSPIREXLS-6090Fixed an issue where setting the font size for merged cells did not take effect.
Bug FixSPIREXLS-6099 SPIREXLS-6100Fixed an issue where Excel-to-PDF conversion results were inconsistent.

Spire.Presentation

CategoryIDDescription
CategoryIDDescription
Bug FixSPIREPPT-2841Fixed the issue where rendering effects were inconsistent when converting PowerPoint to SVG.
Bug FixSPIREPPT-3073Fixed the issue that extraneous log information was generated when converting PowerPoint to PDF.
Bug FixSPIREPPT-3073Fixed the issue that charts were missing when converting PowerPoint to PDF.

Spire.PDF

CategoryIDDescription
OptimizationSPIREPDF-7881Optimizes the compression functionality for netstandard DLLs to improve the file compression ratio.
New FeatureSPIREPDF-7780Added 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 FeatureSPIREPDF-7907Added support for configuring text color when replacing text in PDF pages.
PdfTextReplacer textReplacer = new PdfTextReplacer(page);
textReplacer.Options = textReplaceOptions;
textReplacer.ReplaceAllText("文档", "文件", Color.Red);
Bug FixSPIREPDF-7871Fixed the issue where the program hung when converting PDF to images.
Bug FixSPIREPDF-7882Fixed the issue where the seal was rendered incorrectly when converting OFD to images.
Bug FixSPIREPDF-7915Fixed the issue where the output was incorrect when converting XPS to PDF.
Bug FixSPIREPDF-7922Fixed the issue that PDF bookmark destinations were altered.
Bug FixSPIREPDF-7943Fixed the issue where added bookmarks appeared in incorrect positions.
Bug FixSPIREPDF-7945Fixed the issue where an "Invalid font metrics" exception was thrown when converting PDF to PDF/A-2B.
Bug FixSPIREPDF-7946Fixed the issue where an “InvalidOperationException” was thrown when converting PDF to PDF/A-2B.
Bug FixSPIREPDF-7949Fixed the issue where an "Object reference not set to an instance of an object" exception was thrown when converting OFD to PDF.
Bug FixSPIREPDF-7853Fixes an issue where converting PDF to images resulted in incorrect rendering.
Bug FixSPIREPDF-7920Fixes an issue where shadows were offset when converting PDF to images.
Bug FixSPIREPDF-7952Fixes an issue where adding images to a PDF resulted in slow execution and excessively large file sizes.
Bug FixSPIREPDF-7953Fixes a NullReferenceException thrown when drawing the "MS Gothic" font onto a page.
Logo

助力广东及东莞地区开发者,代码托管、在线学习与竞赛、技术交流与分享、资源共享、职业发展,成为松山湖开发者首选的工作与学习平台

更多推荐