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 fro

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: 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 code

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: dev-unsubscr

[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 fro

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

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 -

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: 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: [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: 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: dev-h

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 fi

Re: Next release of POI/XmlBeans?

2019-03-19 Thread pj.fanning
For xmlbeans, I would recommend getting the release jars and zips from https://builds.apache.org/view/P/view/POI/job/POI-XMLBeans-DSL-1.6/lastSuccessfulBuild/artifact/build/ This guarantees the jars were built with Java 6. For the nexus release, I follow this guide: https://central.sonatype.org/p

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: dev-h...@poi.apache.o

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: http:

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 p

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: 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: 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 https://github.co

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 addit

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: dev-unsubscr

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 ja

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: 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 t

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: dev-unsubscr...@poi.

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: [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 t

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 For

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-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: http:/

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 unsubs

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, e-mai

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 unsubscribe,

[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 https://repository.apache.org/content/repositories/staging/org/apach

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: dev-h...@poi.apa

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: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f23

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: 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

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: http://apache-poi.104

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: https://repository.apache.org/content/repositories/staging/org/apache/xmlbe

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 person

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: http://apache-poi.1045710.n5.nabble.

[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: http://apache-poi.1045710.n5.n

Re: xmlbeans 3.0.2 release?

2018-09-27 Thread pj.fanning
I have pushed xmlbeans 3.0.2 release candidate to: https://repository.apache.org/content/repositories/staging/org/apache/xmlbeans/xmlbeans/3.0.2/ https://dist.apache.org/repos/dist/dev/poi/xmlbeans/ -- 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: 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: 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 dependencies

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

2018-09-20 Thread pj.fanning
I'm not sure why you need to load poi differently from xmlbeans. The xmlbeans is correct but your poi dependencies are nothing like anything I've ever seen. Could you use the standard pom settings? org.apache.poi poi-ooxml 4.0.0 -- Sent from

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

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 - To

Re: Provide alpha releases via Apache repo

2018-09-07 Thread pj.fanning
I would like to see our CI build publish regular snapshots to Apache Nexus. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional com

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

2018-09-01 Thread pj.fanning
Piccolo is no longer used or supported. -- 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.o

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

2018-08-31 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: [RESULT] [VOTE] Apache XMLBeans 3.0.1 release (RC1)

2018-08-27 Thread pj.fanning
Hi Andi, I'm not sure how to sign an announce email. It also doesn't seem to be common on https://lists.apache.org/list.html?annou...@apache.org to have signed emails. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html --

Re: Remove OPOIFSFileSystem for 4.0.0?

2018-08-27 Thread pj.fanning
I'd prefer if we rename the NPOIFS classes to POIFS but also keep deprecated NPOIFS subclasses to reduce the impact on users who will be upgrading from POI 3 to 4. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html ---

Re: [RESULT] [VOTE] Apache XMLBeans 3.0.1 release (RC1)

2018-08-24 Thread pj.fanning
Hi Andi, I've done most of the pieces for the release. The items that are incomplete are: * Regenerating the xmlbeans site html using Forrest * Announcing the release I'm not sure of the exact command to use Forrest in the xmlbeans setup. I'm also not sure what `Announcing the release` entails.

Re: [RESULT] [VOTE] Apache XMLBeans 3.0.1 release (RC1)

2018-08-24 Thread pj.fanning
I have a look at doing all the items on the release list at the weekend. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional comman

Re: [RESULT] [VOTE] Apache XMLBeans 3.0.1 release (RC1)

2018-08-23 Thread pj.fanning
I'd prefer not to wait for INFRA-14923. Even Sonatype's Nexus only adds md5 and sha1 digests. These are generated by Nexus, as opposed to publisher's adding their own digest files. I have done some checking on maven central and in the cross section I checked, no jars had sha256 or sha512 digests.

Re: JAXB error in OpenJDK 10

2018-08-22 Thread pj.fanning
Hi Andi, Would you be able to put the jaxb build changes in a patch file or in a github branch? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.o

Re: [VOTE] Apache XMLBeans 3.0.1 release (RC1)

2018-08-22 Thread pj.fanning
+1 for the release -- 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: [Bug 62639] DataFormatter can never set its provided locale

2018-08-21 Thread pj.fanning
The DataFormatter class has been like this for a number of years, so it would not be a good idea to make big changes to its behaviour. Plenty of people rely on it working the way it works right now. We could add a 2nd DataFormatter that behaves the way you want it to - but right now, we are busy wi

Re: [VOTE] Apache XMLBeans 3.0.1 release (RC1)

2018-08-20 Thread pj.fanning
I've updated the staged artifacts for xmlbeans 3.0.1. https://repository.apache.org/content/repositories/staging/org/apache/xmlbeans/xmlbeans/3.0.1/ and https://dist.apache.org/repos/dist/dev/poi/xmlbeans/ -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html --

Re: POI 4.0.0 - also release / use XMLBeans 3.0.1?

2018-08-19 Thread pj.fanning
PS xmlbeans 3.0.1 is staged at https://repository.apache.org/content/repositories/staging/org/apache/xmlbeans/xmlbeans/3.0.1/ and https://dist.apache.org/repos/dist/dev/poi/xmlbeans/ -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html ---

Re: POI 4.0.0 - also release / use XMLBeans 3.0.1?

2018-08-19 Thread pj.fanning
I'm +1 for an xmlbeans 3.0.1 release. I changed tack a little and am now using new XmlOptions instead of system properties to control the xmlbeans xml parser setup. I had to undo the decrease in the default entity expansion limit due to failing xmlbeans tests. The hardcoded limit was 4096 and the

Re: POI 4.0.0 - also release / use XMLBeans 3.0.1?

2018-08-18 Thread pj.fanning
I can do an xmlbeans 3.0.1 release in the coming days if there is PMC approval. With xmlbeans 3.0.0, I copied over the XML parser code from Apache POI and the aim with 3.0.1 is to add the recent POI changes to XMLBeans. XMLBeans is intended for broader use - ie to continue to facilitate non-POI u

Re: Upgrade OOXML schema to 3rd edition?

2018-08-16 Thread pj.fanning
My opinion is that it would be good to release 4.0.0 soon and that we should do a feature freeze shortly. The upgrading of the schema seems like a nice-to-have as opposed to a must-have for 4.0.0. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html --

Re: Remove OPOIFSFileSystem for 4.0.0?

2018-08-13 Thread pj.fanning
+1 for 4.0.0 change -- 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: upgrading to 4.0.0

2018-08-09 Thread pj.fanning
Hi Tim, I don't think there is anything delaying a 4.0.0 release other than getting the regression suites tested and any fixing any bugs that are found. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html -

Re: starting poi 4.0.0 release process?

2018-07-31 Thread pj.fanning
Would it be possible to start pushing regular snapshots to maven (https://repository.apache.org/content/repositories/staging/org/apache/poi/) in the run up to the 4.0.0 release ? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html

Re: starting poi 4.0.0 release process?

2018-07-30 Thread pj.fanning
http://people.apache.org/~centic/poi_regression/reportsAll/download.oldindex/br.com.conhecadeus.www_Plano_Divino_Revelado_Homens_Apresentacao_11_O_Glorioso_Aparecimento_Cristo_Vers_C3_A3o2007.pptx This document causes a NPE in the poi regression tests. I added a fix to make the NPE go away but the

Re: [Bug 62275] vlookup function with "empty" fourth argument can not be processed.

2018-07-27 Thread pj.fanning
The current code blows up because the 4th param is empty (resulting in a MissingArgEval issue) - the code will pass is the 4th param is set to the true (the default for this param) https://www.techonthenet.com/excel/formulas/vlookup.php -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI

Re: starting poi 4.0.0 release process?

2018-07-26 Thread pj.fanning
I'm doing a little work on trying to change the XSSF streaming APIs to accept a SharedStringsTable interface instead of a concrete implementation. We currently have 3 different SharedStringsTable implementations and it would be nice to be able to share code between the implementations and to allow

Re: Remove Spanish translation?

2018-07-15 Thread pj.fanning
+1 for removal of unmaintained docs -- 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: starting poi 4.0.0 release process?

2018-07-15 Thread pj.fanning
Would it be possible to provide links to some of the more worrying regression cases highlighted in http://apache-poi.1045710.n5.nabble.com/XMLBeans-3-0-0-release-vote-td5730932.html#a5730965 ? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html --

Re: poi-ooxml-schemas missing some inner classes

2018-07-11 Thread pj.fanning
I checked in some artificial tests that load some of the ooxml-schemas classes that are missing. I was able to get the ooxml build and tests to work locally after regenerating poi-ooxml-schemas with the extra classes. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html -

Re: poi-ooxml-schemas missing some inner classes

2018-07-11 Thread pj.fanning
] Compiling 541 source files to /Users/pj.fanning/svn/poi/build/ooxml-classes [javac] /Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xddf/usermodel/chart/XDDFChart.java:67: error: cannot find symbol [javac] import org.openxmlformats.schemas.drawingml.x2006.chart.CTSurface; [javac

Re: reordering xssf rows

2018-07-11 Thread pj.fanning
Thanks for the suggestions. I've tried a few thing with XmlCursors and recreating the XmlBeans for scratch but keep hitting new issues. I suspect the best the approach is to create an XSSFSheet2 implementation that has no XMLBeans in it - start by creating a sheet initialised from the XMLBeans she

reordering xssf rows

2018-07-10 Thread pj.fanning
I've been looking at https://github.com/apache/poi/blob/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestUnfixedBugs.java#L344 The test fails with: java.lang.AssertionError: Row 3 (1-based) is not in ascending order; previously saw 5 After shifting the xssf rows as part of the test, th

poi-ooxml-schemas missing some inner classes

2018-07-10 Thread pj.fanning
I'm seeing some issues with poi-ooxml-schemas where it is missing inner classes that implement Lists. An example is this: java.lang.NoClassDefFoundError: org/openxmlformats/schemas/spreadsheetml/x2006/main/impl/CTSheetDataImpl$1RowList at org.openxmlformats.schemas.spreadsheetml.x2006.main

starting poi 4.0.0 release process?

2018-07-08 Thread pj.fanning
Thanks Andreas for all the work on the XMLBeans release announcement and all the web site updates. With the XMLBeans release process soon to be completed, are we in a position to move onto pushing out the POI 4.0.0 release? I've done some testing with the nightly builds and tried them out with som

Re: adding extra classes to poi-ooxml-schemas jar

2018-07-04 Thread pj.fanning
Thanks Dominik, that makes sense, that type erasure in Java collections would mean that the CTPhoneticRun is not necessarily loaded. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe,

Re: adding extra classes to poi-ooxml-schemas jar

2018-07-03 Thread pj.fanning
Hi Dominik, I cleaned out the workspace on the DSL-1.8 build plan and ran a build and downloaded the bin zip from https://builds.apache.org/view/P/view/POI/job/POI-DSL-1.8/ws/build/dist/ The CTPhoneticRun class is still missing from poi-ooxml-schemas jar though. -- Sent from: http://apache-poi.

Re: [RESULT][VOTE] Re: XMLBeans 3.0.0 release vote

2018-07-02 Thread pj.fanning
Thanks Andi for updating the xmlbeans.apache.org site. Would it make sense to change the links on https://xmlbeans.apache.org/community/index.html to point to the POI mailing lists - the XMLBeans lists haven't been reactivated? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312

Re: poi.apache.org update

2018-07-02 Thread pj.fanning
I updated https://poi.apache.org/ based on the latest documentation in poi svn. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional

adding extra classes to poi-ooxml-schemas jar

2018-07-02 Thread pj.fanning
I made a change[1] to try to gat an extra generated class included in poi-ooxml-schemas jar. The latest nightly jars did not end up including it and I've tried local builds but do not get it included either. Would someone be able to review the change to see if I've made a mistake? [1] https://gith

poi.apache.org update

2018-06-29 Thread pj.fanning
Would it be possible to get the https://poi.apache.org/ pages updated? I added some notes in src/documentation about the XMLBeans 3.0.0 release. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To

Re: XmlBeans 3.0.0 review

2018-06-23 Thread pj.fanning
I'm happy to discuss alternatives. The XMLBeans SAXHelper was lifted directly from POI. https://github.com/apache/poi/blob/trunk/src/ooxml/java/org/apache/poi/ooxml/util/SAXHelper.java But with setEntityExpansionLimit being used too, it's probably safe to not have the ignoring entity resolver.

Re: XMLBeans 3.0.0 release vote

2018-06-22 Thread pj.fanning
Some of the github pull request builds failed and I wasn't sure what was causing the issue. Conceptually, the POI build no longer needs any piccolo manipulation because xmlbeans 3.0.0 removes the support for piccolo entirely. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f231286

Re: XMLBeans 3.0.0 release vote

2018-06-22 Thread pj.fanning
github is a read only mirror of the poi svn - we use pull requests on github to demonstrate proposed changes but those pull requests need to be merged using svn commits (by POI committers) -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html --

XMLBeans 3.0.0 release vote

2018-06-22 Thread pj.fanning
Can I ask for a vote on releasing XMLBeans 3.0.0? This branch builds and tests POI with a pre-release version of XMLBeans. https://github.com/apache/poi/pull/113 Releasing this jar to Maven Central should just be a click of a button in Nexus. https://issues.apache.org/jira/browse/XMLBEANS-517?jq

Re: XMLBeans 3.0.0 votes

2018-06-21 Thread pj.fanning
I found a bug in the xmlbeans build that I had accidentally added, that meant some important classes were being omitted from the xmlbeans jar. http://svn.apache.org/viewvc?view=revision&revision=1833948 I rebuilt my xmlbeans 3.0.0 candidate and removed the older 2.7.0-rc1 candidate. The candidate

Re: XMLBeans 3.0.0 votes

2018-06-17 Thread pj.fanning
I think there's been a reasonable consensus on: A +1 B: 1.6 C: +1 The 2.7.0-rc1 candidate is pretty close to what I would like to release. I can produce a new version as a candidate for 3.0.0. I have been using a very similar XMLBeans code base in production applications for close to a year a

XMLBeans 3.0.0 votes

2018-06-14 Thread pj.fanning
Can I get votes on the following? A. Stop supporting Java 1.4 B. If we stop supporting Java 1.4, do set Java 1.6 or Java 1.8 as the minimum? C. Do we call the next release 3.0.0? It's inconvenient to keep supporting Java 1.4 builds. We don't need to use Java APIs that have been introduced after J

Re: Vote on XMLBeans 2.7.0-rc1 release

2018-06-11 Thread pj.fanning
I have already upgraded xmlbeans from jdk 1.4 to jdk 1.6. This was more because I can't find a jdk that will build jdk 1.4 compatible binaries on my Mac. I guess this means we'll need to call the next release 3.0.0. I'm not convinced that we need to build against newer JDKs than 1.6. Running appli

Re: Vote on XMLBeans 2.7.0-rc1 release

2018-06-10 Thread pj.fanning
I published to https://dist.apache.org/repos/dist/dev/poi/xmlbeans/ I used svn to publish. The maven dir is based on what is in Nexus. The src and bin are based on artifacts that the xmlbeans ant build produces. The asc files are based on my public PGP key. -- Sent from: http://apache-poi.10

Re: Vote on XMLBeans 2.7.0-rc1 release

2018-06-10 Thread pj.fanning
I do have the RC jars uploaded on Nexus (they are not released yet). https://repository.apache.org/content/repositories/orgapachexmlbeans-1002/org/apache/xmlbeans/xmlbeans/2.7.0-rc1/ Is this enough? I'm not sure how to push jars into https://dist.apache.org. I used the Nexus UI (https://reposito

Vote on XMLBeans 2.7.0-rc1 release

2018-06-10 Thread pj.fanning
I have an RC1 build ready for release based on these changes: https://issues.apache.org/jira/browse/XMLBEANS-517?jql=project%20%3D%20XMLBEANS%20AND%20fixVersion%20%3D%20%22Version%202.7.0%22 Can I call a vote on whether to proceed with an org.apache.xmlbeans:xmlbeans:2.7.0-rc1 release? My vote i

Re: 2016 Excel Tree Map Charts excel file Not able to Read Using POI

2018-06-01 Thread pj.fanning
Could you raise an issue at https://bz.apache.org/bugzilla/enter_bug.cgi ? It would be useful to attach a file that demonstrates the issue. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To unsubs

  1   2   >