Good day!
Please tell me a function that allows you to get the cell formula (macro, table)
Macros. Table. function to get the cell formula

 Posts: 3
 Joined: Tue Jun 23, 2020 1:48 am
Re: Macros. Table. function to get the cell formula
Hello OIZhivaeva,
Could you please describe in more details the function you require? Please describe the usage scenario.
Could you please describe in more details the function you require? Please describe the usage scenario.

 Posts: 3
 Joined: Tue Jun 23, 2020 1:48 am
Re: Macros. Table. function to get the cell formula
Good day!
For example, on Sheet "Sheet1" to cell C2, there is the formula eomonth (A2, 6) , I want to go through macros for all cells , if the formula contains eomonrh (..., 6), then replace it with eomonrh (..., 12 )
I know how to get the cell value (03/31/2019), but how do I get the formula for cell C2?
Let oworksheet=api.getsheet("Sheet1")
Let svaluecell= oworksheet.GetRange("C2").GetValue();
Let sformulacell=oworksheet.GetRange("C2").????????
For example, on Sheet "Sheet1" to cell C2, there is the formula eomonth (A2, 6) , I want to go through macros for all cells , if the formula contains eomonrh (..., 6), then replace it with eomonrh (..., 12 )
I know how to get the cell value (03/31/2019), but how do I get the formula for cell C2?
Let oworksheet=api.getsheet("Sheet1")
Let svaluecell= oworksheet.GetRange("C2").GetValue();
Let sformulacell=oworksheet.GetRange("C2").????????

 Posts: 3
 Joined: Tue Jun 23, 2020 1:48 am
Re: Macros. Table. function to get the cell formula
Good day!
For example, on Sheet "Sheet1" to cell C2, there is the eomonth (A2, 6) formula, I want to go through the macro in the cells I need, if the formula contains eomonrh (..., 6), then replace it with eomonrh (..., 12 )
I know how to get the cell value (03/31/2019), but how do I get the formula for this cell?(eomonth (A2, 6) )
Let oworksheet=api.getsheet("Sheet1");
Let scellvalue=oworksheet.Getrange("C2").GetValue();
Let scellformula=oworksheet.Getrange("C2").?????
What function i must use , so that scellformula='(eomonth (A2, 6)'
For example, in goolgledocs is function Getrange("C2".Getfotmula())
For example, on Sheet "Sheet1" to cell C2, there is the eomonth (A2, 6) formula, I want to go through the macro in the cells I need, if the formula contains eomonrh (..., 6), then replace it with eomonrh (..., 12 )
I know how to get the cell value (03/31/2019), but how do I get the formula for this cell?(eomonth (A2, 6) )
Let oworksheet=api.getsheet("Sheet1");
Let scellvalue=oworksheet.Getrange("C2").GetValue();
Let scellformula=oworksheet.Getrange("C2").?????
What function i must use , so that scellformula='(eomonth (A2, 6)'
For example, in goolgledocs is function Getrange("C2".Getfotmula())