{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["String","Pattern","Formula","Result"]
[123,"12#",{"$f":"\"Compare(A\"&ROW()&\":B\"&ROW()&\")\"","v":"Compare(A2:B2)"},{"$f":"Compare(A2,B2)","v":true}]
[123,"1#","Compare(A3:B3)",false]
[123,"#2#","Compare(A4:B4)",true]
["ABC","A?C",{"$f":"\"Compare(A\"&ROW()&\":B\"&ROW()&\")\"","v":"Compare(A5:B5)"},{"$f":"Compare(A5,B5)","v":true}]
["ABCD","A?D",{"$f":"\"Compare(A\"&ROW()&\":B\"&ROW()&\")\"","v":"Compare(A6:B6)"},{"$f":"Compare(A6,B6)","v":false}]
["ABCD","?BC?","Compare(A7:B7)",{"$f":"Compare(A7,B7)","v":true}]
["AAAC","AAA*","Compare(A8:B8)",{"$f":"Compare(A8,B8)","v":true}]
["AAAC","aaa*","Compare(A9:B9)",{"$f":"Compare(A9,B9)","v":false}]
["DDC23E","DD*E","Compare(A10:B10)",{"$f":"Compare(A10,B10)","v":true}]
["AA23BB","*##??","Compare(A11:B11)",{"$f":"Compare(A11,B11)","v":true}]
["AA23BB","*##?","Compare(A12:B12)",{"$f":"Compare(A12,B12)","v":false}]
["AA23BB","*##*","Compare(A13:B13)",{"$f":"Compare(A13,B13)","v":true}]
["ABCD","[A]*","Compare(A14:B14)",{"$f":"Compare(A14,B14)","v":true}]
["ABCD","[A]","Compare(A15:B15)",{"$f":"Compare(A15,B15)","v":false}]
["ABCD","[!A]*","Compare(A16:B16)",{"$f":"Compare(A16,B16)","v":false}]
["C22R","[A-Z]##?","Compare(A17:B17)",{"$f":"Compare(A17,B17)","v":true}]
["C22R","[A-Z]##[A-Z]","Compare(A18:B18)",{"$f":"Compare(A18,B18)","v":true}]
["C222","[A-Z]##[A-Z]","Compare(A19:B19)",{"$f":"Compare(A19,B19)","v":false}]

{"sheet":"Sheet2","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Values","Pattern:","Results:",null,null,null,null,{"$f":"CHAR(RANDBETWEEN(65,67))&CHAR(RANDBETWEEN(65,67))&CHAR(RANDBETWEEN(65,67))","v":"CAB"}]
["AAC","?B?",{"$f":"SearchPattern(A2:A15,B2)","v":"ABB"},null,null,null,null,{"$f":"CHAR(RANDBETWEEN(65,67))&CHAR(RANDBETWEEN(65,67))&CHAR(RANDBETWEEN(65,67))","v":"BBA"}]
["BCC",null,"BBB",null,null,null,null,{"$f":"CHAR(RANDBETWEEN(65,67))&CHAR(RANDBETWEEN(65,67))&CHAR(RANDBETWEEN(65,67))","v":"ACB"}]
["AAA",null,"ABB",null,null,null,null,"CCB"]
["CAB",null,"BBC",null,null,null,null,"ACB"]
["AAA",null,"",null,null,null,null,"CCC"]
["BCA",null,null,null,null,null,null,"AAA"]
["CAA",null,null,null,null,null,null,"BAB"]
["ABB",null,null,null,null,null,null,"BBA"]
["CCB",null,null,null,null,null,null,"AAA"]
["BBB",null,null,null,null,null,null,"CAB"]
["ACA",null,null,null,null,null,null,"CCB"]
["ABB",null,null,null,null,null,null,"BAB"]
["BAC",null,null,null,null,null,null,"ABB"]
["BBC"]

{"sheet":"Sheet3","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Values","Numbers","Pattern:","Results:"]
["AAC",1,"?B?",{"$f":"SearchCol(A2:A15,B2:B15,C2)","v":"8"}]
["BCC",2,null,"10"]
["AAA",3,null,"12"]
["CAB",4,null,"14"]
["AAA",5,null,""]
["BCA",6]
["CAA",7]
["ABB",8]
["CCB",9]
["BBB",10]
["ACA",11]
["ABB",12]
["BAC",13]
["BBC",14]

{"sheet":"Sheet4","index":3,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Values","Pattern:","Count:"]
["AAC","*B",{"$f":"COUNTIF(A2:A15,B2)","v":5}]
["BCC"]
["AAA"]
["CAB"]
["AAA"]
["BCA"]
["CAA"]
["ABB"]
["CCB"]
["BBB"]
["ACA"]
["ABB"]
["BAC"]
["BBC"]