https://bugs.documentfoundation.org/show_bug.cgi?id=113974
--- Comment #2 from Dan Dascalescu <[email protected]> ---
Nice, I see very recents commits.
As extra motivation, I was trying to extract Bitcoin prices from this API,
=SUBSTITUTE(WEBSERVICE("https://min-api.cryptocompare.com/data/pricemulti?fsyms=BTC,ETH,LTC&tsyms=USD";),
""":{""USD""", "")
The SUBSTITUTE above is just prep. After that, to get at a value, I came up
with a formula looks like this:
=VALUE(MID(A1, SEARCH("(?<=BTC:)\d", A1), FIND("}", A1, SEARCH("(?<=BTC:)\d",
A1)) - SEARCH("(?<=BTC:)\d", A1)))
A week later, that thing above looks more cryptic than elliptic curve
cryptography :) I have no idea what it does at a glance and why it's so
repetitive.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
