I am new to POI, and I have to use an older version of POI in existing
project at work.
One thing I noticed is if I add formula OR(AK3="",AK3="") to a cell using POI
and open that in MS-Excel, the value of the cell is show as #VALUE!
The Java statement I use is
cell.setCellFormula("OR(AK3=\"\",AL3=\"\")");
I could enter the same formula =OR(AK3="",AK3="") directly in MS-Excel
and get result as TRUE or FALSE.
So question
1. Is this bug fixed in latest version of POI?
2. Is there already a bug entry for this?
PS:
1. Right now I solved my problem by using 2 =IF(,,) instead of =OR(,)
2. Version details.
Info from poi.jar MANIFEST.MF file
Manifest-Version: 1.0
Ant-Version: Apache Ant 1.6.2
Created-By: 1.5.0_13-b05 (Sun Microsystems Inc.)
Built-By: yegor
Specification-Title: Apache POI
Specification-Version: 3.1-FINAL-20080629
Specification-Vendor: Apache
Implementation-Title: Apache POI
Implementation-Version: 3.1-FINAL-20080629
Implementation-Vendor: Apache
Info from System Info Window
Microsoft Excel
Version : 9.0
Build : 6627
Info from MS-Excel About Window
Microsoft(r) Excel 2000 (9.0.7616 SP-3)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
