Bug 26700 - Created workbook, formula's thru Excel don't work
Summary: Created workbook, formula's thru Excel don't work
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-pre2
Hardware: All other
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2004-02-05 21:25 UTC by Larry Cryderman
Modified: 2004-11-16 19:05 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Larry Cryderman 2004-02-05 21:25:42 UTC
We're creating basic workbooks each with various sheets.
When opened with Excel, we can't use cells we created
in a formula. We've set the type of cell to CELL_TYPE_NUMERIC
and set the data format to "0.00".
This is a big bug for us and we're in production with POI.
Comment 1 Niall Pemberton 2004-02-06 01:12:59 UTC
You need to supply more information. For example:

1) More description of symptoms ("can't use cells" is v.general).
2) Sample code which creates this problem.
3) Sample Workbook with the error.
4) Is the version of POI really 2.0-pre2 and if so does it still occur in 2.0-

Comment 2 Larry Cryderman 2004-02-06 18:37:38 UTC
Our code produced the atch'd workbook. The columns in question are on sheet 2 
range B2:G6.
We opened this file in Excel 2000 (9.0.3821 SR-1) and created the simple 
formula in B7 of the atch'd. As you can see, the result is incorrectly 0.0.
Another thing we noticed, is when opened thru Excel and you enter numberics in 
several cells, and then include those cells in a formula, the behavior is 

1) I hope the above narrative is more descriptive.
2) The company I'm consulting with does not want to release it's source code.
3) atch'd is a workbook created with POI
4) We downloaded 2.0-final and the error exists there also.
Comment 3 Larry Cryderman 2004-02-06 19:52:37 UTC
The reason for this is that we were calling setValue on the HSSFCell with a 
String object....no bug.
...now to figure out how to get no decimal points in our output (just whole 
numbers )