During the import of text files into a spreadsheet, various problems can occur that prevent Calc from recognizing numeric values.