{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":94,"n_cols":7,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Couleur","Gras"]
["ARTICLE INCONNU",null,"ARTICLE INCONNU",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 6",null,"Qté: 6",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[19.75,null,19.75,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["DANETTE CHOCOLAT 4X125G",null,"DANETTE CHOCOLAT 4X125G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 2",null,"Qté: 2",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[2.79,null,2.79,null,{"$f":"Lire_couleur_police","v":38},{"$f":"Lire_Caractere_Gras","v":true}]
[3.72,null,3.72,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["DANETTE EXTRA NOIR 4X125G",null,"DANETTE EXTRA NOIR 4X125G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[1.86,null,1.86,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["NESQUIK BOITE 250G",null,"NESQUIK BOITE 250G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[2.15,null,2.15,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["ST MICHEL GALETTE GOURM CHOC 121G",null,"ST MICHEL GALETTE GOURM CHOC 121G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 4",null,"Qté: 4",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[6.28,null,6.28,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["HOT-DOG KETCHUP CHARAL 120 G X 1",null,"HOT-DOG KETCHUP CHARAL 120 G X 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 2",null,"Qté: 2",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[5.98,null,5.98,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["EMMENTAL RAPE CO 29%MG100G",null,"EMMENTAL RAPE CO 29%MG100G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 2",null,"Qté: 2",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[2.48,null,2.48,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["Carte+ 0,12",null,0.12,null,{"$f":"Lire_couleur_police","v":38},{"$f":"Lire_Caractere_Gras","v":true}]
["EAU MONTAGNE 6X150CL CO",null,"EAU MONTAGNE 6X150CL CO",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[2.66,null,2.66,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["Carte+ 0,14",null,0.14000000000000001,null,{"$f":"Lire_couleur_police","v":38},{"$f":"Lire_Caractere_Gras","v":true}]
["MINI PATE CROUTE COCKT.CO 450G",null,"MINI PATE CROUTE COCKT.CO 450G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[3.52,null,3.52,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["Carte+ 0,18",null,0.18,null,{"$f":"Lire_couleur_police","v":38},{"$f":"Lire_Caractere_Gras","v":true}]
["CHICKEN WINGS NATURE CO 250G",null,"CHICKEN WINGS NATURE CO 250G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[2.72,null,2.72,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["Carte+ 0,13",null,0.13,null,{"$f":"Lire_couleur_police","v":38},{"$f":"Lire_Caractere_Gras","v":true}]
["JBON SS ANTIBIO DD 2 TR 80G CO",null,"JBON SS ANTIBIO DD 2 TR 80G CO",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 3",null,"Qté: 3",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[7.71,null,7.71,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["Carte+ 0,38",null,0.38,null,{"$f":"Lire_couleur_police","v":38},{"$f":"Lire_Caractere_Gras","v":true}]
["JBON SS ANTIBIO DD 4 TR 160G",null,"JBON SS ANTIBIO DD 4 TR 160G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 2",null,"Qté: 2",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[7.42,null,7.42,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["Carte+ 0,37",null,0.37,null,{"$f":"Lire_couleur_police","v":38},{"$f":"Lire_Caractere_Gras","v":true}]
["STEAK HACHE 15MG 2X100G VBF CO",null,"STEAK HACHE 15MG 2X100G VBF CO",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 2",null,"Qté: 2",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[6.2,null,6.2,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["Carte+ 0,31",null,0.31,null,{"$f":"Lire_couleur_police","v":38},{"$f":"Lire_Caractere_Gras","v":true}]
["OEUFS X6 SOL TRES GROS CO",null,"OEUFS X6 SOL TRES GROS CO",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[1.49,null,1.49,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["Carte+ 0,08",null,0.08,null,{"$f":"Lire_couleur_police","v":38},{"$f":"Lire_Caractere_Gras","v":true}]
["CHARAL STEAK P.B 15%MGX10 1KG",null,"CHARAL STEAK P.B 15%MGX10 1KG",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[10.97,null,10.97,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["100% MIE LC 325G",null,"100% MIE LC 325G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[2.79,null,2.79,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["CURLY CACAHUETE 100G",null,"CURLY CACAHUETE 100G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[1.49,null,1.49,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["ARTICLE INCONNU",null,"ARTICLE INCONNU",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[2.5499999999999998,null,2.5499999999999998,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["PR COPPA 80G",null,"PR COPPA 80G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[2.5,null,2.5,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["LONG NUGGETS POULET NATURE 200 G",null,"LONG NUGGETS POULET NATURE 200 G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[3.42,null,3.42,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["TLJ MOUCHOIR BLANC 2PLIS X150",null,"TLJ MOUCHOIR BLANC 2PLIS X150",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 1",null,"Qté: 1",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[0.89,null,0.89,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["CHIPS ALLUMETTES 250GR",null,"CHIPS ALLUMETTES 250GR",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 2",null,"Qté: 2",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[7.58,null,7.58,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["KINDER MOUL TRAINEAU 75G",null,"KINDER MOUL TRAINEAU 75G",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
["Qté: 3",null,"Qté: 3",null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":false}]
[11.97,null,11.97,null,{"$f":"Lire_couleur_police","v":56},{"$f":"Lire_Caractere_Gras","v":true}]
["Total avant remise(s)",null,"Total avant remise(s)"]
[118.1,null,118.1]
["Total des remises produits",null,"Total des remises produits"]
[-1.71,null,-1.71]
["Total remise(s)",null,"Total remise(s)"]
[-0.93,null,-0.93]
["Total",null,"Total"]
[117.17,null,117.17]
["TVA 5,5%",null,"TVA 5,5%"]
[]
["Montants caractère rouge","macro Excel 4",{"$f":"SUMIF($E$2:$E$79,\"38\",$C$2:$C$79)","v":4.5}]
["Montants caractères noirs et gras","macro Excel 4",{"$f":"SUMIFS($C$2:$C$79,$E$2:$E$79,\"56\",$F$2:$F$79,\"VRAI\")","v":114.38}]
[]
["Montants caractère rouge","macro h2so4",{"$f":"somcolfont($C$2:$C$79,C7)","v":4.5},null,null,null,"Calculer somme en fonction couleur texte"]
["Montants caractères noirs et gras","macro h2so4 + jpr73",{"$f":"somcolfontbold($C$2:$C$79,C4)","v":114.38}]