st3-2.5.2
This is the legacy version of Excel formula from before it became Spreadsheet formula in Package Control. It can be used with Sublime builds 3092 - 4074.
Edit (1/6/2025): Logical comparator functions AND, OR, etc. and logical flow functions IF, IFS, etc. that had new scopes applied in 2.5.1 now have both the support.function.excel scope applied to them in addition to the two new scopes applied to said categories of functions: keyword.operator.logical.excel and keyword.control.conditional.if.excel, respectively. The visual effect of this in the default Mariana color scheme is that these two categories of functions additionally show in italics, reflecting the fact that they are built-in functions.
Two relatively major changes from a UX POV:
- Reverted the previous change explicitly allowing commas as decimal separators. This change made unit testing (QC) too hectic. We have plans to extend this syntax into multiple flavors, including commands that allow users to specify their locale and software of choice (Excel, Sheets, or Libre), at which point this and several other conflicts will be resolved properly.
Apologies for any inconvenience this may cause. I have no idea if anyone other than myself and Michael reads these release notes, but if you run into any locale specific issues or quirks, please submit them here if they are not already mentioned: #19.
- Formalize naming rules for names defined in LET, name manager, etc. These changes extend to functions. They also extend to Google Sheets and Libre office.
Other changes:
The space intersection operator is now explicity scoped for use between two names as those defined in LET and the name manager, and between a name and a standard cell or range reference.
Fleshed out unit tests for naming rules and uses of the space intersection operator in Excel.
Full Changelog: 2.5.1...2.5.2