2018-11-13T17:59:17.679132174P0D1LibreOfficeDev/6.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/c846e85f03b635c88e043166a352a42eeae39304 0 0 33535 6588 view1 2 8 0 0 0 0 2 0 0 0 0 0 85 60 true false 8 13 0 0 0 0 2 0 0 0 0 0 85 60 true false Sheet2 1233 0 85 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false 7 true true true false false false true true false 0 en US zh CN :!),.:;?]}¢'"、。〉》」』】〕〗〞︰︱︳﹐､﹒﹔﹕﹖﹗﹚﹜﹞！），．：；？｜｝︴︶︸︺︼︾﹀﹂﹄﹏､～￠々‖•·ˇˉ―--′’” ([{£¥'"‵〈《「『【〔〖（［｛￡￥〝︵︷︹︻︽︿﹁﹃﹙﹛﹝（｛“‘ false false 1270 1270 true true true true true false 12632256 false Lexmark-E352dn true 3 1 true 1 true lwH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERRQARHVwbGV4TW9kZTo6TG9uZ0VkZ2U= true false false false Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € R$ - R$ € - € \ \- \ \- \ \- \ \- $ ($ ) $ ($ ) $ ($ ) $ ($ ) - - \ \ - \ - - - \ \ - \ - : : : : Lt - Lt kr - kr € - € SFr. SFr. - / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ??? Page 1 ???(???) 00.00.0000, 00:00:00 Page 1/ 99 REGEX Function Result PRAVDA Sheet Result Description 1 PRAVDA Simple REGEX formulas with local references and values Function Expected Correct FunctionString Comment The end Needle Needle PRAVDA =REGEX("Needle in a haystack"; ".e{2}dle") The end 101 101 PRAVDA =REGEX("LibreOffice text 101"; "[0-9]+") The end 826.25 826.25 PRAVDA =REGEX("The price today is $826.25"; "[0-9]*\.[0-9]+[0-9]+") (Content) (Content) PRAVDA =REGEX("(Content) between brackets"; "\(([A-Za-z]+)\)") AA end AA end PRAVDA =REGEX("The end"; "^The"; "AA") The end The end PRAVDA =REGEX("The end"; "^BBe"; "AA") The end The end PRAVDA =REGEX("The end"; "^BBe"; "AA") AA end AA end PRAVDA =REGEX("The end"; "^The"; "AA";"g") AA end AA end PRAVDA =REGEX(I1; "^The"; "AA";"g") AA end AA end PRAVDA {=REGEX(I1:I3; "^The"; "AA";"g")} AA end AA end PRAVDA {=REGEX(I1:I3; "^The"; "AA";"g")} AA end AA end PRAVDA {=REGEX(I1:I3; "^The"; "AA";"g")}