Issue 126226 - Vertical alignment of text of different size
Summary: Vertical alignment of text of different size
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.1
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2015-04-06 06:28 UTC by rj3r6c8nw6
Modified: 2015-04-27 09:57 UTC (History)
1 user (show)

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

ODS example (9.91 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-04-06 06:28 UTC, rj3r6c8nw6
no flags Details
Excel screen shot (15.41 KB, image/jpeg)
2015-04-27 09:50 UTC, rj3r6c8nw6
no flags Details
OpenOffice screen shot (20.75 KB, image/jpeg)
2015-04-27 09:50 UTC, rj3r6c8nw6
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description rj3r6c8nw6 2015-04-06 06:28:28 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.
Comment 1 rj3r6c8nw6 2015-04-06 06:30:11 UTC
Affects all versions tested.
Comment 2 oooforum (fr) 2015-04-08 08:42:51 UTC
Could you provide a screen shot to see what you expected?
Comment 3 oooforum (fr) 2015-04-27 08:22:57 UTC
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.
Comment 4 rj3r6c8nw6 2015-04-27 09:50:07 UTC
Created attachment 84695 [details]
Excel screen shot
Comment 5 rj3r6c8nw6 2015-04-27 09:50:43 UTC
Created attachment 84696 [details]
OpenOffice screen shot
Comment 6 rj3r6c8nw6 2015-04-27 09:57:03 UTC
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.