Support cell formula update when copy and paste


Version: 2020b

Type: Features

Category: Data Handling

Subcategory: Set Column Values / Cell Formula

Jira: ORG-20808


Example I: Enter formula “=A1/B1” in C1 cell, copy it and paste to C2 cell, formula will automatically update to “=A2/B2”.

Example II: Enter formula “=total(A)” in C1 cell, copy it and paset to D1 cell, formula will automatically update to “=total(B)”.