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 𝖍𝖙 𝕬𝖈𝖍𝖙𝖚𝖓𝖌!