DO NOT REPLY [Bug 48043] New: Excel complains about a POI generated function

https://issues.apache.org/bugzilla/show_bug.cgi?id=48043

           Summary: Excel complains about a POI generated function
           Product: POI
           Version: 3.5-FINAL
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@...
        ReportedBy: alamothe@...


When I insert the following function in a cell:

=IF(AND(ISBLANK(A10),ISBLANK(B10)),"",CONCATENATE(A10,"-",B10))

using:

cell.setCellFormula(
        "IF(AND(ISBLANK(A10)," +
        "ISBLANK(B10)),\"\"," +
        "CONCATENATE(A10,\"-\",B10))");

Excel complains about it (#VALUE!) when the workbook is first opened. However,
it is enough just to press F2, Enter on a cell for the function to start
evaluating properly. Interestingly, this problem does not appear in OpenOffice.

--
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@...
For additional commands, e-mail: dev-help@...

https://issues.apache.org/bugzilla/show_bug.cgi?id=48043

alamothe@... changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |alamothe@...

--
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@...
For additional commands, e-mail: dev-help@...

https://issues.apache.org/bugzilla/show_bug.cgi?id=48043

--- Comment #1 from suat gonul <suatgonul@...> 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@...
For additional commands, e-mail: dev-help@...