Last Update: 4/26/2022
Origin 2018 introduced the cell formula; spreadsheet-like cell-level calculations. You can directly enter worksheet cell formulas in the edit mode and the calculated result will be shown immediately upon clicking outside the cell. However, you may find it suits your workflow to disable cell formulas in some cases.
To disable cell formula:
@esc=0 // disable cell formulas
@esc=1 // default, allow cell formulas
For guidance on changing the value of a LabTalk system variable, see this FAQ.
When you suspect cell formula of causing Origin to crash:
In rare cases, we have seen cell formula-related program crashes and when you suspect that this might be the cause, try the following:
If you are able to open a project in this mode where previously you could not, there is a good chance that something in your cell formula calculations is causing the crash. While in Edit Mode, you can try deleting your cell formulas and/or try to save portions of the project that do not contain cell formulas, as new window or project files.
Keywords:cell formula, cell calculation, spreadsheet, Edit Mode, remove link