Getting Started with Macros (Basic Examples) in LibreOffice Calc

[@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 😊

[@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!

[@cashpop-jo4zk]

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

[@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

[@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. 👍👍👍

[@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?

[@beluga4785]

Thanks😀

[@officenifty]

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

[@lonnieo4676]

this does not look like basic...

[@georgeunknown6381]

Because it's StarBasic

[@xavsbrink6484]

Stay away from the star basic. I do for 40 years the most basic form of basic and solve nearly every problem with adding a fsm. A finite state machine. A fsm is in fact 1 case statement with states. So you can automate work in SAP database systems, bookkeeping programs inclusive income tax calculation, stock robots, automate work in cad programs, gaming, etc