The environment
Version: 7.0.4.2
Build ID: 00(Build:2)
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: x11
Locale: pt-BR (pt_BR.UTF-8); Interface: pt-BR
Debian package version: 1:7.0.4-4+deb11u7
Calc: threaded
The problem:
COLUMN B C D E
27 TOTAL R$ 14.665,32 R$ 14.396,66 R$ 13.986,87 R$ 12.922,57
…
In Cells S9, S10, S11, S12 i want to replicate content of Cells B27, C27, D27 and E27. So, according to documentation, if one needs to anchor both Column and Row B27, simply $ to both: **$B$27! But to anchor column B and change rows as many times as one needs, simply $ B27! But what I need is much on the contrary: anchor row and change collumn. So, as per your documentation, simply apply B$**27 and the row keeps preserved (27) but the column should change! But it appears, at least, for me to have not changed! When I copy to cells S9, S10, S11, S12 content B$27 it should be cell s9=$b27, s10=c$27, s11=$d27, s10=e$27 but it results in $B27 in all of them, as if I had entered $B$27.
I would not go as far as to say that it is definitely a bug but I look thru the docs and web but I have not found an answer. Should you be kind enough as to point me to any place in the docs i have missed or any other source, i would be very grateful.