AnsweredAssumed Answered

Bug in conditional formatting?

Question asked by dzittin on Jan 27, 2012
Latest reply on Jan 27, 2012 by Sorbsbuster

Title

Bug in conditional formatting?

Post

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 */

Outcomes