2.4.1
-
Updated builtin function list with Google Sheets functions
in an attempt to correct an issue regarding function highlighting potentially stemming from differences in system locale and/or operating systemand verified both Excel and Google Sheets functions are up to date as of 12/27/2024 (credit to acid_form). -
Updated matching for functions not in the builtin list to try to allow for user-defined functions in the above case, and to more closely follow the naming rules for user-defined functions in Excel.
-
Updated matching for names, like those defined in the Name Manager or in LET functions, to more closely follow the naming rules for names in Excel (rules for names are currently set to be identical to functions).
-
Allow commas and semicolons to be used interchangably as separators between function arguments.
-
Flag the following reference formats as invalid:
- A:1
- 1:A