POI 3.7 can't get formula

[andrey skrypnik]

yes, i did so :

newCell.setCellType(XSSFCell.CELL_TYPE_FORMULA);
newCell.setCellValue("=BDP($C270;E$1)");

but actually i have to do something like : 
newCell.setCellValue(cell.getCellFormula());

bcs oldCell contains a macros! 



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org