On 6/28/21 3:36 PM, Brian Barker wrote:
At 22:55 28/06/2021 +0100, David Deeks wrote:
Thanks very much for your explanation re the Text to Columns facility
Brian.
<snip>
That's not my experience or, I imagine, anyone else's.
Brian et al.,
Your imagination is wrong. I have seen it. I just saw it on one of my
spreadsheets. In my case it is sensitive to the cell's line length. If
the text ends close to the right side of the cell, but not quite close
enough to wrap, the row will be double height (wasted white space). I
deleted one character and the row jumped to the proper single height.
When I put the character back again, the row stayed the proper height. I
am pretty sure if I close the file and reopen it again, I will have the
double height back. Confirmed - I did a save and "File" -> "Reload" and
the row is back to double-height.
I have also seen the opposite - row text that is definitely two lines,
but the row is single height, making the text cropped and unreadable
until I double-click on the row bottom, then it will pop up to the
proper double height. I have no idea what is causing it. It seems
somewhat random sometimes, but random action does not apply to a
computer program. This "feature" has not been fatal to my work, so I
just work-around it.
I don't know exactly what you can be doing to cause this. Oh, you are
not saving your document in the foreign Microsoft .xls format, are
you? I'm not sure that would be the culprit, but it can cause
problems. As Joyce Grenfell said to George, "Don't do that". Use
OpenOffice's native Open Document Format formats - here .ods.
I _never_ save in M$ format.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Girvin Herr
