Bug 53155

Summary: excel fomulas are not executed after cell is modified
Product: POI Reporter: Pramod Bagauly <utpramod>
Component: XSSFAssignee: POI Developers List <dev>
Severity: critical    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   

Description Pramod Bagauly 2012-04-27 13:17:46 UTC
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,
Comment 1 Nick Burch 2012-04-27 13:26:43 UTC
You need to trigger the formula evaluation yourself when you're done making changes, see http://poi.apache.org/spreadsheet/eval.html