Spreadsheet icon indicating copy to clipboard operation
Spreadsheet copied to clipboard

Cells does not wrap text if it's too long.

Open SkyzohKey opened this issue 8 years ago • 2 comments

SkyzohKey avatar May 03 '17 06:05 SkyzohKey

The screenshot that @SkyzohKey uploaded seems to be gone, so I guess it was something like the following screenshot.

Screenshot from 2019-07-31 20-15-52

The A1 cell text is too long that it is overlapped to the left cell.

Screenshot from 2019-07-31 20-39-10

Also, if there is some text in the next cell, the spilled cell text is still shown and the two texts are overlapped.

I was curious about how other spreadsheet apps address text wrapping, so I searched a little.

Unfortunately, I can't see how about Excel (the desktop app), because I don't have it. Instead, I checked in Excel Online because I think how to handle text wrapping is essentially the same in Excel and Excel Online.

Screenshot at 2019-07-31 201203

In Excel Online, the long text is not wrapped and spilled out to the right cell. However, selecting "Wrap Text" wraps spilled text.

Screenshot from 2019-07-31 20-29-39

Also, if the next cell has some text, the spilled text is hidden.

LibreOffice also handles wrapping text in the same way.

So, I think it's OK to spill out long texts by default, but we may want to:

  • provide an option to wrap long texts
  • hide the spilled text if there is some text in the next cell

as other spreadsheet apps do?

ryonakano avatar Jul 31 '19 11:07 ryonakano

Sounds good to me :+1: When doubting about things like that, I think it is generally a good idea to just follow what other apps does, as it is probably what is expected.

elegaanz avatar Jul 31 '19 19:07 elegaanz