{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Entrées","Affectation",null,null,"Valeur entrées",null,null,null,"La base de données est en colonne E"]
["A",{"$f":"IF(A2=\"\",\"\",IF(COUNTIF(E2:E11,A2),INDEX(E:E,MATCH($A2,E:E,0)+12),\"à choisir\"))","v":10},null,null,"A",null,null,null,"Pour affecter la validation, cette base doit se trouver dans u,ne seule c olonne"]
["D",{"$f":"IF(A3=\"\",\"\",IF(COUNTIF(E3:E12,A3),INDEX(E:E,MATCH($A3,E:E,0)+12),\"à choisir\"))","v":16},null,null,"B",null,null,null,"pour les vcamleurs définies"]
["F",20,null,null,"C",null,null,null,"liste des valeurs pl;acées en A se trouve en E2:E11"]
["G",22,null,null,"D",null,null,null,"liste des valeurs de B correspondantes en E14:E23 (même ordre)"]
["X","à choisir",null,null,"E"]
[null,"",null,null,"F",null,null,null,"liste des valeurs hors formules: E26 à E37"]
[null,"",null,null,"G"]
[null,"",null,null,"H",null,null,null,"si la valeur de A n'est pas référencée, B affiche à choisir"]
[null,"",null,null,"I",null,null,null,"La liste est alors E26:E37"]
[null,"",null,null,"J"]
[null,"",null,null,null,null,null,null,"si le choix en B passe par la liste, la formule disparaît"]
[null,"",null,null,"valeurs correspondantes aux entrées (même ordre)",null,null,null,"sdi la formule en B à disparu et A dans la liste, B n'autorise que la  valeur correspondante"]
[null,"",null,null,10]
[null,"",null,null,12,null,null,null,"La formule en B est à placer avant la validation"]
[null,"",null,null,14]
[null,"",null,null,16]
[null,"",null,null,18]
[null,"",null,null,20]
[null,"",null,null,22]
[null,"",null,null,24]
[null,"",null,null,26]
[null,"",null,null,28]
[null,""]
[null,"",null,null,"Valeurs sélectionnables si à choisir"]
[null,"",null,null,120]
[null,"",null,null,130]
[null,"",null,null,140]
[null,"",null,null,150]
[null,"",null,null,160]
[null,null,null,null,170]
[null,null,null,null,180]
[null,null,null,null,190]
[null,null,null,null,200]
[null,null,null,null,210]
[null,null,null,null,220]
[null,null,null,null,230]