https://issues.apache.org/bugzilla/show_bug.cgi?id=48043
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P2 |P1 CC| |[email protected] Version|3.5-FINAL |3.7 --- Comment #2 from [email protected] 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: [email protected] For additional commands, e-mail: [email protected]
