You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by PJ Fanning <fa...@yahoo.com.INVALID> on 2022/09/17 10:52:32 UTC
[ANNOUNCE] Apache POI 5.2.3 released
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
On behalf of the Apache POI PMC,
PJ
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: [ANNOUNCE] Apache POI 5.2.3 released
Posted by Tim Allison <ta...@apache.org>.
Thank you, PJ and team!
On Sat, Sep 17, 2022 at 6:52 AM PJ Fanning <fa...@yahoo.com.invalid> wrote:
>
> 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
>
> On behalf of the Apache POI PMC,
> PJ
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: [ANNOUNCE] Apache POI 5.2.3 released
Posted by Andreas Reichel <an...@manticore-projects.com>.
Greetings.
> To find which functions your copy of Apache POI supports, use
> getSupportedFunctionNames() to get a list of the implemented function
> names. For the list of functions that POI knows the name of, but
> doesn't currently implement, use getNotSupportedFunctionNames()
Awesome, exactly what I have been looking for.
I would check it out and maybe we can work on this.
BTW: the maturity of POI for Spreadsheets is impressive. I remember
there was a time when I pulled SNAPSHOTS oftenly just to benefit from
fixes or features. Now, even such a massive release is just "nice to
have" and welcome. Please read it as a compliment!
Cheers
Andreas
Re: [ANNOUNCE] Apache POI 5.2.3 released
Posted by PJ Fanning <fa...@yahoo.com.INVALID>.
Hi Andreas,
https://poi.apache.org/components/spreadsheet/formula.html has a 'Supported Functions' section which describes how to get a list of supported and unsupported functions.
See also https://poi.apache.org/components/spreadsheet/eval-devguide.html - it has some details about implementing functions and a slightly out of date list of supported functions.
Regards,
PJ
On Saturday 17 September 2022 at 11:56:26 IST, Andreas Reichel <an...@manticore-projects.com> wrote:
On Sat, 2022-09-17 at 10:52 +0000, PJ Fanning wrote:
> Support more Excel functions [#github-
> 330,#58468,#66083,#66090,#66092,#66093,#66094,#66095,#66097,#66105]
Greetings!
Thank you for the amazing, great work! We do love POI.
Question please: is there a list of "missing" Excel functions, we still
would need to implement? I could assign some resources to close any gap
on that part.
Cheers and warm regards
Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: [ANNOUNCE] Apache POI 5.2.3 released
Posted by Andreas Reichel <an...@manticore-projects.com>.
On Sat, 2022-09-17 at 10:52 +0000, PJ Fanning wrote:
> Support more Excel functions [#github-
> 330,#58468,#66083,#66090,#66092,#66093,#66094,#66095,#66097,#66105]
Greetings!
Thank you for the amazing, great work! We do love POI.
Question please: is there a list of "missing" Excel functions, we still
would need to implement? I could assign some resources to close any gap
on that part.
Cheers and warm regards
Andreas