ReoGrid icon indicating copy to clipboard operation
ReoGrid copied to clipboard

Published 20 hours ago • verified publisher icon unvell

Formula cell reference not change on delete rows or columns.

Open TECNOLAN opened this issue 7 years ago • 5 comments

I have created a small worksheet on Editor. I have referenced a sum formula for a column. When I delete some rows, cell formula reference not updated.

I have read same issue in forum, but I have not found then solution. Is ther any way to solution this problem.

The platform used is Windows Forms

Recgards. SBC

TECNOLAN avatar Aug 13 '18 09:08 TECNOLAN

I think this is not implemented yet.

jingwood avatar Aug 13 '18 10:08 jingwood

Ok,

I will try to implement a procedure to do this.

Thanks you. SBC

TECNOLAN avatar Aug 13 '18 14:08 TECNOLAN

Currently we are trying to implement this feature, has anyone already implemented auto updation of formula on Row/column insert and delete?

ShamnaHussain avatar Jun 17 '21 13:06 ShamnaHussain

@shihanapj There is a my work-in-progress version. There still some work to be finished. https://github.com/unvell/ReoGrid/pull/419

jingwood avatar Jun 19 '21 02:06 jingwood

Thats a great news and thanks for the reply Jing. Tried the #419 version and could see update on delete rows is implemented currently.

In that, changes happens only with relative addresses.

Will the absolute addresses also be considered in upcoming days?

ShamnaHussain avatar Jun 23 '21 10:06 ShamnaHussain