Apache OpenOffice (AOO) Bugzilla – Issue 126226
Vertical alignment of text of different size
Last modified: 2015-04-27 09:57:03 UTC
Created attachment 84635 [details] ODS example It's impossible to vertically align the baselines of text in adjacent cells if the font sizes are different. It seems that extra padding is being added in the wrong place, which creates the curious symptom of having bottom-aligned text placed higher than top-aligned text.
Affects all versions tested.
Could you provide a screen shot to see what you expected?
No news? Please read my previous comment. Once this is done, set the status back to UNCONFIRMED and we will attempt to reproduce the issue.
Created attachment 84695 [details] Excel screen shot
Created attachment 84696 [details] OpenOffice screen shot
This issue came up because I was trying to ditch Excel and use OpenOffice instead, but the spreadsheet that my work made me use was being formatted differently in OpenOffice (the baselines no longer aligned). See the new attachments for screenshots of how bottom alignment of differently-sized text in adjacent cells looks in Excel and OpenOffice. You can ignore the TOP and BOTTOM text from the first attachment. I thought it odd that character padding was not mandatory on the top and bottom, regardless of the vertical alignment type chosen. But this feature exists in Excel too, so for compatibility I guess it's best to just keep it.