Issue 53460 - Cant chart more han 32767 values.
Summary: Cant chart more han 32767 values.
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-08-17 23:05 UTC by mal42north
Modified: 2013-02-24 21:19 UTC (History)
5 users (show)

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

Attachments
graph_of_32767_values (933.50 KB, application/vnd.sun.xml.calc)
2006-03-01 18:57 UTC, tange 		no flags Details
no_graph_of_32768_values (584.75 KB, application/vnd.sun.xml.calc)
2006-03-01 18:58 UTC, tange 		no flags Details
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 mal42north 2005-08-17 23:05:45 UTC 
If I try to Chart an XY chart wit more than 32767 value pairs in a line, then
the chart comes up blank, with both axes scaled 0-1. Seems like the number of
elements is stored as a signed 16 bit int, with hard range clipping.  
Of course I dont have any reasonable explanation as to why I am trying to chart
that much data.
Comment 1 kla 2005-08-26 14:48:46 UTC 
-> BM: Should fixed in the new Chart.
Comment 2 bjoern.milcke 2005-08-29 10:01:31 UTC 
confirmed
Comment 3 tange 2006-03-01 18:55:02 UTC 
I still see this issue. I run Build 1 (Sat Dec 17 17:47:04 CET 2005).

I attach 2 documents:

- graph_of_32767_values.ods
- no_graph_of_32768_values.ods

The only change is graphing 32768 values instead of 32767.
Comment 4 tange 2006-03-01 18:57:16 UTC 
Created attachment 34530 [details]
graph_of_32767_values
Comment 5 tange 2006-03-01 18:58:25 UTC 
Created attachment 34531 [details]
no_graph_of_32768_values
Comment 6 bjoern.milcke 2006-03-02 09:52:06 UTC 
Well, it is actually still not fixed in the master build of OOo. The new chart
is the re-implementation of the existing chart code, which is not yet integrated
into the master. To have a look at the current developer build of the new chart,
see http://graphics.openoffice.org/chart/chart.html.
Comment 7 michwi 2006-11-23 10:50:31 UTC 
I experienced the same problem. Additionally, handling a graph with many
(thousands of) values slows down the system significantly. 
Excel seems to work around this problem by not drawing more than 32000 values
and draws only every x-th value if nevertheless is supposed to do so. At least,
it displays a warning message telling the user it cannot draw more than 32000
values in a 2D-diagram. However, the graph looks complete. Wouldn't that be a
good idea for OOo too?
Comment 8 bjoern.milcke 2007-01-15 11:45:50 UTC 
->iha: please take over as discussed
Comment 9 IngridvdM 2007-01-15 11:51:10 UTC 
accepted
Comment 10 IngridvdM 2007-08-02 18:56:27 UTC 
This issue was fixed with the complete re-implementation of the chart module
starting with version SRC680m213.

You can have more than 32767 values for a chart now. Load the attached example,
double click the chart and you will see the graph.

I think the new principle limit within the chart is given by type sal_Int32 as
index for uno sequences. Also the number of rows or columns in calc or writer is
a limiting factor.
Furthermore the machine memory and power will limit the number of points which
can be processed.
Comment 11 IngridvdM 2007-08-02 18:58:38 UTC 
->Thomas, please verify on master and close.
Comment 12 kla 2007-08-03 09:05:51 UTC 
verified
Comment 13 kla 2007-08-03 09:06:12 UTC 
closed