News & Releases
|
Spire.Office 6.3.3 is released
We are happy to announce the release of Spire.Office 6.3.3. This update brings some fantastic features, for example, Spire.PDF supports removing form field as well as adding PDF Portfolio from stream; Spire.XLS supports changing data source in Pivot Table as well as setting the shape order and many more. In addition, 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 v9.3.3
- Spire.Pdf.dll v7.3.1
- Spire.XLS.dll v11.3.4
- Spire.Email.dll v4.1.2
- Spire.DocViewer.Forms.dll v6.1.0
- Spire.PdfViewer.Forms.dll v6.1.1
- Spire.PdfViewer.Asp.dll v6.1.1
- Spire.Presentation.dll v6.2.2
- Spire.Spreadsheet.dll v5.3.0
- Spire.OfficeViewer.Forms.dll v6.3.3
- Spire.Barcode.dll v5.1.4
- Spire.DataExport.dll v4.1.9
- Spire.DataExport.ResourceMgr.dll v2.1.0
- Spire.License.dll v1.3.8
Click the link to get the version Spire.Office 6.3.3:
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-4022 | Supports adding page-piece dictionaries.
PdfDocument doc = new PdfDocument(inputFile); if (doc.DocumentPieceInfo==null) { doc.DocumentPieceInfo = new PdfPieceInfo(); } doc.DocumentPieceInfo.AddApplicationData("ice","this is a uu"); doc.DocumentPieceInfo.AddApplicationData("blie", "this is a uu"); doc.DocumentPieceInfo.AddApplicationData("blue", "this is a uu"); doc.DocumentPieceInfo.AddApplicationData("jis", "this is a uu"); doc.DocumentPieceInfo.RemoveApplicationData("blie"); if (doc.Pages[0].PagePieceInfo==null) { doc.Pages[0].PagePieceInfo = new PdfPieceInfo(); } doc.Pages[0].PagePieceInfo.AddApplicationData("ice", "this is a uu"); doc.Pages[0].PagePieceInfo.AddApplicationData("blie", "this is a 2222uu"); doc.Pages[0].PagePieceInfo.AddApplicationData("blue", "this is a 3333uu"); doc.Pages[0].PagePieceInfo.AddApplicationData("jis", "this is a 4444uu"); doc.Pages[0].PagePieceInfo.RemoveApplicationData("blie"); StringBuilder sb = new StringBuilder(); IDictionary<sstring, PdfApplicationData> dic = doc.Pages[0].PagePieceInfo.ApplicationDatas; foreach (string item in dic.Keys) { PdfApplicationData data = dic[item]; if (data.Private is String) { string ss = data.Private as string; sb.AppendLine(ss); } } File.WriteAllText(outputFile_txt, sb.ToString()); doc.SaveToFile(outputFile); |
New Feature | SPIREPDF-281 | Supports removing form field.
string input = @"Field.pdf"; PdfDocument doc = new PdfDocument(); doc.LoadFromFile(input); PdfFormWidget formWidget = doc.Form as PdfFormWidget; if (formWidget != null) { //method 1 //formWidget.FieldsWidget.Clear(); for (int i = formWidget.FieldsWidget.List.Count - 1; i >= 0; i--) { //method2 PdfField field = formWidget.FieldsWidget.List[i] as PdfField; formWidget.FieldsWidget.Remove(field); } } string output = "DeleteFormField.pdf"; doc.SaveToFile(output); |
New Feature | SPIREPDF-4062 | Supports adding PDF Portfolio from stream.
PdfDocument doc = new PdfDocument(); MemoryStream stream = new MemoryStream(File.ReadAllBytes("test.pdf")); doc.Collection.AddFile("file.pdf", stream); doc.SaveToFile("result.pdf"); |
Bug | SPIREPDF-949 | Fixes the issue that bold effect of Chinese characters was missing when converting PDF to XPS. |
Bug | SPIREPDF-955 | Fixes the issue that the application threw NullReferenceException when converting PDF to Image. |
Bug | SPIREPDF-1135 | Fixes the issue that the background color tunred black when converting PDF to Image. |
Bug | SPIREPDF-3060 | Fixes the issue occurred when opening the document encrypted by Spire.PDF with Adobe. |
Bug | SPIREPDF-3178 | Fixes the issue that box-shadow effect was incorrect when converting HTML to PDF with plugins. |
Bug | SPIREPDF-4020 | Fixes the issue that deleting the pencil annotations created by Spire.PDF failed. |
Bug | SPIREPDF-4025 | Fixes the issue that the extracted text from PDF was out of order. |
Bug | SPIREPDF-4026 | Fixes the issue that the application threw System.ArgumentException when saving PDF. |
Bug | SPIREPDF-4029 | Fixes the issue that the content of the PDF file saved by Spire.PDF was lost. |
Bug | SPIREPDF-4030 | Fixes the issue that the application threw System.FormatException when converting PDF to Image. |
Bug | SPIREPDF-4033 | Fixes the issue that the background of text turned black when printing PDF. |
Bug | SPIREPDF-4036 SPIREPDF-4037 |
Fixes the issue that the contents were lost when converting PDF to Excel. |
Bug | SPIREPDF-927 | Fixes the issue that a warning popped when opening the PDF saved after filling textBox form field. |
Bug | SPIREPDF-1322 | Fixes the issue that the text order was incorrect when extracting text from PDF. |
Bug | SPIREPDF-3039 | Fixes the issue that adding timestamp to digital signature by using NETCore failed. |
Bug | SPIREPDF-3770 | Fixes the issue that the saved PDF document size was big after splitting PDF. |
Bug | SPIREPDF-3975 | Fixes the issue that there wasn't output PDF when converting Html to PDF with Plugin in Linux. |
Bug | SPIREPDF-4038 | Fixes the issue that the application threw System.ArgumentNullException when converting PDF to Image. |
Bug | SPIREPDF-4040 | Fixes the issue that the generated file did not conform to the standard of PDF/A-3A after converting PDF to PDF/A-3A. |
Bug | SPIREPDF-4042 | Fixes the issue that the application threw the error “An item with the same key has already been added” when getting the properties “DocumentInformation” and “Conformance” of the PDF. |
Bug | SPIREPDF-4044 | Fixes the issue that an error popped when opening the result file after compressing the images in the PDF. |
Bug | SPIREPDF-4047 | Fixes the issue that the drawn grid was incorrect. |
Bug | SPIREPDF-4053 | Fixes the issue that an error popped when opening the result file after replacing the text. |
Bug | SPIREPDF-4056 | Fixes the issue that it failed to add the weblink to PDF. |
Bug | SPIREPDF-4061 | Fixes the issue that the generated PDF was blank when using the CreateTemplate method to draw PDF pages. |
Bug | SPIREPDF-4063 | Fixes the issue that there was an error popped when opening the converted PDFA3A file in Adobe. |
Bug | SPIREPDF-4064 | Fixes the issue that the document could not be edited after removing the signature field. |
Bug | SPIREPDF-4069 | Fixes the issue that the layout was messed up when using WPS to open the result word document after converting PDF to Word. |
Bug | SPIREPDF-4070 | Fixes the issue that the application threw System.FormatException when converting PDF to Image. |
Bug | SPIREPDF-4075 | Fixes the issue that the verification failed when verifying the converted PDFA3A file |
Spire.XLS
Category | ID | Description |
New Feature | SPIREXLS-813 SPIREXLS-2714 |
Supports changing data source in Pivot Table.
var pivotTable = sheet.PivotTables[0]; ((Spire.Xls.PivotTable)pivotTable).ChangeDataSource(sheet.Range["A1:C9"]); |
New Feature | SPIREXLS-3112 | Supports setting the shape order.
wb.Worksheets[0].Pictures[0].ChangeLayer(ShapeLayerChangeType.BringForward); wb.Worksheets[1].Pictures[0].ChangeLayer(ShapeLayerChangeType.BringToFront); wb.Worksheets[2].Pictures[1].ChangeLayer(ShapeLayerChangeType.SendBackward); wb.Worksheets[3].Pictures[1].ChangeLayer(ShapeLayerChangeType.SendToBack); |
New Feature | SPIREXLS-3117 | Supports operating the theme of Workbook.
//copy the theme from Excel workbook.CopyTheme(srcWorkbook); //set theme color workbook.SetThemeColor(ThemeColorType.Accent1, Color.Blue); //get theme color Color color = workbook.GetThemeColor(ThemeColorType.Accent2); //set style as theme color style.SetThemeColor(ThemeColorType.Lt1, 0.1); //get theme color of style bool isThemeColor = style.GetThemeColor(out themeType, out tint); |
New Feature | SPIREXLS-3120 | Supports getting the range of freeze panes.
sheet.GetFreezePanes(out rowIndex, out colIndex); |
Bug | SPIREXLS-2419 | Fixes the issue that getting series data in discontinuous areas failed. |
Bug | SPIREXLS-2808 | Fixes the issue that the corresponding data was incorrect when setting PlotArea to create a chart. |
Bug | SPIREXLS-2916 | Fixes the issue that the date formula conversion failed when converting Excel to PDF. |
Bug | SPIREXLS-3006 | Fixes the issue that the application threw "Exception Unhandled" when converting Excel to PDF. |
Bug | SPIREXLS-3085 | Fixes the issue that setting HasMajorGridLines as "true" did not work when creating a new chart. |
Bug | SPIREXLS-3087 | Fixes the issue that the application threw "System.NullReferenceException" when loading an XLSM file and threw "System.ArgumentOutOfRangeException" when converting an XLSM file to HTML. |
Bug | SPIREXLS-3104 | Fixes the issue that the recognition of date format data was incorrect. |
Bug | SPIREXLS-3115 | Fixes the issue that the barcode of output PDF was displayed incorrectly when converting XLSX to PDF. |
Bug | SPIREXLS-3116 | Fixes the issue of the chart being updated incorrectly. |
Bug | SPIREXLS-2223 SPIREXLS-2575 |
Fixes the issue that the content was incorrect after converting Excel to Image. |
Bug | SPIREXLS-2724 | Fixes the issue that the font format was incorrect after converting Excel to PDF. |
Bug | SPIREXLS-2820 | Fixes the issue that the pagination was incorrect after converting Excel to PDF. |
Bug | SPIREXLS-3084 | Fixes the issue that the chart format was incorrect after saving it. |
Bug | SPIREXLS-3113 | Fixes the issue that the color of pie chart was incorrect. |
Spire.Doc
Category | ID | Description |
Bug | SPIREDOC-4100 | Fixes the issue that the pagination was inconsistent when converting Word to PDF. |
Bug | SPIREDOC-4501 | Fixes the issue that the checkbox was missing when converting Word to PDF. |
Bug | SPIREDOC-4666 SPIREDOC-4896 |
Fixes the issue that the format was incorrect when converting Word to PDF. |
Bug | SPIREDOC-5448 | Fixes the issue that the application threw "System.InvalidOperationException" when loading a Word file. |
Bug | SPIREDOC-5503 | Fixes the issue that it failed to obtain the value of "ListText" |
Bug | SPIREDOC-5507 | Fixes the issue that the fields containing the image path were missing after converting XML to PDF. |
Bug | SPIREDOC-5510 | Fixes the issue that the text was messed up after merging multiple files. |
Bug | SPIREDOC-5520 | Fixes the issue that the application threw "DirectoryNotFoundException" when converting Word to PDF using PS method. |
Bug | SPIREDOC-5523 | Fixes the issue that the application threw "System.NullReferenceException" when converting Word to PDF. |
Bug | SPIREDOC-5524 | Fixes the issue that the letter case was inconsistently obtained by "document.GetText();". |
Bug | SPIREDOC-5526 | Fixes the issue that the indentation was incorrect after converting RTF to PDF. |
Bug | SPIREDOC-5530 | Fixes the issue that the application threw "System.ArgumentNullException" when converting HTML to PDF |
Bug | SPIREDOC-5544 | Fixes the issue that the application hung when converting Word to image. |
Bug | SPIREDOC-5572 | Fixes the issue that the application threw "System.DivideByZeroException" when converting Word to PDF. |
Spire.SpreadSheet
Category | ID | Description |
Bug | SPREADSHEET-170 | Fixes the display issue regarding number. |
Bug | SPREADSHEET-174 | Fixes the display issue regarding text. |