https://bugs.documentfoundation.org/show_bug.cgi?id=165091
Bug ID: 165091
Summary: bug report - libreoffice - calc - xyplot with several
datalines - wont accept data descriptins which are
individual for each dataline
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
