Issue 35085 - better defaults for text break in axis labels
Summary: better defaults for text break in axis labels
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
Keywords: ms_interoperability, usability
: 49042 (view as issue list)
Depends on:
Reported: 2004-10-07 07:15 UTC by vandan
Modified: 2013-02-24 21:22 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description vandan 2004-10-07 07:15:02 UTC
In Excel ( sorry for starting out with those 2 words ... ), I've set up a chart
that has text labels down the Y axis. Then I set the font to 8-point. Excel will
'push' the main chart area to the right to accomodate for the increased size of
the category labels down the Y axis.

When I open the .xls in OpenOffice 1.9.54 ( which wasn't available in the issue
tracker by the way ), instead of increasing the width of the Y-axis area to
accomodate for the labels ( and pushing the main chart area to the right ),
OpenOffice instead wraps the label text, making the label take up multiple
'rows'. It looks very bad.

I can provide an example if needed, however I've left it out for now because the
.xls I'm talking about has sensitive data, so I'll have to make another with
'test' data ( no problem if that's what's needed ).
Comment 1 vandan 2004-10-08 04:51:10 UTC
My appology.

I missed a feature of the charting module: you can set a 'text-flow' property
for labels. If I de-select 'break', the labels are displayed properly.

Perhaps this should be the default setting, at least when importing from an
Excel chart? It would make imported charts look more like the original without
any editing.
Comment 2 flibby05 2004-10-22 10:04:59 UTC
changing defect -> enhancement
Comment 3 flibby05 2004-10-22 10:05:44 UTC
reassigning to Bettina
Comment 4 bettina.haberer 2004-11-29 18:23:41 UTC
Reassigned to Ingrid.
Comment 5 IngridvdM 2005-04-25 14:42:03 UTC
Yes, the current default is not very good and should be improved.
Comment 6 kla 2005-05-13 06:30:58 UTC
*** Issue 49042 has been marked as a duplicate of this issue. ***
Comment 7 treblig 2005-07-08 16:36:16 UTC
Can we change this from 'Enhancement' - at the moment it makes imported charts
from Excel unusable in many cases.

I suspect a simple initial improvement would to default to 'break' being off for
the X-axis labels since in general the Y-axis has space and also breaks a bit
more neatly than the X axis.
Comment 8 IngridvdM 2005-07-22 12:00:41 UTC
Yes agreed, from the view point of import it is a defect.
For the moment please use the workaround and disable the property 'Break' for
the axis labels. You can find this setting at the axis Object Properties dialog
on the tab page 'Label'. You than will need to make sure that all your axis
labels are short enough to leave enough space for the display of the data itself.
By the way it is always helpful if you could provide an example or screenshot
how it should look like and how it looks after import maybe as png. Thanks a lot.
Comment 9 IngridvdM 2006-12-04 21:02:37 UTC
Fixed in CWS chart2mst3.

Labels on vertical axes and value labels on any axis now are never wrapped over
multiple lines. Only horizontal text labels on horizontal axes are wrapped when
the property 'break' is set.
When the not wrapped labels do not fit into the rectangle that is given by the
user or by the automatic calculation then the labels just lap outside. But you
can still see and select the selection handles as they are placed on the user
defined rectangle - not on the resulting rectangle.

If someone likes he could test the current behaviour in the preview version
Milestone9b available for download here:
Comment 10 IngridvdM 2006-12-13 23:30:00 UTC
->Thomas: Fixed in CWS chart2mst3 milestone10, please verify.
Comment 11 IngridvdM 2007-01-18 11:55:48 UTC
changed target to 2.3
Comment 12 kla 2007-04-13 08:26:25 UTC
verified, follow up issue for disable "break" for vertical axis will be written
Comment 13 2007-06-10 07:23:49 UTC
It's OK for me with m213

I'm not authorized to close this issue
-> vandan or kla : can you close this issue ?

Comment 14 kla 2007-06-11 11:37:08 UTC