Description: (See attachment) When comparing cells content (text), the formula works on first cells but does not work on all cells. Actual Results: same formula does not give the same result : Expected Results: Same behavior Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 150739 [details] Libre Office Calc file with the bug The file attached is a French version of Libre Office Calc The problem is the formula in col B, we should not have an "X" as a result in this column when col A and col C are equal. The code (unicode) of each character in the strings are the same, the content seems exactly the same.
if you enable Menu "View/Value Hightlighting", you will see that cells A7:A9 and A11 contain numbers, not text. could you please retest? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
to be more precise: you have to convert numbers to text before comparison, or to adjust the formula's, e.g: =IF(AND(A7<>"";A7<>VALUE(C7));"X";"") or =IF(AND(A8<>"";TEXT(A8;"@")<>C8);"X";"")