Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
From: bugzilla@apache.org
To: dev@poi.apache.org
Subject: DO NOT REPLY [Bug 44677] COUNTA function gives incorrect result
In-Reply-To: <bug-44677-47293@https.issues.apache.org/bugzilla/>
Content-Type: text/plain; charset="UTF-8"
MIME-Version: 1.0
Message-Id: <20080326184343.AA271234C0AC@brutus.apache.org>
Date: Wed, 26 Mar 2008 11:43:43 -0700 (PDT)

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


--- Comment #1 from Josh Micich <josh@gildedtree.com>  2008-03-26 11:43:43 PST ---
POI currently saves these formulas with tokens of tAreaV(0x45) instead of
tAreaR (0x25).  In my excel (2007) I observe *both* formulas to be wrong at
first (A4=0, A5=1, until re-entered).

It looks like the problem is in FormulaParser.setParameterRVA(Node, int)
Commenting out the call to that method seems to fix this bug, but that is not a
proper solution.  Without that call, the token classes of all parsed formulas
will stay at 'reference', which is probably wrong for other formulas.

This functionality is related to the 'Token Class Transformation' section
(3.2.4) of excelfileformat.pdf.  This logic seems to be partially implemented
in POI but since there are no junits, it's probably not very stable yet.


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