3 Replies Latest reply on Jan 27, 2012 1:33 PM by Sorbsbuster

    Bug in conditional formatting?



      Bug in conditional formatting?


      I have a conditional format:

         PatternCount ( Field1; "¶") > 1   /* Then change font color on warning message */

      When I have 1 carriage return in Field1, the font changes when it should not. To verify there is only one carriage return, I wrote a one line script with a custom dialog whose message panel contains:

        PatternCount ( Field1; "¶")

      and when executed, returns 1 (one). 

      Why is the conditional format logic returning true if there is only one carriage return in the field?

      FWIW, the second condition (there are 2) is 

          PatternCount ( Field1; "¶") = 0  /* Change warning message to another color */