Full electromagnetic Green's dyadic of spherically symmetric open optical systems and elimination of static modes from the resonant-state expansion