I created an excel file using the Apache Poi API, in it I set one of the cells with a formula, but when I open the file I need to "enter" in the cell with the formula so that it will print the result in the file. Would there be a way to make this result appear automatically?
code:
destino.getSheet("Status dos Testes").getRow(2).createCell(7).setCellType(CellType.FORMULA);
destino.getSheet("Status dos Testes").getRow(2).getCell(7).setCellFormula("CONT.SE($D$6:$D$10000, Legenda!A6)");