Spire.Office for Java 7.6.4 is released

Wednesday, 22 June 2022 02:47

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.