LibreOffice Calc combined with python's pandas and numpy modules meet all needs I have for spreadsheets, with matplotlib and seaborn for visualization. The Ipython shell is the optimal IDE for this approach IMO. My desktop reference is:
"Python for Data Analysis 2nd ed" (Wes McKinney, 2018)
"Python for Data Analysis 2nd ed" (Wes McKinney, 2018)