Format word wrap in Calc not working on long list

I just finished a list inside Calc of last names, some 30,000 of them. The problem is, at the column width (0.8") I decided on, the wider ones are not wrapping.

Yowell Ainsworth
Aglibam Bell
Scepurek-Mcdonald
Radford-Jackson
Parker-Reynolds
Jurgan-Burton
Higginbotham
Green Mayfield

Just for fun I selected a few of them and placed them into a different column on that same sheet. Amazingly, they wrap just fine.
I just finished a list of last names, some 30,000 of them. The problem is, at the column width (0.8") I decided on, the wider ones are not wrapping.

Yowell Ainsworth
Aglibam Bell
Scepurek-Mcdonald
Radford-Jackson
Parker-Reynolds
Jurgan-Burton
Higginbotham
Green Mayfield

Just for fun I selected a few of them and placed them into a different column on that same sheet. This way they wrap just fine.
image description

I’m guessing that LO Calc simply cannot manage the wrapping feature in a list this large but thought I’d give the forum a stab at some solution – or a workaround.

Hello,

Do not know the answer to your problem but I am posting to let you know I have an 80,000+ row Calc file. I changed the city name column to your specs. Had no problem. Quick look shows all wrapping. Added another at the end & it wrapped also.

Did this on Ubuntu 20.04.1 Mate with LO v7.0.3.1 from TDF (The Document Foundation).

Hopefully someone else has an answer for you.

@fatfreek,

You should note your OS and Specific LO version.

Select all cells (can use Ctrl+* if no data in columns E and G) or select the column F (just clicking in the column heading).

Choose menu Format - Cells… (the same that Ctrl+1) - Alignment tab, and check Wrap text automatically.

Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.


Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.

Check the mark (Answer markCorrect answer mark) to the left of the answer that solves your question.

Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 10 Home, Build 19041.630

And it works now?

If not solved, you can click edit below your question and use the paper clip to upload a sample file (remove all sensible data before).

No, LeroyG, it still doesn’t work. Just providing more specifics of my OS version and LO version.

I have the same problem. Double-clicking the row header adjusts the height to make it fit, but eventually it will go back to its un-fitted state with a small red arrow at the LHS of the cell to indicate that there’s an overflow. Just saving it is sometimes enough to reset the cell to the default single-row height. I’ve tried setting the row height and optimal row height using for a row, but nothing fixes it.