{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BOUCLE","PAYS EUROPE","CdC"],"not_rendered":{"charts":0,"images":4,"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":"BOUCLE","index":0,"n_rows":29,"n_cols":24,"rows_kept":29,"cut":false,"hidden":false,"merged":[[12,1,12,10],[6,2,6,3],[6,8,6,9],[8,2,8,3],[8,8,8,9],[11,5,11,7]]}
[]
[]
[]
[]
[]
[]
[null,null,"Vérif. TVA France 19.6% :",null,null,null,null,null,"Vérif. TVA France 20% :"]
[]
[null,null,"Vérif. TVA Intra 19.6% :",null,null,null,null,null,"Vérif. TVA Intra 20% :"]
[]
[]
["Pays","Code T","Date","C.J","N° Pièce","Libellé écriture",null,null,"Mvts D","Mvts C","Solde",null,null,"Débit","Exo","Intra 19.6","Intra 20","HT 19.6","HT 20","TVA 19.6","TVA 20","TTC","TVA Intra 19.6","TVA Intra 20"]
[null,"Grand livre général (Fournisseurs)"]
[]
[null,"HELLO","2015-01-01","RAN","162","XXXXXX",null,null,null,84.9,84.9,null,null,84.9]
[null,"HELLO","2015-01-01","RAN","V101201400434","XXXXXX",null,null,null,8.9,8.9,null,null,8.9]
[null,"HELLO","2015-01-16","ACH","39","XXXXXX",null,null,null,35.299999999999997,35.299999999999997]
[null,"HELLO","2015-01-17","ACH","46","XXXXXX",null,null,null,14.4,14.4]
[null,"HELLO","2015-03-05","RAN","116","XXXXXX",null,null,null,4.5999999999999996,4.5999999999999996,null,null,4.5999999999999996]
[null,"HELLO","2015-03-12","RAN","135","XXXXXX",null,null,null,8,8,null,null,8]
[null,"HELLO","2015-05-29","ACH","01147729","XXXXXX",null,null,null,58.01,58.01]
[null,"DOLY","2015-05-31","ACH","01147730","XXXXXX",null,null,null,52.76,52.76]
[null,"DOLY","2015-06-02","RAN","01147724","XXXXXX",null,null,null,106.32,106.32]
[null,"HELLO","2015-06-04","RAN","01147727","XXXXXX",null,null,null,47.9,47.9,null,null,47.9]
[null,"HELLO","2015-06-04","ACH","01147731","XXXXXX",null,null,null,15.19,15.19]
[null,"HELLO","2015-06-04","ACH","01147732","XXXXXX",null,null,null,32.479999999999997,32.479999999999997]
[null,"HELLO","2015-06-12","ACH","01147738","XXXXXX",null,null,null,112.59,112.59]
[null,"DOLY","2015-06-16","ACH","01147756","XXXXXX",null,null,null,928,928]
[null,"DOLY","2015-06-17","RAN","01147740","XXXXXX",null,null,null,45,45]

{"sheet":"PAYS EUROPE","index":1,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["ALLEMAGNE"]
["AUTRICHE"]
["BELGIQUE"]
["BULGARIE"]
["CHYPRE"]
["CROATIE"]
["DANEMARK"]
["ESPAGNE"]
["ESTONIE"]
["FINLANDE"]
["FRANCE"]
["GRECE"]
["HONGRIE"]
["IRLANDE"]
["IRELAND"]
["ITALIE"]
["LETTONIE"]
["LITUANIE"]
["LUXEMBOURG"]
["MALTE"]
["PAYS BAS"]
["PAYS-BAS"]
["POLOGNE"]
["PORTUGAL"]
["REPUBLIQUE TCHEQUE"]
["TCHEQUIE"]
["ROUMANIE"]
["ROYAUME UNI"]
["ROYAUME-UNI"]
["ANGLETERRE"]
["SLOVAQUIE"]
["SLOVENIE"]
["SUEDE"]
["GRANDE BRETAGNE"]
["GRANDE-BRETAGNE"]
["LA REPUBLIQUE TCHEQUE"]

{"sheet":"CdC","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"Il reste encore des problèmes dans ce code. Lorsque je répond \"non\" à la deuxième MsgBox, je souhaiterais que le contenu des cellules s'effacent. En effet, si je retourne au tiers précédent pour pouvoir changer de choix, imaginons que j'ai répondu OUI la première fois, il faut que la seconde je puisse répondre NON et que ce qui s'était rempli la première fois s'efface."]
[]
[null,null,null,"De plus, lorsque je répond \"OUI\" à la MsgBox, rien ne se passe."]
[]
[]
[null,null,null,"OK donc là ça marche parfaitement à un détail près. Comme je le disais, lorsque je reviens en arrière au tiers précédent et que je répond \"NON\" à la MsgBox, il faut que toutes les lignes avec ce tiers là s'effacent. Et pas seulement la première ligne."]