News & Releases
|
|

Spire.Office 6.1 is released
We are agog to announce the release of Spire.Office 6.1. This version brings some new features. For instance, Spire.XLS supports using newly added formulas of MS Excel2019 and adding some new features such as the availability of removing borders of pictures, the conversion from shape to picture, Spire.PDF supports customizing signed image when signing PDF, Spire.Presentation supports embedding ZIP objects into PPTX files, Spire.PDFViewer supports displaying page labels and many more. What’s more, a lot of bugs have been successfully fixed as well. More details are given below.
In this version, the most recent versions of Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.Email, Spire.DocViewer, Spire.PDFViewer, Spire.Spreadsheet, Spire.OfficeViewer, Spire.DataExport, Spire.Barcode are included.
DLL Versions:
- Spire.License.dll 1.3.8
- Spire.Barcode.dll 5.1.4
- Spire.DataExport.dll 4.1.9
- Spire.Doc.dll 9.1.7
- Spire.DocViewer.Forms.dll 6.1.0
- Spire.Email.dll 4.1.2
- Spire.Pdf.dll 7.1.10
- Spire.PdfViewer.Forms.dll 6.1.0
- Spire.Presentation.dll 6.1.4
- Spire.Spreadsheet.dll 5.1.0
- Spire.XLS.dll 11.1.4
Here is a list of changes made in this release
Spire.XLS
| Category | ID | Description |
| Optimization | SPIREXLS-2965 | Optimizes the speed of converting Excel to HTML. |
| New feature | SPIREXLS-2244 | Supports calculating newly added CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN of MS Excel2019. |
| New feature | SPIREXLS-2872 | Supports the function of not displaying the title of bubble chart.
chart.HasChartTitle = false; |
| New feature | SPIREXLS-2254 | Supports the function of removing the borders of pictures.
picture.Line.Visible = false or picture.Line.Weight = 0 |
| New feature | SPIREXLS-2990 | Supports the function of converting shape to picture.
Image img = shape.SaveToImage();
shape.SaveToImage(string fileName);
shape.SaveToImage(string fileName, ImageFormat imageFormat);
shape.SaveToImage(Stream fileStream);
shape.SaveToImage(Stream fileStream, ImageFormat imageFormat);
|
| New feature | SPIREXLS-3059 | Supports the function of compressing pictures in Excel.
Workbook book = new Workbook();
book.LoadFromFile(input);
foreach (Worksheet sheet in book.Worksheets)
{
foreach (ExcelPicture picture in sheet.Pictures)
{
picture.Compress(30);
}
}
book.SaveToFile(result, ExcelVersion.Version97to2003);
|
| Bug | SPIREXLS-2424 | Fixes the issue that getting the chart title failed. |
| Bug | SPIREXLS-2912 | Fixes the issue that the date data was incorrectly wrapped when converting Excel to PDF. |
| Bug | SPIREXLS-3002 | Fixes the issue that the application threw System.OverflowException when loading file. |
| Bug | SPIREXLS-3007 | Fixes the issue that the application threw System.ArgumentOutOfRangeException when loading and saving files. |
| Bug | SPIREXLS-3008 | Fixes the issue that the data bar of the conditional format was not displayed correctly when converting Excel to PDF. |
| Bug | SPIREXLS-3013 | Fixes the issue that creating a pivot table failed in the environment with Win10 64-bit and Italy region setting. |
| Bug | SPIREXLS-3018 | Fixes the issue that the text boxes could not be copied correctly. |
| Bug | SPIREXLS-3020 | Fixes the issue that the text font indentation was changed from condensed to standard when copying cell content. |
| Bug | SPIREXLS-3021 SPIREXLS-3037 SPIREXLS-3053 |
Fixes the issue that the application hung when converting Excel to Html. |
| Bug | SPIREXLS-3033 | Fixes the issue that the format of date data was incorrect when importing sheet data to data table. |
| Bug | SPIREXLS-3034 | Fixes the issue that inserting and deleting rows took a long time. |
| Bug | SPIREXLS-3041 | Fixes the issue that the data of the category label in the chart was incorrect when saving the chart to images. |
| Bug | SPIREXLS-3044 | Fixes the issue that the characters were garbled when converting CSV file with Turkish ISO-8859-9 encoding to xlsx file. |
Spire.Doc
| Category | ID | Description |
| Bug | SPIREDOC-3818 | Fixes the issue that the content of the converted PDF/XPS was incorrect when it contains right-to-left text. |
| Bug | SPIREDOC-5120 | Fixes the issue that no matches were found when finding the text. |
| Bug | SPIREDOC-5138 SPIREDOC-5191 SPIREDOC-5307 |
Fixes the issue that the content was incorrect after converting Word to PDF. |
| Bug | SPIREDOC-5159 SPIREDOC-5161 |
Fixes the issue that the text overlapped after converting Word to PDF. |
| Bug | SPIREDOC-5217 | Fixes the issue that page number was incorrect after converting Word to PDF. |
| Bug | SPIREDOC-5301 | Fixes the issue that the application threw the error "Object reference not set to an instance of an object" when converting Word to PDF. |
| Bug | SPIREDOC-5303 | Fixes the issue that it caused incorrect pagination after converting Word to PDF. |
| Bug | SPIREDOC-5338 | Fixes the issue that the bookmark location was changed after saving the Word document. |
| Bug | SPIREDOC-5341 | Fixes the issue that the lines were rendered incorrectly after converting Word to PDF. |
| Bug | SPIREDOC-5346 | Fixes the issue that the application threw the error "Index was outside of bounds of the array" when converting Word to PDF. |
| Bug | SPIREDOC-5348 | Fixes the issue that the equation was incorrect after saving to doc/docx file. |
| Bug | SPIREDOC-5370 | Fixes the issue that the list number value was incorrect after converting Word to PDF. |
| Bug | SPIREDOC-5386 | Fixes the issue that the application threw the error "Input string was not in a correct format" when loading the file. |
Spre.PDF
| Category | ID | Description |
| New Feature | SPIREPDF-1136 | Supports customizing signed image when signing PDF.
PdfSignature signature = new PdfSignature(doc, page, cert, "123456");
signature.ConfigureCustomGraphics(DrawGraphics);
private void DrawGraphics(PdfCanvas g)
{
PointF point1 = new PointF(10, 20);
PointF point2 = new PointF(25, 50);
PointF point3 = new PointF(60, 20);
PointF[] pntArr = { point1, point2, point3 };
PdfRGBColor color = new PdfRGBColor(Color.Red);
g.DrawPolygon(new PdfPen(color), pntArr);
g.DrawRectangle(new PdfPen(Color.Green), new RectangleF(70, 10, 20, 30));
g.DrawLine(new PdfPen(Color.Blue), new PointF(120, 50), new PointF(95, 5));
g.DrawLine(new PdfPen(Color.Blue), new PointF(100, 30), new PointF(130, 20));
}
|
| Bug | SPIREPDF-970 SPIREPDF-1791 SPIREPDF-3869 |
Fixes the issue that entering the PIN multiple times when using Smart Card certificate and USB token to sign PDF. |
| Bug | SPIREPDF-3554 | Fixes the issue that the converted PDFA3B document from PDF did not meet the PDFA3B standard. |
| Bug | SPIREPDF-3783 | Fixes the issue that content order was incorrect when extracting pdf text. |
| Bug | SPIREPDF-3851 | Fixes the issue that the table cell merged format was lost when converting PDF to Excel. |
| Bug | SPIREPDF-3872 | Fixes the issue that the application threw an error "The object reference is not set to the instance of the object" when converting PDF to Excel. |
| Bug | SPIREPDF-3914 | Fixes the issue that some characters were not converted successfully when converting XPS to PDF. |
| Bug | SPIREPDF-3937 | Fixes the issue that Justify alignment style of text in grid cells did not take effect. |
Spire.Presentation
| Category | ID | Description |
| New Feature | SPIREPPT-1385 | Supports embedding ZIP objects into PPTX files. (Note that 03PPT does not support this feature.)
String zipPath= "C:/test.zip";
Presentation ppt = new Presentation();
byte[] data = File.ReadAllBytes(zipPath);
Rectangle rec = new Rectangle(80, 60, 100, 100);
//The first parameter needs to be passed the complete file name
IOleObject ole = ppt.Slides[0].Shapes.AppendOleObject("test.zip", data, rec);
ole.ProgId = "Package";
Image image = Image.FromFile(@"E:\demoProducts\Image\logo.png");
IImageData oleImage = ppt.Images.Append(image);
ole.SubstituteImagePictureFillFormat.Picture.EmbedImage = oleImage;
ppt.SaveToFile(@"result.pptx", Spire.Presentation.FileFormat.Pptx2013);
|
| New Feature | - | Supports loading and printing PPT/PPTX containing mathematical formulas and converting to other document formats. |
| Bug | SPIREPPT-1395 | Fixes the issue that the size of shape inside it was changed when copying group shape. |
| Bug | SPIREPPT-1397 | Fixes the issue that the shape's position was changed after the value of a shape inside group shape was modified. |
| Bug | SPIREPPT-1398 | Fixes the issue that the content was stretched when printing multiple slides onto one page. |
| Bug | SPIREPPT-1398 | Fixes the issue that the position of a shape was changed when the height of the shape was modified after cloning it into another slide. |
Spire.Email
| Category | ID | Description |
| Adjustment | - | Change the parameter type of ImapClient.MarkAsDeleted(int sequqnceNo) method from String to int. |
Spire.PDFViewer
| Category | ID | Description |
| New Feature | SPIREPDFVIEWER-464 | Supports the function of displaying page labels |
| Bug | SPIREPDFVIEWER-448 | Fixes the issue that the white color of the picture was displayed as black. |
| Bug | SPIREPDFVIEWER-462 | Fixes the issue that Chinese characters were displayed in garbled characters. |
| Bug | SPIREPDFVIEWER-466 | Fixes the issue that the page rotating failed. |
| Bug | SPIREPDFVIEWER-467 | Fixes the issue that the background color of form fields was displayed incorrectly. |
Spire.Barcode
| Category | ID | Description |
| New Feature | - | Adds BarcodeScan class so that different instances can be created to call the Scan method.
BarcodeScan task1 = new BarcodeScan(); task1.Scan(bitmap, rectangle, barcodeType); |
| Bug | - | Fixes the issue that the application threw an exception "object reference is not set to an instance of an object" when using BarcodeScanner.Scan method with asynchronous delegates. |
| Bug | SPIREBARCODE-84 SPIREBARCODE-174 |
Fixes the issue that the scanned data of Code128 barcode was incorrect. |
| Bug | SPIREBARCODE-90 | Fixes the issue that the application hanged when scanning the picture without barcodes. |
| Bug | SPIREBARCODE-93 | Fixes the issue that the scanned data of QR-code was empty. |
| Bug | SPIREBARCODE-167 | Fixes the issue that barcodeSettings.Code128SetMode setting was invalid |