Created attachment 138131 [details]
Example file made with Calc
Many Chart Legend properties are not preserved when the spreadsheet is saved as XLSX, including Gradient, Bitmap, Pattern and Hatch area fills, transparencies with gradient and border line styles different from Continuous. The custom size of the chart legend isn't preserved either, but that's a different bug.
Steps to reproduce:
1. Create a new spreadsheet in LibreOffice Calc.
2. Create a simple chart (a column chart with default settings will do) based on any values.
3. Change the area fill of the chart legend to bitmap, pattern, hatch, transparent with gradient, or the Border line style to something different from Continuous.
4. Save the file as XLSX.
5. Reload the file.
The custom chart legend property will be lost.
The custom chart legend property should be preserved.
Created attachment 138132 [details]
The example file saved by LO6 alpha in XLSX
Created attachment 138133 [details]
The example files in Calc side by side
Just a check: you did test in MS Excel that it supports creating this stuff?
Version: 188.8.131.52.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
Created attachment 138213 [details]
Example file made with Excel 2013
Similar example file from Excel.
Created attachment 138214 [details]
The Excel-made example saved in LO6 alpha
If we set a few chart legend properties in Excel, then open the file and save it in LO, we get:
- Solid color and border roudtrips fine
- Gradient, bitmap, pattern, image, transparency+gradient opens fine, but disappears after saving.
Created attachment 138912 [details]
Example .xlsx file created by Office 2013, with legend with gradient
This bug has been in ASSIGNED status for more than 3 months without any
activity. Resetting it to NEW.
Please assigned it back to yourself if you're still working on this.
Created attachment 143679 [details]
Example file with gradients in legend, PlotArea, Chart and axis created with MS Office 2013
Created attachment 143680 [details]
Example file with patterns in legend, PlotArea, Chart and axis created with MS Office 2013
Created attachment 143681 [details]
Example XLS file with patterns in legend, PlotArea, Chart and axis created with MS Office 201
*** This bug has been marked as a duplicate of bug 108078 ***