Page 1 of 1

[Solved] Import api

Posted: Fri Mar 02, 2018 10:47 am
by dennisov
Hey
I´m trying to import api from https://api.coinmarketcap.com/v1/ticker/
When I try to insert/hyperlink to extern data , the ok button never apear on the popup screen.

If I import it as a sheet from file, the data get importet, but it will never update.

How can I import it so it will update?
Regards
Dennis

Re: import api

Posted: Fri Mar 02, 2018 10:58 am
by Villeroy
dennisov wrote:How can I import it so it will update?
You can't.

Re: import api

Posted: Fri Mar 02, 2018 11:01 am
by dennisov
waooo hmmm ok

Re: import api

Posted: Fri Mar 02, 2018 12:35 pm
by Villeroy
Install extension http://dl.bintray.com/binnarywolf/Libre ... Plugin.oxt
Make sure that Tools>Options>LanguageSettings>Languages>Locale (2nd option) is something English
With LibreOffice you can use any locale and use the NumberValue function with "." as decimal separator instead of the Value function.
Restart office
Open attachment
 Edit: Hit Ctrl+Shift+F9 (hard recalc) to update 

Re: import api

Posted: Fri Mar 02, 2018 3:32 pm
by dennisov
cool thanks :D

Re: import api

Posted: Sun Mar 17, 2019 6:35 am
by dougabc123
I attempted to install the plug-in below, and the following error popped up:
could-not-create-java-implementation-loader.jpg
could-not-create-java-implementation-loader.jpg (9.97 KiB) Viewed 1302 times
Is this the correct plug-in for the current version of OpenOffice 4.1.6 ?
Villeroy wrote:Install extension http://dl.bintray.com/binnarywolf/Libre ... Plugin.oxt
Make sure that Tools>Options>LanguageSettings>Languages>Locale (2nd option) is something English
With LibreOffice you can use any locale and use the NumberValue function with "." as decimal separator instead of the Value function.
Restart office
Open attachment
 Edit: Hit Ctrl+Shift+F9 (hard recalc) to update