Why can't I print a spreadsheet

Can only print text as none of the icons allow printing rows and columns

One can select the cells, rows, columns, sheets, entire Calc file by using the required settings.

If you want to select a certain area of a sheet, select this area
Open File > print > General (tab) > Select: “selected cells”.

The selected area could also be 1 or more columns or 1 or more rows.