Keep formula exactly as entered by user.


Version: 2018

Type: Features

Category: Data Handling

Subcategory: Set Column Values / Cell Formula

Jira: ORG-16551


Before Origin 2018, formula auto expanded in some cases.

  • Sheet index in formula auto expanded to sheet name. E.g. user typed 1!A. It auto expanded to Sheet1!A.
  • If type A+0.5 in column A formula, it will become This+0.

System variable @SCVU is added in Origin 2018.  By default what you type will be what you see. If you want it to go back to 2017 behavior, set @scvu=0.