主题：关于明细列的自动添加问题

明细表函数受限，用关联表啊。

呵呵，能解决也是绕了一大圈，建议采用关联表。

以后使用中你会发现，今天的改动是很值得的，再则说建一个关联表进行关联只是几分钟的事。

仅供参考。

呵呵，代价太大了。
个人认为这种方式不可取，只有三行数据重算一下都这么耗时间，如果数据量大，还不晕死。

如果一定要用明细列,教你一个最笨的也是最好的办法,此办法和一般的刷新公式无异,不会导致效率降低.

生产单号列刷新公式:

Substitute(Substitute(Substitute(SubCell("量",1,1)+","+SubCell("量",2,1)+","+SubCell("量",3,1)+","+SubCell("量",4,1)+","+SubCell("量",5,1)+","+SubCell("量",6,1)+","+SubCell("量",7,1)+","+SubCell("量",8,1)+","+SubCell("量",9,1)+","+SubCell("量",10,1)+","+SubCell("量",11,1)+","+SubCell("量",12,1)+","+SubCell("量",13,1)+","+SubCell("量",14,1)+","+SubCell("量",15,1)+","+SubCell("量",16,1)+","+SubCell("量",17,1)+","+SubCell("量",18,1)+","+SubCell("量",19,1)+","+SubCell("量",4,1)+","+SubCell("量",5,1)+","+SubCell("量",6,1)+","+SubCell("量",20,1)+","+SubCell("量",21,1),",,,,",""),",,,",""),",,","")

具体用多少个SubCell相加,可根据自己的实际情况而定,多写些也无所谓.