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
[Solved] Trying to understand how to use functions with Calc
- DayGlittering
- Posts: 4
- Joined: Tue Jul 21, 2020 9:42 am
[Solved] Trying to understand how to use functions with Calc
Last edited by DayGlittering on Thu Jul 23, 2020 6:20 pm, edited 2 times in total.
OpenOffice 4.1.7 on MacOS
Re: Trying to understand how to use functions with Calc
/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
- DayGlittering
- Posts: 4
- Joined: Tue Jul 21, 2020 9:42 am
Re: Trying to understand how to use functions with Calc
Thank you!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,
OpenOffice 4.1.7 on MacOS
Re: Trying to understand how to use functions with Calc
LibreOffice Calc is a lot more similar to MS Excel.
https://libreoffice.org/
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- DayGlittering
- Posts: 4
- Joined: Tue Jul 21, 2020 9:42 am
Re: Trying to understand how to use functions with Calc
Thanks, I'll check it outVilleroy wrote:LibreOffice Calc is a lot more similar to MS Excel.
https://libreoffice.org/
OpenOffice 4.1.7 on MacOS