cannot install LOC extension

[HuguesDohmen]

I am running Windows 10 (64 bits) and I am trying to install Loc extension v2 but it gives me a very long error message: "(com.sun.star.uno.RuntimeException) { { Message = "<class 'FileNotFoundError'>: [Errno 2] No such file or directory: 'C:\\tmp\\LOC_14796', traceback follows\X000a File \"C:\Program Files (x86)\LibreOffice 5\program\pythonloader.py\", line 149, in writeRegistryInfo\X000a mod = self.getModuleFromUrl( locationUrl )\X000a File \"C:\Program Files (x86)\LibreOffice 5\program\pythonloader.py\", line 103, in getModuleFromUrl\X000a exec(codeobject, mod.dict)\X000a File \"C:\Users\HUGUES\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\unopackages\lu137121fpwsx.tmp\LOC.oxt\loc.py\", line 38, in \X000a fh = logging.FileHandler(logfile, mode='a', encoding=None, delay=False)\X000a File \"C:\Program Files (x86)\LibreOffice 5\program\python-core-3.3.0\lib\logging\init.py\", line 969, in init\X000a StreamHandler.init(self, self._open())\X000a File \"C:\Program Files (x86)\LibreOffice 5\program\python-core-3.3.0\lib\logging\init.py\", line 993, in _open\X000a return open(self.baseFilename, self.mode, encoding=self.encoding)\X000a\X000a", Context = (com.sun.star.uno.XInterface) @0 } }"

Libreoffice version is 5.3.3.2

How can I solve this?

Regards,

Hugues

[HuguesDohmen]

I just remarked that you reacted on someone elses issue with the same problem. You released a new version of the LOC. I installed this one and this could be installed properly. But it is not working. When I try to make a sheet with it the results in my cels are not what should. Is there something I missed? Do I have to install some extra's on my pc to make it work.

[walkjivefly]

Thanks for confirming that the newest release installs without error on Windows. You should not have to install anything else for the extension to work.

What is the formula you're entering that doesn't get the result you expect? What are your expected and actual results?

The results are not continuously updated. When the inputs that a cell depends on change, LO recalculates the value. The lookup for each coin can take anywhere from 1-30 seconds depending on your network connection. Sometimes a lookup fails.

[HuguesDohmen]

I just remarked that you reacted on someone elses issue with the same problem. You released a new version of the LOC. I installed this one and this could be installed properly. But it is not working. When I try to make a sheet with it the results in my cels are not what should. Is there something I missed? Do I have to install some extra's on my pc to make it work.

[HuguesDohmen]

The formula I entered is =GETPOLONIEX("BTC_ETH","last"). It results in ERROR:504

[walkjivefly]

That's strange and I'm sorry you're having problems. 504 is a parameter error but your parameters look fine and when I cut'n'paste your formula into my sheet it works perfectly. When you start typing the formula does it prompt like this?

What happens if you try the ccxt() function instead? Note the tickers are different in the ccxt() function. For your example you'd need to use =CCXT("Poloniex","eth/btc","last"). The exchange name and ticker are case-insensitive, the information ("last") is case-sensitive.

[HuguesDohmen]

Yes it is very strange. I opened you examples sheet and there it gives the same error. CCXT same problem.

When I start typing i get what you can see in screenshot:

walkjivefly schreef:

That's strange and I'm sorry you're having problems. 504 is a parameter error but your parameters look fine and when I cut'n'paste your formula into my sheet it works perfectly. When you start typing the formula does it prompt like this? loc_001 https://user-images.githubusercontent.com/17745270/34072595-064764c0-e258-11e7-9715-1d226826bdff.png

What happens if you try the ccxt() function instead? Note the tickers are different in the ccxt() function. For your example you'd need to use =CCXT("Poloniex","eth/btc","last"). The exchange name and ticker are case-insensitive, the information ("last") is case-sensitive.

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/walkjivefly/LOC-Extension/issues/2#issuecomment-352195659, or mute the thread https://github.com/notifications/unsubscribe-auth/AWFPozgiC1UggOEhL0HrrUz2xE7l3zGVks5tA_cPgaJpZM4RBZiN.

--

http://www.websandapps.eu/nl

[walkjivefly]

I can only assume the installation got messed up because of the problem with the 0.2.0 package.

LibreOffice does not do a good job of tidying up after an installation fails or when you remove an extension. I haven't experienced a 504 error because of this but I have had lots of problems installing, updating and removing extensions. The only solution I have found on Linux is to completely remove the user config directory and re-install the extensions I want to keep. It is not sufficient to only delete the extensions and uno-packages directories because LibreOffice leaves junk all over the config directory. I guess the Windows versions are no better than their Linux counterparts in this respect.

It's an unsatisfactory response but the only thing I can suggest is for you to shutdown LibreOffice, (backup and) remove the user config directory, restart LibreOffice and re-install the extensions you want. On Linux this is as simple as moving/renaming the ~/.config/libreoffice/4/user directory but probably it's more complex on Windows because some of the information will be buried in the registry. I've never attempted to do this on Windows and don't have access to a machine where I can attempt it. I'm afraid Google will have to be your guide. If you have any customisations like personal information, templates, window appearance, toolbar layouts etc., then all of these will need to be replaced too. It's worth checking on LibreOffice/OpenOffice forums for the best way to do this. Maybe there's a tool which can backup selected customisations and restore them in a clean instance but I don't know of one.

[GarudaLLCAZ]

Hi,

I'm having a different problem. Windows 10/64. Version: 5.4.3.2 (x64) Build ID: 92a7159f7e4af62137622921e809f8546db437e5 CPU threads: 2; OS: Windows 6.19; UI render: default; Locale: en-US (en_US); Calc: group.

I tried loading the had problems like what the OP mentioned. I removed LOC files. Tried again. Removed files again and ran the install for LibreOffice in the repair mode. It wiped out all of the extensions I'd loaded and I tried again.

Now, I'm getting the error message below. Any help would be appreciated! Thanks, Chris

Add Extension(s): C:\Users\calindsey\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\unopackages\lu105841fwe61.tmp\LOC-1.oxt does not exist.

[walkjivefly]

Hi Chris, sorry you're having problems too.

I'm not familiar with repair mode. When do you get that message? During installation or when you try to use the extension? It sounds like LibreOffice knows it should be there but can't find it where it expects to. And I would expect the name to be .....\LOC.ext. Which sounds like the general flakiness LibreOffice has regarding extension file management. It's almost certainly more flaky on Windows because the installation attempt leaves junk in the registry too.

If wiping out the user config directory and reinstalling the extension(s) doesn't get it running then the final 2 suggestions are

1. Use regedit to remove any trace of LibreOffice (extension) settings and try again.
2. The ultimate Windows fallback: uninstall and re-install LibreOffice, possibly in conjunction with some extra registry cleaning (manual or programmatic). It's ridiculous that this is an accepted turn of events in the Windows world.

I think I'm going to update the LibreOffice Extensions page to not say Windows is supported since I don't currently have access to a machine where I can test/support it.

[walkjivefly]

Windows users are STRONGLY advised to make a Windows system snapshot before installing or upgrading ANY LibreOffice extension and to only use v0.2.2 LOC-Extension until further notice.

[walkjivefly]

Opened LibreOffice bug 114708 for the problem installing an extension with a space (put there by the browser) in the filename.