Bug 26700

Summary: Created workbook, formula's thru Excel don't work
Product: POI Reporter: Larry Cryderman <LCryderman>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED INVALID    
Severity: normal    
Priority: P3    
Version: 2.0-pre2   
Target Milestone: ---   
Hardware: All   
OS: other   

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-
final.
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 
correct.

replies:
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 )