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

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:
But, yes, since a SQL point of view, it's impossible to show the value with
the currency format. You are right.

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.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.