We are excited to announce the release of Spire.Office 6.11.2. This version brings some new features, for example, Spire.XLS supports to set drop lines for line chart and area chart; Spire.Doc adds two new method; Spire.PDF supports converting PDF to linearized PDF; Spire.Presentation supports getting the display color of the table cell border. Meanwhile, a lot of bugs have been successfully fixed. More details are listed as follow.
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.11.6
- Spire.Pdf.dll v7.11.1
- Spire.XLS.dll v11.11.2.
- Spire.Email.dll v4.11.1
- Spire.DocViewer.Forms.dll v6.8.0
- Spire.PdfViewer.Forms.dll v6.11.1
- Spire.PdfViewer.Asp.dll v6.11.1
- Spire.Presentation.dll v6.11.4
- Spire.Spreadsheet v5.10.0
- Spire.OfficeViewer.Forms.dll v6.11.2
- Spire.Barcode.dll v5.9.4
- Spire.DataExport.dll v4.1.9
- Spire.DataExport.ResourceMgr.dll v2.1.0
- Spire.License.dll v1.4.0
Click the link to get the version Spire.Office 6.11.2
More information of Spire.Office new release or hotfix:
Here is a list of changes made in this release
Spire.XLS
Category | ID | Description |
New feature | SPIREXLS-1805 | Supports to set border for data bar of chart.
XlsConditionalFormats cfs = sheet.ConditionalFormats[0]; IConditionalFormat cf = cfs[0]; Spire.Xls.DataBar dataBar1 = cf.DataBar; dataBar1.BarBorder.Type = Spire.Xls.Core.Spreadsheet.ConditionalFormatting.DataBarBorderType.DataBarBorderSolid; dataBar1.BarBorder.Color = Color.GreenYellow; |
New feature | SPIREXLS-3453 | Supports to set drop lines for line chart and area chart.
chart.Series[0].HasDroplines = true; |
New feature | SPIREXLS-3487 | Supports to set the customized page size when converting an excel file to pdf.
workbook.Worksheets[0].PageSetup.SetCustomPaperSize(width, height); |
Bug | SPIREXLS-2906 | Fixes the issue that the location of picture was incorrect when converting an excel file to html |
Bug | SPIREXLS-3456 | Fixes the issue that the content was clipped when converting an excel file to pdf file |
Bug | SPIREXLS-3461 | Fixes the issue that the content was incorrect when converting a combination chart to image |
Bug | SPIREXLS-3515 | Fixes the issue that the application hung when loading an ods file |
Bug | SPIREXLS-3516 | Fixes the issue that the content was incorrect when converting an excel file to pdf |
Bug | SPIREXLS-3542 | Fixes the issue that MS Excel failed to open the saved xlsx file |
Spire.PDF
Category | ID | Description |
New feature | SPIREPDF-4594 | Supports getting the page number of the attachment.
int page = pdf.Attachments.GetAttachmentPage("attachmentFileName"); |
New feature | - | Supports converting PDF to linearized PDF.
PdfToLinearizedPdfConverter converter = new PdfToLinearizedPdfConverter("inputFile"); converter.ToLinearizedPdf("outputFile"); |
Bug | SPIREPDF-2356 | Fixes the issue that the content was incorrect after converting PDF to Word. |
Bug | SPIREPDF-4311 | Optimizes the time for converting PDF to images. |
Bug | SPIREPDF-4587 | Fixes the issue that an error prompted when opening the result file after compressing the PDF file. |
Bug | SPIREPDF-4609 | Fixes the issue that some digital signatures were missing after merging PDF files. |
Bug | SPIREPDF-4622 | Fixes the issue that it didn't get the correct name of the used font. |
Bug | SPIREPDF-4637 | Fixes the issue that the barcodes were incorrect after converting PDF to images. |
Bug | SPIREPDF-4660 | Optimizes the memory consumption for converting PDF to PDFA. |
Bug | SPIREPDF-4701 | Fixes the issue that the application threw the error "Header checksum illegal" when loading the PDF file. |
Bug | SPIREPDF-4703 | Fixes the issue that the extracted content was incomplete. |
Bug | SPIREPDF-4721 | Fixes the issue that the font size of the inserted checkbox field was incorrect. |
Bug | SPIREPDF-4736 SPIREPDF-4727 |
Optimizes the time for adding watermarks. |
Bug | SPIREPDF-4731 | Fixes the issue that setting line width for the PdfPolyLineAnnotation did not take effect. |
Bug | SPIREPDF-4732 | Fixes the issue that the content extracted from PDF tables was incorrect. |
Bug | SPIREPDF-4739 | Fixes the issue that the content extracted from the specified rectangular area was incorrect. |
Bug | SPIREPDF-4745 | Fixes the issue that the application threw the error "Object reference not set to an instance of an object" when converting PDF to images. |
Spire.Doc
Category | ID | Description |
New feature | - | Adds a new method "SetColumnWidth" to set table column width.
table.SetColumnWidth(int columnIndex, float columnWidth, CellWidthType columnWidthType); |
New feature | - | Adds a new method "UseNewEngine" to use new engine to convert Word to PDF.
Document doc = new Document(); doc.LoadFromFile("input.docx"); doc.UseNewEngine = true; doc.SaveToFile("result.pdf", FileFormat.PDF); |
Adjustment | - | Adjusts the method of setting table cell width.
//Old method //tableCell.Width //Deprecated //tableCell.CellWidthType //Deprecated //New method tableCell.SetCellWidth(float width, CellWidthType widthType); |
Spire.Presentation
Category | ID | Description |
New feature | SPIREPPT-1687 | Supports getting the fill color of table cells.
table.TableRows[i][j].DisplayColor; |
New feature | SPIREPPT-1701 | Supports setting the data label range for charts.
Presentation ppt = new Presentation(); IChart chart = ppt.Slides[0].Shapes.AppendChart(ChartType.ColumnStacked, new RectangleF(100, 100, 500, 400)); CellRange cellRange = chart.ChartData["F1"]; cellRange.Text = "aaa"; cellRange = chart.ChartData["F2"]; cellRange.Text = "bbb"; cellRange = chart.ChartData["F3"]; cellRange.Text = "ccc"; cellRange = chart.ChartData["F4"]; cellRange.Text = "ddd"; chart.Series[0].DataLabelRanges = chart.ChartData["F1", "F4"]; ChartDataLabel dataLabel1 = chart.Series[0].DataLabels.Add(); dataLabel1.ID = 0; dataLabel1.LabelValueVisible = true; dataLabel1.ShowDataLabelsRange = true; |
New feature | SPIREPPT-1707 | Supports to get the path data of the custom animation.
foreach (AnimationEffect effect in shape.Slide.Timeline.MainSequence) { if (effect.ShapeTarget.Equals(shape as Spire.Presentation.Shape)) { MotionPath path = ((AnimationMotion)effect.CommonBehaviorCollection[0]).Path; foreach (MotionCmdPath motionCmdPath in path) { PointF[] points = motionCmdPath.Points; MotionCommandPathType type = motionCmdPath.CommandType; } } } |
New feature | SPIREPPT-1708 | Adds a new method "IShape.SaveAsImage()" to convert shape to images.
Image image = shape.SaveAsImage(); |
New feature | SPIREPPT-1744 | Supports getting the display color of the table cell border.
table[0, 0].BorderLeftDisplayColor; table[0, 0].BorderTopDisplayColor; table[0, 0].BorderRightDisplayColor; table[0, 0].BorderBottomDisplayColor; |
Bug | SPIREPPT-1453 | Fixes the issue that the newly inserted shape did not have default line width and color. |
Bug | SPIREPPT-1667 | Fixes the issue that the images were not clear enough after converting PPT to images. |
Bug | SPIREPPT-1699 | Fixes the issue that it couldn't get the background color of the theme. |
Bug | SPIREPPT-1709 | Fixes the issue that the content was incorrect after converting shape to image. |
Bug | SPIREPPT-1717 | Fixes the issue that it didn't get the correct display color of the TextRange. |
Bug | SPIREPPT-1731 | Fixes the issue that the inserted clustered column chart was incorrect. |
Bug | SPIREPPT-1723 | Fixes the issue that the image converted from PowerPoint formula was blurred |
Bug | SPIREPPT-1732 | Fixes the issue that the symbol lost when converting PowerPoint to PDF |
Bug | SPIREPPT-1738 | Fixes the issue that the obtained font size of the text was incorrect |
Bug | SPIREPPT-1739 | Fixes the issue that the application threw "Spire.Presentation.AppException" when loading a PPT file. |
Bug | SPIREPPT-1743 | Fixes the issue that the application threw "System.NullReferenceException" when replacing text |
Bug | SPIREPPT-1751 | Fixes the issue that the application threw "System.ArgumentException" when converting group shpes to image |
Spire.Email
Category | ID | Description |
Bug | SPIREEMAIL-48 | Fixes the issue that the addresser was incorrect when saving the email extracted from a PST file to eml format |