wood burning stoves*
The moose likes Other Open Source Projects and the fly likes Formula not rendered with POI 3.6 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Formula not rendered with POI 3.6" Watch "Formula not rendered with POI 3.6" New topic
Author

Formula not rendered with POI 3.6

Samir Banerjee
Ranch Hand

Joined: Jun 21, 2010
Posts: 72
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

Joined: Oct 14, 2008
Posts: 1337
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

Joined: Jun 21, 2010
Posts: 72
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

Joined: Jun 21, 2010
Posts: 72
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

Joined: Oct 14, 2008
Posts: 1337
Lester Burnham wrote:post an SSCCE that demonstrates the issue.
Samir Banerjee
Ranch Hand

Joined: Jun 21, 2010
Posts: 72
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!!!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Formula not rendered with POI 3.6
 
Similar Threads
SVTableModel only for HSSF.
#REF! error when trying to access cell of another Sheet in same workbook.
Read MS Excel Sheet Formula Execution Value Without Opening it
Help with POI 3.6 Excel cell validation
Duplicate PageSettingsBlock record (sid=0x89c) in POI API 3.6.