Issue 118312 - Formula gets morphed.
Summary: Formula gets morphed.
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Linux, all
: P2 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Ephraim Purcell
Depends on:
Reported: 2011-07-20 05:18 UTC by de_logics
Modified: 2014-03-19 11:35 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Buggy spreadsheet (22.78 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-07-20 05:18 UTC, de_logics
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description de_logics 2011-07-20 05:18:05 UTC
I've installed the getquote addon for calc. I've used the function extensively and till yesterday, everything seemed fine, then today all of a sudden (when the stock market opened), I saw the OOo was crashing on opening the document with the getquote addon. I tried opening as a different user, and saw the formula had changed (as seen in the attached document). "" had been added.

Thus morphing the formula without permission.
Comment 1 de_logics 2011-07-20 05:18:41 UTC
Created attachment 76704 [details]
Buggy spreadsheet
Comment 2 Marcus 2012-03-03 12:00:27 UTC
this issue is no P1
Comment 3 dE 2012-03-04 03:53:44 UTC
This issue causes data loss, in my case it's complex formulas with involvement of 10 - 15 cells.
Comment 4 Ephraim Purcell 2013-01-22 13:08:34 UTC
Formula appears "morphed" when GETQUOTE disabled or not present, however this is not permanent. With GETQUOTE enabled file opens very slowly and AOO appears to crash. However, wait with it and file opens successfully after several minutes. Slow opening is probably caused by internet connection speed or slow Yahoo Finance Server response.
Comment 5 Edwin Sharp 2013-11-17 11:17:09 UTC
1) Download extension getquote by Ted
2) Delete in attachment 76704 [details]
3) Save and File - Reload is added to getquote function.

AOO410m1(Build:9750)  -  Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Comment 6 Rainer Bielefeld 2014-03-19 11:35:57 UTC
Version has been modified erroneous, so back to most early version