News & Releases
|
Spire.Office 6.9.1 is released
Spire.Office 6.9.1 is released. This version brings some new features, for instance, Spire.Presentation supports adding math equations and checking whether shape contains math equations., hiding the audio clip icon during the slide show, checking whether the PPT file is encrypted as well as converting PPT to OFD; Spire PDFViewer supports rotating pages as well as finding and highlighting text; Spire.Doc supports setting frame positions; Spire.XLS supports converting Excel to UOS and converting Excel to OFD. 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.9.6
- Spire.Pdf.dll v7.9.3
- Spire.XLS.dll v11.9.3
- Spire.Email.dll v4.7.0
- Spire.DocViewer.Forms.dll v6.8.0
- Spire.PdfViewer.Forms.dll v6.9.1
- Spire.PdfViewer.Asp.dll v6.9.1
- Spire.Presentation.dll v6.9.2
- Spire.Spreadsheet v5.6.1
- Spire.OfficeViewer.Forms.dll v6.9.1
- Spire.Barcode.dll v5.7.1
- Spire.DataExport.dll v4.1.9
- Spire.DataExport.ResourceMgr.dll v2.1.0
- Spire.License.dll v1.4.0
Here is a list of changes made in this release
Spire.Presentation
Category | ID | Description |
New feature | SPIREPPT-1439 | Supports adding math equations and checking whether shape contains math equations.
Presentation ppt = new Presentation(); string latexMathCode = @"x^{2}+\sqrt{x^{2}+1}=2"; IAutoShape shape = ppt.Slides[0].Shapes.AppendShape(ShapeType.Rectangle, new RectangleF(30, 100, 400, 30)); shape.TextFrame.Paragraphs.Clear(); //Add math equation TextParagraph tp = shape.TextFrame.Paragraphs.AddParagraphFromLatexMathCode(latexMathCode); for (int i = 0; i < ppt.Slides[0].Shapes.Count; i++) { if (ppt.Slides[0].Shapes[i] is IAutoShape) { //Check whether shape contains math equations bool containMathEquation = (ppt.Slides[0].Shapes[i] as IAutoShape).ContainMathEquation; } } ppt.SaveToFile("result.pptx", FileFormat.Pptx2013); ppt.Dispose(); |
New feature | SPIREPPT-1660 | Supports hiding audio clip icons during the slide shows.
Presentation ppt = new Presentation(); ppt.LoadFromFile(inputFile); foreach(Shape shape in ppt.Slides[0].Shapes) { if(shape is IAudio) { IAudio audio = shape as IAudio; audio.HideAtShowing = true; } } |
New feature | SPIREPPT-1662 | Supports converting PPT to OFD.
Presentation ppt = new Presentation(); ppt.LoadFromFile(inputFile); ppt.SaveToFile(ofdFile, FileFormat.OFD); |
New feature | SPIREPPT-1674 | Supports checking whether the PPT file is encrypted.
Presentation ppt = new Presentation(); ppt.IsPasswordProtected(inputFile) |
Bug | SPIREPPT-1657 | Fixes the issue that the trendline label was not initialized after adding trendlines to the chart. |
Bug | SPIREPPT-1658 | Fixes the issue that it did not highlight the matched text. |
Bug | SPIREPPT-1661 | Fixes the issue that the hyperlink was missing after converting PPT to PDF. |
Bug | SPIREPPT-1665 | Fixes the issue that the existing video could not be played after adding audio to the PPT file. |
Bug | SPIREPPT-1671 | Fixes the issue that setting the slice angle for doughnut chart did not take effect. |
Bug | SPIREPPT-1673 | Fixes the issue that the application threw the error "DocumentReadException" when loading an encrypted PPT file. |
Spire.PDFViewer
Category | ID | Description |
New feature | SPIREPDFVIEWER-514 | The ASP.NET control supports rotating pages.
input type=button id=PdfDocumentViewer1_btnRotate onfocus=this.blur() onclick=pdfdocumentviewer1.Rotate(pdfdocumentviewer1.RotateAngle + 270); value=rotate_270 |
New feature | SPIREPDFVIEWER-515 | The ASP.NET control supports finding and highlighting text.
input type=text id=PdfDocumentViewer1_txtFindText onkeydown=if(event.keyCode==13){pdfdocumentviewer1.SearchText(this.value,true);return false;} value= protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.PdfDocumentViewer1.FindTextHighLightColor = System.Drawing.Color.FromArgb(125, 255, 0, 0); this.PdfDocumentViewer1.LoadFromFile(input.pdf); } } |
Bug | SPIREPDFVIEWER-369 SPIREPDFVIEWER-433 SPIREPDFVIEWER-508 |
Fixes the issue that the display content of the PDF was incorrect. |
Bug | SPIREPDFVIEWER-491 | Fixes the issue that Chinese characters in PDF file were displayed incorrectly. |
Bug | SPIREPDFVIEWER-504 | Fixes the issue that the ASP.NET control poped up an error message when no PDF file was loaded. |
Bug | SPIREPDFVIEWER-506 | Fixes the issue that the image covered the text content. |
Bug | SPIREPDFVIEWER-513 | Fixes the issue that the display content of the PDF was blurred. |
Spire.PDF
Category | ID | Description |
Bug | SPIREPDF-1165 SPIREPDF-1246 |
Fixes the issue that the application threw the error "System.ArgumentException" when converting PDF to images. |
Bug | SPIREPDF-3006 | Fixes the issue that the printout was incorrect after printing the PDF file. |
Bug | SPIREPDF-4558 | Fixes the issue that the application threw the error "System.FormatException" when converting PDF to images. |
Bug | SPIREPDF-4560 | Fixes the issue that the application threw the error "Value cannot be null" when setting image for a button field. |
Bug | SPIREPDF-4563 | Fixes the issue that the application threw the error "Unexpected token Eof before 986932" when loading PDF files. |
Bug | SPIREPDF-4569 | Fixes the issue that the application threw the error "OutOfMemoryException" when loading the merged file after merging files. |
Bug | SPIREPDF-4572 | Fixes the issue that the application threw the error "System.OverflowException" whe converting PDF to images. |
Spire.XLS
Category | ID | Description |
New feature | - | Supports converting Excel to UOS.
Workbook workbook = new Workbook(); workbook.LoadFromFile(xlsxFile); workbook.SaveToFile(uosFile, FileFormat.UOS); |
New feature | - | Supports converting Excel to OFD
Workbook workbook = new Workbook(); workbook.LoadFromFile(xlsxFile); workbook.SaveToFile(ofdFile, FileFormat.OFD); |
New feature | SPIREXLS-3348 | Setting the "Values" field generated by the pivot table in Excel as a row label.
pivottable.ShowDataFieldInRow = true; pivottable.CalculateData(); |
New feature | SPIREXLS-3392 | Supports converting group pictures/charts into an image.
List images = sheet.SaveShapesToImage(new SaveShapeTypeOption()); for (int i = 0; i < images.Count; i++) { images[i].Save(string.Format(outputFile + "{0}.png", i), ImageFormat.Png); } |
Bug | SPIREXLS-3337 | Fixes the issue that the content in the chart was incorrect after converting Excel to SVG files or images. |
Bug | SPIREXLS-3335 | Fixes the issue that the generated image was incomplete after converting Excel to SVG files. |
Bug | SPIREXLS-3343 | Optimizes the content layout of converting HTML to Excel. |
Bug | SPIREXLS-3344 | Fixes the issue that the generated image was incorrect after converting charts in Excel to images. |
Bug | SPIREXLS-3359 | Fixes the issue that the generated image was incorrect after converting charts in Excel to images. |
Bug | SPIREXLS-3361 | Fixes the issue that the program threw an exception when converting Excel to EMF streams. |
Bug | SPIREXLS-3366 | Fixes the issue that the IsPasswordProtected() method only returned "true" after converting .XLSX files to .XLS formats. |
Bug | SPIREXLS-3367 | Fixes the issue that the program threw an exception when using the CalculateAllValue() method. |
Bug | SPIREXLS-3374 | Fixes the issue that the vertical page breaks in the generated file was incorrect after converting Excel to PDF. |
Bug | SPIREXLS-3377 | Fixes the issue that the fonts used in the generated file was different with the original file after converting Excel to PDF. |
Bug | SPIREXLS-3378 | Fixes the issue that the program threw an exception when getting the data range of the chart in Excel files. |
Bug | SPIREXLS-3380 | Fixes the issue that the filter of the pivot table in Excel did not take effect after changing it. |
Bug | SPIREXLS-3387 | Fixes the issue that the program threw an exception when converting Excel to PDF. |
Spire.Doc
Category | ID | Description |
New feature | SPIREDOC-5818 | Supports setting frame positions. |
Bug | SPIREDOC-5441 SPIREDOC-6168 SPIREDOC-6499 SPIREDOC-6596 |
Fixes the issue that the program threw an exception when converting Word to PDF. |
Bug | SPIREDOC-5775 | Fixes the issue that the mail merge area was empty in the generated file after mail merging using the string that contains ""in Word. |
Bug | SPIREDOC-5870 SPIREDOC-6381 SPIREDOC-6446 SPIREDOC-6447 SPIREDOC-6547 SPIREDOC-6549 SPIREDOC-6550 SPIREDOC-6554 |
Fixes the issue that the content and format was incorrect in the generated file after converting Word to PDF. |
Bug | SPIREDOC-6312 | Fixes the issue that the borders of the table disappeared after inserting TOC to Word. |
Bug | SPIREDOC-6451 | Fixes the issue that the content of the result file was overlapped after printing Word. |
Bug | SPIREDOC-6505 | Fixes the issue that the merged result was incorrect after mail merging Word. |
Bug | SPIREDOC-6515 | Fixes the issue that the program threw an exception when combining Word files. |
Bug | SPIREDOC-6580 | Fixes the issue that the program threw an exception when converting RTF to Word. |
Bug | SPIREDOC-6615 | Fixes the issue that the image quality was lower in the generated file after converting Word to PDF using the PS mode method. |
Bug | SPIREDOC-6642 | Fixes the issue that the program threw an exception when loading Word. |