Bug 9802 - formula results in #value in excell
Summary: formula results in #value in excell
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-dev
Hardware: PC All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-06-12 10:02 UTC by pete jackson
Modified: 2005-03-20 17:06 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description pete jackson 2002-06-12 10:02:44 UTC
V1.60-dev-20020612.jar

entering a formula sum(A1:B1), in excel the formula is shown correctly but the 
value is shown as '#value'
Comment 1 Andy Oliver 2002-06-12 12:32:41 UTC
which cell are you setting this to.  What is the value of A1?  What is the Value
of B1?  Does it work if you capitalize SUM?
Comment 2 Avik Sengupta 2002-06-12 12:43:53 UTC
Now fixed on HEAD. please try a new nightly after 12 june.  Also added this 
case to testRVAOperands in TestFormulas.