2016-05-23T19:52:21.032366237P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/3287bc2f91438085b7604773d5e0346fc3c3f452
0
0
20602
44769
view1
2
8
0
0
0
0
2
0
0
0
0
0
85
60
true
false
0
99
0
0
0
0
2
0
0
0
81
0
85
60
true
false
Sheet2
1241
0
85
60
false
true
true
true
12632256
true
true
true
true
false
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
en
US
true
true
3
1
true
1
true
rgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg==
false
0
Kč
-
Kč
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
€
-
€
R$
-
R$
€
-
€
\
\-
\
\-
\
\-
\
\-
$
($
)
$
($
)
$
($
)
$
($
)
-
-
\
\
-
\
-
-
-
\
\
-
\
-
:
:
:
:
/
/
-
-
-
-
:
:
:
:
:
:
/
/
:
(
)
(
)
(
)
(
)
(
)
(
)
???
Page 1
??? (???)
00/00/0000, 00:00:00
Page 1 / 99
CODE Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple CODE formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
33
33
TRUE
=CODE(I2)
!
34
34
TRUE
=CODE(I3)
"
35
35
TRUE
=CODE(I4)
#
36
36
TRUE
=CODE(I5)
$
37
37
TRUE
=CODE(I6)
%
38
38
TRUE
=CODE(I7)
&
39
39
TRUE
=CODE(I8)
'
40
40
TRUE
=CODE(I9)
(
41
41
TRUE
=CODE(I10)
)
42
42
TRUE
=CODE(I11)
*
43
43
TRUE
=CODE(I12)
+
44
44
TRUE
=CODE(I13)
,
45
45
TRUE
=CODE(I14)
-
46
46
TRUE
=CODE(I15)
.
47
47
TRUE
=CODE(I16)
/
48
48
TRUE
=CODE(I17)
0
49
49
TRUE
=CODE(I18)
1
50
50
TRUE
=CODE(I19)
2
51
51
TRUE
=CODE(I20)
3
52
52
TRUE
=CODE(I21)
4
53
53
TRUE
=CODE(I22)
5
54
54
TRUE
=CODE(I23)
6
55
55
TRUE
=CODE(I24)
7
56
56
TRUE
=CODE(I25)
8
57
57
TRUE
=CODE(I26)
9
58
58
TRUE
=CODE(I27)
:
59
59
TRUE
=CODE(I28)
;
60
60
TRUE
=CODE(I29)
<
61
61
TRUE
=CODE(I30)
=
62
62
TRUE
=CODE(I31)
>
63
63
TRUE
=CODE(I32)
?
64
64
TRUE
=CODE(I33)
@
65
65
TRUE
=CODE(I34)
A
66
66
TRUE
=CODE(I35)
B
67
67
TRUE
=CODE(I36)
C
68
68
TRUE
=CODE(I37)
D
69
69
TRUE
=CODE(I38)
E
70
70
TRUE
=CODE(I39)
F
71
71
TRUE
=CODE(I40)
G
72
72
TRUE
=CODE(I41)
H
73
73
TRUE
=CODE(I42)
I
74
74
TRUE
=CODE(I43)
J
75
75
TRUE
=CODE(I44)
K
76
76
TRUE
=CODE(I45)
L
77
77
TRUE
=CODE(I46)
M
78
78
TRUE
=CODE(I47)
N
79
79
TRUE
=CODE(I48)
O
80
80
TRUE
=CODE(I49)
P
81
81
TRUE
=CODE(I50)
Q
82
82
TRUE
=CODE(I51)
R
83
83
TRUE
=CODE(I52)
S
84
84
TRUE
=CODE(I53)
T
85
85
TRUE
=CODE(I54)
U
86
86
TRUE
=CODE(I55)
V
87
87
TRUE
=CODE(I56)
W
88
88
TRUE
=CODE(I57)
X
89
89
TRUE
=CODE(I58)
Y
90
90
TRUE
=CODE(I59)
Z
91
91
TRUE
=CODE(I60)
[
92
92
TRUE
=CODE(I61)
\
93
93
TRUE
=CODE(I62)
]
94
94
TRUE
=CODE(I63)
^
95
95
TRUE
=CODE(I64)
_
96
96
TRUE
=CODE(I65)
`
97
97
TRUE
=CODE(I66)
a
98
98
TRUE
=CODE(I67)
b
99
99
TRUE
=CODE(I68)
c
100
100
TRUE
=CODE(I69)
d
101
101
TRUE
=CODE(I70)
e
102
102
TRUE
=CODE(I71)
f
103
103
TRUE
=CODE(I72)
g
104
104
TRUE
=CODE(I73)
h
105
105
TRUE
=CODE(I74)
i
106
106
TRUE
=CODE(I75)
j
107
107
TRUE
=CODE(I76)
k
108
108
TRUE
=CODE(I77)
l
109
109
TRUE
=CODE(I78)
m
110
110
TRUE
=CODE(I79)
n
111
111
TRUE
=CODE(I80)
o
112
112
TRUE
=CODE(I81)
p
113
113
TRUE
=CODE(I82)
q
114
114
TRUE
=CODE(I83)
r
115
115
TRUE
=CODE(I84)
s
116
116
TRUE
=CODE(I85)
t
117
117
TRUE
=CODE(I86)
u
118
118
TRUE
=CODE(I87)
v
119
119
TRUE
=CODE(I88)
w
120
120
TRUE
=CODE(I89)
x
121
121
TRUE
=CODE(I90)
y
122
122
TRUE
=CODE(I91)
z
123
123
TRUE
=CODE(I92)
{
124
124
TRUE
=CODE(I93)
|
125
125
TRUE
=CODE(I94)
}
126
126
TRUE
=CODE(I95)
~
127
127
TRUE
=CODE(I96)
72
72
TRUE
=CODE(I97)
Hello
72
72
TRUE
=CODE(I98)
Hello
72
72
TRUE
=CODE("Hello")
4