We're excited to announce the release of Spire.Office 9.5.0. In this version, Spire.Doc supports converting Word to PDF while retaining form fields, Spire.XLS supports finding cells based on regular expressions, Spire.Presentation supports setting spacing between two columns. Meanwhile, tons of known issues 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, and Spire.Barcode are included.
DLL Versions:
- Spire.Doc.dll v12.5.5.0
- Spire.Pdf.dll v10.5.5.0
- Spire.XLS.dll v14.5.3.0
- Spire.Presentation.dll v9.5.3.0
- Spire.Barcode.dll v7.2.9.0
- Spire.Email.dll v6.5.10.0
- Spire.DocViewer.Forms.dll v8.7.10.0
- Spire.PdfViewer.Asp.dll v7.12.14.0
- Spire.PdfViewer.Forms.dll v7.12.14.0
- Spire.Spreadsheet.dll v7.4.6.0
- Spire.OfficeViewer.Forms.dll v8.7.12.0
- Spire.DataExport.dll 4.9.0.0
- Spire.DataExport.ResourceMgr.dll v2.1.0
Click the link to get the version Spire.Office 9.5.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 preserving FormField (CheckBox, DropDown, TextFormField) and SDT (CheckBox, Text, RichText, DropDownList, ComboBox) data when converting Word to PDF.
ToPdfParameterList.PreserveFormFields = true; |
| New feature | - | Supports setting three display modes for comments (Hide, ShowInBalloons, ShowInAnnotations) when converting Word to PDF.
Document.LayoutOptions.CommentDisplayMode = CommentDisplayMode.ShowInAnnotations; |
| Bug | SPIREDOC-10152 | Fixes the issue that the table widths and fonts are not correct when converting HTML to Word. |
| Bug | SPIREDOC-10363 | Fixes the issue that the program threw "ArgumentOutOfRangeException" when loading Word documents. |
| Bug | SPIREDOC-10371 | Fixes the issue that headings were missing after converting Word to HTML. |
| Bug | SPIREDOC-10376 | Fixes the issue that table borders were missing after converting Word to HTML. |
| Bug | SPIREDOC-10402 | Fixes the issue that tables were missing when converting Word to HTML. |
| Bug | SPIREDOC-10421 | Fixes the issue that the program threw "InvalidCastException" exception when comparing Word documents. |
| Bug | SPIREDOC-10427 | Fixes the issue that the header was lost after adding a watermark to Word and saving it to PDF. |
Spire.PDF
| Category | ID | Description |
| Bug | SPIREPDF-6045 | Fixes the issue that the content was blurred when printing PDFs. |
| Bug | SPIREPDF-6529 | Fixes the issue that the content was lost after replacing text. |
| Bug | SPIREPDF-6654 | Fixes the issue that specific Chinese characters could not be drawn successfully. |
| Bug | SPIREPDF-6655 | Fixes the issue that the background turned black after converting PDF to pictures. |
| Bug | SPIREPDF-6657 | Fixes the issue that the standard validation failed after converting PDF to PDFA3A. |
| Bug | SPIREPDF-6658 | Fixes the issue that some pages became blank after converting PDF to XPS and then converting it to PDF. |
| Bug | SPIREPDF-6681 | Fixes the issue that the program threw System.NullReferenceException when converting OFD to PDF. |
| Bug | SPIREPDF-6687 | Fixes the issue that the added signature was not visible in the signature menu bar on the left side. |
| Bug | SPIREPDF-6697 | Fixes the issue that the content formatting was not correct after converting PDF to PowerPoint. |
| Bug | SPIREPDF-6701 | Fixes the issue that the background color was incorrect after converting XPS to SVG. |
| Bug | SPIREPDF-6707 | Fixes the issue that text replacement was incorrect. |
| Bug | SPIREPDF-6714 | Fixes the issue that the content was lost after converting OFD to PDF. |
| Bug | SPIREPDF-6715 | Fixes the issue that replacing text that crosses lines was incorrect. |
| Bug | SPIREPDF-6727 | Fixes the issue that the program threw FileNotFoundException when converting OFD to PDF. |
| Bug | SPIREPDF-6733 | Fixes the issue that the program threw InvalidOperationException when converting PDF to OFD in multiple threads. |
| Bug | SPIREPDF-6734 | Fixes the issue that the color of stamps was not correct after converting OFD to PDF. |
| Bug | SPIREPDF-6735 | Fixes the issue that replacing Chinese characters did not succeed. |
Spire.XLS
| Category | ID | Description |
| New feature | SPIREXLS-5128 | Supports adding images to the first page header and footer.
//Load image System.Drawing.Image bufferedImage = System.Drawing.Image.FromFile(inputFile_Img); //Set image on first page header and footer wb.Worksheets[0].PageSetup.FirstLeftHeaderImage = bufferedImage; wb.Worksheets[0].PageSetup.FirstLeftFooterImage = bufferedImage; wb.Worksheets[1].PageSetup.FirstCenterHeaderImage = bufferedImage; wb.Worksheets[1].PageSetup.FirstCenterFooterImage = bufferedImage; wb.Worksheets[2].PageSetup.FirstRightHeaderImage = bufferedImage; wb.Worksheets[2].PageSetup.FirstRightFooterImage = bufferedImage; |
| New feature | SPIREXLS-5195 | Supports obtaining active selection range.
Worksheet worksheet = workbook.Worksheets[0];
string Information = null;
foreach (CellRange range in worksheet.ActiveSelectionRange)
{
Information += "RangeAddressLocal:"+ range.RangeAddressLocal+"\r\n";
Information += "ColumnCount:" + range.ColumnCount + "\r\n";
Information += "ColumnWidth:" + range.ColumnWidth + "\r\n";
Information += "Column:" + range.Column + "\r\n";
Information += "RowCount:" + range.RowCount+ "\r\n";
Information += "RowHeight:" + range.RowHeight + "\r\n";
Information += "Row:" + range.Row + "\r\n";
}
File.WriteAllText(outputFile_TXT,Information);
|
| New feature | SPIREXLS-5200 | Supports finding cells based on regular expressions.
CellRange[] ranges = sheet.FindAllString(".*test.", false, false, true);
|
| Bug | SPIREXLS-5075 | Fixes the issue that the image was lost after converting Excel to image. |
| Bug | SPIREXLS-5151 | Fixes the issue that the content in the generated PDF document was lost after converting Excel to PDF on the Kirin system. |
| Bug | SPIREXLS-5186 | Fixes the issue that the application threw the "System.NullPointerException" when converting sheet to image. |
| Bug | SPIREXLS-5197 | Fixes the issue that the border obtained from merged area was incorrect. |
| Bug | SPIREXLS-5198 | Fixes the issue that the text and alternative text obtained from checkboxes were incorrect. |
| Bug | SPIREXLS-5214 | Fixes the issue that it failed to set the active cell using the SetActiveCell() method. |
| Bug | SPIREXLS-5216 | Fixes the issue that the textboxes added to charts were not displayed. |
| Bug | SPIREXLS-5218 | Fixes the issue that the name obtained from checkbox was incorrect. |
| Bug | SPIREXLS-5225 | Fixes the issue that the mouse cursor position was incorrect after importing data into Excel using the InsertDataTable() method. |
| Bug | SPIREXLS-5228 | Fixes the issue that some graphics and lines were lost after converting Excel document to PDF document. |
| Bug | SPIREXLS-5234 | Fixes the issue that it failed to autofit columns using the AutoFitCoumns() method. |
Spire.Presentation
| Category | ID | Description |
| New feature | SPIREPPT-2497 | Adds the ColumnSpacing property to set the spacing between columns.
//The unit is point shape.TextFrame.ColumnSpacing = 20.50f; |
| Bug | SPIREPPT-2493 | Fixes the issue that the application threw the "System.ArgumentException" when appending images to presentations. |
| Bug | SPIREPPT-2498 | Fixes the issue that the shape was in opposite direction after converting PPTX to SVG. |
| Bug | SPIREPPT-2500 | Fixes the issue that the gradient color of the shape was incorrect after converting PPTX to SVG. |
