2017-01-14T18:37:16.363535665P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/ec1afa55e8ed79dc290caff74aaca304a77c3b4f
0
0
103829
19790
view1
2
8
0
0
0
0
2
0
0
0
0
0
75
60
true
false
4
6
0
0
0
0
2
0
0
0
0
0
75
60
true
false
Sheet2
1241
0
75
60
false
true
true
true
12632256
true
true
true
true
true
false
false
1270
1270
1
1
true
false
7
false
false
true
true
false
false
false
1270
1270
true
true
true
true
true
false
12632256
false
Lexmark-E352dn
cs
CZ
de
DE
en
US
nl
NL
true
true
3
1
true
1
true
sgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMA0wAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgBJbnB1dFNsb3Q6VHJheTEARHVwbGV4Ok5vbmUAABIAQ09NUEFUX0RVUExFWF9NT0RFDwBEdXBsZXhNb2RlOjpPZmY=
false
0
Kč
-
Kč
(
)
-
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
€
-
€
-
€
/
/
/
/
€
-
€
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
-
-
-
-
-
-
Kč
-
Kč
- Kč
-
-
Kč
-
Kč
-
Kč
:
:
:
:
Yes
Yes
No
True
True
False
On
On
Off
¥€
(
€
)
€
-
€
$
($
)
€
-
€
€
-
€
€
-
€
€
-
€
-
-
€
-
€
- €
-
-
€
-
€
-
€
$
($
)
$
($
)
$
($
)
(
)
-
$
$
(
)
$
-
$
$
(
)
$
-
€
(
€
)
\
\-
\
\-
\
\-
\
\-
\
\
-
\
-
-
-
\
\
-
\
-
-
-
-
-
-
-
$
$(
)
$-
(
)
-
$
$(
)
$-
(
)
-
%
%
%
%
%
%
%
%
%
%
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
%
%
%
%
%
%
$
(
$
)
%
%
-
%
-
-
-
£
-
£
£
-
£
%
-
%
DM
-
DM
DM
-
DM
DM
-
DM
DM
-
DM
-
-
DM
-
DM
- DM
-
-
DM
-
DM
-
DM
Ouch! -
- Error detected!
- Result=0 - No Errordetection
/
/
/
/
(
)
-
$
$
(
)
$
-
(
)
-
$
$
(
)
$
-
£
-£
£
-£
£
-£
£
-£
-
-
£
-£
£
-
-
-
£
-£
£
-
¥
-
¥
DM
-
DM
DM
-
DM
DM
-
DM
DM
-
DM
DM
-
DM
€
€
-
tan
aa
zł
-
zł
-
-
Kč
-
Kč
- Kč
-
-
Kč
-
Kč
-
Kč
.
.
/
/
-
-
-
-
:
:
:
:
:
:
/
/
:
(
)
(
)
(
)
(
)
(
)
(
)
-
:
:
:
(
)
%
(
)
-
(
)
-
(
)
-
(
)
-
.
.
:
:
:
.
.
:
-
-
-
-
€
-
€
€
-
€
€
-
€
€
-
€
€
€
-
€
€
-
€
€
-
€
€
-
-
-
-
-
-
-
:
:
:
:
:
:
-
-
:
-
-
-
-
-
-
€
€
-
€
-
-
-
€
€
-
€
-
%
???
Page 1
??? (???)
00/00/0000, 00:00:00
Page 1 / 99
GAMMALN.PRECISE Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple GAMMALN.PRECISE formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
0
Err:502
Err:502
TRUE
=GAMMALN.PRECISE(I1)
0.1
2.25271265173421
2.25271265173421
TRUE
=GAMMALN.PRECISE(I2)
0.2
1.52406382243078
1.52406382243078
TRUE
=GAMMALN.PRECISE(I3)
0.3
1.09579799481807
1.09579799481807
TRUE
=GAMMALN.PRECISE(I4)
0.4
0.796677817701784
0.796677817701784
TRUE
=GAMMALN.PRECISE(I5)
0.5
0.5723649429247
0.5723649429247
TRUE
=GAMMALN.PRECISE(I6)
0.6
0.398233858069235
0.3982338580692350000
TRUE
=GAMMALN.PRECISE(I7)
0.7
0.260867246531667
0.260867246531667
TRUE
=GAMMALN.PRECISE(I8)
0.8
0.152059678399838
0.152059678399838
TRUE
=GAMMALN.PRECISE(I9)
0.9
0.066376239734742
0.066376239734742
TRUE
=GAMMALN.PRECISE(I10)
1
0
0
TRUE
=GAMMALN.PRECISE(I11)
2
0
0
TRUE
=GAMMALN.PRECISE(I12)
3
0.693147180559945
0.693147180559945
TRUE
=GAMMALN.PRECISE(I13)
4
1.79175946922806
1.79175946922806
TRUE
=GAMMALN.PRECISE(I14)
5
3.17805383034795
3.17805383034795
TRUE
=GAMMALN.PRECISE(I15)
6
4.78749174278205
4.78749174278205
TRUE
=GAMMALN.PRECISE(I16)
7
6.5792512120101
6.5792512120101
TRUE
=GAMMALN.PRECISE(I17)
8
8.52516136106541
8.52516136106541
TRUE
=GAMMALN.PRECISE(I18)
9
10.6046029027453
10.6046029027453
TRUE
=GAMMALN.PRECISE(I19)
10
12.8018274800815
12.8018274800815
TRUE
=GAMMALN.PRECISE(I20)
11
15.1044125730755
15.1044125730755
TRUE
=GAMMALN.PRECISE(I21)
12
17.5023078458739
17.5023078458739
TRUE
=GAMMALN.PRECISE(I22)
13
19.9872144956619
19.9872144956619
TRUE
=GAMMALN.PRECISE(I23)
14
22.5521638531234
22.5521638531234
TRUE
=GAMMALN.PRECISE(I24)
15
25.1912211827387
25.1912211827387
TRUE
=GAMMALN.PRECISE(I25)
16
27.8992713838409
27.8992713838409
TRUE
=GAMMALN.PRECISE(I26)
17
30.6718601060807
30.6718601060807
TRUE
=GAMMALN.PRECISE(I27)
18
33.5050734501369
33.5050734501369
TRUE
=GAMMALN.PRECISE(I28)
19
36.3954452080331
36.3954452080331
TRUE
=GAMMALN.PRECISE(I29)
30.6718601060807
30.6718601060807
TRUE
{=GAMMALN.PRECISE(I27:I29)}
33.5050734501369
33.5050734501369
TRUE
{=GAMMALN.PRECISE(I27:I29)}
36.3954452080331
36.3954452080331
TRUE
{=GAMMALN.PRECISE(I27:I29)}