On 2013-09-18 08:45, John Smith 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
Hi. I have the file /usr/lib64/libreoffice/share/registry/main.xcd. The
example in help CONVERT(100,"EUR","DEM") works. I can't find EUR or DEM
in main.xcd. My function wizard says the conversion table is in calc.xcu
which I don't have.
Steve
--
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
