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.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.

Spire.Office Platinum (DLL Only) Version:4.9.0(2019-09-04)
DLL Version:
Spire.Doc.dll v7.8.17
Spire.Pdf.dll v5.8.17
Spire.XLS.dll v9.9.1
Spire.Presentation.dll v4.8.16
Spire.Email.dll v2.4.19
Spire.DocViewer.Forms.dll v4.5.12
Spire.PdfViewer.Forms.dll v4.8.2
Spire.PdfViewer.Asp.dll v4.8.2
Spire.Spreadsheet v3.8.2
Spire.OfficeViewer.Forms.dll v4.9.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.1
Spire.License.dll v1.3.7
Spire.PDF
New Features:
Supports converting HTML to PDF on .Net Core platform.
Adds a new property to get the callout line of PdfFreeTextAnnotationWidget.
Code: Select all
public PointF[] CalloutLines { get; }

Adds a new property to get the line ending style of PdfFreeTextAnnotationWidget.
Code: Select all
public PdfLineEndingStyle LineEndingStyle { get; }

Adds a new property to get or set the rectangular diffecences array of PdfFreeTextAnnotationWidget and PdfFreeTextAnnotation.
Code: Select all
public float[] RectangleDifferences { get; set; }

Bug Fixes:
Fixes the issue that extra border of textbox field was caused after filling text.
Fixes the issue that the content lost after printing.
Fixes the issue that the invisible layer of PDF was rendered after converting the PDF to SVG.
Fixes the issue that the PDF field whose border had color became black after converting the PDF to SVG.
Fixes the issue that the checkbox style was incorrect after selecting an existing checkbox field.
Fixes the issue that the application threw an exception "Array dimensions are out of support" when loading PDF.
Fixes the issue that many lines text of textbox fields had problems after filling textbox fields.
Fixes the issue that caused black content after converting PDF to image.
Fixes the issue that the application threw the "NullReferenceException" when loading XPS file.
Fixes the issue that the application threw the "IndexOutOfRangeException" when converting PDF to image.
Fixes the issue that the application hung when converting PDF to HTML.
Fixes the issue that the application threw the "NullReferenceException" when merging PDF documents.
Fixes the issue that the transparency of watermark lost after converting XPS to PDF.
Fixes the issue that the added image stamp was missing after rotating in adobe reader.
Fixes the issue that the size of stamp changed after creating template.
Fixes the issue that getting PDF forms returns correct value first second time while returns null in second time.
Fixes the issue that the text was stretched after filling text box.
Fixes the issue that the content was lost after printing a PDF file.
Fixes the issue that the text in rotated page cannot be extracted.
Fixes the issue that the application threw the exception when dlls in netstandard2.0 folder used in the project with .NET framework.
Spire.Doc
New Features:
NETStandard and NETCore support digital signatures.
Bug Fixes:
Fixes the issue that incomplete images was caused after converting Word to PDF.
Fixes the issue that blank page was caused and the image in header lost after converting Word to PDF.
Fixes the issue that incorrect page number was caused after converting Word to PDF.
Fixes the issue that errors in the characters in Thai were caused after converting Word to PDF.
Fixes the issue that caused incorrect content and paging after converting Word to PDF.
Fixes the issue that after setting KeepSameFormat to true, the application threw an exception when converting Word to PDF.
Fixes the issue that incorrect data was caused after doing mail merging.
Fixes the issue that the application threw an exception "An object reference is not set to an object instance " when converting Word to PDF.
Fixes the issue that the application threw an exception "The format of input string is incorrect" when executing AppenHTML() method.
Fixes the issue that the incorrect content format was caused after converting Word to PDF.
Fixes the issue that the content lost and pagination error was caused after converting Word to PDF.
Fixes the issue that the application threw the "InvalidOperationException" when loading file.
Fixes the issue that exception was thrown when converting Word to PDF.
Fixes the issue that incorrect layout was caused after converting Word to PDF.
Fixes the issue that displaying error of WordArt was caused after converting Word to PDF.
Fixes the issue that the table header error was caused after converting Word to PDF.
Fixes the issue that the page number updating was incorrect after converting Word to PDF.
Fixes the issue that image format was incorrect after converting Html to Docx.
Spire.Presentation
New Features:
Supports inserting images and video to placeholders.
Code: Select all
Presentation ppt = new Presentation();
 ppt.LoadFromFile("test.pptx");
 for (int j=0;j < ppt.Slides.Count;j++)
 {
     ISlide slide = (ISlide)ppt.Slides[j];
     for (int i=0;i < slide.Shapes.Count;i++)
     {
         Shape shape = (Shape)slide.Shapes[i];
         switch(shape.Placeholder.Type)
         {
             case PlaceholderType.Media:
                 shape.InsertVideo("Video.mp4");
                 break;
             case PlaceholderType.Picture:
                 shape.InsertPicture("Logo.png");
                 break;
             case PlaceholderType.Chart:
                 shape.InsertChart(ChartType.ColumnClustered);
                 break;
             case PlaceholderType.Table:
                 shape.InsertTable(3,2);
                 break;
             case PlaceholderType.Diagram:
                 shape.InsertSmartArt(SmartArtLayoutType.BasicBlockList);
                 break;
         }
     }
 }

Supports setting radius of round rectangle.
Code: Select all
Presentation presentation = new Presentation();
presentation.Slides[0].Shapes.InsertRoundRectangle(0, 60, 90, 100, 200, 36);
presentation.Slides[0].Shapes.AppendRoundRectangle(60, 290, 100, 200, 50);
presentation.SaveToFile("result.pdf", FileFormat.PDF);
presentation.SaveToFile("result.pptx", FileFormat.Pptx2013);

Supports getting a template name in the themes.
Code: Select all
Presentation presentation = new Presentation();
presentation.LoadFromFile(file);
 for (int i = 0; i < presentation.Slides.Count;i++ )
 {
     string name = presentation.Slides[i].Layout.Name;
 }

Bug Fixes:
Fixes the gradient color position issue for converting PPT to SVG.
Fixes the exception issue when loading PPT file.
Fixes the exception issue when saving PPT file.
Fixes the content format issue for converting PPT to image.
Fixes the content lost issue for converting PPT to image.
Fixes the slow issue when saving PPT file on Windows 10.
Spire.XLS
New Features:
Supports creating chart based on PivotTable.
Code: Select all
worksheet.Charts.Add(ExcelChartType.BarClustered, pivotTable);

Supports adding arrow line.
Code: Select all
var arrowline = workbook.Worksheets[0].TypedLines.AddLine();
line.Top = 50;
line.Left = 30;
line.Width = 300;
line.Height = 500;
line.BeginArrowHeadStyle = ShapeArrowStyleType.LineArrowDiamond;
line.EndArrowHeadStyle = ShapeArrowStyleType.LineArrow;

Adds the method AddCopy() after TypedLines/TypedCheckBoxes/TypedTextBoxes/TypedRadioButtons/TypedComboBoxes to copy shapes.
Code: Select all
wb.Worksheets[0].TypedLines.AddCopy(line);

Bug Fixes:
Fixes the issue that incorrect line height was caused after setting AutoFitRow.
Fixes the issue that there were errors in the PivotTable after converting Excel to PDF or HTML.
Fixes the issue that messy content was caused after converting CSV to XLSX in .NET Core.
Fixes the issue that incorrect line was caused after converting Excel to PDF.
Fixes the issue that the conditional format lost after copying range.
Fixes the issue that if the page number had blank space, there was a problem with the page number after adding.
Fixes the issue that incorrect Thai characters were caused after converting Excel to PDF.
Fixes the issue that incorrect chart data was caused after converting Excel to PDF.
Fixes the issue that the formula of trend line could not be returned correctly.
Fixes the issue that the color of range could not be cloned successfully.
Fixes the issue that the application failed to load a correct document if the first document had failed to be loaded.
Fixes the issue that Excel prompted a message to update link after removing a sheet which contains NamedRange.
Fixes the issue that the application caught an exception in try catch statement, but another exception was thrown after using GC to collect garbage.
Fixes the issue that the page break was wrong after converting Excel to PDF.
Fixes the issue that the data displayed wrongly after saving Chart to image.
Fixes the issue that loading a file failed.
Fixes the issue that the application threw the exception StackOverflowException when saving to PDF.
Fixes the issue that corrupted Excel was caused when using Conditional Formatting.
Fixes the issue that the result file hinted an error when opening after deleting a row that contains formula.
Fixes the issue that setting fill horizontally for text didn't work.
Fixes the issue that the application threw the exception FormatException when loading a file.

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;
User avatar

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

Return to Spire.DataExport