Bug 62472 - Cells referring to values by "Extension GetQuote 1.1" with wrong value after FILEOPEN
Summary: Cells referring to values by "Extension GetQuote 1.1" with wrong value after ...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL: http://extensions.openoffice.org/de/p...
Whiteboard: BSA
Keywords: regression
Depends on:
Reported: 2013-03-18 14:14 UTC by Jens Westemeier
Modified: 2015-02-14 13:46 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Jens Westemeier 2013-03-18 14:14:50 UTC
Problem description: 

Cells are not updated properly

Steps to reproduce:
1. Install Extension "GetQuote 1.1" from http://extensions.openoffice.org/de/project/GetQuote

2. Enter "=GETQUOTE("EURUSD=X")" into field A1
3. Enter "=A1" into B1
4. Save file

Current behavior:
A1 and B1 show the same value. After saving and opening again (or refresh), A1 shows the actual value, given from GetQuote, B1 shows the old, different from A1 value.

Expected behavior:
Both fields allways show the same value.

I file this as a Libre Office Bug since the same extension was working under older versions of Libre Office
Operating System: Windows 7
Version: release
Comment 1 Jens Westemeier 2013-03-18 18:28:24 UTC
Same happens with Libre Office on Linux (OpenSuSE 12.2 / 64 Bit).
Comment 2 Joel Madero 2013-04-22 20:58:06 UTC
This is likely NOTOURBUG as it's related to a third party extension but adding Rainer so he have final say on this.

Rainer - another extension bug, will you mark appropriately?

@Jens - I recommend you get in touch with the developer of the extension to get him/her to fix it.
Comment 3 Rainer Bielefeld Retired 2013-04-23 06:18:55 UTC
[Reproducible] with parallel Dev-installation of  "Version (Build ID: 0b4315077a6827798e1d2bdae73298365ba9a01) TinderBox: Win-x86@6, Branch:master, Pull Time:  2013-04-18_04:00:51" ENGLISH UI / German Locale on German WIN7 Home Premium (64bit) with LODev/4 Masters User Profile

Steps how to reproduce:
0. Install Extension, close LibO, restart
1. open attached sample document, check B1
   Expected: should have same value as cell A1 with same number of decimals
   Actual: small difference between values A1 and Be (shown in B2), 
           B1 shows only           4 decimals instead of expected 8 ones. All unexpected vanishes with

This problem might be related to the version with what the sample document has been created. so for your own tests please create a new document and follow reporter's instructions.

Migtht still have been ok with 
* Server Installation of "LibO   -  GERMAN UI / German Locale  [Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89)]"  {tinderbox: @6, pull time 2013-01-31 11:30(?)} on German WIN7 Home Premium (64bit) with separate  new User Profile
* unzipped  installation of  "LOdev   -  ENGLISH UI / German Locale  [Build ID: af60316514f3ae3d4c475819bf86f2af837171e)]"  {tinderbox: Win-x86@6, pull time 2012-11-23 22:10:31} on German WIN7 Home Premium (64bit) with own separate User Profile 
* server installation of "LibreOffice  German UI/Locale [Build-ID: 3215f89-f603614-ab984f2-7348103-1225a5b] on German WIN7 Home Premium (64bit) 
**  server-installation of Master "3.7.0alpha0+  – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: b255de8]" (tinderbox: Win-x86@6-fast, pull time 2012-06-05 23:16:58)
* OOo 4.0-dev

Attention, this problem seems to be not 100% reproducible, if value generated by extension did not change between save and reopen, it looks as if the problem does not exist. I learned this after my tests where they started so the results might not be reliable. For a test you will have to remember the A1 value when you save, test is only useful if you have a different value in A1 after FILEOPEN.

It seems that this is neither simply Extension nor simply LibO problem but something with interaction?

Please also see "Bug 63824 - GetQuote 1.1: breaks cell formatting " and "Bug 63823 - GetQuote 1.1: Installation fails with Java error message", where confirmation and additional research is required.
Comment 4 Rainer Bielefeld Retired 2013-04-23 06:33:04 UTC
I left a request for assistance on <http://extensions.openoffice.org/de/project/GetQuote#comment-6589>
Comment 5 Markus Mohrhard 2013-04-24 13:35:35 UTC
Please check if this issue is still present after a hard recalculation?

Additionally changing the recalculation settings for the import might help and if so please put me in CC.
Comment 6 Jens Westemeier 2013-05-21 07:51:45 UTC
With LibreOffice 4.0.3 the problem is solved for Windows 7 and OpenSuse 12.3 (both 64 Bit).
Since I don't have seen any specific bugfix associated with that, it seems to be still there but being unreproducable.
Comment 7 Joel Madero 2013-05-21 12:57:43 UTC
Hm if it's fixed for you but no patch known we mark as WFM. Going to do so now, if you catch the bug again please mark the bug as NEW again. Thanks!
Comment 8 Jens Westemeier 2014-01-27 18:36:46 UTC
Bug is back in LibreOffice on OpenSuSE 13.1 / 64 Bit
Comment 9 raal 2014-10-17 17:15:06 UTC
Tested with getquote 1.0 and LO Version:
Build ID: 9aa36a1ad39e37c372cc833a44fba450b8cc30cd
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-10-09_04:46:44

and can not reproduce the bug. Seems to be fixed.
Comment 10 Matthew Francis 2015-02-14 13:46:14 UTC
Per comment 9, currently believed to be fixed