Product: Spreadsheet
Type: new
Title: CONVERT_ADD with many new conversion factors
Posted by: [email protected]
Affected: scaddins
TaskId: i99140
<http://www.openoffice.org/issues/show_bug.cgi?id=99140>
Effective from: CWS odff06
CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/odff06>
CWS status: new
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
The CONVERT_ADD spreadsheet function (known as CONVERT in other
applications) has many more conversion factors implemented, as defined
in OASIS ODFF/OpenFormula, for details see
http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula
The full list is:
SI prefix: unit may be prefixed by one SI prefix, supported prefixes are:
y Yocto 1.00E-24
z Zepto 1.00E-21
a Atto 1.00E-18
f Femto 1.00E-15
p Pico 1.00E-12
n Nano 1.00E-09
u Micro 1.00E-06
m Milli 1.00E-03
c Centi 1.00E-02
d Deci 1.00E-01
1.00E+00
e Deca 1.00E+01
h Hecto 1.00E+02
k Kilo 1.00E+03
M Mega 1.00E+06
G Giga 1.00E+09
T Tera 1.00E+12
P Peta 1.00E+15
E Exa 1.00E+18
Z Zetta 1.00E+21
Y Yotta 1.00E+24
Information units "bit" and "byte" may also be prefixed by one
IEC 60027-2 / IEEE 1541 prefix, supported prefixes are:
1
ki kibi 1024
Mi mebi 1048576
Gi gibi 1073741824
Ti tebi 1099511627776
Pi pebi 1125899906842620
Ei exbi 1152921504606850000
Zi zebi 1180591620717410000000
Yi yobi 1208925819614630000000000
// MASS: 1 Gram is...
SI prefix "g"
SI prefix "u"
"sg"
"lbm"
"ozm"
"stone"
"ton"
"grain"
"pweight"
"hweight"
"shweight"
"brton"
"cwt"
"shweight"
"uk_cwt"
"lcwt"
"hweight"
"uk_ton"
"LTON"
// LENGTH: 1 Meter is...
SI prefix "m"
SI prefix "parsec"
SI prefix "pc"
SI prefix "lightyear"
SI prefix "ly"
"mi"
"Nmi"
"in"
"ft"
"yd"
"ang"
"Pica"
"ell"
"survey_mi"
// TIME: 1 Second is...
SI prefix "sec"
SI prefix "s"
"yr"
"day"
"d"
"hr"
"mn"
"min"
// PRESSURE: 1 Pascal is...
SI prefix "Pa"
SI prefix "atm"
SI prefix "at"
SI prefix "mmHg"
"Torr"
"psi"
// FORCE: 1 Newton is...
SI prefix "N"
SI prefix "dyn"
SI prefix "dy"
SI prefix "pond"
"lbf"
// ENERGY: 1 Joule is...
SI prefix "J"
SI prefix "e"
SI prefix "c"
SI prefix "cal"
SI prefix "eV"
SI prefix "ev"
SI prefix "Wh"
SI prefix "wh"
"HPh"
"hh"
"flb"
"BTU"
"btu"
// POWER: 1 Watt is...
SI prefix "W"
SI prefix "w"
"HP"
"h"
"PS"
// MAGNETISM: 1 Tesla is...
SI prefix "T"
SI prefix "ga"
// TEMPERATURE: 1 Kelvin is...
SI prefix "K"
SI prefix "kel"
"C"
"cel"
"F"
"fah"
"Reau"
"Rank"
// VOLUME: 1 Liter is...
SI prefix "l"
SI prefix "L"
SI prefix "lt"
SI prefix "m3"
"tsp"
"tbs"
"oz"
"cup"
"pt"
"us_pt"
"uk_pt"
"qt"
"gal"
"mi3"
"Nmi3"
"in3"
"ft3"
"yd3"
"ang3"
"Pica3"
"barrel"
"bushel"
"regton"
"GRT"
"ly3"
"MTON"
"tspm"
"uk_gal"
"uk_qt"
// 1 Square Meter is...
SI prefix "m2"
SI prefix "ang2"
SI prefix "ar"
"mi2"
"Nmi2"
"in2"
"ft2"
"yd2"
"Pica2"
"Morgen"
"acre"
"uk_acre"
"us_acre"
"ly2"
"ha"
// SPEED: 1 Meter per Second is...
SI prefix "m/s"
SI prefix "m/sec"
"m/h"
"m/hr"
"mph"
"kn"
"admkn"
// INFORMATION: 1 Bit is...
SI prefix or IEC 60027-2 / IEEE 1541 prefix "bit"
SI prefix or IEC 60027-2 / IEEE 1541 prefix "byte"
Send feedback to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
