Calculation cell is one step slower
Hi, I am using Acrobat XI Standard to create a form.
| Cell Name | Cell Value |
|---|---|
| A1 | 1 |
| A2 | 2 |
| A3 | 3 |
| A4 | =A1+A2+A3 |
For example, if I put 1 in Cell A1 and 2 in A2 and 3 in A3, I want A4 to calculate A1+A2+A3=1+2+3=6. My problem is, when I put in 1 in cell A1, A4 shows 0, when I then put 2 in cell A2, A4 shows 1. Then I put 3 in A3, A4 shows 3 which is the sum of 1+2 (A1+A2). The calculation seems to be one step slower than my input. So when I finish entering, A4 shows 3 which should be 6. If I want it to be correct, I need to make another action, like put 0 in another cell so A4 would calculate A1+A2+A3 instead of just A1+A2.
It only happens to several columns and other columns are fine, I checked settings and properties in both cells and they are the same, so I don't know how to do it.
My laptop is windows 10 pro version 1511, processor is Intel(R) Core(TM) i7-5500U CPU @ 2.40GHz 2.40 GHz. System type is 64-bit operating system, x64-based processor.
Please let me know how to solve this problem. Thank you.