Re: Single Java 9 module jar?

2018-03-02 Thread pj.fanning
Could we consider keeping all the jars but ensure that no package spans jars? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional

[VOTE] xmlbeans 3.0.2 release

2018-09-30 Thread pj.fanning
I would like to complete an xmlbeans 3.0.2 release this week. Can I call a vote? The changes are listed in https://issues.apache.org/jira/browse/XMLBEANS-520?jql=project%20%3D%20XMLBEANS%20AND%20fixVersion%20%3D%20%22Version%203.0.2%22 Here's my +1. -- Sent from:

Re: [VOTE] xmlbeans 3.0.2 release

2018-09-30 Thread pj.fanning
I've been using the Oracle 8 JDK as my default for a while but thought that for building XMLBeans it would be better to use an older JDK since we support JDK 6 and above. JDK 6 is not easily installed on Macs so I thought JDK 7 was a better bet. -- Sent from:

Re: [VOTE] xmlbeans 3.0.2 release

2018-10-11 Thread pj.fanning
XMLBeans 3 has similar XML parser factory code to POI and with the reported issues and fixes we've done for POI 4.0.1, I was hoping to release similar fixes for XMLBeans 3.0.2. Would it be feasible to get XMLBeans 3.0.2 reviewed? -- Sent from:

[VOTE] xmlbeans 3.0.2 release [rc2]

2018-10-23 Thread pj.fanning
I've uploaded new artifacts with a couple of extra changes. Still built using the apache jenkins jdk 1.6 build. https://issues.apache.org/jira/issues/?jql=project%20%3D%20XMLBEANS%20AND%20fixVersion%20%3D%20%22Version%203.0.2%22

POI 4.0.1 release

2018-10-30 Thread pj.fanning
Is it time for us to look at doing a POI 4.0.1 release? Are there any issues we would like to see completed before we proceed? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe,

Re: [VOTE] xmlbeans 3.0.2 release [rc2]

2018-10-26 Thread pj.fanning
Thanks everyone. There have been 4 +1s (including me). I will proceed with the release in the coming days if there are no objections. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To

Re: Build failed in Jenkins: POI-DSL-OpenJDK #545

2018-11-02 Thread pj.fanning
The condition is `next != -1` but the value of next appears to -1 so that this condition is false. Maybe the condition should `next == -1` -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To

Re: Here are my slides (if attachments are not stripped)

2018-10-19 Thread pj.fanning
LGTM. 2 minor typos: conjuction uneccessary -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail:

Re: FormulaEvaluator float presicion problem

2018-10-09 Thread pj.fanning
Could you try using DataFormatter after using the FormulaEvaluator? https://stackoverflow.com/questions/21538481/xssf-how-to-get-anything-as-string/21550258#21550258 -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

Re: [VOTE] xmlbeans 3.0.2 release

2018-10-02 Thread pj.fanning
No external parties have reported bugs. I did notify a few external projects about the release of 3.0.0 and some upgraded to it. If people have issues, there is enough documentation on the web that I would expect them to be able to find the POI mailing list or the XMLBeans JIRA. 1 non-POI

Deleting build job XMLBeans-DSL-1.6

2018-10-03 Thread pj.fanning
Does anyone know how to delete the Jenkins job https://builds.apache.org/job/XMLBeans-DSL-1.6/ ? I created a new job called POI-XMLBeans-DSL-1.6 because it's easier to find it if it's grouped with the other POI jobs. https://builds.apache.org/view/P/view/POI/ -- Sent from:

Re: [VOTE] xmlbeans 3.0.2 release

2018-10-02 Thread pj.fanning
I've created a basic build job at https://builds.apache.org/view/P/view/POI/job/POI-XMLBeans-DSL-1.6 I downloaded the zip/tgz/jar files from the build (built using JDK 1.6). I replaced the artifacts in the staging repos:

Re: Deleting build job XMLBeans-DSL-1.6

2018-10-03 Thread pj.fanning
Thanks Andi -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org

Re: Worth doing a 4.0.1 release soon?

2018-09-19 Thread pj.fanning
Seems useful to do a 4.0.1 soon but I think we should wait a few weeks. There have been a few issues reported and they continue to come in at reasonable steady pace. None of the issues so far seem to be blockers though. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

xmlbeans 3.0.2 release?

2018-09-26 Thread pj.fanning
Should we do an XMLBeans 3.0.2 release? https://issues.apache.org/jira/browse/XMLBEANS-520?jql=project%20%3D%20XMLBEANS%20AND%20fixVersion%20%3D%20%22Version%203.0.2%22 -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

Re: java.lang.ClassNotFoundException: org.apache.poi.ss.usermodel.Workbook

2018-09-20 Thread pj.fanning
Somehow you've disabled the standard transitive dependency loading mechanisms in your maven build. Try adding: org.apache.poi poi 4.0.0 But without transitive dependency loading, you're going to have to explicitly add lots of

Re: Worth doing a 4.0.1 release soon?

2018-09-24 Thread pj.fanning
There were some bugs in the maven pom dependencies that we published. We were missing commons-math3 dependency and some dependencies were listed with old version numbers. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

Re: setBulletAutoNumber does not work, always get error - PowerPoint found a problem with content...

2019-01-16 Thread pj.fanning
Thanks for the report. Could you raise an issue in https://bz.apache.org/bugzilla/ ? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For

Re: SXSSF cannot work with large excel files

2019-01-16 Thread pj.fanning
For reading large documents use https://github.com/monitorjbl/excel-streaming-reader or https://github.com/apache/poi/blob/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java If you run into issues with shared strings table being too large, you might also want

Re: XMLBeans Jira - new version tag

2019-01-19 Thread pj.fanning
Hi Andi, I just added https://issues.apache.org/jira/browse/XMLBEANS-526?jql=project%20%3D%20XMLBEANS%20AND%20fixVersion%20%3D%20%22Version%203.0.3%22 -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

Re: Throwing EvaluationException slows down evaluation, proposed change: not fill stack trace

2018-12-17 Thread pj.fanning
For me, this kind of optimisation needs to be configurable. Most users would not need this performance optimisation and would be better off to get the full stack trace. I would pitch that something like XmlOptions in the XMLBeans project is a useful model. This allows users to choose to override

Re: [VOTE] Apache POI 4.0.1 release (RC1)

2018-11-23 Thread pj.fanning
The real fix is https://bz.apache.org/bugzilla/show_bug.cgi?id=62692 - XMLBeans-519 fixes a similar issue in XMLBeans (the SAXHelper code in XMLBeans is basically a copy/paste of POI equivalent). -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

Re: [VOTE] Apache POI 4.0.1 release (RC1)

2018-11-23 Thread pj.fanning
https://bz.apache.org/bugzilla/show_bug.cgi?id=62943 fix was to bring back a try catch block around the code that had been removed in 4.0.0. The 4.0.0 issue seems to affect users that have very old parsers - typically part of Application Servers that have their own non-standard parsers. I'm happy

Re: [VOTE] Apache POI 4.0.1 release (RC1)

2018-11-21 Thread pj.fanning
I found a few missing classes in poi-ooxml-schemas.jar. We have some gaps in the XDDF testing and this leads to us not adding all the necessary OOXML classes for XDDF to the poi-ooxml-schemas.jar. https://github.com/apache/poi/commit/df83dab1a49900d85d9a20c0ee6d5a7a31f0eb9c -- Sent from:

Re: [VOTE] Apache POI 4.0.1 release (RC1)

2018-11-21 Thread pj.fanning
I'm +1 -- the fix can wait till 4.0.2 and there is the workaround to use full schema jar. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For

Re: [VOTE] Apache POI 4.0.1 release (RC1)

2018-11-22 Thread pj.fanning
Tim - would you be able to provide some sample files and we can add some regression tests? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

Re: [VOTE] Apache POI 4.0.1 release (RC2)

2018-11-27 Thread pj.fanning
+1 Thanks for all the hard work getting this over the line. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail:

Re: Adding mockito as testCompile dependency in poi:main module

2018-11-28 Thread pj.fanning
Thanks for your contributions. Feel free to use Mockito in any of the submodules you need to use it in. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail:

Re: XMLBeans bugs / build / commit

2019-01-09 Thread pj.fanning
The META-INF/services files appear in xmlbeans-xpath-2.6.0.jar. 50 07-23-2012 15:42 META-INF/services/org.apache.xmlbeans.impl.store.PathDelegate.SelectPathInterface 52 07-23-2012 15:42 META-INF/services/org.apache.xmlbeans.impl.store.QueryDelegate.QueryInterface Since that

Re: Java-11 Compatibility of POI 4.0.x

2019-01-10 Thread pj.fanning
We unit test our POI 4.0 code base with java 11. if you are seeing issues, could you provide a lot more detail? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail:

Re: null excetion when using workbook write function

2019-01-04 Thread pj.fanning
The directoryEntry that is causing in the NullPointerException is set in the HSSFWorkbook constructor. Could you be passing a null into this constructor? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

Re: Apache POI

2018-09-12 Thread pj.fanning
Could you raise a bugzilla issue and attach an xlsb file? https://bz.apache.org/bugzilla/ xlsb is not an active area of development, I'm afraid. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html -

xmlbeans 3.0.3

2019-01-28 Thread pj.fanning
Should we release xmlbeans 3.0.3? https://issues.apache.org/jira/browse/XMLBEANS-532?jql=project%20%3D%20XMLBEANS%20AND%20fixVersion%20%3D%20%22Version%203.0.3%22 -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

Re: XML Beans 3.0.3 candidate build

2019-03-20 Thread pj.fanning
Yes, to release the jars, you just need to run the release option in the repository.apache.org UI. I would suggest that we leave the jars in staging for a few days, just in case someone spots any issues. I've changed the POI build to use the xmlbeans 3.0.3 jars from staging and the build seems

Re: [Bug 63289] New: org.apache.poi.hpsf.Util poi-4.0.1

2019-03-27 Thread pj.fanning
What version are you upgrading from? That org.apache.poi.hpsf.Util class no longer exists. I went back nearly 2 years in code history and find no sign of such a class. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

Re: [VOTE] XMLBeans 3.1.0 release

2019-03-23 Thread pj.fanning
+1 -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org

Re: Ready for 4.1.0 release?

2019-04-05 Thread pj.fanning
In the ant build, we can download different versions of bouncycastle into different directories. The openpgp task can use the old bouncycastle jar and the dsig can use the new one. Bouncycastle has lots of security fixes and it seems bad to completely switch back to a very old version. These were

Re: [VOTE] Apache POI 4.1.0 release (RC3)

2019-04-06 Thread pj.fanning
Thanks Greg. In my testing, I had to make a couple of small code changes to get things working again but nothing big and this is an intermediate version upgrade so that's expected. +1 -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

Re: Unit Test failure

2019-03-16 Thread pj.fanning
The code that is failing is not POI code, it is from the java runtime. It appears the test is trying to read a png file and convert it to a jpeg in preparation for the POI part of the test. Maybe we should just find a jpeg file for the test instead of doing this conversion. -- Sent from:

Re: Next release of POI/XmlBeans?

2019-03-18 Thread pj.fanning
I've dropped the xmlbeans staging jars. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail:

Re: XML Beans 3.0.3 candidate build

2019-03-21 Thread pj.fanning
Calling the next release 3.1.0 seems sensible to me. +1 -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail:

Re: Event Based APIs for parsing docx,doc,pptx,ppt files

2019-02-14 Thread pj.fanning
Noone that I know of is actively working on a streaming API for docx or pptx. Contributions to POI in these areas would be welcome. One low level approach is to read docx/pptx files as zip files. If they are password protected, you can use POI to first create a copy of the file with the password

github PR for MAPIType.isFixedLength

2019-04-09 Thread pj.fanning
https://github.com/apache/poi/pull/143 The notifications for github PRs seem not to happen any more. I don't know a lot about the H**F foramts. Would someone be able to review github-143? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

POIFS int size - limits size to 2G

2019-04-15 Thread pj.fanning
I'm not very familiar with the OLE specification that POIFS implements. Right now, we have the size parameter implemented as an int which means that we are limited to a file size of approx 2G. I had a look at changing the int to a long but this has a knock-on effect for lots of classes. Is there a

[VOTE] Should future XMLBeans releases support a min version of Java 8

2019-06-05 Thread pj.fanning
We've already released some JDK 6 friendly XMLBeans releases. With https://issues.apache.org/jira/projects/XMLBEANS/issues/XMLBEANS-541 and just to make life easier for future development, could we move to just building with Java 8 (and newer versions)? Here's my +1 for the change. -- Sent

Re: [VOTE] Should future XMLBeans releases support a min version of Java 8

2019-06-10 Thread pj.fanning
We have 4 +1s. I will proceed with the build changes over the coming days. Ping me if there are any objections. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail:

Re: Concatenating, Indexing, and Copying a document to the end of another

2019-10-23 Thread pj.fanning
My personal opinion is that I'd prefer not to add this to the POI core. It is quite possible to have a community where people have side projects that use the core code. The core POI code is already very large and we only have a small number of volunteers to maintain it. If we were to add this

xmlsec upgrade issue

2020-03-11 Thread pj.fanning
I didn't want to complicate the last release but I discovered that POI signing does not work with the latest xmlsec jar. (https://bz.apache.org/bugzilla/show_bug.cgi?id=63712) This signing code base is not something I am very familiar with - but it would be nice not to stuck on the old jar. --

Re: Pivot Table - Data Column with % of Parent Calculation

2020-04-08 Thread pj.fanning
That class is generated from a schema. It is a big task to regenerate those classes based on a newer version of the schema - and fix issues and uptake extra features - so we only do this upgrade every few years. http://www.ecma-international.org/publications/standards/Ecma-376.htm -- Sent

<    1   2