Bug 53155 - excel fomulas are not executed after cell is modified
Summary: excel fomulas are not executed after cell is modified
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: unspecified
Hardware: PC Windows XP
: P2 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-04-27 13:17 UTC by Pramod Bagauly
Modified: 2012-04-27 13:26 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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,
Pramod
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