https://issues.apache.org/bugzilla/show_bug.cgi?id=45593
Vinod <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #8 from Vinod <[EMAIL PROTECTED]> 2008-08-08 09:39:38 PST ---
The value of G1 is coming out to be 0 where as it should be 30. This is using
formula "=SUM(A1:F1)".
But instead of using this SUM formula, if I use "=A1+B1+C1+D1+E1", then it
works fine, see cell G2.
I took the source code of POI to find out that the if clause is not executed in
the following:
Class - org.apache.poi.hssf.record.formula.eval.ValueEvalToNumericXlator
Method - xlateRefStringEval
To test this I modified this method xlateRefStringEval
if ( (flags & REF_STRING_IS_PARSED) > 0) {
to
if ( true || (flags & REF_STRING_IS_PARSED) > 0) { // forcing to go in if block
and then the SUM formula worked.
--
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]
