Set cells as column labels

Greetings!

I’m new to LibreOffice so that may be ridiculously easy to solve so I apologize in advance. I’m trying to take data from a Calc spreadsheet and input it as a field in Writer. Basically using a Calc spreadsheet as a database to Writer fields. To do so, I setted the spreadsheet as a database, as follows*:

*: My LibreOffice is in pt-Br

After setting it as a database, Writer reads it like this:

In my understanding, Writer is interpreting all itens in the first line as labels for the content on the following lines. My question is, how do I switch it up? Making it read all values in the A column as labels, and the cell contents of the B column as their contents?

Maybe there is a simpler way to do what I need. I am currently using data from the spreadsheet as field to be read and inserted by Writer. I tried pasting the cells in my form as a DDE Link but it pastes it like it’s a cell, and I need it to be just it’s data.

Not sure if I made myself clear, I hope you guys understand it.
Thanks in advance!

Hello @FabioLima,

In a spreadsheet the Columns represent the “Fields” and the Rows represent the “Records”, so i think the first Row in your sheet should contain the field names ( Nome, Endereco, Telefone, Cidade ), and the second Row should contain the field values ( ABC, Rua ABC, 12345, DEFGH ).

Please refer to this wiki page for more information.