2016-07-24T08:15:55.362000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/7b8832ff972a4e9f3e03fd7d96882b2a78c03b3e
0
0
22009
4420
view1
2
8
0
0
0
0
2
0
0
0
0
0
75
60
true
false
3
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
lgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg==
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
GAUSS Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple GAUSS formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
0
0
0
TRUE
=GAUSS(I1)
Check 5.3
0.1
0.039827837277029
0.039827837277029
TRUE
=GAUSS(I2)
0.2
0.079259709439103
0.079259709439103
TRUE
=GAUSS(I3)
0.3
0.117911422188953
0.117911422188953
TRUE
=GAUSS(I4)
0.4
0.155421741610324
0.155421741610324
TRUE
=GAUSS(I5)
0.5
0.191462461274014
0.191462461274014
TRUE
=GAUSS(I6)
0.6
0.22574688224994
0.2257468822499400000
TRUE
=GAUSS(I7)
0.7
0.258036347777185
0.258036347777185
TRUE
=GAUSS(I8)
0.8
0.288144601419861
0.288144601419861
TRUE
=GAUSS(I9)
0.9
0.315939874683772
0.315939874683772
TRUE
=GAUSS(I10)
1
0.341344746068543
0.341344746068543
TRUE
=GAUSS(I11)
2
0.477249868051821
0.477249868051821
TRUE
=GAUSS(I12)
3
0.498650101968373
0.498650101968373
TRUE
=GAUSS(I13)
4
0.499968328758167
0.499968328758167
TRUE
=GAUSS(I14)
5
0.499999713328127
0.499999713328127
TRUE
=GAUSS(I15)
6
0.4999999990134
0.4999999990134
TRUE
=GAUSS(I16)
7
0.49999999999872
0.49999999999872
TRUE
=GAUSS(I17)
8
0.5
0.5
TRUE
=GAUSS(I18)
9
0.5
0.5
TRUE
=GAUSS(I19)
10
0.5
0.5
TRUE
=GAUSS(I20)
11
0.5
0.5
TRUE
=GAUSS(I21)
12
0.5
0.5
TRUE
=GAUSS(I22)
13
0.5
0.5
TRUE
=GAUSS(I23)
14
0.5
0.5
TRUE
=GAUSS(I24)
15
0.5
0.5
TRUE
=GAUSS(I25)
16
0.5
0.5
TRUE
=GAUSS(I26)
17
0.5
0.5
TRUE
=GAUSS(I27)
18
0.5
0.5
TRUE
=GAUSS(I28)
19
0.5
0.5
TRUE
=GAUSS(I29)
0.258036347777185
0.258036347777185
TRUE
{=GAUSS(I8:I12)}
0.288144601419861
0.288144601419861
TRUE
{=GAUSS(I8:I12)}
0.315939874683772
0.315939874683772
TRUE
{=GAUSS(I8:I12)}
0.341344746068543
0.341344746068543
TRUE
{=GAUSS(I8:I12)}
0.477249868051821
0.477249868051821
TRUE
{=GAUSS(I8:I12)}
0.075345434734796
0.075345434734796
TRUE
=GAUSS(0.19)
0.01495682992591
0.01495682992591
TRUE
=GAUSS(0.0375)