Spire.Office 6.11.2 is released

2021-11-26 01:49:50

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