I working in Libreoffice 220.127.116.11 in Ubuntu. I have a text file that has some columns of text and columns of numbers. When I import them into Calc either by copying and pasting or saving as a csv and opening in Calc the columns containing numbers are changed to text and I can't use them in calculations. I have tried using different delimiters and changing the text file from Unix to Windows encoding (I don't remember this happening on my windows box at work) but the results are always the same.
In other words if I import a file containing the lines
Course,Credit Hours Course, Grade Received,Grade Point Value,Grade Points Beg Comp (ENGL 1100),3,C,2 Med Term (MULT 1010),2,C,2
The 3 in the second column of the second row shows up visually as the number 3, but if I go to the cell formatting it shows "Text" and it can't be used in calculations. It is apparent at first glance because the default alignment for text is left justified in the cell and a number would be right justified.