{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Facture de vente"],"not_rendered":{"images":4,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Facture de vente","index":0,"n_rows":40,"n_cols":7,"rows_kept":40,"merged":[[1,0,1,1],[1,2,1,5],[2,0,2,1],[2,2,2,5],[3,0,3,6],[4,0,4,1],[4,4,4,5],[5,0,5,1],[5,4,5,5],[6,0,6,1],[6,2,6,3],[6,4,6,5],[7,0,7,1],[7,2,7,3],[8,0,8,6],[9,0,9,6],[10,1,10,2],[10,4,10,5],[11,1,11,2],[11,4,11,5],[12,1,12,2],[12,4,12,5],[13,1,13,2],[13,4,13,5],[14,1,14,2],[14,4,14,5],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,3,36,4],[37,0,39,4],[43,1,43,4]]}
[]
[]
[]
[]
["[Rue]",null,null,"N° DE FACTURE","[100]"]
["[Code postal, Ville]",null,null,"DATE",{"$f":"TODAY()","v":"2019-07-01"}]
["[Téléphone] [Télécopie]",null,"RÉF CLIENT",null,"[ABC12345]"]
["[Courriel] "]
[]
[]
["À","[Nom]",null,"DESTINATAIRE DE L’EXPÉDITION","[Nom]"]
[null,"[Nom de l’entreprise]",null,null,"[Nom de l’entreprise]"]
[null,"[Rue]",null,null,"[Rue]"]
[null,"[Code postal, Ville]",null,null,"[Code postal, Ville]"]
[null,"[Téléphone]",null,null,"[Téléphone]"]
[]
["VENDEUR","POSTE","FRAIS D’EXPÉDITION \nMÉTHODE","FRAIS D’EXPÉDITION \nCONDITIONS","LIVRAISON \nDATE","PAIEMENT \nCONDITIONS","DATE D’ÉCHÉANCE"]
[]
["QTÉ","N° ÉLÉMENT","DESCRIPTION",null,"PRIX UNITAIRE","REMISE","TOTAL LIGNE"]
[{"$nulls":6},{"$f":"IF(SUM(A20)>0,SUM((A20*E20)-F20),\"\")","v":""}]
[{"$nulls":6},{"$f":"IF(SUM(A21)>0,SUM((A21*E21)-F21),\"\")","v":""}]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":3},"REMISE TOTALE",null,{"$f":"IF(SUM(F20:F36)>0,SUM(F20:F36),\"\")","v":""}]
[{"$nulls":5},"SOUS-TOTAL",{"$f":"IF(SUM(G20:G36)>0,SUM(G20:G36),\"\")","v":""}]
[{"$nulls":5},"TVA"]
[{"$nulls":5},"TOTAL",{"$f":"IF(SUM(G38)>0,SUM((G38*G39)+G38),\"\")","v":""}]