$[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).
$[officename] では (Shift)＋(F4) を使うと、カレントセルの参照の相対･絶対が切りかえられます。例えば A1 (相対参照)は、(Shift)＋(F4) を押すと行列ともに絶対参照($A$1)にかわり、もう一度押すと行のみが絶対参照(A$1)に、さらにもう一度押すと列のみ($A1)、そして最後に行列ともに相対参照(A1)に戻ります。