Charge-Transfer-Like π→π* Excitations in Time-Dependent Density Functional Theory: A Conundrum and Its Solution.