2016-06-25T07:16:38.437590147P0D1LibreOffice/5.1.3.2$Linux_X86_64 LibreOffice_project/10m0$Build-2
0
0
26393
10369
view1
2
8
0
0
0
0
2
0
0
0
0
0
100
60
true
1
13
0
0
0
0
2
0
0
0
0
0
100
60
true
Sheet2
1185
0
100
60
false
true
true
true
12632256
true
true
true
true
false
false
false
1270
1270
1
1
true
7
false
false
true
true
false
false
false
1270
1270
true
true
true
true
true
true
true
false
12632256
false
Lexmark-E352dn
en
US
3
1
true
1
true
qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY=
false
0
Kč
-
Kč
$
$(
)
$-
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
€
-
€
€
-
€
€
-
€
€
-
€
-
-
€
-
€
- €
-
-
€
-
€
-
€
:
:
:
:
$
($
)
$
($
)
$
($
)
$
($
)
(
)
-
$
$
(
)
$
-
(
)
-
$
$
(
)
$
-
Yes
Yes
No
True
True
False
On
On
Off
€
(
€
)
\
\-
\
\-
\
\-
\
\-
\
\
-
\
-
-
-
\
\
-
\
-
-
-
-
-
-
-
-
-
€
-
€
.
/
€
-
€
⌀
$
-
$
(
)
-
$
$(
)
$-
(
)
-
$
€
-
€
.
.
WAHR
WAHR
FALSCH
/
/
-
-
-
-
:
:
:
:
:
:
/
/
:
(
)
(
)
(
)
(
)
(
)
(
)
(
)
(
)
(
)
-
(
)
-
(
)
-
(
)
-
.
.
:
:
:
.
.
:
-
-
-
-
€
-
€
€
-
€
€
-
€
€
-
€
%
:
:
:
:
:
:
-
$
-
$
???
Page 1
??? (???)
00/00/0000, 00:00:00
Page 1 / 99
BITLSHIFT Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple BITLSHIFT formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
12
12
TRUE
=BITLSHIFT(6,1)
16
16
TRUE
=BITLSHIFT(4,2)
25
0
0
TRUE
=BITLSHIFT(0,2)
a
2
2
TRUE
=BITLSHIFT(-4,2)
10
10
TRUE
=BITLSHIFT(10,0)
40
40
TRUE
=BITLSHIFT(10,2)
Chyba:502
error
TRUE
=BITLSHIFT(-4,2)
4
4
TRUE
=BITLSHIFT(4,)
#VALUE!
error
TRUE
=BITLSHIFT(4,J4)
Chyba:511
error
TRUE
=BITLSHIFT(4)
Chyba:504
error
TRUE
=BITLSHIFT(4,1,1)
BITLSHIFTSummary: Returns left shift of value x by n bits (“<<”)Syntax: BITLSHIFT( Integer x ; Integer n )Returns: NumberConstraints: x ≥ 0Semantics: Returns left shift of value x by n bit positions:If n<0, return BITRSHIFT(x,-n)if n=0, return xif n>0, return x*2^n
4
O5