I have a simple MySql query that returns a currencyrate and the date of the currencyrate. My column names are “rate” and “dtrate”. When I drag the query to my spreadsheet both the column names and the two values are inserted. But I do NOT want the column names, just the values. When I enter menu item Data->Define Range->Options there is a checkbox “Contains column labels”. I have tried both checked and unchecked but in both cases I get the labels as well. Is this a bug or am I doing wrong?
I am on Mac 10.12.4 and LibreOffice 5.2.6.2.
In the Windows environment (with Office 2003) there is a similar option to avoid column names and there it works.
Can anyone please help?
