[Solved] Multiple lines in cell

Discuss the spreadsheet application
Post Reply
MyBrady
Posts: 4
Joined: Thu Jan 09, 2020 1:07 pm

[Solved] Multiple lines in cell

Post by MyBrady »

I can create multiple lines in a spreadsheet cell but I can't see the all cell contents, only the single cell being written. I want the contents of all the cells to appear when printed.
Last edited by Hagar Delest on Thu Jan 09, 2020 9:58 pm, edited 1 time in total.
Reason: tagged solved
Open Office 4.1.3 on Mac OS X El Capitan
User avatar
RoryOF
Moderator
Posts: 34612
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: multiple lines in cell

Post by RoryOF »

Choose /Format /Cells : Alignment tab, 'Wrap text automatically'.

You might wish to select /Tools /AutoCorrect Options, Options tab, and uncheck 'Capitalise first letter of every sentence'.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
MyBrady
Posts: 4
Joined: Thu Jan 09, 2020 1:07 pm

Re: multiple lines in cell

Post by MyBrady »

RoryOF wrote:Choose /Format /Cells : Alignment tab, 'Wrap text automatically'.

You might wish to select /Tools /AutoCorrect Options, Options tab, and uncheck 'Capitalise first letter of every sentence'.
This only makes the active cell visible, not every cell that has multiple lines.
Open Office 4.1.3 on Mac OS X El Capitan
User avatar
RoryOF
Moderator
Posts: 34612
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: multiple lines in cell

Post by RoryOF »

Screenshot_2020-01-09_12-13-10.png
It works for me. See attached screenshot
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
MyBrady
Posts: 4
Joined: Thu Jan 09, 2020 1:07 pm

Re: Multiple lines in cell

Post by MyBrady »

screen shot.tiff
screen shot.tiff (41.24 KiB) Viewed 2680 times
Thank you for the reply.
This is what my screen looks like. I hope this works!
Open Office 4.1.3 on Mac OS X El Capitan
MyBrady
Posts: 4
Joined: Thu Jan 09, 2020 1:07 pm

Re: Multiple lines in cell

Post by MyBrady »

Ha, problem solved, just Preview in web browser.
Open Office 4.1.3 on Mac OS X El Capitan
Post Reply