1

In libreOffice when I write in a cell, I need if the size of the text gets more than its size, the end of the text doesn't disappear and cell's height gets expanded. From the path: Format > Cells.. > Alignment I select 'Wrap text automatically' but when I write more than the size, it's not showed compeletely again and will be remain like this:

enter image description here

What should I do?

1
  • Hi H., did you notice the edited answer? Please mention. Sep 7, 2016 at 12:11

2 Answers 2

2

By default, the cell expands, like you mention.

Unless...

You force the cell to a certain hight by clicking on the row on the left, choose Row hight (Rijhoogte in Dutch):

enter image description here

Example:

This

enter image description here

becomes:

enter image description here

How to save the time to set all rows individually

Although I couldn't find any setting to change the default behaviour for cells/rows, you can easily work around:

  • In a new document, before changing cells etc, click in the top/left blank square, where rows/columns cross each other, to select all cells/rows.
  • Right- click on the left of first row, Choose Row hight, simply press return.
  • Again, while all cells/rows are selected, right- click on the left of first row, choose Format > Cells.. > Alignment, set to wrap.

Now the document will behave like you want, for all cells in all rows.

2
  • I don't want to change the row height for each row separately! Is there any way that it automatically get expanded?
    – M. Hossein
    Sep 5, 2016 at 9:43
  • @M.Hossein, select all the cells by clicking the box to the upper left between column A and row 1. Then adjust row height and column width with a right click on any one of the columns and any one of the rows and it will apply to the whole sheet. Oct 11, 2022 at 15:36
0

Finally I found out that in order to solve this problem I can double click on the line of borders which the related cell gets expanded

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .