https://bugs.documentfoundation.org/show_bug.cgi?id=91070
gmarco <gmmell...@inwind.it> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
Assignee|libreoffice-b...@lists.free |gmmell...@inwind.it
|desktop.org |
Ever confirmed|1 |0
--- Comment #12 from gmarco <gmmell...@inwind.it> ---
Created attachment 115432
--> https://bugs.documentfoundation.org/attachment.cgi?id=115432&action=edit
new test 2b (see comments)
Hi Julien and Raal
I'll try to update 442 asap but actually look at this.
Let we try to fly over the initial case that occurs on a spreadsheet migrated
from MS Excel, it still is so, it is difficult to reproduce, but I cannot find
a way to correct it.
Trying and trying again i believe I have identified some states of apparent
anomaly, easily reproducible (I can reproduce them at infinity), on which you
should be able to investigate.
Explaining fully in english (which is not my native language) is for me a
little complicated but I'll try to.
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), do the same thing
with B3;
now you can try and try to change the conditions in B3 and A3 and the result
will be always correct.
1a) creates a new sheet as above, applies the conditional formatting on A3 and
then copy it on 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 be always remain until you change the
condition of A3 (it is sufficient to open the window of "Conditional
Formatting" and, even without changing anything, clicking OK).
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 A9/A11 then copy col.A into col.B and col.C,
creates a style and apply the conditional formatting ("Format-Conditional
Formatting") on A3 (if = 5) and copy it ("Copy - Paste special-formats") on B3
D3 A7 B7 D7 A11 B11 D11;
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) 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 (as already seen at point 1a).
I show that in help "https://help.libreoffice.org/Calc/Conditional_Formatting";
there is an incomprehensible statement "Conditional Formatting - Choose
Conditional Formatting to define format styles depending on certain conditions.
If a style was already assigned to a cell, it remains unchanged. .... ":
I can't understand what it means, it would seem a false statement (see my test
point 1) but it could hide some limitation mal implied that would otherwise
better clarified.
I hope that you will be able to reproduce the above and find the explanation,
it could be the cause of other faults: if it is a bug it should be fixed, if it
is intentional it should be highlighted more thoroughly and completely.
Let me ask you also a curiosity: I frequently used in MS Excel the conditional
formatting, there it is much less cumbersome and I never had any problems, is
there a reason?
Finally, at the margin, I show an error translation in the help (both internet
and online):
https://help.libreoffice.org/calc/applying_conditional_formatting"; Step 5: Copy
Cell Style "To apply the conditional formatting to other cells later:
1.Click one of the cells that has been assigned conditional formatting.
...... "
was incorrectly translated
"1.Fate clic su una delle celle a cui deve essere applicata la formattazione
condizionata."
the correct translation is
"1.Fate clic su una delle celle a cui รจ stata applicata la formattazione
condizionata."
--
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
