Ask Your Question

Calc convert function [closed]

asked 2013-07-29 11:59:02 +0200

Kev2 gravatar image

I would like to know the keywords for the convert function. I understand the syntax is: =convert(value;"text;"text") and I need to know the list of units conversion.

I've read in the help, the conversion factors are given in a list in the configuration, but I couldn't find where to set them up. I've read in the fx dialog, the configuration is stored in calc.xcu file but i don't have it, should I make one? What is the format?

Thanks in advance.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-08 08:34:35.097813

3 Answers

Sort by » oldest newest most voted

answered 2013-07-30 00:46:31 +0200

horst gravatar image

updated 2013-07-30 01:03:38 +0200

You will find the Unit-Texts here. And as @oweng mentioned you have to use CONVERT_ADD. While the CONVERT function is only for currency convertion. I compiled a convertion list with the convertion factors. When I figure out how to attach it I wll do so.

Looks like one can only attach picture files.

Another list from the OASIS Document here with convertion factors. Not all of them are implemented in CALC.

edit flag offensive delete link more

answered 2013-07-29 12:44:38 +0200

oweng gravatar image

This is not a complete answer to your question, however according to this recent mailing list thread you probably should be using the CONVERT_ADD function rather than the CONVERT function.

edit flag offensive delete link more

answered 2013-09-15 01:56:42 +0200

Kev2 gravatar image

My doubt is solved, I appreciate very much your help. Thanks!

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-07-29 11:59:02 +0200

Seen: 6,329 times

Last updated: Sep 15 '13