Issue 49042 - Error fromatting a BIG table that has date on the X axis
Summary: Error fromatting a BIG table that has date on the X axis
Status: CLOSED DUPLICATE of issue 35085
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-05-10 22:01 UTC by giuliano1969
Modified: 2013-02-24 21:22 UTC (History)
1 user (show)

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


Attachments
example of Exel 97 table/graph, badly displayed under Openoffice (36.50 KB, application/vnd.ms-excel)
2005-05-10 22:04 UTC, giuliano1969
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description giuliano1969 2005-05-10 22:01:49 UTC
Error fromatting a BIG table that has on the X axis wide text data (like date).

Example: 
1) create big table that has e.g. 200 rows and 3 coloumns (date, value1, value2)
2) Create a graph with this table. 
3) In the wizard (the button with the pie chart) Select the first coloumn to be
the data to be shown on the X Axis.

The table is like  
----------|value1|value2|
10/05/2005|   100|  101 |
11/05/2005|   103|  103 |
........................
........................

When a graph is created by the wizard, the Text (the date) on the X Axis is
badly formatted, because each single "date" that would be present on the X Axis,
gets overwritten and messed up with the others.

WHAT SHOULD HAPPEN INSTEAD?
Look, as an example, at what happens in Excel 97.
We'll see that considering on the following parameters:
a) the lenght of the text to be displayed on the X Axis (i.e. the date is
10/12/02 or is 10 december 2005 ?) 
b) the number of this items (i.e. do we have a 5 elements serie o a 500 data
elements to be displayed on the X axis?) 
c) the size of the area in which the graph is displayed

What happens is:
A) the text displayed on the X axis is rotated, untill it will become completly
vertical when the elements are one hundred or more, 
b) the data displayed is "decimated" that's to say that if there is not enough
room, the graph shows one data text (one date) each N data

Try on Exel97 , and you will see that 
1) a 5 elements serie, has the text displayed horizzontally on the X Axis.
2) As the numbers of elements grows, the text ont the X Axis is slowly rotated
.... say it is rotated at 45°
3) when the numbers of elements to be displayed on the X Axis grows each more,
the text is rotated a 90 °
4) when the numbers of elements to be displayed on the X Axis continue growing,
the text (the datein our example) is picked each one each N elements...

This does not happens automatically in Open Office.
Even worst,
If we import such an Excel file, (....that is correclty displayed under
Excel97), we'll see a mess under the X Axis under Open office.
We can of course manually correct the problem, but the wizard should
automatically and easily detect the situation, considering the need to rotate
the text as the number of elements (and their size) increase.

Giuliano
Windows XP + SP2
Open office 1.9m100
Comment 1 giuliano1969 2005-05-10 22:04:42 UTC
Created attachment 25996 [details]
example of Exel 97 table/graph, badly displayed under Openoffice
Comment 2 frank 2005-05-11 00:40:29 UTC
wrong component changed to Chart
Comment 3 daniel.rentz 2005-05-11 08:08:43 UTC
Shortly, missing features:
- Scaling settings for category axes (show every n-th category)
- Automatic rotation of axis labels
Comment 4 kla 2005-05-13 06:30:59 UTC
Sounds like an duplicate to 35085.
IHA works on it.
So i will close it. 

*** This issue has been marked as a duplicate of 35085 ***
Comment 5 kla 2005-05-13 06:31:20 UTC
closed as duplicate