We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

setTransitionEntry method

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:

@Test
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

Sorry. I have found Excel’s flag transition entry, that works in same way.


Remove this post.

Best regards. Alexey

Hi Alexey,

Thanks for your posting and using Aspose.Cells.

It is good to know that you were able to sort out this issue. Let us know if you encounter any other issue, we will be glad to look into it and help you further.