OpenOffice Row Height resetting on each edit / sheet opening

The issue is about Optimal Row Height. I was tired of setting Optimal Row Height each time, to reveal the text that just hid.

Optimal Row Height is the spacing between largest character in the Row and Row boundary with other rows. Row Optimal Height can be either set Manually, or it switches to default. My default was set to 0.0. This hid the text on each Edit / Open.

I modified the setting by
  1. Selecting the entire rows (Ctrl-a)
  2. Right-Click on any row number, e.g. 1, 2 etc.
  3. Select Optimal Row Height
  4. Tried various settings, i.e. 0.1, 0.05, 0.2
  5. Settled with 0.1, as the spacing is optimal for the view
Let me know if this doesn't work for anyone.


Popular posts from this blog

AWS RDS incompatible-parameters solved

504 Gateway Timeout on Amazon AWS ELB (Elastic Load Balancer)