Bug 53654 - FORMATTING: Format Cells dialog; Alignment tab; Text orientation
Summary: FORMATTING: Format Cells dialog; Alignment tab; Text orientation
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Cell-Format-Dialog
  Show dependency treegraph
Reported: 2012-08-17 19:48 UTC by Dan Lewis
Modified: 2019-12-10 13:17 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Dan Lewis 2012-08-17 19:48:44 UTC
Problem description: 
When the text orientation is between 91 and 269 degrees, the Horizontal text alignment does not work when "Wrap text automatically" is checked. Selecting any of the choice in Horizontal text alignment does not change the position of the text regardless of the choice. However, when the text orientation is between 0 and 90 or 270 and 360 (it is shown as 0), all choices work as they should. Also, if the Wrap text is unchecked, the Horizontal text alignment works. So it is something to do with wrapping text in a cell and the text orientation.
Steps to reproduce:
1.Select a cell.
2. Enter some text longer than the cell.
3. Right click the cell and select "Format cells" from the context menu.
4. Click the Alignment tab.
5. Check "Wrap text automatically".
6. Select a text orientation between 91 and 269 degrees.
7. Click OK.
8. Apply each of the Alignment tools. 

Current behavior:

Expected behavior:

Platform (if different from the browser): 
Browser: Mozilla/5.0 (X11; Linux x86_64; rv:14.0) Gecko/20120715 SeaMonkey/2.11
Comment 1 Sören 2012-12-26 21:05:52 UTC
I can confirm the problem in
Version (Build ID: 4104d660979c57e1160b5135634f732918460a0)
on Ubuntu 12.04 (x86)
althoug for me the alignment neither works for orientations below 90 (apart from 0, which works fine)
Comment 2 A (Andy) 2014-10-18 19:08:46 UTC
Reproducible with LO (Win 8.1)

In both cases (below and above 90 degrees) the text alignment options have no effect.
Comment 3 QA Administrators 2015-12-20 16:20:06 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2017-01-03 19:51:01 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2019-12-03 14:05:13 UTC Comment hidden (obsolete)
Comment 6 Dan Lewis 2019-12-10 13:17:04 UTC
For this, I used the following version of LibreOffice: Version:
Build ID: a21169d87339dfa44546f33d6d159e89881e9d92
CPU threads: 2; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded.
   My test was to follow my own steps. Once I had selected "Format Cell", I entered a value for each quadrant: 0-90, 91-180, 181-270, 271-359. The text entered into the cell rotated to each new setting I entered.