2016-12-20T21:01:28.998667961P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/5a20df55ff829978c880b22e0a1f32c35d0ba30f
0
0
37620
15564
view1
2
8
0
0
0
0
2
0
0
0
0
0
85
60
true
false
4
14
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
zh
CN
:!),.:;?]}¢'"、。〉》」』】〕〗〞︰︱︳﹐、﹒﹔﹕﹖﹗﹚﹜﹞!),.:;?|}︴︶︸︺︼︾﹀﹂﹄﹏、~¢々‖•·ˇˉ―--′’”
([{£¥'"‵〈《「『【〔〖([{£¥〝︵︷︹︻︽︿﹁﹃﹙﹛﹝({“‘
true
true
3
1
true
1
true
rgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg==
false
0
Kč
-
Kč
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
€
-
€
R$
-
R$
€
-
€
\
\-
\
\-
\
\-
\
\-
$
($
)
$
($
)
$
($
)
$
($
)
-
-
\
\
-
\
-
-
-
\
\
-
\
-
:
:
:
:
Lt
-
Lt
kr
-
kr
€
-
€
SFr.
SFr.
-
.
.
/
/
-
-
-
-
:
:
:
:
:
:
/
/
:
(
)
(
)
(
)
(
)
(
)
(
)
???
Page 1
??? (???)
00/00/0000, 00:00:00
Page 1 / 99
T Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple T formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
0
TRUE
=T(0)
0
1
TRUE
=T(1)
2
TRUE
=T(2)
TRUE
TRUE
=T(TRUE())
FALSE
TRUE
=T(FALSE())
01.01.2001
TRUE
=T(VALUE("2001-01-01"))
TRUE
#N/A
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
TRUE
=T(1/0)
#N/A
#N/A
#N/A
#DIV/0!
TRUE
=T(NA())
x
x
x
x
TRUE
=T("x")
TRUE
=T(J1)
TRUE
=T(J2)
TRUE
=T(J3)
TRUE
=T(J4)
TRUE
=T(J5)
TRUE
=T(J6)
TRUE
=T(J7)
#DIV/0!
#DIV/0!
TRUE
=T(J8)
#N/A
#DIV/0!
TRUE
=T(J9)
x
x
TRUE
=T(J10)
TRUE
{=T(J1:J10)}
TRUE
{=T(J1:J10)}
TRUE
{=T(J1:J10)}
TRUE
{=T(J1:J10)}
TRUE
{=T(J1:J10)}
TRUE
{=T(J1:J10)}
TRUE
{=T(J1:J10)}
#DIV/0!
#DIV/0!
TRUE
{=T(J1:J10)}
#N/A
#DIV/0!
TRUE
{=T(J1:J10)}
x
x
TRUE
{=T(J1:J10)}