search

madsailor / SMF-Extension

LibreOffice extension for retrieving stock market data
GNU Lesser General Public License v3.0
27 stars 17 forks source link

Not working for me #1

Closed dpugeau closed 9 years ago

dpugeau commented 10 years ago

Hi Madsailor, I just downloaded and installed SMF. I initially had an error in the extension manager but a google search brought the libreoffice-pyuno package to my attention. After installing it the install appears to have worked.

I next opened the yahooexamples.ods. It shows #VALUE! for every formula. Same for both Morningstar sample spreadsheets.

I've tried the extension on LibreOffice 4.1.6.2 on Fedora 19 and on OpenOffice 4.1.0 on Red Hat 6.5. Same results on both.

Any help troubleshooting would be appreciated.

ranoniem commented 10 years ago

I have the same issue. What I noticed is that your delimiter is a colon, in the documents and in the spreadsheet Example. However in the formula there are semi colons: =GETYAHOO(A1;1)

And when I replace the semi-colon with a colon, it adds a zero as prefix to the datacode. Like this: =GETYAHOO(A10,1) This gives me a error:509, which says I should use semi-colon.

So I think this conflix as some users use a semicolon or colon in their functions.

The extension should consider which delimiter the user uses maybe

TrevorDTC commented 10 years ago

Hi Madsailor, can you point out how to use this extension? I install the extension via extension manager, then when I open the "example" file, all it shows are #VALUE.

What step I missed? I never used the SMF plugin for Excel, so is that what I miss? screenshot from 2014-09-15 12 48 56

madsailor commented 10 years ago

On 09/14/2014 09:48 PM, TrevorDTC wrote:

Hi Madsailor, can you point out how to use this extension? I install the extension via extension manager, then when I open the "example" file, all it shows are #VALUE.

What step I missed? I never used the SMF plugin for Excel, so is that what I miss?

— Reply to this email directly or view it on GitHub https://github.com/madsailor/SMF-Extension/issues/1#issuecomment-55552723.

TrevorDTC,

Unfortunately the SMF addin is broken as of LO4 since the migration to Python3. I have not had the time to change the code. You have installed it correctly, it just isn't functioning until such time as I or a contributor find a fix (dicts and parsing are handled differently).

Madsailor

ranoniem commented 9 years ago

Thanks, its working!

LibreOffice Version: 4.3.3.2 (g)Ubuntu 14.10 64-bit

madsailor commented 9 years ago

Great. Thanks for the feedback!