Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

Running Open OFfice on Linux Mint

Discussions regarding financial software
TUK020
Lemon Quarter
Posts: 2039
Joined: November 5th, 2016, 7:41 am
Has thanked: 762 times
Been thanked: 1175 times

Running Open OFfice on Linux Mint

#428040

Postby TUK020 » July 16th, 2021, 11:06 am

New project is to get a mini fanless PC running Linux Mint.
When I try to run HYPTUSS under Open Office, the macros do not go - because Python for the scripts is not supported. What package should I load for Python? The software manager presented me with a bucket load of options that I did not understand.
Excuse me that this question is more about Linux that the spreadsheet
tuk020

GeoffF100
Lemon Quarter
Posts: 4720
Joined: November 14th, 2016, 7:33 pm
Has thanked: 178 times
Been thanked: 1363 times

Re: Running Open OFfice on Linux Mint

#428047

Postby GeoffF100 » July 16th, 2021, 11:30 am

TUK020 wrote:New project is to get a mini fanless PC running Linux Mint.
When I try to run HYPTUSS under Open Office, the macros do not go - because Python for the scripts is not supported. What package should I load for Python? The software manager presented me with a bucket load of options that I did not understand.
Excuse me that this question is more about Linux that the spreadsheet
tuk020

OpenOffice is essentially obsolete. Virtually all the development effort has been going into LibreOffice. LibreOffice ships with Linux Mint nowadays. You could try LibreOffice with an up to date copy of Mint.

TUK020
Lemon Quarter
Posts: 2039
Joined: November 5th, 2016, 7:41 am
Has thanked: 762 times
Been thanked: 1175 times

Re: Running Open OFfice on Linux Mint

#428050

Postby TUK020 » July 16th, 2021, 11:33 am

GeoffF100 wrote:
TUK020 wrote:New project is to get a mini fanless PC running Linux Mint.
When I try to run HYPTUSS under Open Office, the macros do not go - because Python for the scripts is not supported. What package should I load for Python? The software manager presented me with a bucket load of options that I did not understand.
Excuse me that this question is more about Linux that the spreadsheet
tuk020

OpenOffice is essentially obsolete. Virtually all the development effort has been going into LibreOffice. LibreOffice ships with Linux Mint nowadays. You could try LibreOffice with an up to date copy of Mint.


Sorry, my confused use of names - I am actually using Libre Office on Linux Mint. Question about Python/macros still stands

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: Running Open OFfice on Linux Mint

#428074

Postby kiloran » July 16th, 2021, 1:07 pm

TUK020 wrote:
GeoffF100 wrote:
TUK020 wrote:New project is to get a mini fanless PC running Linux Mint.
When I try to run HYPTUSS under Open Office, the macros do not go - because Python for the scripts is not supported. What package should I load for Python? The software manager presented me with a bucket load of options that I did not understand.
Excuse me that this question is more about Linux that the spreadsheet
tuk020

OpenOffice is essentially obsolete. Virtually all the development effort has been going into LibreOffice. LibreOffice ships with Linux Mint nowadays. You could try LibreOffice with an up to date copy of Mint.


Sorry, my confused use of names - I am actually using Libre Office on Linux Mint. Question about Python/macros still stands

See page 2 of the USer Guide
If you use LibreOffice on Ubuntu, you may need to install the Python Script Provider from
http://tinyurl.com/y9tnmvtg to allow the macros to work.

I can't remember if I had to do this on Mint, but I suspect so

Hope this helps

--kiloran

TUK020
Lemon Quarter
Posts: 2039
Joined: November 5th, 2016, 7:41 am
Has thanked: 762 times
Been thanked: 1175 times

Re: Running Open OFfice on Linux Mint

#428237

Postby TUK020 » July 17th, 2021, 8:03 am

kiloran wrote:
TUK020 wrote:
GeoffF100 wrote:OpenOffice is essentially obsolete. Virtually all the development effort has been going into LibreOffice. LibreOffice ships with Linux Mint nowadays. You could try LibreOffice with an up to date copy of Mint.


Sorry, my confused use of names - I am actually using Libre Office on Linux Mint. Question about Python/macros still stands

See page 2 of the USer Guide
If you use LibreOffice on Ubuntu, you may need to install the Python Script Provider from
http://tinyurl.com/y9tnmvtg to allow the macros to work.

I can't remember if I had to do this on Mint, but I suspect so

Hope this helps

--kiloran

kiloran,
copied and pasted the Python script provider into the MInt software manager, and loaded up - worked, now able to enable macros, fetch prices and yields. Thank you.
Tried to do the charts, and got:
Error 503 Backend fetch failed

Backend fetch failed
Guru Meditation:

XID: 715333820

Running Libre Office 6.4.7.2 on Linux Mint

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: Running Open OFfice on Linux Mint

#428238

Postby kiloran » July 17th, 2021, 8:09 am

TUK020 wrote:
kiloran wrote:#
kiloran,
copied and pasted the Python script provider into the MInt software manager, and loaded up - worked, now able to enable macros, fetch prices and yields. Thank you.
Tried to do the charts, and got:
Error 503 Backend fetch failed

Backend fetch failed
Guru Meditation:

XID: 715333820

Running Libre Office 6.4.7.2 on Linux Mint

Glad the script provider worked.
I recently found that the MoneyAM charts are no longer working, the website has changed and the new charts are not usable. You can change the chart source to LiveCharts on the Parameters sheet.
I'm working on an alternative to MoneyAM charts

--kiloran

TUK020
Lemon Quarter
Posts: 2039
Joined: November 5th, 2016, 7:41 am
Has thanked: 762 times
Been thanked: 1175 times

Re: Running Open OFfice on Linux Mint

#428240

Postby TUK020 » July 17th, 2021, 8:26 am

kiloran wrote:Glad the script provider worked.
I recently found that the MoneyAM charts are no longer working, the website has changed and the new charts are not usable. You can change the chart source to LiveCharts on the Parameters sheet.
I'm working on an alternative to MoneyAM charts

--kiloran

That worked, thanks

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: Running Open OFfice on Linux Mint

#428242

Postby kiloran » July 17th, 2021, 8:37 am

TUK020 wrote:
kiloran wrote:Glad the script provider worked.
I recently found that the MoneyAM charts are no longer working, the website has changed and the new charts are not usable. You can change the chart source to LiveCharts on the Parameters sheet.
I'm working on an alternative to MoneyAM charts

--kiloran

That worked, thanks

I've also found that there has been a small change on the Stockopedia site so dividends also fail with Stockopedia as a source (LibreOffice on Windows, haven't checked on Linux). I have a fix ready to go.

--kiloran


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 5 guests