[Solved] Import api

dennisov · Post by **dennisov** » Fri Mar 02, 2018 10:47 am

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

edit this topic's initial post · Post by **Villeroy** » Fri Mar 02, 2018 10:58 am

dennisov wrote:How can I import it so it will update?

You can't.

dennisov · Post by **dennisov** » Fri Mar 02, 2018 11:01 am

waooo hmmm ok

edit this topic's initial post · Post by **Villeroy** » Fri Mar 02, 2018 12:35 pm

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

dennisov · Post by **dennisov** » Fri Mar 02, 2018 3:32 pm

cool thanks

dougabc123 · Post by **dougabc123** » Sun Mar 17, 2019 6:35 am

I attempted to install the plug-in below, and the following error popped up:

: could-not-create-java-implementation-loader.jpg (9.97 KiB) Viewed 1310 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

[Solved] Import api

[Solved] Import api

Re: import api

Re: import api

Re: import api

Re: import api

Re: import api