When set to Automatic, the CellSize is different, so the Sprite Pivot is not displayed properly and the animation is not displayed properly.
I uploaded a picture file showing CellSize, so if you set it like the picture below, the animation will work properly.