Calc: Reading in text data file, header row not recognized as a header

[mathprof]

My version is 3.6.2.2 running on Ubuntu.

I tried to read in a text file with column names in the first row, but LibreOfficeCalc thinks this is the first row of data.

Here’s a toy example (imagine that the white spaces are tabs); the contents of a text file:

"Col1"   "Col2"
 1   23
 2   45

Reading this in to Calc has row 1 with the column names.

Is this a bug?

[bencomp]

Did you expect the column names to have the values in the header row? That’s not how spreadsheets work. See e.g. Is it possible to change the Column and Row header names?

[oweng]

These settings work OK here under GNU/Linux using v3.5.7.2:

If you only want the data, the From row field on this dialog can be adjusted to skip N leading rows.