Centering vertically

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=1T7t0lgnNSsKMPzNneWIid_noIfA--vNL

Thank you in advance.

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

what I am trying to achieve:

OK, but what exactly are you doing?

@mikekaganski: 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.

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.

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.

@mikekaganski was faster.

Thank you. Modified the condition.