Hi :) This looks like a question that might be good to pass on to the Users Mailing List? They might have answers to the 2 questions here.
Since you can't get Convert to work it might be good to post a bug-report anyway and then wait for feedback from the Users List. I keep getting told off for liaising between lists so it would be better if you posted the question there rather than me passing it on to them. Regards from Tom :) ________________________________ From: Jean Weber <[email protected]> To: John Smith <[email protected]> Cc: documentation <[email protected]> Sent: Wednesday, 18 September 2013, 11:43 Subject: Re: [libreoffice-documentation] CONVERT function in Calc Isn't it, and some other functions, still there so old spreadsheets that used it will still work? (Just a guess; I don't know.) --Jean On 18/09/2013, at 20:17, John Smith <[email protected]> wrote: > 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, [email protected] 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 <[email protected] >> <mailto:[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 >> 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: >> [email protected] >> <mailto:documentation%[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 >> >> > > > -- > 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 -- 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 -- 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
