API Access to Column Formulas
I have been trying to understand how to handle column formulas and all I can see is that you have error messages to let us know that we can modify cells in columns with column formulas but there is no column attribute to indicate that a column formula is present via the API.
Also, when a column formula is present, it is only displayed as an attribute of each cell within that column as opposed to belonging to the column object itself.
The only thing I believe I can reasonably do is copy the column data, delete the column, recreate a new column and then change values thereafter. But this is not ideal given corollary effects of this approach.
Is there any plans to add Column Formulas to the API in the near future?