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!