Geoffrey Hyde wrote:
Hi, I am an end-user of OpenOffice Org 1.1.2 and I was wondering if there are any plans to add more types of units of measurement into OpenOffice Org's next version? What I am after is basically simple unit conversion, addition, and subtraction of weights, eg 4lb 6 oz to/from the equivalent amount of grams, (rounded, of course, to the nearest possible displayable value) and displaying a cell as a weight measurement value, eg grams, kilograms, pounds, pounds. ounces etc.
We have the CONVERT_ADD function, see its description in the online help. It converts a single value from one unit to another, so for your example you need something like CONVERT_ADD(4;"lbm";"kg")+CONVERT_ADD(6;"ozm";"kg").
If you need rounding, you can use the ROUND function. Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
