Issue 8325

Summary:	update copied formulas functionality
Product:	Calc	Reporter:	lars <lars_o_hansen>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	ACCEPTED ---	QA Contact:
Severity:	Trivial
Priority:	P4	CC:	issues
Version:	OOo 1.0.0	Keywords:	rfe_eval_ok
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	FEATURE	Latest Confirmation in:	---
Developer Difficulty:	---

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