Spire.Office 6.2.1

Spire.Office 6.2.1 is released

We are happy to announce the release of Spire.Office 6.2.1. This update brings some fantastic features, for example, Spire.PDF supports detecting whether the PDF is encrypted or not as well as converting PDF files to grayscale and additionally adds new methods of replacing text; Spire.Presentation supports replacing video files. Furthermore, a lot of bugs have been successfully fixed. 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 9.2.4
  • Spire.Pdf.dll 7.2.6
  • Spire.XLS.dll 11.2.3
  • Spire.Email.dll 4.1.2
  • Spire.DocViewer.Forms.dll 6.1.0
  • Spire.PdfViewer.Forms.dll 6.1.1
  • Spire.PdfViewer.Asp.dll 6.1.1
  • Spire.Presentation.dll 6.2.2
  • Spire.Spreadsheet 5.2.0
  • Spire.OfficeViewer.Forms.dll 6.2.1
  • Spire.Barcode.dll 5.1.4
  • Spire.DataExport.dll 4.1.9
  • Spire.DataExport.ResourceMgr.dll 2.1.0
  • Spire.License.dll 1.3.8
Click the link to get the version Spire.Office 6.2.1:
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-878 Supports converting PDF file to grayscale.
PdfGrayConverter convert = new PdfGrayConverter(inputFile);
convert.ToGrayPdf(outputFile);
New Feature SPIREPDF-3110 Supports detecting whether the PDF is encrypted.
PdfDocument.IsPasswordProtected(inputFile);
New Feature SPIREPDF-3991 Supports setting the signature details in advanced properties for digital signatures.
public CustomPKCS7SignatureFormatter(X509Certificate2 certificate)
{
if (null == certificate)
{ throw new ArgumentNullException("certificate"); }
m_certificate = certificate;
Parameters.Add("Filter", "Adobe.PPKMS");
Parameters.Add("SubFilter", "adbe.pkcs7.detached");
Parameters.Add("SignatureLength", 975);
Parameters.Add("SoftwareModuleName", "Create by Spire.Pdf");
New Feature - Adds new methods of replacing text.
PdfTextReplacer ptr = new PdfTextReplacer(page);
ptr.ReplaceAllText("LONDON MIDLAND", "West Midlands Railway");//replace all text
ptr.ReplaceText("LONDON MIDLAND", "West Midlands Railway");//replace only one 
Bug SPIREPDF-328 Fixes the issue that the application threw the error "There is an error in XML document" when loading the XPS file.
Bug SPIREPDF-782 Fixes the issue that the content was incorrect after converting PDF to images.
Bug SPIREPDF-848 Fixes the issue that the the content was missing after printing the PDF.
Bug SPIREPDF-967 Fixes the issue that the border was missing after printing the PDF.
Bug SPIREPDF-1385 Fixes the issue that the text was messed up after converting PDF to Doc.
Bug SPIREPDF-1416 Fixes the issue that the application threw the error "KeyNotFoundException" when flatting form fields after merging PDF files.
Bug SPIREPDF-1977 Fixes the issue that the jumping position of the created PdfGoToAction was incorrect.
Bug SPIREPDF-3811 Fixes the issue that picture became opaque after converting PDF to SVG.
Bug SPIREPDF-3898 Fixes the issue that only the last signature was valid when digitally signing PDF multiple times.
Bug SPIREPDF-3957 Fixes the issue that the content was incorrect when setting the text alignment to justify.
Bug SPIREPDF-3969 Fixes the issue that the generated PDF was not displayed correctly when opened in Adobe.
Bug SPIREPDF-3974 Fixes the issue that the application threw the error "Document encryption is not allowed in FIPS mode" when encrypting the PDF in FIPS mode.
Bug SPIREPDF-3986 Fixes the issue that the drawn grid was incorrect.
Bug SPIREPDF-3986 Fixes the issue that the content was incorrect after adding SVG image to PDF.
Bug SPIREPDF-3993 Fixes the issue that the images were rotated after compressing PDF.
Bug SPIREPDF-3998 Fixes the issue that the application threw the error "Index was outside the bounds of the array" when printing PDF.
Bug SPIREPDF-4005 Fixes the issue that the the converted PDF/A-3B file was not recognized when opened in Foxit Reader.
Bug SPIREPDF-347 Fixes the issue that size and location of image was incorrect after drawing image to PDF.
Bug SPIREPDF-996 Fixes the issue that the application threw ArgumentException when converting PDF to image.
Bug SPIREPDF-1141 Fixes the issue that some characters lost when converting XPS to PDF.
Bug SPIREPDF-3299 Fixes the issue that the image's color went black after drawing image to PDF.
Bug SPIREPDF-4004 Fixes the issue that the content of output pdf was incorrect when inserting pages with different sizes into a PDF.
Bug SPIREPDF-4006 Fixes the issue that the application threw "The index can not be less then zero or greater then Count" when calling page.CreateTemplate()method.
Bug SPIREPDF-4007 Fixes the issue that background color of image went black after drawing transparent image to PDF.

Spire.Doc

Category ID Description
Bug SPIREDOC-5279
SPIREDOC-5351
Fixes the issue that the content was inconsistent when converting Word to PDF.
Bug SPIREDOC-5333 Fixes the issue that the links were missing when converting Word to PDF.
Bug SPIREDOC-5425
SPIREDOC-5457
Fixes the issue that the application threw the "System.NullReferenceException" when converting Word to PDF
Bug SPIREDOC-5431 Fixes the issue that the application threw the "System.Exception: 'Invalid data'" when loading a password-protected docx file.
Bug SPIREDOC-5432 Fixes the issue that the application threw the "System.InvalidOperationException" when loading a doc file.
Bug SPIREDOC-5444 Fixes the issue that the application threw the "System.FormatException" when converting Word to PDF
Bug SPIREDOC-5453 Fixes the issue that the application threw the "System.FormatException" when loading a docx file
Bug SPIREDOC-5454 Fixes the issue that the application threw the "System.ArgumentOutOfRangeException" when loading a docx file.
Bug SPIREDOC-5481 Fixes the issue that the signature picture disappeared when converting Word to PDF.

Spire.Presentation

Category ID Description
New Feature SPIREPPT-1413 Supports the function of replacing video files.
Presentation ppt= new Presentation();
ppt.LoadFromFile(inputFile);
VideoCollection videos = ppt.Videos;
foreach (ISlide sld in ppt.Slides)
{
    foreach (Spire.Presentation.Shape sp in sld.Shapes)
    {
        if (sp is IVideo)
        {
IVideo video = sp as IVideo;
byte[] bts = File.ReadAllBytes("C:/test.mp4");
VideoData videoData = videos.Append(bts);
video.EmbeddedVideoData = videoData;
        }
    }
}
ppt.SaveToFile(outputFile, FileFormat.Pptx2013);
Bug SPIREPPT-1414 Fixes the issue that the output pptx file could not be opended after deleting the shape where the video was located
Bug SPIREPPT-1415 Fixes the issue that the text of data label in chart was garbled when converting PPT to Image in multithreaded mode.
Bug SPIREPPT-1418 Fixes the issue that the application threw NullReferenceException when replacing the images in SmartArt.
Bug SPIREPPT-1430 Fixes the issue that the application threw "an object reference is not set to an instance of the object" when loading PPT.
Bug SPIREPPT-1451 Fixes the issue that the bulleted list displayed incorrectly after copying the paragraphs with bulleted list to new slide.
Bug SPIREPPT-1456 Fixes the issue that the application threw {"rgb(255 is not a valid value for Int32. (Parameter 'htmlColor')"} when adding html text.
Bug SPIREPPT-1457
SPIREPPT-1458
Fixes the issue that the output pptx file got very large after merging two pptx files.

Spire.XLS

Category ID Description
Bug SPIREXLS-1886 Fixes the issue that only the first sheet worked when changing the background color of multiple sheets and converting the sheets to images.
Bug SPIREXLS-2981 Fixes the issue that opening output files failed after adding char code data to cell
Bug SPIREXLS-3023 Fixes the issue that the application threw System.NullReferenceException when copying charts.
Bug SPIREXLS-3056 Fixes the issue that the application threw System.StackOverflowException when converting Excel to PDF.
Bug SPIREXLS-3060 Fixes the issue that the application threw System.NullReferenceException when loading an XLSX file.
Bug SPIREXLS-3061 Fixes the issue that the application threw System.ArgumentNullException when loading an XLSX file.
Bug SPIREXLS-3064 Fixes the issue that the line breaks were inconsistent when converting Excel to PDF.
Bug SPIREXLS-3065 Fixes the issue that the application threw System.ArgumentException when calculating PivotTable data.
Bug SPIREXLS-3073 Fixes the issue that the retrieved data type of cell was incorrect.
Bug SPIREXLS-3074 Fixes the issue that the size of the converted PDF from Excel increased to 20 times.
Bug SPIREXLS-3078 Fixes the issue that the text did not wrap and thus resulted in incomplete text display when converting text with vertical layout and auto-wrap to PDF/Images.
Bug SPIREXLS-3079 Fixes the issue that the content displayed incompletely when converting Excel to PDF.
Bug SPIREXLS-3082 Fixes the issue that the layout of the chart in the generated .ods document was incorrect.
Bug SPIREXLS-3086 Fixes the issue that the center alignment style of text with vertical layout was lost when converting Excel to PDF/Images.
Bug SPIREXLS-3097 Fixes the issue that the color of the background image went black after saving files.
Bug SPIREXLS-3103 Fixes the issue that the content was incorrect when converting XLSM to PDF.
Bug SPIREXLS-3105 Fixes the issue that copying the drop-down list failed.