I have a calc spreadsheet with customer information, one row per customer. I generate invoices using a writer document via mail merge from this spreadsheet.
The spreadsheet has some date fields that I need to use as mail merge fields. I would like to vary the date format according to the customer’s language and country. I therefore chose “from database” for the date format of the date fields in the writer document. I understand this is supposed to use the date format that exists in the spreadsheet. This should allow me to have different date formats for different rows (different customers).
Unfortunately, this doesn’t work. The spreadsheet’s date format (for cells containing the date fields) does not appear in the Write document upon mail merge. I think this is a Libreoffice bug, but I’m posting this issue here first as a question in case I’ve missed something.