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.
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.
@Mike Kaganski was faster.
Asked: 2018-01-05 07:34:20 +0100
Seen: 4,632 times
Last updated: Jan 05 '18
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
It could help if you attached a one-cell example here (put it on an external share, and edit question to post a link).
OK, but what exactly are you doing?
@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.