Apache OpenOffice (AOO) Bugzilla – Issue 80626
Diagram does not read data from hidden fields
Last modified: 2013-02-24 21:22:00 UTC
If I pick a data-area for a diagram and hide those rows afterwards, the diagram does not display any data although the data-area is still valid. If I set some cell to display the content of a hidden cell it works. Hence for functions that read data from another cell it is not important whether it is hidden or not. Thus the diagram should work too, i.e. read data from a hidden area.
wrong component, changed to Chart and re-assigned
Taking a look
In the re-implementation of the chart (OOo 2.3) this will be fixed. However, I am not sure if this is just a missing feature of the old chart. The API has properties IsHidden and HiddenValues at the XDataSequence. These can be set by the container and evaluated by the chart to hide certain values for a series, or an entire series. Maybe we should implement this or rethink the usefulness of this. ->mmp: Please try to find out what most users want. A. not show data that bases on hidden values B. show everything no matter if hidden or not
Setting to new. It is reproducable in the old chart, and different in the new chart.
This will be solved with feature implementation issue 91578. Then you will be able to choose whether hidden cells should be display or not. *** This issue has been marked as a duplicate of 91578 ***
In fact in the current version (dev300m23) values from hidden cells are displayed.