In Excel I used to do this by using . I have some spreadsheets from Excel with two or more lines of text and I’d like to continue the practice. But in Calc using acts just like . What is the Calc equivalent?
Select the cell containing your text. Then, go to Format - Alignment - Justified.
First select the cell. Go to Format - Cells. Hit the Alignment tab in the dialog box. Select the check box adjacent to “Wrap text automatically”. Click the OK button. That’s all.
When just selecting the cell and pasting multiple lines, it opens the import dialog.
To paste multiple lines into the same cell, first double-click the cell to enter edit mode, then paste.