Re: [libreoffice-users] LO spreadsheet format row

At 11:32 28/03/2016 -0400, Helen Etters wrote:
> Is there a way, in L.O. spreadsheet, to lock the rows so that a row 
> cannot take more than one line?

The default formatting of cells means that text does not flow to 
further lines in a cell unless either you enter Ctrl+Enter to create 
a line break or you tick Format | Cells... | Alignment | Properties | 
Wrap text automatically.

> So that all rows have the same height.

Even if you allow multiple lines, you can easily reset any row height 
to whatever you want.

> Freeze doesn't seem to do that.

That's not surprising: Freeze does something else entirely.

Do you perhaps mean that you want others to be able to use the 
spreadsheet and to modify it, but not to modify the height of a 
particular row or rows? You can do that by protecting the row or 
rows, but that also prevents modification of other features of those 
rows, including their contents - which you may not want. To avoid 
that, you could protect a single otherwise unused cell in any such 
row; other cells in the row could then be modified. The problem is 
that this appears to prevent explicit changes to the row height - by 
dragging the row boundary or setting the height via the menus - but 
not automatic ones through "Wrap text automatically" or ones 
stimulated by Ctrl+Enter line breaks.

o Click the rectangle where the row and column headers meet (or press 
Ctrl+A) to select the entire sheet.
o Go to Format | Cells... | Cell Protection | Protection and remove 
the tick from Protected.
o Select the row or rows you want to protect or the unused cell or cells.
o Go to Format | Cells... | Cell Protection | Protection and tick Protected.
o Now go to Tools | Protect Document > | Sheet... and enter your password.

But I fear that this will not achieve what you need.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted