2016-12-31T17:21:23.214030677P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/a7c51323b7343f82b5aea6098f5d5e31a8bad0e9
0
0
31557
18591
view1
2
8
0
0
0
0
2
0
0
0
0
0
100
60
true
false
4
6
0
0
0
0
2
0
0
0
0
0
100
60
true
false
Sheet2
1241
0
100
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+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMA0wAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpMZXR0ZXIAABIAQ09NUEFUX0RVUExFWF9NT0RFDwBEdXBsZXhNb2RlOjpPZmY=
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ł
€
-
€
:
:
:
:
€
-
€
€
-
€
/
/
-
-
-
-
:
:
:
:
:
:
/
/
:
(
)
(
)
(
)
(
)
(
)
(
)
-
:
:
:
(
)
%
(
)
-
(
)
-
(
)
-
(
)
-
.
.
:
:
:
.
.
:
-
-
-
-
€
-
€
€
-
€
€
-
€
€
-
€
:
:
:
€
€
-
€
€
-
€
€
-
€
€
-
-
-
-
-
-
-
:
:
:
:
:
:
-
-
:
-
-
-
-
-
-
€
€
-
€
-
-
-
€
€
-
€
-
%
???
Page 1
??? (???)
00/00/0000, 00:00:00
Page 1 / 99
PHI Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple PHI formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
-1.4
0.031739651835668
0.031739651835667
TRUE
=PHI(2.25)
-1.3
0.031739651835667
0.031739651835667
TRUE
=PHI(-2.25)
-1.2
0.398942280401433
0.398942280401433
TRUE
=PHI(0)
-1.1
0.301137432154804
0.301137432154804
TRUE
=PHI(0.75)
-1
0.149727465635745
0.149727465635745
TRUE
{=PHI(I1:I26)}
-0.9
0.171368592047807
0.171368592047807
TRUE
{=PHI(I1:I26)}
-0.8
0.194186054983213
0.194186054983213
TRUE
{=PHI(I1:I26)}
-0.700000000000001
0.21785217703255
0.21785217703255
TRUE
{=PHI(I1:I26)}
-0.600000000000001
0.241970724519143
0.241970724519143
TRUE
{=PHI(I1:I26)}
-0.500000000000001
0.266085249898755
0.266085249898755
TRUE
{=PHI(I1:I26)}
-0.400000000000001
0.289691552761483
0.289691552761483
TRUE
{=PHI(I1:I26)}
-0.300000000000001
0.312253933366761
0.312253933366761
TRUE
{=PHI(I1:I26)}
-0.200000000000001
0.333224602891799
0.333224602891799
TRUE
{=PHI(I1:I26)}
-0.100000000000001
0.352065326764299
0.352065326764299
TRUE
{=PHI(I1:I26)}
-1.33226762955019E-15
0.368270140303323
0.368270140303323
TRUE
{=PHI(I1:I26)}
0.099999999999999
0.381387815460524
0.381387815460524
TRUE
{=PHI(I1:I26)}
0.199999999999998
0.391042693975456
0.391042693975456
TRUE
{=PHI(I1:I26)}
0.299999999999998
0.396952547477012
0.396952547477012
TRUE
{=PHI(I1:I26)}
0.399999999999998
0.398942280401433
0.398942280401433
TRUE
{=PHI(I1:I26)}
0.499999999999998
0.396952547477012
0.396952547477012
TRUE
{=PHI(I1:I26)}
0.599999999999998
0.391042693975456
0.391042693975456
TRUE
{=PHI(I1:I26)}
0.699999999999998
0.381387815460524
0.381387815460524
TRUE
{=PHI(I1:I26)}
0.799999999999998
0.368270140303324
0.368270140303324
TRUE
{=PHI(I1:I26)}
0.899999999999998
0.3520653267643
0.3520653267643
TRUE
{=PHI(I1:I26)}
0.999999999999998
0.3332246028918
0.3332246028918
TRUE
{=PHI(I1:I26)}
1.1
0.312253933366762
0.312253933366762
TRUE
{=PHI(I1:I26)}
0.289691552761483
0.289691552761483
TRUE
{=PHI(I1:I26)}
0.266085249898755
0.266085249898755
TRUE
{=PHI(I1:I26)}
0.241970724519144
0.241970724519144
TRUE
{=PHI(I1:I26)}
0.21785217703255
0.217852177032551
TRUE
{=PHI(I1:I26)}