Apache OpenOffice (AOO) Bugzilla – Issue 49042
Error fromatting a BIG table that has date on the X axis
Last modified: 2013-02-24 21:22:45 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
Created attachment 25996 [details] example of Exel 97 table/graph, badly displayed under Openoffice
wrong component changed to Chart
Shortly, missing features: - Scaling settings for category axes (show every n-th category) - Automatic rotation of axis labels
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 ***
closed as duplicate