2017-07-04T14:48:09.4272387572017-07-06T19:24:21.086006189PT53M58S16LibreOfficeDev/6.0.0.0.alpha0$Linux_X86_64 LibreOffice_project/3ddbb0e4797448749643e1f43dd5fcfde1486728 0 0 37932 16495 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 2 2 0 0 0 0 2 0 0 0 0 0 100 60 true false Sheet1 993 0 100 60 false true true true 12632256 true true true true true false false 1000 1000 1 1 true false 7 true false false 0 true kQH+/0dlbmVyaWMgUHJpbnRlcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAU0dFTlBSVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAMAsgAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9R2VuZXJpYyBQcmludGVyCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCm1hcmdpbmRhanVzdG1lbnQ9MCwwLDAsMApjb2xvcmRlcHRoPTI0CnBzbGV2ZWw9MApwZGZkZXZpY2U9MApjb2xvcmRldmljZT0wClBQRENvbnRleERhdGEKUGFnZVNpemU6QTQARHVwbGV4Ok5vbmUAABIAQ09NUEFUX0RVUExFWF9NT0RFDwBEdXBsZXhNb2RlOjpPZmY= Generic Printer zh CN :!),.:;?]}¢'"、。〉》」』】〕〗〞︰︱︳﹐､﹒﹔﹕﹖﹗﹚﹜﹞！），．：；？｜｝︴︶︸︺︼︾﹀﹂﹄﹏､～￠々‖•·ˇˉ―--′’” ([{£¥'"‵〈《「『【〔〖（［｛￡￥〝︵︷︹︻︽︿﹁﹃﹙﹛﹝（｛“‘ true 3 true false true true 12632256 true true true false true false true 1 false 1000 1000 false 1 true Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € R$ - R$ € - € \ \- \ \- \ \- \ \- $ ($ ) $ ($ ) $ ($ ) $ ($ ) - - \ \ - \ - - - \ \ - \ - : : : : Lt - Lt / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ??? Page 1 ???(???) 00-00-0000, 00:00:00 Page 1/ 99 REPLACEB Function Result WAAR Sheet Result Description 1 WAAR Simple REPLACEB formulas with local references and values Function Expected Correct FunctionString Comment ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ab ᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ab ᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K2;L2;"ab") 1 33 abᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ abᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K3;L3;"ab") 2 1 33 ᄩab ᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩab ᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K4;L4;"ab") 3 1 33 ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K5;L5;"ab") 4 1 33 ᄩᄔab ᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩᄔab ᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K6;L6;"ab") 5 1 33 ᄩᄔ abᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩᄔ abᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K7;L7;"ab") 6 1 33 abᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ abᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K8;L8;"ab") 2 1 33 ab ᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ab ᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K9;L9;"ab") 2 32 abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K10;L10;"ab") 2 3 31 ab ᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ab ᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K11;L11;"ab") 2 4 30 abᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ abᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K12;L12;"ab") 2 5 29 ab ᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ab ᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K13;L13;"ab") 2 6 28 ab ᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ab ᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K14;L14;"ab") 2 32 ᄩab ᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩab ᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K15;L15;"ab") 3 31 ᄩ ab ᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩ ab ᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K16;L16;"ab") 4 30 ᄩᄔab ᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩᄔab ᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K17;L17;"ab") 5 29 ᄩᄔ ab ᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩᄔ ab ᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K18;L18;"ab") 6 28 abᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ abᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K19;L19;"ab") 1 6 28 abᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ abᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K20;L20;"ab") 2 5 29 ᄩabᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩabᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K21;L21;"ab") 3 4 30 ᄩ abᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩ abᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K22;L22;"ab") 4 3 31 ᄩᄔabᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩᄔabᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K23;L23;"ab") 5 2 32 ᄩᄔ abᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩᄔ abᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K24;L24;"ab") 6 1 33 ᄩ ᄬᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩ ᄬᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K25;L25;"ᄬ") 4 1 33 ᄩ ᄬ ᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩ ᄬ ᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K26;L26;"ᄬ") 4 2 32 ᄩᄬ ᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩᄬ ᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K27;L27;"ᄬ") 3 1 33 ᄩᄬᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ᄩᄬᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;K28;L28;"ᄬ") 3 2 32 Err:502 Err:502 WAAR =REPLACEB($K$1;0;3;"ab") The quick brown fox jumped… ab ᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ ab ᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ WAAR =REPLACEB($K$1;2;0;"ab") Err:502 Err:502 WAAR =REPLACEB($K$1;2;-1;"ab") Err:502 Err:502 WAAR =REPLACEB($K$1;-2;4;"ab") The slow brown fox jumped… The slow brown fox jumped… WAAR =REPLACEB($K$29;5;5;"slow") Err:502 Err:502 WAAR =REPLACEB($K$29;25;5;"slow") Err:502 Err:502 WAAR =REPLACEB($K$29;5;25;"slow")