The Apache POI project is pleased to announce the release of POI 5.2.3. Featured are a handful of new areas of functionality, and numerous bug fixes. See the downloads page for binary and source distributions: https://poi.apache.org/download.html Release Notes Changes ------------ The most notable changes in this release are: * upgrade dependencies: log4j-api 2.18.0, xmlbeans 5.1.1, xmlsec 3.0.0, graphics2d 0.40, pdfbox 2.0.26 ... * Avoid some more possible overly large memory allocations on certain input documents * Support capitalized text in WordExtractors [#63575,#63576] * Fix issues with some Excel functions [#65988,#66022,#66047,#66087,#66098,#66181] * Support more Excel functions [#github-330,#58468,#66083,#66090,#66092,#66093,#66094,#66095,#66097,#66105] * Shifting Excel rows or columns can damage formulas in tables [#66215] * Some Password protected XLS files are not rea [#66115] * SXSSF doesn't update dimension field [#65562] * SXSSFWorkbook should work even when fonts not installed on OS [#66230] * Issue with orphaned (in package) images and notes post slide removal [#66242] * Issues with XSSFTables [#66211,#66212,#66213] A full list of changes is available in the change log: https://poi.apache.org/changes.html. People interested should also follow the dev mailing list to track further progress. Release Contents ---------------- This release comes in two forms: - pre-built binaries containing compiled versions of all Apache POI components and documentation (poi-bin-5.2.3-20220909.zip or poi-bin-5.2.3-20220909.tgz) - source archive you can build POI from (poi-src-5.2.3-20220909.zip or poi-src-5.2.3-20220909.tgz) Unpack the archive and use the following command to build all POI components with JDK 1.8 or higher: gradlew jar Pre-built versions of all POI components are also available in the central Maven repository under Group ID "org.apache.poi" and Version "5.2.3" All release artifacts are accompanied by MD5 checksums and PGP signatures that you can use to verify the authenticity of your download. The public key used for the PGP signature can be found at https://svn.apache.org/repos/asf/poi/tags/REL_5_2_3/KEYS About Apache POI ----------------------- Apache POI is well-known in the Java field as a library for reading and writing Microsoft Office file formats, such as Excel, PowerPoint, Word, Visio, Publisher and Outlook. It supports both the older (OLE2) and new (OOXML - Office Open XML) formats. See https://poi.apache.org/ for more details