[Solved] Absolute adress acts like relative address

Discuss the spreadsheet application

[Solved] Absolute adress acts like relative address

Postby rltw » Sun Feb 24, 2008 8:58 pm

In cell H8 I have: $H$9+$G$8

When I insert a row below row 8, H8 becomes $H$10+$G$8

I thought the whole idea of absolute addresses was to prevent this. What am I missing?

OO 2.3.1, W2K sp4
Last edited by rltw on Mon Feb 25, 2008 2:50 am, edited 1 time in total.
rltw
 
Posts: 4
Joined: Thu Jan 17, 2008 10:07 pm

Re: Absolute adress acts like relative address

Postby Villeroy » Sun Feb 24, 2008 9:11 pm

Nope, it's designed to keep track of data on insert/removal.
$H$9+$G$8 can be replaced with
=OFFSET($A$1;8;7)+OFFSET($A$1;7;6)
or
=INDEX($G$1:$H$65536;9;2)+INDEX($G$1:$H$65536;8;1)
Last edited by Villeroy on Tue Mar 18, 2008 11:20 am, edited 1 time in total.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26142
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Absolute adress acts like relative address

Postby rltw » Mon Feb 25, 2008 2:45 am

Thanks, that worked like a charm. Although I notice that inserting a cell ahead of A1 (shift cells right) can throw it off, as if it sees the displaced cell as A1 even though it shows as A2.
rltw
 
Posts: 4
Joined: Thu Jan 17, 2008 10:07 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 21 guests