When defining names, what is the difference between $c$26 and c26
Or, is there a difference.
First time here? Check out the FAQ!
You are right - but I won't never ever use relative addressing when it comes to define a named range - just make a copy of a formula containing a named range using relative addressing and watch CTRL+F3
(Sheet -> Named Ranges and Expressions -> Manage ...
. (The references are broken and showing #REF!
, when in any cell not using the range, and the range has different meaning in different cells having a formula containing the range). Just don't do that, if you want to understand what's going on in your sheet at some later time.
I won't never ever use relative addressing
That of course depends on what you want to achieve. If you want to address cells always relative to the position where you use the name in a formula expression it's of course the very right thing to do. Also, using a named expression that when deleting a referenced cell (range) does not produce a #REF! error but instead just shifts things according to the new position may be exactly a feature to use. Yes, one needs to fully understand how things work..
@erAck - please note what I wrote "showing #REF!, when in any cell not using the range (move to any cell not in the named range and not containing a formula using the named range) and this is true at least for my LO 6.3.2.2 because I checked before I posted. And in addition it's not an advice but a statement what I won't do.
Using relative references in a Named Expression, makes crucial, where you are when the expression it's defined because The relative references changes in relation with the cell when they are copied.
Test this:
Go to A1, define a named expression RelativeA1F1 Sheet1.F1
Go to B1, define a named expression RelativeB1F1 Sheet1.F1
So both have the same relative formula.
Go to E1, introduce 'Ref E1'
Go to F1, introduce 'Ref F1'
Go to G1, introduce 'Ref G1'
Goto to A1, introduce =RelativeA1F1, result = Ref F1
Goto to A1, introduce =RelativeB1F1, result = Ref E1
Both named expressions have the same relative formula, but as can be seen, they are relative to the cell active when they are created.
They have another advantaje, deleting a column/row referenced by a named expression doesn't broke them, while direct references in a formula gets an #REF! error.
Asked: 2019-10-14 20:30:54 +0100
Seen: 413 times
Last updated: Oct 15 '19
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]