Issue 123233 - images missing in cognos 10.1 generated .xlsx
Summary: images missing in cognos 10.1 generated .xlsx
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: 4.0.0
Hardware: All Windows, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-09-11 08:15 UTC by e3k
Modified: 2013-09-12 06:59 UTC (History)
2 users (show)

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

Attachments
a cognos generated report with charts = images (12.65 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-09-11 08:15 UTC, e3k 		no flags Details
the images should look like this (39.65 KB, image/png)
2013-09-11 08:17 UTC, e3k 		no flags Details
Excel 2007 vs. Calc 4.0 (246.83 KB, image/jpeg)
2013-09-11 10:52 UTC, Edwin Sharp 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description e3k 2013-09-11 08:15:25 UTC 
Created attachment 81516 [details]
a cognos generated report with charts = images

Problem description: 

Steps to reproduce:
1. open the attached .xlsx
2. observe the blank placeholders where the images should be

Current behavior:
no showing images

Expected behavior:
should show images
Comment 1 e3k 2013-09-11 08:17:19 UTC 
Created attachment 81517 [details]
the images should look like this
Comment 2 Edwin Sharp 2013-09-11 10:52:36 UTC 
Created attachment 81519 [details]
Excel 2007 vs. Calc 4.0
Comment 3 Edwin Sharp 2013-09-11 10:52:55 UTC 
Confirmed with Rev. 1520602 Win 7.
Comment 4 Rob Weir 2013-09-12 00:16:55 UTC 
When I open the chart.xslx file in MS Office 2013 I get a message:  "We found a problem with some content in 'charts.xlsx'.  Do you want us to try to recover as much as we can?  If you trust the source of this workbook, click Yes."

If I click Yes I get a dialog "Repairs to 'charts.xlsx'" saying:

"Excel was able to open the file by repairing or removing the unreadable content.  Removed Part:: /xl/drawings/drawing1.xml part. (Drawing shape)"

At that point the file renders, but without the charts, like the way AOO does.

This was with Microsoft Office 2013 on 64-bit Windows 8.

But it sounds like it worked OK for Edwin with Office 2007.   Strange.
Comment 5 Oliver-Rainer Wittmann 2013-09-12 06:59:02 UTC 
I observed the following on my 64bit Windows 7:
- opening the document in 
-- AOO --> the same as reporter and Edwin have reported.
-- Microsoft Excel 2007 and Microsoft Excel 2010 --> fine, charts/images are shown
-- Microsoft Excel 2013 --> the same as Rob has reported.
- I opened the document in Microsoft Excel 2007 and saved it without any change. This saved document opens fine in AOO and Microsoft Excel 2013