https://bugs.documentfoundation.org/show_bug.cgi?id=165000
--- Comment #3 from [email protected] --- I appreciate the quick reply. I am looking at the spreadsheet right now, there is no space trailing the word "boat" in cell F5, so I think you are not correct. I made this example spreadsheet as a test to mimic an error I just started getting in a spreadsheet that I have been using for a couple of years without problems, but since updating my machine with the latest linux mint and hence the version of Libre Office that comes with it, I now have this issue. I'm not sure how you are seeing a trailing space in cell F5. I have just cleared the cell multiple times with no trailing space and still get the issue as described. Match should search for an EXACT match with the "0" in the third term of the function, or return #NA if it cannot find an exact match. At least that is how I've had the match function work for me over the last 3 decades as an engineer using spreadsheets, including Libre Office Calc. Maybe I'm missing something? Is there a setting somewhere in the Office options that needs changing? Thanks for any assistance. -- You are receiving this mail because: You are the assignee for the bug.
