Getting Started with Macros (Basic Examples) in LibreOffice Calc

This video tutorial shows the beginning steps of creating, recording, running, and editing macros in LibreOffice Calc.
The video walkthrough follows step by step using the official Getting Started Guide, which is available on their website here
books.libreoff...
If you prefer the PDF, ODF, or hardcopy version, it's available on this website (Click the Getting Started Guide 7.5 to see the options):
books.libreoff...
Don't worry if you don't understand macro code yet! There's a steep learning curve in editing code for macros, so it's ok to take your time to learn it. This video should at least help you to get going.
#LibreOfficeCalc #CalcMacro

[@alkamino]

Thank you! :D I really appreciate this video! :D You are the best!!!!!

[@officenifty]

You're welcome, Danny! It's wonderful to hear the content was impactful. Thanks for watching and giving your feedback 😊

[@terrenceolivido741]

this may be the only guy in the world who has done this. ... and after his explanation he will continue to be. i give him 100% credit for this, but also recommend that someone else read his narrative or he take elocution lessons.

[@officenifty]

Thank you for your kind comment and constructive criticism! I bought a public speaking course and am going through it to elocute better.

[@Outside-In.]

​@@officenifty I am not sure, but I do believe you elocuted very well LOL. Elocution??. I had to look that one up, but it was just as I thought. I thought your execution and follow through was very good indeed, and I understood completely everything you were saying, so great great job. Glad that I subscribed, as I love spread-sheeting, and using IF statements, nested IF statements, and nested nested IF statements... These macros look very interesting as well, and am sure they will come in handy. Spreadsheet is my name, and statistics is my game for sure.
👍👍👍

[@virsli100]

I would like to see an advanced video about macros. Creating custom python formulas in python. And more specifically somehow invoking yahoo_fin python program to get stock market data that we can use in Calc

[@cashpop-jo4zk]

can u tell me how to join 2 tables using common column in open office calc

[@S-sz1oo]

How will we enable relative referencing, if we want to create a macro for a formula, but would like it to change the cell address and not just copy/paste the same formula with the same cell addresses. And I did try the way you said, but that only copy/pastes, and is not dynamic. It would be a big help! Thanks!

[@beluga4785]

Thanks😀

[@officenifty]

You're welcome! Thanks for watching and leaving a comment, I appreciate it 👍

[@TheMarkdo1980]

Hello, i am using libreoffice calc, and i need to make sound like beep when a cell show Error, can you teach me how?

[@lonnieo4676]

this does not look like basic...

[@georgeunknown6381]

Because it's StarBasic