Apache OpenOffice (AOO) Bugzilla – Issue 8325
update copied formulas functionality
Last modified: 2013-08-07 15:12:27 UTC
so if I copy formulas from one cell to others and I update the formula in the original cell, the copied functions are updated. This requires a list of copied functions or copied functions are saved as references in the first place, and the app. (Calc) only adjusts the Cell X:Y appropriately or this is done "dynamically" (because Calc is so designed that the original formula says "cell to the left" immediately (when user enters =D6 in E6) so when referring from D8 to D6, there is no extra adjustment needed) or perhaps the functionality ==Z:A so the user manually says, shall be the same as in Z:A but just with approprioately updated cell refs. and these formulas shall be "auto-updated". this doesn't require much memory (hardly any) on small spreadsheets.
*** Issue 8324 has been marked as a duplicate of this issue. ***
what do I mean by "saved as references" in D6 is a value in E6 I write =D6 in E8 I copy the function from E6 but because it is stored as refrence when copying, it says =E6ref in E8, but because I am in E8 and it is a reference, all other cells are adjusted on execution by calc, so =E6ref does do =D6[(D6/E6=x/E8)<=>x=... and replace D6 by x]. This adjustment would have not to be done, if calc saves in E6: =cell to the left. Then when E8 says =E6 and E6 contains a formula (or rather than that approach which looks at the content use the apporach that you do that because it was copied from E6) it sees cell to the left; and because you are in E8 it becomes D8. Or you only do that if the user explicitly stated that he wants this type of auto-updating by using copy with auto-update (so you then also use the above approach (perhaps) only that it is not implemented in the standard copy function).
what does D6/E6=x/E8 mean? that is Target Cell in Referenced Cell to Referencd Cell is like to-be-Target Cell in Current Cell to Current Cell
Hi Bettina, one4you
considered for Office later.
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".