Posted 20 May 2022, 10:32 am EST
Hello,
We are seeing some differences compared to Excel when using the F4 keyboard shortcut (they are all listed below).
Issue 1: Let’s say I have =A1 in a cell and when in edit mode of the cell, I put the focus right after the = sign and press F4, nothing happens. In Excel, pressing F4 in this situation, the reference value is updated to =$A$1.
Issue 2: Let’s say I have =SUM(A1+A2) in a cell. When in edit mode of the cell, If I highlight the entire formula and press F4, nothing happens. In Excel, doing this updates the reference values for both A1 and A2 to =SUM($A$1+$A$2)
Issue 3: Let’s say I have =SUM(A1+B1+C1) in a cell. When in edit mode of the cell, If I highlight just A1+B1+C1 and press F4, the highlight is lost. In Excel, the highlight is maintained so the user keep cycling through the values
Issue 4: Let’s say I have =A1+$A$2 in a cell. When in edit mode of the cell, If I highlight A1+$A$2 and press F4. Only $A$2 reference is changed and A1+A$2 is what is now showing. In Excel if I do the same thing, $A$1+$A$2 is what is now in the cell.
