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



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.



--
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: 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 to POI core, it would need samples, unit tests
and the code would need to be formatted and follow Java coding standards -
for instance, your code has some classes with names that start with
lowercase letters and parameter names that start with capital letters.



--
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: [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...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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



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 reason for us to stick with int sizes or should we look at
supporting long sizes (and bigger files)?



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



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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

-
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 modified to be the same old version.




But wouldn't this work (if we have a dist.lib as well as a compile.lib)?






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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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...@poi.apache.org



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 fine, so far.



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



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://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: 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 protection removed (this supports streaming).

The zip files contain XML files that have the content and the metadata (eg
style data). The XML can be parsed with SAX or StAX parsers. The XML specs
are detailed in https://en.wikipedia.org/wiki/Office_Open_XML

docx4j may be an option. As far as I know it does not support streaming but
it's possible it uses less memory when reading docx or pptx files.

For ppt and doc formats, I believe that the data formats don't lend
themselves to streaming the data.




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



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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.com/pjfanning/poi-shared-strings

You can then use SXSSFWorkbook to save the modified sheets.

This is obviously not as straightforward as parsing into an XSSFWorkbook and
modifying it in place before saving it.



--
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: 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 additional commands, e-mail: dev-h...@poi.apache.org



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...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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 jar was needed for POI and relies on an old version of saxon, I
didn't prioritise supporting it.

It's probably ok to put the equivalent files in xmlbeans' own
META-INF/services folder but the main usage of the files is for xpath/xquery
support, maybe it is time to start creating the xmlbeans-xpath jars again
and including them on the classpaths for the tests that need those files to
be available.

The files are in xmlbeans/src/xpath_xquery but get renamed in the building
of the xmlbeans-xpath jar.




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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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 the default behaviour
of the lib. It's a little bit prettier than using System properties but it
might be a lot of work to wire a PoiOptions class into our APIs, even if we
just started with some APIs where we could make use of it.

Options include:
* Roll out PoiOptions in these evaluation APIs (probably a lot of work and
to not break API contracts, we'd need to have to add lots of new methods
that take the new class as a param)
* Look for the PoiOptions on ThreadLocal so that users can set PoiOptions
just on the threads where they want to override the default behaviour
* Expose PoiOptions as a static variable eg PoiOptions.getInstance() so that
users can update the settings and affect the whole JVM (easiest to write and
easiest to use)
* Use System variables



--
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: 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.apache.org
For additional commands, e-mail: dev-h...@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: dev-h...@poi.apache.org



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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 to have someone review the change but I think it is fixed.



--
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: [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 additional commands, e-mail: dev-h...@poi.apache.org



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 additional commands, e-mail: dev-h...@poi.apache.org



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://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: 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 unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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.apache.org



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-f2312866.html

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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.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: [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/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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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 did comment on an XMLBeans JIRA recently.

https://issues.apache.org/jira/projects/XMLBEANS/summary
 



--
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: [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.com/POI-Dev-f2312866.html

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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



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

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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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.



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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 unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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 commands, e-mail: dev-h...@poi.apache.org



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.org



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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

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



--
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-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 commands, e-mail: dev-h...@poi.apache.org



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.

We have complete control over what gets added to
https://archive.apache.org/dist/poi/release/ and we can definitely use
sha256 and sha512 digests there. 




--
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: 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.org
For additional commands, e-mail: dev-h...@poi.apache.org



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 with a major release and I think it's not a good time
to make changes.

Individuals can create their own subclasses of DataFormatter, for now.
A lot of the implementation of DataFormatter is private but you could copy
paste any private methods that you need into your own subclass.




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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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 default is now
2048.

I can modify POIXMLTypeLoader [1] to set it so that when POI uses XMLBeans,
the entity expansion limit will be 1.

I can look after the xmlbeans 3.0.1 release. When I get enough +1s, I'll
proceed.

[1]
https://github.com/apache/poi/blob/trunk/src/ooxml/java/org/apache/poi/ooxml/POIXMLTypeLoader.java



--
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: 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
usage. With this in mind, I have disabled DTD loading and Entity Expansion
by default but do support 3 new system properties that allow users to
re-enable these features.

"xmlbeans.entity.expansion.limit" (default of 1)
"xmlbeans.load.dtd.grammar" (default of false)
"xmlbeans.load.external.dtd" (default of false)

Latest Parser code can be found at (if anyone would like to review my
changes):
http://svn.apache.org/viewvc/xmlbeans/trunk/src/common/org/apache/xmlbeans/impl/common/



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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

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

-
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-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 document is still corrupt.
I am unable to open this file in Mac Numbers, Google Spreadsheet or
LibreOffice. I'm afraid I no longer have MS Office installed.
Is it a priority to get POI to work with this file?



--
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 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-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-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
external users to write their own implementations (that use less memory, for
instance - the current implementations use Java collections to store all the
shared strings for the workbook).

I'm trying to make the changes in a backward compatible way.

The same issues affect CommentsTable and StylesTable.



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



Re: poi-ooxml-schemas missing some inner classes

2018-07-11 Thread pj.fanning
I modified my local poi build.xml to use a poi-ooxml-schemas 4.0.0-SNAPSHOT
from a recent nightly build and found lots of compile issues building
poi-ooxml.

My build crashes with a Stackoverflow issue after this output so I suspect
that this is the tip of the iceberg.

compile-ooxml:
[javac] 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]^
[javac]   symbol:   class CTSurface
[javac]   location: package
org.openxmlformats.schemas.drawingml.x2006.chart
[javac]
/Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xssf/usermodel/charts/XSSFChartAxis.java:31:
error: cannot find symbol
[javac] import
org.openxmlformats.schemas.drawingml.x2006.chart.CTChartLines;
[javac]^
[javac]   symbol:   class CTChartLines
[javac]   location: package
org.openxmlformats.schemas.drawingml.x2006.chart
[javac]
/Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xssf/usermodel/charts/XSSFChartAxis.java:224:
error: cannot find symbol
[javac] @Internal public abstract CTChartLines getMajorGridLines();
[javac]   ^
[javac]   symbol:   class CTChartLines
[javac]   location: class XSSFChartAxis
[javac]
/Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xssf/usermodel/charts/XSSFLineChartData.java:36:
error: cannot find symbol
[javac] import
org.openxmlformats.schemas.drawingml.x2006.chart.STMarkerStyle;
[javac]^
[javac]   symbol:   class STMarkerStyle
[javac]   location: package
org.openxmlformats.schemas.drawingml.x2006.chart
[javac]
/Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xssf/usermodel/charts/XSSFValueAxis.java:125:
error: cannot find symbol
[javac] public CTChartLines getMajorGridLines() {
[javac]^
[javac]   symbol:   class CTChartLines
[javac]   location: class XSSFValueAxis
[javac]
/Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xssf/usermodel/charts/XSSFCategoryAxis.java:112:
error: cannot find symbol
[javac] public CTChartLines getMajorGridLines() {
[javac]^
[javac]   symbol:   class CTChartLines
[javac]   location: class XSSFCategoryAxis
[javac]
/Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xssf/usermodel/charts/XSSFDateAxis.java:112:
error: cannot find symbol
[javac] public CTChartLines getMajorGridLines() {
[javac]^
[javac]   symbol:   class CTChartLines
[javac]   location: class XSSFDateAxis
[javac]
/Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xddf/usermodel/chart/XDDFChartAxis.java:340:
error: cannot find symbol
[javac] protected CTShapeProperties
getOrAddLinesProperties(CTChartLines gridlines) {
[javac] ^
[javac]   symbol:   class CTChartLines
[javac]   location: class XDDFChartAxis
[javac]
/Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xddf/usermodel/BlackWhiteMode.java:22:
error: cannot find symbol
[javac] import
org.openxmlformats.schemas.drawingml.x2006.main.STBlackWhiteMode;
[javac]   ^
[javac]   symbol:   class STBlackWhiteMode
[javac]   location: package
org.openxmlformats.schemas.drawingml.x2006.main
[javac]
/Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xddf/usermodel/XDDFEffectContainer.java:22:
error: cannot find symbol
[javac] import
org.openxmlformats.schemas.drawingml.x2006.main.CTEffectContainer;
[javac]   ^
[javac]   symbol:   class CTEffectContainer
[javac]   location: package
org.openxmlformats.schemas.drawingml.x2006.main
[javac]
/Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xddf/usermodel/XDDFScene3D.java:22:
error: cannot find symbol
[javac] import
org.openxmlformats.schemas.drawingml.x2006.main.CTScene3D;
[javac]   ^
[javac]   symbol:   class CTScene3D
[javac]   location: package
org.openxmlformats.schemas.drawingml.x2006.main
[javac]
/Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xddf/usermodel/XDDFShape3D.java:22:
error: cannot find symbol
[javac] import
org.openxmlformats.schemas.drawingml.x2006.main.CTShape3D;
[javac]   ^
[javac]   symbol:   class CTShape3D
[javac]   location: package
org.openxmlformats.schemas.drawingml.x2006.main
[javac]
/Users/pj.fanning/svn/poi/src/ooxml/java/org/apache/poi/xddf/usermodel/chart

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 sheet graph - then the edits are stored in the XSSF2 classes - when
we want to save the worksheet XML, we can create a brand new set of XMLBeans
and use them to write the XML or maybe better still, reuse the SXXSFSheet
code to write out the XML.



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



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, the underlying CTRows are
not reordered.

wb.getSheetAt(0).getCTWorksheet().getSheetData().getRowList()

When the workbook is output, the rows in the output are out of order.

XMLBeans doesn't seem to make it easy to fix this.
I've tried to empty the rows on SheetData and to recreate them but this
orphans the existing CTRows and leads to errors if I try to read off the
data from the old rows when trying to create new ones.

org.apache.xmlbeans.impl.values.XmlValueDisconnectedException
at
org.apache.xmlbeans.impl.values.XmlObjectBase.check_orphaned(XmlObjectBase.java:1258)
at
org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTRowImpl.getR(Unknown
Source)

It seems like the best solution to completely recreate the sheet by adding a
new sheet, copying on all the items related to the initial sheet (with the
rows shifted) and then removing the old sheet before then renaming the new
sheet and putting in the right sheet order.

This does seem like a lot of work and there are risks that even this
approach won't work.

Anyone have any thoughts on alternative solutions?



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



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.impl.CTSheetDataImpl.getRowList(Unknown
Source)

Traditionally, we've tended to use CTSheetData#getRowArray() instead of
CTSheetData#getRowList() but the former is deprecated.
The problem appears to be that type erasure on the List that is
returned by CTSheetData#getRowList() means that the OoxmlLite class does not
necessarily recognise that we need the 
CTSheetDataImpl$1RowList class to be included in poi-ooxml-schemas.

Would it be feasible to modify OoxmlLite to include all inner classes of any
class it chooses to include in poi-ooxml-schemas?



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



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 some
open source projects that depend on POI like excel-streaming-reader and
spoiwo and I think we are in a good position to push the 4.0.0 release.
I think there will be some annoyance with the number of API changes in 4.0.0
but I didn't find it too time consuming to update the code bases I looked
at.




--
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: 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, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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.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] 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-f2312866.html

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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 commands, e-mail: dev-h...@poi.apache.org



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://github.com/apache/poi/commit/31674ea13b5ad026a701802b60a8fce28748d17c



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



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 unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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.



--
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: 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-f2312866.html

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



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?jql=project%20%3D%20XMLBEANS%20AND%20fixVersion%20%3D%20%22Version%203.0.0%22

Details on getting the source are at
https://xmlbeans.apache.org/sourceAndBinaries/index.html

My vote is +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: 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=1833948

I rebuilt my xmlbeans 3.0.0 candidate and removed the older 2.7.0-rc1
candidate.

The candidate jars can be found at
https://dist.apache.org/repos/dist/dev/poi/xmlbeans/
https://repository.apache.org/content/repositories/staging/org/apache/xmlbeans/xmlbeans/3.0.0/



--
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: 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 and would like to proceed with a 3.0.0
Apache XMLBeans release in the coming weeks to unblock the Apache POI 4.0.0
release.

Would anyone be in a position to validate the XMLBeans candidate(s)?



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



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 Java 1.6 and
users can run with the latest JRE if they want the latest security fixes.
If we upgrade Java min version, then we should probably do a major release.

My votes are:
A. +1
B. Java 1.6 (but happy to go to Java 1.8)
C. +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: 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
applications with a more up to data Java runtime is recommended but I'm not
sure we need to make Java 1.8 the minimum supported version.



--
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: 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://repository.apache.org) to push the RC jars into Nexud
Repository.



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



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 is +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: 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 unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



Re: xmlbeans svn open for commits by poi committers

2018-05-26 Thread pj.fanning
https://issues.apache.org/jira/browse/INFRA-16580 is open for the Nexus/Maven
bit.




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



xmlbeans svn open for commits by poi committers

2018-05-26 Thread pj.fanning
This was done as part of https://issues.apache.org/jira/browse/INFRA-16278

I have committed the work that I had done on my github fork of xmlbeans,

The changes are:

https://issues.apache.org/jira/browse/XMLBEANS-515?jql=project%20%3D%20XMLBEANS%20AND%20fixVersion%20%3D%20%22Version%202.7.0%22

I would like to publish this as an xmlbeans 2.7.0 release.
Would anyone know how this is done? I'm familiar with publishing to OSS
Sonatype but I'm not sure if Apache has its own setup and who is allowed to
publish artifacts for Apache projects.



--
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: [VOTE] Re: Review #62355

2018-05-21 Thread pj.fanning
Also  a) -0 b) -1 c) +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: Using StAX parser for .xlsx files

2018-05-18 Thread pj.fanning
https://github.com/monitorjbl/excel-streaming-reader is probably a better bet



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



  1   2   >