To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102602 Issue #|102602 Summary|SUM does not update if number changed Component|Spreadsheet Version|OOo 3.1 Platform|All URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|editing Assigned to|spreadsheet Reported by|jensriis
------- Additional comments from jensr...@openoffice.org Mon Jun 8 20:36:05 +0000 2009 ------- The Sum of a range e.g. SUM(A2:A5) include a number e.g. 100 which is then changed to a formula e.g. =100-20 then the Sum does not update i.e. in this example reduce the sum with 20, but remains unchanged. Similarly if the number 100 is changed to 80 the Sum does not update. As it is one of the most common uses the bug is very serious. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org