Bug 165091 - bug report - libreoffice - calc - xyplot with several datalines - wont accept data descriptins which are individual for each dataline
Summary: bug report - libreoffice - calc - xyplot with several datalines - wont accept...
Status: RESOLVED DUPLICATE of bug 38760
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-02-07 01:48 UTC by michael.schumann.123
Modified: 2025-02-07 14:08 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file illustrating the problem (38.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-02-07 01:52 UTC, michael.schumann.123
Details
screenshots illustrating the step-by-step description (203.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-02-07 01:59 UTC, michael.schumann.123
Details
Workaround (33.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-02-07 13:48 UTC, Regina Henschel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description michael.schumann.123 2025-02-07 01:48:46 UTC
Description:
Hello all,

I hope I'm doing this the right way.
I want to file a bug report.

I've first put the topic for discussion on the German LibreOffice forum (https://www.libreoffice-forum.de/viewtopic.php?f=6&t=40478),
and the received feedback / recommendation was to place a bugreport.

At the link, you can also find a example file for illustrating the problem.

Since I'm using the German localized version, please don't get offended if my translation to English is a bit lopsided.



1) My system

Ubuntu LTS24.04
Libre Office - Calc - Version 24.2.7.2 (X86_64)
localization: German


2) What I want to achieve

Having a diagram plotting several (more than one) datalines.
Each dataline ist a list of several datasets (x-values, y-values, description).
The diagram should show for each dataline and each dataset (aka each x/y-point) the corresponding description.

3) What I've done 

enter the data to the cells in the calc sheet: e.g. data for four datalines

create a diagram (a plot?) of the type x/y-scatter subtype dots-connected-with-lines

at data source, pressing the "add" button four times to create 4 datalines
for each of these 4 data lines:
  select the button dataline/name and fill the field with the cell-index of the cell containing the dataline-name, using the select-by-mouse button
  select the button dataline/x-values and fill the field with the cell-indices of the cells containing the list of x-values, using the select-by-mouse button
  select the button dataline/y-values and fill the field with the cell-indices of the cells containing the list of y-values, using the select-by-mouse button
  fill the field called "data-description" with the cell-indices of the cells containing the list of descriptions, using the select-by-mouse button

What I noticed:
Each dataline has its individual name, x-values, y-values
But the data-description applies to all datalines together, it is NOT individual for each dataline.
If I e.g. enter cell-indices data to the data-description field for dataline 2, it is applied to all four data lines.

At the diagram by selecting (right mouse clicking) each of the 4 displayed data lines:
 enable the show-description option
 mouse rightclicking one of the shown descriptions (numbers)
 select button "edit data description" and sub-button "data description"
 default enabled is the option "value as number"
 disable this option
 enable the "category"  option

result:
only one of the four datalines can get the correct dot descriptions,
all other datalines just show the same descriptions which are wrong for them

4) my opinion

IMHO, the data-description field should be individual for each data line,
so that different datalines can have different descriptions.


Steps to Reproduce:
1) enter suitable data to the cells in a calc sheet
e.g. 4 datalines, each dataline:
  name
  list of n x-values
  list of n y-values
  list of n descriptions


2) create a diagram (a plot?) of the type x/y-scatter subtype dots-connected-with-lines

3) at data source page, pressing the "add" button four times to create 4 individual datalines to be displayed

4) for each of these 4 data lines:

4.1) select the button dataline/name and fill the field with the cell-index of the cell containing the dataline-name, using the select-by-mouse button
4.2) select the button dataline/x-values and fill the field with the cell-indices of the cells containing the list of x-values, using the select-by-mouse button
4.3) select the button dataline/y-values and fill the field with the cell-indices of the cells containing the list of y-values, using the select-by-mouse button
4.4) fill the field called "data-description" with the cell-indices of the cells containing the list of descriptions, using the select-by-mouse button

remark)
What I noticed:
Each dataline has its individual name, x-values, y-values
But the data-description applies to all datalines together, it is NOT individual for each dataline.
If I e.g. enter cell-indices data to the data-description field for dataline 2, it is applied to all four data lines.

5) At the diagram (the plot?) by selecting (right mouse clicking) each of the 4 displayed data lines:
 
5.1) enable the show-description option
5.2) mouse rightclicking one of the shown descriptions (numbers)
5.3) select button "edit data description" and sub-button "data description"
remark) default enabled is the option "value as number"
5.4) disable this option
5.5) enable the "category" option


Actual Results:
only one of the four datalines can get the correct dot descriptions,
all other datalines just show the same descriptions which are wrong for them



Expected Results:
each dot of each dataline gets the correct dot description

IMHO:

The data-description field should be individual for each data line,
so that different datalines can have different descriptions.

If I enter data-description cell indices data for e.g. dataline 2,
it should only be applied to dataline 2 and not to all other datalines.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
1) Please copy here the information from menu Help - About LibreOffice.

Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 12; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.2
Calc: threaded

2) You can also add other information that might be relevant

You can get / download a example file illustrating the problem here: 
https://www.libreoffice-forum.de/viewtopic.php?f=6&t=40478
Comment 1 michael.schumann.123 2025-02-07 01:52:49 UTC
Created attachment 199029 [details]
Example file illustrating the problem
Comment 2 michael.schumann.123 2025-02-07 01:59:49 UTC
Created attachment 199030 [details]
screenshots illustrating the step-by-step description
Comment 3 Regina Henschel 2025-02-07 13:48:54 UTC
Created attachment 199046 [details]
Workaround

A workaround this problem:
Arrange the series so, that you have a common column for the data labels.
Use for all data series the same rows as for all data labels together. 
Leave those cells that are not used for a data series empty.
Comment 4 Regina Henschel 2025-02-07 14:08:55 UTC

*** This bug has been marked as a duplicate of bug 38760 ***