Description: In Excel 2010 the default automatic line chart markers are different in shape and color. When opening and saving the example file in current LO master the shapes are all converted to a square. In Excel 2013 the default markers are different only in color and the shape is a dot, which is retained on LO export. Steps to Reproduce: 1. Create a line chart in Excel 2010 with many data rows 2. Notice they get the Automatic marker setting which gets a different shape 3. Open and save the file in Calc Actual Results: On saving all previously different shapes become a square. Also Excel indicates this is not “automatic” type but built-in, i.e. customly set. In case of the Excel 2013 file the type changes to built-in too. However since there was no difference between shapes to begin with, the built-in dot shape is not visually different from the original automatic type dot shape. Expected Results: The “automatic” type setting is retained. Reproducible: Always User Profile Reset: No Additional Info: LibreOffice details: Version: 6.4.0.0.alpha0+ (x86) Build ID: 4808ae1c73597726c89936f5b9cb3f11c9a4a7bf CPU threads: 4; OS: Windows 6.3; UI render: GL; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-06-24_23:50:55 Locale: hu-HU (hu_HU); UI-Language: en-US Calc: CL
Created attachment 152381 [details] Example file from Excel 2010
Created attachment 152382 [details] Example file from Excel 2013
Created attachment 152383 [details] The Excel 2010 example file saved by LO master
Created attachment 152384 [details] The Excel 2013 example file saved by LO master
Created attachment 152385 [details] The two original Excel files side by side in Excel
Created attachment 152386 [details] The two original Excel files side by side in Calc
Created attachment 152387 [details] The two exported files side by side in Calc
Created attachment 152388 [details] The two exported files side by side in Excel
confirm in Version: 6.4.0.0.alpha0+ (x64) Build ID: c0d1bdbb8a9aca2ef2e475268a953da995567700 CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-06-22_23:10:51 Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded and in Версия: 4.4.7.2 ID сборки: f3153a8b245191196a4b6b9abd1d0da16eead600 Локаль: ru_RU
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/bae73c0726e7fdf7f427a8254c9d6d4b4c510daf tdf#126076 XLSX export: fix automatic line chart markers It will be available in 7.0.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.