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

Remove forced linebreaks #29

Closed HLinde closed 9 years ago

HLinde commented 9 years ago

Could you remove the forced line-break on http://excelformulabeautifier.com/ after ~140 chars? I got some very nasty formulas and to me it seems a bit arbitrary to do additional line-breaks with no functional meaning.

Otherwise a very nice tool, helps a lot. Thanks, Hannes

joshbtn commented 9 years ago

Thanks for the feedback! I'll look into this shortly.

joshbtn commented 9 years ago

@HLinde , I fixed this using a simple css change. Take a look and let me know if it works for you.

I tested using this formula:

=IF(SUM( IF(FOO = BAR, IF(SUM( IF(FOO = BAR, IF(SUM( IF(FOO = BAR, IF(SUM( IF(FOO = BAR, IF(SUM( IF(FOO = BAR, IF(SUM( IF(FOO = BAR, IF(SUM( IF(FOO = BAR, IF(SUM( IF(FOO = BAR, IF(SUM( IF(FOO = BAR, IF(SUM( IF(FOO = BAR, IF(SUM( IF(FOO = BAR, 10, 0), 10 ) = 20 , "FOO", "BAR"), 0), 10 ) = 20 , "FOO", "BAR"), 0), 10 ) = 20 , "FOO", "BAR"), 0), 10 ) = 20 , "FOO", "BAR"), 0), 10 ) = 20 , "FOO", "BAR"), 0), 10 ) = 20 , "FOO", "BAR"), 0), 10 ) = 20 , "FOO", "BAR"), 0), 10 ) = 20 , "FOO", "BAR"), 0), 10 ) = 20 , "FOO", "BAR"), 0), 10 ) = 20 , "FOO", "BAR"), 0), 10 ) = 20 , "FOO", "BAR")

HLinde commented 9 years ago

Very nice, works for me. Thanks a lot.