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