
An independent Office library that allows developers to create, edit, convert, print Word,Excel,PowerPoint and PDF documents, and to generate and scan 1D&2D barcodes within Java applications.


| Spire.Office for Java 7.6.4 . In this version, Spire.XLS for Java supports setting whether to export hidden worksheets when converting Excel to HTML; Spire.Presentation for Java supports cropping pictures in PowerPoint and setting default alternate font for format conversion; Spire.Doc for Java enhances the conversion from Word to PDF and Word to HTML. Additionally, many known bugs have been fixed successfully. More details are listed below. | |||||
| Here is a list of changes made in this release | |||||
| Spire.XLS for Java | |||||
| New feature | SPIREXLS-3865 | Supports setting whether to export hidden worksheets when converting Excel to HTML. |
| Workbook book=new Workbook(); | ||
| book.loadFromFile("test.xlsx"); | ||
| //false--- export the hiden worksheets | ||
| //true--- not export the hiden worksheets | ||
| book.saveToHtml("output.html",false); | ||
| New feature | SPIREXLS-3872 | After converting Excel to HTML, a contrasting color border is added to the currently selected tab in the converted HTML. |
| New feature | SPIREXLS-3873 | After converting Excel to HTML, the spacing on both sides is added to the text of the worksheet tabs. |
| Bug | SPIREXLS-3724 | Fixes the issue that updates chart data with wrong results. |
| Bug | SPIREXLS-3764 | Fixes the issue that the content exceeded the cells after Excel was converted to images. |
| Bug | SPIREXLS-3803 | Fixes the issue that "NullPointerException" was thrown when converting Excel to images. |
| Bug | SPIREXLS-3815 | Fixes the issue that the background color and text color of the worksheet tab changed after converting Excel to HTML. |
| Bug | SPIREXLS-3831 | Fixes the issue that the application hangs when converting Excel to PDF. |
| Bug | SPIREXLS-3832 | Fixes the issue that sparklines were lost after copying sheets. |
| Bug | SPIREXLS-3841 | Fixes the issue that macros were lost after saving the document. |
| Bug | SPIREXLS-3867 | Fixes the issue that the application throws "ArrayIndexOutOfBoundsException" when loading an XML file. |
| Bug | SPIREXLS-3871 | Fixes the issue that the content was offset after Excel was converted to HTML. |
| Bug | SPIREXLS-3875 | Fixes the issue that setting DPI did not work when converting charts to images. |
| Bug | SPIREXLS-3877 | Fixes the issue that some data values were incorrect after converting Excel to PDF. |
| Bug | SPIREXLS-3907 | Fixes the issue that setting the cell background color to transparent does not work. |
| Spire.Presentation for Java | ||
| Category | ID | Description |
| New feature | SPIREPPT-1848 | Supports setting default alternate font for format conversion. |
| Presentation.setDefaultFontName("Arial"); | ||
| Presentation ppt = new Presentation(); | ||
| ppt.loadFromFile(inputFile); | ||
| ppt.saveToFile(outputFile, FileFormat.PDF); | ||
| //Used to reset the document conversion default font | ||
| Presentation.resetDefaultFontName(); | ||
| New feature | SPIREPPT-1962 | Supports cropping pictures in PowerPoint. |
| SlidePicture slidePicture= (SlidePicture)presentation.getSlides().get(0).getShapes().get(0); | ||
| //The crop start coordinates are adjusted according to the position of the original picture | ||
| slidePicture.crop(slidePicture.getLeft()+50f,slidePicture.getTop()+50f,100f,200f); | ||
| Bug | SPIREPPT-1945 | Fixes the issue that the application throws "ArrayIndexOutOfBoundsException" when setting custom font files. |
| Bug | SPIREPPT-1959 | Optimizes the memory consumption of conversion from PowerPoint to images. |
| Spire.Doc for Java | ||
| Category | ID | Description |
| Bug | SPIREDOC-7542 | Fixes the issue that the content format was incorrect after converting Word to PDF. |
| Bug | SPIREDOC-7574 | Fixes the issue that caused incorrect page number and blank page after converting Word to PDF. |
| Bug | SPIREDOC-7848 | Fixes the issue that the application threw "OutOfMemory" when converting Word to PDF. |
| Bug | SPIREDOC-7754 | Fixes the issue that the application threw "OutOfMemoryError" when converting Word to PDF in multithreading. |
| Bug | SPIREDOC-7757 | Fixes the issue that the application threw "NullPointerException" when converting Word to HTML. |
| Bug | SPIREDOC-7814 | Fixes the issue that the position of text was incorrect after converting Word to PDF. |
| Bug | SPIREDOC-7844 | Fixes the issue that caused extra content after saving Word documents.. |
| Bug | SPIREDOC-7861 | Fixes the issue that the application threw "This is not a structured storage file." when merging Word documents. |
| Bug | SPIREDOC-7894 | Fixes the issue that failed to find and highlight keyword in Word. |
| Bug | SPIREDOC-7253 | Fixes the issue that the application threw "NullPointerException" when calling the autoFit method of table. |
| Bug | SPIREDOC-7335 | Fixes the issue that the pagination was incorrect after converting Word to PDF. |
| Bug | SPIREDOC-7523 | Fixes the issue that the image location was incorrect after converting Word to PDF. |
| SPIREDOC-7753 | ||
| SPIREDOC-7929 | ||
| Bug | SPIREDOC-7709 | Fixes the issue that the content was incorrect after using NewEngine to convert Word to PDF. |
| SPIREDOC-7788 | ||
| SPIREDOC-7893 | ||
| Bug | SPIREDOC-7823 | Fixes the issue that it failed to open the added image Ole in Word. |
| Bug | SPIREDOC-7847 | Fixes the issue that the application threw "NullPointerException" when loading Word document. |
| Bug | SPIREDOC-7849 | Fixes the issue that the textbox was truncated after converting Word to PDF. |
| Bug | SPIREDOC-7853 | Fixes the issue that the text wrapping was incorrect after converting Word to PDF. |
| Bug | SPIREDOC-7908 | Fixes the issue that caused incorrect page number after converting Word to PDF. |
| Bug | SPIREDOC-7946 | Fixes the issue that the image format was incorrect after converting Word to PDF. |
| Bug | SPIREDOC-7949 | Fixes the issue that the text was lost after converting Word to PDF. |
| Bug | SPIREDOC-7950 | Fixes the issue that the table location was incorrect after converting Word to PDF. |
| Spire.PDF for Java | ||
| Category | ID | Description |
| Bug | SPIREPDF-5257 | Fixes the issue that there are extra black borders after converting PDF to images.
|