https://bugs.documentfoundation.org/show_bug.cgi?id=91868
Bug ID: 91868
Summary: Conditional format error after calc file is saved 2x
(only in xls file-format)
Product: LibreOffice
Version: 4.3.7.1 rc
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 116294
--> https://bugs.documentfoundation.org/attachment.cgi?id=116294&action=edit
easy way to reproduce the bug
In a Calc in xls file format, the condition of the conditional formatting of a
cell is changed after the file is saved and opened again.
How to reproduce :
Open a new calc
enter "aa" in cell A1
enter "aa" in cell B1
define a conditional format of cell B1 : if cell content is equal to cell A1,
get a style (green color in my case).
Save and open again. If you now look at the definition of the conditional
format, A1 is changed to sheet1.A1, which is still correct.
Save and open once again; now the error appears. If you now look at the
definition of the conditional format, sheet1.A1 is changed to $#REF!.A1,
resulting in a all ways FALSE condition.
This problem only appears with xls files, not with xlsx files neither with ods
files.
--
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
