https://bugs.documentfoundation.org/show_bug.cgi?id=91229
Bug ID: 91229
Summary: Anomalies applying conditional formatting (LO Calc
4.4.3.2).
Product: LibreOffice
Version: 4.4.3.2 rc
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: gmmell...@inwind.it
Created attachment 115504
--> https://bugs.documentfoundation.org/attachment.cgi?id=115504&action=edit
screen case 1a
I have identified some states of apparent anomaly, easily reproducible (I can
do it at infinity), on which you should be able to investigate.
-1-) Create a new sheet and enter the values and formulas (A1 =230, A2 =225, A3
=A1-A2), copy col.A into col.B, creates a style and apply the conditional
formatting ("Format-Conditional Formatting") on A3 (if = 5 "red backgrounded"),
do the same thing with B3;
now you can try and try to change the conditions in B3 and A3 and the result
will get always correct.
-1a-) creates a new sheet as above, applies the conditional formatting on A3
and then copy it to B3 using "Copy - Paste special-formats" as exemplified in
the help '"https://help.libreoffice.org/Calc/Applying_Conditional_Formatting";
Step 5: Copy Cell Style';
now try to change the condition in B3 (if = 0), you will notice that the result
is not changed (see attached "case1a.jpg") and, continuing to change the
condition of B3, the result will always remain wrong until you change the
condition of A3 (it is sufficient to open the window of "Conditional
Formatting" and, even without changing anything, clicking OK).
I further notice that, saving the file (as xls or ods) in the wrong state and
reopening it, the cell B3 too displays now correctly and its conditional
formatting can be changed without problems.
-2-) 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 "case2a.jpg").
Now, trying to change the condition of C3, a warning window will appear (see
attached "case2b.jpg"; note: image displays LO 4.3.7.2 but the same gets in LO
4.4.3.2) 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).
>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; now, if you apply one, that is acquired but the displayed outcome
is unchanged (as already observed at point 1a).
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).
In conclusion I think something has to be revised about this area.
I don't think all this happens to me only, for that I'll be gratefull if
someone other could reproduce and confirm.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
