Spire.Office 6.6

Spire.Office 6.6 is released

We are excited to announce the release of Spire.Office 6.6. This version brings some new features, for instance, Spire.PDF supports converting PDF to transparent background images and adds new features related to timestamp servers; Spire.XLS supports specifying the font file directory when converting Excel to PDF; Spire.Doc supports adding a horizontal line across entire pages and many more. In addition, a lot of bugs have been 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.License.dll 1.3.15
  • Spire.Barcode.dll 5.6.0
  • Spire.Email.dll 4.6.0
  • Spire.DataExport.dll 4.1.9
  • Spire.Pdf.dll 7.6.0
  • Spire.PdfViewer.Forms.dll 6.6.0
  • Spire.PdfViewer.Asp.dll 6.6.0
  • Spire.Doc.dll 9.6.10
  • Spire.DocViewer.Forms.dll 6.6.0
  • Spire.XLS.dll 11.6.0
  • Spire.Spreadsheet.dll 5.6.0
  • Spire.Presentation.dll 6.6.2
  • Spire.OfficeViewer.Forms.dll 6.6.2
Click the link to get the version Spire.Office 6.6:
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-4242 Supports converting PDF to transparent background images.
PdfDocument doc = new PdfDocument();
doc.LoadFromFile("input.pdf");
doc.ConvertOptions.SetPdfToImageOptions(0);
Image image = doc.SaveAsImage(0);
image.Save("output.png", ImageFormat.Png);
New feature SPIREPDF-4222 The PdfOrdinarySignatureMaker API supports digitally signing a PDF document with a timestamp server.
static void Main(string[] args)
{
    X509Certificate2 x509 = new X509Certificate2(inputFile_pfx, password);
    PdfDocument doc = new PdfDocument();
    doc.LoadFromFile(inputFile);
    PdfPKCS7Formatter formatter = new PdfPKCS7Formatter(x509, false);
    formatter.TimestampService = new TSAHttpService("http://time.certum.pl");
    PdfOrdinarySignatureMaker signatureMaker = new PdfOrdinarySignatureMaker(doc, formatter);
    IPdfSignatureAppearance signatureAppearance = new PdfCustomSignatureAppearance();
    signatureMaker.MakeSignature("sign", doc.Pages[0], 100, 100, 100, 100, signatureAppearance);   
    doc.SaveToFile(outputFile, FileFormat.PDF);
    doc.Close();
}
public class PdfCustomSignatureAppearance : IPdfSignatureAppearance
{
    public void Generate(PdfCanvas g)
    {
float fontSize = 10;
PdfTrueTypeFont font = new PdfTrueTypeFont(new Font("Arial", fontSize), true);
g.DrawString("AAAAAAAAAAA", font, PdfBrushes.Red, new PointF(0, 0));
    }
}
New feature SPIREPDF-4226 Supports setting the username and password of the timestamp server when digitally signing a PDF document.
string url = "http://test1.tsa.cn/tsa";
signature.ConfigureTimestamp(url, "tsademo", "tsademo");
New feature SPIREPDF-4313 Supports loading SVG files via stream.
doc.LoadFromSvg(Stream stream);
Bug SPIREPDF-3270 Fixes the issue that the return value was incorrect when verifying whether the signature had been modified.
Bug SPIREPDF-4269 Fixes the issue that PDF documents were damaged after encrypting.
Bug SPIREPDF-4280 Fixes the issue that it failed to parse the strong and em tags correctly.
Bug SPIREPDF-4281 Fixes the issue that the first page was empty when converting PDF to images.
Bug SPIREPDF-4283 Fixes the issue that the width of the space between two tags was large after parsing the HTML tags.
Bug SPIREPDF-4295 Fixes the issue that the content was incorrect after converting PDF to SVG.
Bug SPIREPDF-4304 Fixes the issue that the content was incorrect after converting SVG to PDF.
Bug SPIREPDF-2785 Fixes the issue that the content was incorrect after converting PDF to images.
Bug SPIREPDF-4134 Fixes the issue that the added signature was invalid.
Bug SPIREPDF-4223 Fixes the issue that the signing time of the added signature was incorrect.
Bug SPIREPDF-4231 Fixes the issue that the console printed the text "-------------AGAIN" when converting PDF to Excel.
Bug SPIREPDF-4232 Fixes the issue that the content was incorrect after converting XPS to PDF.
Bug SPIREPDF-4248 Fixes the issue that the printout was incorrect after printing the PDF.
Bug SPIREPDF-4258 Fixes the issue that an error prompted when opening the result file after merging the PDF files.
Bug SPIREPDF-4262 Fixes the issue that it failed to get the correct image location when using .NET Standard library.
Bug SPIREPDF-4263 Fixes the issue that the text location was changed after flattening the fields.
Bug SPIREPDF-4265 Removes the set method of Security.Permissions.
Bug SPIREPDF-4270 Fixes the issue the generated file did not conform to the standard of PDF/A-3B after digital signing PDFA/3B files.
Bug SPIREPDF-4297 Fixes the issue there were content errors after converting PDF to SVG.

Spire.XLS

Category ID Description
New feature SPIREXLS-3212 Supports detecting whether a row/column is hidden.
sheet.GetColumnIsHide(columnIndex) 
sheet.GetRowIsHide(rowIndex) 
New feature SPIREXLS-3219 Supports specifying the font file directory when converting Excel to PDF.
workbook.CustomFontFileDirectory = new string[] { "./Data/Font" };
Bug SPIREXLS-3096 Fixes the issue that there were extra underlines after converting sheet to HTML.
Bug SPIREXLS-3175 Fixes the issue that the content was incorrect after converting Excel to HTML.
Bug SPIREXLS-3191 Fixes the issue that content of Excel document was incorrect after removing the filters.
Bug SPIREXLS-3200 Fixes the issue that the application threw the error "Can't insert row" when inserting rows.
Bug SPIREXLS-3201 Fixes the issue that the application threw the error "Index was out of range" when converting Excel to PDF in docker container.
Bug SPIREXLS-3217 Fixes the issue that the content was incorrect after converting ChartSheet to images.
Bug SPIREXLS-3226 Fixes the issue that the application threw the error "System.OverflowException" when loading the XLSX file.
Bug SPIREXLS-3229 Fixes the issue that the application threw the error "System.ArgumentOutOfRangeException" when loading the XLSX file.
Bug SPIREXLS-3231 Fixes the issue that the text line break was incorrect after converting Excel to PDF.
Bug SPIREXLS-3238 Fixes the issue that the application threw the error "Input string was not in a correct format" when converting Excel to PDF.
Bug SPIREXLS-3239 Fixes the issue that the content was incorrect after converting chart to images.
Bug SPIREXLS-3243 Fixes the issue that the page margins were incorrect after converting Excel to PDF.
Bug SPIREXLS-3244 Fixes the issue that the content was incomplete after convert Excel to PDF when setting DPI to 125%.
Bug SPIREXLS-3245 Fixes the issue that it didn't get the correct cell format.
Bug SPIREXLS-3246 Fixes the issue that the WordArt text was cut off after converting Excel to PDF.
Bug SPIREXLS-3254
SPIREXLS-3259
Fixes the issue that the application threw the error "Invalid cell name" when loading the XLSX file.
Bug SPIREXLS-3260 Fixes the issue that the application threw the error "OutOfRangeException" when converting Excel to SVG.
Bug SPIREXLS-3261 Fixes the issue that the application threw the error "NullReferenceException" when converting Excel to PDF.
Bug SPIREXLS-3265 Fixes the issue that the application threw the error "System.Data.DuplicateNameException" when exporting the data of the Excel file.

Spire.Doc

Category ID Description
New feature SPIREDOC-5884 Supports adding a horizontal line across the entire page.
Document doc = new Document();
Section section = doc.AddSection();
section.AddParagraph().AppendHorizonalLine();
doc.SaveToFile("result.docx", FileFormat.Docx);
Bug SPIREDOC-5603 Fixes the issue that the content of the converted image was incorrect.
Bug SPIREDOC-5834 Fixes the issue that the inserted math equations containing Chinese characters were incorrect.
Bug SPIREDOC-5835 Fixes the issue that the number format was incorrect after merging mails.
Bug SPIREDOC-5851 Fixes the issue that there were extra characters after loading and saving the files.
Bug SPIREDOC-5854 Fixes the issue that the inserted math equations were incorrect.
Bug SPIREDOC-5868
SPIREDOC-5900
SPIREDOC-5904
Fixes the issue that the content was incorrect after converting Word to PDF.
Bug SPIREDOC-5940 Fixes the issue that the ol tag was not rendered correctly when appending HTML text.
Bug SPIREDOC-5942
SPIREDOC-5962
Fixes the issue that the table content was incorrect after converting Word to PDF.
Bug SPIREDOC-5949 Fixes the issue that the image content was incorrect after converting RTF to PDF.
Bug SPIREDOC-5965 Fixes the issue that the alignment of the inserted math equation was incorrect.
Bug SPIREDOC-6010 Fixes the issue that the application threw the error "System.ArgumentOutOfRangeException" when getting the text of the Word file.
Bug SPIREDOC-6022 Fixes the issue that the content was incorrect after loading and saving the Word file generated by NPOI.
Bug SPIREDOC-6027 Fixes the issue that the application threw the error "System.ObjectDisposedException" when saving the file after merging it.
Bug SPIREDOC-6083 Fixes the issue that there was an extra bookmark "Word Bookmarks" after converting Word to PDF.
Bug SPIREDOC-5110
SPIREDOC-5860
Fixes the issue that the content was incorrect after converting Word to PDF.
Bug SPIREDOC-5668 Fixes the issue that the printout was incorrect after printing Word files.
Bug SPIREDOC-5864 Fixes the issue that the image was missing after converting Word to PDF.
Bug SPIREDOC-5874 Fixes the issue that the content of the TOC was incorrect after converting Word to PDF.
Bug SPIREDOC-5875 Fixes the issue that some text was missing after converting Word to PDF.
Bug SPIREDOC-5958
SPIREDOC-6016
Fixes the issue that the pagination was incorrect after converting Word to PDF.
Bug SPIREDOC-6040 Fixes the issue that the orientation was incorrect after printing Word files.
Bug SPIREDOC-6073 Fixes the issue that the application threw the error "System.NullReferenceException" when loading a RTF file.
Bug SPIREDOC-6081 Fixes the issue that the application threw the error "System.NullReferenceException" when loading a Word file.

Spire.Presentation

Category ID Description
Bug SPIREPPT-1547 Fixes the issue that the application threw the error "Shape was not found" when loading PPT files.
Bug SPIREPPT-1555 Fixes the issue that the line format of the generated file was incorrect after copying the slide.
Bug SPIREPPT-1559 Fixes the issue that the application threw the error "System.IndexOutOfRangeException" when loading PPT files.
Bug SPIREPPT-1560 Fixes the issue that the application threw the error "Can't assign string which contains paragraph break character" when replacing the text.
Bug SPIREPPT-1561 Fixes the issue that it did not take effect when setting the text effect of the WordArt to arch.
Bug SPIREPPT-1570 Fixes the issue that the content was incorrect after converting PPT to PDF.

Spire.PDFViewer

Category ID Description
Bug SPIREPDFVIEWER-139 Fixes the issue that there were garbled characters after opening PDF files.
Bug SPIREPDFVIEWER-230
SPIREPDFVIEWER-440
Fixes the issue that the content was incorrect after opening PDF files.
Bug SPIREPDFVIEWER-476 Fixes the issue that the content was not displayed when zooming in to view the PDF.
Bug SPIREPDFVIEWER-440 Fixes the issue that it displayed a blank page after opening the PDF file.

Spire.OfficeViewer

Category ID Description
Bug SPIREOFFICEVIEWER-23 Fixes the issue that the watermark was displayed incomplete after opening Word files.