Download it now!
Bug 61185 - Calc Charts: Non-contiguous category ranges
Summary: Calc Charts: Non-contiguous category ranges
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
3.5.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: possibleRegression
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2013-02-20 19:27 UTC by tmacalp
Modified: 2020-09-19 23:03 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Example of non-contiguous calc chart category bug (23.59 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-02-20 19:27 UTC, tmacalp
Details
Screenshot of chart category bug (120.16 KB, image/jpeg)
2013-02-26 17:20 UTC, tmacalp
Details
Screenshot of correct (previous) behavior for chart categories (135.93 KB, image/jpeg)
2013-02-26 17:27 UTC, tmacalp
Details

Note You need to log in before you can comment on or make changes to this bug.
Description tmacalp 2013-02-20 19:27:50 UTC
Created attachment 75197 [details]
Example of non-contiguous calc chart category bug

This bug appears to be similar to 53300, but doesn't seem to match exactly. Sorry if it does turn out to be a duplicate.

When working with non-contiguous data ranges, I am able to get the proper behavior for the actual data for a chart, but not for the category labels.  It seems to concatenate the second range with each item in the first range and then associate that value with only the items in the first data range.  I'm having a rather difficult time describing the bug, so I've included an example spreadsheet.

I am using commas to separate the compound ranges such as A2:A13,C2:C13.  I did experience difficulties with defining the non-contiguous charts when using the create chart wizard.  I had to manually modify the data ranges after it was created. But I guess that part has more to do with bug 53300.

I'm not sure when this bug showed up, but I know this behavior worked correctly back in OpenOffice 3.2.1.  I am currently experiencing this bug using LibreOffice 3.6.5.2 from the main Arch Linux repo.
Comment 1 tmacalp 2013-02-26 17:20:56 UTC
Created attachment 75584 [details]
Screenshot of chart category bug

I've added a screenshot of the bug using LibreOffice 3.6.5.2. 

As you can see, the same syntax is used in both the Y-Values field and the Categories field.  The Y-Values are accepted and add data points to the chart.  Each item in the second range of categories is just appended to the each item in the first set of categories.
Comment 2 tmacalp 2013-02-26 17:27:28 UTC
Created attachment 75585 [details]
Screenshot of correct (previous) behavior for chart categories

Here is a screenshot of the same document loaded in OpenOffice 3.2.1 for an example of how it should behave.
Comment 3 ign_christian 2013-06-10 09:14:45 UTC
I can confirm reproducible on LO 4.0.4.1 (Win7 32bit)

In my opinion Bug 53300, also Bug 55697 is about selecting data beyond existing that is previously impossible. At present it's possible but wrong result.
Comment 4 stragu 2013-11-01 07:42:45 UTC
I can confirm this is still present in 4.1.2.3

Sad to see it is such a long-standing regression!
Comment 5 tmacalp 2015-04-17 15:32:00 UTC
This is still a valid bug in recent nightly versions.  There have been many changes since the last comment, but this bug's behavior is still broken in the same way as originally reported.

Version tested:
Version: 4.5.0.0.alpha0+
Build ID: 09a1e4f36128f64029d45a38d9b059bf11ea0821
TinderBox: Linux-rpm_deb-x86@45-TDF, Branch:master, Time: 2015-04-15_23:40:36
Locale: en_US
Comment 6 heiko 2016-04-13 18:25:10 UTC
same problem in version 4.2.8.2

and catagory-problems also for donut charts for 2. or more rings
with non-contiguous data ranges
Comment 7 heiko 2016-04-13 18:28:38 UTC
same problem in version 5.1.2.2

and catagory-problems also for donut charts for 2. or more rings
with non-contiguous data ranges
Comment 8 QA Administrators 2017-05-22 13:23:15 UTC Comment hidden (obsolete)
Comment 9 tmacalp 2017-05-24 20:15:49 UTC
This bug is still present in 5.3.3.
Comment 10 Xisco Faulí 2017-06-12 11:27:31 UTC
Changing version back to the earliest affected version.
Comment 11 QA Administrators 2018-06-15 02:45:38 UTC Comment hidden (obsolete)
Comment 12 stragu 2018-06-17 05:57:33 UTC
I can reproduce this same bug with the following versions/config:

Version: 5.4.6.2
Build ID: 4014ce260a04f1026ba855d3b8d91541c224eab8
CPU threads: 2; OS: Linux 3.13; UI render: default; VCL: kde4; 
Locale: en-GB (en_GB.UTF-8); Calc: group

Version: 6.1.0.0.beta1
Build ID: 8c76dfe1284e211954c30f219b3a38dcdd82f8a0
CPU threads: 2; OS: Linux 3.13; UI render: default; VCL: kde4; 
Locale: en-GB (en_GB.UTF-8); Calc: group
Comment 13 QA Administrators 2019-06-18 02:46:51 UTC Comment hidden (obsolete)
Comment 14 stragu 2019-06-20 12:01:19 UTC
Can reproduce with:

Version: 6.3.0.0.beta1
Build ID: a187af327633f5f00363be5131bd21a13e0f1a7b
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded

.. and:

Version: 6.2.4.2
Build ID: 1:6.2.4-0ubuntu0.18.04.1~lo1
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-GB
Calc: threaded
Comment 15 b. 2020-09-19 23:03:24 UTC
still bug in 7.1 from 2020-09-05 win7x64, 

already bug in 3.5.1.2 win7x64, 

issue looks - besides some parts of the range definitions containing small errors - depending on both 'parts' of the data area starting in the same row, 

move e.g. C2:D13 to C3:D14 (select and ctrl-x ctrl-v), then chart display will be correct, at least improved ... may be that helps in debugging ... 

old bug, and regression as old sample looks better,