Ask Your Question

Why is the "EXACT" Function NOT WORKING with this FILE in CALC

asked 2020-10-02 18:03:07 +0100

RJBowman gravatar image

This is a specific problem with a spreadsheet. I have cut the spreadsheet down to just a portion of the entries effected and you can download it here:

The problem is that the "EXACT" function isn't working properly. It always returns a "FALSE" result, even when comparing two cells with the exact same contents.

I'm using LebreOffice, but it doesn't matter. The problem appeared when I was using an earlier version. I thought that an update might fix it, but it didn't. I checked the file on a different computer and the bug was still there. The same file even produces the same results on OpenOffice Calc, so the problem is likely to be present on just about any version of LibreOffice or OpenOffice.

If I save the sheet in CSV format then reload, the problem is fixed in the new CSV file, but then if I copy the sheet from the CSV file and past it into a new sheet in the ODS file, the problem comes back.

I think that it has something to do with the formatting of the sheet, but I've tried everything I could think of and, no dice.

Please advise.

edit retag flag offensive close merge delete


This seems to be a problem of drag down / copy. If you enter the formula individually in each cell, the result will be correct (and if clicking fx - the functions assistant - it is shown correctly)

Opaque gravatar imageOpaque ( 2020-10-02 18:35:03 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2020-10-02 18:43:49 +0100

Opaque gravatar image

updated 2020-10-02 18:46:23 +0100


your sheet doesn't have Data -> Calculate -> [x] AutoCalculate hence you need to CRTL+SHIFT+F9 to get the formulas recalulated after dragging down or copying the formulas.

Hope that helps.

edit flag offensive delete link more


In the meantime I found your bug report #tdf137211 which has been RESOLVED as NOTABUG with the same explanation.

Opaque gravatar imageOpaque ( 2020-10-02 19:08:38 +0100 )edit

answered 2020-10-02 18:16:23 +0100

m.a.riosv gravatar image

Because it's comparing numbers and EXACT it's for text. Forcing the numbers to text works fine for me.

In A13 =EXACT(B13&"";B14&"")

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-10-02 18:03:07 +0100

Seen: 48 times

Last updated: Oct 02