2016-05-23T19:52:21.032366237P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/7b8832ff972a4e9f3e03fd7d96882b2a78c03b3e
0
0
21171
16772
view1
2
8
0
0
0
0
2
0
0
0
0
0
85
60
true
false
4
6
0
0
0
0
2
0
0
0
0
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+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg==
false
0
Kč
-
Kč
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
€
-
€
R$
-
R$
€
-
€
\
\-
\
\-
\
\-
\
\-
$
($
)
$
($
)
$
($
)
$
($
)
-
-
\
\
-
\
-
-
-
\
\
-
\
-
:
:
:
:
/
/
-
-
-
-
:
:
:
:
:
:
/
/
:
(
)
(
)
(
)
(
)
(
)
(
)
???
Page 1
??? (???)
00/00/0000, 00:00:00
Page 1 / 99
CONCAT Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple CONCAT formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
1
255
255
TRUE
=DECIMAL("FF",16)
2
7
7
TRUE
=DECIMAL(111,2)
3
45745
45745
TRUE
=DECIMAL("zap",36)
4
17
17
TRUE
=DECIMAL("17",10)
5
64206
64206
TRUE
=DECIMAL("FACE",16)
6
5
5
TRUE
=DECIMAL("0101",2)
7
Err:502
Err:502
TRUE
=DECIMAL("aa",I1)
8
Err:502
Err:502
TRUE
=DECIMAL("aa",I2)
9
Err:502
Err:502
TRUE
=DECIMAL("aa",I3)
10
Err:502
Err:502
TRUE
=DECIMAL("aa",I4)
11
Err:502
Err:502
TRUE
=DECIMAL("aa",I5)
12
45745
45745
TRUE
=DECIMAL("ZAP",36)
13
12
12
TRUE
=DECIMAL( "1100", 2 )
14
100000
100000
TRUE
=DECIMAL( "186A0", 16 )
15
100000
100000
TRUE
=DECIMAL( "31L0", 32 )
16
28754
28754
TRUE
=DECIMAL( "70122", 8 )
17
Err:502
Err:502
TRUE
=DECIMAL( "2000", 2 )
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37