[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-l10n] Test CONVERT function


Hi Mihovil,

On Tuesday, 2013-07-16 23:56:35 +0200, Mihovil Stanic wrote:

> >>Can someone please test CONVERT function.
> >>I can't get it to work.
> >Note that (due to legacy reasons, whatever) the UI visible CONVERT is
> >not the ODF CONVERT, but CONVERT_ADD is. They are two different
> >functions. Yes, this is confusing and it should be addressed in some
> >release.
> >
> > Eike
> >
> Well, I still don't understand why it's there if it's not working,
> but atleast I'll not bug my self with it any more.

It works, but it is not an implementation of the ODFF CONVERT function
(which CONVERT_ADD is). It takes its conversion factors from the
configuration, predefined are the Euro conversions (the function
predates the EUROCONVERT function), but also others are possible. See
online help for 'CONVERT function', an example is
=CONVERT(100;"EUR";"DEM")

Eike

--
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key ID: 0x65632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A
For key transition see http://erack.de/key-transition-2013-01-10.txt.asc
Support the FSFE, care about Free Software! https://fsfe.org/support/?erack

--
To unsubscribe e-mail to: l10n+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/l10n/
All messages sent to this list will be publicly archived and cannot be deleted

References:
[libreoffice-l10n] Test CONVERT functionMihovil Stanic <mihovil.stanic@gmail.com>
Re: [libreoffice-l10n] Test CONVERT functionEike Rathke <erack@redhat.com>
Re: [libreoffice-l10n] Test CONVERT functionMihovil Stanic <mihovil.stanic@gmail.com>
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.