Calc is combining spreadsheet data all into one column when opening the file. [closed]
The files are .ss files (made in Android Simple Spreadsheet). When I try to open them in Calc, all the data is smushed into a single column, it's all in order but not organized like it should be. Here's a link to a picture: http://s12.postimg.org/e2wian9jx/Spreadsheet_issue.png (not enough karma to upload yet). Each of the capitalized words should be it's own column, with the appropriate data below it, not all together.
I don't understand. That is a picture of the Text Import dialog. Is the SS file format equivalent to CSV? Are you expecting the values displayed to somehow be further separated e.g., by colon?
The first few entries(the capitalized ones) are supposed to be each a separate column(there are 4 all together) but when I open the file in Calc, there is only one column.
"the capitalized ones". If this is a reference to "DAY", "SHIFT", "PICKUP", and "DROPOFF" then I am afraid that as @ROSt52 indicates below, this Text Import dialog is appearing because LO has no idea what the SS file format is. You are going to have to export the data from the Android app into a different file format (i.e., CSV) in order to import it into Calc.