Bug 98019 (TrueButFalse) - The condition in a IF function is met, but its showing FALSE
Summary: The condition in a IF function is met, but its showing FALSE
Status: RESOLVED NOTABUG
Alias: TrueButFalse
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.0.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-02-20 10:19 UTC by Lorenz25
Modified: 2016-02-20 10:45 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
See explanation in the file. (14.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-02-20 10:19 UTC, Lorenz25
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Lorenz25 2016-02-20 10:19:00 UTC
Created attachment 122815 [details]
See explanation in the file.

I have this formula: 
=IF(EXACT($A2,$B$1), STYLE("Match"), STYLE("Default"))
The result is shown as FALSE/0 with the style "Match" applied, when the condition is met, and as FALSE/0 with the style "Default" applied, when not met.