Bug 124013 - FILESAVE XLSX Background fill of shapes disappear
Summary: FILESAVE XLSX Background fill of shapes disappear
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, filter:xlsx, regression
: 123108 (view as bug list)
Depends on:
Blocks: OOXML-Shapes
  Show dependency treegraph
 
Reported: 2019-03-12 08:07 UTC by NISZ LibreOffice Team
Modified: 2019-05-18 15:22 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel (15.53 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-03-12 08:08 UTC, NISZ LibreOffice Team
Details
The example file saved by LO 4.2 (12.49 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-03-12 08:09 UTC, NISZ LibreOffice Team
Details
The example file saved by LO 4.3 (12.61 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-03-12 08:09 UTC, NISZ LibreOffice Team
Details
The exported file on my current local build (117.89 KB, image/png)
2019-03-14 20:35 UTC, Gabor Kelemen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-03-12 08:07:22 UTC
Description:
Background fill of shapes in XLSX documents created with Microsoft Excel 2016 disappear when the document is exported in LibreOffice Calc 6.3.0.0.alpha0+ and opened in Excel 2016

Steps to Reproduce:
    1. Create a new document in Microsoft Excel.
    2. Insert Shapes.
    3. Save the file as XLSX
    4. Open the same file in LibreOffice Calc 
    5. Select File and Save As
    6. Name the file
    7. Open the exported file in Microsoft Excel
    8. Compare the original file opened in Excel and the exported file opened in Excel
    9. Notice, that the background fill of shapes are not visible.

Actual Results:
Background fill of shapes in XLSX documents created with Microsoft Excel 2016 disappear when the document is exported in LibreOffice Calc 6.3.0.0.alpha0+ and opened in Excel 2010

Expected Results:
Background fill of shapes should be visible as the original file opened in Microsoft Excel 2016


Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice details:
Version: 6.3.0.0.alpha0+
Build ID: 65438bcda46bab4f2fe6fb555f44aace45e11e5e
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: threaded

Also happens in:
Verzió: 4.3.0.4
Build az.: 62ad5818884a2fc2e5780dd45466868d41009ec0

But not with:
Verzió: 4.2.0.4
Build az.: 05dceb5d363845f2cf968344d7adab8dcfb2ba71
Comment 1 NISZ LibreOffice Team 2019-03-12 08:08:13 UTC
Created attachment 149904 [details]
Example file from Excel
Comment 2 NISZ LibreOffice Team 2019-03-12 08:09:01 UTC
Created attachment 149905 [details]
The example file saved by LO 4.2
Comment 3 NISZ LibreOffice Team 2019-03-12 08:09:45 UTC
Created attachment 149906 [details]
The example file saved by LO 4.3
Comment 4 Durgapriyanka 2019-03-12 17:36:20 UTC
thank you for reporting the bug. I cannot reproduce the bug in

Version: 6.3.0.0.alpha0+
Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 5 Xisco Faulí 2019-03-14 18:18:34 UTC
I can't reproduce it in

Version: 6.3.0.0.alpha0+
Build ID: c196d70337f6b755cfc4c34beda05554c6fab114
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

nor in

Versión: 6.2.2.1
Id. de compilación: fcd633fb1bf21b0a99c9acb3ad6e526437947b01
Subprocs. CPU: 1; SO: Windows 6.1; Repres. IU: predet.; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES
Calc: threaded

with MSO 2010

@NISZ Team, are you sure you attached the correct file ?
Comment 6 Gabor Kelemen 2019-03-14 20:34:10 UTC
Oh, the description is a bit wrong :(

Instead of opening the LO-exported file in Excel, you should open it in Calc.

In Excel the shapes would stay visible, but in Calc they "lose" their fill color.

They are still present in the Navigator: under Drawing objects you can select them, and switching to the Properties side bar panel you can see they don't have any fill attribute set.

This begun sometime between 4.2 and 4.3.
Comment 7 Gabor Kelemen 2019-03-14 20:35:39 UTC
Created attachment 149978 [details]
The exported file on my current local build

Here setting a fill color would bring back the shape.
Comment 8 Regina Henschel 2019-03-14 21:45:29 UTC
It seems the theme-color information is lost. If you do not use theme-colors in Excel, but use an own color, this is retained in LibreOffice.

The shape has a fill and stroke color 'white' for me.
Comment 9 Buovjaga 2019-04-09 17:34:38 UTC
Bibisected with Linux 43max to range https://gerrit.libreoffice.org/plugins/gitiles/core/+log/160db96a882a2be8c3307e8a04beda4ae93a13c4..6069b5162281ccc88eb242991a115197d0893fb4

I don't see what it could be. There were two bad results: shapes gone and only fill gone. I targeted only fill gone, because it was older.
Comment 10 Buovjaga 2019-04-10 18:11:13 UTC
Bibisected with the new win32-4.3 to https://gerrit.libreoffice.org/plugins/gitiles/core/+/bc0a9076aa43a0782bcf81e55d3f84f6af0f68e8%5E!/
ooxml: Preserve shape theme attribute for solid fill

Same one blamed for bug 91332 and bug 103478
Comment 11 Buovjaga 2019-04-14 08:14:10 UTC
*** Bug 123108 has been marked as a duplicate of this bug. ***
Comment 12 Xisco Faulí 2019-05-18 15:21:34 UTC
Still reproducible in

Version: 6.3.0.0.alpha1+
Build ID: 787525a314de9c8178d0fedcd71ddbd08ec41a55
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

@Tamás, since you fixed bug 125346, I thought you could be interested in this issue...
Comment 13 Xisco Faulí 2019-05-18 15:22:15 UTC
@Tamás, since you fixed bug 125346, I thought you could be interested in this issue...