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: [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
