I just spent the past couple days troubleshooting a very similar
issue. In the end, the only fix I could come up with is to check out
3.2-alpha1 from svn. It was actually quite easy to build.
If you look back at the history of this list you will find some of the
other suggestions I got. They didn't work for me, but they might work
for you.
Tony
On Sep 10, 2008, at 3:45 PM, John Byrne wrote:
This happens with the POI 3.1-FINAL library but not with the POI
2.5.1-FINAL library. The code is exactly the same for both of them.
If I force the cellType with setCellType the same thing happens.
Here's a code snippet:
StyleHelper.setPrecisionOne(ec.getCell("B45"),ec);
ec.getCell("B45").setCellType(HSSFCell.CELL_TYPE_FORMULA);
ec.getCell("B45").setCellFormula("IF(B38=\"\", \"\",
B42/B38)");
Any suggestions?
Thank you in advance...
John
John Byrne
Support Network for Battered Women
1257 Tasman Dr. Suite C
Sunnyvale, CA
94089
(408) 541-6100 x 138
Fax: (408) 541-3333
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
