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
> 
> 
>