Python and Libre Calc Help

[data_wrangler]

Running Libre Office Version: 6.2.1.2 (x64) on Windows 10.
Running Python 3.7.0 and tried on Python 3.5.6 as well.

Been having a hard time getting Libre Calc to recognize my python scripts as a macro. In the Python Macro window only the folder comes up with no script icon to run.

Here my current process and what I have tried. Is there anything I’m not doing correctly?

1. Use a separate IDE to write the .py code
2. Copy and Pasted the script in C:\Program Files\LibreOffice\share\Scripts\python directory that is installed by default when initially installed Libre Office.
3. Uninstalled and then reinstalled Libre Office 1x.
4. Tried the Libre Office extension “APSO - Alternative Script Organizer for Python”.
5. Macro security is set to Medium.

[Hrbrgr]

I myself have no idea about Python. However, I found some hints on the wiki page. Maybe it can help you.

And in the Dokumentation you find a discription “Calc Macro”

[Ratslinger]

Have you a defined function (def statement) in the script?

[data_wrangler]

ebot-Thank you for the links!

Ratslinger-That fixed it. Of all the things I tried, I completely forgot to make ta defined function out of what I need to do. Thanks!

[Ratslinger]

@data_wrangler

Glad it helped. We all need another set of eyes sometimes.

[karolus]

Hello
Don’t store your Scripts into Programfolder.
Store into your **useprofile\Scripts\python**.

On Windows that should be:.

%appdata%\Roaming\LibreOffice\4\user\