[Solved] Align text vertically

Discuss the spreadsheet application

[Solved] Align text vertically

Postby robp » Thu Jan 30, 2020 12:53 pm

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
Last edited by Hagar Delest on Mon Feb 03, 2020 10:40 pm, edited 2 times in total.
Reason: tagged solved
Open Office 4.1.1 on Windows 10
robp
 
Posts: 5
Joined: Thu Jan 30, 2020 12:45 pm

Re: Columns in cal

Postby robleyd » Thu Jan 30, 2020 1:38 pm

Look at Format | Cells and under Alignment play around with Text Orientation and Vertically Stacked.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3456
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Align text vertically

Postby robp » Thu Jan 30, 2020 2:54 pm

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
Open Office 4.1.1 on Windows 10
robp
 
Posts: 5
Joined: Thu Jan 30, 2020 12:45 pm

Re: Align text vertically

Postby robleyd » Thu Jan 30, 2020 11:33 pm

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.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3456
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Align text vertically

Postby robp » Mon Feb 03, 2020 9:33 am

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
Open Office 4.1.1 on Windows 10
robp
 
Posts: 5
Joined: Thu Jan 30, 2020 12:45 pm

Re: Align text vertically

Postby robleyd » Mon Feb 03, 2020 10:29 am

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".
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3456
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Align text vertically

Postby robp » Mon Feb 03, 2020 11:57 am

Maybe then it's something that you can do in Excel but not Calc. I have images of what I want.
Open Office 4.1.1 on Windows 10
robp
 
Posts: 5
Joined: Thu Jan 30, 2020 12:45 pm

Re: Align text vertically

Postby robleyd » Mon Feb 03, 2020 1:41 pm

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 23 times
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3456
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Align text vertically

Postby robp » Mon Feb 03, 2020 3:21 pm

Yes that's exactly it. Many columns and headers easy to read. I'll keep at it. Thanks
Open Office 4.1.1 on Windows 10
robp
 
Posts: 5
Joined: Thu Jan 30, 2020 12:45 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests