News Category

Spire.Office 7.9.2 is released

2022-09-30 09:40:19

We are excited to announce the release of Spire.Office 7.9.2. In this version, Spire.PDF supports setting the binding orientation when creating a booklet; Spire.XLS supports getting the color of condition formats; Spire.Presentation supports finding the first matching text in a slide and modifying its style. Besides, a lot of known issues are fixed successfully. 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 v10.9.9
  • Spire.Pdf.dll v8.9.16
  • Spire.XLS.dll v12.9.3
  • Spire.Presentation.dll v7.9.2
  • Spire.Email.dll v5.8.0
  • Spire.DocViewer.Forms.dll v7.8.0
  • Spire.PdfViewer.Forms.dll v7.8.0
  • Spire.PdfViewer.Asp.dll v7.8.0
  • Spire.Spreadsheet.dll v6.9.0
  • Spire.OfficeViewer.Forms.dll v7.9.2
  • Spire.Barcode.dll v6.8.0
  • Spire.DataExport.dll v4.8.0
  • Spire.DataExport.ResourceMgr.dll v2.1.0
Click the link to get the version Spire.Office 7.9.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-5358 Supports setting the binding orientation when creating a booklet.
float width = PdfPageSize.A4.Width * 2;
float height = PdfPageSize.A4.Height; 
Stream outputstreaml = File.Open(outputFile, FileMode.Create, FileAccess.ReadWrite, FileShare.Read);
BookletOptions bookletOptions = new BookletOptions();
bookletOptions.BookletBinding = Spire.Pdf.Utilities.PdfBookletBindingMode.Left;
SizeF size = new SizeF(width, height);
PdfBookletCreator.CreateBooklet(doc, outputstreaml, size, bookletOptions);
New feature SPIREPDF-5403 Supports converting PDF to OFD with attachments together.
New feature SPIREPDF-5462 Supports setting the zoom type of bookmarks to Brought forward.
PdfDocument pdf = new PdfDocument();
pdf.LoadFromFile(inputFile);
            PdfBookmarkCollection bookmarks = pdf.Bookmarks;
            for(int i = 0; i<bookmarks.Count; i++)
            {
                PdfBookmark bookmark = bookmarks[i];
SetBookmarkAction(bookmark);
            }
            pdf.SaveToFile(outputFile, FileFormat.PDF);

  private void SetBookmarkAction(PdfBookmark bookmark)
{
    PdfDestination dest = bookmark.Destination;
    dest.Mode = PdfDestinationMode.Location;
    dest.Zoom = 0;
    for (int i = 0; i < bookmark.Count; i++)
    {
        PdfBookmark childbookmark = bookmark[i];
        SetBookmarkAction(childbookmark);
    }
}
New feature SPIREPDF-5461 Supports setting the zoom type of hyperlinks to Brought forward.
PdfDocument pdf = new PdfDocument();
pdf.LoadFromFile(inputFile);
            PdfAnnotationCollection annotations = pdf.Pages[0].AnnotationsWidget;
            for(int i = 0; i<annotations.Count; i++)
            {
                PdfDocumentLinkAnnotationWidget anno = annotations[i] as PdfDocumentLinkAnnotationWidget;
PdfDestination dest = anno.Destination;
dest.Mode = PdfDestinationMode.Location;
                dest.Zoom = 0;
                anno.Destination = dest;
            }
            pdf.SaveToFile(outputFile, FileFormat.PDF);
            pdf.Close();
New feature SPIREPDF-1126 Supports adding digital signatures with pictures.
static void Main(string[] args)
{

    PdfDocument doc = new PdfDocument();
    doc.LoadFromFile(@"test.pdf");
    PdfPageBase pagebase = doc.Pages[0];
    X509Certificate2 x509 = new X509Certificate2(@"gary.pfx", "e-iceblue");
    PdfOrdinarySignatureMaker signatureMaker = new PdfOrdinarySignatureMaker(doc, x509);
    IPdfSignatureAppearance signatureAppearance = new PdfCustomSignatureAppearance();
    signatureMaker.MakeSignature("Signature", signatureAppearance);
    doc.SaveToFile(@"new.pdf", Spire.Pdf.FileFormat.PDF);
    doc.Close();
}
public class PdfCustomSignatureAppearance : IPdfSignatureAppearance
{
    public void Generate(PdfCanvas g)
    {
        Image image = Image.FromFile("test.png");
        g.DrawImage(PdfImage.FromImage(image), new PointF(0, 0));
    }
}
Bug SPIREPDF-892 Fixes the issue that the DashDot line effect was incorrect after converting PDF to image.
Bug SPIREPDF-1121 Fixes the issue that the text position was incorrect after printing PDF.
Bug SPIREPDF-1125 Fixes the issue that there was an error when opening the PDF file which was filled the image field.
Bug SPIREPDF-4485 Fixes the issue that it failed to replace text in form field.
Bug SPIREPDF-5439 Fixes the issue that the extracted table content was incorrect.
Bug SPIREPDF-5441 Fixes the issue that the application threw System.ArgumentException when extracting table.
Bug SPIREPDF-5444 Fixes the issue that there was an error when opening the created PDF file with an image by Preview tool in MacOS12.5.
Bug SPIREPDF-5456 Fixes the issue that the program threw an error"Invalid date string, after year" when calling pdf.SaveToFile(file) in the German language system.
Bug SPIREPDF-5466 Fixes the issue that English letters on geometry were missing when converting PDF to image
Bug SPIREPDF-5467 Fixes the issue that the content was missing when converting PDF to image.
Bug SPIREPDF-1228
SPIREPDF-5298
Fixes the issue that caused incorrect text position after filling text field.
Bug SPIREPDF-5345 Fixes the issue that caused text position deviation after converting PDF to SVG.
Bug SPIREPDF-5407 Fixes the issue that it failed to convert PDF to images.
Bug SPIREPDF-5408 Fixes the issue that the pages were in the wrong order when creating a booklet.
Bug SPIREPDF-5413 Fixes the issue that the OFD file cannot be opened after converting PDF to OFD.
Bug SPIREPDF-5431 Fixes the issue that caused duplicate content in table extraction.
Bug SPIREPDF-5442 Fixes the issue that font styles were lost after converting PDF to SVG.
Bug SPIREPDF-5454 Fixes the issue that the application hangs when loading PDF.

Spire.XLS

Category ID Description
New feature SPIREXLS-4084 Supports getting the color of condition formats.
Color color = cRange.GetConditionFormatsStyle().Color;
Bug SPIREXLS-718
SPIREXLS-4066

Fixes the issue that caused incorrect content formatting after converting Excel to PDF
Bug SPIREXLS-2073 Fixes the issue that the application threw the "System.ArgumentException" when getting RichText from Excel on Linux system.
Bug SPIREXLS-2308
Fixes the issue that when setting the DPI to 125%, the content was cropped after converting chart to image.
Bug SPIREXLS-3036 Fixes the issue that caused incorrect pagination after converting Excel to PDF.
Bug SPIREXLS-3278 Fixes the issue that when setting the DPI to 125%, the content was incomplete after converting Excel to image.
Bug SPIREXLS-4038 Fixes the issue that the content was incorrect after converting chart to image.
Bug SPIREXLS-4047 Fixes the issue that failed to insert Pdf OLE object in Excel.
Bug SPIREXLS-4051 Fixes the issue that the application threw the "Shape failing to render" when converting Excel to PDF.
Bug SPIREXLS-4069 Fixes the issue that the application hung when loading Excel.
Bug SPIREXLS-4087 Fixes the issue that the number format of the cell (sheet.Range[0, 1].Text= "=SUM(18,29)" ) generated in the new version is a formula calculated value instead of text.
Bug SPIREXLS-4099 Fixes the issue that the application threw the "Element is an invalid XmlNodeType" when loading Excel.
Bug SPIREXLS-4100 Fixes the issue that the content was lost after converting Excel to image.
Bug SPIREXLS-4104 Fixes the issue that the date format was lost after inserting a date into cell.

Spire.Presentation

Category ID Description
New feature SPIREPPT-2037 Supports finding the first matching text in a slide and modifying its style.
Presentation ppt = new Presentation();
            ppt.LoadFromFile(inputFile);
            string text = "create";
            TextRange textRange = ppt.Slides[0].FindFirstTextAsRange(text);
            textRange.Fill.FillType = FillFormatType.Solid;
            textRange.Fill.SolidColor.Color = Color.Red;
            textRange.FontHeight = 28;
            textRange.LatinFont = new TextFont("Times New Roman");
            textRange.IsBold = TriState.True;
            textRange.IsItalic = TriState.True;
            textRange.TextUnderlineType = TextUnderlineType.Double;
            textRange.TextStrikethroughType = TextStrikethroughType.Single;
New feature SPIREPPT-2065 Support setting not to convert hidden slides when converting PPT to PDF.
Presentation presentation = new Presentation();
            presentation.LoadFromFile(input);
            presentation.SaveToPdfOption.ContainHiddenSlides = false;
            presentation.SaveToFile(output, FileFormat.PDF);
Bug SPIREPPT-2034 Fixes the issue that setting font size and color of data label didn't take effect.
Bug SPIREPPT-2051 Fixes the issue that the content was missing when converting PowerPoint to images.
Bug SPIREPPT-2067 Fixes the issue that the application threw System.ArgumentOutOfRangeException when loading PPT.

Spire.Doc

Category ID Description
Bug SPIREDOC-8386 Fixes the issue that the left border of the gray rectangle was cropped after converting Word to PDF.
Bug SPIREDOC-8390 Fixes the issue that part of the content was missing after converting Word to PDF.

Spire.Spreadsheet

Category ID Description
Bug SPREADSHEET-204 Fixes the issue that the Worksheet.Resize method did not work.