You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Prof <pr...@gmail.com> on 2020/06/10 21:53:40 UTC
Another spreadsheet formatting query
Having had my cell colours query sorted so quickly by you very helpful people, I’m gonna push my luck because I have discovered another one!
I am finding that apparently random rows do not set themselves to my selected ‘optimal height’?
See attached extract from a recordings catalogue. Optimal row height default value is set to 0.0 cm, and many rows appear to set themselves to this. Note however the rows for the following artists/albums (columns A & B). I’d really appreciate it if someone can identify what creates the wider row spacing?
Ruby Braff Hear me talkin’!
Ry Cooder The slide area
Shakatak Out of this world
Steve Forbert Jackrabbit slim
Steve Miller Band Greatest hits
Steve Miller Band Abracadbra
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Another spreadsheet formatting query
Posted by Martin Groenescheij <ma...@groenescheij.com>.
Optimal Row Height is not the same as Optimal Column Width
On 10/06/2020 23:55, David Deeks wrote:
> Sorry, here’s attachment ! ...
>
>> On 10 Jun 2020, at 22:53, Prof <pr...@gmail.com> wrote:
>>
>> Having had my cell colours query sorted so quickly by you very helpful people, I’m gonna push my luck because I have discovered another one!
>>
>> I am finding that apparently random rows do not set themselves to my selected ‘optimal height’?
>>
>> See attached extract from a recordings catalogue. Optimal row height default value is set to 0.0 cm, and many rows appear to set themselves to this. Note however the rows for the following artists/albums (columns A & B). I’d really appreciate it if someone can identify what creates the wider row spacing?
>>
>> Ruby Braff Hear me talkin’!
>> Ry Cooder The slide area
>> Shakatak Out of this world
>> Steve Forbert Jackrabbit slim
>> Steve Miller Band Greatest hits
>> Steve Miller Band Abracadbra
>>
>>
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
Re: Another spreadsheet formatting query
Posted by David Deeks <pr...@gmail.com>.
Sorry, here’s attachment ! ...
> On 10 Jun 2020, at 22:53, Prof <pr...@gmail.com> wrote:
>
> Having had my cell colours query sorted so quickly by you very helpful people, I’m gonna push my luck because I have discovered another one!
>
> I am finding that apparently random rows do not set themselves to my selected ‘optimal height’?
>
> See attached extract from a recordings catalogue. Optimal row height default value is set to 0.0 cm, and many rows appear to set themselves to this. Note however the rows for the following artists/albums (columns A & B). I’d really appreciate it if someone can identify what creates the wider row spacing?
>
> Ruby Braff Hear me talkin’!
> Ry Cooder The slide area
> Shakatak Out of this world
> Steve Forbert Jackrabbit slim
> Steve Miller Band Greatest hits
> Steve Miller Band Abracadbra
>
>
>