https://bugs.freedesktop.org/show_bug.cgi?id=54940
mariosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WONTFIX | Ever Confirmed|0 |1 --- Comment #2 from mariosv <[email protected]> 2012-09-15 00:13:05 UTC --- Attached the file source of previous screenshot. I it works as you said, then when I change to a blank cell, i.e. D5, the condition for A1 should be change from ISTEXT(A1) to ISTEXT(D5) and how D5 is blank, the condition is false, then A1 should be without format, but A1 remains with the condition true because there is a text in A1. So no care where I go, CF for A1 is calculate by their formula ISTEXT(A1), the condition is true, the select style is Green. I think I understand how the relative cells works, but in CF relative is different from absolute only when they are used to define the CF for a range. And only while evaluating a range, the CF formula should be evaluated like the arrays in the cells. And I think is how do it. After select A6:B8 enter in the CF ISTEXT(A6), then evaluation should be: A6 with ISTEXT(A6), B6 with ISTEXT(B6) A7 with ISTEXT(A7), B7 with ISTEXT(B7) A8 with ISTEXT(A8), B8 with ISTEXT(B8) After select A6:B8 enter in the CF ISTEXT($A6), then evaluation should be: A6 with ISTEXT($A6), B6 with ISTEXT($A6) A7 with ISTEXT($A7), B7 with ISTEXT($A7) A8 with ISTEXT($A8), B8 with ISTEXT($A8) After select A6:B8 I enter the CF ISTEXT(A$6), then evaluation must be: A6 with ISTEXT(A$6), B6 with ISTEXT(B$6) A7 with ISTEXT(A$6), B7 with ISTEXT(B$6) A8 with ISTEXT(A$6), B8 with ISTEXT(B$6) I need to insist, to me the calculations are doing properly, when you go trough Menu/Format/CondFormatting/CondFormatting/ you can see right the formula for the actual cell, differen if you go trough Menu/Format/CondFormatting/Manage/ -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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
