This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Formula not rendered with POI 3.6

 
Samir Banerjee
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We were using POI 2.5 and I am upgrading that to POI 3.6. Now in a strange issue when with old 2.5 jars I render one excel file that has a formula li ke
F22-F33. The value is rendered properly. Now with replacing the new 3.6 jar and without a single line of code change the formulas are not rendered.
Is this a issue with POI 3.6. Do I need to do something extra for this? Can't I neglect the formulas and let excel take care of it itself?

Please help as I cannot find any way out. Thanks in advance.
 
Lester Burnham
Rancher
Posts: 1337
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you mean by "render" - displaying it in Excel? So the problem is that some Java code using POI 2.5 generates a file that displays correctly in Excel, while using the same code with POI 3.6 produces a file that's not displaying correctly? If so, please post an SSCCE that demonstrates the issue.
 
Samir Banerjee
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So I would like to explain my problem more elaborately. Suppose there is an excel file where user has specified a formula like F2-F1.So in F1 there is a variable x and in F2 there is another variable y. We read that excel file and from our code populate the values of x and y. But we do not touch the formula and it stays as it is.

In this scenario when I am using POI 3.5 the formula cell is populated without any problem. But for the same file with the same code when I use POI 3.5,POI 3.6 or POI 3.7 beta the formula cell shows error and cannot render the value.

So my question is for the these versions do I explicitly need to handle these codes. But the problem is how can I handle in code as these are generated run time and JAVA code won't understand F2 or F1 as such.

Is this an issue? Is it a known one and has some work around.Its quite hard to digest that an older version supports something that newer doesn't.
Kindly help me out. As I can't find any solution. Thanks in advance!!!

I hope I am clear,If there is still doubt please let me know I can give more information.
 
Samir Banerjee
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can kindly give some clue or hint for this issue.Please I have tried all possibilities and stuck with no solution . Please let me know if there can be any workaround.
Thanks in advance.
 
Lester Burnham
Rancher
Posts: 1337
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Lester Burnham wrote:post an SSCCE that demonstrates the issue.
 
Samir Banerjee
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Lester,
Giving SSCE will be a bit difficult in this case. But one more thing I want to share with you is that when I am using Excel 2010 the formulas are rendered fine without any issue. But for the previous versions it is giving problem. Will this information help anyways?
Thanks!!!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic