Issue 27495 - feature to resolve formulas until they only refer to cells that contain values
Summary: feature to resolve formulas until they only refer to cells that contain values
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-04-06 11:03 UTC by norbert2
Modified: 2013-02-07 22:42 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description norbert2 2004-04-06 11:03:38 UTC
Often when making more complex spreadsheets, it is useful to calculate 
intermediary results (german: Zwischenergebnisse).
These results then are used for calculating final results in other cells.

If one found out that the final result is OK, such cells containing 
intermediary results are not needed anymore. But the cells that calculate the 
final results still refer to these intermediate results.

I think a function that, if performed on cells including formulas, resolves 
them until they only refer to cells that contain values (and no formulas), 
would be useful.

Here a simple example:

A1 contains "5" (value)
B1 contains "=A1/2" (intermediate result)
C1 contains "=B1+4" (final result)

The feature I mean performed on C1 should change C1 to "=A1/2+4".

What do you mean? I think this would be a useful feature!
Comment 1 frank 2004-04-06 12:13:53 UTC
Hi Norbert,

this would be great but I think this is not possible in a suitable timeframe /
amount of work. Nevertheless I re-assign it to Bettina for further investigation.

Comment 2 norbert2 2005-03-13 18:09:01 UTC
I think this feature should NOT be very difficult to implement:

The only thing that has to be done is to

- lookup the content of referenced cells
- and replace the references with the content surrounded by a pair of brackets
Comment 3 bettina.haberer 2010-05-21 15:05:39 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".