#VALUE results from entering formula with POI

[John Byrne]

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