{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","tests","testsVerifieResultat"],"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":"Feuil1","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Valeur 1","Valeur 2","Valeur 3","Valeur 4","Somme :"]
[123,54,168,9,{"$f":"MaPremiereSomme(A2,B2,C2,D2)","v":354}]
[4,58,67,21,{"$f":"MaPremiereSomme(A3,B3,C3,D3)","v":150}]
[9,46,41,25,121]
[168,9,41,23,241]
[9,168,9,35,221]
[41,25,41,46,153]
[9,41,25,78,153]
[4,58,41,14,117]
[25,78,58,7,168]
[9,25,78,569,681]
[45,46,41,54,186]

{"sheet":"tests","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Valeur 1","Valeur 2","Valeur 3","Valeur 4","Résultats attendus","Résultats obtenus","Statut"]
[123,54,168,9,354,{"$f":"MaPremiereSomme(A2,B2,C2,D2)","v":354},{"$f":"VerifieResultat(E2,F2)","v":"succes"}]
[0,0,0,0,0,0,{"$f":"VerifieResultat(E3,F3)","v":"succes"}]
[-5,5,-12,12,0,0,"succes"]
[9.9999999999999901E+307,9.9999999999999901E+307,9,35,"ERREUR",{"$error":"#VALUE!"},"succes"]
[9.9999999999999901E+307,168,9,35,9.9999999999999901E+307,9.9999999999999901E+307,"succes"]
[null,78,58,7,{"$f":"D7+C7+B7+A7","v":143},143,"succes"]
[9,null,78,569,{"$f":"D8+C8+B8+A8","v":656},656,{"$f":"VerifieResultat(E8,F8)","v":"succes"}]
[45,46,null,54,{"$f":"D9+C9+B9+A9","v":145},145,"succes"]
[45,46,78,null,{"$f":"D10+C10+B10+A10","v":169},169,"succes"]
[45,46,78,"Mot","ERREUR",{"$error":"#VALUE!"},{"$f":"VerifieResultat(E11,F11)","v":"succes"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$error":"#VALUE!"}]

{"sheet":"testsVerifieResultat","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Valeur 1","Valeur 2","Résultat attendu","Résultat obtenu","Statut"]
[12,52,"echec",{"$f":"VerifieResultat(A2,B2)","v":"echec"},{"$f":"IF(D2=C2,\"OK\",\"PROBLEME\")","v":"OK"}]
[12,12,"succes",{"$f":"VerifieResultat(A3,B3)","v":"succes"},{"$f":"IF(D3=C3,\"OK\",\"PROBLEME\")","v":"OK"}]
[9.9999999999999901E+307,9.9999999999999901E+307,"succes",{"$f":"VerifieResultat(A4,B4)","v":"succes"},"OK"]
["ERREUR",{"$error":"#VALUE!"},"succes",{"$f":"VerifieResultat(A5,B5)","v":"succes"},"OK"]
[12,{"$error":"#VALUE!"},"echec",{"$f":"VerifieResultat(A6,B6)","v":"echec"},"OK"]
[{"$error":"#VALUE!"},12,"echec",{"$f":"VerifieResultat(A7,B7)","v":"echec"},{"$f":"IF(D7=C7,\"OK\",\"PROBLEME\")","v":"OK"}]
[{"$error":"#VALUE!"},{"$error":"#VALUE!"},"echec",{"$f":"VerifieResultat(A8,B8)","v":"echec"},{"$f":"IF(D8=C8,\"OK\",\"PROBLEME\")","v":"OK"}]
[9.9999999999999901E+307,{"$error":"#VALUE!"},"echec",{"$f":"VerifieResultat(A9,B9)","v":"echec"},{"$f":"IF(D9=C9,\"OK\",\"PROBLEME\")","v":"OK"}]
[{"$error":"#VALUE!"},9.9999999999999901E+307,"echec",{"$f":"VerifieResultat(A10,B10)","v":"echec"},"OK"]