Spire.DataExport for .NET is a 100% pure data .NET library suit for exporting data into MS Word, Excel, RTF, Access, PDF, XPS, HTML, XML, Text, CSV, DBF, SYLK, SQL Script, DIF, Clipboard, etc.

Wed Apr 30, 2014 8:49 am

This is the list of changelogs of Spire.Office New release and hotfix. Spire.Doc, Spire.PDF, Spire.XLS, Spire.PDFViewer, Spire.DocViewer and Spire.DataExport, Spire.BarCode are included in Spire.Office.
Free Trial to evaluate Spire.Office here:
http://www.e-iceblue.com/Download/downl ... t-now.html

Spire.Office Platinum (DLL Only) Version:4.7.0(2019-07-22)
DLL Version:
Spire.Doc.dll v7.7.10
Spire.Pdf.dll v5.7.14
Spire.XLS.dll v9.7.5
Spire.Presentation.dll v4.7.6
Spire.Email.dll v2.4.12
Spire.DocViewer.Forms.dll v4.5.5
Spire.PdfViewer.Forms.dll v4.6.5
Spire.PdfViewer.Asp.dll v4.6.5
Spire.Spreadsheet v3.7.3
Spire.OfficeViewer.Forms.dll v4.7.0
Spire.Barcode.dll v3.5.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.7.5
Spire.License.dll v1.3.7
Spire.XLS
New Features:
Supports applying external font file to chart, such as axis labels and datalabels. Note: embedding the font in Excel file is not supported, but it is supported when converting to PDF.
Code: Select all
Workbook wb = new Workbook();
wb.LoadFromFile("Book1.xlsx");
Worksheet sheet = wb.Worksheets[0];
Chart chart = sheet.Charts[0];
wb.CustomFontFilePaths = new string[] { "C:\\gotham-book.ttf" };
System.Collections.Hashtable result=wb.GetCustomFontParsedResult();
chart.PrimaryValueAxis.Font.FontName= result["C:\\gotham-book.ttf"] as string;
chart.SecondaryCategoryAxis.Font.FontName = result["C:\\gotham-book.ttf"] as string;
Spire.Xls.Charts.ChartSerie cs1 = chart.Series[0];
cs1.DataPoints.DefaultDataPoint.DataLabels.FontName = result["C:\\gotham-book.ttf"] as string;
wb.SaveToFile("result.pdf", FileFormat.PDF);

Supports specifying EmfType in ToEMFStream method.
Code: Select all
sheet.ToEMFStream(stream, sheet.FirstRow, sheet.FirstColumn, sheet.LastRow, sheet.LastColumn, EmfType.EmfOnly);

Bug Fixes:
Fixes the issue that caused incorrect content format after converting Excel to HTML.
Fixes the issue that the application threw an exception when converting an Excel which contains formulas to PDF.
Fixes the issue that caused incorrect content after copying a sheet which contains named ranges.
Fixes the issue that the application threw an exception “offset and length beyond the array bounds...” when loading Excel.
Fixed the issue that after creating a chart using an array with an empty first value, the generated Excel prompted an error when opening.
Fixes the issue that getting the formula of trendline returned incorrect data.
Fixes the issue that caused incorrect color after converting .XLT to .XLS.
Fixes the issue that caused an exception "The ' [ '- unterminated [] set is being analyzed" when converting Excel to PDF.
Fixes the issue that the same axis categories were expanded when converting chart to an image.
Fixes the issue that setting the center alignment of checkbox text failed.
Fixes the issue that the thousand separator format of the number value obtained in the Spanish language system was incorrect.
Spire.Doc
Bug Fixes:
Fixes the issue that the images don't display out when updating field after adding MergeField to IncludePicture.
Fixes the issue that the mergefield update incorrectly after the format like "EEEE year O month A".
Fixes the issue that converting Word to Pdf is failed.
Fixes the issue that the position of bookmarkEnd tag changed after resaving the Word by MS Word.
Fixes the issue that the field update failed when setting the custom styles.
Fixes the issue that the image was stretched after converting Word to PDF.
Fixes the issue that the application threw the “The queue is empty” exception when loading HTML file.
Fixes the issue that the application threw the “Stack empty” exception when loading Word document.
Fixes the issue that caused incorrect content after converting Word to PDF.
Fixes the issue that caused incorrect indent of paragraph and cropped text after converting RTF to PDF.
Fixes the issue that caused offset position of text after converting Word to PDF.
Fixes the issue that caused incorrect format after creating textboxes in Word and converting the word to PDF.
Fixes the issue that the settings (KeepFollow,PageBreakAfter,Isheader) didn't take effect after converting Word to PDF.
Fixes the issue that caused incorrect location of image after converting Word to XPS.
Fixes the issue that the application threw an exception "The format of input string is not correct" when loading HTML file.
Fixes the issue that the base64 image didn't render after converting HTML to PDF.
Fixes the issue that the line height of table was incorrect after converting Word to PDF.
Fixes the issue that the application threw an exception “The index was out of range. Must be non-negative and less than the set size” when converting Word to PDF.
Fixes the issue that caused incorrect Thai characters after converting Word to PDF.
Spire.Presentation
New Features:
Supports setting the alignment of shape.
Code: Select all
var shape = ppt.Slides[0].Shapes[0];
shape.SetShapeAlignment(Spire.Presentation.ShapeAlignment.AlignBottom);
shape.SetShapeAlignment(Spire.Presentation.ShapeAlignment.AlignLeft);
shape.SetShapeAlignment(Spire.Presentation.ShapeAlignment.AlignTop);
shape.SetShapeAlignment(Spire.Presentation.ShapeAlignment.AlignCenter);
shape.SetShapeAlignment(Spire.Presentation.ShapeAlignment.AlignMiddle);
shape.SetShapeAlignment(Spire.Presentation.ShapeAlignment.AlignRight);
shape.SetShapeAlignment(Spire.Presentation.ShapeAlignment.DistributeHorizontally);
shape.SetShapeAlignment(Spire.Presentation.ShapeAlignment.DistributeVertically);

Supports getting the format and version of PowerPoint file.
Code: Select all
Presentation pp = new Presentation();
ppt.LoadFromFile(filePath);
FormatAndVersion fv = ppt.FormatAndVersion;

Bug Fixes:
Fixes the issue that caused incorrect content after converting PPTX to image.
Fixes the issue that the AdvanceAfterTime could not be obtained correctly.
Fixes the issue that the time of generated PPTX file was incorrect.
Fixes the issue that the width of shape increased after saving the PPTX.
Fixes the issue that the chart data series markers lost after converting PPTX to image.
Fixes the issue that the font height and color of text can not be obtained successfully.
Fixes the issue the default font height of text can not be obtained successfully.
Fixes the issue the background color of inserted slide lost.
Spire.PDF
New Features:
Implements that PdfTextMarkupAnnotationWidget PdfTextAnnotationWidget and PdfPopupAnnotationWidget can delete the comment author information.
Adds page.ReplaceImage(Image originalImage, PdfImage image) method to replace original image with new image.
Bug Fixes:
Fixes the issue that the application threw an error "Unexpected token unknown before 83178" when setting the margins and page size of a PDF.
Fixes the issue that the location and the format of text was incorrect when setting the parameter htmlTags in the page.DrawString(string text, PdfFontBase font, PdfBrush brush, PointF point, bool htmlTags) method to true.
Fixes the issue that the content was garbled when printing a PDF document using STSongStd-Light-Acro font and SinHei font.
Fixes the issue that the application threw a System.NullReferenceException exception when using page.CreateTemplate() method to create a page template.
Fixes the issue that extracting the text of a PDF document failed.
Spire.Spreadsheet
New Features:
Adds the Items property to the Cells, Columns, and Rows collections in order to view each item in the collection when debugging.
Bug Fixes:
Fixes the issue that the order of the first newly added worksheet was incorrect after applying license.
Fixes the issue that some data were lost after loading.
Fixes the issue that the SetActiveCell didn't take effect after setting freezing.

Spire.Office Platinum (DLL Only) Version:4.6.3(2019-06-26)
DLL Version:
Spire.Doc.dll v7.6.13
Spire.Pdf.dll v5.6.32
Spire.XLS.dll v9.6.11
Spire.Presentation.dll v4.6.6
Spire.Email.dll v2.4.11
Spire.DocViewer.Forms.dll v4.5.4
Spire.PdfViewer.Forms.dll v4.6.4
Spire.PdfViewer.Asp.dll v4.6.4
Spire.Spreadsheet v3.6.7
Spire.OfficeViewer.Forms.dll v4.6.3
Spire.Barcode.dll v3.5.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.6.11
Spire.License.dll v1.3.7

Spire.Presentation
New Features:
Supports setting the arrangement order of shapes.
Code: Select all
Presentation ppt = new Presentation(input);
IAutoShape shape = ppt.Slides[0].Shapes[0] as IAutoShape;
shape.SetShapeArrange(ShapeArrange.BringForward);
ppt.SaveToFile("result.pptx", FileFormat.Pptx2013);

Bug Fixes:
Fixes the issue that there were extra characters when converting PPT to image.
Fixes the issue that the application threw an error "an object is not referenced to an instance of an object" when loading a PPTX document.

Spire.Office Platinum (DLL Only) Version:4.6.1(2019-06-21)
DLL Version:
Spire.Doc.dll v7.6.7
Spire.Pdf.dll v5.6.28
Spire.XLS.dll v9.6.8
Spire.Presentation.dll v4.6.2
Spire.Email.dll v2.4.8
Spire.DocViewer.Forms.dll v4.5.2
Spire.PdfViewer.Forms.dll v4.6.2
Spire.PdfViewer.Asp.dll v4.5.2
Spire.Spreadsheet v3.6.5
Spire.OfficeViewer.Forms.dll v4.6.1
Spire.Barcode.dll v3.5.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.6.8
Spire.License.dll v1.3.7

Spire.Presentation
New Features:
Adds the DefaultLatinFont property to get the font of the table applied with a table style.
Code: Select all
var defaultLatinFont = table[2, 0].TextFrame.TextRange.DefaultLatinFont

Bug Fixes:
Fixes the issue that the application threw NullReferenceException when converting POTX to PPTX.
Spire.XLS
Bug Fixes:
Fixes the issue that caused incorrect format when converting Excel to image.
Fixes the issue that the application threw the exception "the length can't be less than 0" when getting a specific range.
Fixes the issue that caused incorrect format when converting chart to image.
Fixes the issue that the application threw the exception "the specified parameter is out of range of valid values" when loading a CSV file.
Fixes the issue that caused incorrect columns of Pivot Table after adding data.
Fixes the issue that the formula of trendline could not be obtained correctly.
Spire.SpreadSheet
New Features:
Implements copying and pasting of multiple areas (including the discontinuous cells with different rows or same rows)
Implements inserting and deleting multiple rows or columns (can be discontinuous)
Adds events to insert and delete rows or columns.
Code: Select all
AfterInsertRow/AfterIndertColumn
AfterDeleteRow/AfterDeleteColumn

Bug Fixes:
Fixes the issue that the data of the folded rows could be copied after grouping rows.
Spire.PDF
New Features:
Supports removing the author of annotation. Note removing the author of caret annotation is not supported at present.
Code: Select all
annotation.Author = "";

Supports specifying page ranges when saving to PDF.
Code: Select all
document.SaveToFile(filepath, 0, 3, FileFormat.PDF);

Supports setting the width of signature name.
Code: Select all
signature.SetSignNameWidth(float width);

Bug Fixes:
Fixes the issue that the PDF document failed to be printed out by color printer.
Fixes the issue that the invisible layer appeared in SVG after converting PDF to SVG.
Fixes the issue that getting the page number of bookmark's destination failed.
Fixes the issue that the content lost after converting EMF to PDF.
Fixes the issue that the font was changed after converting PDF to Word.
Fixes the issue that the application threw an exception when finding the character "$" and the positions of some characters were not be returned correctly.
Fixes the issue that adding hyperlink to image failed.
Fixes the issue that running the application to convert HTML to PDF with plugin, the second time was longer than the first time.
Fixes the issue that messy content was caused after converting HTML to PDF with plugin.
Fixes the issue that related to the timeout when converting HTML to PDF with plugin.
Fixes the issue that the application threw an exception when converting HTML to PDF with plugin.
Fixes the issue that incorrect spacing between words was caused after converting HTML to PDF with plugin.
Fixes the issue that incorrect css style was caused after converting HTML to PDF with plugin.
Fixes the issue that low quality of content was caused after converting HTML to PDF with plugin.
Fixes the issue that incorrect table layout was caused after converting HTML to PDF with plugin.
Fixes the issue that the hyperlink lost after converting HTML to PDF with plugin.
Fixes the issue that shrunken content was caused after converting HTML to PDF with plugin.
Fixes the issue that incorrect table header was caused after converting HTML to PDF with plugin.
Fixes the issue that the application that converts HTML to PDF with plugin didn't work on Azure (64bit).
Spire.Doc
New Features:
Supports adding Latex math code to Word.
Code: Select all
Document doc = new Document();
Section section = doc.AddSection();
Paragraph paragraph = section.AddParagraph();
OfficeMath officeMath = new OfficeMath(doc);
paragraph.Items.Add(officeMath);
officeMath.FromLatexMathCode("x^{2}+\\sqrt{x^{2}+1}=2");
doc.SaveToFile("latexToDoc", FileFormat.Docx);

Supports setting MailMergeMainDocumentType as NotAMergeDocument to make the Word as non-mailmerge document when doing MailMerge.
Code: Select all
document.MailMerge.MailMergeMainDocumentType = MailMergeMainDocumentType.NotAMergeDocument;

Bug Fixes:
Fixes the issue that the text overlapped after converting Word to PDF.
Fixes the issue that using PS method to do conversion from Word to PDF in multi-thread took more time than single thread.
Fixes the issue that incorrect format was caused after merging Word files.
Fixes the issue that the application hung when executing SaveToImages method.
Fixes the issue that there was extra columns when opening the generated ODT by LibreOffice 6.2.3 after converting HTML to ODT.
Fixes the issue that the application threw "Items with the same key have been added" when merging Word files.
Fixes the issue that incorrect content format was caused after converting XML to Docx.
Fixes the issue that overlapped table was caused after converting Word to PDF.
Fixes the issue that getting FieldValue and ImageFileName of ImageMergeField had differences between old version and new version.
Fixes the issue that the application threw NullReferenceException when converting Word to PDF.
Fixes the issue that the application threw “The value is too large or too small for Int32” when loading Word.
Fixes the issue that incorrect header was caused after modifying .doc file which was generated by Spire.Doc.

Spire.Office Platinum (DLL Only) Version:4.6.0(2019-06-06)
DLL Version:
Spire.Doc.dll v7.6.2
Spire.Pdf.dll v5.6.3
Spire.XLS.dll v9.6.2
Spire.Presentation.dll v4.5.10
Spire.Email.dll v2.4.6
Spire.DocViewer.Forms.dll v4.5.1
Spire.PdfViewer.Forms.dll v4.5.11
Spire.PdfViewer.Asp.dll v4.5.11
Spire.Spreadsheet v3.6.1
Spire.OfficeViewer.Forms.dll v4.6.0
Spire.Barcode.dll v3.5.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.6.2
Spire.License.dll v1.3.7
Spire.Presentation
Bug Fixes:
Fixes the issue that the chart title was incorrect when converting PPT to image.
Spire.XLS
Bug Fixes:
Fixes the issue that caused incorrect format when converting Excel to PDF.
Fixes the issue that the transparency of image was lost after saving to Version97to2003 file format.
Fixes the issue that the characters become □ when converting Excel to PDF.
Fixes the issue that the application threw an exception when using the code CalculateAllValue.
Fixes the issue that setting color for chart markers didn't work.
Fixes the issue that the application threw the exception "ArgumentException" when saving Excel to image.
Fixes the issue that the application threw an exception when loading a file.
Spire.Spreadsheet
New Features:
Supports inserting or deleting rows or columns by right-clicking and selecting the option "Insert" or "Delete".
Adds two events "ColumnGroupButtonClick" and "RowGroupButtonClick";
Spire.PDF
Bug Fixes:
Fixes the issue that the application threw the exception "Source array was not long enough" when loading an encrypted PDF.
Fixes the issue that caused duplicated stamps after printing.
Fixes the issue that caused messy content after converting PDF to TIFF.
Fixes the issue that the application threw an exception “Attempts to read content beyond the end of the stream” when printing.
Fixes the issue that failed to add an image in PdfGrid.
Fixes the issue that speed to load PDF was slow.
Fixes the issue that signature of PDF lost after converting the PDF to image.

Spire.Office Platinum (DLL Only) Version:4.5.4(2019-05-24)
Dll Version:
Spire.Doc.dll v7.5.13
Spire.Pdf.dll v5.5.22
Spire.XLS.dll v9.5.12
Spire.Presentation.dll v4.5.8
Spire.Email.dll v2.4.5
Spire.DocViewer.Forms.dll v4.4.6
Spire.PdfViewer.Forms.dll v4.5.9
Spire.PdfViewer.Asp.dll v4.5.9
Spire.Spreadsheet v3.5.4
Spire.OfficeViewer.Forms.dll v4.5.4
Spire.Barcode.dll v3.5.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.5.12
Spire.License.dll v1.3.7

Spire.Presentation
New features:
Supports changing the master of the slide by setting the MasterSlideID property.
Code: Select all
ppt.Slides[1].MasterSlideID = ppt.Slides[0].MasterSlideID;

Fixes bugs:
Fixes the issue that the label content of the chart was incorrect when converting PPT to image.
Fixes the issue that the application threw an error "Object reference not set to an instance of an object" when loading a PPTX document.
Fixes the issue that the application threw an error " the ContentType string is invalid" when using OpenXml API to load the saved PPTX document.
Fixes the issue that the application threw an error "Microsoft PowerPoint 2007 file is corrupt" when loading a PPTX document
Spire.Xls
New features:
Supports converting Text format to Number format.
Code: Select all
range.ConvertToNumber();

Fixes bugs:
Fixes the issue that caused incorrect format in Pdf which was converted from Excel with the A3 paper size setting.
Fixes the issue that the application can't get the correct NumberText after setting NumberFormat.
Fixes the issue that caused the incorrect alignment after converting Excel to Pdf.
Fixes the issue that there was an error "Object reference not set to an instance of an object” threw when running excel to pdf/images conversion on a Docker container hosted on Linux.
Spire.Doc
Bug Fixes:
Fixes the issue that there was extra blank page after converting Word to PDF.
Fixes the issue that the space between tables was lost when converting to PDF.
Fixes the issue that the application threw an exception “InvalidOperationException” when loading files.
Fixes the issue that the content was missing after converting Word to PDF.
Fixes the issue that the color of text changed after converting Word to PDF.
Fixes the issue that the format of text changed to Bold after converting Word to PDF.
Fixes the issue that the application threw an exception “ArgumentOutOfRangeException” when converting .odt to .docx.
Spire.Pdf
Fixes bugs:
Fixes the issue that content was overlapped when converting PDF to Word.
Fixes the issue that system memory kept growing when extracting text.
Fixes the issue that replacing images failed.
Fixes the issue that the application threw an error "' PDFX :My ID' has invalid markup" when adding two or
more custom attributes that contain space character.
Fixes the issue that the layout was incorrect when setting the row count of PDF Grid to 280.
Fixes the issue that the content was garbled when extracting text.
Fixes the issue that the application hung when converting a PDF to Image.
Fixes the issue that the application threw an error "the characters are not supported by this font" when
setting the font size.
Fixes the issue that the same text was printed in duplicate when printing PDF.
Spire.Barcode
New features:
Supports setting the vertical/horizontal bearer bar for ITF-14 barcode.
Code: Select all
//vertical bar
BarCodeSetting.ITF14BearerBars = ITF14BorderType.Frame;
///horizontal bar
BarCodeSetting.ITF14BearerBars = ITF14BorderType.Bar;


Spire.Office Platinum (DLL Only) Version:4.5.1(2019-05-13)
Dll Version:
Spire.Doc.dll v7.5.5
Spire.Pdf.dll v5.5.10
Spire.XLS.dll v9.5.5
Spire.Presentation.dll v4.5.1
Spire.Email.dll v2.4.2
Spire.DocViewer.Forms.dll v4.4.3
Spire.PdfViewer.Forms.dll v4.5.4
Spire.PdfViewer.Asp.dll v4.5.4
Spire.Spreadsheet v3.5.1
Spire.OfficeViewer.Forms.dll v4.5.1
Spire.Barcode.dll v3.4.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.5.5
Spire.License.dll v1.3.7
Spire.Email
Bug Fixes:
Fixes the issue that the attachments could not be added in .msg after applying license.
Spire.Spreadsheet
Bug Fixes:
Fixes an issue that there were additional rows when displaying.
Spire.Presentation
New Features:
Supports saving a PowerPoint file as PowerPoint 2003 format.
Spire.Doc
New Features:
Supports signing .doc / .docx with digital signature, yet only the .pfx certificate is supported. And the feature is not supported in .Net Standard / .Net Core.
Code: Select all
public void SaveToFile(string fileName, FileFormat fileFormat, byte[] certificateData, string securePassword);
public void SaveToFile(string fileName, FileFormat fileFormat, string certificatePath, string securePassword);
public void SaveToStream(Stream stream, FileFormat fileFormat, byte[] certificateData, string securePassword);
public void SaveToStream(Stream stream, FileFormat fileFormat, string certificatePath, string securePassword);
//Also supports signing by calling Document class.
public static byte[] Sign(Stream sourceStream, byte[] certificateData, string securePassword);
public static byte[] Sign(Stream sourceStream, string certificatePath, string securePassword);

Alteration:
document.Styles.ApplyDocDefaultsToNormalStyle() method has been marked as obsolete, using document.KeepSameFormat = true instead.
Bug Fixes:
Fixes the issue that the character spacing was changed when merging documents.
Fixes the issue that the numbering format was changed when converting a .docx document to PDF.
Fixes the issue that the image in the combined shape could not be obtained.
Fixes the issue that the application threw an error "index out of range" when loading a doc document.
Fixes the issue that the formula field "=SUM(ABOVE)" update failed.
Spire.PDF
Bug Fixes:
Fixes the issue that caused ArgumentException when printing.
Fixes the issue that PDF/X that was converted from Word could not be validated correctly in the Adobe Reader.
Fixes the issue that caused overlapped text after converting PDF to Word.
Fixes the issue that the checkbox and signature had problems after signing.
Fixes the issue that caused incorrect text after filling Textbox field.
Fixes the issue that the images became black after merging files.
Fixes the issue that the content were messy after converting HTML to PDF.
Fixes the issue that the read-only fields cannot be deleted.
Fixes the issue that caused "NullReferenceException" when obtaining UsedFonts.
Fixes the issue that caused "NullReferenceException" when saving PDF page as images.
Fixes the issue that the text could not be found.
Fixes the issue that when signing on an existing signature field, the properties of PdfSignature instance had problems.
Fixes the issue that the table format is incorrect once the merged rows of PDF gird exceed one page.
Fixes the issue that caused messy content after converting PDF to image.
Fixes the issue that the application threw the "NullReferenceException" when extracting text from PDF pages.
Spire.XLS
Optimizations:
Improves the speed of loading a file which contains EMF.
Bug Fixes:
Fixes the issue that the application threw an exception when saving a sheet which contains 3d pie chart to SVG.
Fixes the issue that MS excel hinted a problem when opening the result file after adding a pivot table.
Fixes the issue that the progress threw an exception "ArgumentOutOfException" when loading a file.
Fixes the issue that the progress threw an exception "ArgumentOutOfException" when saving sheet to image.
Fixes the issue that the content exceeded the cell after converting Excel to PDF.
Fixes the issue that the application threw an exception "OverflowException" when converting chart to image.
Fixes the issue that a cell was filled wrong color for a new file.
Fixes the issue that the content of some rows were lost after converting sheet to image.
Fixes the issue that getting the page number of worksheet returned incorrect data.
Fixes the issue that after adding background image and then saving to Version97to2003 format, the generated .xls had problems on content.
Fixes the issue that the application threw “OverflowException” when loading an Excel.
Fixes the issue that the superscript was incorrect after saving an Excel to image.
Fixes the issue that the application threw an error "XXX is not valid named range" when executing InsertArray method.
Fixes the issue that the application threw an error "Input string was not in a correct format" when loading an Excel.
Fixes the issue that the conditional format was lost after converting worksheet to HTML.
Spire.PdfViewer
New Features:
Adds Move(float offsetX, float offsetY) method to move a new location from current location.
Adds ScrollTo(float scrollLocationX, float scrollLocationY) method to scroll to the designated location.
Bug Fixes:
Fixes the issue that the application threw the exception "StackOverflowException" when loading a pdf file.
Fixes the issue that the content is garbled when viewing a pdf file.
Alteration:
LoadFromHtml(string url, string convertPdfName) method may be removed in the future.
Threshold property may be removed in the future.
MultiPagesThreshold property may be removed in the future.
VeryfyDocumentEncrypted(string filePath)method may be removed in the future,please use the method of IsEncryptedDocument()instead.
SetViewerMode(PdfViewerMode.PdfViewerMode mode) method may be removed in the future,please use the property of PdfDocumentViewer.ViewerMode instead.
SetPageLayoutMode(PageLayoutMode pageMode) method may be removed in the future,please use the property of PdfDocumentViewer.PageLayoutMode instead.
ZoomTo(int percentage) method and SetZoom(ZoomMode mode) method may be removed in the future,please use the property of PdfDocumentViewer.ZoomFactor instead.
PdfLoaded event may be removed in the future,please use DocumentOpened event instead.
ZoomChanged event may be removed in the future,please use ZoomFactorChanged instead.
ZoomFator property may be removed in the future,please use the property of PdfDocumentViewer.ZoomFactor instead.
Initialize(PdfDocumentViewer view) method may be removed in the future,please use the property of ActiveView instead.

Spire.Office Platinum (DLL Only) Version:4.4.1(2019-04-19)
Dll Version:
Spire.Doc.dll v7.4.12
Spire.Pdf.dll v5.4.13
Spire.XLS.dll v9.4.8
Spire.Presentation.dll v4.4.7
Spire.Email.dll v2.1.10
Spire.DocViewer.Forms.dll v4.4.1
Spire.PdfViewer.Forms.dll v4.4.3
Spire.PdfViewer.Asp.dll v4.4.3
Spire.Spreadsheet v3.4.1
Spire.OfficeViewer.Forms.dll v4.4.1
Spire.Barcode.dll v3.4.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.4.8
Spire.License.dll v1.3.7
Spire.PDF
Bug Fixes:
Fixes the issue that there were some incorrect characters when converting XPS to PDF.
Fixes the issue that the content was lost when converting PDF page contained only one image to Image.
Fixes the issue that the application threw an error "the index beyond the bounds of the array" when converting a PDF to Image.
Fixes the issue that the images which were included in the content changed to the black boxes when converting a PDF to Image.
Spire.XLS
New Features:
Adds CustomFontFilePaths property to set the font files that are not installed on the computer.
Code: Select all
workbook.CustomFontFilePaths = new string[] { inputFontfile };

Optimizations:
Optimizes the time of creating a chart when setting a larger chart data range.
Optimizes the speed of copying worksheets.
Bug Fixes:
Fixes the issue that the content was lost when converting an .xlsx document to images.
Fixes the issue that the application threw an error "don't set the object reference to the object instance" when copying a sheet containing a chart.
Fixes the issue that the application threw an error "cannot find the required relation" when loading an .xlsx document.
Fixes the issue that the content was lost when converting an .xlsx document generated by NPOI to PDF.
Fixes the issue that the application threw an error "don't set the object reference to the object instance" when calculating the formulas using CalculateAllValue method.
Spire.Presentation
New Features:
Code: Select all
Adds SlidePicture.IsCropped property to determine whether an image was cropped.
foreach (IShape shape in ppt.Slides[0].Shapes)
{
    if (shape is SlidePicture)
    {
        SlidePicture slidepicture = (SlidePicture)shape;
        bool reault = slidepicture.IsCropped;
    }           
}

Adds the presentation.IsNoteRetained property to set whether to keep notes when converting PPT to SVG.
Code: Select all
Presentation ppt = new Presentation();
ppt.LoadFromFile(inputPPT);
ppt.IsNoteRetained = true;
Queue bytes = ppt.SaveToSVG();
int length = bytes.Count;
for (int i = 0; i < length; i++)
{
    FileStream filestream = new FileStream(string.Format(@"output_{0}.svg", i), FileMode.Create);
    byte[] outputBytes = bytes.Dequeue();
    filestream.Write(outputBytes, 0, outputBytes.Length);     
}
ppt.Dispose();

Bug Fixes:
Fixes the issue that the chart data label moved up when converting PPT to PDF.
Spire.Doc
Optimizations:
Optimizes the speed of conversion from Word to PDF.
Bug Fixes:
Fixes the issue that the content pagination was incorrect when converting a .doc document to PDF.
Fixes the issue that the application threw an error "the format of the input string is incorrect" when loading an Html document.
Fixes the issue that the border of the textbox was lost when saving a .doc document.
Fixes the issue that the application threw an error "the reference object was not set to an instance of the object" when loading a .docx document.
Fixes the issue that the text color was changed from blue to black when converting a .docx document to PDF.
Fixes the issue that the content was displayed incorrectly when operating mail merge.
Fixes the issue that the text wrapping was incorrect when converting a .docx document to PDF.
Fixes the issue that the obtained value was incorrect after adding a document custom property containing # symbol.
Fixes the issue that the application threw an error "Unexpected parent of the id attribute" when loading a .docx document containing Russian characters.
Fixes the issue that the borders and background color of the textboxes were lost when saving a .docx document.
Fixes the issue that the content was lost when converting Word to XPS.
Fixes the issue that the application threw an error "pItem haven't found in paragraph Items." when converting Word containing "\t"(tab) in the header paragraph to PDF.
Fixes the issue that the content was cut when converting Word to images.
Fixes the issue that the tab leader in the table of contents was lost when converting Word to PDF.
Spire.Barcode
New Features:
Supports setting the top text margin of barcode.
Code: Select all
barcodeSetting.TopTextMargin = 50.0f;


Spire.Office Platinum (DLL Only) Version:4.4.0(2019-04-04)
Dll Version:
Spire.Doc.dll v7.4.2
Spire.Pdf.dll v5.4.2
Spire.XLS.dll v9.4.1
Spire.Email.dll v2.1.9
Spire.DocViewer.Forms.dll v4.3.1
Spire.PdfViewer.Forms.dll v4.4.1
Spire.PdfViewer.Asp.dll v4.4.1
Spire.Presentation.dll v4.3.20
Spire.Spreadsheet v3.3.2
Spire.OfficeViewer.Forms.dll v4.4.0
Spire.Barcode.dll v3.3.1
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.4.1
Spire.License.dll v1.3.7
Spire.PDF
New Features:
Supports finding and highlighting text that cross lines.
Code: Select all
PdfDocument doc = new PdfDocument(input);
PdfTextFind[] result = null;
foreach (PdfPageBase page in doc.Pages)
{
    result = page.FindText("This is a test", TextFindParameter.CrossLine).Finds;
    for (int i = 0; i < result.Length; i++)
    {
        result[i].ApplyHighLight(Color.Yellow);
    }
}
doc.SaveToFile(output);

Supports adding digital signatures with LTV (Long Term Validation).
Code: Select all
PdfNewDocument doc = new PdfNewDocument();
PdfPageBase page = doc.Pages.Add();
String pfxPath = inputFile;
PdfCertificate cer = new PdfCertificate(pfxPath, password, X509KeyStorageFlags.Exportable);
PdfSignature signature = new PdfSignature(doc, page, cer, "s1");
signature.Bounds = new RectangleF(new PointF(100, 100), new SizeF(200, 200));
signature.ConfigureHttpOCSP(null, null);
doc.Save(outputFile);

Supports getting and setting the background color of the form field.
Code: Select all
PdfRGBColor color = xxField.BackColor;
xxField.BackColor = Color.Yellow;

Supports setting the coordinate position of the picture in PdfGridCell.
Code: Select all
PdfGridCellContent cellContent = new PdfGridCellContent();
cellContent.ImageLocation = new PointF(20,20);

Optimizes the printing speed.
Bug Fixes:
Fixes the issue that the number containing the decimal point was separated by two lines.
Fixes the issue the obtained image location was incorrect.
Fixes the issue document size became very large after multiple digital signatures were added
Fixes the issue that setting the column width of the table didn't work.
Fixes the issue that it threw a Win32Exception when printing a PDF document
Fixes the issue that the images became blurred when printing a PDF document
Fixes the issue that content styles were changed when converting a PDF document to images.
Fixes the issue that there was an error "No FunctionType specified in function" was thrown when extracting images.
Fixes the issue that there was an error "Object reference not set to an instance of an object" was thrown when extracting text.
Fixes an issue that some characters were missing and extra characters were added when extracting text.
Fixes an issue that the merged document could not be opened with the Microsoft Edge browser.
Fixes an issue that the barcode in the document was not displayed correctly when printing a PDF.
Fixes an issue that the content was truncated and lost when drawing text using the PdfTextWidget function.
Fixes an issue that the position of new text was slightly shifted down when replacing text.
Fixes an issue that the added image tag was changed.
Fixes an issue that the application threw the error "the reference object was not set to an instance of the object" when converting TIFF to PDF.
Fixes an issue that vertical text was garbled when converting PDF to images.
Fixes an issue that the application threw the error"the reference object was not set to an instance of the object" when merging PDFs containing hidden content.
Fixes an issue that the content was garbled when splitting a PDF document.
Fixed an issue that the application hung when finding text from a PDF.
Fixes an issue that some content was incorrect when merging PDF documents.
Fixes an issue that setting the checkbox field value did not take effect.
Fixes an issue that the space between numbers was increased when converting PDF to XPS.
Fixes an issue that the content was garbled when printing PDFs.
Fixes an issue that the application threw the error"index cannot be less than zero or greater than count" when merging documents.
Fixes an issue that PDF documents after rotating pages were opened incorrectly with the Microsoft Edge browser.
Spire.Presentation
New Features:

Supports adding text animation to specified paragraphs in shape.
Code: Select all
Presentation ppt = new Presentation();
ppt.LoadFromFile("test.pptx");
IAutoShape shape = (IAutoShape)ppt.Slides[0].Shapes[0];
AnimationEffect animation = shape.Slide.Timeline.MainSequence.AddEffect(shape, AnimationEffectType.Fly);
animation.SetStartEndParagraphs(2, 3);
IAutoShape shape2 = (IAutoShape)ppt.Slides[0].Shapes[1];
AnimationEffect animation2 = shape.Slide.Timeline.MainSequence.AddEffect(shape2, AnimationEffectType.FadedZoom);
animation2.SetStartEndParagraphs(0, 0);
ppt.SaveToFile("result.pptx", FileFormat.Pptx2010);
ppt.Dispose();

Improves print interface.
Code: Select all
Presentation ppt = new Presentation();
ppt.LoadFromFile(inputfile);
PresentationPrintDocument document = new PresentationPrintDocument(ppt);
//Set print task name
document.DocumentName = "print task 1";
document.Print0rder = Order.Horizontal;
document.SlideFrameForPrint = true;
document.GrayLevelForPrint = true;
document.SlideCountPerPageForPrint = PageSlideCount.Three;
document.PrinterSettings.PrintRange = PrintRange.AllPages;
//Set continuous print area
document.PrinterSettings.PrintRange = PrintRange.SomePages;
document.PrinterSettings.FromPage = 1;
document.PrinterSettings.ToPage = ppt.Slides.Count - 1;
//Set discontinuous print area
//document.SelectSldiesForPrint("1", "2-6");
document.PrinterSettings.PrintToFile = true;
document.PrinterSettings.PrintFileName = outputfile;
ppt.Print(document);
ppt.Dispose();

Bug Fixes:
Fixes the issue that the content format was incorrect when converting PPTX to PDF/PPT.
Fixed the issue that the chart was lost when converting PPT to PDF.
Fixed the issue that the process threw an InvalidCastException when loading a PPT document.
Fixed the issue that where the data was not updated correctly after modifying data source of chart
Fixes an issue that it threw the error "the object reference was not set to the object instance" when copying shape.
Fixes an issue that the chart was lost when converting PPT to images.
Fixes an issue that the datalabel was incorrect when converting PPT to PDF.
Fixes an issue that the the formula from chart datasource was not displayed when saving as a PPT file.
Fixes an issue that the legend still existed when converting to PDF after deleting chart legend.
Fixes an issue that the images content were incorrect when converting PPT to PDF.
Fixes the issue that the result was incorrect when converting PPT to images.
Fixes the issue that the application threw an exception when setting the value of ChartData.
Fixes the issue that the application threw and exception when saving PPT to images.
Fixes the issue that a datalable of a chart was missing when converting PPT to PDF.
Fixes the issue that the format of the data changed after saving PPT to images.
Fixes the issue that the chart data updated incorrectly after changing the chart data.
Fixes the issue that the position of the content changed after converting PPT to PDF.
Fixes the issue that the image moved from left to right when converting PPT to PDF.
Spire.Doc
New Features:
Supports to get or set the value that determines whether the space is automatically adjusted between Asian text and numbers.
Code: Select all
Paragraph.Format.AutoSpaceDN;

Supports to get or set the value that determines whether the space is automatically adjusted between Asian and Latin text.
Code: Select all
Paragraph.Format.AutoSpaceDE;

Bug Fixes:
Fixes the issue that the application threw an exception when saving the Word document to PDF.
Fixes the issue that the page break was incorrect after saving Word to image.
Fixes the issue that setting read only for part content didn't work when saving to .doc format file.
Fixes the issue that the bold effect was lost when converting Word to PDF.
Fixes the issue that the application threw an exception when loading a Word file.
Fixes the issue that the application threw the StackOverflowException when saving the Word document to PDF.
Fixes the issue that the field didn't update correctly after merging files.
Fixes the issue that the cells were split incorrectly when saving to .doc format file.
Fixes the issue that the hidden image displayed after converting Word to PDF.
Fixes the issue that the format was wrong after merging files.
Fixes the issue that there was extra footer after updating TOC.
Spire.XLS
New Features:
Supports to set the location of the content in textbox.
Code: Select all
TextBoxShapeBase texbox = workbook.Worksheets[0].TextBoxes[0] as TextBoxShapeBase;
texbox.InnerLeftMargin = 1;
texbox.InnerRightMargin = 3;
texbox.InnerTopMargin = 1;
texbox.InnerBottomMargin = 3;

Bug Fixes:
Fixes an issue that the rotation of the shape didn't work when saving to ExcelVersion.Version97to2003.
Fixes an issue that an error dialog popped up when opening a document after copying the formulas and saving it to an .xlsx file.
Fixes an issue that image transparency was lost after saving as an .xls document.
Fixes an issue that caused incorrect content after converting Excel to PDF.
Fixes an issue that setting DocumentProperties of version97-2003 format but didn't take effect.
Fixes an issue that caused exception (“XmlException was unhandled”) when loading Excel.
Fixes an issue that the DisplayedText of Excel cell could not be obtained correctly.
Fixes an issue that after saving as a new Excel file, an error dialog popped up when opening the saved Excel.
Fixes an issue that the count of NameRange could not be obtained correctly.
Spire.Spreadsheet
New Features:
Supports customizing language configuration file path.
spreadsheet.MenuLanguageConfigPath= "D:/SpreadsheetTest/MenuLanguageConfig.xml";
Supports recovery shortcut(Ctril + Y).
Reduces the width of the rounding border when the cell is selected.
Bug Fixes:
Fixes an issue that it threw an ArgumentException when loading an xls document.
Fixes an issue that the minus sign was lost when the negative value was displayed in the SpreadSheet.
Fixes an issue that the right side of the border would move to the right when dragging the scroll bar to the left.

Spire.Office Platinum (DLL Only) Version:4.3.1(2019-03-14)
Dll Version:
Spire.Doc.dll v7.3.4
Spire.Pdf.dll v5.3.4
Spire.XLS.dll v9.3.6
Spire.Email.dll v2.1.8
Spire.DocViewer.Forms.dll v4.1.11
Spire.PdfViewer.Forms.dll v4.3.1
Spire.PdfViewer.Asp.dll v4.3.1
Spire.Presentation.dll v4.3.6
Spire.Spreadsheet v3.1.10
Spire.OfficeViewer.Forms.dll v4.3.1
Spire.Barcode.dll v3.1.1
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.3.4
Spire.License.dll v1.3.7
Spire.PDF
New Features:
Supports adding timestamp when signing a PDF. Kindly note that the timestamp servers supported at present must conform to RFC 3161 standard.
Code: Select all
// Summary:
//     Configure timestamp which must conform to RFC 3161.
//
// Parameters:
//   handler:
//     the handler which generate timestamp token
public void ConfigureTimestamp(PdfSignature.TimestampGenerateHandler handler);
//
// Summary:
//     Configure timestamp which must conform to RFC 3161.
//
// Parameters:
//   tsaUrl:
//     TSA url
public void ConfigureTimestamp(string tsaUrl);

Bug Fixes:
Fixes the issue that the content was in bad format after converting PDF to Word.
Fixes the issue that the application threw an exception when converting PDF to SVG.
Fixes the issue that the application threw an exception when printing a PDF document.
Fixes the issue that the extra hidden content was wrongly displayed after creating a booklet for PDF.
Fixes the issue that the application threw an exception when converting PDF to image.
Fixes the issue that the field value could not be displayed when opening the generated.
PDF after adding a text field to existing PDF and then fill the field.
Fixes the issue that the content was in blank after converting PDF to image.
Fixes the issue that drawing content to XPS document failed.
Fixes the issue that some content was missing after converting XPS to PDF.
Spire.Presentation
New Features:
Adds the following properties for printing.
Code: Select all
//Enable slideFrame when printing.
ppt.SlideFrameForPrint = true;
//Set gray level for when printing
ppt.GrayLevelForPrint = true;
//Set the orientation to Horizontal or Vertical when printing
ppt.OrderForPrint = Order.Horizontal; //Order.Vertical;
//Print multi-slides to one page
ppt.SlideCountPerPageForPrint = PageSlideCountl.Three;

Supports to print the discontinuous slide range.
Code: Select all
Presentation.SelectSlidesForPrint(Params string[])

Adds a new property "SmartArtNode.CoustomText" for specifying whether to customize the text style for SmartArt.
Code: Select all
smartArt.nodes[0].CoustomText = true;

Bug Fixes:
Fixes the issue that caused incorrect format when converting PPTX to PDF.
Fixes the issue that the application hung when loading presentation.
Fixes the issue that the hyperlink lost after converting PPTX to PDF.
Fixes the issue that the content was bad formatted after converting .pptx to .ppt or PDF.
Fixes the issue that the chart series could not be successfully obtained.
Spire.Doc
New Features:
Add a new property "CreateWordBookmarksUsingHeadings" for keeping the Word headings as PDF bookmarks when converting Word to PDF.
Code: Select all
ToPdfParameterList topdf = new ToPdfParameterList();
topdf.CreateWordBookmarks = true;
topdf.CreateWordBookmarksUsingHeadings = true;
doc.SaveToFile(outputFile_PS, topdf);

Bug Fixes:
Fixes the issue that the MergeFIeld could not be correctly updated when it is in the nested IF field.
Fixes the issue that the content was in bad format after setting "SectionBreakType.NoBreak" and then converting to PDF.
Fixes the issue that the image was overlapped after converting Word to PDF.
Fixes the issue that the application threw an exception when saving the Word document to stream with .docx format.
Fixes the issue that the underline format was lost after merging xml documents.
Fixes the issue that the application threw an exception when loading the Word file.
Fixes the issue that the application threw an exception when saving a Word file with the Czech culture.
Fixes the issue that the content of formula field was displaced after merging xml documents.
Fixes the issue that the formula had a bad layout after merging xml documents.
Fixes the issue that the hidden content was wrongly displayed after converting Word to PDF.
Fixes the issue that the eq field content was in bad format after merging xml documents.
Fixes the issue that the justify alignment was not correctly rendered after converting Word to PDF.
Fixes the issue that the double underline format was lost after converting RTF to PDF.
Spire.XLS
New Features:
Supports to set the page size as A6 when converting Excel to PDF.
Code: Select all
sheet.PageSetup.PaperSize = PaperSizeType.PaperA6;

Supports to keep the original cell format after replacing the part of text.
Code: Select all
XlsRange.TextPartReplace(string old, string new);

Bug Fixes:
Fixes the issue that the content was incorrect after converting Excel to HTML.
Fixes the issue that the data was split wrong after converting Excel to CSV.
Fixes the issue that the process threw System.ApplicationException when loading a file.
Fixes the issue that replacing image failed.
Fixes the issue that MS Excel 2007 hint an error when opening the result after adding Pivot table.
Fixes the issue that the process threw ArgumentNullException when loading a file.
Fixes the issue that opening the result file hinted an error after adding header and footer.
Fixes the issue that some part of hyperlink string was missing after converting Excel to HTML.
Fixes the issue that the text was not wrapped properly when converting Excel to PDF.
Fixes the issue that setting partial protection didn't work.

Spire.Office Platinum (DLL Only) Version:4.2.0(2019-02-28)
Dll Version:
Spire.Doc.dll v7.2.6
Spire.Pdf.dll v5.2.12
Spire.XLS.dll v9.2.13
Spire.Email.dll v2.1.6
Spire.DocViewer.Forms.dll v4.1.8
Spire.PDFViewer.Forms.dll v4.2.6
Spire.PDFViewer.Asp.dll v4.2.6
Spire.Presentation.dll v4.2.3
Spire.Spreadsheet v3.1.9
Spire.OfficeViewer.Forms.dll v4.2.0
Spire.Barcode.dll v3.1.1
Spire.DataExport.dll v4.1.3
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.2.13
Spire.License.dll v1.3.7
Spire.Doc
Bug Fixes:
Fixes the issue that the table border was missing after converting Word to PDF.
Fixes the issue that the content was in bad format after merging Word documents.
Fixes the issue that the application threw an exception when loading Word file.
Fixes the issue that the result was null when getting the table title.
Fixes the issue that the LineWidth property did not make any sense when saving to .doc format.
Fixes the issue that the format was missing when using "table.AddRow(true)" to add a row.
Fixes the issue that the table was displaced after converting Word to image.
Fixes the issue that the application hung when loading HTML file.
Fixes the issue that the application threw an exception when loading and resaving a Word file.
Fixes the issue that the application threw an exception when loading an HTML file.
Spire.PDF
New Features:
Supports to convert PDF to PCL.
Code: Select all
PdfDocument pdf = new PdfDocument(input);
pdf.SaveToFile("output.pcl",FileFormat.PCL);

Bug Fixes:
Fixes the issue that the content position was offset after converting PDF to image.
Fixes the issue that when a signed document was loaded and saved or re-signed, “the annotation had been revised” appeared.
Fixes the issue that an exception "The format of input string is not correct" was caused when printing.
Fixes the issue that the caused an exception "NullReferenceException was unhandled" after setting StringFormat for grid cell.
Spire.XLS
New Features:
Some interfaces were adjusted:
Code: Select all
Spire.Xls.Core.Converter.Exporting.EMF.ConverterSetting was adjusted to Spire.Xls..ConverterSetting
Spire.Xls.Core.Converter.Exporting.EMF.PrintingPageType was adjusted to Spire.Xls.PrintingPageType
Spire.Xls.Core.Converter.Exporting.EMF.PageColRow was adjusted to Spire.Xls.PageColRow
Spire.CompoundFile.XLS.XlsDocumentProperty was adjusted to Spire.Xls.XlsDocumentProperty
Spire.CompoundFile.XLS.PropertyType was adjusted to Spire.Xls.PropertyType
Spire.CompoundFile.XLS.Net.IPropertyData was adjusted to Spire.Xls.IPropertyData

Bug Fixes:
Fixes the issue that the application threw an exception when setting the font for a textbox.
Fixes the issue that the result was not correct for "MatchEntireCellContent" mode when finding exactly the same content.
Fixes the issue that the application threw an exception when unprotecting an Excel document.
Fixes the issue that the number format is incorrect after converting Excel to CSV.
Fixes the issue that the application threw an exception when loading an Excel document.
Fixes the issue that the application threw an exception when loading an XML file.
Fixes the issue that an error was prompted when opening the PDF converted from Excel in Adobe.
Fixes the issue that an error prompted when opening the generated .xlsm file converted from .xlsb in Excel.
Fixes the issue that the worksheet tab color changed after loading and resaving an Excel file.
Fixes the issue that the application threw an exception when loading an Excel file or saving the worksheet to image.
Fixes the issue that an error popped up when opening the converted PDF from an .xlsx file in Adobe Reader.
Fixes the issue that the font size was changed when converting an .xlsx file to PDF.
Fixes the issue that the application threw an exception when loading an .xlsx stream on the .net core platform.
Spire.Presentation
New Features:
Add a new method to convert specific slide to SVG.
Code: Select all
byte[] svgByte = ppt.Slides[0].SaveToSVG();

Bug Fixes:
Fixes the issue that the correct data of 3-D Format of chart label could not be obtained.
Fixes the issue that the incorrect data was generated when setting the DataLabelSize for chart date label.
Fixes the issue that the number list type was incorrect after converting html to PPT.
Fixes the issue that setting the DataLabelSize for new added label but didn't take effect.
Spire.PDFViewer
Bug Fixes:
Fixes the issue that there were extra page borders in WPF.

Spire.Office Platinum (DLL Only) Version:4.1.4(2019-02-02)
Dll Version:
Spire.Doc.dll v7.1.20
Spire.Pdf.dll v5.1.36
Spire.XLS.dll v9.1.23
Spire.Email.dll v2.1.5
Spire.DocViewer.Forms.dll v4.1.6
Spire.PdfViewer.Forms.dll v4.1.14
Spire.PdfViewer.Asp.dll v4.1.14
Spire.Presentation.dll v4.1.25
Spire.Spreadsheet v3.1.8
Spire.OfficeViewer.Forms.dll v4.1.4
Spire.DataExport.dll v4.1.0
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.1.22
Spire.License.dll v1.3.7
Spire.Barcode.dll v3.1.1
Spire.XLS
New Features:
Adds a new attribute to add cell link for CheckBox.
Code: Select all
ICheckBox.LinkedCell

Supports .NET Core 2.0.
Bug Fixes:
Fixes the issue that caused an exception when loading Excel.
Fixes the issue that an exception occurred after merging multiple Excel files and while converting the merged file to Pdf.
Fixes the issue that an exception occurred after merging the file which contains image group with another Excel file and while converting the merged file to Pdf.
Fixed the issue that caused extra blank columns after saving .xlsb to .xls.
Spire.Spreadsheet
Bug Fixes:
Fixes the issue that the horizontal positions of added text in cells were not the same.
Spire.Presentation
New Features:
Supports to copy shapes between slides.
Code: Select all
Presentation presentation = new Presentation();
presentation.LoadFromFile(input);
ISlide sourceSlide = presentation.Slides[0];
ISlide targetSlide = presentation.Slides[1];
targetSlide.Shapes.AddShape((Shape)sourceSlide.Shapes[0]);
presentation.SaveToFile(output, FileFormat.Pptx2013);

Bug Fixes:
Fixes the issue that the row height was incorrect after splitting cells.
Spire.PDFViewer
Bug Fixes:
Fixes the issue that the application ran out of memory before opening a PDF file.
Spire.PDF
Bug Fixes:
Fixes the issue that the application threw an exception when extracting text from a PDF document.
Fixes the issue that the text in bold were not displayed correctly after converting PDF to image.
Fixes the issue that the result was a blank page after converting PDF to image.
Fixes the issue that the result was a blank page after converting PDF to XPS.
Fixes the issue that “field.Visible“ property wrongly returned true even it was for the invisible form field.
Spire.Doc
New Features:
Supports to convert Word to PCL.
Code: Select all
Document doc = new Document(inputFile);
doc.SaveToFile("result.pcl", Spire.Doc.FileFormat.PCL);

Bug Fixes:
Fixes the issue that the application hung when converting a word file to images.
Fixes the issue that finding text inside shapes failed.
Fixes the issue that there was extra white space between table rows when converting a word file to PDF.
Fixes the issue that the background image was not displayed when converting a word file to PDF.
Fixes the issue that some content was not formatted correctly when merging word documents
Fixes the issue that images were incorrectly positioned when converting a word file to PDF/images.
User avatar

amy.zhao
 
Posts: 2311
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.DataExport

cron