[sc-features] new/CWS odff06 : CONVERT_ADD with many new conversion factors

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[sc-features] new/CWS odff06 : CONVERT_ADD with many new conversion factors

eike.rathke


       Product: Spreadsheet
          Type: new
         Title: CONVERT_ADD with many new conversion factors
     Posted by: [hidden email]
      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 [hidden email]



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]