Re: publishing poi xmlbeans jars

2018-03-09 Thread Andreas Beeker
There's a workaround for the GPL problem:
https://issues.apache.org/jira/browse/LEGAL-264

... but my last experiments with the current ECMA schemas weren't so successful:
https://stackoverflow.com/questions/46869482/


On 3/9/18 2:05 PM, Murphy, Mark wrote:
> Since JAXB is being dropped from Java SE (deprecated in Java 9, removed in 
> Java 11), I don't think that this will be a problem. There may be other 
> marshallers out there, but the more immediate problem is that we need to 
> remove all JAXB code from POI because we can no longer rely on the JVM 
> implementation, and the JAXB project is GPL code.




signature.asc
Description: OpenPGP digital signature


[Bug 62170] NumberFormatException when trying to get reference from named range with getRefersToFormula()

2018-03-09 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62170

stephane.tes...@soprasteria.com changed:

   What|Removed |Added

 OS||All

--- Comment #1 from stephane.tes...@soprasteria.com ---
After further investigations, it seems that the problem only concerns XLS
files. It works fine with XLSX files.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 62170] New: NumberFormatException when trying to get reference from named range with getRefersToFormula()

2018-03-09 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62170

Bug ID: 62170
   Summary: NumberFormatException when trying to get reference
from named range with getRefersToFormula()
   Product: POI
   Version: 3.17-FINAL
  Hardware: PC
Status: NEW
  Severity: normal
  Priority: P2
 Component: HSSF
  Assignee: dev@poi.apache.org
  Reporter: stephane.tes...@soprasteria.com
  Target Milestone: ---

When I try to get the reference behing my named range via the
getRefersToFormula() function, in some cases, I get a NumberFormatException.
It depends on the sheet name where the named range is, for example :
- the named range is in a sheet named '262001', it's OK. 
- the named range is in a sheet named 'C262001', it fails -> i don't know
why but it seems POI considers that it's a number and tries to parse it into a
string, thus the NumberFormatException : 262001 is higher than the int
limit 2^31-1

When I check the named cells in Excel's name manager, sometimes the sheet name
is surrouded with quotes, sometimes it isn't.
Note that when there are quotes, it works everytime with POI. Otherwise, it
fails sometimes (cf. the case mentionned before, Excel doesn't add quotes with
the sheet name C262001)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



RE: publishing poi xmlbeans jars

2018-03-09 Thread Murphy, Mark
Since JAXB is being dropped from Java SE (deprecated in Java 9, removed in Java 
11), I don't think that this will be a problem. There may be other marshallers 
out there, but the more immediate problem is that we need to remove all JAXB 
code from POI because we can no longer rely on the JVM implementation, and the 
JAXB project is GPL code.

-Original Message-
From: Javen O'Neal [mailto:one...@apache.org] 
Sent: Thursday, March 08, 2018 9:24 PM
To: POI Developers List 
Subject: Re: publishing poi xmlbeans jars

+1 sending it back to Incubator or subproject of Commons.

+0.9 as a subproject of POI.

Would prefer Xmlbeans to have its own PMC to make it easier for other Apache 
devs to make changes, but given how stable/mature it is, the support volume 
should be low.

If/when POI does replace XMLBeans for a more memory efficient/faster XML 
library, it'd be awkward for our PMC to manage a product we don't use. We can 
move it out to incubator, attic, or put it up for adoption when that time comes.

As long as the board doesn't have reservations about us subprojecting XMLBeans 
and then making another change in a couple years, I'm fine with taking XMLBeans 
as a subproject of POI.

On Thu, Mar 8, 2018, 10:50 Dominik Stadler  wrote:

> +1
>
> On Wed, Mar 7, 2018 at 11:20 PM, pj.fanning  wrote:
>
> > +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
> >
> >
>

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



Re: publishing poi xmlbeans jars

2018-03-09 Thread Alain FAGOT BÉAREZ

+1

Je 2018-03-07 14:40, Dave Fisher skribis:

Hi -

Let’s get back on track.

We want to release XMLBeans 2.7.0 with the org.apache.xmlbeans
namespace for the benefit of all of the users who are dependent on it.
If POI does not want to do this then XMLBeans will need to go to the
Incubator.

Should we VOTE?

If yes then we can ask Infra to open the JIRA and move the svn
somewhere with the history. We also ask for the return of the website
to our LDAP.

Regards,
Dave

On Mar 7, 2018, at 4:04 AM, Murphy, Mark  
wrote:


If we do that, it needs to be in a major release because namespaces 
change. If we are going to repackage to support Java 9 modules, that 
should also happen at the same time.


-Original Message-
From: pj.fanning [mailto:fannin...@yahoo.com]
Sent: Tuesday, March 06, 2018 4:35 PM
To: dev@poi.apache.org
Subject: Re: publishing poi xmlbeans jars

I have an experimental xmlbeans jar where I changed the package name 
to org.apache.poi.xmlbeans just to see if it was feasible to get it 
build. I also have a poi branch that successfully uses this jar.

https://repo1.maven.org/maven2/com/github/pjfanning/xmlbeans/2.7.0-beta1/
It should be feasible to use a commons based package name if that was 
the route we went.




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



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



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