[Solved] Control F "Find" feature not working

Discuss the spreadsheet application

[Solved] Control F "Find" feature not working

Postby ausbane » Sat Feb 08, 2020 12:06 am

When using the Find or Find and Replace feature, the program will only locate the item if the search matches exactly what is in the cell. It will not return any results for a partial entry of the cell data. In other words, if the field shows "big red truck", and the search is for "truck", it will return "Search key not found".
Last edited by robleyd on Sat Feb 08, 2020 2:33 am, edited 1 time in total.
Reason: Tagged [Solved]
OpenOffice 4.1.7 on Windows 10
ausbane
 
Posts: 4
Joined: Sat Feb 08, 2020 12:01 am

Re: Control F "Find" feature not working

Postby robleyd » Sat Feb 08, 2020 12:45 am

Do you perhaps have Entire Cells checked on the search form? If so, uncheck it and try again.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3461
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Control F "Find" feature not working

Postby ausbane » Sat Feb 08, 2020 2:09 am

Wow. How blind. Thanks.
OpenOffice 4.1.7 on Windows 10
ausbane
 
Posts: 4
Joined: Sat Feb 08, 2020 12:01 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests