Issue 8325 - update copied formulas functionality
Summary: update copied formulas functionality
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: rfe_eval_ok
: 8324 (view as issue list)
Depends on:
Reported: 2002-10-14 16:00 UTC by lars
Modified: 2013-08-07 15:12 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 lars 2002-10-14 16:00:11 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.
Comment 1 lars 2002-10-14 16:08:58 UTC
*** Issue 8324 has been marked as a duplicate of this issue. ***
Comment 2 lars 2002-11-08 14:21:05 UTC
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).  
Comment 3 lars 2002-11-08 14:31:34 UTC
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
Comment 4 oc 2003-09-17 09:41:56 UTC
Hi Bettina, one4you
Comment 5 bettina.haberer 2004-01-21 16:46:33 UTC
considered for Office later.
Comment 6 bettina.haberer 2010-05-21 15:07:16 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".