Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.