Odd.
I did these steps:
Selects the cells in column E, then copied.
(The cells contain a formula referencing the values in column D)
Opened a new Numbers document, and
- Selected D1 and Pasted
- Selected A1 and Pasted
- Clicked in the open canvas and pasted
Results:
Column D: Formulas are in the cells. All formulas have been recalculated, and the results are displayed.
Column A: Formulas are in the cells, and display a 'bad ref' error message.
New table: Formulas are in the cells, and display a 'bad ref' error message.
All results as expected. The error messages arise from the formulas attempting to reference cells in the column to the left of the column containing the formula. The results in D are correct for the formula used: D2: ISEVEN(C2)
Test done with Numbers 3.6.2 and OS X 10.11.6.
Possibly a Hi Sierra/Numbers 4 issue/
Regards,
Barry