Incorrect Column formula update while adding the new column

[conx]

Case 1:
I have a excel grid A to E, i added formula on column D as =SUM(A3+C3), now when i add new column in between A and B , the formula cell D is shifted to E and formula on it is changed to =SUM(B3+D3), which should have been =sum(A3+D3), can anyone suggest the solution,
Case 2:: i have A to E excel grid and formula cell is on E as =sum(A1+C1), now when i add column after C, then again the formula cell(E) shifted to F and formula changes to =sum(B1+D1) which should not have been changed as new column was added after the cells used on formula
(Seems like its same on demo examples as well, isnt that wrong?)

[paramvir]

Yes you are right, shifting of formulas is not perfect when columns are inserted in between formula columns.

It would be corrected / improved upon in upcoming versions.