I got a problem with cell changing its type from formula to non-formula when I want to change text in shape which is apparently linked with the mentioned cell. What happens is that the text which I tried to set to that shape has been set into a mentioned cell too, and that cell becomes non-formula although it was formula before changing text in shape. I need to change text on shape without changing fact that mentioned cell is formula.
Workbook workbook = new Workbook(“BILANSIZBIRNO.XLS”);
boolean isFormulaBefore = workbook.getWorksheets().get(8).getCells().get(“F47”).isFormula();
Shape shape = workbook.getWorksheets().get(0).getShapes().get(8);
boolean isFormulaAfter = workbook.getWorksheets().get(8).getCells().get(“F47”).isFormula();
<span style=“font-family: “Courier New”;”>
Excel file is attached to the post. Can You help me here?