Apache OpenOffice (AOO) Bugzilla – Issue 27495
feature to resolve formulas until they only refer to cells that contain values
Last modified: 2013-02-07 22:42:19 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!
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
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
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".