Bug 126033 - FILEOPEN XLSX Chart data point marker setting “None” imported incorrectly
Summary: FILEOPEN XLSX Chart data point marker setting “None” imported incorrectly
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: All All
: medium normal
Assignee: Balázs Varga
URL:
Whiteboard: target:6.4.0 target:6.3.0.1
Keywords: filter:xlsx
: 39926 (view as bug list)
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
 
Reported: 2019-06-21 08:46 UTC by NISZ LibreOffice Team
Modified: 2019-09-01 09:27 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot of the problem in Calc and Excel side by side (128.63 KB, image/png)
2019-06-21 08:47 UTC, NISZ LibreOffice Team
Details
Example file from Excel (20.26 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-06-21 08:48 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-06-21 08:46:29 UTC
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
Comment 1 NISZ LibreOffice Team 2019-06-21 08:47:40 UTC
Created attachment 152325 [details]
Screenshot of the problem in Calc and Excel side by side
Comment 2 NISZ LibreOffice Team 2019-06-21 08:48:02 UTC
Created attachment 152326 [details]
Example file from Excel
Comment 3 raal 2019-06-21 11:25:19 UTC
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
Comment 4 Commit Notification 2019-06-26 09:01:30 UTC
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.
Comment 5 Xisco Faulí 2019-06-28 12:12:09 UTC
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!!
Comment 6 Commit Notification 2019-06-28 12:33:47 UTC
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.
Comment 7 Gabor Kelemen (allotropia) 2019-09-01 09:27:33 UTC
*** Bug 39926 has been marked as a duplicate of this bug. ***