Re: Plea - test the POI 5.0.0 snapshot

Hi,

I also did a round of manual testing in various projects that are using
POI. Mostly XSSF and XWPF, mostly smaller documents, but various features
covered across these.

Issues:
* Found one issue where auto-sizing of columns with changed alignment
caused an NPE. Fixed on trunk now.
* Ran into some issue when trying to adjust code to create a chart. After
reworking the code to the XDDFChart interfaces, it throws an
"IndexOutOfBoundsException", maybe the code is incorrect, but we should at
least have better error messages on mis-use, I created
https://bz.apache.org/bugzilla/show_bug.cgi?id=65016 so we can investigate

things that we should note in the release notes as breaking
changes/migration/...:
* there are new names for modules for ooxml-schema
* some classes moved between packages, e.g. ExtractorFactory, no backwards
compatible change possible
* Some tool which makes use of CT... classes for Word document handling had
to be changed...: CTDocument1.Factory.parse instead of
CTBody.Factory.parse. These changes seem to be backwards compatible though,
i.e. new code also works with Apache POI 4.1.2
* Charting was reworked heavily, code likely needs adjustments

I will soon start the first regression-testing run so that we also see
where stand with the large corpus of test-documents.

Thanks Andi and PJ for doing the bulk of the work for this version! ...
Dominik.


On Sun, Dec 20, 2020 at 1:08 AM Andreas Reichel <
[email protected]> wrote:

> Good Morning Andreas and Team,
>
> thank you for the great work.
> We use POI 5 snapshot in our life environments for some time already
> (because we write very large files). Lots of different usecases:
>
> 1) reading from file into database
> 2) evaluating formulas
> 3) writing (formatted) reports
> 4) open the built spreadsheets in LibreOffice, Gnumeric and all
> versions of MS Excel
> 5) tested it with SQLSheet (an Excel sheet based JDBC driver)
> 6) tested with Java 11 and Java 8 (but not with Java 14/15)
>
> Although we do not create charts. And we use only the spreadsheet
> document.
> So from our point of view, it is stable and matured and works extremely
> well.
>
> Thank you again and cheers
> Andreas
>
>
>
> On Sat, 2020-12-19 at 13:52 +0100, Andreas Beeker wrote:
> > Dear POI users,
> >
> > we are shortly before releasing POI 5.0.0 and there have been some
> > breaking changes [1].
> > Notably the JPMS/JigSaw migration and the upgrade of the ECMA-376
> > schemas to the 5th edition.
> >
> > Please download the snapshot [2] and give it a try - especially with
> > the new schemas, I'm interested if documents created by POI still can
> > be opened without errors in various office applications.
> >
> > Thank you for your support.
> >
> > Andi
> >
> >
> > [1] http://poi.apache.org/changes.html
> >
> > [2]
> >
> https://ci-builds.apache.org/job/POI/job/POI-DSL-1.8/lastSuccessfulBuild/artifact/build/dist/
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [email protected]
> > For additional commands, e-mail: [email protected]
> >
>
>