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
Still same in own build: Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d76f736a89eb2a36b342a1a41ea6ced26d87692e CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: CL threaded The improvements in 24.8 don't seem to have helped here: https://wiki.documentfoundation.org/ReleaseNotes/24.8#Chart
(In reply to NISZ LibreOffice Team from comment #8) Another recheck: going through sheets in workbook from attachment 138121 [details]: ╔═══════════════════╦════════════════════════╦════════════════════════╗ ║ Sheet ║ LO* ║ LO Dev** ║ ║ ║ 28.8.1.1 ║ 26.2.0.0.alpha0+ ║ ╠═══════════════════╬════════════════════════╬════════════════════════╣ ║ 1) Original ║ OK ║ OK ║ ╠═══════════════════╬════════════════════════╬════════════════════════╣ ║ 2) Solid Color ║ Rendered proper color, ║ Rendered proper color, ║ ║ ║ but without margins* ║ but without margins* ║ ╠═══════════════════╬════════════════════════╬════════════════════════╣ ║ 3) Gradient ║ Not imported ║ Not imported ║ ╠═══════════════════╬════════════════════════╬════════════════════════╣ ║ 4) Material ║ Not imported ║ Not imported ║ ╠═══════════════════╬════════════════════════╬════════════════════════╣ ║ 5) Pattern ║ Imported, ║ Not imported ║ ║ ║ but without margins ║ ?REGRESSION? ║ ╠═══════════════════╬════════════════════════╬════════════════════════╣ ║ 6) Border ║ Imported, ║ Not imported ║ ║ ║ but without margins ║ ║ ║ ║ (lines close to text) ║ ║ ╠═══════════════════╬════════════════════════╬════════════════════════╣ ║ 7) GradientBorder ║ Not imported ║ Not imported ║ ╠═══════════════════╩════════════════════════╩════════════════════════╣ ║ https://www.tablesgenerator.com/text_tables# ║ ╚═════════════════════════════════════════════════════════════════════╝ *2) It seems like it's implemented as text highlighting and not the text frame. * Version: 25.8.1.1 (X86_64) Build ID: 54047653041915e595ad4e45cccea684809c77b5 CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: CL threaded ** Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: b33cc5a7388c1739ff4a02a84751800f3e3086ce CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: CL threaded https://dev-builds.libreoffice.org/daily/master/Win-x86_64@tb77-TDF/2025-09-12_03.31.47/ Can anyone confirm that 5) Pattern is NOT IMPORTED in LO Dev? So there is another thing to handle: MARGINS of labels.