Ask Your Question

Centering vertically [closed]

asked 2018-01-05 07:34:20 +0200

xylus gravatar image

updated 2018-01-05 15:59:54 +0200


I am trying to center text in a table within LibreOffice Calc vertically however it does not work.

I want to move 3.5 to the middle of the cell vertically. I have selected the vertical middle button but it does not work, or I am misunderstanding the use for it.

Here is a Google Drive example with the cell and the desired position as an image below it:

Thank you in advance.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-25 15:21:25.205273


It could help if you attached a one-cell example here (put it on an external share, and edit question to post a link).

Mike Kaganski gravatar imageMike Kaganski ( 2018-01-05 08:53:55 +0200 )edit

what I am trying to achieve:

OK, but what exactly are you doing?

gabix gravatar imagegabix ( 2018-01-05 13:30:38 +0200 )edit

@Mike Kaganski: I have attached an example. @gabix: I am currently attempting to press the "Centre vertically" button to try and get the number to be in the middle of the cell in terms of height.

Edit: FYI It seems that when opened as a Google Sheet the number is centered vertrically as desired. The problem is when the sheet is open using LibreOffice Calc.

xylus gravatar imagexylus ( 2018-01-05 16:01:10 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-01-05 20:17:03 +0200

This happens because of conditional formatting applied. The styles that are applied contain the vertical alignment; and as the conditional formatting is applied last, it overrides both style and manual format set for the cell.

Define proper vertical alignment in the conditional formatting styles.

edit flag offensive delete link more

answered 2018-01-05 20:33:43 +0200

Lupp gravatar image

updated 2018-01-05 20:40:38 +0200

There is a conditional formatting for cell B2 that overlays the attributes of a cell style assigned under the current condition.

The styles applying under the different conditions partly have vertical 'Default', partly ''Bottom'. Both these settings result inbottom alignment eventually for that sheet.

@Mike Kaganski was faster.

edit flag offensive delete link more


Thank you. Modified the condition.

xylus gravatar imagexylus ( 2018-01-05 20:40:22 +0200 )edit

Question Tools

1 follower


Asked: 2018-01-05 07:34:20 +0200

Seen: 4,981 times

Last updated: Jan 05 '18