Spire.Office 5.9.6

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
Click the link to get the version Spire.Office 5.9.6:
More information of Spire.Office new release or hotfix:

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.