Re: [libreoffice-users] Formating fields in mail merge

Thank you so much for sharing this information with us!!!!!! This is 
what makes the LibreOffice community a community!!!!!

Don

On 09/05/2011 10:37 AM, David Buckley wrote:
> 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