To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82611 Issue #|82611 Summary|Formula cells cannot refresh solo Component|Spreadsheet Version|OOo 2.3.0 RC1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|duneflower
------- Additional comments from [EMAIL PROTECTED] Mon Oct 15 05:44:37 +0000 2007 ------- Formula cells can't refresh without recalculating the entire sheet or changing the formula. Suggest either having the cell recalc when formula opened for editing, or adding a "recalc this cell" command. Steps to reproduce the problem: 1. Turn AutoRecalc off. 2. Create a couple of RANDs or RANDBETWEENs. Also demonstrated by multiple formulae referencing the same data when one of the data is changed. 3. Try to refresh the cell by clicking in formula bar and <enter>ing out. Nothing happens. Recommend either implementing the above functionality, or (what I'd do if it were me) adding a "recalc this cell" command. --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]