Enhanced gas sorption properties and unique behavior toward liquid water in a pillared-paddlewheel metal-organic framework transmetalated with Ni(II).