Bug 111004 - Different results in the MATCH function with exact same formula
Summary: Different results in the MATCH function with exact same formula
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-08-01 20:45 UTC by Nartagnan
Modified: 2017-08-01 21:07 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
bug active in this file (9.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-08-01 20:46 UTC, Nartagnan 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Nartagnan 2017-08-01 20:45:07 UTC 
Description:
=EQUIV(A4;A2:A25;0)
must display a number, but it display "TRUE" in on cell.
If I copy the cell, the "True" remain.
If I copy another cell with the right result, the bug disappear.

I don't know how to reproduce the initial bug, but I can provide a file where it is active.

(EQUIV = MATCH in french)

Actual Results:  
TRUE

Expected Results:
a number


Reproducible: Didn't try

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:54.0) Gecko/20100101 Firefox/54.0
Comment 1 Nartagnan 2017-08-01 20:46:27 UTC 
Created attachment 135056 [details]
bug active in this file
Comment 2 Julien Nabet 2017-08-01 21:02:33 UTC 
For I2, J2, and perhaps all the line the format number shows "boolean value"
I3 shows "number"
Comment 3 Nartagnan 2017-08-01 21:07:41 UTC 
Aw, I didn't saw that.
Thanks, and sorry for that.