Macro Programming in LibreOffice Calc with BASIC - Introduction

In this video I will show you the basics of BASIC, the scripting language of LibreOffice Calc and Microsoft Excel. Programming in BASIC is simple, as I will show you.
Learn more:

[mikecolley-]

PERFECT. I"m a compiled BASIC person and this explanation worked GREAT for me, I will refer back to it. If you do make a new video, please don't erase this video because it shows me so much and I will use this video as a reference over and over. PERFECT Video. Thank You!

[projectnathanadam]

You have no idea how much your video has helped me! Thank you so much. I am a beginner and I was following along and add my own numbers, to which I didn't realize that I there is a limit to how big the numbers could be, other than that problem it went smoothly.

[henrylawson]

Thank you, very helpful. Needless to say this task could completed with formulas but it was great seeing how to do in Basic to get my head around writing macros.

[jorgealmeida]

I've learned a lot in a short time. Please continue. Thank you!

[TeaAndFloppyDisks]

That's a really good place to start. Thank you for the easy to follow instructions! It looks a lot like the VBA used in MS Office, but the built-in objects (such as ThisWorkbook) are different.

[piotr_biły_]

Finally, after 30 years of occasional use of spreadsheets, I was forced to start programming. Apart from the fact that I mistyped "curSheet", which took me an embarrassingly long time to find, everything worked right out of the box. Thank you.

PS For people like me, I'm posting something for copy-paste.
REM BASIC
Sub Main
Dim currDoc as object
Dim currSheets as object
Dim currSheet as object
Dim currCell as object
Const dodaj as integer=1000

currDoc = ThisComponent
If NOT Then Exit Sub
currSheets = currDoc.getSheets()
currSheet =

For i = 1 To 10 Step 1
currCell = currSheet.getCellByPosition(5, i)
If currCell.String="" Then
a = currSheet.getCellByPosition(1, i).value
b = currSheet.getCellByPosition(0, i).value
wynik = a*b+dodaj
currCell = currSheet.getCellByPosition(6, i)
currCell.value = wynik
EndIf
Next
End Sub

[steve]

"REM" does not mean 'reminder'. It has always meant 'remark'.

[martinfyhn]

Great video, thank you.

A couple of notes:
- As it has been mentioned, the font size is a tad on the small side, especially on my phone 😂
- If you do a final voiceover after you've finished recording, so it's more clear what you're saying, with less unfinished sentences, then it would be easier to retain the information you so graciously are sharing (it might just be me struggling with attention. My head is rather noisy, so it doesn't take much for me to lose track of what's being said)

But keep up the good work 👍

[pratikmahamuni]

Great video. I appreciate you putting the documentation as well!

[famalicao]

Thank you very much ! Very good explanation, easy to understand, helped me very much!

[clarksims]

This is a great tutorial. Thanks for posting.

[petermartin]

A small correction: At time 10:20, the FOR loop will execute 101 times, not 100, because i starts at 0 not 1.

[johnwysham]

This is just excellent. Am very grateful. Thank you!

[BlokeBritish]

in excel vba there is a Userform in wich other controls can be added.
similarly libre has the "Dialog"
but vba has a Frame control wich can be added to a userform.
this Frame can have other child controls too like a button
Libre has no such Frame control
so then, wat is the way to achieve the Frame like effect in Libre ?

[worcesterexchange]

It is good information but the display is too small to read, even at 1080 on quite a big screen. Any chance that you could re-record it zoomed in?

[davivify]

I do appreciate your video. Though I find the text really small and hard to read, even with a maximized window on my 24" monitor. And the light gray comment text I find illegible. Hope the feedback is helpful.

[youssh]

where can i get a list of ThisComponent's methods? this shit obscure af

[NavyCuda]

Is there a way to write a custom function and have the autofill work in calc?

[kapilvora]

Hello, I'm new to learning Macros on Libreoffice Calc, I saw on other excel macros tutorials that there is a typing assistant to autofill the code and available commands for e.g. when you type activecell. a list of commands appears in a dropdown list with options like Activate, AddComment, Address etc. How do you get this in Libreoffice Basic?

[raymondroy]

I was wondering if you could create a macro manually for Advanced Filter. The Record Macro does not register changing sheet or any dropdown menu are not recorded. It would be greatly appreciated if this could be done. Thank you for sharing your knowledge with Us.