Posted 2 April 2024, 3:22 am EST
In excel, if a user presses enter after typing an invalid formula, an error message appears but the formula is retained and the user is returned to the formula editor.
In SJS, after the error message appears, the invalid formula is deleted and their work is lost.
Is there a way that we can simulate the Excel behavior, where we retain the formula and return the user to the formula editor?
Thanks!