https://issues.apache.org/bugzilla/show_bug.cgi?id=46643
Robert Pate <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Robert Pate <[email protected]> 2009-01-31 08:53:42 PST --- After looking at this issue, I have discovered that it is the area range reference in the sum formula that seems to be missing the change value events on cells in between the range. The first and last cells of the range affect the formula as they should but anything in between does not affect the sum. Attached are example documents and below are better steps to reproduce. The following are better reproduction steps for this issue: 1. Load the attached template into POI. 2. Find the cell with the string 'sumofprice' and replace it with the formula SUM(A2:A3) 3. Begin inserting rows in between the rows with the 'firstrow' and 'lastrow' tags by shifting the 'lastrow' row and the 'sumofprice' row down by 1. 4. For each row inserted, place numeric values in the 'price' column. 5. After two or three rows, output the file to another file name. -- 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]
