Bug 87303

Summary: Embedded spreadsheet appears as "Object #" and picture of a plug when unselected
Product: LibreOffice Reporter: sebriese <stevebriese>
Component: WriterAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: major    
Priority: medium CC: jmadero.dev, todventtu
Version: 4.3.4.1 releaseKeywords: regression
Hardware: All   
OS: All   
Whiteboard: bibisectRequest
i915 platform: i915 features:
Attachments: .odt file with misbehaving spreadsheet on page 1
Image of broken sheet

Description sebriese 2014-12-14 11:32:31 UTC
Created attachment 110832 [details]
.odt file with misbehaving spreadsheet on page 1

I can usually access and update this imbedded spreadsheet, but when I go to do it a second time it does no display or print as  a spreadsheet, just a static picture of a electrical plug along with and "Object 1" label at the bottom. Strange... If I leave it alone until tomorrow (assuming tomorrow is not a weekend) it can be edited and deselected normally. I am running Windows XP as a VM. It does not seem to be a memory problem.
Comment 1 Beluga 2014-12-16 13:10:01 UTC
Edited text inside the embedded spreadsheet, clicked elsewhere, edited again saved & reopened, but no problems. Not sure, if the astrological alignment was correct at the time, though. I also did not sacrifice any goats while editing.

Win 7 64-bit 4.3.4.1 and Version: 4.5.0.0.alpha0+
Build ID: 170616e9f2d30c1302bbb5a7a4b588bc05cd5cc9
TinderBox: Win-x86@39, Branch:master, Time: 2014-12-12_01:58:46
Comment 2 Joel Madero 2014-12-16 15:30:33 UTC
Can you provide explicit steps of what you're doing? I'm setting this to NEEDINFO. Enumerated steps are always the best:

1. Open the attached file;
2. ...
3. ...

Observed:
Expected:

For instance, what does it mean when you say "when I go to do it a second time" Also can you provide a pdf of what you're seeing with the electrical plug static picture?

Once you do the above please set to UNCONFIRMED. Thanks!
Comment 3 sebriese 2014-12-17 16:20:14 UTC
This is interesting. I found the variable action causing the bug. The document contains sections in addition to the imbedded spreadsheet, so when it loads, I get this message:

"This document contains one or more links to external data.
"Would you like to change the document, and update all links
to get the most recent data?"
"Yes   No"

1. Answering No to this question and then 
2. clicking into the spreadsheet
3. and back out 
results in turning the spreadsheet to a bitmap that looks like a 2-prong Europe contiental electrical wall plug bitmap.

Interesting since the 'Yes / No' question has no impact on updating the spreadsheet. ( wish it did.) It only affects the sections content.
Comment 4 Beluga 2014-12-30 14:55:40 UTC
Created attachment 111517 [details]
Image of broken sheet

It's true that after answering "no" one can break the sheet like you describe. So is it really a bug?
Comment 5 sebriese 2014-12-30 15:22:45 UTC
The Writer message:
"This document contains one or more links to external data.
"Would you like to change the document, and update all links
to get the most recent data?"
"Yes   No"

applies to updating Sections, NOT the spreadsheet. The answer, therefore, should not affect the imbedded spreadsheet (let alone break it). This takes it out of the feature list and into the bug domain.

It is not uncommon to modify the spreadsheet without wanting the sections updated. In my case it essential. This makes it a serious bug.
Comment 6 Beluga 2014-12-30 15:31:08 UTC
Ok, NEW it is.

I tested on Win 7 64-bit Version: 4.5.0.0.alpha0+
Build ID: 57626f2132f73e4e42b31e364b25c5867336e718
TinderBox: Win-x86@42, Branch:master, Time: 2014-12-26_09:26:33
Comment 7 Beluga 2015-01-12 17:39:29 UTC
Linux test results with repro steps from comment 5:
No problem with 3.5, so bibisecting can be done!
4.5 alpha gave the plug immediately on opening when answering "No" to link update.

Ubuntu 14.10 64-bit Version: 4.5.0.0.alpha0+
Build ID: 9763b55eb946cf425220d26dab91bf220890b180
TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2015-01-08_12:56:53

LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.