Created attachment 138121 [details] Example file made with Excel 2013 Microsoft Excel 2013 offers many customization options for chart data labels that are not interpreted by LibreOffice Calc, including fill properties and effects. Steps to reproduce: 1. Create a new spreadsheet in Microsoft Excel 2013. 2. Create a simple chart (a column chart with default settings will do) based on any values. 3. Turn on Data Labels and change the fill properties or add effects. 4. Save the file as XLSX. 5. Open the file in LibreOffice Calc. Actual results: The custom data label properties will not be interpreted. Expected results: The custom data label properties should be be interpreted.
Created attachment 138123 [details] The example file in Excel and Calc side by side
I guess we should set this as an enhancement Version: 6.1.0.0.alpha0+ (x64) Build ID: cc1db6f2b0ebe05ae807628778835b62df00eca2 CPU threads: 4; OS: Windows 10.0; UI render: default; TinderBox: Win-x86_64@42, Branch:master, Time: 2017-12-03_00:59:10 Locale: fi-FI (fi_FI); Calc: group threaded
Yes, background settings are missing, but border is imported. This is common feature not only xlsx filter but also pptx and docx (where chart can be placed in general). Code pointers, here code should be modified: https://opengrok.libreoffice.org/xref/core/oox/source/drawingml/chart/seriesconverter.cxx#248 probably it can be done similar to importBorderProperties: https://opengrok.libreoffice.org/xref/core/oox/source/drawingml/chart/seriesconverter.cxx#185 Data label properties are defined here: offapi/com/sun/star/chart2/DataPointProperties.idl
*** Bug 127395 has been marked as a duplicate of this bug. ***
(In reply to Szymon Kłos from comment #3) > Yes, background settings are missing, but border is imported. Not really. Border is only imported, if the user has set the line width explicitly in MS Office.
*** Bug 131175 has been marked as a duplicate of this bug. ***
(In reply to Gabor Kelemen from comment #6) > *** Bug 131175 has been marked as a duplicate of this bug. *** Changing from duplicate to blocker (as in one of many pieces of this puzzle).
A quick recheck on this: - Solid color and Pattern fill are imported now - Gradient and Material (Bitmap in LO terms) fill are still not imported - Solid color border works - Gradient border is still not imported - but this feature does not even exist in LO.
Have you looked into shadows? That does not appear to be working in LibreOffice either, cf. bug #134995. (I am not adding this as a dependency to this bug, but if you agree, that'd probably make sense?)
(In reply to Gerald Pfeifer from comment #9) > Have you looked into shadows? > > That does not appear to be working in LibreOffice either, cf. > bug #134995. Shape effects such as shadow, glow, soft edges, 3-D formats[1] as far as we see are not a supported feature for chart shapes in LO. [1] see the first screenshot for example here: https://www.e-iceblue.com/Tutorials/Spire.Presentation/Spire.Presentation-Program-Guide/Chart/Add-Shadow-Effect-to-Chart-DataLabels-in-PowerPoint-in-C.html