The transition between sharp and diffusive wetting fronts as a function of imbibing fluid properties