I have an excel file with xlsx extension. I have some cells which are drop down fields. when I am selecting values for these fields manually excel formulas are run correctly. When I write the value in these fields using XSSF API's from java program, values are shown properly in excel sheet but the formulas are not executed. Is there a way using API's I can select the value from drop down so that excel understands it and runs the formula to give me desired result. Thanks in advance for any valuable suggestion. Best regards, Pramod
You need to trigger the formula evaluation yourself when you're done making changes, see http://poi.apache.org/spreadsheet/eval.html