https://bugs.documentfoundation.org/show_bug.cgi?id=91312
Bug ID: 91312
Summary: Anomalies applying conditional formatting (follow-on
Bug 91229)
Product: LibreOffice
Version: 4.4.3.2 rc
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 115630
--> https://bugs.documentfoundation.org/attachment.cgi?id=115630&action=edit
snipped jpg
I verified the anomaly in LO 4.3.7.2, unchanged in 4.4.3.2 (see attached
"case2-0.jpg").
Case2-) Create a new sheet and enter the values and formulas (A1 =230, A2 =225,
A3 =A1-A2), copy A1/A3 to A5/A7 and to A9/A11 then copy col.A to col.B and to
col.C, creates a style and apply the conditional formatting
("Format-Conditional Formatting") on A3 (if = 5 "red backgrounded");
copy it to B3 C3 A7 B7 C7 A11 B11 C11 (select A3 - copy - select B3 and Ctrl+
C3 A7 B7 ... - paste special-formats);
go to "Conditional Formatting-Manage Conditional Formatting" and the window
shows only A3 A7 A11 B3 (see attached "case2-1.jpg").
Now, trying to change the condition of C3, a warning window will appear (see
attached "case2-2.jpg) that does not appear if you change the condition of B3
(these are only examples, you can prove this even with other cells); however
the result in B3 does not change anyway (as already observed at point 1a for
bug 91229).
>From this point (trying to change the condition of C3) my test takes different
ways (warning: for every testing way you must restart from a new base sheet):
w1 --- replying NO from the warning window, the "Condition" window is
nevertheless displayed and you can see that the cell really has no conditional
formatting (see too w4 following); now, if you apply one, that is acquired but
the displayed outcome is unchanged (as already observed at point 1a for bug
91229).
w2 --- replying YES from the warning window, the "Condition" window is
displayed and you can see that the cell seems having the condition applied;
now, if you change that one, the new condition is acquired and the displayed
outcome appears correct, but looking at "Manage Conditional Formatting" window
the cell C3 is not displayed.
w3 --- trying the same as above on cell B11 (instead of C3) other strangeness
happen (but, at this point, I think unusefull going any further ....).
w4 --- in reality, cells B7 B11 C3-7-11 have not been conditioned: you get the
proof saving/reopening the file; that cells get no more "red backgrounded" and
have no conditional formatting, while B3 displays correctly conditioned and you
can change successfully its conditional formatting (as already observed at
point 1a for bug 91229).
--
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
