Syntax for spreadsheet formulas

[fdmsaraiva]

What syntax highlighting would you recommend for writing spreadsheet formulas, like those used in Excel, Google Sheets, Numbers, etc?

[FichteFoll]

This syntax is inspired by Tex/LaTeX, if I remember correctly. The easiest way would be to use the LaTeX syntax and wrap your formulas in $, i.e. $a^{b+x}$.

[fdmsaraiva]

Thanks for the suggestion @FichteFoll, but it doesn’t pickup syntax very well. So far C seems to do the best job, but picks up on very little.

[mkormendy]

I’ve used the ASP syntax highlighting. Works nicely!

[neochuck]

Yes, C is indeed the best one. Thank you!

[Alco]

@fdmsaraiva

Apologies for digging up this old post, but if it’s any help, I’d like to share the following:

I had been struggling with this issue as well. A few weeks ago I finally got fed up and made my own:

Excel formula - Package Control
Excel formula - Github

So far it’s been smooth sailing when using it with all kinds of Excel formulas.

Edit:
As of now, v1.1.3 is the latest version. Currently waiting for Package Control to check the repo for the update. I forgot to remove (test) from the syntax name: before committing it to Github.

Preview: