Apache OpenOffice (AOO) Bugzilla – Issue 12869
'Blank' cells are not ignored in chart areas
Last modified: 2013-02-24 21:21:15 UTC
I have a simple spreadsheet with columns A, D, E. A is the X axis (with label) and D and E are the Y data (again labeled). I have the line chart saying go from cell 1 to 999 for all three sources. When viewed in OOo 90% of the chart area is blank. When viewed in Excel, it is smart enough to trim off all the blank cell data. I know this sounds dumb, but if I then add a new row of data, as soon as I refresh the chart it is now expanded to include the new data point, so I am not rebuilding the chart every time. Keep up the good work!
I take it
It's an enhancement. See: http://graphics.openoffice.org/chart/featurewishes.html So I close it.
invalid because it's on the featurelist
closed