Issue 10305 - Define cells in formula that wont be addapted copying
Summary: Define cells in formula that wont be addapted copying
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 643C
Hardware: All Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
Depends on:
Reported: 2002-12-26 07:03 UTC by Unknown
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-12-26 07:03:38 UTC
It would be great if I could tell OO, that there are cells that should not be
addapted in the formula when copying the cell containig the formula to a new
location. I think you could introduce a function in the formula editor to define
a link to a cell as static (something like fixcell(A1) or so). The cells in this
function would not get addapted to the new location when copying a cell
containing a fourmula with this expression to a new location.
Comment 1 lars 2002-12-26 07:25:57 UTC
this sounds like absolute references:

place a $ sign before each cell refernce you don't want to be updated:

=$A$1 in C5 and copy C5 to E3 => E3 has =$A$3 too.

you can also have only 1 $, so the other is a dynamic refernce.
There is also a toolbar option which you can find in the paste or 
insert category of the edit toolbar dialogue.
Comment 2 Unknown 2002-12-26 09:57:08 UTC
Sorry, couldn't find that. But this shows that this function isn't 
really intuitive. Wouldn't it be easier to find, if one could change 
these references when entering the formula? Maybe with a popup menu 
when right-clicking on the selected cells while editing the formula 
or so.
Comment 3 lars 2002-12-26 10:08:28 UTC
you should place the $ in front of column or row indices in your 

cell A3: you enter a formula like (without quotation marks) "=SUM

if you place a $ in front of B and 1 and 10 and you copy the formula 
from its original cell to another cell, B,1 and 10 are not adjusted.
so "=SUM($B$1:$B$10)" remains this way.
Comment 4 daniel.rentz 2003-01-06 13:41:25 UTC
While editing a formula, you can alter the state of a reference:
Move the cursor into a cell reference and press SHIFT+F4 (repeatedly).
Comment 5 oc 2003-09-17 09:40:53 UTC
Hi Bettina, one4you
Comment 6 bettina.haberer 2004-01-21 17:46:13 UTC
That works like Daniel (dr) described.
Comment 7 bettina.haberer 2004-01-21 17:46:35 UTC