| View previous topic :: View next topic |
| Author |
Message |
superduper
General User
Joined: 06 Sep 2006
Posts: 6
|
 Posted: Wed Sep 06, 2006 5:13 am Post subject: find function..entire spreadsheet |
 |
|
hi, a newbird using Oo... so.. here it goes..
its regarding the "find" function, when i search 4 somethng, it only find downwards, if there is somethng i want is before the current cell, it will returned a "not found" message, and another "search frm the top?" message, then only i can find wat i'm looking 4..
which mean if i'm in cell 10, i can only find somethng bellow cell 10, if the thngy i want is at cell 1, i hav 2 go through the "not found" n "search frm the top" message only i can find it.. i got quite a no. of entry in the spreadsheet, its hard 2 remember all of them, wat it is or where it is...i feel tat its kinda troublesome if everytime i wanna search somethng i hav 2 go all ovr to the top of d sheet
is there anyway around this? or i just hav 2 blend in?
thanks!!  |
|
| Back to top |
|
 |
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Wed Sep 06, 2006 5:31 am Post subject: |
|
|
The function seems to work for me.
Click on the button "More Options".
Check that the options describe what you want.
One option is "Search in" - you can select Formulas, Values, Notes.
Another is search direction - rows, columns.
My search found "alpha" in A1 although the cell pointer was in E20 when I used the function.
_________________
search forum by month |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Wed Sep 06, 2006 9:38 am Post subject: Re: find function..entire spreadsheet |
|
|
| superduper wrote: |
is there anyway around this? or i just hav 2 blend in?
|
ifyouareinacellyoucanalreadyseewhatyouarelookingforthefindwillaskifyouwanttogobacktothebeginning
David. |
|
| Back to top |
|
|
superduper
General User
Joined: 06 Sep 2006
Posts: 6
|
| Posted: Thu Sep 07, 2006 4:35 am Post subject: |
|
|
| noranthon wrote: | The function seems to work for me.
Click on the button "More Options".
Check that the options describe what you want.
One option is "Search in" - you can select Formulas, Values, Notes.
Another is search direction - rows, columns.
My search found "alpha" in A1 although the cell pointer was in E20 when I used the function. |
i still can find wat i'm looking 4, the prob is everytime when i wanna find somethng tat is b4 d cell pointer, i hav 2 do double work by telling Oo 2 look through the beginning of d sheet instead of like MS office, it will straight away loop back 2 the beginning of d sheet n search again automatically w/o pressing addtion "OK" |
|
| Back to top |
|
|
superduper
General User
Joined: 06 Sep 2006
Posts: 6
|
| Posted: Thu Sep 07, 2006 4:38 am Post subject: Re: find function..entire spreadsheet |
|
|
| David wrote: | | superduper wrote: |
is there anyway around this? or i just hav 2 blend in?
|
ifyouareinacellyoucanalreadyseewhatyouarelookingforthefindwillaskifyouwanttogobacktothebeginning
David. |
just wanna know if there is a way around d asking thngy? its kinda like double work 2 me, u hav 2 press "ok" twice 2 get 2 wat u wan...just wanna know if this is d natural behaviour of the Oo Calc or its just tat i dunno how.. guess i hav 2 blend in? |
|
| Back to top |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Thu Sep 07, 2006 4:42 am Post subject: |
|
|
Is that it? I thought you meant the search was not covering the whole sheet.
It is an inconvenience, I suppose, to be asked whether you want the search to resume at the start of the document.
If you feel strongly enough, register with OpenOffice and file an issue requesting an enhancement along the lines you suggest.
_________________
search forum by month |
|
| Back to top |
|
|
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8979
Location: Lexinton, Kentucky, USA
|
| Posted: Thu Sep 07, 2006 5:30 am Post subject: |
|
|
| How about doing Ctrl+Home before you do a Find. |
|
| Back to top |
|
|
superduper
General User
Joined: 06 Sep 2006
Posts: 6
|
| Posted: Thu Sep 07, 2006 6:46 am Post subject: |
|
|
| noranthon wrote: | Is that it? I thought you meant the search was not covering the whole sheet.
It is an inconvenience, I suppose, to be asked whether you want the search to resume at the start of the document.
If you feel strongly enough, register with OpenOffice and file an issue requesting an enhancement along the lines you suggest. |
yeah, maybe i nv make thngs clear, my bad...  but no1 found tat this is a bit incovenient? only me felt it? hmm... |
|
| Back to top |
|
|
superduper
General User
Joined: 06 Sep 2006
Posts: 6
|
| Posted: Thu Sep 07, 2006 6:51 am Post subject: |
|
|
| JohnV wrote: | | How about doing Ctrl+Home before you do a Find. |
lets say u wanna search 4 a few items, everytime after u find, u hav 2 press Ctrl+home again n again 4 d next items since u dunno where d hack it is .. (tats y u need d find isnt it? ), or u can just press 'ok' twice 2 let it start frm beginning again.. in my opinion its a bit troublesome... n a bit slow if u r in a hurry.. if u know wat i mean.. |
|
| Back to top |
|
|
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Thu Sep 07, 2006 7:57 am Post subject: |
|
|
I find that the quickest way to search is:
Use Ctrl-F, type the thing you're looking for, press Enter, if it says do you want to start at the beginning, press Enter again to do so. Your finger is already over the Enter button, so it's quick and easy.
This is a case where using the keyboard speeds up the process, and the mouse/trackpad slows me down. |
|
| Back to top |
|
|
superduper
General User
Joined: 06 Sep 2006
Posts: 6
|
| Posted: Fri Sep 08, 2006 4:56 am Post subject: |
|
|
oh well, i guess tats d only way 2 solve d prob.. (actually its not really a prob..
thanks u guys 4 all d help n comment! thanks 
hope tat they will realized this 1 n do a enhancement or any kind..peace! |
|
| Back to top |
|
|
|
