LOC-Extension
LOC-Extension copied to clipboard
walkjivefly
Getting Err:504 even in the Examples.ods
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
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.
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
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?
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.
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.
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.
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).
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...
Yeah, i get exceptions with coinmarketcap on linux(alpha4) and error 504 on pretty much everything in windows(alpha3w).
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
@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.
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 [email protected] 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 https://github.com/walkjivefly/LOC-Extension/issues/4#issuecomment-469695298, or mute the thread https://github.com/notifications/unsubscribe-auth/AWBFOvkuM_1goHupczKmbvmt_zhtxFmrks5vTnw1gaJpZM4RN55U .
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
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.
@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.
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.