"Mail merge embedding of the datasource (Miklos Vajna, Collabora)" was added for 5.1 https://wiki.documentfoundation.org/ReleaseNotes/5.1#Writer. The idea behind is really fantastic, no need for carry the odb file and have it registered. I think it would be great for others purposes in writer and other LibreOffice apps, in particular I have in mind calc, for the sames reasons than Mail Merge. In a calc file having sql queries on itself with only one file, as example.
Hi Miguel, I agree that this would be good to have. (Although personally I prefer to work with data sources for mail merge, since I usually make merges from the same sources.) Ciao - Cor
Hi Cor, thanks for set up. I think having it in calc or with other task in writer, doesn't need modify the actual behavior for mail merge. Perhaps I was not clear enough, I refer to embed all kind of odb files not only those linked to spreadsheets as database. Specially in calc it can be invaluable, e.g. in an enterprise environment, avoiding to register the odb in every computer, so you can access everywhere to server data in a transparent way, only opening the ods file. Currently without macros there is no option to have sql queries in spreadsheets without the odb file, so having it embedded it's not the same but a good approximation. And I think except those having inner data, odb files only have a few Kb of size, so to increase the file should not be an issue. Ciao, Miguel Ángel.
@Miguel, yes it's perfectly clear that this is a valuable enhancement!