Ask Your Question

Calc Function CONVERT_ADD unit string not explained [closed]

asked 2012-08-20 22:47:39 +0200

horst gravatar image

I had to use the CONVERT_ADD(value,fromUnit, toUnit) a few times. The Unit Strings provided in the Help section are not explained. I figured out a few my self but some I could not. Also the Unit "Pica" should be renamed "Point", that is what the convertion really returns 1/72 of an inch. Pica is 1/72 of a foot. I don't know if this is reportable as a bug?

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-10-17 20:05:01.595883

2 Answers

Sort by » oldest newest most voted

answered 2012-08-20 23:56:18 +0200

erAck gravatar image

"Pica" is pica points (1/72 inch) for interoperability with other spreadsheet applications. The 1/6 inch would be "pica" (note small letter p) but that isn't implemented yet.

See also the ODF OpenFormula specification for CONVERT

edit flag offensive delete link more

answered 2012-08-21 23:12:10 +0200

horst gravatar image

Danke erAck, may be You could insert this link into the help-files and the documentation. The documentation does not even contain the table of the help files.

edit flag offensive delete link more

Question Tools


Asked: 2012-08-20 22:47:39 +0200

Seen: 2,501 times

Last updated: Aug 21 '12