We’re glad to announce the release of Spire.XLS for Java 15.6.3. This version starts to support font stream when applying custom fonts, and support retrieving the cell location of embedded images. Meanwhile, a number of known bugs have been successfully fixed. More details are listed below.
Here is a list of changes made in this release:
| Category | ID | Description |
| New feature | SPIREXLS-5817 | Added support for font stream data when applying custom fonts.
Workbook book = new Workbook();
FileInputStream stream = new FileInputStream("fontpath");
book.setCustomFontStreams(new FileInputStream[]{stream});
|
| New feature | SPIREXLS-5821 | Added support for setting setIsSaveBlankCell to control whether to export extra blank cells when converting Excel to HTML.
Workbook workbook = new Workbook(); workbook.loadFromFile(inputFile); WorksheetsCollection sheets = workbook.getWorksheets(); HTMLOptions options = new HTMLOptions(); options.setImageEmbedded(true); options.setStyleDefine(HTMLOptions.StyleDefineType.Inline); options.setIsSaveBlankCell(true); |
| New feature | SPIREXLS-5822 | Added support for retrieving the cell location of embedded images.
Worksheet worksheet=wb.getWorksheets().get(0); ExcelPicture[] cellimages=worksheet.getCellImages(); cellimages[0].getEmbedCellName() |
| Bug | SPIREXLS-5522 | Fixed the issue where sheet.getCellImages() could not retrieve images inserted by Office 365. |
| Bug | SPIREXLS-5803 | Fixed the issue where page numbering was incorrect when converting Excel to PDF. |
| Bug | SPIREXLS-5812 | Fixed the issue that caused a "NullPointerException" when copying Excel and saving it as .xls. |
| Bug | SPIREXLS-5813 | Fixed the issue where text content was truncated when converting Excel to PDF. |
| Bug | SPIREXLS-5815 | Fixed the issue that caused the error "For input string: 'OP_ID'" when converting CSV to Excel. |
| Bug | SPIREXLS-5816 | Fixed the issue where autoFitColumns() behaved incorrectly. |
| Bug | SPIREXLS-5823 | Fixed the issue where cell styling was inconsistent when converting Excel to HTML with setIsFixedTableColWidth enabled. |
| Bug | SPIREXLS-5844 | Fixed the issue that caused the error "Specified argument was out of the range of valid values" when converting Excel to HTML. |
| Bug | SPIREXLS-5852 SPIREXLS-5855 |
Fixed the issue where Excel was rendered incorrectly when converting to HTML. |
Click the link to download Spire.XLS for Java 15.6.3: