Issue 123233 - images missing in cognos 10.1 generated .xlsx
Summary: images missing in cognos 10.1 generated .xlsx
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:
Depends on:
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: ---

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

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