[libreoffice-users] Re: Calcultated fields in query (how to output in currency format) ?

Am 31.03.2015 um 12:23 schrieb xavier2:
> Yes, I suspect this is impossible, we cannot have a "currency" variable,
> because we would have to have thousands of different variables according the
> thousands of currencies in the world. What BASE can do is to format the way
> the output is presented to the user, however, sadly I've discovered that
> even if you change the format of a query to show the results in euros, for
> example, sadly, LibreOffice Base don't remember the field format. I've
> documented this as a bug: 
> https://bugs.documentfoundation.org/show_bug.cgi?id=90360
> But, yes, since a SQL point of view, it's impossible to show the value with
> the currency format. You are right.
> Cheers

The grid views of your tables and queries are simple visualisations of
database content and query results. All you can do with this is reading,
editing, sorting and filtering of raw data in most simple data grids.
The user interface consists of office documents carrying forms and
reports. There you can format and layout everything to your liking and
you can export your reports to other file formats.

One thing you may try: Open the table for editing where your query
fetches the currency values from. Near the bottom of the table design
window you find a formatting option. As far as I remember, this is the
place where the default formatting can be saved for a table field and
derived objects such as queries, Writer fields and data source window.

Cheers


-- 
To unsubscribe e-mail to: users+unsubscribe@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