Calc issue: green display bug

users
#1

Hi,

I've a display bug with the attached xlsx file: a bad green splash as you can see on attached screenshot.
I've opened the file with 3 versions of Calc (4.2.8, 4.3.5 and 4.4.0.2), but this strange bug is still there.

How to fix it?

Best regards

#2

Eric,

Sorry, the ML does not pass through attachments. Either provide a hosted
location for your screen clip, or use the Nabble interface and insert, or
upload and link.

http://nabble.documentfoundation.org/Users-f1639498.html

Stuart

#3

Sorry I didn't knew:

- here is the xlsx file: http://demo.ovh.eu/download/a148c18ea657f9a5a1cf506f7fc4a5e7/green.xlsx
- here is the screenshot: http://i.imgur.com/x7KafJZ.png

Hope it works now :slight_smile:

Best regards

#4

Hello,

There is an image into the spreadsheet, the label of "Agriculture
Biologique", which isn't well decompressed by LO. I assume this can be
catalogued as a bug, for which you can file a bug entry.

Met vriendelijke groeten, Salutations distinguées, Kind Regards,

DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer

TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
Watch our company movies on www.tvh.tv

#5

As you say opening the xlsx file in LO does produce the green splash
caused by multiple renderings of an embedded image.

I ran two alternative tests:

1. Opened the file in Excel 2013 and (as expected) it displayed
correctly. However, there was no visual evidence of the image. I then
extracted the contents of the file and removed the image.
When I reopened the modified file in Excel the file still displayed
correctly, which suggests that the image served no useful purpose, or
Excel somehow auto-adjusted to the image's removal.
When I reopened the modified file in LO the green splash was gone, but
LO interpreted the file structure by replacing what was the image with
multiple place holders. While the green splash is inconvenient and
annoying, my main concern would be that, with or without the embedded
image, LO did not render the drop-down list boxes in column B.

2. Opened a fresh copy of the file in Excel 2013 and saved it in ods
format. Opened the ods file (which still contained the embedded image)
in LO and the file displayed correctly, including the the drop-down list
boxes in column B.

I don't know what, if any, purpose the embedded image serves, but it
seems like it would be worthwhile filing a bug report.

If it would be of any assistance, I can send you repaired copies of the
file in both ods & xlsx format.

Dave

#6

Hi Dave,

I've opened one (https://bugs.freedesktop.org/show_bug.cgi?id=88592), feel free to add your precious explanations :slight_smile: