To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49042 Issue #:|49042 Summary:|Error fromatting a BIG table that has date on the X |axis Component:|Spreadsheet Version:|680m100 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P4 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|giuliano1969
------- Additional comments from [EMAIL PROTECTED] Tue May 10 14:01:49 -0700 2005 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
