https://bugs.documentfoundation.org/show_bug.cgi?id=155697
Bug ID: 155697
Summary: String comparison fails depending on formatting
Product: LibreOffice
Version: 7.5.3.2 release
Hardware: x86-64 (AMD64)
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 187742
--> https://bugs.documentfoundation.org/attachment.cgi?id=187742&action=edit
Reproduction
String comparisons of the form `=IF(A1="✔","=","<>")` can fail depending on the
formatting of A1
I don't know how I made this happen, I noticed it in a fairly complicated file,
was not able to reproduce it in a new file by applying the same formatting, but
was able to reproduce it by pasting only Values & Formats from an affected cell
in the large sheet
In the attached reproduction, A1 and A3 have the value and formatting created
in the new file, and A2 and A4 have the value and formatting created in the
original file. They appear identical, and have identical content in the input
line, but as you can see in column B they do not compare the same. None of
them appear the same as in the original sheet, where the applied font color
appears (in the reproduction the default font color appears)
macOS 13.4 (22F66)
--
You are receiving this mail because:
You are the assignee for the bug.
