Apache OpenOffice (AOO) Bugzilla – Issue 28932
visibility of series from hidden rows or columns
Last modified: 2013-02-24 21:20:41 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 disappears. 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.
I take it.
Hi Bjoern, as discussed for you. tk
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.
accepted
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.
Created attachment 20090 [details] Calc X-Y Chart showing bug 28932
Created attachment 20091 [details] Calc X-Y Chart showing bug 28932
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.
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.
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.
Created attachment 25336 [details] work around for the hiding problem
*** Issue 47617 has been marked as a duplicate of this issue. ***
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!
changed summary to something more meaningful
change owner
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?
reset to new
Sure, why not. Joe Conner, Poulsbo, WA USA
@joeconner, ok thanks, so I set this to duplicate to issue 91578 now. *** This issue has been marked as a duplicate of 91578 ***
closing duplicate