https://bugs.freedesktop.org/show_bug.cgi?id=60756
Priority: medium
Bug ID: 60756
Assignee: [email protected]
Summary: A calc sheet created before 3.6.5.2 has had all
relative cell references converted to absolute.
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.6.5.2 release
Component: Spreadsheet
Product: LibreOffice
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
