Description: Attached file has a chart data point where the marker was set to “None”. Instead of not displaying the data point, Calc displays a black square. Steps to Reproduce: 1. In Excel create a point chart and set a custom data point marker. I used a larger blue triangle. 2. Set one of the data point markers to None 3. Open the file in Calc Actual Results: The data point marker appears as a black square. Expected Results: The data point does not appear. If the marker setting is “None” at the data series level and there is a different setting at the data point level then the import works fine, see the Value2 Reproducible: Always User Profile Reset: No Additional Info: LibreOffice details: Version: 6.4.0.0.alpha0+ (x86) Build ID: 99971d009e9c96d1d47aec14ecfbfeaa06dc140d CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-06-18_03:59:27 Locale: hu-HU (hu_HU); UI-Language: en-US Calc: CL
Created attachment 152325 [details] Screenshot of the problem in Calc and Excel side by side
Created attachment 152326 [details] Example file from Excel
Confirm with Version: 6.3.0.0.beta1+ (x86) Build ID: 5cfac16dbd4af456a7fb6d52c8953c69a72ba2ba CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; and Version: 4.2.0.0.alpha1+ Build ID: fc8f44e82de4ebdd50ac5fbb9207cd1a59a927e3
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/2783a34899379dae84889c924e49481631280ab1%5E%21 tdf#126033 chart: hide removed marker of a single data point It will be available in 6.4.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.
Verified in Version: 6.4.0.0.alpha0+ Build ID: a294457eb95e60028539b6783abac78b56561fe2 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded @Balázs Varga, thanks for fixing this issue!!
Balazs Varga committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/+/2ba68f936669a6516eae8a8bff000131ac63f411%5E%21 tdf#126033 chart: hide removed marker of a single data point It will be available in 6.3.0.1. 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.
*** Bug 39926 has been marked as a duplicate of this bug. ***