2016-05-23T19:52:21.032366237P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/3287bc2f91438085b7604773d5e0346fc3c3f452
0
0
36415
41345
view1
2
8
0
0
0
0
2
0
0
0
0
0
80
60
true
false
3
28
0
0
0
0
2
0
0
0
0
0
80
60
true
false
Sheet2
1241
0
80
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
BASE Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple BASE formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
17
10
4
166
11
1
0017
0017
TRUE
=BASE(17,10,4)
18
11
5
167
12
2
10001
10001
TRUE
=BASE(17,2)
19
12
6
168
13
3
00FF
00FF
TRUE
=BASE(255,16,4)
20
13
7
169
14
4
10000
10000
TRUE
=BASE(16,2)
21
14
8
170
15
5
00010000
00010000
TRUE
=BASE(16,2,8)
111
111
TRUE
=BASE(7,2)
64
64
TRUE
=BASE(100,16)
0000001111
0000001111
TRUE
=BASE(15,2,10)
0000
0000
TRUE
=BASE(0,10,4)
Err:502
Err:502
TRUE
=BASE(-17,10,4)
Err:502
Err:502
TRUE
=BASE(17,100,4)
Err:502
Err:502
TRUE
=BASE(17,0,4)
Err:502
Err:502
TRUE
=BASE(17,-10,4)
17
17
TRUE
=BASE(17,10,0)
Err:502
Err:502
TRUE
=BASE(17,10,-4)
0001
0001
TRUE
=BASE(1,2,4)
0017
0017
TRUE
{=BASE(L1:L5,M1:M5,N1:N5)}
00017
00017
TRUE
{=BASE(L1:L5,M1:M5,N1:N5)}
000017
000017
TRUE
{=BASE(L1:L5,M1:M5,N1:N5)}
0000017
0000017
TRUE
{=BASE(L1:L5,M1:M5,N1:N5)}
00000017
00000017
TRUE
{=BASE(L1:L5,M1:M5,N1:N5)}
141
141
TRUE
{=BASE(P1:P5,Q1:Q5,R1:R5)}
11B
11B
TRUE
{=BASE(P1:P5,Q1:Q5,R1:R5)}
0CC
0CC
TRUE
{=BASE(P1:P5,Q1:Q5,R1:R5)}
00C1
00C1
TRUE
{=BASE(P1:P5,Q1:Q5,R1:R5)}
000B5
000B5
TRUE
{=BASE(P1:P5,Q1:Q5,R1:R5)}
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
TRUE
#N/A
4