Add-in Functions, List of Analysis Functions Part Two
The Add-in functions are supplied by the UNO com.sun.star.sheet.addin.Analysis service.
[text/scalc/01/func_imcos.xhp#imcos_head not found].
Returns the cosine of a complex number.
[text/scalc/01/func_imcosh.xhp#imcosh_head not found].
Returns the hyperbolic cosine of a complex number.
[text/scalc/01/func_imcot.xhp#imcot_head not found].
Returns the cotangent of a complex number.
[text/scalc/01/func_imcsc.xhp#imcsc_head not found].
Returns the cosecant of a complex number.
[text/scalc/01/func_imcsch.xhp#imcsch_head not found].
Returns the hyperbolic cosecant of a complex number.
[text/scalc/01/func_imsec.xhp#imsec_head not found].
Returns the secant of a complex number.
[text/scalc/01/func_imsech.xhp#imsech_head not found].
Returns the hyperbolic secant of a complex number.
[text/scalc/01/func_imsin.xhp#imsin_head not found].
Returns the sine of a complex number.
[text/scalc/01/func_imsinh.xhp#imsinh_head not found].
Returns the hyperbolic sine of a complex number.
[text/scalc/01/func_imtan.xhp#imtan_head not found].
Returns the tangent of a complex number.
CONVERT
Converts a value from one unit of measurement to the corresponding value in another unit of measurement.
COMPLEX
Gumu addi hanqafaanchiwiinni nna hedote hanqafawaanchiwiinni qolantino xurqa kiirooti.
COMPLEX(RealNum; INum [; Suffix])
RealNum is the real coefficient of the complex number.
INum is the imaginary coefficient of the complex number.
Jeefotekala doorshu dirtooti, "i" woy "j".
=Xurqa(3;4;"j") 3+4jqolanno.
FACTDOUBLE
Lame fakitoriaale kiiro qolanno.
FACTDOUBLE(Kiiro)
Kiiro !!, KiiroLame fakitoriaale qolanno, Kiiro Zerotenni taaltino woy roortino intigereeti.
Wo'ma kiirrara FACTDOUBLE(n) qolanno:
2*4*6*8* ... *n
Xea kiirrara FACTDOUBLE(n) qolanno:
1*3*5*7* ... *n
FACTDOUBLE(0) tirotenni 1 qolanno.
=FACT(0) 1 qolanno.
=FACT(3) 6 qolanno.
=FACT(0) 1 qolanno.
IMABS
Gumu xurqa kiirora coitte hornyooti.
IMABS("XurqaKiiro")
XurqaKiiro xurqa kiiro ikkite"x+yi" woy "x+yj"suusdishshinni einote.
=ABS(12) 12 qolanno.
IMAGINARY
Gumu hedote xurqa kiiro hanqafaanchooti.
HEDOTENNI("ComplexNumber")
=Hedotenni("4+3j") 3 qolanno.
IMARGUMENT
Gumu xurqa kiiro tidhooti (phi angile).
IMARGUMENT("ComplexNumber")
=IMSQRT("3+4i") 2+1i qolanno.
IMCONJUGATE
TGumu xurqa kiirora ledote xaaddino xurqa kiirooti.
IMCONJUGATE("ComplexNumber")
=IMCONJUGATE("1+j") 1-j qolanno.
IMDIV
Gumu lame xurqa kiiro beehaacheeti.
IMDIV("Kiiraamaancho"; "Kiiraancho")
Numerator, Denominator are complex numbers that are entered in the form "x+yi" or "x+yj".
=IMDIV("-238+240i";"10+24i") returns 5+12i.
IMEXP
Gumu e wolqa nna xurqa kiirooti. Soorrantannokki e hedotenni 2.71828182845904 hornyo afidhino.
IMEXP("ComplexNumber")
=IMEXP("1+j") returns 1.47+2.29j (rounded).
IMLN
Gumu kalaqamu logartizime (kaimu e) xurqa kiirora. Sorrantannokki e hedotenni 2.71828182845904 hornyo afidhino.
IMLN("ComplexNumber")
=IMLN("1+j") returns 0.35+0.79j (rounded).
IMLOG10
Gumu gutu logaartizime (kaima 10) xurqa kiirora.
IMLOG10("ComplexNumber")
=IMLOG10("1+j") returns 0.15+0.34j (rounded).
IMLOG2
Gumu xurqakiirora lamu logaartizimeeti.
IMLOG2("ComplexNumber")
=IMLOG2("1+j") returns 0.50+1.13j (rounded).
IMPOWER
The result is the ComplexNumber raised to the power of Number.
IMPOWER("ComplexNumber"; Kiiro)
Kiiro wolqate kiirooti.
=IMSQRT("3+4i") 2+1i qolanno.
IMPRODUCT
The result is the product of a set of complex numbers.
IMPRODUCT(Complex 1 [; Complex 2 [; … [; Complex 255]]])
=IMREAL("1+3j") 1qolanno.
IMREAL
Gumu xurqa kiirora addi kiirote hanqafaanchooti.
IMREAL("ComplexNumber")
=IMREAL("1+3j") 1qolanno.
IMSQRT
Gumu xurqa kiiro lamu wolqaati.
IMSQRT("XurqaKiiro")
=IMSQRT("3+4i") 2+1i qolanno.
IMSUB
Gumu lame xurqa kiirra xeishshaati.
IMSUB("XurqaKiirora1"; "XurqaKiirora2")
=IMREAL("1+3j") 1qolanno.
IMSUM
The result is the sum of a set of complex numbers.
IMSUM(Complex 1 [; Complex 2 [; … [; Complex 255]]])
=IMREAL("1+3j") 1qolanno.
OCT2BIN
The result is the string representing the number in binary (base-2) form for the octal number string entered.
OCT2BIN(Number [; Places])
Number is a string that represents an octal number. It can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.
Darguwa guma ikkitanno darguwa kiirooti.
=OCT2BIN("3";3) returns "011".
OCT2DEC
The result is the number for the octal number string entered.
OCT2DEC(Kiiro)
Number is a string that represents an octal number. It can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.
=OCT2DEC("144") returns 100.
OCT2HEX
The result is the string representing the number in hexadecimal form for the octal number string entered.
OCT2HEX(Number [; Places])
Number is a string that represents an octal number. It can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.
Darguwa guma ikkitanno darguwa kiirooti.
=OCT2HEX("144";4) returns "0064".