We are glad to announce the release of 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.
Click the link to download Spire.Office for Java 7.6.4:
Here is a list of changes made in this release
Spire.XLS for Java
| Category | ID | Description |
| 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 SPIREDOC-7753 SPIREDOC-7929 |
Fixes the issue that the image location was incorrect after converting Word to PDF. |
| Bug | SPIREDOC-7709 SPIREDOC-7788 SPIREDOC-7893 |
Fixes the issue that the content was incorrect after using NewEngine to convert Word to PDF. |
| 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. |
