We are excited to announce the release of Spire.Office 9.11.0. In this version, Spire.XLS supports passing values to group pivot tables; Spire.Presentation supports setting whether to save SlidePicture shapes as graphic tags when converting PowerPoint to SVG; Spire.PDF supports returning an array of region values for the PdfTextMarkupAnnotationWidget. More details are listed below.
In this version, the most recent versions of Spire.DocViewer, Spire.PDF, Spire.XLS, Spire.Doc, Spire.Presentation, Spire.PDF are included.
DLL Versions:
- Spire.DocViewer 8.8.3
- Spire.PDF 10.11.7
- Spire.XLS 14.11.3
- Spire.Doc 12.11.7
- Spire.Presentation 9.11.3
- Spire.PDF 10.11.1
Click the link to get the version Spire.Office 9.11.0:
More information of Spire.Office new release or hotfix:
Here is a list of changes made in this release
Spire.XLS
| Category | ID | Description |
| New feature | SPIREXLS-5469 SPIREXLS-5470 SPIREXLS-5546 SPIREXLS-5564 SPIREXLS-5565 |
Supports the new formulas including ACOT, ACOTH, COT, TOROW, TOCOL. |
| New feature | SPIREXLS-5534 | Supports passing values to group pivot tables.
Workbook wb = new Workbook(); wb.LoadFromFile(inputFile); Worksheet pivotSheet = wb.Worksheets[0]; XlsPivotTable pivot = (XlsPivotTable)pivotSheet.PivotTables[0]; PivotField dateBaseField = pivot.PivotFields["number"] as PivotField; dateBaseField.CreateGroup(3000, 3800, 1); pivot.CalculateData(); wb.SaveToFile(outputFile); wb.Dispose(); |
| Bug | SPIREXLS-3123 | Fixes the issue that the results were incorrect after compressing images. |
| Bug | SPIREXLS-5056 | Fixes the issue that some content was hidden when converting Excel to images. |
| Bug | SPIREXLS-5081 | Fixes the issue that the program threw an 'ArgumentOutOfRangeException' error while loading an Excel document. |
| Bug | SPIREXLS-5120 | Fixes the issue that the image content was incorrect after loading and saving an Excel document. |
| Bug | SPIREXLS-5177 | Fixes the issue that the chart height was incorrect when converting Excel to PDF. |
| Bug | SPIREXLS-5364 | Fixes the issue that the effect was incorrect when using "Worksheet.AutoFitColumn()" method. |
| Bug | SPIREXLS-5513 | Fixes the issue that the background color changed when saving xls to xlsx. |
| Bug | SPIREXLS-5537 | Fixes the issue that the content was incorrect when converting Excel to PDF. |
| Bug | SPIREXLS-5538 | Fixes the issue that the results were incorrect when replacing images in Excel. |
| Bug | SPIREXLS-5543 | Fixes the issue that the content was incorrect when converting Chart to Image. |
| Bug | SPIREXLS-5544 | Fixes the issue that the content was lost when printing Excel document. |
| Bug | SPIREXLS-5545 | Fixes the issue that the results were incorrect when using VLOOKUP() formula. |
| Bug | SPIREXLS-5554 | Fixes the issue that the content was incorrect when converting Excel to PDF. |
Spire.Presentation
| Category | ID | Description |
| New feature | SPIREPPT-2636 | Adds a new boolean property "ppt.SaveToSvgOption.ConvertPictureUsingGraphicTag" to set whether to save SlidePicture shapes as graphic tags when converting PPTX to SVG.
ppt.SaveToSvgOption.ConvertPictureUsingGraphicTag = true; |
| Bug | SPIREPPT-2552 | Fixes the issue that PDFA standards were not applied when converting PPTX documents to PDFA documents. |
| Bug | SPIREPPT-2615 | Fixes the issue that the text direction was incorrect when converting PPTX documents to SVG files. |
| Bug | SPIREPPT-2628 | Fixes the issue that the background color was incorrect when using the "shape.SaveAsSvgInSlide()" method to convert to SVG documents. |
| Bug | SPIREPPT-2629 | Fixes the issue that the text was not properly aligned when converting slides to SVG documents. |
| Bug | SPIREPPT-2631 | Fixes the issue that the application threw "System.NullReferenceException: Object reference not set to an instance of an object" exception when loading PPTX documents. |
Spire.PDF
| Category | ID | Description |
| New feature | SPIREPDF-7135 | Supports returning an array of region values for PdfTextMarkupAnnotationWidget.
// Create a PdfDocument object
PdfDocument doc = new PdfDocument();
// Load a PDF file
doc.LoadFromFile(inputFile);
// Initialize a StringBuilder to store extracted text
StringWriter highlightedTextWriter = new StringWriter();
// Loop through each page in the document
foreach (PdfPageBase page in doc.Pages)
{
// Get all annotations on the page
PdfAnnotationCollection annotations = page.Annotations;
// Loop through the annotations
foreach (PdfAnnotation annotation in annotations)
{
// Check if the annotation is a highlight annotation
if (annotation is PdfTextMarkupAnnotationWidget highlightAnnotation)
{
if (highlightAnnotation.TextMarkupAnnotationType == PdfTextMarkupAnnotationType.Highlight)
{
PdfBrush brush = PdfBrushes.Red;
PdfPen pen = new PdfPen(brush, 1f);
for (int i = 0;i<highlightAnnotation.QuadPoints.Length;i += 2) {
page.Canvas.DrawLine(pen, highlightAnnotation.QuadPoints[i], highlightAnnotation.QuadPoints[i + 1]);
}
}
}
}
}
doc.SaveToFile(outputFile);
|
| New feature | SPIREPDF-7145 | Supported the functionality to extract video and audio from PDF documents.
PdfDocument pdf = new PdfDocument();
pdf.LoadFromFile(inputFile);
for (int i = 0; i < pdf.Pages.Count; i++)
{
PdfPageBase page = pdf.Pages[i];
PdfAnnotationCollection ancoll = page.Annotations;
for (int j = 0; j < ancoll.Count; j++)
{
PdfRichMediaAnnotationWidget MediaWidget = ancoll[j] as PdfRichMediaAnnotationWidget;
byte[] data = MediaWidget.RichMediaData;
string embedFileName = MediaWidget.RichMediaName;
File.WriteAllBytes(outputFile + embedFileName,data);
}
}
|
| Bug | SPIREPDF-7049 | Fixed the issue that the program threw an "ArgumentException" error when converting XPS to PDF. |
| Bug | SPIREPDF-7125 SPIREPDF-7156 |
Fix the issue that the content is displayed incompletely after converting SVG to PDF. |
| Bug | SPIREPDF-7147 | Fix the issue that the signature verification was not correct. |
| Bug | SPIREPDF-7172 | Fix the issue that the content was lost after converting PDF to images. |
| Bug | SPIREPDF-7178 | Fix the issue that the program threw an "ObjectDisposedException" error when converting PDF to Markdown. |
| Bug | SPIREPDF-7183 | Fixed the issue that the content was incorrect when printing PDF documents. |
| Bug | SPIREPDF-6786 | Fixes the issue that highlighting text did not work correctly. |
| Bug | SPIREPDF-7055 | Fixes the issue that the program threw "Cannot find table 'loca' in the font file" when loading SVG. |
| Bug | SPIREPDF-7114 | Fixes the issue that merging PDF documents failed to work. |
| Bug | SPIREPDF-7126 | Fixes the issue that page size could not be set using PageSettings.PaperFormat when using ChromeHtmlConverter to convert HTML to PDF. |
| Bug | SPIREPDF-7129 | Fixes the issue that the result of PdfDocument.Conformance was incorrect. |
| Bug | SPIREPDF-7133 | Fixes the issue that the result of signature validity verification was incorrect. |
| Bug | SPIREPDF-7144 | Fixes the issue that the result of bookmark style modification was incorrect. |
| Bug | SPIREPDF-7148 | Optimizes the time consumption of PDF to image conversion. |