Thanks much, Jonathon. I had no idea what PivotTables/DataPilot were. I may very well be able to use them! You learn something new everyday...
On Tue, 22 Mar 2005 09:15:22 +1100, Jonathon Coombes <[EMAIL PROTECTED]> wrote: > On Mon, 2005-03-21 at 15:40 +0000, Jennifer Saussez wrote: > > I use formulas, pivot tables, filters, validation, etc. in Microsoft > > Excel. Can you tell me whether openoffice.org 2.0 has these features? > > Are the three available softwares (word processing, drawing and > > calculating) very similar to the corresponding Microsoft Word, > > PowerPoint and Excel? Thanks for your help - > > Hi Jennifer, > > Yes, these are all available in Calc within OpenOffice.org. > > Formulae: These are very similar to the Excel formulae. You can see > a list of available formulae by using Insert -> Function List > > Pivot Tables: These are called DataPilot in Calc. They work almost > identically, particularly since 2.0 beta, and can be accessed > from Data -> DataPilot -> Start > > Filters: There are three lots of filters within Calc. There is the > autofilter and standard filter which are similar to Excel. There > is also the Advanced filter which works differently to Excel. > The filters are all in Data -> Filter > > Validation: This is done using Data -> Validity to check validity of > input values. If you mean validity of formulae, then you may want > to look at Tools -> Detective. > > Regards > Jonathon > -- > OOo Tips (RSS) - http://mindmeld.cybersite.com.au/tips.rss > OOo Knowledgebase - http://mindmeld.cybersite.com.au/ > Cybersite Consulting - http://www.cybersite.com.au/ > Training4Linux - http://www.training4linux.com > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- -hackmiester EAT IT!! http://www.hackmiester.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
