Find formula string in acad table

Find formula string in acad table

Anonymous
Not applicable
668 Views
0 Replies
Message 1 of 1

Find formula string in acad table

Anonymous
Not applicable

Hello,

 

I am trying to make schedules based on blocks. And I want total in the columns, which are fields.

What I have learnt is that I can not use SUM function for field values. I have attached a file in which SUM of field

is #### in electrical schedule. But in window schedule I can use SUM function in area and perimeter columns of fields. I dont know what is the difference between them.

 

So =SUM(C3:C4) does not work, but =C3+C4 works. Another way I came up is to insert a string "=C3+C4". This is not preferable but workable. The problem is that if I delete a row, formula gets ##..

 

Getcell value gets final value. What I want to do is find formula string and remove "ERR+" from it. so I can have 

new clean foemula. There are so many properties of table. I tried many but could not get anything. There is getformula method which I cant see in Autocad 2007, which I am using.

 

Any help is appreciated.

regards

 

 

0 Likes
669 Views
0 Replies
Replies (0)