Created attachment 138243 [details]
Example file made with Excel 2013
If we create a simple “Points and Lines” Chart in Microsoft Excel 2013/2016 and add a drop line to the diagram, Calc will not display the drop line because this concept does not exist.
Steps to reproduce:
1. Create a new spreadsheet in Excel 2013/2016.
2. Create a simple “Points and Lines” Chart.
3. Add drop line to the diagram.
4. Save the spreadsheet in xlsx.
5. Open the file in LibreOffice Calc.
The drop line disappears from the diagram.
The drop line should not disappear from the diagram.
Created attachment 138244 [details]
The example file in Excel and Calc side by side
I reproduce with
LO 22.214.171.124.alpha0+ Build ID: cc1db6f2b0ebe05ae807628778835b62df00eca2
CPU threads: 2; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@42, Branch:master, Time: 2017-12-02_23:45:34
Locale: fr-FR (fr_FR); Calc: CL
The closest feature is the vertical grids.
Actually this can be considered a duplicate too.
*** This bug has been marked as a duplicate of bug 77131 ***