I am trying to read value generated by formula from a cell in excel file like "=2+2". the excel file shows 4. But the code String.valueOf(cell.getNumericCellValue()); returns 0.0 instead of 4.0 I am using latest 3.0-dev POI classes. regards, vikas
use 2.0pre3. What do you mean by 3.0? are u using CVS HEAD directly, dont do that.. thats unstable. if using CVS, use REL_2_BRANCH. This functionality is well tested , and does work. If you still cant get it to work with 2.0pre3 , reopen this bug with example worksheet that replicates the problem.