{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["开始日期","销售收据"],"not_rendered":{"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"开始日期","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"模板简介"]
[null,"利用此模板创建简单的销售收据。"]
[null,"请填写公司名称、付款方式、支票编号和买家详细信息。"]
[null,"在表中输入详细信息，之后将自动计算出总额。"]
[null,"注意： "]
[null,"销售收据工作表的 A 列中提供了额外说明。已故意隐藏此文本。若要删除文本，请选择 A 列，然后选择“删除”。若要取消隐藏文本，请选择 A 列，然后更改字体颜色。"]
[null,"若要了解有关表格的详细信息，请在表格内按 Shift + F10，选择“表格”选项，然后选择“替换文本”。"]

{"sheet":"销售收据","index":1,"n_rows":42,"n_cols":7,"rows_kept":42,"merged":[[1,1,1,2],[1,3,1,6],[2,1,2,4],[3,1,3,4],[4,2,4,3],[4,4,4,5],[5,2,5,3],[5,4,5,5],[6,2,6,3],[6,4,6,5],[7,2,7,3],[7,4,7,5],[8,2,8,3],[8,4,8,5],[9,1,9,2],[9,4,9,6],[10,1,10,2],[10,4,10,6],[40,1,40,6],[41,1,41,6],[44,2,44,4]]}
["在此工作表中创建销售收据。此列的单元格中显示有关如何使用此工作表的有用说明。请向下移动箭头开始了解。"]
["在右侧单元格中输入公司徽标。单元格 D2 中显示此工作表的标题。","徽标占位符位于此单元格中。",null,"销售收据"]
["在右侧单元格中输入公司名称，在单元格 G3 中输入日期。","你的公司名称",{"$nulls":3},"日期:",{"$f":"TODAY()","v":"2019-04-19"}]
["在右侧单元格中输入公司标语，在单元格 G4 中输入发票编号。"," 在此处键入公司标语",{"$nulls":3},"发票编号:","否"]
["右侧单元格中显示买家标签。在单元格 C5 至 C9 中输入姓名、公司名称、地址和电话号码等详细信息。下一条说明位于单元格 A10 中。","买家:","姓名"]
[null,null,"公司名称"]
[null,null,"省/市/自治区，市/县"]
[null,null,"街道地址 邮政编码 "]
[null,null,"电话"]
["右侧单元格中显示付款方式标签，D10 中显示支票编号标签，E10 中显示职务标签。","付款方式",null,"支票编号","职务"]
["在右侧单元格中输入付款方式，在单元格 D11 中输入支票编号，在 E11 中输入职务。下一条说明位于单元格 A13 中。"]
[]
["在收据表中从右侧单元格开始输入相关信息。自动计算总折扣、小计和汇总。下一条说明位于单元格 A41 中。","数量","商品编号","说明","单价","折扣","行合计"]
[{"$nulls":6},{"$f":"IF(SUM(B14)>0,SUM((B14*E14)-F14),\"\")","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":6},""]
[{"$nulls":4},"总折扣",{"$f":"IF(SUM(F15:F36)>0,SUM(F15:F36),\"\")","v":""}]
[{"$nulls":5},"小计",{"$f":"IF(SUM(G15:G36)>0,SUM(G15:G36),\"\")","v":""}]
[{"$nulls":5},"销售税"]
[null," ",{"$nulls":3},"汇总",{"$f":"IF(SUM(G38)>0,SUM((G38*G39)+G38),\"\")","v":""}]
["右侧单元格显示“感谢你”消息。","谢谢惠顾！"]
["在右侧单元格中输入公司所在省/直辖市/自治区、市/县、街道地址、邮政编码、电话传真号码和电子邮件地址。","省/市/自治区，市/县，街道地址  邮政编码  电话  传真  电子邮件"]