Issue 27495

Summary:	feature to resolve formulas until they only refer to cells that contain values
Product:	Calc	Reporter:	norbert2 <norbert.notz>
Component:	code	Assignee:	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.

Frank

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