Download it now!
Bug 132280 - FORMCONTROLS Data Labels for the Data Points ignore Data Labels field
Summary: FORMCONTROLS Data Labels for the Data Points ignore Data Labels field
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-04-20 18:04 UTC by George 2.0 Hope
Modified: 2020-08-28 13:36 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
SpreadSheet containing the problem described. (14.20 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-04-20 18:06 UTC, George 2.0 Hope
Details
Contains a screenshot containing the appropriate dialog box. (64.32 KB, image/png)
2020-04-20 18:07 UTC, George 2.0 Hope
Details

Note You need to log in before you can comment on or make changes to this bug.
Description George 2.0 Hope 2020-04-20 18:04:46 UTC
Description:
When you create an XY chart, and wish to create data labels for each point; LO Calc ignores whatever you use in the [Data Labels] textbox of the [Data Ranges] dialog box for the chart.

Note:  I am not 100% that FORMCONTROLS is the correct label above, it just seemed the closest option.

Steps to Reproduce:
1.Enter two columns of numerical values for xy values, enter a third column of same length for the [Data Labels] (i.e. A, B, C, D, E, ...)
2.Highlight the data; Insert > Chart; correct the wizards guesses for [Data Ranges], [Range for X&Y Values], & [Data Labels]
3.Double click the chart to enter the chart editing mode; single click on a data point (which will select all the data points) and right click & select [Insert Data Labels].

Actual Results:
It will then show only the Y-axis values of each data point & not use the information provided in the [Data Labels] field.

Expected Results:
It should use the values indicated in the [Data Labels] field, for each data point.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
It should use the values indicated in the [Data Labels] field, for each data point.

Note:  This bug should not be affected by user profiles; so I did not reset my profile.

System Info:

Version: 6.3.5.2 (x64)
Build ID: dd0751754f11728f69b42ee2af66670068624673
CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded


Renderer: GeForce GT 730/PCIe/SSE2
Vendor: NVIDIA Corporation
Version: 4.6.0 NVIDIA 441.12
Shading language version: 4.60 NVIDIA
v3.0 (100 % - 23/23)v3.1 (100 % - 7/7)v3.2 (100 % - 10/10)v3.3 (100 % - 10/10)v4.0 (100 % - 14/14)v4.1 (100 % - 7/7)v4.2 (100 % - 13/13)v4.3 (100 % - 20/20)v4.4 (100 % - 10/10)v4.5 (100 % - 11/11)v4.6 (100 % - 11/11)vARB 2015 (41 % - 5/12)
Comment 1 George 2.0 Hope 2020-04-20 18:06:22 UTC
Created attachment 159769 [details]
SpreadSheet containing the problem described.
Comment 2 George 2.0 Hope 2020-04-20 18:07:38 UTC
Created attachment 159770 [details]
Contains a screenshot containing the appropriate dialog box.
Comment 3 Buovjaga 2020-08-26 17:34:06 UTC
In the dialog for formatting data labels, in the Data Labels tab, tick the box "Show category".

Arguably this could be explained more clearly in the Help https://help.libreoffice.org/latest/en-US/text/schart/01/04030000.html and Calc Guide https://documentation.libreoffice.org/en/english-documentation/
Comment 4 Buovjaga 2020-08-28 13:36:06 UTC
(In reply to Buovjaga from comment #3)
> In the dialog for formatting data labels, in the Data Labels tab, tick the
> box "Show category".
> 
> Arguably this could be explained more clearly in the Help
> https://help.libreoffice.org/latest/en-US/text/schart/01/04030000.html and
> Calc Guide https://documentation.libreoffice.org/en/english-documentation/

The upcoming Calc Guide now has improvements https://listarchives.libreoffice.org/global/documentation/2020/msg01735.html