Spire.Office 5.5.1

Spire.Office 5.5.1 is released

We're pleased to announce the release of Spire. Office 5.5.1. This version has some fantastic new features, such as Spire.PDF supports adding and converting SVG picture to PDF, creating PDF Portfolios, Spire.Doc supports getting the diagonal properties of table and table cells, Spire.XLS supports converting HTML to Excel. At the same time, a series of issues that occurred when loading, converting and manipulating PDF, Word and Excel files 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.

Dll Versions:

  • Spire.Doc.dll v8.5.4
  • Spire.Pdf.dll v6.5.9
  • Spire.XLS.dll v10.5.7
  • Spire.Email.dll v3.3.0
  • Spire.DocViewer.Forms.dll v5.1.1
  • Spire.PdfViewer.Forms.dll v5.1.4
  • Spire.PdfViewer.Asp.dll v5.1.4
  • Spire.Presentation.dll v5.5.1
  • Spire.Spreadsheet v4.3.3
  • Spire.OfficeViewer.Forms.dll v5.5.1
  • Spire.Barcode.dll v4.5.0
  • Spire.DataExport.dll v4.1.9
  • Spire.DataExport.ResourceMgr.dll v2.1.0
  • Spire.Common.dll v10.5.7
  • Spire.License.dll v1.3.8
Click the link to get the version Spire.Office 5.5.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-1258 Supports adding SVG picture to PDF.
PdfDocument doc1 = new PdfDocument();
doc1.LoadFromSvg(inputFile_svg);
PdfDocument doc2 = new PdfDocument();
doc2.LoadFromFile(inputFile_pdf);
PdfTemplate template = doc1.Pages[0].CreateTemplate();
template.Draw(doc2.Pages[0].Canvas, new PointF());
doc2.SaveToFile(outputFile, FileFormat.PDF);
New Feature - Support converting SVG picture to PDF.
PdfDocument doc = new PdfDocument();
doc.LoadFromSvg("test.svg");
doc.SaveToFile("result.pdf", FileFormat.PDF);
New Feature SPIREPDF-548
SPIREPDF-1023
Supports creating PDF Portfolios.
String[] files = new String[] { "File1.pdf", "File2.pdf" };
using (PdfDocument doc = new PdfDocument())
{
    for (int i = 0; i < files.Length; i++)
    {
        doc.Collection.AddFile(files[i]);
    }
    doc.SaveToFile("output.pdf", FileFormat.PDF);
    doc.Dispose();
}	
//Create sub folder and add file into itstring[] files = Directory.GetFiles(@"input/");
string inputFile_1 = "input.pdf";
using (PdfDocument doc = new PdfDocument(inputFile_1))
{
    for (int i = 0; i < files.Length; i++)
    {
        doc.Collection.Folders.AddFile(files[i]);
        PdfFolder folder = doc.Collection.Folders.CreateSubfolder("SubFolder" + i);
        folder.AddFile(files[i]);
    }
    doc.SaveToFile("output.pdf", FileFormat.PDF);
    doc.Dispose();
}
Bug SPIREPDF-1453 Optimizes the memory growth problem when finding text.
Bug SPIREPDF-2341 Fixes the issue that the text position was incorrect when converting PDF to Word.
Bug SPIREPDF-3164 Fixes the issue that the extracted text was incorrect.
Bug SPIREPDF-3176 Fixes the issue that it failed to sign on the existing XFASignatureField.
Bug SPIREPDF-3182 Fixes the issue that the location of getting PolygonAnnotation was incorrect.
Bug SPIREPDF-3187 Fixes the issue that the application threw "Invalid/Unknown/Unsupported format" exception when extracting text.
Bug SPIREPDF-3188 Fixes the issue that it failed to get the PDF rectangle annotation.
Bug SPIREPDF-3190 Fixes the issue that the text content extracted from specified area was incorrect.
Bug SPIREPDF-3197 Fixes the issue that the spacing was incorrect when filling the PDF TextBoxField.
Bug SPIREPDF-2841 Fixes the issue that the PDF document converted from Excel document was displayed incorrectly in Adobe.
Bug SPIREPDF-3020 Fixes the issue that the application threw the exception "Index was outside the bounds of the array" when printing PDF document.
Bug SPIREPDF-3205 Fixes the issue that textbox field was displayed incorrectly in Adobe after setting it to "ReadOnly".
Bug SPIREPDF-3232 Fixes the issue that the application threw "NullReferenceException" when extracting the text of the PDF document.
Bug SPIREPDF-3236 Fixes the issue that the application threw the exception "Value cannot be null" when accessing the used fonts.
Bug SPIREPDF-3245 Fixes the issue that the application threw the exception "Signature 'FPZYZ' failed to verified" when verifying if the document was modified

Spire.Doc

Category ID Description
New Feature SPIREDOC-4147 Supports getting the diagonal properties of table and table cells.
//Get the diagonal properties of table
BorderStyle bs_UP = table.TableFormat.Borders.DiagonalUp.BorderType;
Color color_UP = table.TableFormat.Borders.DiagonalUp.Color;
float width_UP = table.TableFormat.Borders.DiagonalUp.LineWidth;
BorderStyle bs_Down = table.TableFormat.Borders.DiagonalDown.BorderType;
Color color_Down = table.TableFormat.Borders.DiagonalDown.Color;
float width_Down = table.TableFormat.Borders.DiagonalDown.LineWidth;

//Get the diagonal properties of table cells
bs_UP = table[rowIndex, columnIndex].CellFormat.Borders.DiagonalUp.BorderType;
width_UP = table[rowIndex, columnIndex].CellFormat.Borders.DiagonalUp.LineWidth;
color_UP = table[rowIndex, columnIndex].CellFormat.Borders.DiagonalUp.Color;
bs_Down = table[rowIndex, columnIndex].CellFormat.Borders.DiagonalDown.BorderType;
color_Down = table[rowIndex, columnIndex].CellFormat.Borders.DiagonalDown.Color;
width_Down = table[rowIndex, columnIndex].CellFormat.Borders.DiagonalDown.LineWidth;
Bug SPIREDOC-3865 Fixes the issue that content was incorrect when converting Word to PDF.
Bug SPIREDOC-4046 Fixes the issue that the application threw an exception "The object reference was not set to an instance of the object" when converting Word to images.
Bug SPIREDOC-4126 Fixes the issue that the field structure was broken after inserting HTML text.
Bug SPIREDOC-4149 Fixes the issue that the application threw an exception "The format of input string is incorrect" when loading document.
Bug SPIREDOC-4161 Fixes the issue that there were extra double quotes when adding an Advance field.
Bug SPIREDOC-4164 Fixes the issue that the application threw an exception "Index was out of range" when inserting HTML text.
Bug SPIREDOC-4204 Fixes the issue that the application threw an exception "An unhandled exception of type 'System.StackOverflowException' occurred in mscorlib.dll" when saving the document after updating fields.

Spire.XLS

Category ID Description
New Feature SPIREXLS-902
SPIREXLS-1842
Adds the LoadFromHtml and LoadFromMHtml methods that support converting HTML to Excel.
workbook.LoadFromHtml(string fileName);
workbook.LoadFromHtml(Stream stream);
workbook.LoadFromMHtml(string fileName);
workbook.LoadFromMHtml(Stream stream);
Bug SPIREXLS-2045 Fixes the issue that the picture went black when converting Excel to PDF.
Bug SPIREXLS-2165 Fixes the issue that the application threw an error "ArgumentOutOfRangeException".
Bug SPIREXLS-2243 Fixes the issue that the application threw an error "FormatException".
Bug SPIREXLS-2202 Fixes the issue that the right margin was incorrect when converting Excel to PDF.
Bug SPIREXLS-2266 Fixes the issue that line feed of text was incorrect when converting Excel to PDF.
Bug SPIREXLS-2269 Fixes the issue that the style of pivotTable was missing when converting Excel to HTML.
Bug SPIREXLS-2270
SPIREXLS-2321
Fixes the issue that the data of chart created from the PivotTable was not updated correctly when converting Excel to PDF.
Bug SPIREXLS-2287 Fixes the issue that the grid lost when converting XML to Excel.
Bug SPIREXLS-2289 Fixes the issue that the content was narrowed down when printing Excel using customized printing size.
Bug SPIREXLS-2309 Fixes the issue that the content was incorrect when converting XLTX to PDF.
Bug SPIREXLS-2311 Fixes the issue that the application threw an error "NullReferenceException".
Bug SPIREXLS-2324 Fixes the issue that the border style was changed when converting Excel to PDF.
Bug SPIREXLS-2325 Fixes the issue that the application threw an error "ArgumentNullException".