On 6/28/21 4:55 PM, Dave Fisher wrote:
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
Dave,
Oops. I should have provided that:
OpenOffice 4.1.10, AOO4110m2(Build:9807) - Rev. b1cdbd2c1b
2021-04-19 18:17 - Linux i686
on Slackware 14.2 Linux K4.4.261.
In this case I am using "Liberation Sans" 8pt "Regular" with no effects
and "Wrap text automatically" checked in the alignment dialog. The font
is on my system -
liberation-fonts-ttf-1.07.4-noarch-1 :
...
usr/share/fonts/TTF/LiberationSans-Bold.ttf
usr/share/fonts/TTF/LiberationSans-BoldItalic.ttf
usr/share/fonts/TTF/LiberationSans-Italic.ttf
usr/share/fonts/TTF/LiberationSans-Regular.ttf
usr/share/fonts/TTF/LiberationSansNarrow-Bold.ttf
usr/share/fonts/TTF/LiberationSansNarrow-BoldItalic.ttf
usr/share/fonts/TTF/LiberationSansNarrow-Italic.ttf
usr/share/fonts/TTF/LiberationSansNarrow-Regular.ttf
...
HTH
Girvin
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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
