https://bugs.documentfoundation.org/show_bug.cgi?id=98249
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTOURBUG --- Comment #11 from Eike Rathke <[email protected]> --- Opening that document in LibreOffice 5.1.1 without the extension installed I get 32.12€ in an en-US locale and 32,12€ in an de-DE locale. Nothing wrong there. With the extension installed from http://extensions.libreoffice.org/extension-center/smf-extension I get 31.03 (or similar current value) in an en-US locale, left aligned and without the Euro symbol, which indicates the GETYAHOO() function returns a string instead of a numeric value. The same if I start LibreOffice in a de-DE locale. However, this only upon the first call of the GETYAHOO() function, subsequent calls return a numeric value which then is properly displayed. This independent of whether the cell is copy-pasted or the formula is edited (e.g. append and remove blank to modify). Apparently this pattern is repeatable, the very first call to GETYAHOO() after starting LibreOffice always returns a text string instead of a numeric value. Having debugged this I indeed can confirm that the first call's return is of type uno::TypeClass_STRING instead of type uno::TypeClass_DOUBLE like it is for all subsequent calls. I suggest you get in touch with the extension author and/or as a workaround have a dummy call in the spreadsheet that gets calculated first before "real" calls or just invoke the function once in any spreadsheet document before loading the document in question. This apparently is not a bug of Calc. -- 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
