Bug 133945 - Stacked graph draws one series as horizontal line
Summary: Stacked graph draws one series as horizontal line
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.0.beta1+
Hardware: x86 (IA32) other
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-06-12 21:32 UTC by Bob Harvey
Modified: 2021-05-16 03:46 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
the spreadsheet with the problem (110.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-06-12 21:33 UTC, Bob Harvey
Details
screengrab - the bad case (485.59 KB, image/jpeg)
2020-06-12 21:35 UTC, Bob Harvey
Details
screengrab - the good case (523.40 KB, image/jpeg)
2020-06-12 21:37 UTC, Bob Harvey
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Bob Harvey 2020-06-12 21:32:25 UTC
Description:
The attached spreadsheet has two charts.  In the top one series Column D is drawn flat, but should be a sinusoid like the others.  It appears by itself in the lower graph.
If I turn off stacked series, it is fine (hiding behind the green markers)

I attach the spreadsheet and two screengrabs

Steps to Reproduce:
1. open spreadsheet
2.select 2nd tab
3.look at charts
4. change chart type in top chart

Actual Results:
stacked series drawn with 3rd  series scaled weirdly

Expected Results:
Column C should be column A shifted by 4pi()/3


Reproducible: Always


User Profile Reset: Yes



Additional Info:
.
Comment 1 Bob Harvey 2020-06-12 21:33:30 UTC
Created attachment 161934 [details]
the spreadsheet with the problem
Comment 2 Bob Harvey 2020-06-12 21:35:21 UTC
Created attachment 161935 [details]
screengrab - the bad case

Note the yellow line is flat - compare to 2nd chart
Comment 3 Bob Harvey 2020-06-12 21:37:13 UTC
Created attachment 161936 [details]
screengrab - the good case

Turn off series stacking, and the yellow line is no longer flat
Comment 4 m_a_riosv 2020-06-14 15:18:35 UTC
With excel shows the same behavior.
Selecting columns B to H and inserting a new line chart works as expected.
Comment 5 Bob Harvey 2020-06-15 07:02:59 UTC
(In reply to m.a.riosv from comment #4)
> With excel shows the same behavior.
> Selecting columns B to H and inserting a new line chart works as expected.

Thanks for trying that.

And yet selecting columns B to H and inserting a line chart was exactly how I created the first one.  This is an interesting observation, but it still seems to me the original behaviour is incorrect.
Comment 6 Buovjaga 2020-10-16 13:42:16 UTC
(In reply to Bob Harvey from comment #5)
> (In reply to m.a.riosv from comment #4)
> > With excel shows the same behavior.
> > Selecting columns B to H and inserting a new line chart works as expected.
> 
> Thanks for trying that.
> 
> And yet selecting columns B to H and inserting a line chart was exactly how
> I created the first one.  This is an interesting observation, but it still
> seems to me the original behaviour is incorrect.

Are you able to reproduce the original problematic behaviour, though?

Set to NEEDINFO.
Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.
Comment 7 QA Administrators 2021-04-15 03:44:02 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2021-05-16 03:46:05 UTC
Dear Bob Harvey,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp