Issue 82611 - Formula cells cannot refresh solo
Summary: Formula cells cannot refresh solo
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.3.0 RC1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-10-15 06:44 UTC by duneflower
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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.