It only negates the health lost when you use a move that activates Sheer Force. If you use a move boosted by Sheer Force, like Ice Punch or Waterfall, you will not lose health from Life Orb. But if you use a move which is not boosted by Sheer Force, like Earthquake, you would still receive recoil.
Hope I helped!