[Solved] Trying to understand how to use functions with Calc

Discuss the spreadsheet application

[Solved] Trying to understand how to use functions with Calc

Postby DayGlittering » Thu Jul 23, 2020 4:25 pm

Hi guys,

I want to start using OpenOffice Calc instead of Microsoft Excel, I'm looking for a tutorial or a chart that will help me find the correct functions to use with OpenOffice Calc.

Thanks
Last edited by DayGlittering on Thu Jul 23, 2020 6:20 pm, edited 2 times in total.
OpenOffice 4.1.7 on MacOS
User avatar
DayGlittering
 
Posts: 4
Joined: Tue Jul 21, 2020 9:42 am

Re: Trying to understand how to use functions with Calc

Postby RoryOF » Thu Jul 23, 2020 4:57 pm

/Insert /Function list will give you, on right hand side of your Calc window, a list of the available functions; this list can be refined by selecting a category from the dropdown on the top bar of that list. Clicking on a function name will give a brief explanation of it below the list. Looking up the function name in the Help file will give more information and detailed syntax,
Apache OpenOffice 4.1.9 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32181
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Trying to understand how to use functions with Calc

Postby DayGlittering » Thu Jul 23, 2020 5:00 pm

RoryOF wrote:/Insert /Function list will give you, on right hand side of your Calc window, a list of the available functions; this list can be refined by selecting a category from the dropdown on the top bar of that list. Clicking on a function name will give a brief explanation of it below the list. Looking up the function name in the Help file will give more information and detailed syntax,

Thank you!
OpenOffice 4.1.7 on MacOS
User avatar
DayGlittering
 
Posts: 4
Joined: Tue Jul 21, 2020 9:42 am

Re: Trying to understand how to use functions with Calc

Postby Villeroy » Thu Jul 23, 2020 5:17 pm

LibreOffice Calc is a lot more similar to MS Excel.
https://libreoffice.org/
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 29279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Trying to understand how to use functions with Calc

Postby DayGlittering » Thu Jul 23, 2020 6:16 pm

Villeroy wrote:LibreOffice Calc is a lot more similar to MS Excel.
https://libreoffice.org/

Thanks, I'll check it out
OpenOffice 4.1.7 on MacOS
User avatar
DayGlittering
 
Posts: 4
Joined: Tue Jul 21, 2020 9:42 am


Return to Calc

Who is online

Users browsing this forum: mike.stirton and 16 guests