Apache OpenOffice (AOO) Bugzilla – Issue 72865
Calc X-Y chart limited to 32767 points
Last modified: 2013-02-24 21:20:19 UTC
I didn't find any existing issue regarding this, but maybe I just didn't look hard enough. In Calc 1.* the maximum number of rows was 32000. In Calc 2.* this has been increased to 65536. But the X-Y Chart function appears to be limited to 32767 data points. If I try to chart 32768 or more X-Y points, I get an empty chart. I've tried charting different portions of my data. It doesn't seem to matter what row the data range starts or ends at, so long as the range is less than 32768 rows. E.g. I can chart the range $A$1:$B32767, and I can chart the range $A$2:$B$32768, and I can chart the range $A$10000:$B$40000, but I cannot chart the range $A$1:$B$32768.
I don't confirm. It's OK with 40000 points and Chart2m10 (but it's very very very slow)
Sorry if this is a stupid question: What is Chart2m10? I just double checked, and I'm not using 2.0.4 after all, actually I'm still on v2.0.3. I'll try updating and see if that makes any difference.
I just updated to v2.1.0 and I still have the problem. I tried a different chart type ("Lines" - which is actually meaningless for my data, but it was just a test) and it exhibits the same problem. I'll try to attach my file, and then go through my sequence step by step to create the chart.
Created attachment 41685 [details] My spreadsheet
I just uploaded 011.ods (Sat Dec 23 21:36:00) This file was written by Calc v2.1.0 My system is WindowsXP, 1.5GB mem. Steps: Select A1:B40000 Insert->Chart - Range: $A$1:$B$40000 - First row as label: No - First column as label: No - Chart results in worksheet: Sheet1 Click Next>> - Choose a chart type: XY Chart - Show text elements in preview: No - Data series in: Columns Click Next>> - Choose a variant: Lines Only - Grid Lines: X Axis: Yes - Grid Lines: Y Axis: Yes Click Next>> - Display: Chart Title: No - Display: Legend: No - Axis Titles: X Axis: No - Axis Titles: Y Axis: No Click Create>> What I get at the end of these steps is a blank chart with X-axis range 0 to 1 with major intervals of 0.1, Y-axis range 0 to 1 with major intervals of 0.1. I'll attach the file again with the chart in it; you can edit the chart properties and see the data ranges, axis scale, etc.
Created attachment 41686 [details] My spreadsheet again, with empty chart
OOo 1.x use Chart1 OOo 2.1 use Chart1 Chart2 m10 (milestone 10) is here : -> http://graphics.openoffice.org/chart/chart.html
@kjohnstn: As Tony has written it is no limitation to build a chart. It works very, very slow. That is an known Issue (i16280). Pls use the Chart2 m10 (milestone 10). Thx *** This issue has been marked as a duplicate of 16280 ***
closed as duplicate