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. |