For text input, auto fill failed to trigger recalculation of set column Values


Version: 2020

Type: Known Issues

Category: Data Handling

Subcategory: Set Column Values / Cell Formula

Jira: ORG-21100


New bug in Origin 2020.

E.g. fill column A with text, such as aa, bb.

In column B, set F(x) cell as A so it shows aa, bb.

Select aa and bb in column A and drag the bottom-right corner of bb downwards to fill with more rows with aa, bb, ...

==> Column B doesn't auto update to show more values. 

Note: No such problem if column A is numbers.

No such problem if you manually enter more values in column A.


Workaround: Set column A as Text.