https://bugs.freedesktop.org/show_bug.cgi?id=54940
Markus Mohrhard <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution| |WONTFIX CC| |markus.mohrhard@googlemail. | |com --- Comment #1 from Markus Mohrhard <[email protected]> 2012-09-14 22:55:53 UTC --- As I tried to explain, this is a feature and not a bug. Using relative references in conditional formats is one of the trickiest features we have. The formula is not ISTEXT(A1). The formula is actually more something like ISTEXT(current cell) or ISTEXT(cell one to the left) so showing ISTEXT(A1) would be totally wrong. Using relative references in conditional formats requires to abstract a bit and understand that a relative reference is not a reference to a specific cell, instead it only says something about how to find the cell based from the current cell. This does not only happen in the manage conditions dialog you'll also see the same in the normal cond format dialog because the formula is not an absolute formula, the formula is always a formula relative to the currently selected cell in the dialog and when evaluated it is against the current cell but always based on the original base cell. See the difference if you select A1:A4 and define a range ISTEXT(B5) when the currently selected cell is A1 or A4. You'll notice that this results in two different formulas but they will both show the formula string. -- 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
