Spreadsheets did not replace programmers, they mostly changed who could build small solutions. A lot of quick calculations and internal tools moved to spreadsheets, while developers focused more on building systems around them. In many teams it actually increased the need for proper software later on.