Page 1 of 1

[Solved] Align text vertically

Posted: Thu Jan 30, 2020 12:53 pm
by robp
Hello I'm new to this and so I hope that I'm in the correct place.

I need to create a simple spreadsheet but with a lot of columns that will still show on A4 landscape. Therefore I will need to use vertical orientation on the column headings. Even better, angled ones. The actual column in the sheet can just be wide enough for a "tick" or a "1".

Any help gratefully received

Thanks Rob

Re: Columns in cal

Posted: Thu Jan 30, 2020 1:38 pm
by robleyd
Look at Format | Cells and under Alignment play around with Text Orientation and Vertically Stacked.

Re: Align text vertically

Posted: Thu Jan 30, 2020 2:54 pm
by robp
Thanks robleyd. That's good, yes it achieves what I wanted. I.e. being able to get a lot of columns per printed page. If I could get the column header cells angled at say 45 degrees it would be nice but not essential.
Thanks again

Re: Align text vertically

Posted: Thu Jan 30, 2020 11:33 pm
by robleyd
Not possible with a spreadsheet. If you are only interested in printed output - i.e. no calculation involved - you might be better off with desktop publishing software. Possibly Scribus could do what you want.

Re: Align text vertically

Posted: Mon Feb 03, 2020 9:33 am
by robp
David. It's a spreadsheet I need. It's fairly standard, I just can't see how to do it. I've found vertical texting which gives me more columns but 45degrees headings would be better

Re: Align text vertically

Posted: Mon Feb 03, 2020 10:29 am
by robleyd
You can set the text to any angle you want, but that will cause the column width to increase to accommodate the text. As I mention above, you can't make the cells "slanted".

Re: Align text vertically

Posted: Mon Feb 03, 2020 11:57 am
by robp
Maybe then it's something that you can do in Excel but not Calc. I have images of what I want.

Re: Align text vertically

Posted: Mon Feb 03, 2020 1:41 pm
by robleyd
In fact, with a little fiddling, you can get something approximating what I think you are trying to do.
oo_slant_text.png
slant_text.ods
(8.5 KiB) Downloaded 337 times

Re: Align text vertically

Posted: Mon Feb 03, 2020 3:21 pm
by robp
Yes that's exactly it. Many columns and headers easy to read. I'll keep at it. Thanks