Sent from my iPhone
> On Jun 28, 2021, at 4:45 PM, Girvin Herr <ghe...@fastmail.com> wrote:
>
>
>> 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.
What you describe is a font metrics problem where the metrics used don’t match
the font used. Can you describe your OS version, OpenOffice version, font
including style and size selected, and if that font is present in your system.
Regards,
Dave
>
>> 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
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
