search

joshbtn / excelFormulaUtilitiesJS

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.
http://excelformulabeautifier.com/
Other
394 stars 101 forks source link

Formula to vba code in Excel formula beautifier #79

Open timurhamzin opened 5 years ago

timurhamzin commented 5 years ago

It would be great if ExcelFormulaBeautifier could export formula to VBA padding lines with spaces like this:

        frmlaS = ""
        frmlaS = frmlaS & Trim("=IF(                                                  ")
        frmlaS = frmlaS & Trim("    ROW(                                              ")
        frmlaS = frmlaS & Trim("        [ВНС|Вариант зависимости обв-ти от КИН&15]    ")
        frmlaS = frmlaS & Trim("    ),                                                ")
        frmlaS = frmlaS & Trim("    ""ТП:<ГФ def>""                                   ")
        frmlaS = frmlaS & Trim(")                                                     ")