Apache OpenOffice (AOO) Bugzilla – Issue 74915
wrong chart size destroys page layout
Last modified: 2013-02-24 21:20:07 UTC
When I load a previously created in Excel file with a chart, we have a continually occuring incident, with Chart Milestone 11, that the chart still is taller than the original MS chart. This gives us small but very annoying pagination issues, where the chart is forced also onto the next page, which pushes all the other pages out of pagination a little, leading to quite a mess. The legend used on OO2.1 and before was shown underneath the graph itself, leading to a slightly taller graph. Now that the legend is in the same place as Excel it places it on the right hand side, the chart should be the same size as in Excel. But the chart still ends up also on the next page.
Created attachment 43412 [details] Problematic file - in excel 1st page is fine. in OOchartmilestone 11 still pagination issues
set keyword, change Prio and Type, Set Target @Iha: Maybe its possible to keep in mind for the new implementation.
I raised the prio again as page issues are important for printing. ->Daniel, look at the first chart (Object 1). After import it is bigger(heigher) than in the original doument and does not fit into the 'Page 1'-region anymore.
I checked with "2.2.0RC4 German version WIN XP: [680m14(Build9134)]" and can confirm the problem, pls see my screenshots! Related to Issue 46626? @joolsr Pls specify your OS and Platform
Created attachment 45705 [details] screenshots comparing legend view in excel viewer and OOo
I get this same problem using Open Office 2.2.0 on Ubuntu 6.04. I also get exactly the same problem using Open Office 2.2.0 on Windows 2000. Interestingly, in OOo 2.3.0 dev on Windows 2000, the legend for the graph is shown higher up, not the same as Excel's label but much closer in appearance to it. Unfortunately, the chart still falls off the bottom of the page. I think the chart height is still the same as before, and oddly (in fact possibly even worse), the chart y axis is scaled up. ie the y axis takes up more room than before. I enclose a screenshot to illustrate this better. I think its important to stress that many of our hundreds of similar excel files are likewise put together with charts very close to the bottom of the page. Just a very slight change in the way the chart is shown means the the chart does stay on the same page, resulting in a only about 2-3 mm of the bottom part of the chart being cutoff and shown on the next page. The biggest problem is that this results in an almost entirely blank page on pg2 with just a few lines of the chart, resulting in very annoying pagination issues and unwanted almost blank pages. To users who dont understand the problem, it makes OOo look quite poor, although the issue is quite small.
Created attachment 45717 [details] Drawing showing the difference between chart legend placement in 2.2 and 2.3
OS due to joolsr's comments
set target to 3.x
I doubt that this problem has something to do with the legend within the chart. The outer size is the real problem and that is not influenced by the parts within the chart -> changing summary.