$[officename] can convert the current reference, in which the cursor is positioned in the input line, from relative to absolute and vice versa by pressing Shift +F4. If you start with a relative address such as A1, the first time that you press this key combination, both row and column are set to absolute references ($A$1). The second time, only the row (A$1), and the third time, only the column ($A1). If you press the key combination once more, both column and row references are switched back to relative (A1) $[officename] Calc shows the references to a formula.
将光标移至输入行内后按下组合键 Shift+F4，这时 $[officename] 能够将当前输入行中的引用在相对引用和绝对引用之间转换。如果是相对引用，例如 A1，第一次按下组合键后，行与列都将被设置为绝对引用 ($A$1)。再次按下组合键后，只有列 (A$1) 被转换，第三次按下组合键，只有行 ($A1) 被转换。如果再次按下该组合键，行和列都被转换成相对引用 (A1)。