Issue 82611

Summary: Formula cells cannot refresh solo
Product: Calc Reporter: duneflower <shadowcat>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.3.0 RC1   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description duneflower 2007-10-15 06:44:37 UTC
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.
Comment 1 frank 2007-12-12 14:58:30 UTC
Not a defect but possibly an enhancement request. Re-assigned to requirements
for further evaluation and decision finding.