Ask Your Question
0

Centering vertically

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

xylus gravatar image

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

Hello,

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:

https://drive.google.com/open?id=1T7t...

Thank you in advance.

edit retag flag offensive close merge delete

Comments

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
1

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
0

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

Comments

Thank you. Modified the condition.

xylus gravatar imagexylus ( 2018-01-05 20:40:22 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 1,402 times

Last updated: Jan 05 '18