2017-02-24T18:59:59.173514908P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/36de6c50684c8241969a2064d30aff41e0bc5d97 0 0 33104 12386 view1 2 8 0 0 0 0 2 0 0 0 0 0 85 60 true false 2 10 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 SEARCH Function Result TRUE Sheet Result Description 1 TRUE Simple SEARCH formulas with local references and values Function Expected Correct FunctionString Comment LibreOffice 10 10 TRUE =SEARCH(54,998877665544) 6 6 TRUE =IF(ISERROR(SEARCH("Gewinn|Promotion|Replay",I5)),"",K5) 2 2 TRUE =IF(ISERROR(SEARCH("Gewinn|Promotion|Replay",I6)),"",K6) 4 4 TRUE {=SUM(IF(ISERROR(SEARCH("Mark",I10:I19)),0,1))} Gewinn 6 6 6 TRUE =SEARCH("off",I1) Gewinn 2 6 6 TRUE =SEARCH("OFf",I1) 6 6 TRUE =SEARCH("off",I1,2) #VALUE! #VALUE! TRUE =SEARCH("off",I1,7) 5 5 TRUE =SEARCH("e",I1) Mark 11 11 TRUE =SEARCH("e",I1,6) Julia Err:502 error TRUE =SEARCH("e",I1,0) Constraints: Start >= 1 Wookie Err:502 error TRUE =SEARCH("e","LibreOffice",0) Mark Err:502 error TRUE =SEARCH("e","LibreOffice",-1) It is a non-compliance with a purpose to keep backward compatibility (extract from the source code):// This should use GetStringPositionArgument() but old versions up// to LibreOffice 4.2.5 allowed and ignored 0 and negative values.// It is unnecessary to break existing documents that "rely" on// that behavior. Though ODFF constrains Start to be >=1./* TODO: fix this and possibly break those broken documents? */Given that version 4.2.5 dates from June 2014, one could argue that making the code fully ODFF compliant will not really break backward compatibility (version 5.4.0 is scheduled for August 2017).OTOH, it doesn't do real harm, the source code simply replaces the value of argument Start with 1 when the value passed is 0 or negative. Mark Julia Gordon Flash Andromeda Mark 2 2 TRUE =SEARCH(I21;J21) Excel 2016 has same result B😂 ab😂de𝔖gh𝕬𝖈𝖍𝖙𝖚𝖓𝖌! 3 3 TRUE =SEARCH(I22;J21) Excel 2016 has same result 😂d ab😂 3 3 TRUE =SEARCH(I23;J23) Excel 2016 returns 4 𧀬 "𧌒𧀬" 8 8 TRUE =SEARCH(I24;J21) Excel 2016 returns 10 h 4 4 TRUE =SEARCH(I25;J25) Excel 2016 has same result e "üë" 3 3 TRUE =SEARCH(I26;J26) Excel 2016 returns 5 𝖍𝖙 𝕬𝖈𝖍𝖙𝖚𝖓𝖌!