We are excited to announce the release of Spire.Office 7.12.0. In this version, Spire.Doc supports setting the transparency of the fill color for shapes; Spire.PDF adds a method to compress PDF documents and supports converting PDF to PowerPoint; Spire.XLS supports a variety of new formulas and "SHA-512" encryption scheme. Besides, many known issues are fixed successfully in this version. More details are listed 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.Doc.dll v10.11.9
- Spire.Pdf.dll v8.11.10
- Spire.XLS.dll v12.11.3
- Spire.Presentation.dll v7.11.2
- Spire.Email.dll v5.11.10
- Spire.DocViewer.Forms.dll v7.10.0
- Spire.PdfViewer.Forms.dll v7.10.0
- Spire.PdfViewer.Asp.dll v7.10.0
- Spire.Spreadsheet.dll v6.12.0
- Spire.OfficeViewer.Forms.dll v7.12.0
- Spire.Barcode.dll v6.8.0
- Spire.DataExport.dll v4.8.0
- Spire.DataExport.ResourceMgr.dll v2.1.0
Click the link to get the version Spire.Office 7.11.0:
More information of Spire.Office new release or hotfix:
Here is a list of changes made in this release
Spire.Doc
Category | ID | Description |
New feature | SPIREDOC-8443 | Supports setting the transparency of the fill color for shapes.
Paragraph paragraph = section.AddParagraph(); Spire.Doc.Fields.TextBox textbox1 = paragraph.AppendTextBox(100, 50); textbox1.Format.FillColor = Color.Red; textbox1.FillTransparency = 0.45; |
Bug | SPIREDOC-5456 | Fixes the issue that the text format was incorrect when converting Word to PDF. |
Bug | SPIREDOC-5718 | Fixes the issue that paging was incorrect when converting Word to PDF. |
Bug | SPIREDOC-7350 SPIREDOC-7605 |
Fixes the issue that the underline of the header overlapped the table border when converting Word to PDF. |
Bug | SPIREDOC-8539 | Fixes the issue that the text format was incorrect when converting RTF to PDF. |
Bug | SPIREDOC-8635 | Fixes the issue that it failed to merge data when mail merging. |
Bug | SPIREDOC-8636 | Fixes the issue that the program threw System.InvalidOperationException when mail merging. |
Bug | SPIREDOC-8691 | Fixes the issue that doc.HasChanges returned false after modifying the content in content control when opening tracking revision function. |
Bug | SPIREDOC-8709 | Fixes the issue that the content lost when converting Word to PDF. |
Bug | SPIREDOC-8785 | Fixes the issue that the program threw System.NullReferenceException when converting Word to PDF. |
Spire.PDF
Category | ID | Description |
New feature | SPIREPDF-2713 | Adds a new method to compress PDF documents.
PdfCompressor compressor = new PdfCompressor(fileName); compressor.CompressToFIle(outputName); |
New feature | - | Supports .NET 7.0. Supports converting PDF to PPTX. PdfDocument pdf = new PdfDocument(); pdf.LoadFromFile(inputFile); pdf.SaveToFile(outputFile, FileFormat.PPTX) |
New feature | SPIREPDF-2534 SPIREPDF-4641 |
Adds a new method of compressing PDF document.
PdfCompressor compressor = new PdfCompressor(fileName); compressor.CompressToFIle(outputName); |
New feature | SPIREPDF-5598 | PdfTextReplacer interface supports ignoring case.
PdfDocument doc = new PdfDocument(); doc.LoadFromFile(input); PdfPageBase page = doc.Pages[0]; PdfTextReplacer replacer = new PdfTextReplacer(page); PdfTextReplaceOptions option = new PdfTextReplaceOptions(); options.ReplaceType = ReplaceActionType.IgnoreCase; replacer.Options = option; replacer.ReplaceText("cash", "999"); doc.SaveToFile("output.pdf", FileFormat.PDF); |
Bug | SPIREPDF-1264 SPIREPDF-5608 |
Fixes the issue that the content was incorrect when converting PDF to images. |
Bug | SPIREPDF-5443 | Fixes the issue that the program threw System.ArgumentException when converting PDF to Excel. |
Bug | SPIREPDF-5527 | Fixes the issue that it failed to find cross-line text. |
Bug | SPIREPDF-5556 | Fixes the issue that it failed to get attachments. |
Bug | SPIREPDF-5591 | Fixes the issue that the background color lost after drawing TIFF images on page. |
Bug | SPIREPDF-5596 | Fixes the issue that the text color was changed after drawing TIFF images on page. |
Bug | SPIREPDF-3886 SPIREPDF-3932 |
Fixes the issue that printing result was incorrect when the screen font display size was not 100%. |
Bug | SPIREPDF-4506 | Fixes the issue that the program threw System.ArgumentNullException after setting PdfFreeTextAnnotation opacity to 1f and converting PDF to image. |
Bug | SPIREPDF-5196 | Fixes the issue that the compression of PDF was invalid. |
Bug | SPIREPDF-5363 | Fixes the issue that character spacing increased when converting PDF to image. |
Bug | SPIREPDF-5488 | Fixes the issue that the program threw System.ArgumentException when printing a PDF with A0 size. |
Bug | SPIREPDF-5514 | Fixes the issue that the content style was missing when converting PDF to Word. |
Bug | SPIREPDF-5554 | Fixes the issue that top left image lost sing when converting OFD to PDF. |
Bug | SPIREPDF-5557 | Fixes the issue that the image color changed when converting PDF to PDFX1A2001. |
Bug | SPIREPDF-5563 | Fixes the issue that the program threw System.IndexOutOfRangeException when converting PDF to image. |
Bug | SPIREPDF-5581 | Fixes the issue that the result of the finding text was incorrect. |
Spire.XLS
Category | ID | Description |
New feature | SPIREXLS-4120 | Supports CEILING.MATH formula.
Workbook workbook = new Workbook(); workbook.Worksheets[0].Range["A1"].Formula = "CEILING.MATH(-2.78,5,-1)"; workbook.CalculateAllValue(); workbook.SaveToFile("1.xlsx",ExcelVersion.Version2016); |
New feature | SPIREXLS-4195 | Supports BITOR formula.
Workbook workbook = new Workbook(); workbook.Worksheets[0].Range["A1"].Formula = "BITOR(23,10)"; workbook.CalculateAllValue(); workbook.SaveToFile("1.xlsx",ExcelVersion.Version2016); |
New feature | SPIREXLS-4199 | Supports BITAND formula.
Workbook workbook = new Workbook(); workbook.Worksheets[0].Range["A1"].Formula = "BITAND(23,10)"; workbook.CalculateAllValue(); workbook.SaveToFile("1.xlsx",ExcelVersion.Version2016); |
New feature | SPIREXLS-4212 | Supports BITLSHIFT formula.
Supports BITLSHIFT formula. Workbook workbook = new Workbook(); workbook.Worksheets[0].Range["A1"].Formula = "BITLSHIFT(23,2)"; workbook.CalculateAllValue(); workbook.SaveToFile("1.xlsx",ExcelVersion.Version2016); |
New feature | SPIREXLS-4214 | Supports BITRSHIFT formula.
Workbook workbook = new Workbook(); workbook.Worksheets[0].Range["A1"].Formula = "BITRSHIFT(23,2)"; workbook.CalculateAllValue(); workbook.SaveToFile("1.xlsx",ExcelVersion.Version2016); |
New feature | SPIREXLS-4191 | Supports grouping shape.
Workbook workbook = new Workbook(); Worksheet worksheet = workbook.Worksheets[0]; IPrstGeomShape shape1 = worksheet.PrstGeomShapes.AddPrstGeomShape(1, 3, 50, 50, PrstGeomShapeType.RoundRect); IPrstGeomShape shape2 = worksheet.PrstGeomShapes.AddPrstGeomShape(5, 3, 50, 50, PrstGeomShapeType.Triangle); GroupShapeCollection groupShapeCollection = worksheet.GroupShapeCollection; groupShapeCollection.Group(new Spire.Xls.Core.IShape[] { shape1,shape2}); workbook.SaveToFile("1.xlsx",ExcelVersion.Version2013); |
New feature | SPIREXLS-4194 | Supports "SHA-512" encryption scheme. |
New feature | SPIREXLS-4200 | Supports setting the layout pattern of the entire pivot table.
xlsPivotTable.Options.ReportLayout = PivotTableLayoutType.Tabular; |
Bug | SPIREXLS-4161 | Fixes the issue that the border and the style of table lost after converting HTML to Excel. |
Bug | SPIREXLS-4163 | Fixes the issue that the program threw System.NullReferenceException when getting the color of conditional formatting. |
Bug | SPIREXLS-4164 | Fixes the issue that the content had an extra comma after converting chart to images. |
Bug | SPIREXLS-4182 | Fixes the issue that the program did not throw an error when decrypting excel file with a wrong password. |
Bug | SPIREXLS-4189 | Fixes the issue that there were blank columns after deleting hidden columns. |
Bug | SPIREXLS-4197 | Fixes the issue that the content of the result document was different from that of the original document after the document was loaded and saved. |
Bug | SPIREXLS-4211 | Fixes the issue that the double quotation marks were incorrect after converting Excel to CSV. |
Bug | SPIREXLS-4218 | Fixes the issue that the result of the cell range calculation was incorrect. |
Bug | SPIREXLS-4227 | Fixes the issue that the program threw an error "Unknown font" when getting RTF text of cell range. |
Bug | SPIREXLS-4231 | Fixes the issue that the program threw an error "Shapes fail to be rendered" when converting Excel to PDF. |
Bug | SPIREXLS-4245 | Fixes the issue that the program threw System.OutOfMemoryException when converting Excel to PDF. |
Bug | SPIREXLS-4247 | Fixes the issue that the format was inconsistent after converting HTML to Excel. |
Bug | SPIREXLS-4252 | Fixes the issue that the slicers lost after saving files as stream. |
Bug | SPIREXLS-4254 | Fixes the issue that there was a prompt of content error when opening the saved document after OS language area was changed. |
Bug | SPIREXLS-4258 | Fixes the issue that the program threw System.NullReferenceException when copying sheets. |
Spire.Presentation
Category | ID | Description |
Bug | SPIREPPT-2086 | Fixes the issue that the chart data displayed incorrectly when creating charts with data sources containing null values. |
Bug | SPIREPPT-2100 | Fixes the issue that the shapes was moved to the left when combining shapes and setting the Flip Horizontal style. |
Bug | SPIREPPT-2104 | Fixes the issue that the parameters changed in the navigation bar when copying a PowerPoint page to another PowerPoint. |
Spire.Spreadsheet
Category | ID | Description |
Bug | SPREADSHEET-210 | Fixes the issue that the column names overlapped after deleting columns. |