Why does Chart data disappear when columns are hidden?

Discuss the spreadsheet application

Why does Chart data disappear when columns are hidden?

Postby pconroy328 » Tue Oct 19, 2010 8:47 pm

I have an XY Scatter plot, and decided to hide the columns with the data.
As soon as I hide them - the Chart clears, the data points disappear?

Is this supposed to happen?
If so - I fail to understand why that would be desired?

OpenOffice 3.2.1 OOO320m18 Build 9502

thanks!!
OpenOffice 3.2.1 On Ubuntu 9.04
pconroy328
 
Posts: 4
Joined: Thu Oct 14, 2010 1:00 am

Re: Why does Chart data disappear when columns are hidden?

Postby Charlie Young » Tue Oct 19, 2010 10:12 pm

pconroy328 wrote:I have an XY Scatter plot, and decided to hide the columns with the data.
As soon as I hide them - the Chart clears, the data points disappear?

Is this supposed to happen?
If so - I fail to understand why that would be desired?

OpenOffice 3.2.1 OOO320m18 Build 9502

thanks!!


It's a default option. Under Format > Data Series, check "Include values from hidden cells."
Apache OpenOffice 4.1.1
Windows XP
User avatar
Charlie Young
Volunteer
 
Posts: 1559
Joined: Fri May 14, 2010 1:07 am

Re: Why does Chart data disappear when columns are hidden?

Postby Villeroy » Tue Oct 19, 2010 10:53 pm

pconroy328 wrote:Is this supposed to happen?
If so - I fail to understand why that would be desired?

Because too many users complained.
http://qa.openoffice.org/issues/show_bug.cgi?id=91578
http://qa.openoffice.org/issues/show_bug.cgi?id=81209
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27214
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Why does Chart data disappear when columns are hidden?

Postby acknak » Wed Oct 20, 2010 12:49 am

Note that the resolution there was to give users the option whether or not to display values from hidden cells.

Getting the option set for a hidden data set is a bit of a nuisance, but the option is there.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: Hagar Delest and 37 guests