3

I'd like to write libreoffice-calc macros (libreoffice-basic) in Visual Studio Code instead of the embedded macro editor.

I know xlwings enables such functionality when working with excel, as explained in this video, using xlwings vba edit. But I have no idea how to do it using libreoffice calc.

Any idea?

Improve this question
1
  • Not sure how xlwings works, but I use Vim to write python-uno macros, and I have occasionally done this with LO Basic macros as well. The built-in editor for Basic is decent but has some drawbacks, so it's not a bad idea to use an external editor instead. In typical XML syntax, the .xba files where the code is stored use " and & instead of direct punctuation, so I just type it that way, but maybe you can get VS Code to do that for you automatically. You'd also have to update script.xlb if you add new modules. Commented Dec 13, 2023 at 18:51
Related questions
1
LibreOffice Calc: Access a user selected range in a macro
0
How to save and close a running LibreOffice Calc instance programmatically?
2
Using built in Calc function when recording a macro
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.