[Libreoffice-bugs] [Bug 121074] New: Missing images in an XLSX on Linux and macOS (OK on Windows)

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121074

Bug ID: 121074
Summary: Missing images in an XLSX on Linux and macOS (OK on
Windows)
Product: LibreOffice
Version: 6.0.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@hotmail.com

Created attachment 146185
--> https://bugs.documentfoundation.org/attachment.cgi?id=146185&action=edit
Sample file with images missing on import on Linux/macOS

The attached sample has 3 images over cells A5, A6, and A7. They are visible in
MS Excel, and in LO on Windows; but when open in LO on Ubuntu 16.04, 18.04, or
on macOS, the images are missing [1].

Tested myself with Version: 6.1.2.1
Build ID: 1:6.1.2~rc1-0ubuntu0.18.04.1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); Calc:

Also tested on Windows to confirm that it shows images there with Version:
6.1.3.2 (x64)
Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb
CPU threads: 12; OS: Windows 10.0; UI render: GL;
Locale: ru-RU (ru_RU); Calc: CL

[1] Original report: http://forumooo.ru/index.php/topic,7353 (Russian)

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121074

--- Comment #1 from Mike Kaganski <***@hotmail.com> ---
Created attachment 146186
--> https://bugs.documentfoundation.org/attachment.cgi?id=146186&action=edit
Screenshot on Ubuntu 18.04

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121074

--- Comment #2 from Mike Kaganski <***@hotmail.com> ---
Created attachment 146187
--> https://bugs.documentfoundation.org/attachment.cgi?id=146187&action=edit
Screenshot on Windows 10

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121074

Jan-Marek Glogowski <***@fbihome.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
Ever confirmed|0 |1

--- Comment #3 from Jan-Marek Glogowski <***@fbihome.de> ---
First bugreport I see, where something is broken on all platforms _except_
Windows :-)

And I can confirm I don't see the included images on todays master, neither in
the document, nor in the navigator.

Version: 6.2.0.0.alpha1+
Build-ID: d72c915794eb4453dc580fc0dcdfbe3503a4879b
CPU-Threads: 64; BS: Linux 3.16; UI-Render: Standard; VCL: x11;
Gebietsschema: de-DE (de_DE.UTF-8); Calc: threaded

In the terminal I see:
warn:legacy.osl:19680:19680:oox/source/helper/graphichelper.cxx:119:
GraphicHelper::GraphicHelper - cannot get target frame

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121074

Oliver Brinzing <***@gmx.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@gmx.de

--- Comment #4 from Oliver Brinzing <***@gmx.de> ---
excel 2016 complains attached *.xslx is corrupted, will not open ....
seems to be created with Microsoft Excel Online/16.0300

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121074

--- Comment #5 from Mike Kaganski <***@hotmail.com> ---
(In reply to Oliver Brinzing from comment #4)

Just re-tested with Excel 2016 on Win10, and received no warnings/errors.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121074

--- Comment #6 from Oliver Brinzing <***@gmx.de> ---
Created attachment 146216
--> https://bugs.documentfoundation.org/attachment.cgi?id=146216&action=edit
ms excel 2016

tried again, same result ... opens fine with lo 6.1.3.1 ...

D:\>md5sum price_bitiy_obrazets-1.xlsx
10fdef01e4a87eb25fcc344917d5d9de *price_bitiy_obrazets-1.xlsx

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121074

--- Comment #7 from Oliver Brinzing <***@gmx.de> ---
excel tried top open file in protected view
(https://support.office.com/en-us/article/what-is-protected-view-d6f09ac7-e6b9-4495-8e43-2bbcdbcb6653)
and fails.
after changing file properties, it will open.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121074

Julien Nabet <***@yahoo.fr> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@yahoo.fr

--- Comment #8 from Julien Nabet <***@yahoo.fr> ---
Created attachment 146230
--> https://bugs.documentfoundation.org/attachment.cgi?id=146230&action=edit
console logs

On pc Debian x86-64 with master sources updated yesterday, I could reproduce
this.

I attached console logs:
warn:legacy.osl:3913:3913:oox/source/helper/graphichelper.cxx:119:
GraphicHelper::GraphicHelper - cannot get target frame
warn:oox:3913:3913:oox/source/drawingml/shapecontext.cxx:129:
ShapeContext::onCreateContext: unhandled element: 2146
warn:oox:3913:3913:oox/source/drawingml/shapecontext.cxx:129:
ShapeContext::onCreateContext: unhandled element: 2144
warn:legacy.osl:3913:3913:sc/source/filter/oox/worksheethelper.cxx:533:
WorksheetGlobals::getDrawPageSize - called too early, size invalid

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121074

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
OS|All |Linux (All)
CC| |***@libreoffice.org
Version|6.0.4.2 release |Inherited From OOo

--- Comment #9 from Xisco Faulí <***@libreoffice.org> ---
Seems to be inherit from OOo.
I see the images in

LibreOffice 3.3.0 Win
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

but not in

LibreOffice 3.3.0 Linux
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121074

Roman Kuznetsov <***@mail.ru> changed:

What |Removed |Added
----------------------------------------------------------------------------
Blocks| |108897


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker