New Release for Spire.Office Version 2.13

Spire.Office

With the effort of our development team, today we have released the latest version for Spire.Office Platinum version 2.13. In this version, the recent releases of Spire.Doc, Spire.PDF, Spire.XLS, Spire.DocViewer, Spire.PDFViewer, Spire.Presentation, Spire.DataExport, Spire.Barcode, all have been included.

Versions:

Spire.Doc v5.6.17
Spire.PDF v3.6.131
Spire.XLS v7.9.11
Spire.DocViewer.Forms v2.1.13
Spire.PDFViewer.Forms v2.8.10
Spire.Presentation v2.5.11
Spire.DataExport v3.5.57
Spire.Barcode v1.2.9

Free Trial to evaluate Spire.Office v2.13 here:

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

Details of New features and Bug solutions:

Spire.Doc

New Feature:

Add new method to embed uninstalled fonts by font document when convert Doc to PDF.

Document document = new Document();
document.LoadFromFile("Testing.docx");
ToPdfParameterList parms = new ToPdfParameterList()
            {
                PrivateFontPaths = new List()
               {
                  new PrivateFontPath("Century Gothic",FontStyle.Regular,"..\\..\\GOTHIC.TTF"),
                  new PrivateFontPath("Century Gothic",FontStyle.Bold,"..\\..\\GOTHICB.TTF"),
                  new PrivateFontPath("Century Gothic",FontStyle.Italic,"..\\..\\GOTHICI.TTF") ,
                  new PrivateFontPath("Century Gothic",FontStyle.Bold|FontStyle.Italic,"..\\..\\GOTHICBI.TTF")                                       
               }
            };
 document.SaveToFile("Testing.pdf", parms);

Bug solutions:

Fixes the issue that caused the content lost when convert to PDF.
Fixes the issue that caused the application hangs when convert RTF to PDF.
Fixes the issue that caused the application hangs when convert .docx to PDF.
Fixes the issue that caused the ArgumentOutOfRangeException when save to stream.
Fixes the issue where the content was not correct when converts to Image.
Fixes the issue where the content was not correct when converts to PDF.
Fixes the issue where there is security error while opening when create new table.
Fixes the issue that caused the exception when load 0K document.
Fixes the issue that caused the stack empty error when using the AppendHtml method to append the Html.
Fixes the issue where the content in the table was cut off when using the AppendHtml method to append the Html includes table.
Fixes the issue that caused exception when load HTML.
Fixes the issue where the column lost when set PageOrientation and TextDirection.
Fixes the issue that caused layout change when convert word (with tables) to PDF.
Fixes the issue that caused alignment issue when convert word document to PDF.
Fixes the issue where the hyperlink in the header changed when converts RTF to PDF.

Spire.XLS

New Features:

Add new method to customize data label position.

ChartDataLabels format = chart.Series[i].DataPoints.DefaultDataPoint.DataLabels;
format.IsXMode = true;
format.IsYMode = true;
format.X = 1800;
format.Y = 2000;

Add new method to set the position of the comment.

ExcelComment comment = range.AddComment();
comment.SetCommentLocation(true,true);

Bug solutions:

Fixes the issue that caused the text font in the textbox bold when convert to PDF/XPS.
Fixes the issue that caused the TextRotationAngle of PrimaryCategoryAxis not working when converts to PDF.
Resolves the issue where the category label in chart is incorrect when convert to PDF.
Fixes the issue that caused the exception when combine multiple Excel files.
Resolves the issue that caused OverflowException when load Excel file.
Fixes the issue that caused shape lost when convert sheet to Image.
Fixes the issue that caused the richtext formatting lost when convert to Image.
Fixes the issues where the label colors and positions in images are not the same as in charts when save the charts from sheets as images.
Fixes the issue where the spreadsheet showed a right parenthesis on all fields when select the whole spreadsheet and click on the Comma button to format numbers with commas.
Fixes the issue that cause unusual formula calculation.
Fixes the issue where the category labels color in chart cannot changed.
Fixes the issue caused formatting Date not working in "dd/MM/yyyy" Format.
Fixes the issue caused exception when loading worksheet has password protected.

Spire.Presentation

Bug solutions:

Fixes the issue that caused bullet point at the beginning of the text.
Fixes the issue where the HasDataTable property of the chart didn't work.
Fixes the issue that caused "String can not be empty" exception when access data behind this chart.
Fixes the issue that file is broken and needs to be open in repair mode when add a slide and save to another file then open this file in MS Power Point.

Spire.PDFViewer

Bug solutions:

Fixes the issue where the barcode faded.
Fixes the issue where the PDF document can't be loaded.
Fixes the issue where the comment in PDF displayed incorrectly.