{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["銷售收據"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"銷售收據","index":0,"n_rows":49,"n_cols":7,"rows_kept":49,"merged":[[0,1,0,6],[2,0,2,2],[3,0,4,2],[6,1,6,2],[6,4,6,5],[7,1,7,2],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,0,11,5],[12,0,12,1],[12,2,12,3],[12,4,12,6],[13,0,13,1],[13,2,13,3],[13,4,13,6],[14,0,14,6],[15,2,15,3],[16,2,16,3],[17,2,17,3],[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,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,3,40,4],[45,0,45,6],[47,0,47,6],[50,1,50,4]]}
[null,"銷售收據"]
[]
["[公司名稱]",{"$nulls":4},"日期：",{"$f":"TODAY()","v":"2012-07-12"}]
[" [公司標語]",{"$nulls":4},"收據號碼：","[100]"]
[]
[]
["買受人：","[姓名]"]
[null,"[公司名稱]"]
[null,"[郵遞區號，縣/市]"]
[null,"[街道地址]"]
[null,"[電話]"]
[]
["付款方式",null,"支票號碼",null,"職稱"]
[]
[]
["數量","貨號","說明",null,"單價","折扣","項目合計"]
[{"$nulls":6},{"$f":"IF(SUM(A17)>0,SUM((A17*E17)-F17),\"\")","v":""}]
[{"$nulls":6},{"$f":"IF(SUM(A18)>0,SUM((A18*E18)-F18),\"\")","v":""}]
[{"$nulls":6},{"$f":"IF(SUM(A19)>0,SUM((A19*E19)-F19),\"\")","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":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":3},"折扣總計",null,{"$f":"IF(SUM(F17:F40)>0,SUM(F17:F40),\"\")","v":""}]
[{"$nulls":5},"小計",{"$f":"IF(SUM(G17:G40)>0,SUM(G17:G40),\"\")","v":""}]
[{"$nulls":5},"營業稅"]
[{"$nulls":5},"總計",{"$f":"IF(SUM(G42)>0,SUM((G42*G43)+G42),\"\")","v":""}]
[]
["感謝您的惠顧！"]
[]
["[郵遞區號，縣/市]，[街道地址]  [電話]  [傳真]  [電子郵件]"]
[{"$nulls":5},{"$f":"IF(SUM(F44)>0,SUM((F44*F45)+F44),\"\")","v":""}]