XSSFCell gives you access to the underlying xml bean. You can bypass the
call of setCellFormula and copy 'raw' xml as follows:
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellFormula
srcFormula = cell.getCTCell().getF();
newCell.getCTCell().setF(srcFormula);
Warning: this is not a recommended approach. Accessors to low-level XML
beans can be removed in future or method signatures will be changed. POI
only supports code that is based on public usermodel methods.
Yegor
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