• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Duplicate PageSettingsBlock record (sid=0x89c) in POI API 3.6.

 
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I am in a real fix and not sure what to do. In our application we store the excel file as clob in the database.
Now to upload or download we use POI in our application.Our code is like this :-


Only workaround that I got from several blogs is to resave the excel file. But unfortunately it is not possible in our case as there are too many files.
Please let me know if there is any workaround in the code to solve this issue for now.
Also let me know if more information is required. Thanks in advance!!!
 
Samir Banerjee
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This was a POI 3.6 bug and was fixed in POI 3.7. So my issue is solved now.

But there on more issue with formula, where its giving !#REF! error. Same was working fine with POI 2.5 in our application.
Is this another bug.Is there any workaround. Please help.
Thanks in advance!!!
 
Rancher
Posts: 1337
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Is the reference for a cell in a sheet that exists and is accessible?
 
Samir Banerjee
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks for the reply.

Yes...and when I am using old POI 2.5, the values are being populated but with POI 3.6 and POI 3.7 the problem occurs.
So this shows that reference exists and accessible.

 
Samir Banerjee
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Lester,
Please let me know if you need more information. I need to resolve this issue ASAP .
Thanks!!!
 
author
Posts: 3285
13
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
PatienceIsAVirtue
 
Samir Banerjee
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ha ha... I have it my friend...but my client is furious :P ..
But sorry if I was too impatient...
Never mind,
One more thing that I can give is the formulas :
=IF(ISBLANK('RAW DATA DNU'!D40),"",('RAW DATA DNU'!D40))
or
='Proposal Shell'!C35

These values get evaluated when I use POI 2.5. Error comes for 3.6 or 3.7.
Thanks again!!!
 
Martijn Verburg
author
Posts: 3285
13
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I think you're going to have compatibility issues between POI 2.5 and 3.6/3.7. Have you tried taking elements out of the formula to see what could be triggering the error?
 
Samir Banerjee
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Can you please elaborate what do you mean by compatibility issues?
 
Martijn Verburg
author
Posts: 3285
13
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
3.6 indicates a major version change over 2.5, chances are the formula handling in POI has changed. It may be a bug but it also ma be a deliberate change.
 
Lester Burnham
Rancher
Posts: 1337
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I seem to recall that there were changes in POI 3.5 and newer with respect to accessing external files. I suggest to start with a very simple example, and see if you can get that working. Also check the javadocs to see if there are any methods that look like they might be related to that. And, of course, search online for issues regarding external file references.
 
Samir Banerjee
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Lester.
I will let all know when my issue is resolved.
reply
    Bookmark Topic Watch Topic
  • New Topic