How do I suppress spreadsheet cell overflow in Open Office

Environment
Open Office for Mac v4.1.1
.ods or .xls file extension

Select entire sheet by tapping on top left cell or clicking Command-A (Mac OS)
Right click any cell and select "Format Cells..."
Select Alignment > Wrap Text Automatically

To suppress overflow without using word wrap, select entire sheet, right click on any row number and set Row Height to something like 0.18", then select Format Cells again and set Alignment > Vertical to Top.