{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["開始","銷售發票"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"關於此範本"]
[null,"使用此範本以簡單的線條設計建立銷售發票。"]
[null,"填入基本資訊，例如公司名稱、付款人和收貨人詳細資料。"]
[null,"在表格中輸入詳細資料。"]
[null,"系統會為您自動計算總計。"]
[null,"附註： "]
[null,"[銷售發票] 工作表的欄 A 中提供其他指示。此文字已刻意隱藏。若要移除文字，請選取欄 A，然後選取 [刪除]。若要取消隱藏文字，請選取 A 欄，然後變更字型色彩。"]
[null,"若要深入了解表格，請在表格內按 SHIFT 並按 F10，選取 [表格] 選項，然後選取 [替代文字]。"]

{"sheet":"銷售發票","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"merged":[[1,1,1,2],[1,3,1,7],[2,1,2,3],[3,1,3,3],[5,2,5,3],[5,5,5,6],[6,2,6,3],[6,5,6,6],[7,2,7,3],[7,5,7,6],[8,2,8,3],[8,5,8,6],[9,2,9,3],[9,5,9,6],[13,1,13,7],[39,1,39,7],[40,1,40,4],[40,5,40,7],[41,1,41,7],[42,1,42,7]]}
["在此工作表中建立銷售發票。此欄的儲存格為如何使用此工作表的實用指示。按向下鍵就能開始使用。"]
["在右側儲存格中輸入公司標誌。儲存格 D2 中為本工作表的標題。","此儲存格為標誌預留位置。",null,"發票"]
["在右側儲存格中輸入公司名稱，並在儲存格 H3 中輸入日期。","貴公司名稱",{"$nulls":4},"日期：",{"$f":"TODAY()","v":"2019-04-19"}]
["在右側儲存格中輸入公司標語，並在儲存格 H4 中輸入發票號碼。"," 在這裡輸入貴公司的標語",{"$nulls":4},"發票號碼：","編號"]
["在 H5 儲存格中輸入客戶識別碼。",{"$nulls":5},"客戶識別碼：","識別碼"]
["右側儲存格為 [收件者] 標籤，儲存格 E6 為 [收貨人] 標籤。在儲存格 C6 至 C10 中輸入付款人詳細資料，例如姓名、公司名稱、地址和電話號碼，儲存格 F6 至 F10 則輸入收貨人詳亦資料。下一個指示在儲存格 A12。","收件者：","姓名",null,"收貨人：","姓名"]
[null,null,"公司名稱",null,null,"公司名稱"]
[null,null,"街道地址",null,null,"街道地址"]
[null,null,"郵遞區號，縣/市",null,null,"郵遞區號，縣/市"]
[null,null,"電話",null,null,"電話"]
[]
["在從右側儲存格開始的 [銷售資訊] 表格中輸入資訊。下一個指示位於儲存格 A15。","銷售人員","職稱","運送方式","運送規定","遞送日期","付款條件","付款期限"]
[]
[]
["在從右側儲存格開始的 [發票] 表格中輸入資訊。總折扣、小計和合計會自動計算。下一個指示位於儲存格 A41。","數量","項目編號","描述","自訂欄位","單價","折扣","項目合計"]
[{"$nulls":7},{"$f":"IF(SUM(B16)>0,SUM((B16*F16)-G16),\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(SUM(B17)>0,SUM((B17*F17)-G17),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},{"$f":"IF(SUM(B22)>0,SUM((B22*F22)-G22),\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(SUM(B23)>0,SUM((B23*F23)-G23),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":5},"總折扣",{"$f":"IF(SUM(G16:G35)>0,SUM(G16:G35),\"\")","v":""}]
[{"$nulls":6},"小計",{"$f":"IF(SUM(H16:H35)>0,SUM(H16:H35),\"\")","v":""}]
[{"$nulls":6},"營業稅"]
[{"$nulls":6},"合計",{"$f":"IF(SUM(H37)>0,SUM((H37*H38)+H37),\"\")","v":""}]
[]
["工作表會自動更新儲存格 F41 中的公司名稱。","支票抬頭請一律填寫 ",{"$nulls":3},{"$f":"B3","v":"貴公司名稱"}]
["右側儲存格是感謝訊息。","感謝您的惠顧！"]
["在右側儲存格中輸入公司街道地址、縣/市、郵遞區號、電話和傳真號碼，以及電子郵件地址。","郵遞區號，縣/市，街道地址、電話、傳真、電子郵件"]