Description: A histogram chart created from multiple series of data is displayed partly as a histogram, partly as a column chart. This results in assorted kinds of odd behavior and the result can be difficult to interpret. Steps to Reproduce: 1. Open the attached file "histogram-multiple-series.ods". Alternatively: 1. Create a spreadsheet with multiple series of data. 2. Select multiple series. 3. Select "Insert chart", then "Histogram". Actual Results: As shown in the attached screenshot, the histogram (in this case, with two bins) formed from the first series of data shows up in the left side of the chart. The other series show up as normal column charts, on the same axes. Expected Results: Probably one of the following behaviors would be best: 1. Only the first series should be rendered and the rest should be ignored, as is the case with pie charts. 2. Each series should be rendered as its own histogram, with consistent binning across the series. 3. All the data in all series should be considered together, and rendered as a single histogram. Reproducible: Always User Profile Reset: No Additional Info: Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 4daebb60c4a222e9af8c0d8c66a653573cd9e7a2 CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Created attachment 197334 [details] File demonstrating the problem
Created attachment 197335 [details] Rendering of the example file in LO
Please attach the sample file with chart, to see how it is defined.
Ah, it appears that save/load does not work properly for histogram charts. So that's another problem. However, it should be possible to reproduce this bug by opening the histogram-multiple-series.ods file, deleting the (empty) chart, selecting all the data, and then inserting a histogram chart using that data.
Created attachment 197358 [details] File sample modified. I can't find issues saving. Your sample file, I think working fine.
The "File sample modified" attached shows a column chart, not a histogram chart.
Right, isn't it ok to change the type to histogram?
It should round-trip (save and load) properly as a histogram chart. The user shouldn't have to change the chart type in order to save and re-load.
Created attachment 197381 [details] Sample file as histogram The previous modified sample was saved as columns, not as histogram.
The histogram load-save problem is tdf#163727.
*** This bug has been marked as a duplicate of bug 163727 ***
It is a duplicate, there is no fix here. Why do you change the status? *** This bug has been marked as a duplicate of bug 163727 ***
Amending the "steps to reproduce", to avoid confusion ============ Description: A histogram chart created from multiple series of data is displayed partly as a histogram, partly as a column chart. This results in assorted kinds of odd behavior and the result can be difficult to interpret. Steps to Reproduce: 1. Create a spreadsheet with multiple series of data. 2. Select multiple series. 3. Select "Insert chart", then "Histogram". Note that because of https://bugs.documentfoundation.org/show_bug.cgi?id=163727, it's not possible to reproduce the problem at this time by loading a saved file. Actual Results: As shown in the attached screenshot, the histogram (in this case, with two bins) formed from the first series of data shows up in the left side of the chart. The other series show up as normal column charts, on the same axes. Expected Results: Probably one of the following behaviors would be best: 1. Only the first series should be rendered and the rest should be ignored, as is the case with pie charts. 2. Each series should be rendered as its own histogram, with consistent binning across the series. 3. All the data in all series should be considered together, and rendered as a single histogram. Reproducible: Always User Profile Reset: No Additional Info: Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 4daebb60c4a222e9af8c0d8c66a653573cd9e7a2 CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Repro Arch Linux 64-bit Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ccb96251ea15c3252010416377dd185205206cbd CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: kf6 (cairo+wayland) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: CL threaded Built on 12 November 2024