OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Tools/Options

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
dougies
Newbie
Newbie


Joined: 28 Dec 2009
Posts: 3
Location: Welwyn, UK

PostPosted: Mon Dec 28, 2009 9:45 pm    Post subject: Tools/Options Reply with quote

Hi

Recent convert to Mac (at home, MBP Very Happy) and trying to use Calc 3.1.1, I live on Excel though at work, in Accounts, so no scientific stuff, small user of Macros and VB. I don't want to load MS**t on my MBP either!!

I'm encountering a number of issues but will try and deal with them by checking in the forums, good work guys too! Because Calc looks so much like Excel, you assume (incorrectly) it will work like Excel......WRONG!!

But 2 I cannot sort out!!

I don't appear to have Options on my Tools menu, but it's referred to there in the forums. How do I get to see it?

Autofilter: Is there a succinct guide somewhere as to how to use Autofilter in Calc? If I filter on a field value in a column, I get multiple field results (as if it's not selecting the whole database). So if I only want to see RED results, I get GREEN/YELLOW etc as well!!

Thanks for any help!
_________________
Scrap your PC, get a Mac! Er maybe not for Excel??
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Mon Dec 28, 2009 10:34 pm    Post subject: Reply with quote

You asked:
dougies wrote:
I don't appear to have Options on my Tools menu, but it's referred to there in the forums. How do I get to see it?


Please see the link below:

http://www.oooforum.org/forum/viewtopic.phtml?t=86875

I hope this helps, please be sure to let me / us know.

Sliderule
Back to top
View user's profile Send private message
dougies
Newbie
Newbie


Joined: 28 Dec 2009
Posts: 3
Location: Welwyn, UK

PostPosted: Thu Jan 07, 2010 12:53 pm    Post subject: Reply with quote

sliderule wrote:


Please see the link below:

http://www.oooforum.org/forum/viewtopic.phtml?t=86875

I hope this helps, please be sure to let me / us know.

Sliderule


Thanks sliderule, I've found it. I was looking for a menu item called "Options", but see that it's under "Preferences" and is more obvious when you expand some of the headings!

Sorted!
_________________
Scrap your PC, get a Mac! Er maybe not for Excel??
Back to top
View user's profile Send private message
dougies
Newbie
Newbie


Joined: 28 Dec 2009
Posts: 3
Location: Welwyn, UK

PostPosted: Sat Jan 16, 2010 9:24 am    Post subject: Reply with quote

Think I've solved the Autofilter problem, but still don't know if there's a succinct guide out there!

When using Standard Filter, check which field is being filtered on. Unlike Excel, the active cell does not have to be in the column you wish to filter on. In the Standard Filter you select which field to filter on. A useful improvement, and it defaults to the current column of the active cell!!
_________________
Scrap your PC, get a Mac! Er maybe not for Excel??
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group