Spire.Office for Java 8.3.6 is Patch

时间:2022-08-10 01:10:38

Developers can use Spire.Office for Java to perform a wide range of office document operations in Java applications, such as opening, creating, modifying, converting and printing Word, Excel, PowerPoint and PDF documents, generating and scanning 1D&2D barcodes.

As an independent Office Java library, Spire.Office for Java doesn't need Microsoft Office to be installed on either the development or target systems.

Spire.Office for Java 8.3.6 is Patch

 

Here is a list of changes made in this release
Spire.Doc for Java
Category ID Description
New feature SPIREDOC-8859 Supports modifying the revision time.
SimpleDateFormat formatter = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
String dateString = "2023/3/1 00:00:00";
Date date = formatter.parse(dateString);
revison.setDateTime(date);
Bug SPIREDOC-8645 Fixes the issue that the table content was incorrect when converting Word to PDF.
Bug SPIREDOC-8960 Fixes the issue that there is extra whitespace when converting Word to PDF.
Bug SPIREDOC-8855 Fixes the issue that the text display in SmartArt was incomplete when converting Word to PDF.
Bug SPIREDOC-8866 Fixed the issue that SmartArt was missing when converting Word to PDF
Bug SPIREDOC-8928 Fixes the issue that the table layout distorted when setting fixed column width
Bug SPIREDOC-8975 Fixes the issue that the number of document pages was incorrect.
Bug SPIREDOC-8978 Fixes the issue that the TOC style changed after updating
Bug SPIREDOC-9036 Fixes the issue that the application threw” NullPointerException” when converting Word to PDF
Bug SPIREDOC-9037 Fixes the issue that an error was reported when the result document was opened with MS Word after loading and saving as a new document.
Bug SPIREDOC-9056 Fixes the issue that the document could not be edited after repeatedly setting ProtectionType.Allow_Only_Revisions.
Bug SPIREDOC-9085 Fixes the issue that the line breaks were inconsistent when opening result document in MS Word after saving as new document
Bug SPIREDOC-9086 Fixes the issue that the line break styles lost when converting RTF to PDF.
Bug SPIREDOC-9110 Fixes the issue that the document format was inconsistent with the original document after cloning a section
Bug SPIREDOC-9138 Fixes the issue that the content was inconsistent after converting RTF to Word.
Spire.PDF for Java
Category ID Description
New feature SPIREPDF-5796 Optimizes memory consumption when printing PDF documents.
New feature SPIREPDF-5833 Supports scaling when printing PDF documents.
pdfDocument.getPrintSettings().selectSinglePageLayout
(PdfSinglePageScalingMode.Custom_Sacle, true, customScaling);
Bug SPIREPDF-5536 Fixes the issue that the application threw "java.lang.NullPointerException" when extracting table content.
Bug SPIREPDF-5558 Fixes the issue that some spaces were lost when extracting tables to CSV
Bug SPIREPDF-5750 Fixes the issue that the stamp was lost after loading the document and re-saving.
Bug SPIREPDF-5762 Fixes the issue that the application threw "NullPointerException" when saving encrypted PDF documents.
Bug SPIREPDF-5803 Fixes the issue that the checkbox positions changed after flattening PDF forms.
Bug SPIREPDF-5822 Fixes the issue that the Square annotation types could not set transparency.
Bug SPIREPDF-5827 Fixes the issue that the application threw "OutOfMemoryError" when converting PDFs to PDFA1B after applying a license.
Bug SPIREPDF-5834 Fixes the issue that the application threw "Invalid date string" error when converting PDFs to PDFA3A in Italian environment.
Spire.XLS for Java
Category ID Description
New feature SPIREXLS-3537 Support converting Excel to standalone HTML files.
Workbook wb = new Workbook();
wb.loadFromFile("data/mytest.xlsx");
HTMLOptions.Default.isStandAloneHtmlFile(true);
wb.saveToFile("result.html", FileFormat.HTML);
New feature SPIREXLS-3791 Support saving the entire Excel file to an HTML stream.
Workbook wb = new Workbook();
wb.loadFromFile("data/mytest.xlsx");
FileOutputStream fileStream = new FileOutputStream("output/saveStream_result.html");
wb.saveToStream(fileStream, FileFormat.HTML);
fileStream.close();
New feature SPIREXLS-4385 support adding conditional formatting to PivotFields and DataFields in pivot tables.
PivotTable table = (PivotTable)worksheet.getPivotTables().get(0);
PivotConditionalFormatCollection pcfs = table.getPivotConditionalFormats();
PivotConditionalFormat pc = pcfs.addPivotConditionalFormat(table.getColumnFields().get(0));
//PivotConditionalFormat pc = pcfs.addPivotConditionalFormat(table.getRowFields().get(0));
//PivotConditionalFormat pc = pcfs.addPivotConditionalFormat(table.getDataFields().get(0));
//PivotConditionalFormat pc = pcfs.addPivotConditionalFormat(table.getPageFields().get(0));
IConditionalFormat cf = pc.addCondition();
cf.setFormatType(ConditionalFormatType.ContainsBlanks);
cf.setFillPattern(ExcelPatternType.Solid);
cf.setBackColor(Color.Red);
New feature SPIREXLS-4513 Support replacing part of the text within a cell.
sheet.getCellList().get(0).textPartReplace("Office", "Spire");
Bug SPIREXLS-4489 Fixes the issue that the guide lines lost when converting charts to images.
Bug SPIREXLS-4490 Fixes the issue that some data positions were moved down when converting Excel to images.
Bug SPIREXLS-4508 Fixes the issue that the double underline became a single underline when converting Excel to images.
Bug SPIREXLS-4510 Fixes the issue that the program reported an error "java.lang.NullPointerException" when adding a footer to Excel
Bug SPIREXLS-4511 Fixes the issue that the program reported an error "Invalid sectionId of Header Footer image" when converting Excel to PDF.
Bug SPIREXLS-4514 Fixes the issue that the progress color in the progress bar was lost when converting Excel to images.
Bug SPIREXLS-4537 Fixes the issue that the X-axis data offset when converting charts to images.
Bug SPIREXLS-4547 Fixes the issue that the content was incorrect when converting Excel to PDF.
Spire.Presentation for Java
Category ID Description
New feature SPIREPPT-2203 Supports DPT and DPS file formats.
Presentation presentation = new Presentation();
presentation.loadFromFile("sample.dps", FileFormat.DPS);
presentation.saveToFile("result.dpt", FileFormat.DPT);
Bug SPIREPPT-2204 Improves the behavior of throwing exceptions when loading documents as a stream.
Bug SPIREPPT-2132 Fixed the issue that the fonts were wrong after converting HTML to PowerPoint.
Bug SPIREPPT-2171 Fixes the issue that it threw Unknown file format exception when loading PPT documents.
Bug SPIREPPT-2206 Fixes the issue that the colors in bar charts were incorrect after converting PPT to images.
Bug SPIREPPT-2207 Fixes the issue that it threw NullPointerException when executing ppt.getBytes() method.