Apache OpenOffice (AOO) Bugzilla – Issue 71697
new chart: Manual legend size, automatic entry stacking
Last modified: 2013-02-24 21:20:22 UTC
The legend is on 2 lines in Calc
Created attachment 40681 [details] Aire_3D.xls
Tony, Sorry can you please explain it more. Thanks
Created attachment 40715 [details] Aire_3D.jpg
Created attachment 40716 [details] Aire_3D.jpg
Legend -> Two line in Calc and One line in Excel
*** Issue 71685 has been marked as a duplicate of this issue. ***
Confirmed on Ooo 2.1 and Office 2003 Win xp
->dr: This is broken in the reimplementation. You should be able to use the property 'Expansion' of type LegendExpansion at the Legend.
*** Issue 71695 has been marked as a duplicate of this issue. ***
The Expansion property can only be used for automatic legends in Excel (default position left/right/top/bottom). If the legend is resized manually, there is no way to decide whether the enties are stacked or not. So we need the posibility to set a manual size for a legend in Chart2 and to let the legend distribute its entries automatically.
To fix this regression, it would work if you would calculate the aspect ratio of the given legend and set the expansion to HIGH, if it is less than 1, or to WIDE, if it is larger than 1. (If it is 1 +-a threshold, you can set BALANCED). The API also has the enum value CUSTOM for Expansion, but there is no property yet that holds the actual ratio. That would have to be fixed in the chart first. This would lead to better results, but would be an enhancement over the old behavior.
locally fixed by using the workaround suggested by bm
changed prio and target according to i-team decision
(->dr: Checked bugdoc in latest Build on Windows and Linux) Please verify in latest build of chart2mst3, mst12_3.
verified
OK for me