I have a spreadsheet that has a single worksheet with several blocks of cells formatted and with a few formulas added. At runtime, I open this spreadsheet, make as many new sheets as required by copying the original sheet, and then populate the new sheets with data.
Within my first sheet, I use the formula AVEDEV (e.g., the cell's content is "=AVEDEV(U4:U6)"). However, after I perform the worksheet copy, the cell's content is "=U4:U6". It appears that the "AVEDEV" formula is not getting copied.
Is this not supported?