Issue 62365 - Choose how to handle empty cells in charts
Summary: Choose how to handle empty cells in charts
Status: CLOSED DUPLICATE of issue 3411
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-02-21 01:52 UTC by greenslach
Modified: 2013-02-24 21:19 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description greenslach 2006-02-21 01:52:41 UTC 
For the new chart engine, I would like an option that would let the user choose
how to plot empty cells from a chart data range.

In Excel, for some type of charts, you can choose to leave a gap for empty
cells, to assume the missing value is zero, or to interpolate. (it is available
in "Tools" Menu, "Options..." Menu item, "Chart" Tab).  For some other type of
charts, Excel does not plot the empty cells at all (that is, there is no gap for
empty cells).

It would be great to be able to choose how charts should handle empty cells in
OpenOffice.  In OOo 2.0.1, empty cells leave a gap in the chart.

I think that the default way to handle cells should be to leave gap if the empty
cells are in the middle of non-empty cells, but to not plot empty cells that are
in the beginning or the end of the chart data series.  In this way, if the chart
 data range is simply bigger than a non-empty data range, only the non-empty
part will be plotted.

Regards,
greenslach.

***

I also submitted another issue about empty cells and charts:
http://www.openoffice.org/issues/show_bug.cgi?id=62363
(but this one is a bug that prevents selecting empty cells in charts when
modifying them but not creating them)
Comment 1 kla 2006-02-21 09:29:31 UTC 
Hi Greenslach.
Thx to support OOo-Chart. Yes, the "probs" with handle of blank/empty cells are
well known. As I remember i3411 is the first issue who deal with the handle of
blank cells.
Iha is on track to fix the probs into the new chart.
See also: http://graphics.openoffice.org/chart/featurewishes.html
So it's an enhancement and double.
I close it.

*** This issue has been marked as a duplicate of 3411 ***
Comment 2 kla 2006-02-21 09:29:52 UTC 
closed as duplicate