{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","liste","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1],[3,0,3,1],[17,0,19,6],[7,0,7,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[13,2,13,3],[9,5,9,6],[10,4,10,6],[11,1,11,6],[13,5,13,6]]}
["Adresse de livraison",null,null," Adresse de facturation"]
["Nom",null,null,"Nom"]
["N° client de livraison : xxx",null,null,"N° client de facturation : xxx"]
["RUE  ",null,null,"RUE"]
["BP ",null,null,"BP "]
["Ville ",null,null,"Ville"]
["Tel.: ",null,null,"Tel.: "]
["Fax: ",null,null,"Fax: "]
[]
["Bon de Commande"]
["Fournisseur","xxx"]
["N° client ",111111]
["Tel. / Fax ","xxxxxxxx / xxxxxxx"]
["Référence ",null,"émise par "]
["Date "]
["Service(s) concerné(s) ","xxxxxxxx / xxxxxxx"]
[]
["Commentaire :"]
[]
[]
[]
[]
["Nom","Ref","Cdt","Tarif","Qté","Prix HT","Prix TTC"]
["a","aA1","x50",2504,null,{"$f":"E24*D24","v":0},{"$f":"F24*1.2","v":0}]
["b","aA2","x10",2.5,null,0,{"$f":"F25*1.2","v":0}]
["c","aA3","x10",4.2,null,0,0]
["d","aA4","x1",3.4,null,0,0]
["e","aA5","x2",2.4,null,0,0]
["g","aA6","x3",3.2,null,0,0]
["h","aA7","x4",1,null,{"$f":"E30*D30","v":0},0]
["i","aA8","x5",10,null,0,0]
["j","aA9","x6",2.5,null,0,0]
["k","aA10","x7",4.2,null,0,0]
["l","aA11","x8",3.4,null,0,0]
["m","aA12","x9",2.4,null,0,0]
["n","aA13","x10",3.2,null,0,0]
["o","aA14","x11",2,null,0,0]
["p","aA15","x12",4,null,0,0]
["q","aA16","x13",4,null,0,0]
["r","aA17","x14",4,null,0,0]
[null,null,null,null,1]
[null,null,null,null,"Total ht Produit",null,{"$f":"SUM(F24:F40)","v":0},null,"Calcul des frais de port"]
[null,null,null,null,"TVA 20%",null,{"$f":"G42*0.2","v":0},null,0,69]
[null,null,null,null,"Frais de port HT",null,{"$f":"IF(G42>=I45,J45,IF(G42>=I44,J44,IF(G42>I43,J43,IF(G42=I43,J45))))","v":0},null,100,30]
[null,null,null,null,"TVA frais de port",null,{"$f":"G44*1.2","v":0},null,200,0]
[null,null,null,null,"TVA totale",null,{"$f":"G45+G43","v":0}]
[null,null,null,null,"Total TTC",null,{"$f":"G42+G46","v":0}]
[null,null,null,null,1]
[null,null,null,null,1]
[null,null,null,null,1]

{"sheet":"liste","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Demandeur"]
["Pierre"]
["Paul "]
["Jacques"]

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}