Set Column Value calculation failed to work in inserted rows

Version: 2019

Type: Bug Fixes

Category: Data Handling

Subcategory: Set Column Values / Cell Formula

Jira: ORG-18234

Newly broken in 2018b.

  1. Fill Column A with row numbers.
  2. Set F(x) of Column B as A*3
  3. Right click row 1 and choose Insert to insert a row on the top.
  4. Enter 4 in the new A1 cell.

  ==> B1 isn't updated.