Apache OpenOffice (AOO) Bugzilla – Issue 60262
First row of multiline cells is not centered after rotation
Last modified: 2017-05-20 11:11:15 UTC
On my spreadsheet, I entered a text value in a cell which spans two rows. This text is centered horizontically and in the middle (vertically). Then, I rotate that text 180°, so that it is upside down. Now the text in the first row is no longer centered. I'd expect it to be still centered. I'll attach a screenshot showing this behaviour and a sample ods file. This happens for me with OOo 2.0.0 on Windows and with OOo 2.0.1 on Linux. I did not test other versions.
Created attachment 33054 [details] Screenshot showing the misalignment of the first row in a rotated multiline cell
Hi, I cannot reproduce it; can you give a step-by-step description?
I'll try. - Start oocalc2 - Create a new spreadsheet - Go to cell A1 - Type: "Row 1<ctrl>+<enter>The second row" (you hit the keys <ctrl> and <enter> at the same time after you entered "1") - Set the width of that cell to be quite wide - like 5cm - Click with the right mouse button on that cell - Select "Format Cells" - Go to "Alignment" tab - Set: Text Alignment -> Horizontal: Center, Vertical: Middle, Text orientation: 180 degrees - Click on ok Result: Something like what I presented in the screenshot I'll now attach the spreadsheet that I just created.
Created attachment 33071 [details] Spreadsheet with two rows in cell A1, demonstrating the defect
Ok, reproduced; for some reason I always merged cells and then applied the attributes. confirmed on Windows XP Pro SP2 with OOo 2.0.1
Hi Niklas, please have a look at this one. Frank
changing target
change target from 2.x to 3.x according to http://wiki.services.openoffice.org/wiki/Target_3x
Reset assigne to the default "issues@openoffice.apache.org".