Hi. I have found some issue, that blocked my book. When i tried to find a source of issue i have found following details:
1) I want to set up Lotus evaluation mode
2) I have found 2 method for Worsheet “setTransitionEvaluation”,“setTransitionEntry"
3) I have tried to set both methods for my worsheet, but after saving a book in disk i unable to set a date in empty cell. I don’t understand what happens with sheet (i unable to made cell valid for input date)
Example:
public void changeFormatTest() throws Exception {
Workbook wb = new Workbook();
Worksheet ws = wb.getWorksheets().get(0);
Cells cells = ws.getCells();
Cell cell = cells.get(“A4”);
cell.putValue(”", true);
ws.setTransitionEvaluation(true);
ws.setTransitionEntry(true);
wb.save(“D:\out.xlsx”);
}
Open out.xlsx and try to input a date in A4. Catch error (see error.png. Unfortunatelly i have no English Excel)
Can you please help me with this methods. Can you please provide detail description for this.
Best regards. Alexey