Sorry, as a total newbie, I am getting my head in a total spin about where my python macros should reside. I am on Ubuntu 23.04 and LO 7.5.4.2.
What I am trying to do is to write a macro that takes row of numbers from the current spreadsheet and put it in the same place in another spreadsheet called Tool.ods (also open).
As far as I can make out, to achieve this in LO my scripts need to sit in .config/libreoffice/4/user/Scripts/Python/.
However, it seems to me that Geany wants to put all my macros into /home/projects
When I click on New Project. I get a box asking me for File, File Name and Base Path
File I presume is XXXX.py....but what do I put in for File Name and Base Path?.....If I try to change any of the two to .config/libreoffice/4/user/Scripts/Python/......I find I cannot. I don't want to use default as then the script will not appear in the LO Macro look up box. What am I missing please?