Enter value in F(X) applies to whole column


Version: 2025

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-29742


Sometimes user highlights a range of cells in column and set its value. Such sub The formula shows in F(x) cell but will only be applied to the specified sub range in the future. Later user may forget this and wonder why changing F(x) failed to apply to the whole column.

In Origin 2025, system variable @FXR (default 1) is added:

  • 1 - new behavior. Type new formula in F(X) will update the whole column

  • 0 - old behavior. Type new formula in F(X) will only update the subrange