https://bugs.documentfoundation.org/show_bug.cgi?id=137211
Bug ID: 137211
Summary: My "EXACT" function isn't working properly, but only
with one specific spreadsheet.
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: b...@wonderworldcomics.com
Description:
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:
http://wonderworldcomics.com/ProblemEXACTFunction.ods
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 7.0.1.2, 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.
Steps to Reproduce:
1. Load file that I've linked to
2. Look at what the functions in column 1 are doing
Actual Results:
Always false, even when it should be true. Only with this one spreadsheet.
Expected Results:
Should have resulted in true when cells compared matched.
Reproducible: Always
User Profile Reset: No
Additional Info:
The bug seems to exist in all LibreOffice software versions, and even in
OpenOffice.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
