https://bugs.freedesktop.org/show_bug.cgi?id=54940
Markus Mohrhard <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution| |WONTFIX --- Comment #4 from Markus Mohrhard <[email protected]> 2012-09-15 15:52:17 UTC --- (In reply to comment #3) > Created attachment 67191 [details] > File test No this is not a bug. The formula is always calculated against the current cursor position. So if you open the Manage Conditional Format window when the cursor is in A3 you see both formulas with an A3 if you open it while it is in A1 you see it with A1. When you entered the formulas you actually told Calc that the formula is: ISTEXT(current cell) and not ISTEXT(always cell A1). The cseocnd one would be ISTEXT($A$1). As long as you're using conditional formats you have to understand that the relative part is always only relative to the cursor/currently evaluated cell. -- 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
