[Solved] Position middle vs bottom of row

Discuss the spreadsheet application
Locked
Oskar4U
Posts: 98
Joined: Thu Mar 18, 2021 1:30 am
Location: Quebec, Canada

[Solved] Position middle vs bottom of row

Post by Oskar4U »

Using Libre Office Calc 25.2.3 when I type in a row it always goes to the bottom of the row. Then I go to format and select middle of the row. Is there a way to have the middle of the row permanent ?

Many thanks
Last edited by MrProgrammer on Wed Feb 25, 2026 10:20 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Nicolas
LibreOffice 7.5.4.2 in Windows11
User avatar
Zizi64
Volunteer
Posts: 11505
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Position Middle vs Bottom of Row

Post by Zizi64 »

Oskar4U wrote: Wed Feb 18, 2026 1:50 am Is there a way to have the middle of the row permanent ?
You can create and use your own Cell styles wirth the desired formatting properties. It is very easy to apply the existing cell styles to the Cells and Cell ranges.

And you can create and use you own Template files (.ots) with predefined styles and preformatted cells and cell ranges.


And you can apply one of the preferred template files as the Default template of the Calc application. Then the new spreadsheet documents will be created based on the properties of the new template file.
Last edited by Zizi64 on Wed Feb 18, 2026 8:53 am, edited 1 time in total.
Tibor Kovacs, Hungary; LO7.5.8/25.8.5.2 /Win7-10-11 x64Prof.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Oskar4U
Posts: 98
Joined: Thu Mar 18, 2021 1:30 am
Location: Quebec, Canada

Re: Position Middle vs Bottom of Row

Post by Oskar4U »

Your time is much appreciated,
Thanks
Nicolas
LibreOffice 7.5.4.2 in Windows11
cwolan
Posts: 214
Joined: Sun Feb 07, 2021 3:44 pm

Re: Position Middle vs Bottom of Row

Post by cwolan »

Zizi64 wrote: Wed Feb 18, 2026 6:13 am And you can create and use you own Template files (.ott) with predefined styles and preformatted cells and cell ranges.
Did you mean .ots?
OpenOffice 1.1.5 – 4.1.16
LibreOffice 3.3.0.4 – 26.2
Windows 7,10,11 64-bit
User avatar
Zizi64
Volunteer
Posts: 11505
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Position Middle vs Bottom of Row

Post by Zizi64 »

Did you mean .ots?
Yes. I fixed it in my answer.
Tibor Kovacs, Hungary; LO7.5.8/25.8.5.2 /Win7-10-11 x64Prof.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Locked