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