This library contains methods to beautify an excel formula. This library also contains functions to convert an excel formula to JavaScript (ECMAScript) or C# and python.
Above formula results in below. some double quotes are removed i.e. ="""" is reduced to =""" in first part and double quotes are also removed throughout the "beautified" formula.
=""""&IF(J$2>1,"""""""","")&TEXTJOIN(""""",""""",FALSE,OFFSET(GalaxyLoad_MasterData!$A$1,$D7-1,J$3-1,J$2,1))&IF(J$2>1,"""""""","")&""""
Above formula results in below. some double quotes are removed i.e. ="""" is reduced to =""" in first part and double quotes are also removed throughout the "beautified" formula.
=""" & IF( J$2 > 1, """"", "" ) & TEXTJOIN( """,""", FALSE, OFFSET( GalaxyLoad_MasterData!$A$1, $D7 - 1, J$3 - 1, J$2, 1 ) ) & IF( J$2 > 1, """"", "" ) & """