多级编号的公式，复制粘贴会自动更新

把相应的公式复制粘贴即可实现；

a1=IF(ISERROR(VALUE(SUBSTITUTE(Sheet1!prevWBS,".",""))),"1",IF(ISERROR(FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",1))),TEXT(VALUE(Sheet1!prevWBS)+1,"#"),TEXT(VALUE(LEFT(Sheet1!prevWBS,FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",1))-1))+1,"#")))

a2=IF(ISERROR(VALUE(SUBSTITUTE(Sheet1!prevWBS,".",""))),"0.1",IF(ISERROR(FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",1))),Sheet1!prevWBS&".1",LEFT(Sheet1!prevWBS,FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",1)))&IF(ISERROR(FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",2))),VALUE(RIGHT(Sheet1!prevWBS,LEN(Sheet1!prevWBS)-FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",1))))+1,VALUE(MID(Sheet1!prevWBS,FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",1))+1,(FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",2))-FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",1))-1)))+1)))

a3=IF(ISERROR(VALUE(SUBSTITUTE(Sheet1!prevWBS,".",""))),"0.0.1",IF(ISERROR(FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",2))),Sheet1!prevWBS&".1",LEFT(Sheet1!prevWBS,FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",2)))&IF(ISERROR(FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",3))),VALUE(RIGHT(Sheet1!prevWBS,LEN(Sheet1!prevWBS)-FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",2))))+1,VALUE(MID(Sheet1!prevWBS,FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",2))+1,(FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",3))-FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",2))-1)))+1)))

a4=IF(ISERROR(VALUE(SUBSTITUTE(Sheet1!prevWBS,".",""))),"0.0.0.1",IF(ISERROR(FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",3))),Sheet1!prevWBS&".1",LEFT(Sheet1!prevWBS,FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",3)))&IF(ISERROR(FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",4))),VALUE(RIGHT(Sheet1!prevWBS,LEN(Sheet1!prevWBS)-FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",3))))+1,VALUE(MID(Sheet1!prevWBS,FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",3))+1,(FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",4))-FIND("`",SUBSTITUTE(Sheet1!prevWBS,".","`",3))-1)))+1)))