Spire.Office New Release or Hotfix

Technical support for Spire.DataExport

Moderators: iceblue support, DataExport, Manager

Spire.Office New Release or Hotfix

Postby amy.zhao » 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:3.7.0(2018-07-17)
Versions:
Spire.Doc.dll v6.7.5
Spire.Pdf.dll v4.7.6
Spire.XLS.dll v8.7.2
Spire.Email.dll v1.3.2
Spire.DocViewer.Forms.dll v3.7.0
Spire.PdfViewer.Forms.dll v3.6.3
Spire.PdfViewer.Asp.dll v3.6.3
Spire.Presentation.dll v3.6.9
Spire.Spreadsheet v2.6.0
Spire.OfficeViewer.Forms.dll v3.7.0
Spire.DataExport.dll v3.5.131
Spire.DataExport.ResourceMgr.dll v1.6.71
Spire.Common.dll v1.2.792
Spire.License.dll v1.3.6
Spire.Barcode.dll v2.3.0

Spire.Doc
Bug Fixes:
Fixes the issue that the header formatting was incorrect after opening and saving a document.
Fixes the issue that the application threw "ArgumentException" exception when converting .doc to .docx.
Fixes the issue that the application threw "FormatException" exception when loading a .docx file.
Fixes the issue that the application threw an “System.FormatException” exception when loading a .docx file in a Dutch regional environment.
Fixes the issue that custom font size did not apply to paragraph in table cell.
Fixes the issue that the numbers in TOC were changed after updating TOC field.
Fixes the issue that the .doc documents with password protected failed to load.
Fixes the issue that the default value of doNotExpandShiftReturn property is incorrect.
Fixes the issue that the application threw an “System.FormatException” exception when loading a .docx document containing grid in points.
Fixes the issue that the application got stuck when loading a .docx document containing hebrew characters.
Fixes the issue that the application threw an “System.OutOfMemoryException” exception when converting a .doc file to PDF.
Fixes the issue that the picture was stretched when converting Rtf document to PDF.
Fixes the issue that the format of table became incorrect when converting Word to PDF.
Fixes the issue that some problems including wrong bullet number and inconsistent corss-page-break setting for tables occured when converting Word to PDF.
Fixes the issue that the application threw "NullReferenceException" exception when converting Word to PDF.
Fixes the issue that the application threw "ArgumentOutOfRangeException" exception when converting Word to PDF.
Fixes the issue that the format of bulltes became incorrect when converting Word to PDF.
Fixes the issue that there was an extra "/*" symbol after the hyperlink when converting Word to HTML.
Fixes the issue that the "created date" information was wrong when creating an .doc and .docx file.
Fixes the issue that the application hung when calculating the page count for a Word.
Spire.PDF
New features:
Add new methods to remove rows or columns of PdfGrid.
Code: Select all
Grid.Rows.Remove(row);
Grid.Rows.RemoveAt(index);
Grid.Columns.Remove(col);
Grid.Columns.RemoveAt(index);

Bug Fixes:
Fixes the issue that the format became incorrect when extracting text from a PDF.
Fixes the issue that a memory leak occurred when extracting images from a PDF.
Fixes the issue that the images got removed when parsing an EMF to PDF.
Fixes the issue that the "FindText()" method could not find the related content.
Fixes the issue that the encryption of PDF got failed when setting the password to be special characters.
Fixes the issue that the application threw an exception when invoking the "AppendPage()" method.
Fixes the issue that the application threw an “System.FormatException” exception when converting extracting images and text.
Fixes the issue that the text was clipped a little bit when converting rtf content with justified style to PDF document.
Fixes the issue that the application threw an “System.FormatException” exception when printing PDF document.
Fixes the issue that the dotted/dashed lines were displayed as solid lines when converting PDF document to XPS file or printing PDFdocument on the WPF platform.
Fixes the issue that the application threw an “System.NullReferenceException” exception when converting PDF document to Image.
Fixes the issue that half page content got removed when printing PDF document.
Fixes the issue of misplaced content when parsing an EMF to PDF.
Fixes the issue that background became black when printing PDF document.
Fixes the issue that all content got removed when converting PDF document to Image.
Fixes the issue that the text cannot be found using the method FindText.
Fixes the issue that the vertical text wasn't displayed correctly when converting EMF to PDF.
Fixes the issue that the background of image changed to black when converting PDF to Word.
Fixes the issue that the text was cut off when printing PDF.
Fixes the issue that the content was wrong when printing.
Fixes the issue that the formats of graphics in PDF document were printed incorrectly.
Fixes the issue that the data were misplaced when extracting text.
Fixes the issue that the chinese characters were messy code when extracting text.
Fixes the issue that the QR Code in a Pdf document were printed incorrectly.
Fixes the issue that the content were cut off when merging PDF files.
Fixes the issue that the data got lost when converting PDF to Image.
Fixes the issue that Xps file converted from PDF was opened unsuccessfully.
Fixes the issue that some content was blacked out when converting PDF to PDF/A.
Spire.XLS
New Features:
Add a new property "XlsPivotTable.Options.IsAutoFormat" for setting whether the autoformat is applied for pivot table or not. Default value is true.
Code: Select all
bool IsAutoFormat
{ get; set; }

Add following three new methods to delete filters in pivot table.
Code: Select all
public void ClearColumnFieldFilter(string fieldName);
public void ClearFilter(string fieldName);
public void ClearRowFieldFilter(string fieldName);

Add a new property “IChart.ChartArea.Shadow.SoftEdge”to support the setting for chart soft edge.
Code: Select all
public int SoftEdge { get; set; }

Bug Fixes:
Fixes the issue that caused ArgumentException when loading the file.
Fixes the issue that caused NullReferenceException when using the code trendLine.DisplayEquation.
Fixes the issue that setting number format didn't work in Spain's environment.
Fixes the issue that the number format was wrong after converting Excel to PDF in Spain's environment.
Fixes the issue that the content was incorrect after converting Excel to PDF.
Fixes the issue that setting default value for the filter of pivot table didn't work.
Fixes the issue that the process hang when converting Excel to HTML.
Fixes the issue that caused NullReferenceException when loading a file.
Fixes the issue that the content of R1C1-Formula would change when inserting a row.
Fixes the issue that the "CellRange.FormulaValue" returned the wrong value.
Fixes the issue that the "ValueFromCell" setting would result in an invalid color effect for the negative column.
Fixes the issue that the original images in Excel1 had all been replaced when copying one of the sheets in Excel2 to Excel1.
Fixes the issue that some structural references were not supported.
Fixes the issue that the property "IsAutoMajor" must be set to false when setting the label unit.
Fixes the issue that the “pageInfoList[0].Count” returned wrong value for the page count.
Fixes the issue that the application thraw an "ArgumentOutOfRangeException" when loading an EXCEL document.
Fixes the issue that the color settings for columns with negative values in Column Chart did not work.
Fixes the issue that the name ranges got lost after copying a worksheet.
Fixes the issue that the application threw "ArgumentException" exception when loading an .xlsx file.
Spire.Presentation
New Features:
Add a property IsHidden to hide the series of a chart.
Code: Select all
series.IsHidden = true;

Add a new method GroupShapes to group shapes.
Code: Select all
ppt.Slides[0].GroupShapes(shapeList);

Add a new property "DataLabelShapeType" for setting the shape of the chart datalabel in PPT.
Code: Select all
public DataLabelShapeType DataLabelShapeType
{ get; set; }

Add a new property “MarkerFill” for setting the fill color and border color of the separate markers in PPT.
Code: Select all
ChartDataPoint dp = new ChartDataPoint(chart.Series[0]);
//set the fill color
dp.MarkerFill.Fill.FillType = FillFormatType.Solid;
dp.MarkerFill.Fill.SolidColor.Color = Color.Red;
//set the border color
dp.MarkerFill.Line.FillType = FillFormatType.Solid;
dp.MarkerFill.Line.SolidFillColor.Color = Color.Black;

Bug Fixes:
Fixes the issue that there was extra character "-" when converting PPT to PDF.
Fixes the issue that the chart was missing and the position of yellow punctuation was wrong when converting PPT to PDF.
Fixes the issue that there was a blue border after saving PPT.
Fixes the issue that the default font of chart legend cannot be got if the legend didn't set any font.
Fixes the issue that caused DocumentUnkownFormatException when loading a file.
Fixes the issue that the conversion from the PPT file which has the same backround image for each slide to PDF would result in a time-consuming process with large size output file.
Fixes the issue that the application threw an "Index was out of range" exception when loading an PPT.
Fixes the issue that printing in landscape mode did not make any sense.
Fixes the issue that the output file was not correct when converting PPT to PDF.
Fixes the issue that the chart was in bad format when converting PPT to PDF.
Spire.SpreadSheet
New features:
Support to undo the action of deleting a row.
Bugs Fixes:
Fixes the issue that chinese characters were truncated when viewing xls file in spreadsheet.
Spire.PdfViewer
Bug Fixes:
Fixes the issue the application thraw an exception when reading an PDF.
Fixes the issue that some contents got removed when reading an PDF.

Spire.Office Platinum (DLL Only) Version:3.6.0(2018-06-06)
Versions:
Spire.Doc.dll v6.6.1
Spire.Pdf.dll v4.5.9
Spire.XLS.dll v8.6.1
Spire.Email.dll v1.3.2
Spire.DocViewer.Forms.dll v3.4.2
Spire.PdfViewer.Forms.dll v3.5.3
Spire.PdfViewer.Asp.dll v3.5.3
Spire.Presentation.dll v3.5.5
Spire.Spreadsheet v2.5.2
Spire.OfficeViewer.Forms.dll v3.6.0
Spire.DataExport.dll v3.5.131
Spire.DataExport.ResourceMgr.dll v1.6.71
Spire.Common.dll v1.2.792
Spire.License.dll v1.3.6
Spire.Barcode v2.3.0
Spire.Doc
Bug fixes:

Fixes the issue that the generated Epub did not meet a criterion when converting Word to Epub.
Fixes the issue that the application hung when converting Word to PDF.
Fixes the issue that the image field could not get updated in Word after replacing the picture of this field with Spire.Doc.
Fixes the issue that the application threw "Index was out of range" exception when converting Word to PDF.
Fixes the issue that the colspan and rowspan of the table became incorrect after saving to HTML.
Fixes the issue that the image turned out to be in wrong position after printing the Word document.
Fixes the issues that the application threw exception when using "UpdateTableOfContents" and the “HorizontalAlignment” setting gave an incorrect format.
Fixes the issue that the application threw "ArgumentOutOfRangeException" exception when converting Word to XPS.
Spire.XLS
Bug Fixes:

Fixes the issue that the content was cut, the checkbox disappeared and the resolution of logo on first page became lower when converting Excel to Pdf.
Fixes the issue that setting ResizeBehave property had no effect.
Fixes the issue that caused NullReferenceException after deleting column.
Fixes the issue that the HideItem method of PivotTable didn't work.
Fixes the issue that the image lost after adding filter.
Spire.PDF
New features:

Adds a new property "SignFontColor" to support the font color setting for the signature content.
Code: Select all
public Color SignFontColor { set; }

Changes the class name of "PdfGridCellTextAndStyleList" to"PdfGridCellContentList" and updates the code annotation.
Changes the class name of "PdfGridCellTextAndStyle" to"PdfGridCellContent" and updates the code annotation.
Bug Fixes:
Fixes the issue that caused OutOfMemoryException when converting PDF to Image.
Fixes the issue that the chart content was lost after printing PDF.
Fixes the issue that caused OutOfMemoryException when removing layers.
Fixes the issue that the signature panel wrongly displayed "signed by" after the signature was certificated.
Fixes the issue that incorrect text was added when adding Code 128C barcode to PDF.
Fixes the issue that the text was offset when converting XPS to PDF.
Fixes the issue that the result was blurred when printing a PDF.
Fixes the issue that the generated PDF could not be opened when converting EMF to PDF.
Fixes the issue that the settign of italic and bold font style for the PdfFreeTextAnnotation content did not make any sense.
Fixes the issue that half page became black when printing a PDF.
Fixes the issue that the generated PDF could not be opened when merging this PDF with any other PDFs.
Fixes the issue that the applictaion threw an "Index was out of range" exception when converting PDF to Word.
Fixes the issue that the pictures got removed when converting PDF to XPS.
Fixes the issue that the image background color wrongly became blue when merging PDF files.
Fixes the issue that the generated PDF could not be opened when duplicating a PDF.
Spire.Spreadsheet
New features:

Add a new property "Password" supporting the loading of an encrypted Excel, the statement should be before the loading step.
Code: Select all
public string Password { get; set; }

Bug fixes:
Fixes the issue that the margins of the output document turned out to be incorrect when loading and saving an Excel document.
Fixes the issue that the group content could not completely display when loading an Excel which contains a group.
Fixes the issue that the chart got lost after saving the document.
Fixes the issue that the an pop-up would wrongly appear when clicking a cell which has a hyperlink.

Spire.Office Platinum (DLL Only) Version:3.4.0(2018-04-25)
Versions:
Spire.Doc.dll v6.4.10
Spire.Pdf.dll v4.4.9
Spire.XLS.dll v8.4.13
Spire.Email.dll v1.3.1
Spire.DocViewer.Forms.dll v3.4.1
Spire.PdfViewer.Forms.dll v3.4.1
Spire.PdfViewer.Asp.dllv3.4.1
Spire.Presentation.dll v3.4.7
Spire.Spreadsheet v2.3.1
Spire.OfficeViewer.Forms.dll v3.4.0
Spire.DataExport.dll v3.5.131
Spire.DataExport.ResourceMgr.dll v1.6.71
Spire.Common.dll v1.2.791
Spire.License.dll v1.3.6
Spire.Barcode v2.3.0
Spire.Xls:
Bug Fixes:
Fixes the issue that the cell content of the result file is incorrect when printing Excel with the DPI of 125.
Fixes the issue that the text format is incorrect when converting Excel to PDF with the DPI of 125.
Fixes the issue that the result images are incorrect when converting Excel Sheets to Images.
Fixes the issue that the calculation is incorrect after calculating formula value("=ROUND(2.135,2)").

Spire.Office Platinum Version:3.0(2018-04-19)
Versions:
Spire.Barcode.dll 2.3.0
Spire.Common.dll 1.2.791
Spire.DataExport.dll 3.5.131
Spire.Doc.dll 6.4.8
Spire.DocViewer.Forms.dll 3.4.1
Spire.Email.dll 1.3.1
Spire.License.dll 1.3.6
Spire.OfficeViewer.Forms.dll 3.0.0
Spire.Pdf.dll 4.4.7
Spire.PdfViewer.Asp.dll 3.4.1
Spire.PdfViewer.Forms.dll 3.4.1
Spire.Presentation.dll 3.4.7
Spire.Spreadsheet.dll 2.3.1
Spire.XLS.dll 8.4.8
Spire.Doc:
New Features:
Add a new method to support adding a cover image when converting to Epub.
Code: Select all
public void SaveToEpub(Stream stream, DocPicture coverImage);
public void SaveToEpub(string fileName, DocPicture coverImage);
Supports to load WordXml stream.
Document doc = new Document();
doc.LoadFromStream(stream, FileFormat.WordXml);

Bug Fixes:
Fixes the issue that caused extra empty paragraph when convertiong to PDF after mailmerging.
Fixes the issue that the content lost when setting paragraph keepFollow.
Fixes the issue that caused the ArgumentOutOfRangeException when saving to PDF after replacing text with some Chinese.
Fixes the issue that caused the exception "Can not find the required value 'es'" when using AppendHtml method.
Fixes the issue that caused the exception "Value was either too large or too small for an Int16" when loading rtf document.
Fixes the issue that the images got duplicated when converting Word to PDF.
Fixes the issue that the hyperlinks were lost when converting Word to PDF.
Fixes the issue that the document was unable to open after splitting.
Fixes and supplements the code annotation of SDTType property to avoid misunderstanding when the type is RichTextControl.
Fixes the issue that caused an exception when loading a document.
Fixes the issue that much time was needed when converting Word to PDF_A1B.
Fixes the issue that data became incorrect after UpdateTableOfContents method.
Fixes the issue that UpdateTableOfContents method threw an exception in Azure.
Fixes the issue that the TOC was not recognized as bookmarks when converting Word to PDF.
Fixes the issue that the other bookmark object got lost when deleting the content of one bookmark using DeleteBookmarkContent().
Fixes the issue that caused an "System.FormatException" exception when loading a document.
Fixes the issue that caused an "System.NullReferenceException" exception when converting Word to PDF.
Fixes the issue that caused the deranged content when using PS method to convert.
Fixes the issue that caused the ArgumentOutOfRangeException when converting Html to Word.
Fixes the issue that the images don't show completely when converting Word to PDF.
Fixes the issue that caused incorrect paging when converting Word to Tiff.
Fixes the issue that the application hangs when converting Word to PDF.
Fixes the issue that caused Exception when using method doc.GetPageCount().
Fixes the issue that caused different page numbers when converting Word to PDF.
Fixes the issue that caused the overlapping content when applying license to convert Word to PDF.
Fixes the issue that caused the NullReferenceException when executing MailMerge.GetMergeFieldNames() method.
Fixes the issue that getting caused the missing page field after getting page count.
Fixes the issue that getting title and AlternativeText returns empty.
Fixes the issue that caused the NullReferenceException when converting XML to PDF.
Fixes the issue that the GetFiledName method returns wrong value after adding a field whose name contains the ":" symbol.
Fixes the issue that caused the exception when loading Word document.
Fixes the issue that the horizontal rulers don't appear when converting html string to OpenOffice (ODT).
Fixes the issue of the process hanging when converting Word to PDF.
Fixes the issue that the footer is missing when converting Rtf to Pdf/A.
Fixes the issue that caused the StackOverflowException error when loading doc file.
Spire.pdf:
New feature:
Add new method to support converting the specified range of the document pages to the format file which saved to streams. Kindly note FileFormat.PDF is not supported.
Code: Select all
public Stream[] SaveToStream(int startIndex, int endIndex, FileFormat format);

Add new method to support printing in white&black mode.
Code: Select all
PdfDocument doc=new PdfDocument();
doc.LoadFromFile(@"");
doc.PrintSettings.Color=false;
doc.Print();

Adds a feature to declare the range when using SimpleTextExtractionStrategy to extract text in PDF.
Code: Select all
PdfDocument doc = new PdfDocument("input.pdf");
RectangleF rec = new RectangleF(0,0,595,760);SimpleTextExtractionStrategy sim = new SimpleTextExtractionStrategy();
string content = doc.Pages[0].ExtractText(rec,sim);
string fileName = "output.txt";
File.WriteAllText(fileName, content);

Bug Fixes:
Fixes the issue that the data is lost after removing the password of PDF.
Fixes the issue that caused NullReference exception when calling page.AnnotationsWidget.Add() method.
Fixes the issue that the saved PDF which includes XFA forms hints "Please wait..." when opening.
Fixes the issue that the process hangs when extracting image from PDF page.
Fixes the issue that caused StackOverflowException when extracting both images and text.
Fixes the issue that caused the error "Illegal characters in path" when merging pdf files.
Fixes the issue that caused blank pages when copying page content to a new document.
Fixes the issue of getting the wrong number of PDF attachments.
Fixes the issue that caused NullReferenceException when converting PDF to image.
Fixes the issue that caused NullReferenceException when converting PDF to SVG.
Fixes the issue that caused wrong background of the image when drawing emf image to PDF file.
Fixes the issue that the line break was added when the name of the signature is too long.
Fixes the issue of throwing Exception when loading a PDF file.
Fixes the issue that printing in black and white would give a blur result.
Fixes the issue that caused the NullReferenceException when finding text.
Fixes the issue that caused the NullReferenceException when merging Pdf files.
Fixes the issue that caused the NullReferenceException when extracting text.
Fixes the issue that caused the FormatException when getting ImagesInfo of a page.
Fixes the issue that caused the ArgumentOutOfRangeExcepton when invoking page.FindText("").
Fixes the issue that caused the AccessViolationExcepetion when converting Pdf to Image.
Fixes the issue that fail to obtain the LineText when extracting the collection of specific text.
Fixes the issue that caused the NullReferenceException when removing Pdf layer.
Spire.Xls:
New features:
Add new feature to specify the Image Location type (GlobalAbsolute or Relative to Table) when converting sheet to html.
Code: Select all
HTMLOptions opt = new HTMLOptions();
opt.ImageLocationType = ImageLocationTypes.TableRelative;
//opt.ImageLocationType = ImageLocationTypes.GlobalAbsolute;
sheet.SaveToHtml(string fileName, HTMLOptions saveOption);
Add a series of new interfaces to create conditional formats.
XlsConditionalFormats xcfs = sheet.ConditionalFormats.Add();
xcfs.AddAverageCondition(AverageType averageType)
xcfs.AddBeginsWithCondition(string text);
xcfs.AddCellValueCondition(ComparisonOperatorType operatorType, double value1, double value2);
xcfs.AddCellValueCondition(ComparisonOperatorType operatorType, string value1, string value2);
xcfs.AddContainsBlanksCondition();
xcfs.AddContainsErrorsCondition();
xcfs.AddNotContainsTextCondition(string text);
xcfs.AddTimePeriodCondition(TimePeriodType timePeriodType);
xcfs.AddTopBottomCondition(TopBottomType topBottomType, int rank);
xcfs.AddUniqueValuesCondition();

Bug Fixes:
Fixes the issue that the property CellRange.HasConditionFormats always return false.
Fixes the issue that the table border was lost when converting Excel to SVG.
Fixes the issue that caused FormatException when loading file.
Fixes the issue that the result is incorrect when adding shadow for a chart.
Fixes the issue that caused exception when setting the Gradient with “Radial” type in Chart Plot Area.
Fixes the issue that the datalable of chart was missing when converting Excel to PDF.
Fixes the issue that the font "garamond" cannot be embedded when converting Excel to PDF.
Fixes the issue that the property CellRange.HasConditionFormats returned wrong value.
Fixes the issue that the functionality "CalculateAllValue" gave error in the result.
Fixes the issue that the process hung when converting Excel to PDF.
Fixes the issue that an additional page was added when converting Excel to PDF.
Fixes the issue that an exception occured when converting worksheet to Image.
Fixes the issue that data was lost when converting sheet to Image.
Fixes the issue that image got lost when converting Excel to PDF.
Fixes the issue that the "Percent" attribute did not make sense in " chart.Series[0].DataPoints[0].DataFormat.Percent=20;
Fixes the issue that caused incorrect style and content when converting Excel to Pdf.
Fixes the issue that the bottom graphic is incorrect when converting Excel to Pdf.
Fixes the issue that caused a gradual increase in the size of the generated file when circularly changing the value of a cell.
Fixes the issue that caused incomplete content on local and blank content on Azure after using sheet.ToImage() to save sheet to image.
Fixes the issue that caused incorrect content after saving.
Fixes the issue that the cell filling lost when converting Excel to Pdf.
Fixes the issue that the cell style lost after merging data.
Fixes the issue that caused incorrect content when converting Excel to Pdf.
Fixes the issue that caused InvaildCastException when changing text color.
Fixes the issue that caused incorrect text color when converting Excel to HTML.
Fixes the issue that the next text font had a change after modifying subscripts.
Spire.Presentation:
New Features:
Add new property IsMergeSameLabel to set the same item for the classification axis first class label.
Add new method DeleteEntry to delete Legend entry.
Code: Select all
public void DeleteEntry(int index);

Add new method "AddFromHtml" to insert html into PPT. The method would regard each html tag as a separate shape.
Code: Select all
public void AddFromHtml(string htmlText);

Add new properties "ChartDataLabel.X" and "ChartDataLabel.Y" to set the position for the chart datatable in a PPT.
Add a new property "AnimationEffect.Subtype" to set or get the "Effect option" for an animation in a PPT.
Add AlternativeTitle property to get/set the title of the alternative text of shape.
Code: Select all
string title = ppt.Slides[0].Shapes[0].AlternativeTitle;

Add StartParagraph property and EndParagraph property to get start paragraph and end paragraph of animation effects.
Code: Select all
AnimationEffect anim = ppt.Slides[0].Timeline.MainSequence[0];
TextParagraph startParagraph = anim.StartParagraph;
TextParagraph endParagraph = anim.EndParagraph;

Bug Fixes:
Fixes the issue that the chart legend added extra borders when converting PPT to PDF.
Fixes the issue of invalid font when converting PPTX to PDF.
Fixes the issue that caused the unhandled exception of type 'System.DivideByZeroException' when loading.
Fixes the issue that caused the redundant marker when adding a custom label to chart.
Fixes the issue that caused the unhandled exception of type 'Spire.presentation.DocumentEditException' when deleting single row of table.
Fixes the issue that deleting the legend entry of a chart would cause the “Null Reference Exception".
Fixes the issue that changing the data source of a chart would cause the incorrect chart fromat.
Fixes the issue that some words got displaced when converting PPT slides to images.
Fixes the issue that the chart format become incorrect when converting a PPT to a PDF.
Fixes the issue that the border format of a table become incorrect when converting a PPT to a PDF.
Fixes the issue that the format of a chart’s graphic description become incorrect when converting a PPT to a PDF.
Fixes the issue that the chart got removed when converting a PPT to a PDF.
Fixes the issue that the chart legend added extra borders when converting PPT to PDF.
Fixes the issue of invalid font when converting PPTX to PDF.
Spire.DocViewer
Bug Fixes:
Fixes the issue that caused the exception "Index was out of range. Must be non-negative and less than the size of the collection." when quickly loading the file again.
Fixes the issue that the scroll bar cannot roll when viewing the file.
Spire.PdfViewer
New Features:
Add a new method for PdfViewer control to support setting the start page.
Code: Select all
pdfviewer.DefaultStartIndex=3

Bug Fixes:
Fixes the issue that caused a runtime error when zooming a document in IE10 browser.
Fixes the issue that the content is not displayed correctly when viewing and printing pdf document.
Fixes the issue that license is invalid for printing function of PDFViewer control.

Spire.Office hotfix Version 2.16.27(2018-02-11)
Versions:
Spire.Barcode.dll 1.4.11
Spire.DataExport.dll 3.5.133
Spire.Doc.dll 6.0.58
Spire.DocViewer.Forms.dll 2.4.38
Spire.Email.dll 1.1.16
Spire.Pdf.dll 3.9.480
Spire.PdfViewer.Forms.dll 2.12.47
Spire.Presentation.dll 2.8.81
Spire.XLS.dll 7.12.120
Spire.Spreadsheet.dll 2.2.50
Spire.OfficeViewer.Forms.dll 2.16.23
Spire.Doc
New features:
Add Table.ApplyTableStyle method to apply the table style to table and cell.
Exposes the ParagraphBase.StyleName property.
Adds Document.CloneThemesTo method to clone the Themes to destination document when merging files.
Adds the Styles.ApplyDocDefaultsToNormalStyle method to apply the default paragraph format and character format to normal style.
Supports to manipulate OpenDocument Text (ODT) format document.
Bug solutions:
Fixes the issue that caused the content was lost when converting word to PDF.
Fixes the issue that caused the link on the text was lost when converting word to PDF.
Fixes the issue that caused image was shift when converting word to PDF.
Fixes the issue that caused list number was incorrect when converting word to PDF.
Fixes the issue that caused text to wrap was incorrect when converting word to PDF.
Fixes the issue that caused the ArgumentOutOfRangeException error when saving word to PDF.
Fixes the issue that caused content in table was out of table when converting word to PDF with PS conversion method.
Fixes the issue where the hr html tag wasn't recognized.
Resolves the issue that caused application was hang when getting page count.
Resolves the issue where the Section.PageSetup.PageBorderIncludeFooter property didn't work.
Fixes the issue that caused empty line missing when converting Word to PDF.
Fixes the issue that caused some text moved up when converting Word to PDF.
Fixes the issue that the added page number field displays wrong page number when converting Word to PDF.
Fixes the issue that the bullets doesn't convert correctly when saving to text.
Fixes the issue that caused NullReferenceException when converting Word to HTML.
Fixes the issue that the created hyperlink is incorrect.
Fixes the issue that caused the ArgumentOutOfRangeException when saving Word to PDF.
Fixes the issue that the column's content was incorrect when converting Word to PDF.
Fixes the issue that the content was lost when converting Word to PDF.
Fixes the issue that caused the application to hang when using LoadFromStream method.
Fixes the issue where AppendHTML method threw ArgumentOutOfRangeException.
Fixes the issue that the document protection lost.
Fixes the issue that numbered list couldn’t be obtained correctly.
Fixes the issue that the vector graphics lost when converting Word to Html.
Fixes the issue that the column width of table was incorrect when converting Word to PDF.
Fixes the issue that the document couldn’t be saved to .docx format after inserting a hyperlink.
Fixes the issue that caused StackOverflowException when converting Word to PDF.
Fixes the issue that caused NullReferenceException when Loading RTF file.
Fixes the issue where the list numbering is lost when saving Word to PDF.
Fixes the issue that the content added in footnote is missing when saving to .docx file.
Fixes the issue that the updated result in SUM field is incorrect after replacing data.
Fixes the issue that the absolute position of floating TextBox was incorrect after converting to PDF format.
Fixes the issue in which incorrect values were returned from CharacterFormat.HighlightColor and CharacterFormat.TextBackgroundColor properties.
Fixes the issue that the font of field was lost while copying bookmark's TextRange.
Fixes the issue that the text in HYPERLINK field code was lost.
Fixes the issue that the HYPERLINK effect was lost when converting to HTML.
Fixes the issue that the column width of table was incorrect when converting to PDF.
Fixes the issue that System.IndexOutOfRangeException was occured when loading doc document.
Fixes the issue that System.NullReferenceException was occured when using ImportContent method to merge document.
Fixes the issue that the header content was obtained incorrectly when using Document.GetText method.
Fixes the issue that the content in a Word table was not aligned correctly when converted to PDF.
Fixes the issue that the text bold style was lost when converting html to PDF.
Fixes the issue that the table border was lost when converting html to PDF.
Fixes the issue that the table style was incorrect when converting word to PDF.
Fixes the issue that the content was confused when converting word to PDF in UsePSCoversion way.
Fixes the issue that caused the NullReferenceException when using ApplyStyle method.
Fixes the issue that the watermark was lost when adding new watermark to a document with watermark.
Spire.PDF
New features:
Adds the new property PdfDocument.PrintSettings.DocumentName.
Adds a new property PdfLayer.IsShowOnUI to get whether the layer is shown on user interface or not.
Adds the print event doc.PrintSettings.EndPrint.
Supports to extract text from a certain rectangle.
Supports to set Collate when printing.
Adds new method for new plugin to save HTML to PDF stream.
Adds a new feature to return a collection of all text on the page with their bounds.
Bug solutions:
Fixes the issue that caused the text in PdfTextBoxField invisible after merging PDF files.
Fixes the issue that cannot read the KeyWords after loading encrypted document.
Fixes the issue that caused the text overlapping when converting to Image.
Fixes the issue that caused the position of inserted bookmark incorrect when inserting bookmark.
Fixes the issue that the margin is incorrect after printing.
Fixes the issue that caused "Fatal Error at 92916" exception when merging PDF files.
Fixes the issue that the position of signature image is incorrect after saving to image.
Fixes the issue that the position of words is inconsistent when getting coordinates of searched words.
Fixes the issue that the image changed to black after compressing PDF.
Fixes the issue that parts of content got messy when saving PDF to Word.
Fixes the issue that the state of checkbox changed to "checked" after setting the value for textbox.
Fixes the issue that the position of text in textbox changed after updating.
Fixes the issue that the result PDF couldn't be opened via Adobe after using pdf.Form.IsFlatten = true.
Fixes the issue that the space of character was incorrect when converting PDF to Word.
Fixes the issue that collapsing bookmarks didn't work.
Fixes the issue that the extracted image was whiter than the original image in PDF.
Fixes the issue that the line style changed from "solid" to "dotted" when printing PDF.
Fixes the issue that caused PdfException when loading file.
Fixes the issue that some extra blank characters were added when converting HTML to PDF with IE7.
Fixes the issue that the border was missing when printing PDF.
Fixes the issue that the VerifySignature method returns false for valid signature.
Fixes the issue that the ProPhotoRGB profile is lost after drawing image.
Fixes the issue that the timeout is kicking in in some cases when using the Spire.Pdf.HtmlConverter.Qt.HtmlConverter.Convert method to convert the same HTML to PDF many times.
Fixes the issue that the position of the signature image changed after saving PDF to image.
Fixes the issue that the time of getting bookmarks keeps increasing.
Fixes the issue that the border is missing when printing.
Fixes the issue that getting page index of a textbox which is placed on multiple pages is incorrect.
Fixes the issue that the result document cannot be opened successfully after converting .tiff image to PDF.
Fixes the issue that the text in the fields is being cut off at the top after converting the split PDF to image.
Fixes the issue that the result was incorrect when converting PDF to XPS.
Fixes the issue that the function SetButtonImage doesn't work.
Fixes the issue that caused ArgumentNullException when checking the property page.ImagesInfo.
Fixes the issue that caused the exception "can not convert to rectangle" when assigning some text value to form field.
Fixes the issue that the compression ratio for the method TryCompressImage was not high.
Fixes the issue that the whole document is printed empty.
Fixes the issue that the PdfLineAnnotation.Location property returned wrong value.
Fixes the issue that the gradient effect lost when converting PDF to SVG.
Fixes the issue that the PdfAttachmentAnnotation object was drawn at a wrong location.
Fixes the issue that the PageSettings.Orientation property didn't work properly.
Fixes the issue that caused the "Unexpected token Unknown before 8103" exception when loading a file.
Fixes the issue that caused the "Invalid/Unknown/Unsupported format" exception when loading a file.
Fixes the issue that the button field couldn't be added into an existing PDF document.
Fixes the issue that the text was not displayed in its proper position when converting PDF to image.
Fixes the issue that extra black spots were added when converting PDF to image.
Fixes the issue that some texts were garbled when printing a PDF.
Fixes the issue that the result document was blank when converting PDF to PDF/A.
Fixes the issue that the data replacement of attachment in PDF document didn't work.
Fixes the issue that the background color became black when converting to Image.
Fixes the issue that the value of PdfImageInfo bounds always returned 0.
Fixes the issue that the file size increased when inserting stamp.
Fixes the issue that caused the ArgumentException when using VerifySignature method.
Fixes the issue that the result was garbled when extracting text.
Fixes the issue that the BackgroundRegion property didn't work.
Spire.XLS
New features:
Adds Workbook.GetOleSize method to get the displayed size of an embedded Excel OLE object.
Bug solutions:
Fixes the issue that caused ArgumentOutOfRangeException error when loading workbook XML document.
Fixes the issue that the address of conditional formatting was gotten incorrectly.
Fixes the issue that the double quote was parsed incorrectly when converting CSV to Excel.
Fixes the issue that caused the docfile has been corrupted error when loading .xls document.
Fixes the issue that caused application to hang when loading document.
Fixes the issue that caused the error that extended format record fontindex field has wrong value when loading document.
Fixes the issue that caused application to hang when saving chart as image.
Fixes the issue that ConditionalFormatWrapper.DataBar.MinPoint didn't work.
Fixes the issue that caused HideItemDetail method to throw exception when there is a blank item.
Fixes the issue that caused NullReferenceException when launching a GarbageCollector.
Fixes the issue that the shadow property of shape didn't work.
Fixes the issue that the border of the rectangle was lost when converting Excel to PDF.
Fixes the issue that the position of shape was incorrect when converting Excel to PDF.
Fixes the issue that the sheet protecting password was removed when manipulating locked cell.
Fixes the issue that caused the exception that it is not supported for this Vertical Axis type when loading the Excel file.
Fixes the issue that caused the exception when saving empty worksheet.
Fixes the issue that there is extra border for chart title when converting Excel to PDF.
Fixes the issue that the alignment of chart title was changed after converting Excel worksheet to PDF.
Fixes the issue that additional leader line of data label for chart occurs after converting Excel worksheet to PDF.
Fixes the issue that caused InvalidCastException when loading the Excel.
Fixes the issue that the process was freezing when using LoadFromStream to load file.
Fixes the issue that caused exception when calling CalculateAllValue method.
Fixes the issue that the result file has extra data.
Fixes the issue that chart datalable was duplicated when converting Chart to Image.
Fixes the issue that CalculateAllValue method threw an exception.
Fixes the issue that the alignment of chart subtitle was incorrect when converting worksheet to PDF.
Fixes the issue that the font of chart subtitle was incorrect when converting worksheet to PDF.
Fixes the issue that the leader lines of chart was added when converting to PDF.
Fixes the issue that the conditional format was incorrect.
Fixes the issue that formula returned wrong value.
Fixes the issue that the returned value of the sheet counts was incorrect.
Fixes the issue that the retuned value of alternative text of shape was incorrect.
Fixes the issue that the application was hanging when loading a file.
Fixes the issue that the space between words was lost when converting to PDF.
Fixes the issue that the invisible comment can't be set as visible.
Fixes the issue that the horizontal axis position of bar chart was rendered incorrectly when converting to PDF.
Fixes the issue that caused spr2464 exception when converting sheet to Image.
Fixes the issue that caused NullReferenceException when saving to XML.
Fixes the issue that the formula was copied incorrectly when inserting new row.
Fixes the issue that the IgnoreErrorOptions property didn't work.
Fixes the issue that the value of ComboBox control was set incorrectly.
Fixes the issue that caused the exception that Value was either too large or too small for an Int32 when loading.
Fixes the issue that the digit in Chinese character was incorrect when saving to PDF.
Spire.Presentation
New features:
Adds Transparency property for PictureShape class to set or get the picture transparency when using picture fill.
Add SetTableBorder method to set the border of table.
Add BubbleScale property for Chart to scale bubble size of bubble chart.
Add IterateType property for AnimationEffect to set the type of animate text.
Add IterateTimeValue property for AnimationEffect to set the time of animate text.
Supports to manipulate error bars of chart.
Adds HasMultiLvlLbl property to get/set if Category Axis has Multi-level Category Lables.
Bug solutions:
Fixes the issue that caused the SlideNumberVisible property didn't work.
Fixes the issue that caused the NullReferenceException when loading file.
Fixes the issue that caused the embedded fonts lost when converting to Image.
Fixes the issue that caused chart non-editable after the chart was edited with Spire.Presentation.
Fixes the issue that caused the style of pie chart lost when converting to PDF.
Fixes the issue that font bold effect lost when converting to Image.
Fixes the issue that GIF in slide was changed to .PNG image when adding to new presentation.
Fixes the issue that the content of slide was incorrect when appending to new presentation.
Fixes the issue that animation was incorrect when copying slide to new presentation.
Fixes the issue that percentage format setting of chart datalabel had no effect.
Fixes the issue that getting comment was incorrectly.
Fixes the issue that the LeaderLinesVisible property setting didn't work.
Fixes the issue that only the first 10 series was displayed in legend area when series count is more than 10.
Spire.PDFViewer
Bug solutions:
Fixes the issue that caused text overlapping.
Fixes the issue where the alignment of text is incorrect when displaying the PDF file.
Fixes the issue that the warning information appears on generated thumbnail after applying license.
Fixes the issue where the VerticalScroll.Visible property didn't work.
Fixes the issue that the image in the document lost.
Fixes the issue that the background on text lost.
Fixes the issue that extra black marks were displayed.
Fixes the issue that the horizontal scroll bar displayed incorrectly.
Fixes the issue that the document couldn't be switched to other document when using Spire.PDFViewer for ASP.NET.
Fixes the issue that the textbox overlapped when zooming the document using Spire.PDFViewer for ASP. NET.
Fixes the issue that the document couldn't be opened.


Spire.Office hotfix Version 2.16.23
Versions:
Spire.Barcode.dll 1.4.11
Spire.DataExport.dll 3.5.133
Spire.Doc.dll 6.0.58
Spire.DocViewer.Forms.dll 2.4.38
Spire.Email.dll 1.1.16
Spire.Pdf.dll 3.9.480
Spire.PdfViewer.Forms.dll 2.12.47
Spire.Presentation.dll 2.8.81
Spire.XLS.dll 7.12.120
Spire.Spreadsheet.dll 2.2.50
Spire.OfficeViewer.Forms.dll 2.16.23
Spire.Doc
New features:
Exposed the property Paragraph.Format.BeforeAutoSpacing.
Exposed the property Paragraph.Format.AfterAutoSpacing.
Bug solutions:
Fixed the issue that caused list number missing after cloning document.
Fixed the issue that caused NullReferenceException when applying the style for table.
Fixed the issue that caused wrong result after using table.AutoFit(AutoFitBehaviorType.AutoFitToWindow).
Fixed the issue that font cannot be embedded when using PS method to convert Word to PDF on Azure.
Fixed the issue that the quality of the image is not as good as original when saving to PDF.
Fixed the issue that caused ArgumentOutOfRangeException when using AppendHTML method.
Fixed the issue where form fields were overlaid when converting Word to PDF.
Fixed the issue that caused an extra chapter number when applying heading.
Fixed the issue that caused NullReferenceException when using the method LoadFromStream.
Fixed the issue that caused additional picture in INCLUDEPICTURE field after changing the size of picture.
Fixed the issue that the method GetText didn't get the text in shapes.
Fixed the issue that caused the exception "This is not a structured storage file" when using document.LoadFromStream(stream, FileFormat.Auto) to load a Html file.
Fixes the issue that caused the hyperlink on the image lost when using PS conversion method to convert Word to PDF.
Fixes the issue that caused "Cannot insert an object of type CustomXml into the Body" error when loading wordxml document.
Fixes the issue that the page number was not updated after updating the field.
Fixes the issue that caused the process hanging when converting Word to PDF.
Fixes the issue that caused ArgumentException when converting to image.
Fixes the issue that the picture was shifted after converting to PDF.
Fixes the issue that caused NullReferenceException when loading file.
Fixes the issue that the color of a TextRange cannot be changed.
Fixes the issue that caused NullReferenceException using SaveToStream method after cloning document.
Fixes the issue that caused the exception "An item with the same key has already been added." when merging files.
Fixes the issue that caused StackOverflowException when converting Word to PDF.
Fixes the issue that caused the error "string cannot be of zero length" when converting RTF to PDF.
Fixes the issue that caused the line lost when converting RTF to PDF.
Fixes the issue that caused the text alignment incorrect in merged rows.
Fixes the issue that Roman number III was transferred to Arabic number 3 while converting Word to TXT.
Resolves the issue where the hyperlink that is linked to bookmark failed to work in converted PDF.
Fixes the issue that caused the text overlapping when converting Word to PDF.
Fixes the issue that caused next pragraphs' ListFormat.CurrentListStyle null when cloning the paragragh that has no ListFormat.
Spire.PDF
New features:
Adds the PdfPrintSettings.SelectMultiPageLayout method to support printing multiple pages per sheet.
Adds feature to convert PDF to .docx format.
Adds the method Spire.Pdf.PdfDocument.Preview(PrintPreviewControl printPreviewControl)to support print preview.
Supports to convert PDF into Html stream.
Adds new method TryCompressImage to compress image in PDF for reducing the size of PDF.
Supports to convert PDF to SVG with custom height and width.
Bug solutions:
Fixes the issue that the text was flipped and cut off when converting PDF to image.
Fixes the issue that caused black background of image when printing.
Fixes the issue that caused wrong signature after multiple signatures.
Fixes the issue that the attachment cannot be added in PDF.
Fixes the issue that the data in the fields were missing when converting to image.
Fixes the issue that content cannot be printed in the center when using ActualSize and AutoPortraitOrLandscape.
Fixes the issue that caused NullReferenceException when converting PDF to XPS.
Fixes the issue that caused exception when loading XPS when system language is Russian.
Fixes the issue that caused messy code when extracting text.
Fixes the issue that content was cut off when printing.
Fixes the issue that the method VerifySignature returned wrong Boolean value.
Fixes the issue that the accents above some characters were printed at wrong position.
Fixes the issue that caused "Insufficient data for an image" error when repeatedly loading document to insert image and save it.
Fixed the issue that caused content garbled when converting to image.
Fixed the issue that caused content lost when converting to image.
Fixed the issue that caused SaveAsImage method threw KeyNotFoundException error.
Fixed the issue that caused FindText method threw FormatException error.
Fixed the issue where the text and image can't be drawn on layer.
Fixed the issue that caused the result incorrect when splitting document.
Fixes the issue where the print result was not centered at the page when using the ActualSize Property.
Fixes the issue that caused signature disappeared when flattening a digitally signed pdf document.
Optimizes the TryCompressImage method to make the document size less.
Optimizes XPS to PDF conversion.
Fixes the issue that caused the content overlapping when converting PDF to .doc.
Fixes the issue where the stamp that is created using our product can't be printed out manually.
Optimize PDF to image conversion time consumption.
Fixes the issue that caused content lost when converting PDF to Image.
Fixes the issue that caused InvalidCastException when converting PDF to Image.
Fixes the issue that caused OutOfMemoryException when extracting image in x86 platform.
Fixes the issue where gradient color was not printed correctly.
Adjustments:
Obsoletes the set property of PdfSecurity.Permissions and PdfSecurity.KeySize.
Obsoletes PdfSecurity.OwnerPassword, PdfSecurity.UserPassword property.
Obsoletes PdfSecurity.ResetPermissions and PdfSecurity.SetPermissions method, and use PdfSecurity.Encrypt method instead.
Obsoletes PdfDocument.PrintDocument.PrintController property. Use PdfDocument.PdfPrintSettings.PrintController property instead.
Obsoletes PdfDocument.PrintDocument.PrinterSettings.Duplex property. Use PdfDocument.PdfPrintSettings.Duplex property instead.
Obsoletes PdfDocument.PrintDocument.QueryPageSettings property. Use PdfDocument.PdfPrintSettings.QueryPageSettings property instead.
Obsoletes PdfDocument.PrintDocument.PrinterSettings.PaperSources and PdfDocument.PrintDocument.DefaultPageSettings.PaperSource property. Use PdfDocument.PrintSettings.PdfPaperSettings property instead.
Obsoletes the property Spire.Pdf.PdfDocument.PageScaling and Spire.Pdf.PdfDocument.CustomScaling. Use the method as below instead.
Spire.XLS
New features:
Supports to manipulate more conditional formatting in XlsConditionalFormat and ConditionalFormatWrapper.
Adds ConditionalFormatWrapper.StopIfTrue property to stop processing the current rule when the condition meets.
Bug solutions:
Fixes the issue where accounting Number Format didn't work correctly while saving Excel to PDF.
Fixes the issue that caused the invalid column index exception while saving Excel to PDF.
Resolves the issue where the comma that is not an actual field separator was considered as delimiter while saving Excel to CSV.
Fixes the issue that caused the back color of ConditionalsFormat incorrect.
Fixes the issue that caused the OverFlowException while loading an Excel file.
Fixes the issue that caused the "object reference not set to an instance of an object" error when saving the Excel using custom OTF font to pdf.
Fixes the issue that caused incorrect number format when the thread culture is not invariant culture.
Fixes the issue that caused the Accounting number format pushed the $ symbol outside the cell border when converting to PDF.
Fixes the issue that change the PrimaryCategoryAxis.CategoryType property didn't work when loading an existing chart.
Fixes the issue that caused the ConditionalFormatWrapper.Priority property didn't work.
Fixes the issue that caused the AutoFitColumn method didn't work when the cell contains date time.
Spire.PDFViewer
New features:
Add PdfDocumentViewer.SearchText(string searchText, Color highlightColor, bool ignoreCase) method to support the case sensitive option.
Adjustments:
Obsoletes the Spire.PdfViewer.Forms.PdfDocumentViewer(PdfViewer).Print method, use the Spire.PdfViewer.Forms.PdfDocumentViewer(PdfViewer).PrintDoc method instead.
Obsoletes the Spire.PdfViewer.Forms.PdfDocumentViewer(PdfViewer).PrintDocument property, use the Spire.PdfViewer.Forms.PdfDocumentViewer(PdfViewer).PdfPrintSettings property instead.
Spire.DocViewer
New features:
Adds VerticalScroll.Visible and HorizontalScroll.Visible properties to support hiding the viewer's scroll bar in WinForm application.
Bug solutions:
Fixes the issue that caused extra pages when displaying.
Spire.Barcode
New features:
Publishes the BarcodeSettings.DataMatrixSymbolShape property to support specifying the shape of DataMatrix when creating it.
Adds two properties for Aztec Code.
User avatar
amy.zhao
 
Posts: 2251
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.DataExport

Who is online

Users browsing this forum: No registered users and 1 guest