https://bugs.documentfoundation.org/show_bug.cgi?id=165000
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED CC| |[email protected] --- Comment #2 from Regina Henschel <[email protected]> --- The cell F5 does not contain "boat" but "boat ", with a blank. So an exact match comparing entire cell content will not success and match returns #N/A. A exact match with comparing part of the cells will match the first from top to bottom and that is in cell C5. Match evaluates the setting in Tools > Options > Calc > Calculate. That has not changed compared to previous versions. Perhaps you have written "boat " (with blank) in cell F5 in previous versions? -- You are receiving this mail because: You are the assignee for the bug.
