Created attachment 114317 [details] ods file created in Win7 Home The bug is experienced when a new spreadsheet is created under Windows 7 home edition. The vertical search retrieves the text to find even if it is embedded in any cell of the range to search. So the cell containing "edcba" is returned when you search the string "dc". The bug is very hard to deal with and returns false results if you don't have unique values to search or string values that may occur within a longer string. If you open such a spreadsheet in Libre Office under Windows 7 Professional edition the bug is still present also in new sheets added. On the converse, when a new spreadsheet is created under Windows 7 Professional edition, the bug is not present and if you open that spreadsheet in Windows 7 Home edition the search behaviour appears correct even in the newly added sheets. Attached 2 spreadsheet with 2 sheets each.
Created attachment 114318 [details] Same spreadsheet created in Win7 Professional edition
Hi Renato, thanks for reporting. But I think not a bug, only a changed option. Menu/Tools/LibreOffice calc/Calculate - Search criteria = and <> must apply to the whole cells. Resolved as notabug, please if you are not agree reopen it.
Hi m.a.riosv, Thank you for the response. I wander why the option, that seems to be (or should be) local to the document, affects the behavior of all the new spreadsheets. I don't remember when or why I changed that option (eventually a long time ago). I think that the standard options that could change drastically the expected results should be set similarly to language settings, local to the document or global. I found it a little confusing that the change on the option panel is immediately operative even if you change it in a new document and don't save the document (new documents will be affected by the changed option but I didn't expect that). Anyway it is not a bug. I hope that you will find this comment somehow useful.
I'm just a project collaborator, not a developer. If you like, report a new bug, selecting in the importance 'enhancement'.