clonerow() and cell(row,"序号")=cell(Row-1,"序号")+1 and cell(row,"销售_订单编号")="" and cell(row,"销售_送货单编号")="" and cell(row,"销售_客户入库单")="" and cell(row,"销售_出票日期")="" and cell(row,"销售_发票号码")="" and cell(row,"销售_回款日期")="" and cell(row,"销售_交付日期")="" and cell(row,"销售_数量")=0 and cell(row,"购进_购进日期")="" and cell(row,"购进_数量")=0 and cell(row,"购进_进票日期")="" and cell(row,"购进_发票号")="" and cell(row,"购进_付款日期")=""
这个公式,只被执行了“clonerow() and cell(row,"序号")=cell(Row-1,"序号")+1”这一段,后面的都没被执行,是怎么回事呢?该怎么办呢?
(文件请见附件,是录入窗口“交易信息”里的“复制行”按钮的公式)
谢谢
clonerow() and SetCellText(GridName,Row,"销售_订单编号","") and SetCellText(GridName,Row,"销售_送货单编号","") and 。。。
cell只是取值,不能赋值
序号列已经设置了默认值公式,会自动增加序号,不需要另外设置公式了