New Hotfix for Spire.Office Version 2.11

Spire.Office

With the efforts of our development team, Spire.Office Platinum hotfix 2.11 has been released. This version contains the up-to-date versions of our products, which are Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.PDFViewer, Spire.DocViewer, Spire.DataExport and Spire.Barcode.

Version:

  • Spire.Doc v5.4.2,
  • Spire.PDF v3.2.202,
  • Spire.XLS v7.7.2,
  • Spire.DocViewer v1.8.15,
  • Spire.PDFViewer v2.4.54,
  • Spire.Presentation v2.2.23,
  • Spire.DataExport v3.5.11,
  • Spire.Barcode v1.2.5

To enjoy the latest version, please download it from:

http://www.e-iceblue.com/Download/download-office-for-net-now.html


Details of New features and Bug solutions:

Spire.Doc

New features:

Add a new feature to add "Line Between" in the document column settings.

Section.PageSetup.ColumnsLineBetween = true;

Add a new feature to set the IMG at vertical-align:middle when append HTML string code to .doc.

Paragraph p = doc.Sections[0].AddParagraph();
p.AppendHTML(string);
p.Format.TextAlignment = TextAlignment.Center;

Bug Solutions:

  • Fix the issue that caused the content displayed incorrectly when convert .doc to PDF.
  • Fix the issue where it failed to convert .doc to PDF.
  • Supports the "picprop" keywords when save as RTF document.
  • Fix the issue that caused tab keywords failed to analyze when convert RTF to RTF.
  • Fix the issue that caused the image lost when convert RTF to RTF.
  • Fix the issue where it failed to load some .docx or RTF documents.
  • Fix the issue that caused the negative number was set as positive when mail merged.
  • Fix the issue where the result was not correct when convert some RTF documents to PDF.
  • Fix the issue that caused the garbled contents when convert RTF to html.
  • Fix the issue where some sentences weren't aligned when convert .docx to PDF.
  • Fix the issue that caused incorrect indent when convert RTF to RTF.
  • Fix the issue where some documents couldn't be saved to PDF format.
  • Fix the issue that caused redundant blank line when save to PDF more than one time.
  • Fix the issue that caused some contents dislocation when convert .docx to PDF.
  • Fix the issue where some doc documents can't be saved to .docx document.

Spire.XLS

New features:

Add the following new property to optimize the time needed when load Excel document.

workbook.OptimizeImport=true;

Add new interface to improve the sort time needed when sort large numbers of data.

workbook.DataSorter.SortedWay = SortedWayType.QuickSort; 

Bug Solutions:

  • Fix the issue where the Excel document couldn't be saved when set Pivot Field FormatType as PercentageOfParent.
  • Fix the issue where the CalculateAllValue method didn't work.
  • Fix the issue that caused some excel documents failed to load.
  • Fix the issue where AutoFitColumn method caused the value of some columns displayed incorrectly.
  • Fix the issue where the ExportDataTable method failed to work.
  • Fix the issue that caused incorrect result when convert XLS to PDF.
  • Fix the issue where the color of cell having conditional formatting was converted incorrectly when convert XLS to PDF.
  • Fix the issue that caused date time format incorrect when converted .xls to text.
  • Fix the issue that caused image or text not to show when they were added to footer.
  • Fix the issue where the border was disabled when converted .xls to .xlsx.
  • Fix the issue that caused the size and position of some elements (legend, X-axis) in chart not correct when converted .xls to .xlsx.

Spire.PDF

New Features:

Add the feature to change PDF page size.

PdfDocument pdf = new PdfDocument("Sample.pdf");
PdfDocument newPdf = new PdfDocument();
foreach (PdfPageBase page in pdf.Pages)
{ 
PdfPageBase newPage = newPdf.Pages.Add(PdfPageSize.A1, new PdfMargins(0)); 
PdfTextLayout loLayout= new PdfTextLayout();
loLayout.Layout=PdfLayoutType.OnePage;
page.CreateTemplate().Draw(newPage, new PointF(0, 0),loLayout);
 } 
newPdf.SaveToFile("Result.pdf");

Add the feature to add form fields to an existing PDF.

PdfDocument loDoc= new PdfDocument();
loDoc.LoadFromFile("file.pdf");
if (loDoc.Form== null)
 { 
   loDoc.AllowCreateForm= true;
 }
PdfPageBase loPage= loDoc.Pages[0];
PdfTextBoxField loField=new PdfTextBoxField(lopage,"kkk");
loField.Bouns=new RectangleF(100,100,20,10);
loField.BorderWidth=0.75f;
loField.BorderStyle=PdfBorderStyle.Soild;
loField.Required= true;
loDoc.Form.Fields.Add(loField);
loDoc.SaveToFile("qqq.pdf");

Add new feature to convert PDF to Doc.

PdfDocument doc = new PdfDocument();
doc.LoadFromFile("Sample.pdf");
doc.SaveToFile("PDFtoDoc.doc", FileFormat.DOC);

Bug Solutions:

  • Fix the issue that caused tick in checkbox to be changed to 4 when converted PDF to Image.
  • Fix the issue where some special characters lost when converted PDF to Image.
  • Fix the issue where some special characters lost when printed PDF files.
  • Fix the issue that caused some PDFs war printed as blank.
  • Fix the issue that caused PDF failed to convert to Image.
  • Fix the issue where some XPS documents failed to load.
  • Fix the issue that caused the wrong lineSpacing when converted XPS to PDF.
  • Fix the issue where the Author and Keywords failed to add.
  • Fix the issue where the baseline of characters was not aligned when converted XPS to PDF.

Spire.Presentation

New features:

Add new feature to convert the shape objects in slide to image.

Presentation.Slides[index].Shapes.SaveAsImage(int shapeIndex);
Presentation.Slides[index].Shapes.SavaAsEMF(int shapeIndex, string filePath);

Add new override method to set whether the media object is embedded or not when append media.

public IAudio AppendAudioMedia(string filePath, RectangleF rectangle, bool isEmbed);
public IAudio AppendAudioMedia(string filePath, float X, float Y, bool isEmbed);

Bug Solution:

  • Fix the issue where the title of secondary axis was unable to set when create new secondary axis.

Spire.PDFViewer

Bug solution:

  • Fix the issue that caused contents of some PDF documents to garble.