Excel formula OR not working with POI

["Biju Gm@il" <bi...@gmail.com>]

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

Re: Excel formula OR not working with POI

[Nick Burch <ni...@torchbox.com>]

On Sun, 14 Dec 2008, Biju Gm@il wrote:
> Specification-Version: 3.1-FINAL-20080629

Try with 3.2, or even better a 3.5 beta

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org