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 <[email protected]> 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<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+unsubscribe@** > global.libreoffice.org<documentation%[email protected]> > > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: http://listarchives.**libreoffice.org/global/** > documentation/ <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: [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/documentation/ All messages sent to this list will be publicly archived and cannot be deleted
