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: [email protected] 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
