Find formula string in acad table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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