Posted 24 October 2019, 5:03 am EST
Hi,
In order to precalculate data based on custom function parameters I need to extract all functions as strings from a formula.
Example:
=SUM(GETCELL(CPTYPE($B$4),DI0M($B$1),DI1M($B$2),DI2M(“/”&B$6&“/”&$A7),DT(“AV”),MODEL(“5/1”),IV($B$3),RW()),GETCELL(CPTYPE($B$4),DI0M($B$1),DI1M($B$2),DI2M(“/”&B$6&“/”&$A7),DT(“AV”),MODEL(“5/1”),IV($B$3),RW())))/GETCELL(…,…)&“/”&GETCELL(…/…)
four string extracted GETCELL(…) functions I’d use for further processing.
Is there a SpreadJS function which would help???
Thanks!