2017-07-04T14:48:09.4272387572017-07-19T09:14:31.836033712PT1H41M10S31LibreOfficeDev/6.0.0.0.alpha0$Linux_X86_64 LibreOffice_project/cfadf08160248463355f8ce157c01349bd6c6bde 0 0 42447 14022 view1 0 0 0 0 0 0 2 0 0 0 0 0 100 60 true false 0 8 0 0 0 0 2 0 0 0 0 0 100 60 true false Sheet2 1395 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 en US 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 FINDB Function Result WAAR Sheet Result Description 1 WAAR Simple REPLACEB formulas with local references and values Function Expected Correct FunctionString Comment data 3 3 WAAR =FINDB("cd";"abcdefg";1) ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ 19 19 WAAR =FINDB("ᄫᄬ";$I$2;17) ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ 19 19 WAAR =FINDB("ᄫᄬ";$I$2;16) #VALUE! #VALUE! WAAR =FINDB("cd";"abcdefg";0) 3 3 WAAR =FINDB("cd";"abcdefg";1) 3 3 WAAR =FINDB("cd";"abcdefg";3) #VALUE! #VALUE! WAAR =FINDB("cd";"abcdefg";4) 5 5 WAAR =FINDB("efg";"abcdefg";3) 5 5 WAAR =FINDB("efg";"abcdefg";5) #VALUE! #VALUE! WAAR =FINDB("efg";"abcdefg";6) 19 19 WAAR =FINDB("ᄫᄬ";$I$2;1) 19 19 WAAR =FINDB("ᄫᄬ";$I$2;2) 19 19 WAAR =FINDB("ᄫᄬ";$I$2;18) 19 19 WAAR =FINDB("ᄫᄬ";$I$2;19) #VALUE! #VALUE! WAAR =FINDB("ᄫᄬ";$I$2;20) 20 20 WAAR =FINDB("ᄫᄬ";$I$3;9) abcdefg a 6 6 WAAR =FINDB(76;998877665544) Miriam McGovern Ceramic Insulators #124-TD45-87 abcdefg b 1 1 WAAR =FINDB("M";I18) Copper Coils #12-671-6772 abcdefg c 6 6 WAAR =FINDB("m";I18) Variable Resistors #116010 abcdefg d 8 8 WAAR =FINDB("M";I18;3) abcdefg e Ceramic Insulators Ceramic Insulators WAAR =MID(K18;1;FINDB(" #";K18;1)-1) abcdefg f Copper Coils Copper Coils WAAR =MID(K19;1;FINDB(" #";K19;1)-1) Variable Resistors Variable Resistors WAAR =MID(K20;1;FINDB(" #";K20;1)-1) Err:511 Err:511 WAAR =FINDB("aa") 1 1 WAAR {=FINDB(O17:O22;N17:N22)} 2 2 WAAR {=FINDB(O17:O22;N17:N22)} 3 3 WAAR {=FINDB(O17:O22;N17:N22)} 4 4 WAAR {=FINDB(O17:O22;N17:N22)} 5 5 WAAR {=FINDB(O17:O22;N17:N22)} 6 6 WAAR {=FINDB(O17:O22;N17:N22)}