Introduce in A1: =COLUMN($A$1) copy to A2 the copied formula in A2 is: =COLUMN($A$2) Other function with the error is CELL("address";$A$1) For example: ROW() function seems works well. Maybe a regression, works well in 3.4.5 with both functions.
Remains in 3.5.3rc1
Confirmed with Linux/32. Effect seems to be restricted to manual copy&paste (i.e. Ctrl+C, Ctrl+V). Autofilling (click on small rectangle down right of cell cursor) seems to work ok. Maybe it's a difference if referenced cell is not equal copied cell, but I haven't examined enough yet, so needs further narrowing. Looks as if under certain circumstances the reference is not recognized as absolute and therefore treated as relative. MAB candidate?
sorry, forgot to mention my Version: 3.5.3.1 and master~2012-04-17_13.43.52_LibO-Dev_3.6.0alpha0_Linux_x86_install-rpm_en-US
This should happen for all formulas that support self reference. There is a problem in my copy/paste adjust formula algorithm for self references.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=bba176a844bd993cf7fe6acce9ff18027870dfa5 only update absolute refs when copying between docs, fdo#48482
This copy&paste formula adjusting code is becoming too complex. Before I'll add that patch into 3-5 I'll need to write some automatic tests to make sure that I have not introduced another bug. Therefore it will not make it into 3-5-3.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7d65dd728ca2b7dea073ef085110dccdf22c2d5c add test case for copy/paste formulas, related fdo#48482
Thanks Markus. I hope, I can download the master and do a test in a couple of days.
Seems solved in 3.6.0alpha0+ (Build ID: f3d7d6e) Copied in all directions, with absolute and mixed relative/absolute references, in a large and complex spreadsheet with external links, arrays, and many types of functions. Win7x64 Ultimate