2016-05-23T19:52:21.032366237P0D1LibreOfficeDev/5.3.0.0.alpha1$Linux_X86_64 LibreOffice_project/5d39c2013374727b1c8f147b8b99d54402a7ff02 0 0 26356 4455 view1 2 8 0 0 0 0 2 0 0 0 0 0 85 60 true false 1 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 / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 REPLACE Function Result TRUE Sheet Result Description 1 TRUE Simple REPLACE formulas with local references and values Function Expected Correct FunctionString Comment Data 444234567 444234567 TRUE =REPLACE("1234567",1,1,"444") abcdefghijk abcde*k abcde*k TRUE =REPLACE(I2,6,5,"*") 2009 2010 2010 TRUE =REPLACE(I3,3,2,"10") 123456 @456 @456 TRUE =REPLACE(I4,1,3,"@") 1234Q56789 1234Q56789 TRUE =REPLACE("123456789",5,0,"Q") abcdefghijkxx abcdefghijkxx TRUE =REPLACE(I2,77,1,"xx") Err:502 Err:502 TRUE =REPLACE("123456789",0,0,"Q") Err:502 Err:502 TRUE =REPLACE("123456789",-5,0,"Q") Q Q TRUE =REPLACE("";5;1;"Q") B😂 ab😂B😂gh𝕬𝖈𝖍𝖙𝖚𝖓𝖌! ab😂B😂gh𝕬𝖈𝖍𝖙𝖚𝖓𝖌! TRUE =REPLACE(I11;4;3;I10) ab😂de𝔖gh𝕬𝖈𝖍𝖙𝖚𝖓𝖌! B😂xXx😂d B😂xXx😂d TRUE =REPLACE(I12;3;1;"xXx") B😂c😂d BxXxc😂d BxXxc😂d TRUE =REPLACE(I12;2;1;"xXx") B😂𝖍𝖙😂d B😂𝖍𝖙😂d TRUE =REPLACE(I12;3;1;"𝖍𝖙") Bx𝖍𝖙xc😂d Bx𝖍𝖙xc😂d TRUE =REPLACE(I12;2;1;"x𝖍𝖙x") BxXx😂c😂d BxXx😂c😂d TRUE =REPLACE(I12;2;0;"xXx") B😂xXxc😂d B😂xXxc😂d TRUE =REPLACE(I12;3;0;"xXx") xYxB😂c😂d xYxB😂c😂d TRUE =REPLACE(I12;1;0;"xYx") xYx😂c😂d xYx😂c😂d TRUE =REPLACE(I12;1;1;"xYx") xYxc😂d xYxc😂d TRUE =REPLACE(I12;1;2;"xYx") xYx😂d xYx😂d TRUE =REPLACE(I12;1;3;"xYx") xYxd xYxd TRUE =REPLACE(I12;1;4;"xYx")