poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Biju Gm@il" <bijumaill...@gmail.com>
Subject Excel formula OR not working with POI
Date Sun, 14 Dec 2008 17:37:40 GMT
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message