We are happy to announce the release of Spire.Office 8.3.2. In this version, Spire.PDF supports embedding fonts into PDF documents and “Show/Hide Fields” action; Spire.XLS supports ISOWEEKNUM, CEILING.PRECISE, and ENCODEURL formula and replacing font; Spire.Spreadsheet supports the zoom function; Spire.Email supports OAuth2 authentication. In addition, a lot of known issues are fixed successfully in this version. 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 v11.3.2
- Spire.Pdf.dll v9.3.4
- Spire.XLS.dll v13.3.2
- Spire.Presentation.dll v8.2.0
- Spire.Email.dll v6.3.1
- Spire.DocViewer.Forms.dll v8.3.0
- Spire.PdfViewer.Forms.dll v7.10.0
- Spire.PdfViewer.Asp.dll v7.10.0
- Spire.Spreadsheet.dll v7.2.0
- Spire.OfficeViewer.Forms.dll v8.3.2
- Spire.Barcode.dll v7.2.1
- Spire.DataExport.dll v4.8.0
- Spire.DataExport.ResourceMgr.dll v2.1.0
Click the link to get the version Spire.Office 8.3.2:
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-3933 | Supports embedding fonts into PDF documents.
PdEmbeddedFontConverter converter = new PdEmbeddedFontConverter ("InputFile");
convert.ToEmbeddedFontPdf("resultFile");
|
| New feature | SPIREPDF-5396 | Supports creating "show/hide a field" action.
PdfDocument pdf = new PdfDocument(inputFile);
pdf.LoadFromFile(inputFile);
for (int c = 0; c < pdf.Pages.Count; c++)
{
PdfFormWidget formWidget = pdf.Form as PdfFormWidget;
for (int i = 0; i < formWidget.FieldsWidget.List.Count; i++)
{
PdfField field = formWidget.FieldsWidget.List[i] as PdfField;
if (field is PdfButtonWidgetFieldWidget)
{
PdfButtonWidgetFieldWidget buttonWidget = field as PdfButtonWidgetFieldWidget;
PdfHideAction hideAction = new PdfHideAction(buttonWidget.Name, true);
buttonWidget.MouseDown = hideAction;
}
}
}
pdf.SaveToFile(outputFile);
pdf.Dispose();
|
| New feature | SPIREPDF-5769 | Optimizes the compression function.
PdfCompressor compressor = new PdfCompressor("1.pdf");
compressor.Options.TextCompressionOptions.UnembedFonts = true;
compressor.Options.ImageCompressionOptions.CompressImage = true;
compressor.Options.ImageCompressionOptions.ResizeImages = true;
compressor.Options.ImageCompressionOptions.ImageQuality = ImageQuality.Low;
compressor.CompressToFile("1_out.pdf");
|
| Bug | SPIREPDF-5436 SPIREPDF-5743 | Fixes the issue that converting PDF to Word resulted in incorrect content. |
| Bug | SPIREPDF-5519 | Fixes the issue that garbled text and boxes appeared when converting OFD to PDF. |
| Bug | SPIREPDF-5702 | Fixes the issue that the created encrypted documents could not be opened on Android mobile devices with Adobe Reader after entering the correct password. |
| Bug | SPIREPDF-5730 | Fixes the issue that single selection buttons lost the "default option" function after merging PDF documents. |
| Bug | SPIREPDF-5738 | Fixes the issue that highlighted text was obstructed after converting to an image. |
| Bug | SPIREPDF-5749 | Fixes the issue that the content was incorrect after converting PDF to images. |
| Bug | SPIREPDF-5761 | Fixes the issue that content was incorrect after converting XPS to PDF. |
| Bug | SPIREPDF-5766 | Fixes the issue that background color changed after converting PDF to images. |
| Bug | SPIREPDF-5788 | Fixes the issue that red seal turned blue after drawing a PDF page as a template onto a new document. |
| Bug | SPIREPDF-5790 | Fixes the issue that merging PDFs threw an exception "System.ArgumentOutOfRangeException". |
| Bug | SPIREPDF-5797 | Fixes the issue that lines were missing after converting PDF to XPS. |
| Bug | SPIREPDF-5798 | Fixes the issue that content was lost after converting PDF to Word. |
| Bug | SPIREPDF-5805 | Fixes the issue that converting PDF to SVG threw an exception "System.ArgumentException: 'Parameter is not valid'". |
| Bug | SPIREPDF-5809 | Fixes the issue that converting OFD to PDF threw an exception "System.IO.FileNotFoundException". |
Spire.XLS
| Category | ID | Description |
| New feature | SPIREXLS-4396 | Supports the ISOWEEKNUM formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "ISOWEEKNUM(DATE(2012,1,1))";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx");
|
| New feature | SPIREXLS-4404 | Supports the CEILING.PRECISE formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "CEILING.PRECISE(-4.6,3)";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx");
|
| New feature | SPIREXLS-4455 | Supports the ENCODEURL formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "ENCODEURL(\"https://www.e-iceblue.com\")";
workbook.CalculateAllValue();
workbook.SaveToFile("result.xlsx");
|
| New feature | SPIREXLS-4460 | Supports replacing one font with another in a worksheet.
sheet.ReplaceAll(oldValue, oldStyle, newValue, newStyle) |
| Bug | SPIREXLS-686 SPIREXLS-4431 |
Fixes the issue that the content was incorrect after converting Excel file to image. |
| Bug | SPIREXLS-3804 | Fixes the issue that the background color was lost after converting Excel file to image. |
| Bug | SPIREXLS-4259 | Fixes the issue that it obtained null value when using DisplayedText() to get text from the hidden cell range. |
| Bug | SPIREXLS-4406 | Fixes the issue that the cell values did not refresh after opening the saved file in MS Excel. |
| Bug | SPIREXLS-4414 | Fixes the issue that the location of the added TextBox was incorrect. |
| Bug | SPIREXLS-4428 | Fixes the issue that the result was incorrect after deleting cell range with the DeleteOption.MoveLeft parameter. |
| Bug | SPIREXLS-4446 | Fixes the issue that the application threw "Parameter is not valid" when deploying the application on Azure to replace Excel file image. |
| Bug | SPIREXLS-4466 | Fixes the issue that the content format was incorrect after inserting rows. |
| Bug | SPIREXLS-4468 | Fixes the issue that the cell value had extra space after converting a .txt file to Excel file. |
| Bug | SPIREXLS-4476 | Fixes the issue that the content was incorrect after converting Excel file to PDF. |
| Bug | SPIREXLS-4484 | Fixes the issue that the link was invalid after converting Excel file to HTML. |
| Bug | SPIREXLS-4504 | Fixes the issue that only one setting was valid when setting LastColumn and LastRow at the same time. |
Spire.Doc
| Category | ID | Description |
| Bug | SPIREDOC-5109 SPIREDOC-5440 |
Fixed the issue that the underline format was incorrect when converting Word to PDF. |
| Bug | SPIREDOC-8575 | Fixed the issue that the table of contents field failed to update. |
| Bug | SPIREDOC-8904 | Fixed the issue that the program threw System.NullReferenceException exception when setting a value with carriage return symbols to form fields. |
| Bug | SPIREDOC-8971 | Fixed the issue that the content was flipped when converting Word to PDF. |
| Bug | SPIREDOC-9087 | Fixed the issue that the program threw System.NullReferenceException when saving Word documents. |
Spire.Email
| Category | ID | Description |
| New feature | SPIREEMAIL-67 | Supports OAuth2 authentication. |
| Bug | SPIREEMAIL-51 | Fixes the issue that it failed to connect to QQ email. |
| Bug | SPIREEMAIL-60 | Fixes the issue that the program threw "004 NO SELECT State" error when reading the inbox of 163 email. |
| Bug | SPIREEMAIL-62 | Fixes the issue that the program threw "Unable to read data from the transport connection" error when sending emails. |
Spire.DocViewer
| Category | ID | Description |
| Bug | SPIREDOCVIEWER-98 | Fixes the issue that some images were not displayed. |
| Bug | SPIREDOCVIEWER-99 | Fixes the issue that Chinese text display failed. |
Spire.Spreadsheet
| Category | ID | Description |
| New feature | - | Supports the zoom function. |
