He did get around. He would totally get with anyone that said yes. But at the same time he wouldn’t try to get between a widow and his captain.

EDIT: He literally sleep with people while on away missions. “First Contact” he got coerced by the doctor into sex to stay safe.