Re: Reg: POI-4.0 Issue

[dillibabu venugopal]

Hi ,

Thank you for your response,

I will try with your advice and come back to you if I need further
assistance on this.

Thank you

Regards,
V. Dillibabu

On Thu, Dec 20, 2018 at 4:29 AM Andreas Reichel <
andr...@manticore-projects.com> wrote:

> Good Morning again,
>
> it looks we are working on very similar stuff as we trigger the same
> issues:
>
> java.lang.IllegalStateException: Chunk 204 no longer exists [1.4.197/9]
> at
> org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:870)
>
> The error message above is from H2 itself and (very likely) has nothing
> to do with Apache POI in particular.
> H2 1.4.197 is still under heavy development and it was quite unstable
> for me until 1-2 months ago. I experienced lock-ups and error messages
> like that.
>
> Although I compiled a snapshot of the GIT repository a few weeks ago
> which seems to be fast and stable. So my advice is to pull a recent
> snapshot and compile it yourself and then to try again with Apache POI.
>
> Best regards
> Andreas
>
> On Thu, 2018-12-20 at 06:16 +, dillibabu venugopal wrote:
> > Hi POI Support Team,
> > We are also looking support for the same issue, Our team member has
> > raised the below bug for the issue when we open huge size excel, the
> > bug is concluded that the fix would be available in POI-4.0.
> >
> > So, we have upgraded from 3.9 to 4.0, but we are getting attached
> > error while generate huge size of file (0.5 million rows & 160
> > column).
> >
> > The server is having sufficient memory to hold the data.
> >
> > Heap memory - 6GB
> > RAM - 8 GB
> >
> > So, we need your support to resolve this issue and can able to
> > generate huge size file.
> >
> > Let me know if you need further detail on this.
> >
> > Thank you.
> >
> > Regards,
> > V. Dillibabu
> >
> > On Thu, Dec 20, 2018 at 5:49 AM Andreas Reichel <
> > andr...@manticore-projects.com> wrote:
> > > Good Morning,
> > >
> > >
> > >
> > > it is related to 4 GB size limits and the use of ZIP64, please see
> > >
> > > https://bz.apache.org/bugzilla/show_bug.cgi?id=62872
> > >
> > > My understanding is, that you can enforce the use of ZIP64 now
> > > although
> > >
> > > you have decide by yourself when to switch it on. Also ZIP64 is not
> > >
> > > supported by LibreOffice. Gnumeric works fine, I do not know about
> > >
> > > Excel.
> > >
> > >
> > >
> > > Best regards
> > >
> > > Andreas
> > >
> > >
> > >
> > >
> > >
> > > On Thu, 2018-12-20 at 05:30 +, dillibabu venugopal wrote:
> > >
> > > > Hi All,
> > >
> > > >
> > >
> > > >
> > >
> > > > We are upgrading poi version from 3.9 to 4.0 for fixing an
> > >
> > > > issue, which released in 4.0. The ticket details is given below
> > > for
> > >
> > > > your
> > >
> > > > reference.
> > >
> > > >
> > >
> > > >
> > >
> > > >  Bug Request :
> > > https://bz.apache.org/bugzilla/show_bug.cgi?id=61832
> > >
> > > >
> > >
> > > >
> > >
> > > >
> > >
> > > > Before upgrade:
> > >
> > > >
> > >
> > > >
> > >
> > > > Jar: poi-ooxml-3.9
> > >
> > > >
> > >
> > > >
> > >
> > > > After Upgrade:
> > >
> > > >
> > >
> > > >
> > >
> > > > poi-4.0.0
> > >
> > > > poi-ooxml-4.0.0
> > >
> > > >
> > >
> > > >
> > >
> > > > xmlbeans-3.0.1
> > >
> > > >
> > >
> > > >
> > >
> > > > poi-shared-string-1.0.0
> > >
> > > >
> > >
> > > >
> > >
> > > > h2-1.4.197
> > >
> > > >
> > >
> > > >
> > >
> > > >
> > >
> > > >
> > >
> > > >
> > >
> > > >  After upgraded POI
> > >
> > > > version to 4.0,we are able to generate excel report and download
> > > it
> > >
> > > > in browser
> > >
> > > > until 0.2 million rows with 160 columns. But it is not working
> > > when
> > >
> > > > we try for
> > >
> > > > 0.5 million rows with 160 columns and getting below h2 database
> > >
> > > > error.The
> > >
> > > > error file is attached along with this email.
> > >
> > > >
> > >
> > > >
> > >
> > > >
> > >
> > > >
> > >
> > > >
> > >
> > > > So, I request you this issue and help us to fix it in our
> > >
> > > > application.
> > >
> > > > Let me know if you need any further details on this.
> > >
> > > >
> > >
> > > >
> > >
> > > >
> > >
> > > > Thank you for your support.
> > >
> > > >
> > >
> > > > ---
> > > 
> > >
> > > > --To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
> > >
> > > > For additional commands, e-mail: user-h...@poi.apache.org
> > >
> > >
> > >
> > >
> > >
> >
> >
> > ---
> > --To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
> > For additional commands, e-mail: user-h...@poi.apache.org
>
>
>

-- 
Regards,
V. Dillibabu

Re: error setting style

[Rob Sargent]

Off to a "Lab party" just now, but I hope to get you some chunks of my 
app (as broken).



On 12/20/18 4:53 PM, Greg Woolsey wrote:

I'm interested to see how you are creating the new sheet, wondering if
something lost a reference to the StylesTable somehow.  Since I have code
that also manipulates styles and adds/removes cells, I'm interested to see
if a bug was introduced or documentation needs improving, or perhaps some
internal API is exposed without proper documentation or safety checks.

Greg

On Thu, Dec 20, 2018 at 3:05 PM Rob Sargent  wrote:


I have circumvented the situation by using copyStyleFrom(). I posted
because a) I'm setting styles on cell in a new sheet in the origin
workbook - which to me contradicts the helpful hint and b) I had been
doing exactly that in the recent pass.

If you still want my code which generates the error I can back up a
bit.  The partial stack trace I sent was all lines not in my code.


On 12/20/18 3:55 PM, Greg Woolsey wrote:

Can you provide a test case, sample code, or full stacktrace?  How is the
new sheet created? It looks to me from the code that the message means
exactly what it says - the style you are trying to set and the cell you

are

trying to set it on come from different Workbook objects.  Both the style
and the cell hold a reference to the StylesTable object read from (or
created for) the Workbook in which they are found.  POI doesn't support
directly assigning styles across Workbook instances.  See this thread[1]
for a description of why, and what to do instead when you need to copy a
style between workbooks.

Greg

[1]


https://stackoverflow.com/questions/10773961/apache-poi-apply-one-style-to-different-workbooks

On Thu, Dec 20, 2018 at 11:58 AM Rob Sargent 

wrote:

I'm using 4.0.1 as of this morning hoping this would help.  I have
recently begun to get:

  Exception in thread "main" java.lang.IllegalArgumentException: This
  Style does not belong to the supplied Workbook Styles Source. Are
  you trying to assign a style from one workbook to the cell of a
  different workbook?
   at



org.apache.poi.xssf.usermodel.XSSFCellStyle.verifyBelongsToStylesSource(XSSFCellStyle.java:121)

   at


org.apache.poi.xssf.usermodel.XSSFCell.setCellStyle(XSSFCell.java:667)

and I am adding style to a cell in a new sheet, same workbook. The
immediate code is not new and had been working (in 4.0.0). Not sure what
change I made has caused this to start.

I confess the original xlsx has been touched by LibreOffice/Calc and
saved as xlsx.  Linux file command reports:

  file '/home/u0138544/tools/reform/Compicated Query for Rob

Tool.xlsx'

  /home/u0138544/tools/reform/Compicated Query for Rob Tool.xlsx:
  Microsoft OOXML

Any suggestions appreciated.




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




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

Re: error setting style

[Greg Woolsey]

I'm interested to see how you are creating the new sheet, wondering if
something lost a reference to the StylesTable somehow.  Since I have code
that also manipulates styles and adds/removes cells, I'm interested to see
if a bug was introduced or documentation needs improving, or perhaps some
internal API is exposed without proper documentation or safety checks.

Greg

On Thu, Dec 20, 2018 at 3:05 PM Rob Sargent  wrote:

> I have circumvented the situation by using copyStyleFrom(). I posted
> because a) I'm setting styles on cell in a new sheet in the origin
> workbook - which to me contradicts the helpful hint and b) I had been
> doing exactly that in the recent pass.
>
> If you still want my code which generates the error I can back up a
> bit.  The partial stack trace I sent was all lines not in my code.
>
>
> On 12/20/18 3:55 PM, Greg Woolsey wrote:
> > Can you provide a test case, sample code, or full stacktrace?  How is the
> > new sheet created? It looks to me from the code that the message means
> > exactly what it says - the style you are trying to set and the cell you
> are
> > trying to set it on come from different Workbook objects.  Both the style
> > and the cell hold a reference to the StylesTable object read from (or
> > created for) the Workbook in which they are found.  POI doesn't support
> > directly assigning styles across Workbook instances.  See this thread[1]
> > for a description of why, and what to do instead when you need to copy a
> > style between workbooks.
> >
> > Greg
> >
> > [1]
> >
> https://stackoverflow.com/questions/10773961/apache-poi-apply-one-style-to-different-workbooks
> >
> > On Thu, Dec 20, 2018 at 11:58 AM Rob Sargent 
> wrote:
> >
> >> I'm using 4.0.1 as of this morning hoping this would help.  I have
> >> recently begun to get:
> >>
> >>  Exception in thread "main" java.lang.IllegalArgumentException: This
> >>  Style does not belong to the supplied Workbook Styles Source. Are
> >>  you trying to assign a style from one workbook to the cell of a
> >>  different workbook?
> >>   at
> >>
> >>
> org.apache.poi.xssf.usermodel.XSSFCellStyle.verifyBelongsToStylesSource(XSSFCellStyle.java:121)
> >>   at
> >>
> org.apache.poi.xssf.usermodel.XSSFCell.setCellStyle(XSSFCell.java:667)
> >>
> >> and I am adding style to a cell in a new sheet, same workbook. The
> >> immediate code is not new and had been working (in 4.0.0). Not sure what
> >> change I made has caused this to start.
> >>
> >> I confess the original xlsx has been touched by LibreOffice/Calc and
> >> saved as xlsx.  Linux file command reports:
> >>
> >>  file '/home/u0138544/tools/reform/Compicated Query for Rob
> Tool.xlsx'
> >>  /home/u0138544/tools/reform/Compicated Query for Rob Tool.xlsx:
> >>  Microsoft OOXML
> >>
> >> Any suggestions appreciated.
> >>
> >>
> >>
>
> -
> To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
> For additional commands, e-mail: user-h...@poi.apache.org
>
>

Re: error setting style

[Rob Sargent]

I have circumvented the situation by using copyStyleFrom(). I posted 
because a) I'm setting styles on cell in a new sheet in the origin 
workbook - which to me contradicts the helpful hint and b) I had been 
doing exactly that in the recent pass.


If you still want my code which generates the error I can back up a 
bit.  The partial stack trace I sent was all lines not in my code.



On 12/20/18 3:55 PM, Greg Woolsey wrote:

Can you provide a test case, sample code, or full stacktrace?  How is the
new sheet created? It looks to me from the code that the message means
exactly what it says - the style you are trying to set and the cell you are
trying to set it on come from different Workbook objects.  Both the style
and the cell hold a reference to the StylesTable object read from (or
created for) the Workbook in which they are found.  POI doesn't support
directly assigning styles across Workbook instances.  See this thread[1]
for a description of why, and what to do instead when you need to copy a
style between workbooks.

Greg

[1]
https://stackoverflow.com/questions/10773961/apache-poi-apply-one-style-to-different-workbooks

On Thu, Dec 20, 2018 at 11:58 AM Rob Sargent  wrote:


I'm using 4.0.1 as of this morning hoping this would help.  I have
recently begun to get:

 Exception in thread "main" java.lang.IllegalArgumentException: This
 Style does not belong to the supplied Workbook Styles Source. Are
 you trying to assign a style from one workbook to the cell of a
 different workbook?
  at

org.apache.poi.xssf.usermodel.XSSFCellStyle.verifyBelongsToStylesSource(XSSFCellStyle.java:121)
  at
 org.apache.poi.xssf.usermodel.XSSFCell.setCellStyle(XSSFCell.java:667)

and I am adding style to a cell in a new sheet, same workbook. The
immediate code is not new and had been working (in 4.0.0). Not sure what
change I made has caused this to start.

I confess the original xlsx has been touched by LibreOffice/Calc and
saved as xlsx.  Linux file command reports:

 file '/home/u0138544/tools/reform/Compicated Query for Rob Tool.xlsx'
 /home/u0138544/tools/reform/Compicated Query for Rob Tool.xlsx:
 Microsoft OOXML

Any suggestions appreciated.





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

how to instrument the apache bundles poi 4.0.0_1

[Mills, Gary (GE Digital)]

Thanks again! Really!  

Yeah, I just now sent a request to join / sign up to ServiceMix nabble  , 
hopefully they'll let me in soon. 

-Original Message-
From: Andreas Beeker  
Sent: Thursday, December 20, 2018 4:57 PM
To: user@poi.apache.org
Subject: EXT: Re: how to instrument the apache bundles poi 4.0.0_1

When you said before "Not getting any response on this at all.", you've already 
tried the obvious in writing to the service mix mailing list [1], right?

Well ... I've checked the mailing lists on nabble and you haven't done so.

I could have a look again how service mix works and provide a patch for 4.0.1 
... but in the end you will need to apply the patch to a local service mix 
checkout. The only way to get that it in an official form is to reach out to 
the service mix guys.

Andi

[1] http://servicemix.apache.org/community/mailing-lists.html


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

Re: error setting style

[Greg Woolsey]

Can you provide a test case, sample code, or full stacktrace?  How is the
new sheet created? It looks to me from the code that the message means
exactly what it says - the style you are trying to set and the cell you are
trying to set it on come from different Workbook objects.  Both the style
and the cell hold a reference to the StylesTable object read from (or
created for) the Workbook in which they are found.  POI doesn't support
directly assigning styles across Workbook instances.  See this thread[1]
for a description of why, and what to do instead when you need to copy a
style between workbooks.

Greg

[1]
https://stackoverflow.com/questions/10773961/apache-poi-apply-one-style-to-different-workbooks

On Thu, Dec 20, 2018 at 11:58 AM Rob Sargent  wrote:

> I'm using 4.0.1 as of this morning hoping this would help.  I have
> recently begun to get:
>
> Exception in thread "main" java.lang.IllegalArgumentException: This
> Style does not belong to the supplied Workbook Styles Source. Are
> you trying to assign a style from one workbook to the cell of a
> different workbook?
>  at
>
> org.apache.poi.xssf.usermodel.XSSFCellStyle.verifyBelongsToStylesSource(XSSFCellStyle.java:121)
>  at
> org.apache.poi.xssf.usermodel.XSSFCell.setCellStyle(XSSFCell.java:667)
>
> and I am adding style to a cell in a new sheet, same workbook. The
> immediate code is not new and had been working (in 4.0.0). Not sure what
> change I made has caused this to start.
>
> I confess the original xlsx has been touched by LibreOffice/Calc and
> saved as xlsx.  Linux file command reports:
>
> file '/home/u0138544/tools/reform/Compicated Query for Rob Tool.xlsx'
> /home/u0138544/tools/reform/Compicated Query for Rob Tool.xlsx:
> Microsoft OOXML
>
> Any suggestions appreciated.
>
>
>

how to instrument the apache bundles poi 4.0.0_1

[Mills, Gary (GE Digital)]

Andreas, please forgive me, I'm terribly sorry, but can you please tell me or 
direct me to where I can get support for the apache.servicemix.bundles ? 

-Original Message-
From: Andreas Beeker  
Sent: Thursday, December 20, 2018 4:23 PM
To: user@poi.apache.org
Subject: EXT: Re: how to instrument the apache bundles poi 4.0.0_1

I did that patch locally to validate some OSGI problems before POI 4.0.0 was 
released.
I've seen that there's already a 4.0.0 version of the service mix bundle - as 
Dave suggested - but I haven't checked the differences.

My hope was, that the patch might help you in fixing the service mix.

Regarding the poi-contrib module ... this is long gone.


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

how to instrument the apache bundles poi 4.0.0_1

[Mills, Gary (GE Digital)]

Ok, wow! Incredible!  Thanks again Andreas.  That poi-contrib module is all 
over the servicemix.bundle.poi in practically all the releases.   

-Original Message-
From: Andreas Beeker  
Sent: Thursday, December 20, 2018 4:23 PM
To: user@poi.apache.org
Subject: EXT: Re: how to instrument the apache bundles poi 4.0.0_1

I did that patch locally to validate some OSGI problems before POI 4.0.0 was 
released.
I've seen that there's already a 4.0.0 version of the service mix bundle - as 
Dave suggested - but I haven't checked the differences.

My hope was, that the patch might help you in fixing the service mix.

Regarding the poi-contrib module ... this is long gone.


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


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

Re: how to instrument the apache bundles poi 4.0.0_1

[Andreas Beeker]

I did that patch locally to validate some OSGI problems before POI 4.0.0 was 
released.
I've seen that there's already a 4.0.0 version of the service mix bundle - as 
Dave suggested -
but I haven't checked the differences.

My hope was, that the patch might help you in fixing the service mix.

Regarding the poi-contrib module ... this is long gone.


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

how to instrument the apache bundles poi 4.0.0_1

[Mills, Gary (GE Digital)]

Andreas, 

I'm sorry but I'm confused. Wondering if reply to emails got crossed. 

I'm trying to resolve dependencies for the apache.servicemix.bundle.poi , 
upgrading from 3.9_2 to 4.0.0_1 . 

Is this patch for me, for this fix?  If so can I get it from Maven repos?

The poi-contrib is bundled in this servicemix.bundle.poi ? 



-Original Message-
From: Andreas Beeker  
Sent: Thursday, December 20, 2018 2:40 PM
To: user@poi.apache.org
Subject: EXT: Re: how to instrument the apache bundles poi 4.0.0_1

For POI 4.0.0, I've created a patch 
(http://people.apache.org/~kiwiwings/servicemix-poi-4.0.0.patch),
feel free to use it as a starting point. I've just realized that there's a 
sandbox for Apache committers, maybe I should push my updates there ...


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

Re: how to instrument the apache bundles poi 4.0.0_1

[Andreas Beeker]

For POI 4.0.0, I've created a patch 
(http://people.apache.org/~kiwiwings/servicemix-poi-4.0.0.patch),
feel free to use it as a starting point. I've just realized that there's a 
sandbox for Apache committers,
maybe I should push my updates there ...


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

how to instrument the apache bundles poi 4.0.0_1

[Mills, Gary (GE Digital)]

Thanks Dave, will do.  Not getting any response on this at all.  It's on 
stacktrace, here, stacktrace super, 
If there are any folks out there successfully implementing servicemix bundle 
poi for 4.0.0_1 your help would be greatly appreciated. 


-Original Message-
From: Dave Fisher  
Sent: Wednesday, December 19, 2018 10:38 PM
To: POI Users List 
Subject: EXT: Re: how to instrument the apache bundles poi 4.0.0_1

I would suggest that you also reach out to the servicemix project. Take a look 
at https://github.com/apache/servicemix-bundles/tree/master/poi-4.0.0 where 
there is active work.

Sent from my iPhone

> On Dec 19, 2018, at 4:35 PM, Mills, Gary (GE Digital)  
> wrote:
> 
> Hello, I am trying to upgrade from 
> org.apache.servicemix.buncles.poi.3.9_2 to 4.0.0_1  (*thanks in 
> advance)
> 
> I inherited an application that used 3.9_2, simply to read xlsx spreadsheets 
> and update a database.
> 
> I needed to write an app to read in a template, update the template with 
> message exchange data, then send the xlsx workbook to some destination.  I 
> had it all working with 3.9_2, however, there is no workbook.close() method 
> in 3.9_2. So, I opted to upgrade to 4.0.0_1.  On my journey I tried each 
> release up to 4.0.0_1 unsuccessfully.  I then just settled on 4.0.0_1 to try 
> to get it working.
> 
> I'm almost there, however, I cannot resolve alll the dependencies.
> 
> Error executing command: Could not start bundle 
> mvn:com.ge.ip.infra/delta-fadec-prod/3.0.1-SNAPSHOT in feature(s) 
> fadec-application-1.0.0: Unresolved constraint in bundle 
> delta-fadec-prod [348]: Unable to resolve 348.0: missing requirement 
> [348.0] osgi.wiring.package; 
> (&(osgi.wiring.package=org.apache.poi.ss.usermodel)(version>=4.0.0)(!(
> version>=5.0.0))) [caused by: Unable to resolve 319.0: missing 
> requirement [319.0] osgi.wiring.package; 
> (osgi.wiring.package=org.apache.xml.security.signature)]
> 
> I'm pretty close, stuck here... the bottom of the manifest for 4.0.0_1, the 
> rest starting at org.apache.xml.security.signature, the org.w3c.dom, etc...
> 
> l.extensions;version="[4.0,5)",org.apache.poi.xssf.util;version="[4.0
> ,5)",org.apache.xml.security.signature,org.ietf.jgss,org.w3c.dom,org.
> w3c.dom.events,org.w3c.dom.ls,org.xml.sax,org.xml.sax.ext,org.xml.sax
> .helpers,junit.framework;resolution:=optional
> 
> I've been at this for 3 days now, very frustrating, needing you expertise, 
> thank you.
> 
> POM
>   xmlns="http://maven.apache.org/POM/4.0.0;
>
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance;
>
> xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 
> http://maven.apache.org/maven-v4_0_0.xsd .0.0%20http:/maven.apache.org/maven-v4_0_0.xsd>">
> 
> 4.0.0
> 
>  
>com.ge.ip.infra
>ge.ip.infra.parent
>3.0.1-SNAPSHOT
>  
> 
>  delta-fadec-prod
>  bundle
> 
>  GE-IP Delta FADEC PROD ENV
> 
>  
> 
>  
>  
>com.ibm.dhbcore
>dhbcore
>7.5.0.2
>  
>  
>com.ibm.mq.jmqi
>jmqi
>   7.5.0.2
>  
>  
>com.ibm.mq
>mq
>7.5.0.2
>  
>  
>com.ibm.mqjms
>mqjms
>7.5.0.2
>  
> 
>  
> 
>   org.springframework
>   spring-jdbc
> 
> 
> 
>   com.mchange
>   c3p0
>
>
>
>  org.apache.servicemix.bundles
>  org.apache.servicemix.bundles.poi
>  4.0.0_1  
>
>
>org.apache.poi
>poi
>4.0.1
>
>
>org.apache.poi
>poi-ooxml
>4.0.1  
>
>   
>org.apache.poi
>poi-ooxml-schemas
>4.0.1
>
>
>org.apache.commons
>commons-collections4
>4.2
>
>  
>org.apache.poi
>ooxml-schemas
>1.4
>  
>
>org.apache.commons
>commons-math3
>3.6.1
>
>
>  commons-codec
>  commons-codec
>  1.11
>
>
>  org.apache.commons
>  commons-compress
>  1.18
>
>
>  org.apache.poi
>  ooxml-security
>  1.1
>
>
>com.enterprisemath
>em-utils
>2.4.0
>   
> 
> 
> 
>  
>mysql
>mysql-connector-java
>  
> 
>
>  org.apache.camel
>  camel-core
>
>
>  org.apache.camel
>  camel-sql
>
>
>  org.apache.camel
> 

error setting style

[Rob Sargent]

I'm using 4.0.1 as of this morning hoping this would help.  I have 
recently begun to get:


   Exception in thread "main" java.lang.IllegalArgumentException: This
   Style does not belong to the supplied Workbook Styles Source. Are
   you trying to assign a style from one workbook to the cell of a
   different workbook?
    at
   
org.apache.poi.xssf.usermodel.XSSFCellStyle.verifyBelongsToStylesSource(XSSFCellStyle.java:121)
    at
   org.apache.poi.xssf.usermodel.XSSFCell.setCellStyle(XSSFCell.java:667)

and I am adding style to a cell in a new sheet, same workbook. The 
immediate code is not new and had been working (in 4.0.0). Not sure what 
change I made has caused this to start.


I confess the original xlsx has been touched by LibreOffice/Calc and 
saved as xlsx.  Linux file command reports:


   file '/home/u0138544/tools/reform/Compicated Query for Rob Tool.xlsx'
   /home/u0138544/tools/reform/Compicated Query for Rob Tool.xlsx:
   Microsoft OOXML

Any suggestions appreciated.

setting style on new sheet, getting grief

[Rob Sargent]

I'm using 4.0.1 as of this morning hoping this would help.  I have 
recently begun to get:


   Exception in thread "main" java.lang.IllegalArgumentException: This
   Style does not belong to the supplied Workbook Styles Source. Are
   you trying to assign a style from one workbook to the cell of a
   different workbook?
    at
   
org.apache.poi.xssf.usermodel.XSSFCellStyle.verifyBelongsToStylesSource(XSSFCellStyle.java:121)
    at
   org.apache.poi.xssf.usermodel.XSSFCell.setCellStyle(XSSFCell.java:667)

and I am adding style to a cell in a new sheet, same workbook. The 
immediate code is not new and had been working (in 4.0.0). Not sure what 
change I made has caused this to start.


I confess the original xlsx has been touched by LibreOffice/Calc and 
saved as xlsx.  Linux file command reports:


   file '/home/u0138544/tools/reform/Compicated Query for Rob Tool.xlsx'
   /home/u0138544/tools/reform/Compicated Query for Rob Tool.xlsx:
   Microsoft OOXML

Any suggestions appreciated.

Re: how to instrument the apache bundles poi 4.0.0_1

[pj.fanning]

This is the mailing list for the Apache POI project. The Service Mix POI
bundle is not maintained by us.
If you are working on maintaining projects with POI dependencies, I would
recommend using POI 4.0,1 and removing anything to with poi-contrib which is
not maintained.



--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

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

how to instrument the apache bundles poi 4.0.0_1

[Mills, Gary (GE Digital)]

Hey PJ, thanks for the reply.

Is there a new release out?  I'm working off of this link for the releases, I 
do not see a 4.0.1 but a 4.0.0_1
Please let me know, thanks
https://mvnrepository.com/artifact/org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi


-Original Message-
From: pj.fanning  
Sent: Thursday, December 20, 2018 1:57 AM
To: user@poi.apache.org
Subject: EXT: Re: how to instrument the apache bundles poi 4.0.0_1

Is poi-contrib still supported? I didn't think it was and I suspect that the 
poi-contrib 3.6 will not work with poi 4.0.x.

Also, would it better to use poi* 4.0.1 - more stable than 4.0.0?



--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

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


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