A calc sheet created before has had all relative cell references converted to absolute

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 https://bugs.freedesktop.org/show_bug.cgi?id=60756

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

Try resetting the user profile. Sometimes solve strange issues.

Hi @keepitsimpleengineer,

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