I’ve had a few queries from fiddler users about how to deal with formulas. Fiddler is primarly for abstracting spreadsheet values so they can be manipulated and updated without worrying too much about the physical details of where they are. Sheets formulas are of course very concerned about where sheet data is relative to each component of the formula – which makes it tricky to support.
Fiddler does have a number of abstracted range manipulation methods (mainly to help with formatting – see Fiddler and rangeLists) but those same methods can be used to play around with formulas too.
https://ramblings.mcpher.com/gassnippets2/formulas-fiddler/
I’ve had a few queries from fiddler users about how to deal with formulas. Fiddler is primarly for abstracting spreadsheet values so they can be manipulated and updated without worrying too much about the physical details of where they are. Sheets formulas are of course very concerned about where sheet data is relative to each component of the formula – which makes it tricky to support.
Fiddler does have a number of abstracted range manipulation methods (mainly to help with formatting – see Fiddler and rangeLists) but those same methods can be used to play around with formulas too. https://ramblings.mcpher.com/gassnippets2/formulas-fiddler/