2.92 FAQ-939 Is there a way to disable cell formulas in my project?
Last Update: 6/5/2018
Origin 2018 introduced the cell formula; spreadsheet-like cell-level calculations. Those who do not use cell formulas don't need to concern themselves with disabling the feature. However, those who do use cell formulas may find that it suits their workflow to temporarily disable cell formulas and that is the subject of this FAQ.
To disable cell formula:
- You can directly enter worksheet cell formulas in the default mode and the calculated result will be shown immediately upon clicking outside the cell. However, if you prefer to see all cell formulas as you work, click Edit: Edit Mode. Origin will pause calculation until you reselect Edit: Edit Mode.
- There is also a way to disable cell formulas using a LabTalk system variable. Like the previous method, this will not prevent you from entering cell formulas in the cell but when you use this method, the formula will be simply treated as text and no calculation will be done until the value of the system variable is reverted to its default value (@esc=1).
@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:
- Run Origin by launching the program directly from the Windows Start menu or by clicking on the Origin desktop shortcut or taskbar icon. Do not launch Origin by double-clicking on the project file.
- Choose Edit: Edit Mode to pause cell formula calculation.
- Open your project using File: Open or File: Recent Projects.
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