Bug 124727

Summary:	Comparison between cell' content does not work consistently
Product:	LibreOffice	Reporter:	Bruno <burelbruno>
Component:	LibreOffice	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	oliver.brinzing, xiscofauli
Priority:	medium
Version:	6.2.2.2 release
Hardware:	x86-64 (AMD64)
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Libre Office Calc file with the bug

Description Bruno 2019-04-14 07:39:28 UTC

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:

Comment 1 Bruno 2019-04-14 07:45:45 UTC

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.

Comment 2 Oliver Brinzing 2019-04-14 09:06:46 UTC

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

Comment 3 Oliver Brinzing 2019-04-14 15:48:32 UTC

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";"")