Is the following possible with SpreadsheetGear? I have a spreadsheet where cell A1 has a formula =C1 + C2 and cell A2 has a formula =SUM(C1:C2). In cell C1 there is a value of 200 and in cell C2 there is a value of 300. So cells A1 and A2 will have a value
of 500. Now if I delete column B the formulas are changed to =B1 + B2 and =SUM(B1:B2) respectively. However if I delete column C instead of column B the formulas become =#REF! +#REF! and =SUM(#REF!). Instead of doing this when column C is deleted is there
anyway of automatically recalculating the formula values before column C is actually deleted? That is cells A1 and A2 would have a value of 500 and not have a formula anymore. I need this to be automatic because the spreadsheets I am working with have lots
of formulas that could be dependent on any given deleted column. The SpreadsheetGear tool is smart enough to add #REF! to all formulas that are dependent on the deleted column. Is it smar ...
Go to the complete details ...