Issue 27495

Summary: feature to resolve formulas until they only refer to cells that contain values
Product: Calc Reporter: norbert2 <norbert.notz>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 1.1.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

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".