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

Discuss the spreadsheet application
Post Reply
User avatar
DayGlittering
Posts: 4
Joined: Tue Jul 21, 2020 9:42 am

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

Post by DayGlittering »

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
RoryOF
Moderator
Posts: 34612
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Trying to understand how to use functions with Calc

Post by RoryOF »

/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.15 on Xubuntu 22.04.4 LTS
User avatar
DayGlittering
Posts: 4
Joined: Tue Jul 21, 2020 9:42 am

Re: Trying to understand how to use functions with Calc

Post by DayGlittering »

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
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Trying to understand how to use functions with Calc

Post by Villeroy »

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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
DayGlittering
Posts: 4
Joined: Tue Jul 21, 2020 9:42 am

Re: Trying to understand how to use functions with Calc

Post by DayGlittering »

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
Post Reply