I am having to switch from MS Office to Libreoffice, but one major problem seems to be mailmerge. I have now spent several hours trying to create a schedule document. The details of the schedule are kept in a spreadsheet and used to update a writer template. I have figured out - I think - how to link the spreadsheet via Edit - Data Exchange and then View - Data Sources. However had a huge amount of trouble trying to place fields on the page and get them to show any sensible data. Initially fields would show data then they would not then it would all get scrambled.
I eventually managed to get it working to a fashion by selecting all the rows in the Data Sources and using the Data to Text icon. This placed fields for all records onto the page. I then had to laboriously copy each field into its proper location on the page starting from the last to the first. I then managed to get all the data where it should be.
The problem now is, when I update anything in the spreadsheet, it does not get updated in the writer template. Ctrl-F9 toggles between the field codes and actual data but F9 seems to do nothing. I still get the old data. I can see the updated information in the Datat Sources view correctly, just no on the page.