Spire.Office 6.1

Spire.Office 6.1 is released

We are agog to announce the release of Spire.Office 6.1. This version brings some new features. For instance, Spire.XLS supports using newly added formulas of MS Excel2019 and adding some new features such as the availability of removing borders of pictures, the conversion from shape to picture, Spire.PDF supports customizing signed image when signing PDF, Spire.Presentation supports embedding ZIP objects into PPTX files, Spire.PDFViewer supports displaying page labels and many more. What’s more, a lot of bugs have been successfully fixed as well. 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.

DLL Versions:

  • Spire.License.dll 1.3.8
  • Spire.Barcode.dll 5.1.4
  • Spire.DataExport.dll 4.1.9
  • Spire.Doc.dll 9.1.7
  • Spire.DocViewer.Forms.dll 6.1.0
  • Spire.Email.dll 4.1.2
  • Spire.Pdf.dll 7.1.10
  • Spire.PdfViewer.Forms.dll 6.1.0
  • Spire.Presentation.dll 6.1.4
  • Spire.Spreadsheet.dll 5.1.0
  • Spire.XLS.dll 11.1.4
Click the link to get the version Spire.Office 6.1:
More information of Spire.Office new release or hotfix:

Here is a list of changes made in this release

Spire.XLS

Category ID Description
Optimization SPIREXLS-2965 Optimizes the speed of converting Excel to HTML.
New feature SPIREXLS-2244 Supports calculating newly added CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN of MS Excel2019.
New feature SPIREXLS-2872 Supports the function of not displaying the title of bubble chart.
chart.HasChartTitle = false;
New feature SPIREXLS-2254 Supports the function of removing the borders of pictures.
picture.Line.Visible = false or picture.Line.Weight = 0
New feature SPIREXLS-2990 Supports the function of converting shape to picture.
Image img = shape.SaveToImage();
shape.SaveToImage(string fileName);
shape.SaveToImage(string fileName, ImageFormat imageFormat);
shape.SaveToImage(Stream fileStream);
shape.SaveToImage(Stream fileStream, ImageFormat imageFormat);
New feature SPIREXLS-3059 Supports the function of compressing pictures in Excel.
Workbook book = new Workbook();
            book.LoadFromFile(input);
            foreach (Worksheet sheet in book.Worksheets)
            {
                foreach (ExcelPicture picture in sheet.Pictures)
                {
                    picture.Compress(30);
                }
            }
            book.SaveToFile(result, ExcelVersion.Version97to2003);
Bug SPIREXLS-2424 Fixes the issue that getting the chart title failed.
Bug SPIREXLS-2912 Fixes the issue that the date data was incorrectly wrapped when converting Excel to PDF.
Bug SPIREXLS-3002 Fixes the issue that the application threw System.OverflowException when loading file.
Bug SPIREXLS-3007 Fixes the issue that the application threw System.ArgumentOutOfRangeException when loading and saving files.
Bug SPIREXLS-3008 Fixes the issue that the data bar of the conditional format was not displayed correctly when converting Excel to PDF.
Bug SPIREXLS-3013 Fixes the issue that creating a pivot table failed in the environment with Win10 64-bit and Italy region setting.
Bug SPIREXLS-3018 Fixes the issue that the text boxes could not be copied correctly.
Bug SPIREXLS-3020 Fixes the issue that the text font indentation was changed from condensed to standard when copying cell content.
Bug SPIREXLS-3021
SPIREXLS-3037
SPIREXLS-3053
Fixes the issue that the application hung when converting Excel to Html.
Bug SPIREXLS-3033 Fixes the issue that the format of date data was incorrect when importing sheet data to data table.
Bug SPIREXLS-3034 Fixes the issue that inserting and deleting rows took a long time.
Bug SPIREXLS-3041 Fixes the issue that the data of the category label in the chart was incorrect when saving the chart to images.
Bug SPIREXLS-3044 Fixes the issue that the characters were garbled when converting CSV file with Turkish ISO-8859-9 encoding to xlsx file.

Spire.Doc

Category ID Description
Bug SPIREDOC-3818 Fixes the issue that the content of the converted PDF/XPS was incorrect when it contains right-to-left text.
Bug SPIREDOC-5120 Fixes the issue that no matches were found when finding the text.
Bug SPIREDOC-5138
SPIREDOC-5191
SPIREDOC-5307
Fixes the issue that the content was incorrect after converting Word to PDF.
Bug SPIREDOC-5159
SPIREDOC-5161
Fixes the issue that the text overlapped after converting Word to PDF.
Bug SPIREDOC-5217 Fixes the issue that page number was incorrect after converting Word to PDF.
Bug SPIREDOC-5301 Fixes the issue that the application threw the error "Object reference not set to an instance of an object" when converting Word to PDF.
Bug SPIREDOC-5303 Fixes the issue that it caused incorrect pagination after converting Word to PDF.
Bug SPIREDOC-5338 Fixes the issue that the bookmark location was changed after saving the Word document.
Bug SPIREDOC-5341 Fixes the issue that the lines were rendered incorrectly after converting Word to PDF.
Bug SPIREDOC-5346 Fixes the issue that the application threw the error "Index was outside of bounds of the array" when converting Word to PDF.
Bug SPIREDOC-5348 Fixes the issue that the equation was incorrect after saving to doc/docx file.
Bug SPIREDOC-5370 Fixes the issue that the list number value was incorrect after converting Word to PDF.
Bug SPIREDOC-5386 Fixes the issue that the application threw the error "Input string was not in a correct format" when loading the file.

Spre.PDF

Category ID Description
New Feature SPIREPDF-1136 Supports customizing signed image when signing PDF.
PdfSignature signature = new PdfSignature(doc, page, cert, "123456");
signature.ConfigureCustomGraphics(DrawGraphics);
 private void DrawGraphics(PdfCanvas g)
{
   PointF point1 = new PointF(10, 20);
   PointF point2 = new PointF(25, 50);
   PointF point3 = new PointF(60, 20);
   PointF[] pntArr = { point1, point2, point3 };
   PdfRGBColor color = new PdfRGBColor(Color.Red);
   g.DrawPolygon(new PdfPen(color), pntArr);
   g.DrawRectangle(new PdfPen(Color.Green), new RectangleF(70, 10, 20, 30));
   g.DrawLine(new PdfPen(Color.Blue), new PointF(120, 50), new PointF(95, 5));
   g.DrawLine(new PdfPen(Color.Blue), new PointF(100, 30), new PointF(130, 20));
 }
Bug SPIREPDF-970
SPIREPDF-1791
SPIREPDF-3869
Fixes the issue that entering the PIN multiple times when using Smart Card certificate and USB token to sign PDF.
Bug SPIREPDF-3554 Fixes the issue that the converted PDFA3B document from PDF did not meet the PDFA3B standard.
Bug SPIREPDF-3783 Fixes the issue that content order was incorrect when extracting pdf text.
Bug SPIREPDF-3851 Fixes the issue that the table cell merged format was lost when converting PDF to Excel.
Bug SPIREPDF-3872 Fixes the issue that the application threw an error "The object reference is not set to the instance of the object" when converting PDF to Excel.
Bug SPIREPDF-3914 Fixes the issue that some characters were not converted successfully when converting XPS to PDF.
Bug SPIREPDF-3937 Fixes the issue that Justify alignment style of text in grid cells did not take effect.

Spire.Presentation

Category ID Description
New Feature SPIREPPT-1385 Supports embedding ZIP objects into PPTX files. (Note that 03PPT does not support this feature.)
String zipPath= "C:/test.zip";
Presentation ppt = new Presentation();
byte[] data = File.ReadAllBytes(zipPath);
Rectangle rec = new Rectangle(80, 60, 100, 100);
//The first parameter needs to be passed the complete file name 
IOleObject ole = ppt.Slides[0].Shapes.AppendOleObject("test.zip", data, rec);
ole.ProgId = "Package";
Image image = Image.FromFile(@"E:\demoProducts\Image\logo.png");
IImageData oleImage = ppt.Images.Append(image);
ole.SubstituteImagePictureFillFormat.Picture.EmbedImage = oleImage;
ppt.SaveToFile(@"result.pptx", Spire.Presentation.FileFormat.Pptx2013);
New Feature - Supports loading and printing PPT/PPTX containing mathematical formulas and converting to other document formats.
Bug SPIREPPT-1395 Fixes the issue that the size of shape inside it was changed when copying group shape.
Bug SPIREPPT-1397 Fixes the issue that the shape's position was changed after the value of a shape inside group shape was modified.
Bug SPIREPPT-1398 Fixes the issue that the content was stretched when printing multiple slides onto one page.
Bug SPIREPPT-1398 Fixes the issue that the position of a shape was changed when the height of the shape was modified after cloning it into another slide.

Spire.Email

Category ID Description
Adjustment - Change the parameter type of ImapClient.MarkAsDeleted(int sequqnceNo) method from String to int.

Spire.PDFViewer

Category ID Description
New Feature SPIREPDFVIEWER-464 Supports the function of displaying page labels
Bug SPIREPDFVIEWER-448 Fixes the issue that the white color of the picture was displayed as black.
Bug SPIREPDFVIEWER-462 Fixes the issue that Chinese characters were displayed in garbled characters.
Bug SPIREPDFVIEWER-466 Fixes the issue that the page rotating failed.
Bug SPIREPDFVIEWER-467 Fixes the issue that the background color of form fields was displayed incorrectly.

Spire.Barcode

Category ID Description
New Feature - Adds BarcodeScan class so that different instances can be created to call the Scan method.
BarcodeScan task1 = new BarcodeScan();
task1.Scan(bitmap, rectangle, barcodeType);
Bug - Fixes the issue that the application threw an exception "object reference is not set to an instance of an object" when using BarcodeScanner.Scan method with asynchronous delegates.
Bug SPIREBARCODE-84
SPIREBARCODE-174
Fixes the issue that the scanned data of Code128 barcode was incorrect.
Bug SPIREBARCODE-90 Fixes the issue that the application hanged when scanning the picture without barcodes.
Bug SPIREBARCODE-93 Fixes the issue that the scanned data of QR-code was empty.
Bug SPIREBARCODE-167 Fixes the issue that barcodeSettings.Code128SetMode setting was invalid