Getting Err:504 even in the Examples.ods

[endrep0]

Hi,
I could install the extension, but I can't get even Examples.ods to work. The cells with the extension calls all show "Err:504". Any idea why?

LOC-Extension version: 0.2.3

Platform you're running it on: Windows 7 x64

Expected behaviour: returning the value of the formula

Actual behaviour: Err:504

[Ep0chalypse]

I'm also experiencing this issue. Any solutions yet?

[walkjivefly]

I'm guessing the problem is related to using Example.ods and LOC.oxt from different releases. It's only a guess because I'm not able to reproduce the error at this time. And if that is the case, I'm sorry for the packaging mistake.

I have simplified and updated the Example.ods sheet but not packaged it into a release yet. My internet has been outrageously slow recently and loading the example sheet was taking several minutes instead of a few seconds. The new version reduces the number of function calls and demonstrates the use of caching. It's a work-in-progress and will only work properly with the current master code.

[endrep0]

Thanks for looking into it.

I downloaded the new Example.ods from today, and it's still giving the same Err:504 messages.

LOC-Extension version: 0.2.3

[walkjivefly]

That's weird, and I'm sorry you're (still) having a problem, @endrep0. I still don't have access to a Windows machine to test/fix it on. If you open one of the cells with the Err:504 message, what is the value shown in the formula bar? Is it something like
=CCXT(B8,CONCAT(A8,"/usd"),"price_btc")*C8
or is the function name something long and complicated? And which version of LibreOffice are you using?

[endrep0]

LibreOffice 5.3.7.2 (x64) (might have upgraded once since the original issue was posted)

Yes - the formulas in the formula bars look just like that.
Let me copy-paste a few examples, all result in Err:504:
=GETPOLONIEX(E3;F3)
=CCXT(F2;F3;F4)
=CCXT("coinmarketcap";CONCAT(A6;"/usd");"price_btc")

Thank you for trying to fix it :)

Maybe you could test it on something like this?
https://developer.microsoft.com/en-us/windows/downloads/virtual-machines
Just a guess, I'm not 100% sure if they can be used for stuff like this.

[walkjivefly]

You have semicolons in the formulae? I have commas, but semicolons work for me too. What language settings do you have?
I've tested on 5.3.4/5 and 5.4 but not 5.3.7. I'm downloading it to try.
I did the limited testing with Windows 7 using a VirtualBox VM and the MS developer download but don't have access to it at present.

[walkjivefly]

You have semicolons in the formulae? I have commas, but semicolons work for me too. What language settings do you have?
I've tested on 5.3.4/5 and 5.4 but not 5.3.7. I'm downloading it to try.
I did the limited testing with Windows 7 using a VirtualBox VM and the MS developer download but don't have access to it at present.

[endrep0]

Yes semicolons.
If I open your Example.ods it's all semicolons already. I'm guessing it's showing the format that's correct for my locale. (With commas it gives Err:501).

In other functions like =MAX I also have to use semicolons.

The LibreOffice is in English, and the Locale is hu-HU (hu_HU).

[walkjivefly]

Wow, with 5.3.7.2 I can't open ANY sheets from 5.3.5, including Example.ods
I'm going to uninstall and re-install and try again...

[Dryparn]

Yeah, i get exceptions with coinmarketcap on linux(alpha4) and error 504 on pretty much everything in windows(alpha3w).

[vadirthedark]

OS is Ubuntu 18.04; LOC v1.6.0.7 on a Linux system. Having the same issues as many of the above (exceptions encountered, #VALUE). When I 'Reload' I get a box asking if I want to 'Delete Change?'. Is there a place with more details on working with your template (cctx, get, etc.)? Thanks

[walkjivefly]

@vadirthedark I take it that version number is Ubuntu's way of saying LibreOffice 6.0.7? I'm using the extension with 6.0.1.1 on MX 17.1 linux (somewhat Ubuntu 18-like). I haven't reproduced any of the Err:504's people have reported so I don't know what causes them.

The example.ods is pretty much all the doc I wrote. The ccxt() function takes 3 parameters; an exchange, a ticker and a function, eg:

=CCXT("bitfinex","btc/usd","last")

or

=CCXT("coinmarketcap","eth/usd","price_btc")

If you change any values in your sheet you should save it before using File/Reload to force the extension to refresh an exchange with cached results by using

=ccxt("bitmex","reload")

Only a handful of exchanges provide cached results to the extension. Most ccxt() calls with Coinmarketcap as the exchange fail since they switched their API last December. I have no plans to try to update the extension in the near future.

[vadirthedark]

I appreciate the additional information and will continue on. One question-are each line to be placed into a separate cell? Thanks again

…

On Tue, Mar 5, 2019 at 8:16 AM walkjivefly ***@***.***> wrote: @vadirthedark <https://github.com/vadirthedark> I take it that version number is Ubuntu's way of saying LibreOffice 6.0.7? I'm using the extension with 6.0.1.1 on MX 17.1 linux (somewhat Ubuntu 18-like). I haven't reproduced any of the Err:504's people have reported so I don't know what causes them. The example.ods is pretty much all the doc I wrote. The ccxt() function takes 3 parameters; an exchange, a ticker and a function, eg: =CCXT("bitfinex","btc/usd","last") or =CCXT("coinmarketcap","eth/usd","price_btc") If you change any values in your sheet you should save it before using File/Reload to force the extension to refresh an exchange with cached results by using =ccxt("bitmex","reload") Only a handful of exchanges provide cached results to the extension. Most ccxt() calls with Coinmarketcap as the exchange fail since they switched their API last December. I have no plans to try to update the extension in the near future. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#4 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AWBFOvkuM_1goHupczKmbvmt_zhtxFmrks5vTnw1gaJpZM4RN55U> .

[walkjivefly]

I don't understand the question. Here's another example of how I use it:

Column A: ticker symbol
Column B: exchange name
Column C: use exchange (=1) or aggregator (Coinmarketcap) (=0) price
Column D: price source to use
Column E: number of coins
Column F: price paid (bought with BTC)
Column G: price paid (bought with ETH)
Column H: current value on the named exchange or on aggregator
Column I: change in %
Column J: profit/loss in BTC

[Jagvayay]

I have the same problem and I noticed something wrong.

LibreOffice version: 5.4.7.2 (x64)
LOC-Extension version: 0.2.2
Platform you're running it on: Windows 10 x64
Expected behaviour: returning the value of the formula
Actual behaviour: Err:504

When the sheets load (or reloads), "=ccxt(stuff)" becomes "=com.loc.crypto.getinfo.python.locimpl.ccxt(stuff)" which results in Err:504 outputs (even in examples.ods).

I can have the extension return the expected values but I need to manually remove "com.loc.crypto.getinfo.python.locimpl." from every formula.

[walkjivefly]

@slowputing thanks for the update. So it sounds like some kind of path problem. I typed =ccxt(stuff) into the cells, but something else got saved. Somehow, the something else version displays for me as =ccxt(stuff), and works as expected, but
for everyone else (with the problem) it doesn't work. I'm not going to poke into what/why/how (I just don't have time) but it sounds like you've found a workaround: retype all the formulae using only ccxt(stuff).

Thanks for taking the time to share the information.

[Jagvayay]

As a follow up I should mention that I just got it working.

I'm not sure exactly how I did it but in case someone is interested here's what I did :

I downgraded LibreOffice version to 5.3.4 and then 5.3.5 which complained I miss VCRuntime140.dll so I installed Microsoft Visual C++ Redistributable.

I installed/uninstalled the extension many times without success. Err:504 was still there yet the aforementioned workaround didn't work anymore.

I was about to reinstall Windows and start fresh when I decided to give version 5.4.7.2 another try and to my surprise everything worked.

I can edit my sheets, save, open, reload and it keeps working. I plan to use the LOC extention on some other Windows systems so I might return and report what I find.