[BUG] 关闭文件重新打开,公式的变量会被添加 _xlpm. 前缀
💡 | =IFERROR(LET(rg,OFFSET(TRIMRANGE(C:C),1,),f,LAMBDA(f,[i],[s],[out],LET(i,i+1,v,INDEX(rg,i),s,IF(ISNUMBER(v),N(s)+v,s),newS,IF(ISNUMBER(v),s,""),out,IF(AND(newS="",ISNUMBER(s)),VSTACK(DROP(out,-1),s,""),VSTACK(out,"")),IF(i<ROWS(rg),f(f,i,newS,out),out))),DROP(DROP(f(f,0,"",""),1),-1)),"") |
把以上公式保存到文件,然后关闭文件,重新打开,公式会变成:
💡 | =IFERROR(LET(rg,OFFSET(TRIMRANGE(C:C),1,),f,LAMBDA(f,[i],[s],[out],LET(i,i+1,v,INDEX(rg,i),s,IF(ISNUMBER(v),N(_xlpm.s)+v,_xlpm.s),newS,IF(ISNUMBER(v),s,""),out,IF(AND(newS="",ISNUMBER(s)),VSTACK(DROP(_xlpm.out,-1),s,""),VSTACK(_xlpm.out,"")),IF(i<ROWS(rg),f(f,i,newS,out),out))),DROP(DROP(f(f,0,"",""),1),-1)),"") |
导致公式无法正常计算。
WPS 版本: Windows 12.1.0.20784
@金山办公
创作者俱乐部成员