Every blue moon I need to export a list of books from a spreadsheet into a writer document. I still follow the steps some smart people explained to me in this thread long ago.
viewtopic.php?f=7&t=57131&p=251768#p251768
I am using a spreadsheet as a data source for Writer. So I can insert a long list of books to Writer. I want to do some layout on the list. So I export the first line on the spreadsheet with the data to field feature. Then I do some lay-out in Writer, so it looks like this example:
This is what the fields look like:Jeffries, Stuart
Grand Hotel Abyss
The lives of the Frankfurt School
2017, 448 pag., €17.95
Verso, London, ISBN 9781784785697[/b]
Who were the Frankfurt School — Benjamin, Adorno, Marcuse, Horkheimer — and why do they matter today? Grand Hotel Abyss combines biography, philosophy, and storytelling to reveal how the Frankfurt thinkers gathered in hopes of understanding the politics of culture during the rise of fascism.
Trefwoorden: Filosofie
After that I copy/paste these fields to a lot of pages in Writer.
Then I select all the tables from the spreadsheet and click the Data to fields button. This populates the Writer document with all the books.
This works really nice and gives me the list I want.
But after that I cannot edit the contents of the fields in the writer document anymore. I am 100% sure I could do this in the past.
If I click on a field Writer highlights the content of the full field.
if I double click on a field Writer opens a new "Edit Fields" box, but there is no option to actually edit the content of the field.
I am I missing something or is this a bug?
Only workarounds I found so far, is doing all the editing on the source spread sheet and repeat the steps to insert the data in the Writer document. Or I save to a word document (.doc) and edit the file online with MS office. Both work, but both are suboptimal.
This is on Ubuntu 19.10 and the included LibreOffice 6.3.4.2