[Libreoffice-bugs] [Bug 142328] New: EDITING Support “Best” rotation for bar chart category axis

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142328

            Bug ID: 142328
           Summary: EDITING Support “Best” rotation for bar chart category
                    axis
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org, varga.balazs3 at nisz.hu
            Blocks: 75057, 90486

Created attachment 172084
  --> https://bugs.documentfoundation.org/attachment.cgi?id=172084&action=edit
Example file from Excel

Attached XLSX file demonstrates that MSO by default uses a “Best” rotation for
horizontal category axes of charts (Bar, Line, Point, Area).
On the UI it is shown as “Horizontal” text rotation, with undefined rotation
angle. This is misleading a bit, since the actual text rotation will be
determined based on the actual text length of the axis labels:
- with short labels/wide chart it’s gonna be horizontal
- with medium length labels it’s gonna be -45 degrees (in Word terms)
- with long labels it’s gonna be 270 degrees (in Word terms)

LO can display the text in the first two cases (when the labels overlap
property is turned off manually, needed right now because of bug #140623) but
it would be nice to be able to better mimic the vertical rotation of long
labels; possibly with an explicit UI option (to be filed later).

Steps to reproduce:
1.      Open attached file
2.      For the first chart, open the X axis properties

Actual results:
The X axis text is not rotated to 270 degrees, but to -45 even if the Overlap
property is manually turned off. 
The Text Orientation dial indicates 0 degrees orientation, which is false: that
would mean the labels are horizontal. 
Ideally, there would be an “Automatic” checkbox (or radio button paired with
“Vertically stacked” option) that disables this dial and sets rotation based on
actual text length + font size + available space. This could be a topic for
another report.

Expected results:
The X axis text should be rotated to 270 degrees.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=75057
[Bug 75057] [META] OOXML Chart object issues
https://bugs.documentfoundation.org/show_bug.cgi?id=90486
[Bug 90486] [META] Chart bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210517/2bacbec8/attachment.htm>