News & Releases
|
Spire.Office 5.9.6 is released
We're pleased to announce the release of Spire.Office 5.9.6. This version contains some fantastic new features, such as Spire.Presentation supports ungrouping the grouped shapes and getting the shapes of layout slide by placeholder, Spire.XLS supports repeating the item labels of PivotTable field, Spire.Barcode supports setting the alignment of the barcode top text and adding custom text at the bottom of the barcode. Meanwhile, a series of issues occurred when converting, manipulating PowerPoint, Excel and PDF documents and scanning barcodes have been successfully fixed. More details are given 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.
- Spire.Doc.dll v8.9.6
- Spire.Pdf.dll v6.9.16
- Spire.XLS.dll v10.9.16
- Spire.Email.dll v3.9.1
- Spire.DocViewer.Forms.dll v5.1.1
- Spire.PdfViewer.Forms.dll v5.9.2
- Spire.PdfViewer.Asp.dll v5.9.2
- Spire.Presentation.dll v5.9.5
- Spire.Spreadsheet v4.5.0
- Spire.OfficeViewer.Forms.dll v5.9.6
- Spire.Barcode.dll v4.9.2
- Spire.DataExport.dll v4.1.9
- Spire.DataExport.ResourceMgr.dll v2.1.0
- Spire.Common.dll v10.9.16
- Spire.License.dll v1.3.8
Here is a list of changes made in this release
Spire.Presentation
Category | ID | Description |
New Feature | SPIREPPT-1293 | Supports ungrouping the grouped shapes.
GroupShape groupShape = presentation.Slides[0].Shapes[0] as GroupShape; presentation.Slides[0].Ungroup(groupShape); |
New Feature | SPIREPPT-1298 | Adds "GetPlaceholderShapes" method to get the shapes of layout slide by placeholder.
Placeholder placeholder = presentation.Slides[1].Shapes[0].Placeholder; IShape[] shapes = presentation.Slides[1].GetPlaceholderShapes(placeholder); for (int i = 0; i < shapes.Length; i++) { if (shapes[i] is IAutoShape) { IAutoShape autoShape = shapes[i] as IAutoShape; if (autoShape.TextFrame != null) { Console.WriteLine(autoShape.TextFrame.Text); } } } |
New Feature | SPIREPPT-1299 | Supports the GroupShapes method to return GroupShape object.
ArrayList groupShapeList = new ArrayList(); groupShapeList.Add(shape1); groupShapeList.Add(shape2); groupShapeList.Add(shape3); GroupShape groupshape = ppt.Slides[0].GroupShapes(groupShapeList); |
Bug | SPIREPPT-1294 | Fixes the issue that the application threw "DocumentEditException" when cloning a slide to another file. |
Bug | SPIREPPT-1301 | Fixes the issue that a shape was missing after grouping the shapes. |
Bug | SPIREPPT-1305 | Fixes the issue that the application threw "NullReferenceException" when converting PPTX to HTML. |
Bug | SPIREPPT-1306 | Fixes the issue that the application threw "IndexOutOfRangeException" when loading the PPTX file. |
Bug | SPIREPPT-1307 | Fixes the issue that it caused incorrect chart content after converting PPTX to PDF. |
Bug | SPIREPPT-1308 | Fixes the issue that the application threw the error “Encrypted presentations are not supported” when loading a protected PPT file. |
Spire.XLS
Category | ID | Description |
New Feature | SPIREXLS-2705 | Supports repeating item labels of PivotTable field.
pt.PivotFields["OnHand"].RepeatItemLabels = true; |
Bug | SPIREXLS-2666 | Fixes the issue that the polygons became rectangles after converting xls to xlsx. |
Bug | SPIREXLS-2710 | Fixes the issue that the value of Left property of the Rectangle that was created by Spire was 0. |
Bug | SPIREXLS-2734 | Fixes the issue that the content was incorrect when converting the sheet that contains pivot table to PDF. |
Bug | SPIREXLS-2750 | Fixes the issue that the added number format was incorrect in German environment when saving to Excel. |
Bug | SPIREXLS-2751 | Fixes the issue that the height and width of rectangle changed after setting the left and top properties. |
Bug | SPIREXLS-2756 | Fixes the issue that the value of "FIXED" formula was incorrect after converting to PDF. |
Bug | SPIREXLS-2762 | Fixes the issue that failed to get correct end row index at pagination. |
Bug | SPIREXLS-2766 | Fixes the issue that the content was incorrect when converting Excel to PDF. |
Bug | SPIREXLS-2771 | Fixes the issue that the border was incorrect when converting Excel to PDF. |
Bug | SPIREXLS-2782 | Fixes the issue that the border lost after converting xls to ods. |
Spire.PDF
Category | ID | Description |
Bug | SPIREPDF-2827 SPIREPDF-3531 |
Fixes the issue that after adding multiple button fields, Adobe Acrobat Reader DC tool popped up an error "Fixing up form fields" when opening the result pdf file by it. |
Bug | SPIREPDF-3151 | Fixes the issue that the top of the character was cropped when printing PDF. |
Bug | SPIREPDF-3425 | Fixes the issue that Y value of the text that was found was incorrect. |
Bug | SPIREPDF-3435 | Fixes the issue that Width value of the text that was found was incorrect. |
Bug | SPIREPDF-3441 | Fixes the issue that replacing image failed. |
Bug | SPIREPDF-3449 | Fixes the issue that PdfPolygonAnnotation created could not be printed. |
Bug | SPIREPDF-3483 | Fixes the issue that the result of extracting text from a particular rectangular region was incorrect. |
Bug | SPIREPDF-3513 | Fixes the issue that converting pdf to docx failed on WPF application. |
Bug | SPIREPDF-3546 | Fixes the issue that the stamp was missing when converting PDF to Word. |
Bug | SPIREPDF-3557 | Fixes the issue that the application threw "Bad XML name" when adding a custom property with name=2.16.76.1.4.2.2.1 and value = 101620. |
Bug | SPIREPDF-3560 | Fixes the issue that the application threw System.NullReferenceexception when extracting the images in the template page. |
Bug | SPIREPDF-3565 | Fixes the issue that the status of check box was changed on the template page. |
Bug | SPIREPDF-3567 | Fixes the issue that the bold style of text was missing when converting PDF to XPS. |
Bug | SPIREPDF-3577 SPIREPDF-3590 |
Fixes the issue that the application threw ArgumentOutOfRangeException when converting PDF to HTML. |
Bug | SPIREPDF-3582 | Fixes the issue that it failed to change the name of the form field. |
Bug | SPIREPDF-3585 | Fixes the issue that the application threw ArgumentOutOfRangeException when converting PDF to Image. |
Spire.Barcode
Category | ID | Description |
New Feature | SPIREBARCODE-126 | Supports setting the alignment of the barcode top text.
int width = 399; int height = 159; BarcodeSettings bs = new BarcodeSettings(); bs.Type = BarCodeType.UPCA; bs.Unit = GraphicsUnit.Pixel; bs.WideNarrowRatio = 0.5f; bs.TextFont = new Font("Arial", 20, FontStyle.Regular); string data = "602318275035"; bs.Data2D = data; bs.Data = data; bs.ShowTextOnBottom = true; bs.TopText = data; bs.ShowTopText = true; bs.TextAlignment = StringAlignment.Center; bs.TopTextAligment = StringAlignment.Center; bs.TopTextFont = new Font("Arial", 20, FontStyle.Regular); bs.AutoResize = false; bs.X = 3.0f; bs.BarHeight = height * 0.6f; bs.ImageWidth = width; bs.ImageHeight = height; BarCodeGenerator generator = new BarCodeGenerator(bs); Image barImage = generator.GenerateImage(); barImage.Save(outputFile_img, ImageFormat.Png); |
New Feature | SPIREBARCODE-155 | Supports adding custom text at the bottom of the barcode.
BarcodeSettings barsetting = new BarcodeSettings(); barsetting.Type=BarCodeType.EAN13; barsetting.BackColor = Color.WhiteSmoke; String data = "6901234567892"; barsetting.Data=data; barsetting.Data2D=data;barsetting.TopText="EAN13"; barsetting.TopTextFont=new Font("Arial", 20, FontStyle.Regular); barsetting.TopTextColor=Color.Red; barsetting.ShowTopText=true; barsetting.ShowTextOnBottom=true; barsetting.TopTextAligment=StringAlignment.Center; barsetting.BottomText="EAN"; barsetting.BottomTextFont=new Font("fangsong", 25, FontStyle.Bold); barsetting.BottomTextColor=Color.Black; barsetting.ShowBottomText=true; barsetting.BottomTextAligment=StringAlignment.Far; BarCodeGenerator generator = new BarCodeGenerator(barsetting); Image barcode = generator.GenerateImage(); barcode.Save(outputFile_img); |
Bug | SPIREBARCODE-85 SPIREBARCODE-113 SPIREBARCODE-156 |
Fixes the issue that the scan result was incorrect. |
Bug | SPIREBARCODE-101 SPIREBARCODE-106 SPIREBARCODE-157 |
Fixes the issue that scanning the barcode failed. |
Bug | SPIREBARCODE-146 | Fixes the issue that the application threw "NullPointerException" when scanning barcode. |
Bug | SPIREBARCODE-154 | Fixes the issue that adding custom text did not take effect. |
Bug | SPIREBARCODE-156 | Fixes the issue that the scan result was incorrect when scanning QR code with special characters. |