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:5.5.1(2020-05-22)
Dll Versions:
Spire.Doc.dll v8.5.4
Spire.Pdf.dll v6.5.9
Spire.XLS.dll v10.5.7
Spire.Email.dll v3.3.0
Spire.DocViewer.Forms.dll v5.1.1
Spire.PdfViewer.Forms.dll v5.1.4
Spire.PdfViewer.Asp.dll v5.1.4
Spire.Presentation.dll v5.5.1
Spire.Spreadsheet v4.3.3
Spire.OfficeViewer.Forms.dll v5.5.1
Spire.Barcode.dll v4.5.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v10.5.7
Spire.License.dll v1.3.8

View changes made in this release: https://www.e-iceblue.com/News/spireoffice-551.html

Spire.Office Platinum (DLL Only) Version:5.4.2(2020-04-23)
Dll Versions:
Spire.Doc.dll v8.4.7
Spire.Pdf.dll v6.4.11
Spire.XLS.dll v10.4.9
Spire.Email.dll v3.3.0
Spire.DocViewer.Forms.dll v5.1.1
Spire.PdfViewer.Forms.dll v5.1.4
Spire.PdfViewer.Asp.dll v5.1.4
Spire.Presentation.dll v5.4.2
Spire.Spreadsheet v4.3.3
Spire.OfficeViewer.Forms.dll v5.4.2
Spire.Barcode.dll v4.4.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v10.4.9
Spire.License.dll v1.3.8
New Features:
Supporting MonoAndroid and Xamarin.iOS platforms.
Spire.PDF
Bug Fixes:

Fixes the issue that the application threw an error "The start index is greater than the end index" when merging pdf documents.
Fixes the issue that it failed to update the document properties.
Fixes the issue that the destinations of TOC were not retrieved correctly.
Fixes the issue that the application threw ArgumentException when replacing text.
Fixes the issue that the stamp covered the text when printing PDF.
Fixes the issue that it failed to re-encrypt PDF using different key size.
Fixes the issue that the text position was incorrect when printing PDF.
Fixes the issue that the spaces between words were missing when printing PDF.
Fixes the issue that the application threw NullReferenceException when converting PDF to XPS.
Spire.Doc
Bug Fixes:

Fixes the issue that the formulas were inconsistent when converting the documents contain MathType formulas between doc and docx formats.
Fixes the issue that the application threw an exception when loading a doc file.
Fixes the issue that the content was incorrect when converting Word to PDF.
Spire.Xls
New Features:

Supports showing or not showing subtotals of PivotTable.
Code: Select all
pt.ShowSubtotals = true;
pt.ShowSubtotals = false;

Bug Fixes:
Fixes the issue that the DisplayedText returned the incorrect date format.
Fixes the issue that after converting .xls to .xlsm, the generated .xlsm prompted an error when opening it.
Fixes the issue that it failed to set chart title and the font of chart axis.
Fixes the issue that the application threw an exception when loading Excel on .NET Core 2.2 platform.
Fixes the issue that it caused incorrect content format after converting Excel to image.
Fixes the issue that after converting a sheet which contains a chart (whose data is from a pivot table) to PDF, the data of chart was incorrect.
Fixes the issue that the markerdesigner couldn't copy the correct style.
Fixes the issue that the application threw the exception "InvalidOperationException" when loading an Excel.
Fixes the issue that the formula value could not be calculated correctly.
Fixes the issue that the application threw the "NullReferenceException" when loading an Excel.
Fixes the issue that after merging Excel files, the generated file prompted an error when opening it.
Fixes the issue that after adding filter, the generated file prompted an error when opening it.
Fixes the issue that it caused incorrect content format after converting Excel to PDF.
Fixes the issue that the application threw the "NullReferenceException" when inserting a new row in a copied sheet.
Fixes the issue that it caused incorrect date format after converting Excel to XML.
Fixes the issue that after creating a pivot table, the generated file prompted an error when opening it.
Spire.Presentation
New Features:

Supports Right-to-left columns.
Code: Select all
IAutoShape shape = ppt1.Slides[0].Shapes[0] as IAutoShape;
shape.TextFrame.RightToLeftColumns = true;

Supports drawing line segments by the position of two points.
Code: Select all
ppt.Slides[0].Shapes.AppendShape(ShapeType.Line, new PointF(10, 10), new PointF(20, 30));

Bug Fixes:
Fixes the issue that it failed to open output document when converting PPT to PDF.
Spire.OfficeViewer
Bug Fixes:

Fixes the issue that setting the SmallChange property of scroll bar didn't take effect.
Spire.Spreadsheet
New Features

Supports custom sorting.
Code: Select all
var range = spreadsheet.Worksheets[0].GetSelectedRange();
//Start from 0, 1 means the second column in the range
int sortIndexs = new int[]{1,};
var sortOrders = new Forms.SortOrder[]{ Forms.SortOrder.Descending };
range.Sort(sortIndexs, sortOrders, SortOrientation.Vertical, false);

Bug Fixes:
Fixes the issue that the application threw exception when loading an excel file.
Fixes the issue that the events of KeyDown and PreviewKeyDown didn't take effect.

Spire.Office Platinum (DLL Only) Version:5.3.7(2020-03-26)
Dll Versions:
Spire.Doc.dll v8.3.15
Spire.Pdf.dll v6.3.11
Spire.XLS.dll v10.3.8
Spire.Email.dll v3.3.0
Spire.DocViewer.Forms.dll v5.1.1
Spire.PdfViewer.Forms.dll v5.1.4
Spire.PdfViewer.Asp.dll v5.1.4
Spire.Presentation.dll v5.3.6
Spire.Spreadsheet v4.3.1
Spire.OfficeViewer.Forms.dll v5.3.7
Spire.Barcode.dll v4.1.1
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v10.3.8
Spire.License.dll v1.3.8
Spire.Doc
Bug Fixes:
Fixes the issue that the content format was incorrect when converting Word to PDF.
Fixes the issue that the application threw an error "This is not a structured storage file".
Fixes the issue that the application threw an error "Object reference not set to an instance of an object" when saving to stream.
Fixes the issue that the application threw System.ArgumentOutOfRangeException when converting doc to xps.
Fixes the issue that the application threw System.FormatException when loading an HTML file.
Fixes the issue that the split cells lost the original style.
Fixes the issue that the content was incorrect when converting Word to PDF.
Fixes the issue that the application threw FormatException when updating TOC.
Fixes the issue that the TOC content was incorrect after updating TOC.
Fixes the issue that the application hung when updating the merged field including "=SUM(a1,a2)" formula.
Fixes the issue that the hyperlink to the image inside it was changed after cloning paragraph.
Fixes the issue that the application threw System.ArgumentException when converting Word to PDF.
Fixes the issue that extra text was extracted when extracting text.
Fixes the issue that the application threw System.ArgumentOutOfRangeException when loading a doc file.
Spire.PDF
New Features
Supports setting subjects for newly-created PdfFreeTextAnnotation.
Code: Select all
RectangleF rectangle = new RectangleF(0, 150, 100, 30);
PdfFreeTextAnnotation textAnnotation = new PdfFreeTextAnnotation(rectangle);
textAnnotation.Text = "Spire.PDF";
textAnnotation.Subject = "test";

Bug Fixes:
Fixes the issue that the bookmark containing "-" was not displayed correctly.
Fixes the issue that text couldn't be matched using regular expressions.
Fixes the issue that application threw ArgumentException when converting pdf to image.
Fixes the issue that the count of form fields read was incorrect.
Fixes the issue that the bookmark containing "" was not displayed correctly.
Fixes the issue that it failed to save document after setting custom information.
Spire.Presentation
Bug Fixes:

Fixes the issue that the application threw NullReferenceException when loading a PPTX file.
Fixes the issue that the application threw NullReferenceException when adding hyperlink to SmartArt node.
Fixes the issue that after copying the slides to the new PPSX document, a dialog box showing "Whether the contents are saved or not" popped up when opening document.
Fixes the issue that the images were missing when converting PPT to PDF.
Fixes the issue that the application threw ArgumentException when loading a PPTX file.
Fixes the issue that the [br] tag was not parsed correctly.
Spire.XLS
New Features:
Supports setting chart marker's border weight.
Code: Select all
chart.Series[0].DataFormat.MarkerBorderWeight = 2.5; //the unit is pt   

Supports calculating SUBTOTAL formula.
Bug fixes:
Fixes the issue that it failed to open output excel after setting time data validity.
Fixes the issue that the value of the chart pointer was lost when creating a meter chart.
Fixes the issue that it failed to set conditional format of the date.
Fixes the issue that it failed to remove hyperlinks of text.
Fixes the issue that it failed to set page order type.
Fixes the issue that it failed to unlock the protected worksheet.
Fixes the issue that it failed to hide/show sheet tab.
Fixes the issue that the incorrect version of the excel document was detected.
Fixes the issue that the coordinate axis value was incorrect when converting PivotChart to images.
Fixes the issue that the alignment of text was incorrect when converting excel to pdf.
Fixes the issue that the data source of chart was incorrect after using CopyFrom() method to copy sheet including a chart.
Fixes the issue that formula value was incorrect after calculating formula.
Fixes the issue that it failed to set the order of PivotTable fields.

Spire.Office Platinum (DLL Only) Version:5.3.1(2020-03-10)
Dll Versions:
Spire.Doc.dll v8.3.3
Spire.Pdf.dll v6.3.0
Spire.XLS.dll v10.3.0
Spire.Email.dll v3.3.0
Spire.DocViewer.Forms.dll v5.1.1
Spire.PdfViewer.Forms.dll v5.1.4
Spire.PdfViewer.Asp.dll v5.1.4
Spire.Presentation.dll v5.2.1
Spire.Spreadsheet v4.1.0
Spire.OfficeViewer.Forms.dll v5.3.1
Spire.Barcode.dll v4.1.1
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v10.3.1
Spire.License.dll v1.3.8
Spire.PDF
Bug Fixes:

Fixes the issue that the text was not highlighted correctly.
Fixes the issue that it was slow to search text when there is no text to be found on the page.
Fixes the issue that characters were changed when printing PDF.
Fixes the issue that the math formula was incorrect when printing PDF.
Fixes the issue that it didn’t work to set the page rotation property as PdfPageRotateAngle.RotateAngle0.
Fixes the issue that there was no Get property for PdfDocumentLinkAnnotationWidget.Destination.
Fixes the issue that the image with opacity was missing after printing PDF.
Fixes the issue that there were additional lines when dragging the generated PdfFreeTextAnnotation in the software BlueBeam.
Fixes the issue that images were not filled correctly after setting IconLayout for button field.
Fixes the issue that the content was changed after getting page and saving the file which includes the annotation with FileAttachment.
Fixes the issue that the property PdfTextWebLinkAnnotationWidget.Location always returned 0.
Spire.Doc
Bug Fixes:

Fixes the issue that the content format was incorrect when converting Word to PDF.
Fixed the issue that the filled value of Mail Merge field was incorrect.
Fixed the issue that the blank page was lost when converting Word to PDF.
Fixed the issue that the header content format was incorrect after saving a Word document.
Fixed the issue that the check box cannot be checked after saving a Word document.
Fixes the issue that the application hung when converting Word to PDF.
Fixes the issue that a word was split into two lines after converting Word to PDF.
Fixes the issue that line breaks were inconsistent after converting Word to PDF.
Fixes the issue that the space between two columns was increased after converting Word to PDF.
Spire.XLS
Bug Fixes:

Fixes the issue that the method sheet.AutoFilters.MatchNonBlanks didn't work.
Fixes the issue that the scale of images became smaller after adding images in chart.
Fixes the issue that the application threw the NullReferenceException when setting gradient for background.
Fixes the issue that the result was wrong after using MarkerDesigner function to copy cell style.
Fixes the issue that the result was incorrect after deleting the border of text box.
Fixes the issue that the color of comment changed from blue to yellow after saving the file.
Fixes the issue that the format was incorrect after converting Excel to PDF.
Fixes the issue that there were extra white borders after converting Excel to PDF.
Fixes the issue that the content was missing after converting Excel to PDF.
Fixes the issue that the alignment of chart title was incorrect after converting Excel to PDF.
Fixes the issue that category axis of chart was incorrect after converting Excel to PDF.
Fixes the issue that the result file hinted an error when opening after using the method SaveToHttpResponse to save to .xlsx file format file.
Fixes the issue that the text color of data label was not set successfully.
Fixes the issue that it failed to get trend line formula.
Fixes the issue that the cell width was inconsistent when converting XLS to HTML.
Fixes the issue that application threw NullReferenceException when loading CSV document.
Fixes the issue that it failed to get the value of formula.
Fixes the issue that the brackets were not formatted correctly when converting XLS to PDF.
Spire.Presentation
New features:
Supports adding hyperlinks to SmartArt node.
Code: Select all
if (shape is ISmartArt)
{ //Get the SmartArt
  ISmartArt smartArt = shape as ISmartArt;
  ISmartArtNode node = smartArt.Nodes[0];
  node.Click = new ClickHyperlink(presentation.Slides[0]);
  //node.Click = new ClickHyperlink("https://www.e-iceblue.com");
}

Supports assigning a unique identifier to each shape when converting PPT to HTML.
SaveToHttpResponse method supports PPSX documents.
Bug Fixes:
Fixes the issue that chart had extra lines when converting PPT to PDF.
Fixes the issue that rotation angle of chart data labels was incorrect when converting PPT to PDF.
Fixes the issue that layout of chart lines was incorrect when converting PPT to PDF.
Fixes the issue that application threw an error "Not an Open Office presentation" when loading ODP documents.
Spire.Email
Bug Fixes:
Fixes the issue that it could not create emails with more than 3 attachments. There was no limitation on the number of attachments after applying license.
Fixes the issue that it only retained 3 attachments when converting EML to MSG files. There was no limitation on the number of attachments after applying license.

Spire.Office Platinum (DLL Only) Version:5.2.0(2020-02-12)
Dll Version:
Spire.Doc.dll v8.2.4
Spire.Pdf.dll v6.2.1
Spire.XLS.dll v10.1.8
Spire.Email.dll v3.1.0
Spire.DocViewer.Forms.dll v5.1.1
Spire.PdfViewer.Forms.dll v5.1.4
Spire.PdfViewer.Asp.dll v5.1.4
Spire.Presentation.dll v5.1.3
Spire.Spreadsheet v4.1.0
Spire.OfficeViewer.Forms.dll v5.2.0
Spire.Barcode.dll v4.1.1
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v3.2.2
Spire.License.dll v1.3.8
Spire.PDF
Bug Fixes:
Fixes the issue that the application threw OutOfMemoryException when loading a PDF file.
Fixes the issue that the font was not automatically adjusted after filling a value to the Textbox which was set multi-line properties.
Fixes the issue that there was extra content after flattening a PDF file.
Fixes the issue that the merged result was blank after merging files.
Fixes the issue that the watermark and image were not added successfully in a file.
Fixes the issue that the fill color of textbox was not set as "No Color".
Fixes the issue that the method ApplyHighLight didn't work for a file.
Fixes the issue that the drawing text overlapped when adding string “\n” in PdfGridCellContentList.
Fixes the issue that the application threw NullReferenceException when converting PDF to image.
Fixes the issue that the generated barcode returned an extra character “D” at the end of actual data when scanning.
Spire.Doc
Bug Fixes:
Fixes the issue that the application threw an exception "An object reference is not set to an object instance" when cloning document.
Fixes the issue that table spans was incorrect when converting Word to PDF(SPIREDOC-3701)
Fixes the issue that numbers were missing when converting Word to SVG(SPIREDOC-3795)
Fixes the issue that the generated paragraph list number was incorrect.(SPIREDOC-3805)
Fixes the issue that the application threw an exception"The argument cannot be null or empty string."when saving document after adding a watermark (SPIREDOC-3819)
Fixes the issue that the images lost when converting Word to PDF(SPIREDOC-3828)
Fixes the issue that the content was incorrect when converting Word to PDF(SPIREDOC-3829)
Fixes the issue that it failed to embed fonts when converting Word to PDF(SPIREDOC-3840)
Fixes the issue that it failed to save document after removing section breaks.(SPIREDOC-3842)
Fixes the issue that the content is not properly formatted when converting Word to PDF.(SPIREDOC-3846)
Fixes the issue that table row became high when converting Html to PDF.(SPIREDOC-3853)
Fixes the issue that the application threw an exception"Object reference is not set to an instance of the object" when loading a document.(SPIREDOC-3874)
Fixes the issue that it failed to save documents after cloning ShapeGroup objects (SPIREDOC-3878)
Fixes the issue that the total pages content was lost when converting Word to PDF(SPIREDOC-3891)
Spire.XLS
New features:
Support to format the data of the trend line.
Code: Select all
trendLine.DataLabel.NumberFormat = "#, ## 0.000";

Bug Fixes:
Fixes the issue that adding a hyperlink to a cell failed.
Fixes the issue that the formula was missing when adding a trend line to a chart.
Fixes the issue that the application threw ArgumentOutOfRangeException when loading an xlsm document.
Fixes the issue that the content was incorrect when converting an xlsx document to PDF.
Fixes the issue that the text in generated xlsx document was wrapped .
Spire.PdfViewer
New features:
Supports catching the exception which was thrown by PDFViewer when rendering pages.
Code: Select all
this.pdfViewer1.OnRenderPageExceptionEvent += MyException;
public void MyException(PdfViewerExceptions agrs)
{
 this.pdfViewer1.OnRenderPageExceptionEvent -= MyException;
}

Bug Fixes:
Fixes the issue that some content was missing when viewing a PDF file.

Spire.Office Platinum Version:5.1(2020-01-14)
Dll Version:
Spire.Barcode.dll 4.1.0
Spire.Common.dll 3.1.3
Spire.DataExport.dll 4.1.9
Spire.Email.dll 3.1.0
Spire.Doc.dll 8.1.3
Spire.DocViewer.Forms.dll 5.1.1
Spire.Pdf.dll 6.1.4
Spire.PdfViewer.Asp.dll 5.1.1
Spire.PdfViewer.Forms.dll 5.1.1
Spire.XLS.dll 10.1.1
Spire.Presentation.dll 5.1.3
Spire.Spreadsheet.dll 4.1.0
Spire.OfficeViewer.Forms.dll 5.1.1
Spire.License.dll 1.3.8
Spire.Spreadsheet
Bug Fixes:
Fixes the issue that the content displayed incorrectly when viewing a document.
Fixes the issue that the bold text was cut when viewing a document.
Fixes the issue that some text was missing when the text in the cell is too long.
Fixes the issue that the columns were missing after minimizing and then restoring the form.
Spire.XLS
New Features:
Supports converting entire workbook to Html.
Code: Select all
Workbook.SaveToHtml(string fileName);

Supports setting copy options when copying.
Code: Select all
CopyRangeOptions copyOptions = CopyRangeOptions.OnlyCopyFormulaValue;
CellRange.Copy(destRange, copyOptions);
WorkSheet.Copy(sourceRange, destRange, copyOptions);

Bug Fixes:
Fixes the issue that the Bubble chart cannot be created.
Fixes the issue that the application threw KeyNotFoundException when removing styles.
Fixes the issue that the content was incorrect after converting Excel to PDF.
Fixes the issue that the application threw OverflowException when loading a file.
Fixes the issue that the content was missing after converting Excel to PDF.
Fixes the issue that the leading 0 of the text was missing when using Marker Designer function.
Spire.PDF
New Features:
Supports getting and setting author and creation date of stamp.
Code: Select all
stamp.Author = "E-iceblue";
stamp.CreationDate = DateTime.Now;

Supports getting the value of PrinterResolutionKind.
Code: Select all
PdfPrinterResolutionKind value = doc.PrintSettings.PrinterResolutionKind;

Supports getting the button style of RadioButton.
Code: Select all
PdfDocument doc = new PdfDocument(@"..\toPDF.pdf");
PdfFormWidget formWidget = doc.Form as PdfFormWidget;
for (int i = 0; i < formWidget.FieldsWidget.List.Count; i++)
{
PdfField field = formWidget.FieldsWidget.List[i] as PdfField;
if (field is PdfRadioButtonListFieldWidget)
{
PdfRadioButtonListFieldWidget radio = field as PdfRadioButtonListFieldWidget;
PdfCheckBoxStyle buttonStyle = radio.ButtonStyle;
}
}

Bug Fixes:
Fixes the issue that the text extracted from PDF was incorrect.
Fixes the issue that caused large memory consumption when finding text.
Fixes the issue that after signing PDF in .NET Core application, the application threw the "lost private key" exception when saving the signed PDF.
Fixes the issue that the speed of conversion from PDF to Word was slow.
Fixes the issue that caused incorrect content after converting PDF to Word.
Fixes the issue that caused incorrect content after converting XPS to Word.
Fixes the issue that the application threw the "An object reference is not set to an object instance" when extracting text from PDF.
Fixes the issue that the application threw the "Index was outside the bounds of the array" when saving PDF pages to images.
Fixes the issue that the content filled in form field didn't display in browser.
Fixes the issue that the annotation can't be added in the location of image.
Fixes the issue that caused incorrect format of centered text in textbox after flattening form fields.
Fixes the issue that after filling textbox field, the generated PDF prompted "This document enabled extended features in Adobe Acrobat." when opening in Adobe.
Fixes the issue that the height property of bounds of text was negative value.
Fixes the issue that the application threw the "ArguementException" when printing PDF.
Spire.Doc
Bug Fixes:
Fixes the issue that the right margin of the page increased after converting Word to PDF.
Fixes the issue that the format was incorrect after converting Word to PDF.
Fixes the issue that the result file cannot be opened after cleaning the section breaks in Word file.
Fixes the issue that the text overlapped after converting Word to PDF.
Fixes the issue that the application threw ArgumentException when converting Word to PDF.
Fixes the issue that the result file cannot be opened after merging files.
Fixes the issue that the shape was missing after adding a shape in created file and converting to image.
Fixes the issue that the bullets were wrong after converting Word to PDF.
Fixes the issue that the application threw NullReferenceException when converting Word to PDF.
Fixes the issue that the format of content was incorrect after converting Word to image.
Fixes the issue that the fields updated incorrectly after converting Word to PDF.
Fixes the issue that the result file cannot be opened after merging files.
Fixes the issue that the application threw NullReferenceException when converting Word to image.
Spire.Presentation
New Features:
Supports getting and setting the name of the slide
Code: Select all
String title = ppt.Slides [0] .Title;

Bug Fixes:
Fixes the issue that the format was incorrect when converting PPT documents to PDF documents.
Fixes the issue that the content position was inconsistent when converting PPT documents to PDF documents.
Fixes the issue that the coordinate axis data lost when converting PPT documents to PDF documents.
Fixes the issue that the data label position was incorrect when converting PPT documents to PDF documents.
Fixes the issue that the rounded rectangle style of the data label was lost when converting PPT documents to PDF documents.
Spire.DocViewer
Bug Fixes:
Fixes the issue that the program hanged when opening a Doc document.
Fixes the issue that text moved up.
Fixes the issue that it threw an error "value cannot null" when loading a Docx document.
Spire.PDFViewer
Bug Fixes:
Fixes the issue that the numbers and punctuation in documents were replaced by small boxes.
Fixes the issue that document content lost.

Spire.Office Platinum (DLL Only) Version:4.12.6(2019-12-20)
Dll version:
Spire.Doc.dll v7.12.23
Spire.Pdf.dll v5.12.16
Spire.XLS.dll v9.12.20
Spire.Presentation.dll v4.12.13
Spire.Email.dll v2.11.11
Spire.DocViewer.Forms.dll v4.5.29
Spire.PdfViewer.Forms.dll v4.12.9
Spire.PdfViewer.Asp.dll v4.12.9
Spire.Spreadsheet.dll v3.12.1
Spire.OfficeViewer.Forms.dll v4.12.6
Spire.Barcode.dll v3.12.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.12.13
Spire.License.dll v1.3.8

Spire.XLS
New Features:
Supports retaining the filtered data when converting Excel to CSV.
Code: Select all
worksheet.SaveToStream (Stream stream, string separator, bool retainHiddenData);
workbook.SaveToFile(string fileName,FileFormat fileFormat , bool retainHiddenData);
worksheet.SaveToFile(string fileName, string separator , bool retainHiddenData);

Bug Fixes:
Fixes the issue that setting the row height using the values that are stored in a dynamic list didn't take effect in Excel file.
Fixes the issue that the formula "=COUNTIF(Q2:Q1839,\"New South Wales\") " could not be calculated successfully.
Fixes the issue that the application threw the exception "An item with the same key has been added" when loading an Excel.
Fixes the issue that getting the AlternativeTextTitle of picture returned null.
Fixes the issue that incorrect chart format was caused after converting Excel to PDF.
Fixes the issue that the application threw the exception "ArgumentOutOfRangeException" when getting the ChartSheet.
Fixes the issue that messy content was caused after converting Excel to PDF.
Fixes the issue that using the method pivotTable.DataFields.Clear() to clear the data fields of pivot table didn't take effect.
Fixes the issue that the drop-down box was missed.
Fixes the issue that the worksheet.IsEmpty returned incorrect results.
Fixes the issue that it threw the exception "the object reference was not set to the object instance" when loading an Xlsx file.
Fixes the issue that the worksheet.IsPasswordProtected returned incorrect results.
Fixes the issue that the content was incorrect when converting from Excel to PDF.
Fixes the issue that the speed was slow when using Filter() method to filter.
Fixes the issue that it threw the exception “ArgumentOutOfRangeException” when loading an Xlsm file.
Fixes the issue that it threw the exception “The specified parameter has exceeded the range of valid value “when copying a sheet by using the workbook.Worksheets. AddCopy (sheet) method.
Fixes the issue that the image was shrunk when converting Excel to PDF.
Fixes the issue that it threw “XmlException” when loading an Xlsx file.
Fixes the issue that the content was missed when converting from an Xlsm file to PDF.
Fixes the issue that the additional content appeared when converting an Xlsx file to PDF.
Spire.Presentation
New Features:
Adds ReplaceFirstText and ReplaceAllText methods to replace text.
Code: Select all
ReplaceFirstText(string matchedString, string newValue, bool caseSensitive);
ReplaceAllText(string matchedString, string newValue, bool caseSensitive);

Supports setting the rotation angle of the chart title.
Code: Select all
chart.ChartTitle.TextProperties.RotationAngle=-30;

Supports highlighting the specified text.
Code: Select all
IAutoShape shape=ppt.Slides[0].Shapes[0] as IAutoShape
TextHighLightingOptions options=new TextHighLightingOptions();
options.CaseSensitive =true;
options.WholeWordsOnly=true;
shape.TextFrame.HightLightText("text",Color.Red,options);

Supports setting the type of the coordinate axis.
Code: Select all
chart.PrimaryCategoryAxis.AxisType = Spire.Presentation.Charts.AxisType.DateAxis;
chart.PrimaryCategoryAxis.MajorUnitScale = ChartBaseUnitType.Months;

Supports setting "until end of slide" for animation timing.
Code: Select all
effect.Timing.AnimationRepeatType = AnimationRepeatType.UtilEndOfSlide;

Bug Fixes:
Fixes an issue that loading an encrypted pptx document failed.
Fixes an issue that converting PPT containing video to Html failed.
Fixes an issue that using the method AddNodeByPosition to insert a new node at the specified SmartArt node location failed.
Fixes an issue that copying chart in the same PPT file failed.
Fixes an issue that setting additional information in PPT to show or hide failed.
Fixes an issue that IsVaryColor property was invalid.
Fixes an issue that the size of the table included in the slide also became larger after increasing the size of the slide.
Fixes the issue that the date format was incorrect after the setting chart category axis.
Fixes the issue that the content format was incorrect after converting PPT(X) to PDF.
Fixes the issue that the color series were incorrect after converting PPT(X) to PDF.
Fixes the issue that the exception appeared when adding Html to shapes.
Fixes the issue that the rotation of DataLabels didn’t remain after converting PPT(X) to PDF.
Fixes the issue that there was the exception "NullReferenceException" when reading the table height.
Fixes the issue that there was the exception "IndexOutOfRangeException" when adding Html.
Fixes the issue that the content was lost after converting PPT(X) to PDF.
Spire.PDF
New Features:
Supports setting Tab Order.
Code: Select all
doc.FileInfo.IncrementalUpdate = false;
PdfPageBase page = doc.Pages[0];
page.SetTabOrder(TabOrder.Structure);

Supports expanding or collapsing specific bookmark.
Code: Select all
doc.Bookmarks[1].ExpandBookmark = true;
(doc.Bookmarks[0] as PdfBookmarkCollection)[0].ExpandBookmark = true;

Supports getting the font information of the extracted text.
Code: Select all
PdfTextFindCollection text = pdf.Pages[0].FindAllText();
foreach (var font in text.Finds)
{
string fontName = font.FontName ;
}

Supports printing to booklet.
Code: Select all
doc.PrintSettings.SelectBookletLayout();
doc.PrintSettings.SelectBookletLayout(PdfBookletSubsetMode bookletSubset);
doc.PrintSettings.SelectBookletLayout(PdfBookletBindingMode bookletBinding);
doc.PrintSettings.SelectBookletLayout(PdfBookletSubsetMode bookletSubset, PdfBookletBindingMode bookletBinding);

Supports setting the image to fill the button field area.
Code: Select all
pdfButtonField.IconLayout.ScaleMode = PdfButtonIconScaleMode.Anamorphic;

Bug Fixes:
Fixes the issue that the application threw ArgumentException when extracting text from page.
Fixes the issue that the format was wrong after converting PDF to Word.
Fixes the issue that there were extra blank pages after merging PDF files.
Fixes the issue that the position of the signature was incorrect after signing.
Fixes the issue that the application threw NullReferenceException when encrypting PDF file.
Fixes the issue that stamp size was incorrect after creating template.
Fixes the issue that the layer content was still visible after removing the layer.
Fixes the issue that the content was missing after converting PDF to TIFF.
Fixes the issue that the print result was incorrect after selecting booklet layout.
Fixes the issue that the order of extracting PDF text content is incorrect.
Fixes the issue that it threw “KeyNotFoundException” when converting PDF to image.
Fixes the issue that the words at the end of text were truncated when drawing long text.
Fixes the issue that it threw “FormatException” when printing PDF.
Fixes the issue that the content was lost when converting PDF to image.
Fixes the issue that it threw the error "Object reference is not set to an object instance" when setting fonts.
Fixes the issue that the file content could not be copied when converting XPS to PDF
Fixes the issue that the printed document was garbled
Fixes the issue that the process threw KeyNotFoundException when converting PDF to image
Fixes the issue that getting pdf page failed
Fixes the issue that adding digital signature failed
Fixes the issue that the process threw IndexOutOfRangeException when extracting text
Fixes the issue that the printed PDF document content was disorder.
Fixes the issue that the content was incorrect when converting XPS to PDF.
Spire.Doc
New Features:
Supports changing the checkbox state symbol.
Code: Select all
sdtCheckBox.CheckedStateFontName = "Calibri";
sdtCheckBox.CheckedStateCharacterCode = 8730;
sdtCheckBox.UnCheckedStateFontName = "Calibri";
sdtCheckBox.UnCheckedStateCharacterCode = 9675;

Supports inserting gutter.
Code: Select all
section.PageSetup.Gutter = 100f;

Bug Fixes:
Improves the speed of Word to PDF conversion
Fixes the issue that the content was missing after converting Word to PDF/A-1a.
Fixes the issue that the layout of result PDF was incorrect after converting Word to PDF.
Fixes the issue that application threw the ArgumentOutOfRangeException when saving to PDF after replacing text.
Fixes the issue that the font in result file was showed incorrectly in LibreOffice after converting to ODT file.
Optimizes the Garbage disposal.
Fixes the issue that the application threw KeyNotFoundException when saving file.
Fixes the issue that the text was overlapped after converting Word to PDF.
Fixes the issue that the direction of Arabic text changed after converting Word to PDF.
Fixes the issue that the application threw the ArgumentOutOfRangeException when converting HTML to Word.
Optimizes the speed of converting a Word file to PDF.
Fixes the issue that the application threw NullReferenceException when loading a Word file.
Fixes the issue that the tag was lost after converting Word to HTML.
Fixes the issue that the application threw IndexOutOfRangeException when converting a Word file to PDF stream.
Fixes the issue that the application threw NotSupportedException when replacing bookmark content.
Fixes the issue that the content was lost after converting Word to PDF.
Fixes the issue that the application threw NullReferenceException when converting Word to PDF.
Fixes the issue that filling data could not be obtained after executing mail merge function
Fixes the issue that the text overlapped after adding header and footer
Spire.SpreadSheet
New Features:
Adds ClearStack () method to clear records.
Code: Select all
private void button1_Click(object sender, EventArgs e)
{
 this.spreadsheet1.LoadFromFile(@"test.xlsx");
this.spreadsheet1.ClearStack();
}

Bug Fixes:
Fixes the issue that some border lines were missing when viewing a document.
Fixes the issue that the obtained value is incorrect after formatting the cell.
Fixes the issue that content displayed repeatedly when the data content exceeds the cell length

Spire.Office Platinum (DLL Only) Version:4.11.1(2019-11-19)
Dll version:
Spire.Doc.dll v7.11.3
Spire.Pdf.dll v5.11.8
Spire.XLS.dll v9.11.9
Spire.Presentation.dll v4.11.3
Spire.Email.dll v2.9.5
Spire.DocViewer.Forms.dll v4.5.17
Spire.PdfViewer.Forms.dll v4.11.9
Spire.PdfViewer.Asp.dll v4.11.9
Spire.Spreadsheet.dll v4.11.3
Spire.OfficeViewer.Forms.dll v4.11.1
Spire.Barcode.dll v3.7.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.9.56
Spire.License.dll v1.3.7
Spire.PDF
Fixes bugs:
Fixes the issue that the content was incomplete after saving PDF to images.
Fixes the issue that the application threw the NullReferenceException when creating a stamp.
Fixes the issue that the application threw the StackOverflowException when printing a PDF file.
Fixes the issue that some characters changed to "\r\n" when calling the code bookmark.Title.
Fixes the issue that the result of some pages were blank after printing a PDF file.
Fixes the issue that the data from xfdf file could not be imported into PDF.
Fixes the issue that the content was blank after printing.
Spire.PdfViewer
New features:
Supports filling form fields.
Code: Select all
this.pdfViewer1.FormFillEnabled = true;

Fixes bugs:
Fixes the issue that the values of text boxes were not displayed correctly when viewing a PDF file.
Fixes the issue that the text were not displayed correctly when viewing a PDF file.
Fixes the issue that the text were not displayed correctly when viewing a PDF file.
Fixes the issue that fonts were incorrectly when viewing a PDF file.
Fixes the issue that the application threw the exception " 'offset' parameter value cannot be NaN" when viewing a PDF file.
Fixes the issue that the event ZoomChanged didn't work when viewing a PDF file.
Fixes the issue that the application threw the ArgumentException when viewing a PDF file with a large image inside.
Fixes the issue that the property ZoomFactor cannot set the value in WPF platform.
Spire.XLS
Fixes bugs:
Fixes the issue that the xlsm converted from xltm hinted an error when opened in MS Excel.
Fixes the issue that the application threw an exception "Value was either too large or too small for an unsigned byte" when loading an Excel file.
Fixes the issue that after inserting an image in Excel, the image lost when opening the generated Excel in LibreOffice.
Fixes the issue that the format of table lost after converting sheet to image.
Fixes the issue that caused incorrect content after converting Excel to PDF.
Fixes the issue that casued inforrect content after converting sheet to html.
Spire.Doc
Fixes bugs:
Fixes the issue that the Word document converted from RTF could not be opened in Office Online Server (2016).
Fixes the issue that caused incorrect table cells after spliting a table.
Fixes the issue that caused incorrect line spacing after merging Word documents.

Spire.Office Platinum (DLL Only) Version:4.10.0(2019-10-31)
Dll version:
Spire.Doc.dll v7.10.7
Spire.Pdf.dll v5.10.11
Spire.XLS.dll v9.10.18
Spire.Presentation.dll v4.10.4
Spire.Email.dll v2.9.3
Spire.DocViewer.Forms.dll v4.5.15
Spire.PdfViewer.Forms.dll v4.10.3
Spire.PdfViewer.Asp.dll v4.10.3
Spire.Spreadsheet.dll v3.10.1
Spire.OfficeViewer.Forms.dll v4.10.0
Spire.Barcode.dll v3.7.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.9.20
Spire.License.dll v1.3.7
Spire.PDF
New Features:
Supports extracting embedded U3D model from .PDF to .U3D file.
Code: Select all
PdfAnnotationCollection annot = doc.Pages[0].AnnotationsWidget;
int count = 0;
for (int i = 0; i < annot.Count; i++)
{
    if (annot[i] is Pdf3DAnnotation)
    {
          Pdf3DAnnotation annot3D = annot[i] as Pdf3DAnnotation;
          byte[] bytes = annot3D._3DData;
          if (bytes != null)
              {
                  File.WriteAllBytes(String.Format("result-{0}.u3d", count), bytes);
                  count++;
              }   
     }
}

Adds the IsNewWindow property to open cross-document in new window.
Code: Select all
//Open file in new window
launchAction.IsNewWindow = true;
//Open file in current window
launchAction.IsNewWindow = false;

Bug Fixes:
Fixes the issue that the gradient was incorrect after converting XPS to PDF.
Fixes the issue that the data was not showed after filling form fields.
Fixes the issue that the result was blank after printing.
Fixes the issue that the application threw the NullReferenceException when converting PDF to images.
Fixes the issue that the application threw the NullReferenceException when executing pdfDocument.InsertPage(pdf, 0) method.
Fixes the issue that the location of polygon annotation could not be obtained correctly.
Fixes the issue that caused incorrect content after encrypting PDF document.
Fixes the issue that caused incorrect location after inserting pages by index.
Fixes the issue that the text lost after converting XPS to PDF.
Fixes the issue that failed to find text.
Fixes the issue that the application threw the exception "No object reference was set to the object instance" when getting PDF form.
Fixes the issue that the application threw the exception "No object reference was set to the object instance" when extracting PDF attachment.
Spire.Presentation
Bug Fixes:
Some optimizations have been made for the time to save PPTX on the Windows10.
Fixes the issue that caused the exception "Index was out of range" when saving PPTX on .NET Core application.
Fixes the issue that caused incorrect content format after converting PPT to PDF.
Fixes the issue that caused the exception "Error reading tags" when loading PPT file.
Spire.XLS
New Features:
Adds two parameters"horizontal:right_to_left" and "vertical:bottom_to_top" for Marker Designer to set orientation when inserting data.
Code: Select all
//add in original file, the data will be inserted from the bottom to the top in vertical orientation.
&=Country.Capital(vertical:bottom_to_top,add:styles)
// add in original file, the data will be inserted from the right to the left in horizontal orientation.
&=Country.Capital(horizontal:right_to_left,add:styles)

Bug Fixes:
Fixes the issue that there were empty additional columns after saving .xls to .xlsx.
Fixes the issue that the content was cut off after converting Excel to PDF.
Fixes the issue that the application threw the NullReferenceException when loading a .xlsx file.
Fixes the issue that the application threw an exception when converting an Excel file which contains Pivot Table to PDF or HTML.
Fixes the issue that the number format and the rules of conditional formatting were wrong after converting an Excel file which contains Pivot Table to PDF or HTML.
Fixes the issue that the application threw XmlException when loading an Excel file.
Fixes the issue that the links placed in the pictures were missing after converting Excel to PDF.
Fixes the issue that there were extra blank columns after converting .xlt to .xlsx file.
Fixes the issue that the application threw OverflowException when loading a .xlsm file.
Spire.SpreadSheet
Adjustment:
Adjusts that the Locked property of the cell in which the initialized SpreadSheet is changed from false to true by default.
Bug Fixes:
Fixes the issue that only the last sheet tab is displayed when dragging horizontal bar.
Fixes the issue that all sheet tabs still are not displayed completely when the SpreadSheet window is wide enough.
Spire.Doc
New Features:
Supports to get and set emphasis mark.
Code: Select all
TextRange.CharacterFormat.EmphasisMark

Bug Fixes:
Fixes the issue that format was incorrect after converting Word to PDF.
Fixes the issue that the content of TOC was missing after using the code doc.UpdateTableOfContents.
Fixes the issue that the height of table was reduced after converting Word to PDF.
Fixes the issue that the table border was incomplete after merging cells and converting to PDF.
Fixes the issue that the application threw the InvalidOperationException when converting Word to PDF.
Fixes the issue that the macros were not removed successfully.
Fixes the issue that the content was missing after converting Word to PDF.
Fixes the issue that the font color changed after converting Word to PDF.
Fixes the issue that the application threw the IndexOutOfRangeException when loading a Word file.
Fixes the issue that the application threw the OutOfMemoryException when loading a Word file.
Fixes the issue that the application threw the NullReferenceException when converting Word to image.
Fixes the issue that caused incorrect alignment after doing mail merge.

Spire.Office Platinum (DLL Only) Version:4.9.2(2019-09-30)
Dll version:
Spire.Doc.dll v7.9.10
Spire.Pdf.dll v5.9.17
Spire.XLS.dll v9.9.16
Spire.Presentation.dll v4.9.6
Spire.Email.dll v2.9.2
Spire.DocViewer.Forms.dll v4.5.14
Spire.PdfViewer.Forms.dll v4.9.6
Spire.PdfViewer.Asp.dll v4.9.6
Spire.Spreadsheet v3.9.4
Spire.OfficeViewer.Forms.dll v4.9.2
Spire.Barcode.dll v3.7.0
Spire.DataExport.dll v4.1.9
Spire.DataExport.ResourceMgr.dll v2.1.0
Spire.Common.dll v2.9.11
Spire.License.dll v1.3.7
Spire.PDF
Bug Fixes:
Fixes the issue that the content lost after converting TEXT to PDF.
Fixes the issue that converting PDF to Word cost a long time.
Spire.Doc
Bug Fixes:
Fixes the issue that the code "doc.UpdateTableOfContents()" threw an exception when adding line break \n in the paragraph inside a table.
Fixes the issue that the property HighlightColor returned wrong value when the color was Green or DarkYellow.
Fixes the issue that the application hung when using the code SaveToImages to convert a file to images.
Fixes the issue that the application threw ArgumentException when loading a Word file.
Fixes the issue that the border of table lost after copying table of Word.
Spire.Presentation
New Features:
Supports setting the size and style of chart marker datapoint.
Code: Select all
Presentation ppt = new Presentation();
ppt.LoadFromFile(file);
IChart chart = ppt.Slides[0].Shapes[0] as IChart;
ChartDataPoint dp = new ChartDataPoint(Chart.Series[0]);
dp.Index =0;
//Set size of chart marker datapoint
dp.MarkerSize = 20;
//Set style of chart marker datapoint
dp.MakerStyle = ChartMarkerType.Star;
chart.Series[0].DataPoints.Add(dp);
ppt.SaveToFile(result,FileFormat.Pptx2013);

Supports deleting macros in PowerPoint 2003 documents.
Code: Select all
ppt.DeleteMacros();

Supports setting rotation angle for chart data lable.
Code: Select all
IChart chart = (IChart)ppt.Slides[0].Shapes[0];
ChartDataLabel datalabel = chart.Series[0].DataLabels.Add();
datalabel.ID = 0;
datalabel.RotationAngle = 45;

Bug Fixes:
Fixes the issue that the bottom border of table lost after saving PPT file.
Spire.XLS
New Features:
Adds a method to apply the style for a whole worksheet.
Code: Select all
CellStyle style = book.Styles.add("newStyle");
style.Color = Color.Pink;
style.Font.Size = 15;
book.Worksheets[0].ApplyStyle(style);

Adds new property "IsWrapText" under the class XlsTextBoxShape to set wrap text.
Code: Select all
XlsTextBoxShape.IsWrapText = true;

Bug Fixes:
Fixes the issue that the application threw an exception when loading an excel file.
Fixes the issue that the application threw the "StackOverFlowException" when executing CalculateAllValue.
Fixes the issue that the extracted cell data was incomplete.
Fixes the issue that the application threw NullReferenceException when loading an Excel file.
Spire.PDFViewer
Bug Fixes:
Fixes the issue that the searched text was fully covered when it was highlighted with a color.
User avatar

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

Return to Spire.DataExport