Apache OpenOffice (AOO) Bugzilla – Issue 83461
X Axis removing some entries compared to Excel
Last modified: 2013-02-24 21:21:59 UTC
See both screenshots.
Created attachment 49536 [details] Excel
Created attachment 49537 [details] OOo
Created attachment 49538 [details] How to correct it in order to look the same
Created attachment 49539 [details] The example file
I checked with "2.3.0 Dev. Snapshot WIN XP: [680m233(Build9228)]" and can confirm the problem. Looks fine with "2.2.1 Multilingual German version WIN XP: [680m18(Build9161)]"
I checked with OOo 2.3 and could not confirm the problem, all labels were shown. Even when some labels are missing this is not a bug. 'Overlap' is not checked on. Thus the axis layout mechanism cares to have no overlapping labels. If there is not enough space only each nth label is displayed. This is an important and necessary behavior to prevent the unintended creation of axis with thousands of labels all drawn above each others -> won't fix as this is no bug.
@iha: You are right, the reason for the different x-axis label view in 2.2 and 2.3 is the different size of the chart image, caused by the different size of the legend in both versions. So everything works fine. After I resized the chart to the size as in 2.2.1, all label entries were shown in 2.3.