Incident Report

使用している商用Excelライブラリでバグがあり、ベンダに対して改善を要求しました。


An  attached excel behavior shows expected behavior. 

Wrong formula calculation occurs in wrong.xlsx

No wrong formula calculations have been seen in correct.xlsx.

The difference between two excel files are as follows

wrong  E5 cell:=IF(D5<>"",IF(D5+1<=$C$2,D5+1,""),"") 

correct E5 cell:=IF(D5<>"",IF($D$5+COLUMN()-COLUMN($D$5)<=$C$2,$D$5+COLUMN()-COLUMN($D$5),""),"")

Apparent wrong calculation starts from AM5 cell in wrong.xlsx

Please note it should result identical results between two excels though they have different formula.

It seems incremental rather deep formula reference causes the wrong calculation.