Bug 112528 - Can't make chart with specific information in a dynamic table
Summary: Can't make chart with specific information in a dynamic table
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.1.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: implementationError
Depends on:
Blocks: Pivot-Chart
  Show dependency tree / graph
 
Reported: 2017-09-20 14:35 UTC by Julian
Modified: 2023-02-25 03:23 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

Attachments
Is the example of make pie charts with the data in a dynamic table. (46.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-09-20 15:00 UTC, Julian 		Details
One way (27.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-09-21 15:36 UTC, Jacques Guilleron 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Julian 2017-09-20 14:35:52 UTC 
Description:
I recent installed the last new LibreOffice 5.4.1, and I have to make a dynamic table with information that I copy and paste in a spreadsheet. For example my dynamic table has 3 columns: type, quantity of values and sum of values, and I have to make two charts: quantity per type and sum per type. If I want to make a pie chart showing the type and the sum of values, Calc doesn't make the chart based on the sum, but the quantity. I have to make two dynamic tables separately: one with type and quantity, and other with type and sum, to make my graphics well. The above doesn't happen with stable LibreOffice 5.3.6. Thanks.

Steps to Reproduce:
1. Make a table in spreadsheet with three columns with data (for example type, quantity and sum).

2. Select the whole table and make dynamic table in a new spreadsheet where the row field is 'type' column, and the data fields are the sum of 'sum' column, and the quantity of 'quantity' column. The result have to be a table with the the sum and quantity data related to the 'type' column.

3. Select the data and try to make two pie charts: one showing the quantity per type, and other one showing the sum per type.

Actual Results:  
The type per sum chart is good but can't make the quantity per type chart because Calc only takes the first one data.

Expected Results:
Have two charts with selected information.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:55.0) Gecko/20100101 Firefox/55.0
Comment 1 Julian 2017-09-20 15:00:38 UTC 
Created attachment 136402 [details]
Is the example of make pie charts with the data in a dynamic table.
Comment 2 Jacques Guilleron 2017-09-21 15:36:50 UTC 
Created attachment 136435 [details]
One way
Comment 3 Jacques Guilleron 2017-09-21 15:38:46 UTC 
Hi Julian

I achieve it by extracting A2:C5 from dynamic table, then selecting Type and Quantity to create the first pie chart, and Type and Sum for the second one.
See attachemnt.

Is it what you are looking for?
Comment 4 Julian 2017-10-06 19:01:42 UTC 
Hello Jacques, thanks for your answer.

Apparently, what you did is another solution: take the needed information of the dynamic table, copy and paste it in another page and make the charts with the copy-pasted information, but that means (in my oppinion) more steps to follow. The matter is when you want to make the same thing but selecting directly the information from the dynamic table, not taking the info apart. With LibreOffice 5.3.6 it works, without separate the data from the dynamic table.

Thank you for the attention.



LibreOffice 5.4.1.2
Comment 5 raal 2017-10-08 07:41:47 UTC 
New feature in 5.4 - https://wiki.documentfoundation.org/ReleaseNotes/5.4#Chart
Comment 6 Julian 2017-10-13 22:57:47 UTC 
Thanks raal, maybe that new feature is the cause of the bug I spoke.
Comment 7 Buovjaga 2017-11-04 19:32:21 UTC 
(In reply to Julian from comment #6)
> Thanks raal, maybe that new feature is the cause of the bug I spoke.

I think raal was suggesting that you try Pivot charts as a solution. Please read the blog posts in the link and try them out.
Comment 8 Regina Henschel 2017-11-04 23:05:30 UTC 
I consider it as bug, that it is not possible to choose the data series, if the chart is a Pie-chart.

Hi Julian, here a workaround. Unfortunately it is not stable and will fall back to default, if you use filter or change data.

A Pie-chart can only show one data series. Here it uses that data series, which is the outer-one in a Donut-chart. So for to get "sum" into the Pie-chart, mark all three columns: type, quantity and sum, and generate a Donut-chart or switch the chart type to Donut-chart in case of an existing chart. Activate the chart for editing. As default "quantity" is the outer one, "sum" is the inner one. Enable Data labels with number and category to verify it. Click on the inner series and then use menu Format item Arrangement and "Bring Forward". Now "sum" should be outer and "quantity" inner ring. As last step change the chart type to Pie-chart.
Comment 9 Julian 2017-11-22 19:18:37 UTC 
(In reply to Regina Henschel from comment #8)
> I consider it as bug, that it is not possible to choose the data series, if
> the chart is a Pie-chart.
> 
> Hi Julian, here a workaround. Unfortunately it is not stable and will fall
> back to default, if you use filter or change data.
> 
> A Pie-chart can only show one data series. Here it uses that data series,
> which is the outer-one in a Donut-chart. So for to get "sum" into the
> Pie-chart, mark all three columns: type, quantity and sum, and generate a
> Donut-chart or switch the chart type to Donut-chart in case of an existing
> chart. Activate the chart for editing. As default "quantity" is the outer
> one, "sum" is the inner one. Enable Data labels with number and category to
> verify it. Click on the inner series and then use menu Format item
> Arrangement and "Bring Forward". Now "sum" should be outer and "quantity"
> inner ring. As last step change the chart type to Pie-chart.

Hello Regina, thanks a lot for your answer. It is a solution, but my intention was to show the bug to the responsible who handle LibreOffice development, and so they may consider to give a solution for the bug to avoid it happen again in future versions. As I said, in LibreOffice 5.3.6 that bug doesn't exists, so there is no matter about. I really appreciate the interest gave on my suggestion. Thanks.
Comment 10 raal 2017-11-23 10:50:46 UTC 
(In reply to Buovjaga from comment #7)
> (In reply to Julian from comment #6)
> > Thanks raal, maybe that new feature is the cause of the bug I spoke.
> 
> I think raal was suggesting that you try Pivot charts as a solution. Please
> read the blog posts in the link and try them out.

No, I think it's pivot chart's implementation error. In 5.3 pivot charts didn't exist, it's new feature of version 5.4. Tomaž, could you take a look at this? Thank you
Comment 11 Aron Budea 2018-02-23 02:31:15 UTC 
I assume this bug is still there, so the bug report should be kept open.
Comment 12 QA Administrators 2019-02-24 03:40:48 UTC Comment hidden (obsolete)
Comment 13 QA Administrators 2021-02-24 04:04:26 UTC Comment hidden (obsolete)
Comment 14 QA Administrators 2023-02-25 03:23:56 UTC 
Dear Julian,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug