https://issues.apache.org/bugzilla/show_bug.cgi?id=46643
Josh Micich <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Inserted rows and cells do |Formula parser should encode |not notify already existing |explicit range operator with |cells of events |tMemFunc --- Comment #6 from Josh Micich <[email protected]> 2009-02-02 14:54:42 PST --- There is definitely something funky going on in attachment (id=23211) . When you open it in Excel it has the behaviour you describe (updating cells within the range does not cause the formula to be automatically updated). Another observation is that re-entering the formula (F2, <enter>) in Excel fixes the problem. This is almost always a sign that POI has incorrectly encoded the formula tokens. BiffViewer shows the formula from the attachment (id=23211) as: Ptg[0]=org.apache.poi.hssf.record.formula.Ref3DPtg [sheetIx=0 ! D2]R Ptg[1]=org.apache.poi.hssf.record.formula.Ref3DPtg [sheetIx=0 ! D24]R Ptg[2]=class org.apache.poi.hssf.record.formula.RangePtg. Ptg[3]=org.apache.poi.hssf.record.formula.FuncVarPtg [SUM nArgs=1]V After re-enterring the formula and saving with Excel this becomes: Ptg[0]=org.apache.poi.hssf.record.formula.MemFuncPtg [len=15]R Ptg[1]=org.apache.poi.hssf.record.formula.Ref3DPtg [sheetIx=0 ! D2]R Ptg[2]=org.apache.poi.hssf.record.formula.Ref3DPtg [sheetIx=0 ! D6]R Ptg[3]=class org.apache.poi.hssf.record.formula.RangePtg. Ptg[4]=org.apache.poi.hssf.record.formula.AttrPtg [sum ]. I have done a quick test and found that the critical difference is the presence of the token tMemFunc. If POI is modified to encode this token, Excel opens the file OK and the symptoms are gone. I have changed the summary to reflect this. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
