Re: [libreoffice-users] Python macros do not show

2020-09-07 Thread Mauricio Baeza
On Mon, 2020-09-07 at 21:05 -0500, Jim wrote:
> I just did a fresh install of Mint 20 which comes with LO 6.4xx. I
> did 
> Tools-->Macros-->Organize Macros in Cakc but there is no entry for
> Python.
> 
> A few years ago when I did the same thing with Mint 18 I had the
> same 
> problem. I thought what I did to fix it was, create a Scripts/python 
> folder in .config/libreoffice/4/user/Scripts/python and be sure that 
> uno.py and unohelper.py were in the site-packages folder of my
> virtual 
> environment. Also in an effort to get this working I set the
> security 
> level for macros to low.
> 
> What else do I need to do to get python macros working?
> 
> Thanks, Jim



In Ubuntu 20.04 you need install:

sudo apt install libreoffice-script-provider-python

Perhaps for Mint is necessary too.

https://wiki.documentfoundation.org/Macros/Python_Guide/Introduction


Best regards


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


[libreoffice-users] Python macros do not show

2020-09-07 Thread Jim
I just did a fresh install of Mint 20 which comes with LO 6.4xx. I did 
Tools-->Macros-->Organize Macros in Cakc but there is no entry for Python.


A few years ago when I did the same thing with Mint 18 I had the same 
problem. I thought what I did to fix it was, create a Scripts/python 
folder in .config/libreoffice/4/user/Scripts/python and be sure that 
uno.py and unohelper.py were in the site-packages folder of my virtual 
environment. Also in an effort to get this working I set the security 
level for macros to low.


What else do I need to do to get python macros working?

Thanks, Jim


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: [libreoffice-users] Odd libreoffice directory under /usr/lib

2020-09-07 Thread MR ZenWiz
Thanks, that worked perfectly.

(I should have known to check it out myself.)

Mark

On Sun, Sep 6, 2020 at 10:49 PM Luuk  wrote:
>
>
> On 5-9-2020 23:07, MR ZenWiz wrote:
> > While looking into the issue I reported about LO 7 not starting
> > properly (which is SOLVED, thank you), I noticed another anomaly.
> >
> > While chasing after the JRE load error that the --nologo option seems
> > to provoke, I discovered the following strange situation:
> >
> > $ loc javaldx
> > /opt/libreoffice6.4/program/javaldx
> > /opt/libreoffice7.0/program/javaldx
> > /usr/lib/libreoffice/program/javaldx
> >
> > ("loc" is an alias I use to run "locate" with certain exclusions and
> > piped through more - not a problem.)
>
> It is not an error, it is just a warning that it cannot find java.
>
> to solve it use:
>
> sudo apt install openjdk-8-jre
>
> The 'documentation' is no really helpful ( a bit old):
>
> https://wiki.documentfoundation.org/Faq/General/InstallJava
>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: [libreoffice-users] LibreOffice Base previously copying data from Calc to Base)...

2020-09-07 Thread Robert Großkopf
Hi Zed,
> 
> My first thought was to have the entire database in one Table,
> differentiating the sectors by using different titles for the ID field,
> e.g. ID as an Integer (for the Reactor), IDArtist  for the artist as an
> Integer etc.  I created the IDArtist as an Integer but when I tried to
> save it I got the error message.
> Column constraints are not acceptable in Statement [ALTER TABLE "Table1"
> ADD "IDArtist" INTEGER NOT NULL IDENTITY] When I click on More I see SQL
> Status:S1000

You have created a table with ID as primary key (IDENTITY).
Now you have to add als the foreignkeys like "IDArtist", "IDPerformance"
und "IDVenue" as foreignkeys by setting the fieldtype to the same
fieldtype as you have choosen in this special table, for example
INTEGER. Don't set this field to key-fields in "Table1". This table
already contains such a field ("ID") and contains also data, which will
need a keyvalue.

Also you couldn't add an (empty) field to a table and set this field to
NOT NULL, if the table aleady contains data.

Hope it helps a little bit.

Regards

Robert
-- 
Homepage: https://www.familiegrosskopf.de/robert

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy