Spire.Office 8.2.2 is released

Spire.Office 8.2.2 is released

2023-02-17 09:23:33

We are excited to announce the release of Spire.Office 8.2.2. In this version, Spire.PDF adds TextCompressionOptions to support setting compression type and supports setting the text alignment type for PdfFreeTextAnnotation; Spire.Doc supports the FLOOR.MATH formula and "what if analysis" goal seek; Spire.Presentation enhances the conversion from PowerPoint to images. Besides, a lot of known issues are successfully fixed in this update. More details are listed below.

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

DLL Versions:

  • Spire.Doc.dll v11.2.3
  • Spire.Pdf.dll v9.2.6
  • Spire.XLS.dll v13.2.4
  • Spire.Presentation.dll v8.2.0
  • Spire.Email.dll v6.2.3
  • Spire.DocViewer.Forms.dll v7.10.0
  • Spire.PdfViewer.Forms.dll v7.10.0
  • Spire.PdfViewer.Asp.dll v7.10.0
  • Spire.Spreadsheet.dll v7.1.0
  • Spire.OfficeViewer.Forms.dll v8.2.2
  • Spire.Barcode.dll v7.2.1
  • Spire.DataExport.dll v4.8.0
  • Spire.DataExport.ResourceMgr.dll v2.1.0
Click the link to get the version Spire.Office 8.2.2:
More information of Spire.Office new release or hotfix:

Here is a list of changes made in this release

Spire.PDF

Category ID Description
New feature SPIREPDF-5132 Supports setting the color space of PdfSeparationColor as RGB.
PdfDocument pdf = new PdfDocument();
 PdfPageBase page = pdf.Pages.Add();
 PdfRGBColor c = Color.Purple;

 //color space RGB
 PdfSeparationColorSpace cs = new PdfSeparationColorSpace("MySpotColor", new PdfRGBColor(c.R, c.G, c.B));
 //color space CMYK
 PdfSeparationColorSpace cs = new PdfSeparationColorSpace("MySpotColor", new PdfRGBColor(c.C, c.M, c.Y, c.K));
 //color space Grayscale
 PdfSeparationColorSpace cs = new PdfSeparationColorSpace("MySpotColor", new PdfRGBColor(c.Gray));

 PdfSeparationColor color = new PdfSeparationColor(cs, 1f);
 PdfSolidBrush brush = new PdfSolidBrush(color);
 page.Canvas.DrawPie(brush, 10, 30, 60, 60, 360, 360);
 page.Canvas.DrawString("Tint=1.0", new PdfFont(PdfFontFamily.Helvetica, 10f), brush, new PointF(22, 100));
 color = new PdfSeparationColor(cs, 0.5f);
 brush = new PdfSolidBrush(color);
 page.Canvas.DrawPie(brush, 80, 30, 60, 60, 360, 360);
 page.Canvas.DrawString("Tint=0.5", new PdfFont(PdfFontFamily.Helvetica, 10f), brush, new PointF(92, 100));
 color = new PdfSeparationColor(cs, 0.25f);
 brush = new PdfSolidBrush(color);
 page.Canvas.DrawPie(brush, 150, 30, 60, 60, 360, 360);
 page.Canvas.DrawString("Tint=0.25", new PdfFont(PdfFontFamily.Helvetica, 10f), brush, new PointF(162, 100));
 pdf.SaveToFile("SpotColorrgb.pdf");
New feature SPIREPDF-5705 Adds TextCompressionOptions to support setting compression type.
PdfCompressor compressor = new PdfCompressor(fileName);
compressor.Options.TextCompressionOptions.UnembedFonts = true;
compressor.CompressToFIle(outputName);
New feature SPIREPDF-5733 Supports setting the text alignment type for PdfFreeTextAnnotation.
RectangleF rect = new RectangleF(x, y, 100, 15);
PdfFreeTextAnnotation textAnnotation = new PdfFreeTextAnnotation(rect);
TextAlignment(textAnnotation);
textAnnotation.TextAlignment = PdfAnnotationTextAlignment.Right;
New feature SPIREPDF-5735 Supports saving to stream after compressing the PDF file.
using (FileStream fileStream = new FileStream(outputFile, FileMode.Create))
{
    PdfCompressor compressor = new PdfCompressor(inputFile);
    compressor.CompressToStream(fileStream);
    fileStream.Flush();
    fileStream.Close();
}
Bug SPIREPDF-5713 Fixes the issue that the content was incorrect after printing a PDF file.
Bug SPIREPDF-5740 Fixes the issue that the content was an offset to the bottom right after printing a PDF file.
Bug SPIREPDF-5741 Fixes the issue that the checkbox checked value didn't display when opening the output PDF with PDF-XChange.
Bug SPIREPDF-5745 Fixes the issue that the RadioButton field value lost after flattening the PDF forms.
Bug SPIREPDF-5754 Fixes the issue that the RadioButton field value was incorrect after flattening the PDF forms.
Bug SPIREPDF-5386 Optimizes the time consumption when converting PDF to Excel.
Bug SPIREPDF-5511 Fixes the issue that it failed to display the added text annotation in WPS software.
Bug SPIREPDF-5659 Fixes the issue that the time consumption of converting two pages with same content to image differs a lot.
Bug SPIREPDF-5660 Fixes the issue that the invisible lines became visible after converting XPS to PDF.
Bug SPIREPDF-5677 Fixes the issue that caused incorrect format after extracting text from PDF pages.
Bug SPIREPDF-5697 Fixes the issue that getting the Destination of bookmark returned incorrect data.
Bug SPIREPDF-5726 Fixes the issue that the application threw the "ArgumentException" when converting Pdf to image.

Spire.XLS

Category ID Description
New feature SPIREXLS-4405 Supports setting the Boolean value of addQuotationForStringValue to make the result strings have quotation marks after converting Excel to CSV.
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"ToCSV.xlsx");
Worksheet sheet = workbook.Worksheets[0];
//The last parameter " true" makes the result strings have quotation marks
sheet.SaveToFile(@"ToCSV.csv", ",",true);
New feature SPIREXLS-4422 Supports running "what if analysis" goal seek.
Workbook book = new Workbook();
book.LoadFromFile(inputFile);
Worksheet sheet = book.Worksheets[0];
CellRange targetCell = sheet.Range["E2"];
CellRange gussCell = sheet.Range["B4"];
GoalSeek goalSeek = new GoalSeek();
GoalSeekResult result= goalSeek.TryCalculate (targetCell, 2000, gussCell);
result.Determine();
New feature SPIREXLS-4386 Supports the FLOOR.MATH formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "FLOOR.MATH(12.758,2,-1)";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx");
Bug SPIREXLS-3469 Fixes the issue that the fonts changed after converting an Excel file to PDF.
Bug SPIREXLS-4367 Fixes the issue that the values were incorrect after referencing the external data source.
Bug SPIREXLS-4402 Fixes the issue that the content format was incorrect after converting an Excel file to PDF.
Bug SPIREXLS-4403 Fixes the issue that the content format was incorrect after converting Excel files to images with netstandard dlls.
Bug SPIREXLS-4407 Fixes the issue that the Conditional Format range was incorrect after invoking DeleteRange() method.
Bug SPIREXLS-4412 Fixes the issue that it didn't take effect to set IsTextWrapped for chart data label.
Bug SPIREXLS-4420 Fixes the issue that the application threw "OutOfMemoryError" when converting an Excel file to PDF.
Bug SPIREXLS-4424 Fixes the issue that the obtained background color of the cell range was incorrect.
Bug SPIREXLS-4413 Fixes the issue that it didn't take effect to invoke workbook.IsSaved.

Spire.Presentation

Category ID Description
Bug SPIREPPT-2153 Fixes the issue that the memory failed to release when the PowerPoint to image conversion program ended.

Spire.Barcode

Category ID Description
Bug SPIREBARCODE-235 Fixes the issue that the QR code position is incorrect when setting UseHttpHandlerMode="True" in an ASP web application.