Table formulas disappear in new drawing from template (BUG?)
Posted: Thu Oct 05, 2023 7:52 pm
Created a template (icad.dwt) that contains a table. For sake of discussion, lets say A1 is a quantity to be updated in the table. B1 is a fixed price. C1 is a formula written in the cell as "=A1*B1".
After initially building the table in the dwt file, I tested it and cell C1 appropriately updates as a new total price when Cell A1 number is changed.
Saved template file.
Create new drawing from template.
File opens and I initially see the value sitting in C1 as it should be, but as soon as I change the number in cell A1, the entire contents of C1 disappears.
The formula is gone. Where did it go? I suspect it has something to do with locking or not locking the formatting of the cells, but I can't seem to come up with any solution that lasts as a template that is then used to make a dwg from template.
Furthermore, one would think that I should be able to open the original template file (icad.dwt) to tweak the cell lock information, but if I open the template file, the same thing happen. As soon as I go to change anything in the table, the formula disappears.
After initially building the table in the dwt file, I tested it and cell C1 appropriately updates as a new total price when Cell A1 number is changed.
Saved template file.
Create new drawing from template.
File opens and I initially see the value sitting in C1 as it should be, but as soon as I change the number in cell A1, the entire contents of C1 disappears.
The formula is gone. Where did it go? I suspect it has something to do with locking or not locking the formatting of the cells, but I can't seem to come up with any solution that lasts as a template that is then used to make a dwg from template.
Furthermore, one would think that I should be able to open the original template file (icad.dwt) to tweak the cell lock information, but if I open the template file, the same thing happen. As soon as I go to change anything in the table, the formula disappears.