[libreoffice-users] Formating fields in mail merge

I have been trying to format currency fields in libreoffice using fields
from tables and queries in base, after many tests I have found the
solution to my problem which gives a proper currency output.

If I right click the column in the open table of the database it can be
formatted to currency or any of the other options and this will feed the
format to a query or mail merge and will store the setting for next
time. This works fine if the data is in a table and no further action is
needed. 

If I need to use a field in a query that is calculated in the query from
a value in a table (like "costone" / 2) the column can be formatted in
the query but the format does not carry to the mailmerge. Also the
format cannot be saved.

The answer is, open the mailmerge starting document, right click on the
field to be formatted, select "fields" from the list, under "format"
select "user defined", open the combi box that says "general", select
"additional formats" and select the one you need. Save the document then
do the mailmerge.   

Hope this helps someone as I could not find an answer

David


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted