Thanks Shelagh and Steve.
CONVERT_ADD is the next function in the Function Wizard list, and I
hadn't yet reached that one. It looks, from reading the Help files, as
if that one supersedes CONVERT as the function to use for converting
units. I don't know why the function has been left in.
In the Help, it says; "The functions whose names end with _ADD return
the same results as the corresponding Microsoft Excel functions". But,
does opening a Calc spreadsheet containing CONVERT_ADD, in Excel, cause
an error?
Because I can't get CONVERT to work I think I may raise a bug. If it's a
dead function then it will hopefully get removed. I can't see much use
for a function for dead European currencies.
Regards
JohnS
On 17/09/2013 22:41, shelagh.man...@gmail.com wrote:
I searched on Google - apparently convert should be convert_add and
the list of units you can use (and works 'cause I tried some out) can
be found for the help of that function.
Now the question is, is it a documentation bug that the convert
function is mentioned in the help, if you are supposed to use
convert_add? Or perhaps convert is for a limited set of conversions. I
just tried the exact example given for the convert function in the
help and that works for converting deutchmarks to euros.
Cheers
Shelagh
On 18 September 2013 06:45, John Smith <clicks...@yahoo.co.uk
<mailto:clicks...@yahoo.co.uk>> wrote:
Hi all.
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 conversion.
I have tried a few of the entries which I found here;
http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#CONVERT
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.
Regards
JohnS
--
To unsubscribe e-mail to:
documentation+unsubscr...@global.libreoffice.org
<mailto:documentation%2bunsubscr...@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/documentation/
All messages sent to this list will be publicly archived and
cannot be deleted
--
To unsubscribe e-mail to: documentation+unsubscr...@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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted