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


Spire.Office hotfix Version 2.16.18
Versions:
Spire.Doc.dll v6.0.23
Spire.Pdf.dll v3.9.375
Spire.XLS.dll v7.12.92
Spire.Email.dll V1.1.9
Spire.DocViewer.Forms.dll v2.4.24
Spire.PdfViewer.Forms.dll v2.12.36
Spire.PdfViewer.Asp.dll v2.12.36
Spire.Presentation.dll v2.8.61
Spire.Spreadsheet.dll v2.2.42
Spire.OfficeViewer.Forms.dll v2.16.18
Spire.DataExport.dll v3.5.133
Spire.DataExport.ResourceMgr.dll 1.6.71
Spire.Common.dll 1.2.730
Spire.License.dll v1.3.6
Spire.Barcode.dll v1.4.8
Spire.XLS
New Features:
Supports to add shapes to worksheet.
Code: Select all
sheet.PrstGeomShapes.AddPrstGeomShape(int row,int column,int width,int height,PrstGeomShapeType shapeType);

Supports to select the cell range to be visible when displayed as an OLE object.
Code: Select all
Workbook.SetOleSize(firstRow,firstColumn,lastRow,lastColumn);

Bug Fixes:
Fixes the issue that the result document changed to Protected View after saving .xlsx to .xls.
Fixes the issue that caused ArgumentOutOfRangeException when converting Excel to HTML.
Fixes the issue that caused the style of the chart missing when using SaveChartAsImage method.
Fixes the issue that caused the font changed when converting Excel to PDF.
Fixes the issue that caused the data format incorrect when converting Excel to pdf.
Fixes the issue that caused the formula result wrong in French environment.
Fixes the issue that caused result incorrect when getting the validation formula value.
Resolves the issue that caused Euro (€) sign lost when using DisplayedText property.
Fixes the issue that the value in the original cell range changed along with value which was set by range.Text property in the copied range.
Fixes the issue that caused IndexOutOfRangeException when loading file.
Fixes the issue that caused the process hanging when converting Excel to PDF.
Fixes the issue that caused the value type changed from text to number when importing data from datatable to Excel.
Fixes the issue that the method AutoFitColumns didn't work.
Spire.PDF
New Features:
Supports to print specific page.
Code: Select all
PdfDocument doc = new PdfDocument();
doc.LoadFromFile(filename);
doc.PrintSettings.SelectSomePages(new int[]{2,4});
doc.Print();
 

Exposes the name property of the layer.
Code: Select all
string name = doc.Layers[0].Name;

Supports to set the alignment for the signature content.
Code: Select all
signature.SignTextAlignment=SignTextAlignment.Right;

Supports to get the text by document structure.
Code: Select all
PdfDocument doc = new PdfDocument();
doc.LoadFromFile("Alcontrol - EDF.pdf");
PdfPageBase page = doc.Pages[0];
SimpleTextExtractionStrategy strategy = new SimpleTextExtractionStrategy();
string text = page.ExtractText(strategy);
FileStream fs = new FileStream("Alcontrol - EDF.txt", FileMode.Create);
StreamWriter sw = new StreamWriter(fs);
sw.Write(text);
sw.Flush();

Adjustments:
The PrintDocument object has been marked as obsolete, it only needs to set the PrintSettings when print. Example:
Code: Select all
PdfDocument doc = new PdfDocument("sample.pdf");
doc.PrintSettings.Landscape = true;
doc.Print();
 

The pageLayers object of Page has been marked as obsolete, use Layers object under PdfDocument instead. It must create the Graphics for the Layer with the CreateGraphics method when Add Layer. Example:
Code: Select all
PdfLayer layer = doc.Layers.AddLayer("red line", PdfVisibility.On);
PdfCanvas pcA = layer.CreateGraphics(doc.Pages[0].Canvas);
pcA.DrawLine(new PdfPen(PdfBrushes.Red, 1), new PointF(0, 100), new PointF(100, 100));
layer = doc.Layers.AddLayer("blue line");
PdfCanvas pcB = layer.CreateGraphics(doc.Pages[0].Canvas);
pcB.DrawLine(new PdfPen(PdfBrushes.Blue, 1), new PointF(0, 150), new PointF(100, 150));

Bug Fixes:
Fixes the issue that cannot delete layer.
Fixes the issue that caused the character wrong after deleting image.
Fixes the issue that the image cannot be deleted.
Fixes the issue that caused NullReferenceException when flatten form field.
Fixes the issue that the checkboxField is not checked after setting checkboxField.Checked as true.
Fixes the issue that caused content missing after replacing image.
Fixes the issue that caused the content in invisible region shows after creating Booklet.
Fixes the issue that caused the original content changed when appending a new page.
Fixes the issue that the object cloned from PdfDocument returns null.
Fixes the issue that caused the size of document increased after compressing images.
Fixes the issue that caused the background changed to black when converting PDF to XPS.
Fixes the issue that the size of document grows too much when converting image to pdf.
Fixes the issue that caused spot colors setting in image missing when drawing image to PDF.
Fixes the issue that custom properties don't work.
Fixes the issue that cannot delete custom properties.
Fixes the issue that caused small drilling holes missing when printing the PDF.
Fixes the issue that custom properties missing after setting own password.
Spire.Doc
Bug Fixes:
Fixes the issue that the path in INCLUDEPICTURE filed was incorrect after Mail Merge.
Fixes the issue that caused ArgumentOutOfRangeException when converting Word to PDF.
Fixes the issue that replace OLE data doesn't work.
Fixes the issue that caused extra lines when converting Word to HTML.
Fixes the issue that caused EndOfStreamException when loading a document.
Fixes the issue that caused the process hanging when using document.PageCount.
Fixes the issue that caused the text format changed to bold when converting Word to HTML.
Fixes the issue that caused extra black shade in table cell when converting Word to HTML.
Fixes the issue that caused the "The format of input string was incorrect" exception while loading HTML.
Fixes the issue that the list was incorrect after converting HTML to Word.
Fixes the issue that caused the style missing when converting HTML to Word.
Fixes the issue that caused one line changed to two lines after saving Word to PDF.
Spire.Presentation
New features:
Adds ShowMasterShape property for Slide to hide background graphics.
Adds new overloaded Print method to support to use the printdocument object.
Code: Select all
public void Print(PresentationPrintDocument presentationPrintDocument);

Exposes the TriggerShape property of InteractiveSequences.
Bug Fixes:
Fixes the issue where list items returned with no bullets or any kind of list formatting when inserting a HTML list.
Fixes the issue where the Animation/Transition time can't be set.
Fixes the issue that caused the table formatting of chart data lost.
Fixes the issue that caused the major units of Chart Axis incorrect when converting PPT with chart to Image.
Spire.PDFViewer
New features:
Add SearchText method in pdfDocumentViewer class to search and highlight text.
Spire.Spreadsheet
Bug Fixes:
Fixes the issue that caused NullReferenceException when opening a document.
Fixes the issue that caused image lost when displaying.
Fixes the issue that caused the border missing when displaying.
Fixes the issue that the sort&filter button displayed improperly.
Spire.Barcode
Bug Fixes:
Fixes the issue that when viewing the barcode from web page, it caused InvalidCastException after editing Barcode DpiX or DpiXY directly via BarCodeControl on Web Forms.
Fixes the issue that the generated barcode was blank when the barcode contains more than ten Arabic letters.
Spire.DocViewer
Bug Fixes:
Fixes the issue where the document displayed incompletely.
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