Ask Your Question

A calc sheet created before has had all relative cell references converted to absolute. [closed]

asked 2013-02-12 23:47:09 +0200

keepitsimpleengineer gravatar image

updated 2015-10-21 16:45:57 +0200

Alex Kemp gravatar image

A well used calc spread sheet after opened in Version for the 1st time has had all relative references converted from relative to absolute.


=IF('Basic Track Data'!$A5=0,"",'Basic Track Data'!$F6)

has become

=IF('Basic Track Data'!$A$5=0,"",'Basic Track Data'!$F$6)



has become


This can create problems since the calc will produce the same results until a formula with relative references is edited i.e. by adding rows or columns, etc.

I suspect this is a bug but Bugzilla is down.

Update: Bug filed

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-21 16:46:12.204972


@mariosv Thanks, but using a new profile in this case did not change the result.

keepitsimpleengineer gravatar imagekeepitsimpleengineer ( 2013-02-13 00:24:23 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-02-13 00:28:55 +0200

qubit gravatar image

Hi @keepitsimpleengineer,

Thanks for filing fdo#60756. Sorry to hear that Bugzilla was down for a while.

edit flag offensive delete link more

answered 2013-02-12 23:54:24 +0200

m.a.riosv gravatar image

Try resetting the user profile. Sometimes solve strange issues.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-02-12 23:47:09 +0200

Seen: 105 times

Last updated: Feb 13 '13