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] New: Excel complains about a POI generated function
Date Fri, 23 Oct 2009 14:07:06 GMT
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@poi.apache.org
        ReportedBy: alamothe@gmail.com


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


Mime
View raw message