2016-12-29T18:23:56.522000000P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/36de6c50684c8241969a2064d30aff41e0bc5d97
0
0
78015
359233
view1
2
8
0
0
0
0
2
0
0
0
0
0
75
60
true
false
11
9
0
0
0
0
2
6
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+/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
IMSIN Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple IMSIN formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
-5+12i
-78034,7601576553+23083,6899133917j
TRUE
=IMSIN("5+12j")
-78034.7601576553
23083.6899133917
-78034.7601576553
23083.6899133917
TRUE
TRUE
-4+12i
74,2032105777888i
TRUE
=IMSIN(COMPLEX(0,5))
0
74.2032105777888
0
74.2032105777888
TRUE
TRUE
-3+12i
78034,7601576553+23083,6899133917i
TRUE
=IMSIN("-5+12i")
78034.7601576553
23083.6899133917
78034.7601576553
23083.6899133917
TRUE
TRUE
-2+12i
78034,7601576553+23083,6899133917i
TRUE
=IMSIN(N1)
78034.7601576553
23083.6899133917
78034.7601576553
23083.6899133917
TRUE
TRUE
-1+12i
78034,7601576553+23083,6899133917i
TRUE
{=IMSIN(N1:N12)}
78034.7601576553
23083.6899133917
78034.7601576553
23083.6899133917
TRUE
TRUE
0+12i
61586,6161369368-53191,8155860018i
TRUE
{=IMSIN(N1:N12)}
6.15866161369368E+004
-5.31918155860018E+004
61586.6161369368
-53191.8155860018
TRUE
TRUE
1+12i
-11483,9787388495-80563,0111422508i
TRUE
{=IMSIN(N1:N12)}
-11483.9787388495
-8.05630111422508E+004
-11483.9787388495
-80563.0111422508
TRUE
TRUE
2+12i
-73996,2565232189-33864,9457896758i
TRUE
{=IMSIN(N1:N12)}
-73996.2565232189
-33864.9457896758
-73996.2565232189
-33864.9457896758
TRUE
TRUE
3+12i
-68476,7173113616+43968,3945457281i
TRUE
{=IMSIN(N1:N12)}
-68476.7173113616
43968.3945457281
-68476.7173113616
43968.3945457281
TRUE
TRUE
4+12i
81377,3957064298i
TRUE
{=IMSIN(N1:N12)}
0
81377.3957064298
0
81377.3957064298
TRUE
TRUE
5+12i
68476,7173113616+43968,3945457281i
TRUE
{=IMSIN(N1:N12)}
68476.7173113616
43968.3945457281
68476.7173113616
43968.3945457281
TRUE
TRUE
6+12i
73996,2565232189-33864,9457896758i
TRUE
{=IMSIN(N1:N12)}
73996.2565232189
-33864.9457896758
73996.2565232189
-33864.9457896758
TRUE
TRUE
11483,9787388495-80563,0111422508i
TRUE
{=IMSIN(N1:N12)}
11483.9787388495
-80563.0111422508
11483.9787388495
-80563.0111422508
TRUE
TRUE
-61586,6161369368-53191,8155860018i
TRUE
{=IMSIN(N1:N12)}
-61586.6161369368
-53191.8155860018
-61586.6161369368
-53191.8155860018
TRUE
TRUE
-78034,7601576553+23083,6899133917i
TRUE
{=IMSIN(N1:N12)}
-78034.7601576553
23083.6899133917
-78034.7601576553
23083.6899133917
TRUE
TRUE
-22738,10556516+78136,157362303i
TRUE
{=IMSIN(N1:N12)}
-22738.10556516
78136.157362303
-22738.10556516
78136.157362303
TRUE
TRUE
-1,1752011936438j
TRUE
=IMSIN("0-j")
0
-1.1752011936438
0
-1.1752011936438
TRUE
TRUE
-0,756802495307928
TRUE
=IMSIN(4)
-0.756802495307928
0
-0.756802495307928
0
TRUE
TRUE
-7,61923172032141-6,548120040911i
TRUE
=IMSIN("4+3i")
-7.61923172032141
-6.548120040911
-7.61923172032141
-6.548120040911
TRUE
TRUE
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596