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 Tue, 05 Apr 2011 16:17:36 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=48043

ivano.diana@ext.bhuman.it changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|P2                          |P1
                 CC|                            |ivano.diana@ext.bhuman.it
            Version|3.5-FINAL                   |3.7

--- Comment #2 from ivano.diana@ext.bhuman.it 2011-04-05 12:17:32 EDT ---
I encountered some problems with HSSF component when using "CONCATENATE"
function inside an excel formula. In particular, it seems this function doesn't
work when inside other function or instructions-for example inside an IF. I
post some code examples to better explain the problem:

cellFormula.setFormula("IF(true, CONCATENATE(B2,B3), \"\")");

cellFormula.setFormula("CONCATENATE(IF(C2=\"X\",CONCATENATE(B2,\"
\"),\"\"),IF(C3=\"X\",CONCATENATE(B3,\" \"),\"\"),IF(C4=\"X\",CONCATENATE(B4,\"
\"),\"\"))");

The issue is the classic "#VALUE!" that appears when trying to evaluate the
formula. 

I was wondering if as happened with "Bug 50384" you are providing to fix it in
Dev versions.

-- 
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