[Solved] Multiple lines in cell

Discuss the spreadsheet application

[Solved] Multiple lines in cell

Postby MyBrady » Thu Jan 09, 2020 1:20 pm

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
MyBrady
 
Posts: 4
Joined: Thu Jan 09, 2020 1:07 pm

Re: multiple lines in cell

Postby RoryOF » Thu Jan 09, 2020 1:33 pm

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.7 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31534
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: multiple lines in cell

Postby MyBrady » Thu Jan 09, 2020 1:54 pm

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
MyBrady
 
Posts: 4
Joined: Thu Jan 09, 2020 1:07 pm

Re: multiple lines in cell

Postby RoryOF » Thu Jan 09, 2020 2:14 pm

Screenshot_2020-01-09_12-13-10.png
It works for me. See attached screenshot
Apache OpenOffice 4.1.7 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31534
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Multiple lines in cell

Postby MyBrady » Thu Jan 09, 2020 4:43 pm

screen shot.tiff
screen shot.tiff (41.24 KiB) Viewed 371 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

Postby MyBrady » Thu Jan 09, 2020 5:50 pm

Ha, problem solved, just Preview in web browser.
Open Office 4.1.3 on Mac OS X El Capitan
MyBrady
 
Posts: 4
Joined: Thu Jan 09, 2020 1:07 pm


Return to Calc

Who is online

Users browsing this forum: fiona87, FJCC and 23 guests