poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 48043] Excel complains about a POI generated function
Date Thu, 05 Nov 2009 16:10:02 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=48043

--- Comment #1 from suat gonul <suatgonul@gmail.com> 2009-11-05 08:09:59 UTC ---
I have the same problem and the code causing this problem looks like the
following one:

String formula = "IF(F2<>\"\",CONCATENATE(F2,\" \",G2),G2)";
cell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
cell.setCellFormula(formula);

In detail, when both F2 and G2 cells are filled with some text, the problem
occurs but when F2 contains empty string, the problem does not occur.

I add a text into F2 cell with a code like in the following:

String str = "foo";
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue(str);

PS: all cell variables have the type of HSSFCell.
PS2: I open the file I created; enter some text into F2 manually; press enter;
and the formula cell again has #VALUE!. After clicking the formula cell, it
shows the correct value.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

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


Mime
View raw message