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
--
View this message in context:
http://nabble.documentfoundation.org/Calcultated-fields-in-query-how-to-output-in-currency-format-tp4144868p4145004.html
Sent from the Users mailing list archive at Nabble.com.
--
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
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.