Issue 28932 - visibility of series from hidden rows or columns
Summary: visibility of series from hidden rows or columns
Status: CLOSED DUPLICATE of issue 91578
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: IngridvdM
QA Contact: issues@graphics
: 47617 (view as issue list)
Depends on:
Reported: 2004-05-07 21:42 UTC by joeconner
Modified: 2013-02-24 21:20 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Calc X-Y Chart showing bug 28932 (21.32 KB, application/vnd.sun.xml.calc)
2004-12-04 05:50 UTC, joeconner
no flags Details
Calc X-Y Chart showing bug 28932 (21.32 KB, application/vnd.sun.xml.calc)
2004-12-04 05:53 UTC, joeconner
no flags Details
work around for the hiding problem (11.91 KB, application/vnd.oasis.opendocument.spreadsheet)
2005-04-22 10:29 UTC, bjoern.milcke
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description joeconner 2004-05-07 21:42:15 UTC
When I create an X-Y linegraph chart,
then hide the columns that contain the
source cells upon which the X-Y graph
lines are based, the graph information

When I show the columns again, the
graph reappears.

If I change the width of the graph lines
and their color then hide the columns 
containing the plot data then the graph 
information disappears.  When I change the
columns to show, then the graph lines reappears, 
but the width of the line has reverted to 
the original width and color scheme.

The graph should not disappear when the data
source cells are hidden.  It should not matter.
Comment 1 kla 2004-05-11 09:05:52 UTC
I take it.
Comment 2 kla 2004-05-11 09:06:39 UTC
Hi Bjoern,
as discussed for you.
Comment 3 bjoern.milcke 2004-05-11 10:02:32 UTC
In the new implementation the solution for this problem is prepared. We have a
property "Hidden" at the data series, which would be set to true in case a
column or row in Calc is hidden. As a result the series would still exist but
not be displayed, thus the attributes would not shift.
However, this is not integrated in the view yet.
Comment 4 bjoern.milcke 2004-05-17 12:24:40 UTC
Comment 5 joeconner 2004-06-19 02:49:39 UTC
Further characterization of problem:

If source data in columns is hidden by column, the graph data all dissappears.
Showing the columns again causes the graph data to reappear, but the graph 
lines have reverted to the original default.  The graph is responsive to 
source changes.

If the source data in columns is hidden by hiding the rows, the graph detail
remains visible with the current colors and line width, but becomes 
unresponsive to changes in the data.  Tools > Cell contents > auto calculate 
is checked but graph lines do not respond to changes in source data until F9 
or recalculate is clicked.  Then it will update to the current data, but will 
not auto update if the source data is changed again.

Comment 6 joeconner 2004-12-04 05:50:29 UTC
Created attachment 20090 [details]
Calc X-Y Chart showing bug 28932
Comment 7 joeconner 2004-12-04 05:53:10 UTC
Created attachment 20091 [details]
Calc X-Y Chart showing bug 28932
Comment 8 joeconner 2004-12-04 06:04:48 UTC
OOo Calc 1.1.4RC still has but 28932 but in a slightly altered form:

1.  Create X-Y graph of data in 4 columns.
2.  Modify property of graph lines to width=.06", and change the default color
to something else.
3.  Hide columns, data line in graph disappears.
4.  Unhide columns.  Graph lines reappear but the width reverts to the default
color and the width is set now to zero.
5.  Hide rows, data line in graph looses hidden data.
6.  Unhide rows, data line property for previously hidden data reappears,
retaining the color and width.
Comment 9 joeconner 2005-03-03 03:59:43 UTC
This issue is still present in 1.9.79 BETA.  In fact, it can cause a crash.  I
just submitted two crash messages using the crash recovery GUI.

Crash steps:
1. Link some cells on sheet two to sheet one cells to hold some x-y data.
2. Put some x-y data on sheet one to be copied into sheet two.  Create an x-y
graph on sheet one.  Save the file as an XSC file.
3. Go back to sheet two, and hide the rows with the data that drive the graph on
sheet one.
4. Go back to sheet one, change some of the graph data.  You will notice that
the graph still exists, but does not update to the change of data.
5.  Click again on sheet two.  Visually, sheet one remains on display, because
Calc has now locked up tight.  Clicking on the close (upper right "X" box) will
close Calc.  
6.  Restart Calc, it goes into recovery mode and successfully recovers the file.
Comment 10 bjoern.milcke 2005-04-22 10:27:47 UTC
Please don't add additional issues to this one. This issue is about the fact
that hidden data series in a chart loose their attributation when they are
re-shown. This will be fixed. As you can see by the target, it will NOT be done
for OOo 2.0. If there is an issue concerning missing chart updates when some
referenced cells are hidden, please write a separate issue for this.

If you really need to hide data columns that shall not reduce the chart, you can
put the data for the chart on a separate sheet that you may hide, and show
references to the original sheet on a visible one. If you hide columns in the
visible sheet this would not affect the chart. See attached example.
Comment 11 bjoern.milcke 2005-04-22 10:29:29 UTC
Created attachment 25336 [details]
work around for the hiding problem
Comment 12 kla 2005-04-22 10:41:25 UTC
*** Issue 47617 has been marked as a duplicate of this issue. ***
Comment 13 joeconner 2006-05-20 23:28:37 UTC
The latest release, 2.0.3rc1 seems to solved the issue for HIDDEN COLUMS but not
for HIDDEN ROWS.  This is a vallient try, but so far, no cigar!
Comment 14 IngridvdM 2007-07-25 18:09:38 UTC
changed summary to something more meaningful
Comment 15 IngridvdM 2008-07-03 11:39:56 UTC
change owner
Comment 16 IngridvdM 2008-07-11 15:39:45 UTC
Within the current version 2.4.1 or dev300m23 the behavior is completely
different. Hidden columns nad rows are always shown within chart. Issue 91578
will introduce an option to choose whether hidden cells should be displayed or
not. Then it might be worth to look at this update scenario again.
@joecoenner, would it be ok when I set this issue to duplicate and close it?
Comment 17 IngridvdM 2008-07-22 14:22:14 UTC
reset to new
Comment 18 joeconner 2008-10-01 03:28:15 UTC
Sure, why not.

Joe Conner, Poulsbo, WA USA
Comment 19 IngridvdM 2008-10-01 10:13:39 UTC
@joeconner, ok thanks, so I set this to duplicate to issue 91578 now.

*** This issue has been marked as a duplicate of 91578 ***
Comment 20 IngridvdM 2008-10-01 10:16:14 UTC
closing duplicate