I prepared a Calc spreadsheet detailing my students’ exam results and averaged grades.
I would like to print a slip of paper for each student listing their results.
I set up a Writer document and followed these steps:
to use my spreadsheet as a database. This worked fine.
I later spotted a few small errors in the original spreadsheet, so I updated and saved the spreadsheet. I thought I could just hit the Refresh/Rebuild button in the Writer toolbar to read the fixed data into Writer but that doesn’t seem to work; the updated numbers only appeared in the Writer document after I essentially started over by going back to the Writer menu Edit > Exchange Database…, re-selecting the spreadsheet, and dragging the relevant fields into the Writer document again.
Is there a more elegant way to do this?