New release version for Spire.Office 2.15

Spire.Office

With the effort of our development team, today we have released the latest version for Spire.Office Platinum version 2.15. In this version, the recent releases of Spire.Doc, Spire.PDF, Spire.XLS, Spire.DocViewer, Spire.PDFViewer, Spire.Presentation, Spire.DataExport, Spire.Barcode, Spire.Spreadsheet and Spire.OfficeViewer all have been included. Spire.OfficeViewer is our newly added product to display and view office and PDF document files from code.

Versions:

  • Spire.Barcode.dll 1.2.10
  • Spire.DataExport.dll 3.5.133
  • Spire.Doc.dll 5.8.12
  • Spire.DocViewer.Forms.dll 2.3.1
  • Spire.Pdf.dll 3.8.52
  • Spire.PdfViewer.Forms.dll 2.11.1
  • Spire.Presentation.dll 2.7.6
  • Spire.XLS.dll 7.11.11
  • Spire.Spreadsheet.dll 2.2.1
  • Spire.OfficeViewer.Forms.dll 2.15.1

Get the most recent version of Spire.Office v2.15 here:

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


Details of New features and Bug solutions:

Spire.Doc

New features:

  • Supports to convert word file to SVG.
  • document.SaveToFile("result.svg", FileFormat.SVG);
    
  • Support to embed private font when save .docx format file.
  • document.EmbedFontsInFile = true;
    document.PrivateFontList.Add(new PrivateFontPath("Open Sans",fontPath));
    document.SaveToFile("result.docx",FileFormat.Docx);
    
  • Public the collection of Fields on the Document object.

Bug solutions:

  • Fixes the issue that caused the font incorrect when save to Html via stream.
  • Optimize the feature on Word to PDF conversion.
  • Fixes the issue that caused content missing when convert to image.
  • Fixes the issue that caused incorrect data when extract audio OLE object data.
  • Fixes the issue that caused incorrect result when convert to PDF.
  • Fixes the issue that caused project hanging when convert to PDF.
  • Fixes the issue that caused the INCLUDETEXT field lost when convert RTF to PDF.
  • Fixes the issue that caused the wrong result when print document.
  • Fixes the issue that caused the style wrong when convert HTML to Word.
  • Resolves the issue that caused the NullReferenceException exception when extract text.

Spire.PDF

New Features:

  • Adds new method to convert XPS to pdf/A1-B.
  • PdfDocument pdf = new PdfDocument(PdfConformanceLevle.Pdf_A1B);
    pdf.LoadFromXPS("test.xps");
    pdf.SaveToFile("result.pdf");
    
  • Supports to set the Asia character in signature area.
  • System.Collections.Generic.Dictionary fonts = new System.Collections.Generic.Dictionary();
    fonts.Add(SignInfoType.SignInformation,new PdfCjkStandardFont(PdfCjkFontFamily.SinoTypeSongLight,12));
    signature.SignInfoFont = fonts;
    
  • Adds new feature to convert PDF to SVG.
  • document.SaveToFile("Result.svg", FileFormat.SVG);
    
  • Adds new method to set the image of button field.
  • if (form.FieldsWidget[i] is PdfButtonWidgetFieldWidget)
     {
     PdfButtonWidgetFieldWidget field = form.FieldsWidget[i] as PdfButtonWidgetFieldWidget;
     if (field.Name == "Field Name")
    { field.SetButtonImage(PdfImage.FromFile(imagePath)); } 
    }
    

Bug Solutions:

  • Fixes the issue where image in the PDF document was covered by a black hatch when print.
  • Fixes the issue that caused open type fonts to display incorrectly when print.
  • Fixes the issue that caused the content lost when print.
  • Resolves the issue that caused the exception that ContextColor /Resources/f856973e-951b-491c-ad5f-9fcff4b05a16.icc 1 is not a valid value for Int32 when load.
  • Fixes the issue that caused the error that badly formed dictionary next should be a name before 9406 when load.
  • Fixes the issue that caused the value of combox field got added repeatedly when debug.
  • Fixes the issue that caused InsertPageRange method got stuck.
  • Fixes the issue that caused accented characters lost when convert to XPS.
  • Fixes the issue that caused the return value incorrect when use signature.VerifyDocModified() method.
  • Fixes the issue that caused the blank image when convert to IMG.
  • Improves the quality of the image when convert XPS to PDF.
  • Resolves the issue that caused image lost when draw EMF image into PDF.
  • Fixes the issue that caused the field format value was null.
  • Fixes the issue that caused blank page when print the PDF.
  • Fixes the issue that caused SaveChange warning information when open the document after filling the field.
  • Fixes the issue that caused page content missing when merge files.
  • Fixes the issue that caused InvalidCastException when close PDF object.
  • Fixes the issue that caused non-transparent region when convert XPS which has transparent region to PDF.
  • Fixes the issue that caused wrong alignment of field value when flat the field or set it ReadOnly.
  • Fixes the issue that caused exception when load the XPS file.
  • Fixes the issue where the color of shape was missing when convert XPS to PDF.
  • Fixes the issue that caused the string disoriented when print PDF.

Spire.XLS

New Features:

  • Supports to convert to SVG.
  • for (int i = 0; i < workbook.Worksheets.Count; i++)
                {
                    FileStream fs = new FileStream(string.Format("sheet{0}.svg", i), FileMode.Create);
                    workbook.Worksheets[i].ToSVGStream(fs, 0, 0, 0, 0);
                    fs.Close();
                }
    
  • Supports to check whether the workbook is password protected.
  • bool havepwd = workbook.IsPasswordProtected(inputFile);
    
  • Supports to extract the equation of chart trendline.
  • IChartTrendLine trendLine = workbook.WorkSheets[0].Charts[0].Series[0].TrendLines[0];
    string formula = trendLine.Formula;
    
  • Supports to add Oval shape in chart.
  • var shape=chart.Shapes.AddOval(left,top,right,bottowm);
    
  • Supports to set Multi-Level Category Labels property for the chart Axis.
  • chart.PrimaryCategoryAXis.MultiLeaveLable = true;
    
  • Supports to save chart as vector image.
  • book.SaveChartAsEmfImage(chartSheet);
    

Bug solutions:

  • Fixes the issue that caused incorrect content when convert to PDF.
  • Fixes the issue that caused custom datalable missing when save chart to image.
  • Fixes the issue that caused NullReferenceException when save file.
  • Fixes the issue that caused AccessViolationException when load file.
  • Fixes the issue that caused ArgumentOutOfRangeException when load xlsm file.
  • Fixes the issue that caused unable to remove chart.
  • Fixes the issue that caused incorrect formula value when convert to PDF.
  • Fixes the issue that caused ArgumentException when insert invalid date into cell.
  • Fixes the issue that caused picture missing when fill picture into comment.
  • Fixes the issue that caused wrong order of chart series when convert to PDF.
  • Fixes the issue where Sparklines cannot be edited or deleted.
  • Fixes the issue that caused KeyNotFoundException when set border for cells.
  • Fixes the issue that caused leader line missing and overlapped content when save chart as image.
  • Fixes the issue that caused ApplicationException when load file.
  • Fixes the issue that caused incorrect content when convert excel to PDF.
  • Fixes the issue that caused chart location changed when use AutoFitColumns method.
  • Fixes the issue that caused ArgumentOutOfRangeException when convert excel to PDF.
  • Fixes the issue that caused wrong page break when convert excel to PDF.
  • Fixes the issue that caused XmlException when load file.
  • Fixes the issue that caused InvalidCastException when extract HPageBreak in HPageBreaksCollection.
  • Fixes the issue that caused ArgumentOutOfRangeException when set color for DataPoint.

Spire.Presentation

New Feature:

  • Supports to convert PPT to SVG.
  • Presentation ppt = new Presentation();
    ppt.LoadFromFile(inputFile);
    Queue svgBytes = ppt.SaveToSVG();
    int len = svgBytes.Count;
    for (int i = 0; i < len; i++)
                {
                   FileStream fs = new FileStream(string.Format(outputFile + "{0}.svg", i), FileMode.Create);
                   byte[] bytes = svgBytes.Dequeue();
                   fs.Write(bytes, 0, bytes.Length);
                   ppt.Dispose();
                }
    
  • Adds new features to get/set transition duration.
  • ///Specifies the transition duration.take effect above office 2010. millisecond.
    public uint Duration { get; set; }
    presentation.Slides[i].SlideShowTransition.Duration;
    

Bug solutions:

  • Fixes the issue that caused color of axis's text wrong when convert PPT to image.
  • Fixes the issue that caused wrong format when convert PPT to image

Spire.PDFViewer

Bug solutions:

  • Fixes the issue where the content was cut off.
  • Fixes the issue that caused the checked checkbox not show.
  • Resolves the issue that caused extra bad characters(idotlessi:hungarumlautz).
  • Fixes the issue that caused the document unclear when the PDF document has large numbers of columns (over 100 columns) in a grid.
  • Fixes the issue where part contents of header was not displayed when the PDF document has large numbers of columns (over 100 columns) in a grid.
  • Fixes the issue where the image lost.

Spire.OfficeViewer

Main features:

  • Load office documents and PDF from file and view;
  • Switch to target page;
  • Fit page, Fit width, Fit height;
  • Page down/up;
  • Zoom in/out;
  • Hand tool;
  • Print;
  • Save as PDF and XPS;