Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Formula cell reference not change on delete rows or columns. #155

Open
TECNOLAN opened this issue Aug 13, 2018 · 5 comments
Open

Formula cell reference not change on delete rows or columns. #155

TECNOLAN opened this issue Aug 13, 2018 · 5 comments

Comments

@TECNOLAN
Copy link

TECNOLAN commented Aug 13, 2018

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

@jingwood
Copy link
Member

I think this is not implemented yet.

@TECNOLAN
Copy link
Author

Ok,

I will try to implement a procedure to do this.

Thanks you.
SBC

@ShamnaHussain
Copy link

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

@jingwood
Copy link
Member

@shihanapj There is a my work-in-progress version. There still some work to be finished.
#419

@ShamnaHussain
Copy link

ShamnaHussain commented Jun 23, 2021

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants