CODEWITHSUNDEEP

Reputation: 549

phpExcel insertNewRowBefore does not correctly update the Cell IDs in the formulas

Also filed an issue on https://github.com/PHPOffice/PHPExcel/issues/275

Repro:

1) Fill, for instance, cells A1,B2,C1,C2,C4 with arbitrary values

2) Set C3=A1*B2*C1*C2*C4

3) Call insertNewRowBefore(1,1) and observe that the formula is corrupted: =A2*B3*C3*C3*C5 instead of A2*B3*C3*C4*C5

Upvotes: 0

Views: 910

Answers (2)

Mark Baker

Reputation: 212412

Believe fixed in the latest develop branch on github

Upvotes: 1

Mark Baker

Reputation: 212412

Please try with the latest develop branch from github: this is a known issue that has been reported already and should be fixed

Upvotes: 0

Related Questions