Ask Your Question

Set cells as column labels

asked 2017-05-19 23:11:32 +0100

FabioLima gravatar image


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

image description

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

image description

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!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-05-21 12:20:44 +0100

librebel gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-05-19 23:11:32 +0100

Seen: 921 times

Last updated: May 21 '17