I think John from the Docs Team could use some help with the "Convert" function. I think the
1. Is it possible for a normal user to edit the lists used in the Convert function
2. how to do 1 if it is possible?
3. Are other people having trouble with Convert in 4.1.x?
4. Is Convert now legacy and unsupported having been replaced by a newer function (i've forgotten
the name but i'm sure they mentioned the name of a replacement)?
From: John Smith <firstname.lastname@example.org>
To: documentation <email@example.com>
Sent: Tuesday, 17 September 2013, 21:45
Subject: [libreoffice-documentation] CONVERT function in Calc
I'm working on the Appendix B chapter for Calc and I am looking at the
=CONVERT function. This function converts a numerical value from one
unit of measure, to another unit of measure in the same group, for
example feet into yards, both in the distance group.
Within the dialogue of the Function Wizard is a statement "Converts a
value according to a conversion table in the configuration (main.xcd)".
My question is basically a two parter; is this list available to a user,
and if so how do you access it? and because the two parameters in the
function for units are both case sensitive and entered inside quotes,
how do you find what the valid entries are for these parameters?
The syntax is CONVERT(Number, "text", "text") where text is the unit of
I have tried a few of the entries which I found here;
such as "lbm" and "stone" for mass, "pt" and "qt" for volume and "ft"
and "in" for distance, without success.
Pulling my hair out here:-) . Please help.
To unsubscribe e-mail to: firstname.lastname@example.org
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
- [libreoffice-users] CONVERT function in Calc · Tom Davies
Impressum (Legal Info)
: 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