Re: XSSFCell.setCellFormula exception : "not implemented yet"

That error means the formula references a different workbook. What version of POI are you using? That stack trace doesn't match the latest release version as far as I can see. What you need to do is use the latest POI, 3.17, and register all external workbooks referenced in formulas via setupRe

Apache POI - row.getCell(column) returns string containing extra space between words

Attached are two excel sheets If we getCell of row2column2 cell it returns :- IF(ISERROR(1000), ,(1000)) for rep_cpm_21558.xlsx If we getCell of row2column2 cell it returns :- IF(ISERROR(1000),,(1000)) for rep_cpm_21558_addWijmo.xlsx There is space included while retrieving cell in rep_cpm_215

XSSFCell.setCellFormula exception : "not implemented yet"

Hello, I'm using apache poi for handling an excel file When I do this: [CODE] destCell.setCellFormula(sourceCell.getCellFormula()); [/CODE] [CODE] private void copyCell(Cell sourceCell, Cell destCell, Workbook destWb) throws Exception { int type = sourceCell.getCellType();