Spire.Office 9.11.0 is released

Spire.Office 9.11.0 is released

2024-11-29 10:02:36

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.