2016-05-23T19:52:21.032366237P0D1LibreOfficeDev/5.3.0.0.alpha1$Linux_X86_64 LibreOffice_project/02af87fdd76bc94fb51aeb160c74d6f719c42c63
0
0
35387
4586
view1
2
8
0
0
0
0
2
0
0
0
0
0
85
60
true
false
1
5
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+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg==
false
0
Kč
-
Kč
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
€
-
€
R$
-
R$
€
-
€
\
\-
\
\-
\
\-
\
\-
$
($
)
$
($
)
$
($
)
$
($
)
-
-
\
\
-
\
-
-
-
\
\
-
\
-
:
:
:
:
Lt
-
Lt
/
/
-
-
-
-
:
:
:
:
:
:
/
/
:
(
)
(
)
(
)
(
)
(
)
(
)
???
Page 1
??? (???)
00/00/0000, 00:00:00
Page 1 / 99
LEN Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple LEN formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
Sale Price
Data 1 (Empty)
Standard Formulas
Data 2
10
10
TRUE
=LEN(I1)
Sweden
0
ab
0
0
TRUE
=LEN(I3)
0
cd
6
6
TRUE
=LEN("output")
0
ef
0
0
TRUE
{=SUM(LEN(M2:M6))}
0
abc
12
12
TRUE
{=SUM(LEN(M2:M6))}
0
def
10
10
TRUE
{=LEN(I1:I2)}
0
6
6
TRUE
{=LEN(I1:I2)}
Err:511
error
TRUE
=LEN()
16
16
TRUE
=LEN(I10)
Excel 2016 returns 25
ab😂de𝔖gh𝕬𝖈𝖍𝖙𝖚𝖓𝖌!
3
3
TRUE
=LEN(I11)
Excel 2016 returns 4
ab😂
4
4
TRUE
=LEN(I12)
Excel 2016 returns 6
"𧌒𧀬"
6
6
TRUE
=LEN(I13)
Excel 2016 returns 6
"üë"