Ask Your Question
1

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

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

keepitsimpleengineer gravatar image

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

Alex Kemp gravatar image

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

i.e.

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

has become

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

and

=IF(ISBLANK($A$4),"",LOWER(ROMAN(IF(ISBLANK($A$4),0,$A$4),4)))

has become

=IF(ISBLANK($A4),"",LOWER(ROMAN(IF(ISBLANK($A4),0,$A4),4)))

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

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

Comments

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

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

2 Answers

Sort by » oldest newest most voted
0

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

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
0

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

m.a.riosv gravatar image

Try resetting the user profile. Sometimes solve strange issues.
https://wiki.documentfoundation.org/UserProfile

edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 104 times

Last updated: Feb 13 '13