{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["SheetB","SheetA","SheetC","Macro1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":25,"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":"SheetB","index":0,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["DEFINED NAMES TEST DOCUMENT"]
[]
["1 - GLOBAL AND LOCAL NAMES ON \"SheetB\""]
[]
["1.1 - LOCAL NAME \"name\"","DEFINED:",null,1,null,null,null,"1.6 - LOCAL BUILT-IN NAMES"]
["Formula","Is","Must","Ok?",null,null,null,"Formula","Is","Must","Ok?"]
["=name",{"$f":"name","v":1},1,{"$f":"IF(IF(AND(ISERROR(B7),ISERROR(C7)),ERROR.TYPE(B7)=ERROR.TYPE(C7),IF(AND(NOT(ISERROR(B7)),NOT(ISERROR(C7))),AND(ISBLANK(B7)=ISBLANK(C7),B7=C7))),1,\"ERR!\")","v":1},null,null,null,"=SUM(Print_Area)",{"$f":"SUM(_xlnm.Print_Area)","v":5},5,{"$f":"IF(IF(AND(ISERROR(I7),ISERROR(J7)),ERROR.TYPE(I7)=ERROR.TYPE(J7),IF(AND(NOT(ISERROR(I7)),NOT(ISERROR(J7))),AND(ISBLANK(I7)=ISBLANK(J7),I7=J7))),1,\"ERR!\")","v":1}]
["=SheetB!name",{"$f":"SheetB!name","v":1},1,{"$f":"IF(IF(AND(ISERROR(B8),ISERROR(C8)),ERROR.TYPE(B8)=ERROR.TYPE(C8),IF(AND(NOT(ISERROR(B8)),NOT(ISERROR(C8))),AND(ISBLANK(B8)=ISBLANK(C8),B8=C8))),1,\"ERR!\")","v":1},null,null,null,"=SUM(Print_Titles)",{"$f":"SUM(_xlnm.Print_Titles)","v":6},6,{"$f":"IF(IF(AND(ISERROR(I8),ISERROR(J8)),ERROR.TYPE(I8)=ERROR.TYPE(J8),IF(AND(NOT(ISERROR(I8)),NOT(ISERROR(J8))),AND(ISBLANK(I8)=ISBLANK(J8),I8=J8))),1,\"ERR!\")","v":1}]
[null,null,null,null,null,null,null,"=SUM(_FilterDatabase)",{"$f":"SUM(_xlnm._FilterDatabase)","v":7},7,{"$f":"IF(IF(AND(ISERROR(I9),ISERROR(J9)),ERROR.TYPE(I9)=ERROR.TYPE(J9),IF(AND(NOT(ISERROR(I9)),NOT(ISERROR(J9))),AND(ISBLANK(I9)=ISBLANK(J9),I9=J9))),1,\"ERR!\")","v":1}]
["1.2 - GLOBAL NAME \"name\"","DEFINED:",null,2]
["Formula","Is","Must","Ok?",null,null,null,"1.7 - BUILT-IN NAMES FROM \"SheetA\""]
["=definedname_import_biff8.xls!name",{"$f":"[0]!name","v":2},2,{"$f":"IF(IF(AND(ISERROR(B12),ISERROR(C12)),ERROR.TYPE(B12)=ERROR.TYPE(C12),IF(AND(NOT(ISERROR(B12)),NOT(ISERROR(C12))),AND(ISBLANK(B12)=ISBLANK(C12),B12=C12))),1,\"ERR!\")","v":1},null,null,null,"Formula","Is","Must","Ok?"]
[null,null,null,null,null,null,null,"=SUM(SheetA!Print_Area)+AREAS(SheetA!Print_Area)",{"$f":"SUM(SheetA!_xlnm.Print_Area)+AREAS(SheetA!_xlnm.Print_Area)","v":20},20,{"$f":"IF(IF(AND(ISERROR(I13),ISERROR(J13)),ERROR.TYPE(I13)=ERROR.TYPE(J13),IF(AND(NOT(ISERROR(I13)),NOT(ISERROR(J13))),AND(ISBLANK(I13)=ISBLANK(J13),I13=J13))),1,\"ERR!\")","v":1}]
["1.3 - LOCAL NAME \"name\" FROM \"SheetA\"",null,null,null,null,null,null,"=SUM(SheetA!Print_Titles)+AREAS(SheetA!Print_Titles)",{"$f":"SUM(SheetA!_xlnm.Print_Titles)+AREAS(SheetA!_xlnm.Print_Titles)","v":21},21,{"$f":"IF(IF(AND(ISERROR(I14),ISERROR(J14)),ERROR.TYPE(I14)=ERROR.TYPE(J14),IF(AND(NOT(ISERROR(I14)),NOT(ISERROR(J14))),AND(ISBLANK(I14)=ISBLANK(J14),I14=J14))),1,\"ERR!\")","v":1}]
["Formula","Is","Must","Ok?",null,null,null,"=SUM(SheetA!_FilterDatabase)",{"$f":"SUM(SheetA!_xlnm._FilterDatabase)","v":22},22,{"$f":"IF(IF(AND(ISERROR(I15),ISERROR(J15)),ERROR.TYPE(I15)=ERROR.TYPE(J15),IF(AND(NOT(ISERROR(I15)),NOT(ISERROR(J15))),AND(ISBLANK(I15)=ISBLANK(J15),I15=J15))),1,\"ERR!\")","v":1}]
["=SheetA!name",{"$f":"SheetA!name","v":3},3,{"$f":"IF(IF(AND(ISERROR(B16),ISERROR(C16)),ERROR.TYPE(B16)=ERROR.TYPE(C16),IF(AND(NOT(ISERROR(B16)),NOT(ISERROR(C16))),AND(ISBLANK(B16)=ISBLANK(C16),B16=C16))),1,\"ERR!\")","v":1},null,null,null,"=SUM(SheetA!Criteria)",{"$f":"SUM(SheetA!_xlnm.Criteria)","v":3},3,{"$f":"IF(IF(AND(ISERROR(I16),ISERROR(J16)),ERROR.TYPE(I16)=ERROR.TYPE(J16),IF(AND(NOT(ISERROR(I16)),NOT(ISERROR(J16))),AND(ISBLANK(I16)=ISBLANK(J16),I16=J16))),1,\"ERR!\")","v":1}]
[null,null,null,null,null,null,null,"=COLUMNS(SheetA!Extract)",{"$f":"COLUMNS(SheetA!_xlnm.Extract)","v":2},2,{"$f":"IF(IF(AND(ISERROR(I17),ISERROR(J17)),ERROR.TYPE(I17)=ERROR.TYPE(J17),IF(AND(NOT(ISERROR(I17)),NOT(ISERROR(J17))),AND(ISBLANK(I17)=ISBLANK(J17),I17=J17))),1,\"ERR!\")","v":1}]
["1.4 - GLOBAL NAME \"globalname\""]
["Formula","Is","Must","Ok?",null,null,null,"1.8 - GLOBAL BUILT-IN NAME \"Criteria\"","DEFINED:",null,23]
["=globalname",{"$f":"globalname","v":4},4,{"$f":"IF(IF(AND(ISERROR(B20),ISERROR(C20)),ERROR.TYPE(B20)=ERROR.TYPE(C20),IF(AND(NOT(ISERROR(B20)),NOT(ISERROR(C20))),AND(ISBLANK(B20)=ISBLANK(C20),B20=C20))),1,\"ERR!\")","v":1},null,null,null,"Formula","Is","Must","Ok?"]
["=definedname_import_biff8.xls!globalname",{"$f":"[0]!globalname","v":4},4,{"$f":"IF(IF(AND(ISERROR(B21),ISERROR(C21)),ERROR.TYPE(B21)=ERROR.TYPE(C21),IF(AND(NOT(ISERROR(B21)),NOT(ISERROR(C21))),AND(ISBLANK(B21)=ISBLANK(C21),B21=C21))),1,\"ERR!\")","v":1},null,null,null,"=SUM(Criteria)",{"$f":"SUM(_xlnm.Criteria)","v":23},23,{"$f":"IF(IF(AND(ISERROR(I21),ISERROR(J21)),ERROR.TYPE(I21)=ERROR.TYPE(J21),IF(AND(NOT(ISERROR(I21)),NOT(ISERROR(J21))),AND(ISBLANK(I21)=ISBLANK(J21),I21=J21))),1,\"ERR!\")","v":1}]
[null,null,null,null,null,null,null,"=SUM(definedname_import_biff8.xls!Criteria)",{"$f":"SUM([0]!_xlnm.Criteria)","v":23},23,{"$f":"IF(IF(AND(ISERROR(I22),ISERROR(J22)),ERROR.TYPE(I22)=ERROR.TYPE(J22),IF(AND(NOT(ISERROR(I22)),NOT(ISERROR(J22))),AND(ISBLANK(I22)=ISBLANK(J22),I22=J22))),1,\"ERR!\")","v":1}]
["1.5 - NAME COLLISION","DEFINED:",null,21]
["Formula","Is","Must","Ok?"]
["=_xlnm.Print_Area.1",{"$f":"__xlnm.Print_Area.1","v":21},21,{"$f":"IF(IF(AND(ISERROR(B25),ISERROR(C25)),ERROR.TYPE(B25)=ERROR.TYPE(C25),IF(AND(NOT(ISERROR(B25)),NOT(ISERROR(C25))),AND(ISBLANK(B25)=ISBLANK(C25),B25=C25))),1,\"ERR!\")","v":1}]
[]
["Built-in defined names"]
[]
[null,null,null,null,1,null,null,"Print_Titles"]
[null,null,null,1,1,1]
[null,null,null,null,1]
[null,null,null,null,null,1,1,"Print_Area"]
[null,null,null,null,null,1,2]
[]
[null,null,null,null,null,"A","B","_FilterDatabase"]
[null,null,null,null,null,1,3]
[null,null,null,null,null,2,1]

{"sheet":"SheetA","index":1,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["DEFINED NAMES TEST DOCUMENT"]
[]
["2 - GLOBAL AND LOCAL NAMES ON \"SheetA\""]
[]
["2.1 - LOCAL NAME \"name\"","DEFINED:",null,3,null,null,null,null,"2.6 - LOCAL BUILT-IN NAMES"]
["Formula","Is","Must","Ok?",null,null,null,null,"Formula","Is","Must","Ok?"]
["=name",{"$f":"name","v":3},3,{"$f":"IF(IF(AND(ISERROR(B7),ISERROR(C7)),ERROR.TYPE(B7)=ERROR.TYPE(C7),IF(AND(NOT(ISERROR(B7)),NOT(ISERROR(C7))),AND(ISBLANK(B7)=ISBLANK(C7),B7=C7))),1,\"ERR!\")","v":1},null,null,null,null,"=SUM(Print_Area)+AREAS(Print_Area)",{"$f":"SUM(_xlnm.Print_Area)+AREAS(_xlnm.Print_Area)","v":20},20,{"$f":"IF(IF(AND(ISERROR(J7),ISERROR(K7)),ERROR.TYPE(J7)=ERROR.TYPE(K7),IF(AND(NOT(ISERROR(J7)),NOT(ISERROR(K7))),AND(ISBLANK(J7)=ISBLANK(K7),J7=K7))),1,\"ERR!\")","v":1}]
["=SheetA!name",{"$f":"SheetA!name","v":3},3,{"$f":"IF(IF(AND(ISERROR(B8),ISERROR(C8)),ERROR.TYPE(B8)=ERROR.TYPE(C8),IF(AND(NOT(ISERROR(B8)),NOT(ISERROR(C8))),AND(ISBLANK(B8)=ISBLANK(C8),B8=C8))),1,\"ERR!\")","v":1},null,null,null,null,"=SUM(Print_Titles)+AREAS(Print_Titles)",{"$f":"SUM(_xlnm.Print_Titles)+AREAS(_xlnm.Print_Titles)","v":21},21,{"$f":"IF(IF(AND(ISERROR(J8),ISERROR(K8)),ERROR.TYPE(J8)=ERROR.TYPE(K8),IF(AND(NOT(ISERROR(J8)),NOT(ISERROR(K8))),AND(ISBLANK(J8)=ISBLANK(K8),J8=K8))),1,\"ERR!\")","v":1}]
[null,null,null,null,null,null,null,null,"=SUM(_FilterDatabase)",{"$f":"SUM(_xlnm._FilterDatabase)","v":22},22,{"$f":"IF(IF(AND(ISERROR(J9),ISERROR(K9)),ERROR.TYPE(J9)=ERROR.TYPE(K9),IF(AND(NOT(ISERROR(J9)),NOT(ISERROR(K9))),AND(ISBLANK(J9)=ISBLANK(K9),J9=K9))),1,\"ERR!\")","v":1}]
["2.2 - GLOBAL NAME \"name\"",null,null,null,null,null,null,null,"=SUM(Criteria)",{"$f":"SUM(_xlnm.Criteria)","v":3},3,{"$f":"IF(IF(AND(ISERROR(J10),ISERROR(K10)),ERROR.TYPE(J10)=ERROR.TYPE(K10),IF(AND(NOT(ISERROR(J10)),NOT(ISERROR(K10))),AND(ISBLANK(J10)=ISBLANK(K10),J10=K10))),1,\"ERR!\")","v":1}]
["Formula","Is","Must","Ok?",null,null,null,null,"=COLUMNS(Extract)",{"$f":"COLUMNS(_xlnm.Extract)","v":2},2,{"$f":"IF(IF(AND(ISERROR(J11),ISERROR(K11)),ERROR.TYPE(J11)=ERROR.TYPE(K11),IF(AND(NOT(ISERROR(J11)),NOT(ISERROR(K11))),AND(ISBLANK(J11)=ISBLANK(K11),J11=K11))),1,\"ERR!\")","v":1}]
["=definedname_import_biff8.xls!name",{"$f":"[0]!name","v":2},2,{"$f":"IF(IF(AND(ISERROR(B12),ISERROR(C12)),ERROR.TYPE(B12)=ERROR.TYPE(C12),IF(AND(NOT(ISERROR(B12)),NOT(ISERROR(C12))),AND(ISBLANK(B12)=ISBLANK(C12),B12=C12))),1,\"ERR!\")","v":1}]
[null,null,null,null,null,null,null,null,"2.7 - BUILT-IN NAMES FROM \"SheetB\""]
["2.3 - LOCAL NAME \"name\" FROM \"SheetB\"",null,null,null,null,null,null,null,"Formula","Is","Must","Ok?"]
["Formula","Is","Must","Ok?",null,null,null,null,"=SUM(SheetB!Print_Area)",{"$f":"SUM(SheetB!_xlnm.Print_Area)","v":5},5,{"$f":"IF(IF(AND(ISERROR(J15),ISERROR(K15)),ERROR.TYPE(J15)=ERROR.TYPE(K15),IF(AND(NOT(ISERROR(J15)),NOT(ISERROR(K15))),AND(ISBLANK(J15)=ISBLANK(K15),J15=K15))),1,\"ERR!\")","v":1}]
["=SheetB!name",{"$f":"SheetB!name","v":1},1,{"$f":"IF(IF(AND(ISERROR(B16),ISERROR(C16)),ERROR.TYPE(B16)=ERROR.TYPE(C16),IF(AND(NOT(ISERROR(B16)),NOT(ISERROR(C16))),AND(ISBLANK(B16)=ISBLANK(C16),B16=C16))),1,\"ERR!\")","v":1},null,null,null,null,"=SUM(SheetB!Print_Titles)",{"$f":"SUM(SheetB!_xlnm.Print_Titles)","v":6},6,{"$f":"IF(IF(AND(ISERROR(J16),ISERROR(K16)),ERROR.TYPE(J16)=ERROR.TYPE(K16),IF(AND(NOT(ISERROR(J16)),NOT(ISERROR(K16))),AND(ISBLANK(J16)=ISBLANK(K16),J16=K16))),1,\"ERR!\")","v":1}]
[null,null,null,null,null,null,null,null,"=SUM(SheetB!_FilterDatabase)",{"$f":"SUM(SheetB!_xlnm._FilterDatabase)","v":7},7,{"$f":"IF(IF(AND(ISERROR(J17),ISERROR(K17)),ERROR.TYPE(J17)=ERROR.TYPE(K17),IF(AND(NOT(ISERROR(J17)),NOT(ISERROR(K17))),AND(ISBLANK(J17)=ISBLANK(K17),J17=K17))),1,\"ERR!\")","v":1}]
["2.4 - GLOBAL NAME \"globalname\"","DEFINED:",null,4]
["Formula","Is","Must","Ok?",null,null,null,null,"2.8 - GLOBAL BUILT-IN NAME \"Criteria\""]
["=globalname",{"$f":"globalname","v":4},4,{"$f":"IF(IF(AND(ISERROR(B20),ISERROR(C20)),ERROR.TYPE(B20)=ERROR.TYPE(C20),IF(AND(NOT(ISERROR(B20)),NOT(ISERROR(C20))),AND(ISBLANK(B20)=ISBLANK(C20),B20=C20))),1,\"ERR!\")","v":1},null,null,null,null,"Formula","Is","Must","Ok?"]
["=definedname_import_biff8.xls!globalname",{"$f":"[0]!globalname","v":4},4,{"$f":"IF(IF(AND(ISERROR(B21),ISERROR(C21)),ERROR.TYPE(B21)=ERROR.TYPE(C21),IF(AND(NOT(ISERROR(B21)),NOT(ISERROR(C21))),AND(ISBLANK(B21)=ISBLANK(C21),B21=C21))),1,\"ERR!\")","v":1},null,null,null,null,"=SUM(Criteria)",{"$f":"SUM(_xlnm.Criteria)","v":3},3,{"$f":"IF(IF(AND(ISERROR(J21),ISERROR(K21)),ERROR.TYPE(J21)=ERROR.TYPE(K21),IF(AND(NOT(ISERROR(J21)),NOT(ISERROR(K21))),AND(ISBLANK(J21)=ISBLANK(K21),J21=K21))),1,\"ERR!\")","v":1}]
[null,null,null,null,null,null,null,null,"=SUM(definedname_import_biff8.xls!Criteria)",{"$f":"SUM([0]!_xlnm.Criteria)","v":23},23,{"$f":"IF(IF(AND(ISERROR(J22),ISERROR(K22)),ERROR.TYPE(J22)=ERROR.TYPE(K22),IF(AND(NOT(ISERROR(J22)),NOT(ISERROR(K22))),AND(ISBLANK(J22)=ISBLANK(K22),J22=K22))),1,\"ERR!\")","v":1}]
["2.5 - NAME COLLISION","DEFINED:",null,22]
["Formula","Is","Must","Ok?"]
["=SheetA!_xlnm.Criteria",{"$f":"SheetA!__xlnm.Criteria","v":22},22,{"$f":"IF(IF(AND(ISERROR(B25),ISERROR(C25)),ERROR.TYPE(B25)=ERROR.TYPE(C25),IF(AND(NOT(ISERROR(B25)),NOT(ISERROR(C25))),AND(ISBLANK(B25)=ISBLANK(C25),B25=C25))),1,\"ERR!\")","v":1}]
[]
["Built-in defined names"]
[]
[null,null,null,null,1,1,null,null,"Print_Titles"]
[null,null,null,1,1,1,2]
[null,null,null,1,1,1,2]
[null,null,null,null,1,2]
[null,null,null,null,null,null,1,1,"Print_Area",1,1]
[null,null,null,null,null,null,1,1,null,1,1]
[]
[null,null,null,null,null,null,1,1,null,1,1]
[null,null,null,null,null,null,1,1,null,1,1]
[]
[null,null,null,null,null,null,"A","B","_FilterDatabase"]
[null,null,null,null,null,null,1,4]
[null,null,null,null,null,null,2,5]
[null,null,null,null,null,null,3,7]
[]
[null,null,null,null,null,null,null,"A","Criteria"]
[null,null,null,null,null,null,null,3]
[]
[null,null,null,null,null,null,"A","B","Extract"]
[null,null,null,null,null,null,3,7]

{"sheet":"SheetC","index":2,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["DEFINED NAMES TEST DOCUMENT"]
[]
["3 - OTHER DEFINED NAMES"]
[]
["3.1 - UNDEFINED NAMES",null,null,null,null,"3.4 - COMPLEX CONTENTS"]
["Formula","Is","Must","Ok?",null,"Formula",null,"Is",null,"Must","Ok?"]
["=my_name",{"$f":"my_name","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"IF(IF(AND(ISERROR(B7),ISERROR(C7)),ERROR.TYPE(B7)=ERROR.TYPE(C7),IF(AND(NOT(ISERROR(B7)),NOT(ISERROR(C7))),AND(ISBLANK(B7)=ISBLANK(C7),B7=C7))),1,\"ERR!\")","v":1},null,"=SheetC!RC[-1]",1,{"$f":"relname1","v":1},2,1,{"$f":"IF(IF(AND(ISERROR(H7),ISERROR(J7)),ERROR.TYPE(H7)=ERROR.TYPE(J7),IF(AND(NOT(ISERROR(H7)),NOT(ISERROR(J7))),AND(ISBLANK(H7)=ISBLANK(J7),H7=J7))),1,\"ERR!\")","v":1}]
["=definedname_import_biff8.xls!my_name",{"$f":"[0]!my_name","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"IF(IF(AND(ISERROR(B8),ISERROR(C8)),ERROR.TYPE(B8)=ERROR.TYPE(C8),IF(AND(NOT(ISERROR(B8)),NOT(ISERROR(C8))),AND(ISBLANK(B8)=ISBLANK(C8),B8=C8))),1,\"ERR!\")","v":1},null,"=SheetC!RC[1]",3,{"$f":"relname2","v":4},4,4,1]
["=SheetB!my_name",{"$f":"SheetB!my_name","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"IF(IF(AND(ISERROR(B9),ISERROR(C9)),ERROR.TYPE(B9)=ERROR.TYPE(C9),IF(AND(NOT(ISERROR(B9)),NOT(ISERROR(C9))),AND(ISBLANK(B9)=ISBLANK(C9),B9=C9))),1,\"ERR!\")","v":1},null,"=SheetC!R[1]C[-1]",5,{"$f":"relname3","v":7},6,7,1]
["=SheetA!my_name",{"$f":"SheetA!my_name","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"IF(IF(AND(ISERROR(B10),ISERROR(C10)),ERROR.TYPE(B10)=ERROR.TYPE(C10),IF(AND(NOT(ISERROR(B10)),NOT(ISERROR(C10))),AND(ISBLANK(B10)=ISBLANK(C10),B10=C10))),1,\"ERR!\")","v":1},null,"=SheetC!R[-1]C[1]",7,{"$f":"relname4","v":6},8,6,1]
[null,null,null,null,null,"={1,2;3,4}",null,{"$f":"SUM(complexname1)","v":10},null,10,1]
["3.2 - FUNCTION STYLE NAMES",null,null,null,null,"={1}+SheetC!$G$12 SheetC!$G$12+{1}",9,{"$f":"complexname2","v":11},null,11,1]
["Formula","Is","Must","Ok?",null,"=!$G$13",12,{"$f":"sheetrelname1","v":12},null,12,1]
["=my_macro(1)",{"$f":"my_macro(1)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"IF(IF(AND(ISERROR(B14),ISERROR(C14)),ERROR.TYPE(B14)=ERROR.TYPE(C14),IF(AND(NOT(ISERROR(B14)),NOT(ISERROR(C14))),AND(ISBLANK(B14)=ISBLANK(C14),B14=C14))),1,\"ERR!\")","v":1},null,"=!RC[-1]",13,{"$f":"sheetrelname2","v":13},14,13,1]
["=definedname_import_biff8.xls!my_macro(2)",{"$f":"[0]!my_macro(2)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"IF(IF(AND(ISERROR(B15),ISERROR(C15)),ERROR.TYPE(B15)=ERROR.TYPE(C15),IF(AND(NOT(ISERROR(B15)),NOT(ISERROR(C15))),AND(ISBLANK(B15)=ISBLANK(C15),B15=C15))),1,\"ERR!\")","v":1}]
["=SheetB!my_macro(3)",{"$f":"SheetB!my_macro(3)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"IF(IF(AND(ISERROR(B16),ISERROR(C16)),ERROR.TYPE(B16)=ERROR.TYPE(C16),IF(AND(NOT(ISERROR(B16)),NOT(ISERROR(C16))),AND(ISBLANK(B16)=ISBLANK(C16),B16=C16))),1,\"ERR!\")","v":1}]
["=SheetA!my_macro(4)",{"$f":"SheetA!my_macro(4)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"IF(IF(AND(ISERROR(B17),ISERROR(C17)),ERROR.TYPE(B17)=ERROR.TYPE(C17),IF(AND(NOT(ISERROR(B17)),NOT(ISERROR(C17))),AND(ISBLANK(B17)=ISBLANK(C17),B17=C17))),1,\"ERR!\")","v":1}]
[]
["3.3 - SHEET MACRO CALLS"]
["Formula","Is","Must","Ok?"]
["=macro1",{"$f":"macro1","v":true},false,{"$f":"IF(IF(AND(ISERROR(B21),ISERROR(C21)),ERROR.TYPE(B21)=ERROR.TYPE(C21),IF(AND(NOT(ISERROR(B21)),NOT(ISERROR(C21))),AND(ISBLANK(B21)=ISBLANK(C21),B21=C21))),1,\"ERR!\")","v":"ERR!"}]
["=macro2(1)",{"$f":"macro2(1)","v":2},2,{"$f":"IF(IF(AND(ISERROR(B22),ISERROR(C22)),ERROR.TYPE(B22)=ERROR.TYPE(C22),IF(AND(NOT(ISERROR(B22)),NOT(ISERROR(C22))),AND(ISBLANK(B22)=ISBLANK(C22),B22=C22))),1,\"ERR!\")","v":1}]

{"sheet":"Macro1","index":3,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RETURN()","v":true},null,{"$f":"RETURN(2)","v":true}]