News & Releases
|
|
Spire.Office 5.11.0 is released
We're pleased to announce the release of Spire.Office 5.11.0. This version contains many fantastic new features, for example, Spire.Doc supports converting SmartArt to other document formats such as PDF/Image/XPS, Spire.XLS supports converting Excel to PDF A/1B and adding/deleting digital signature for Excel, Spire.PDF supports converting PDF to PDF/A3A, PDF/A3B and setting no borders for grid cell. Meanwhile, a series of issues occurred when loading, converting, manipulating Word, Excel and PDF documents 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.10.4.
- Spire.Pdf.dll v6.11.0
- Spire.XLS.dll v10.11.2
- 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.10.1
- Spire.OfficeViewer.Forms.dll v5.11.0
- Spire.Barcode.dll v4.9.2
- Spire.DataExport.dll v4.1.9
- Spire.DataExport.ResourceMgr.dll v2.1.0
- Spire.Common.dll v10.10.0
- Spire.License.dll v1.3.8
Click the link to get the version Spire.Office 5.11.0:
More information of Spire.Office new release or hotfix:
Here is a list of changes made in this release
Spire.Doc
| Category | ID | Description |
| New Feature | - | Supports converting SmartArt to other document formats such as PDF/Image/XPS. |
| New Feature | SPIREDOC-5049 | Supports setting "Contents cannot be edited" for content controls.
StructureDocumentTagInline sdt = new StructureDocumentTagInline(document); sdt.SDTProperties.LockSettings = LockSettingsType.ContentLocked; |
| Bug | SPIREDOC-4944 | Fixes the issue that the content was inconsistent when converting Word to PDF. |
| Bug | SPIREDOC-4946 | Fixes the issue that the application threw ArgumentOutOfRangeException when converting HTML to Word. |
| Bug | SPIREDOC-4968 | Fixes the issue that text position was incorrect when converting Word to PDF. |
| Bug | SPIREDOC-4969 | Fixes the issue that text wrapping was inconsistent when converting Word to PDF on Windows 10. |
| Bug | SPIREDOC-4987 | Fixes the issue that graph was incorrect when converting Word to PDF. |
| Bug | SPIREDOC-4996 | Fixes the issue that the application hung when converting Word to PDF. |
| Bug | SPIREDOC-5045 | Fixes the issue that the application threw FormatException when loading HTML. |
Spire.XLS
| Category | ID | Description |
| New Feature | SPIREXLS-2119 | Supports converting Excel to PDF A/1B.
Workbook workbook = new Workbook();
workbook.LoadFromFile("test.xlsx", ExcelVersion.Version2013);
workbook.ConverterSetting.PdfConformanceLevel = Spire.Pdf.PdfConformanceLevel.Pdf_A1B;
workbook.SaveToFile(@"output.pdf", Spire.Xls.FileFormat.PDF);
|
| New Feature | SPIREXLS-2834 | Supports calculating XLOOKUP formula in Office365 document. |
| New Feature | SPIREXLS-1863 | Supports adding/deleting digital signature function for Excel.
Workbook workbook = new Workbook(); workbook.LoadFromFile(inputFile); //Add digital signature X509Certificate2 cert = new X509Certificate2(inputFile_pfx, "e-iceblue"); DateTime certtime = new DateTime(2020, 7, 1, 7, 10, 36); IDigitalSignatures dsc = workbook.AddDigitalSignature(cert, "e-iceblue", certtime); //delete digital signature workbook.RemoveAllDigitalSignatures(); workbook.SaveToFile(outputFile, FileFormat); |
| New Feature | SPIREXLS-1571 | Supports revision function for Excel
//Accept all tracked changes Workbook workbook = new Workbook(); workbook.LoadFromFile(inputFile); workbook.AcceptAllTrackedChanges(); workbook.SaveToFile(outputFile, FileFormat.Version2013); //Reject all tracked changes Workbook workbook = new Workbook(); workbook.LoadFromFile(inputFile); workbook.RejectAllTrackedChanges(); workbook.SaveToFile(outputFile, FileFormat.Version2013); |
| New Feature | SPIREXLS-1562 SPIREXLS-2561 |
Supports mathematical formulas when converting Excel to PDF. |
| Bug | SPIREXLS-2253 | Fixes the issue that the content was reduced when printing Excel by a needle printer. |
| Bug | SPIREXLS-2763 | Fixes the issue that circular reference error occurred after adding a document custom property. |
| Bug | SPIREXLS-2778 | Fixes the issue that font color and font style of chart was changed after loading and saving Excel files. |
| Bug | SPIREXLS-2794 | Fixes the issue that AutoFitRow setting did not work. |
| Bug | SPIREXLS-2805 | Fixes the issue that chart data was not updated correctly after modifying data source. |
| Bug | SPIREXLS-2809 | Fixes the issue that SUM formula update failed. |
| Bug | SPIREXLS-2810 | Fixes the issue that the shape of the line was changed when converting Excel to PDF. |
| Bug | SPIREXLS-2813 | Fixes the issue that the number format was inconsistent when converting sheet to HTML. |
| Bug | SPIREXLS-2818 | Fixes the issue that the Ole object could be not opened successfully when inserting a Word Ole object containing Chinese name. |
| Bug | SPIREXLS-2822 | Fixes the issue that the application threw an error"xl/drawings/_rels/vmlDrawingHF1.vml.rels does not exist or is empty" when converting Excel to PDF. |
Spire.PDF
| Category | ID | Description |
| New Feature | - | Adjusts converting PDF/A document interface to Spire.Pdf.Conversion, and supports converting to PDF/A3A, PDF/A3B.
PdfStandardsConverter newDOC = new PdfStandardsConverter(inputFile); newDOC.ToPdfA1A(outputFile); newDOC.ToPdfA1B(outputFile); newDOC.ToPdfA2A(outputFile); newDOC.ToPdfA2B(outputFile); newDOC.ToPdfA3A(outputFile); newDOC.ToPdfA3B(outputFile); |
| New Feature | SPIREPDF-3602 | Supports creating the custom property with null value.PdfDocumentInformation info = document.DocumentInformation;
info.SetCustomProperty("new", "");
|
| New Feature | SPIREPDF-3693 | Supports setting no borders for grid cell.
Row.Cells[0].Style.Borders.Left.DashStyle = PdfDashStyle.None; Row.Cells[0].Style.Borders.Right.DashStyle = PdfDashStyle.None; Row.Cells[0].Style.Borders.Top.DashStyle = PdfDashStyle.None; Row.Cells[0].Style.Borders.Bottom.DashStyle = PdfDashStyle.None; PdfPen pen = new PdfPen(); pen.DashStyle = PdfDashStyle.None; Row.Cells[0].Style.Borders.All = pen |
| Bug | SPIREPDF-2916 | Fixes the issue that chinese characters were scrambled when converting PDF to Images. |
| Bug | SPIREPDF-3375 | Fixes the issue that the text was missing when printing PDF. |
| Bug | SPIREPDF-3573 | Fixes the issue that the application threw ArgumentException when converting PDF to XPS. |
| Bug | SPIREPDF-3619 | Fixes the issue that the hyperlinks was missing when using CreateTemplate() method to draw content. |
| Bug | SPIREPDF-3650 | Fixes the issue that the format of vertical text was incorrect when converting PDF to Images. |
| Bug | SPIREPDF-3657 | Fixes the issue that converting PDF to PCL stream failed. |
| Bug | SPIREPDF-3660 | Fixes the issue that the extracted text was incorrect. |
| Bug | SPIREPDF-3673 | Fixes the issue that the application threw NullReferenceException when merging PDFs. |
| Bug | SPIREPDF-3674 | Fixes the issue that the application threw IndexOutOfRangeException when searching text. |
| Bug | SPIREPDF-271 | Fixes the issue that the page size obtained is the default size after setting a page size. |
| Bug | SPIREPDF-324 | Fixes the issue that the application threw "Object reference not set to an instance of an object" error when converting PDF to image. |
| Bug | SPIREPDF-615 SPIREPDF-875 SPIREPDF-918 SPIREPDF-1915 |
Fixes the issue that the generated file does not conform to the standard of PDFA1A after converting PDF to PDFA1A. |
| Bug | SPIREPDF-686 | Fixes the issue that the generated file does not conform to the standard of PDFA3A after converting a PDF file which includes an xml attachment to PDFA3A. |
| Bug | SPIREPDF-930 | Fixes the issue that the fonts are not embedded after converting PDF to PDFA1B. |
| Bug | SPIREPDF-1107 | Fixes the issue that the application threw "ArgumentNullException" when extracting used fonts. |
| Bug | SPIREPDF-1214 | Fixes the issue that the application threw "OutOfMermoryException" when extracting image. |
| Bug | SPIREPDF-1549 | Fixes the issue that the form fields were flatten when copying form fields pages. |
| Bug | SPIREPDF-1836 | Fixes the issue that the generated file does not conform to the standard of PDFA1B after converting PDF to PDFA1B. |
| Bug | SPIREPDF-3522 | Fixes the issue that the content of field lost after flattening form fields. |
| Bug | SPIREPDF-3608 | Fixes the issue that the image was blank when converting PDF to Images. |
| Bug | SPIREPDF-3679 | Fixes the issue that the quality of image was poor. |
| Bug | SPIREPDF-3695 | Fixes the issue that the application threw NullReferenceException when getting page size. |
| Bug | SPIREPDF-2933 | Fixes the issue that the application threw an error "lost private key" when signing a pdf with LTV. |
| Bug | SPIREPDF-3509 | Fixes the issue that the application threw an error "CLR/System.InvalidOperationException" when creating PDFTrueTypeFont on Mac. |
| Bug | SPIREPDF-3564 | Fixes the issue that the shadow was incorrect when converting XPS to PDF. |
| Bug | SPIREPDF-3516 | Fixes the issue that the content was garbled when extracting text. |
| Bug | SPIREPDF-3707 | Fixes the issue that the text was overlapped when drawing text. |
Spire.Spreadsheet
| Category | ID | Description |
| Bug | SPREADSHEET-163 | Fixes the issue that the formulas were not calculated correctly. |
