This issue is similar to but not the same as that reported in Bug 39135. The behaviour is so fundamental that it results in the R1C1 syntax feature being unreliable for practical purposes, which is why I have rated this as major because the R1C1 feature itself is very valuable. Replication is easy: * Start with a new blank spreadsheet. * Tools --> Options --> Calc --> Formula --> Syntax = Excel R1C1 * In cell R3C3 enter "xxx". * In cell R2C2 type = and then click on the xxx in R3C3. * This correctly enters =R[1]C[1] into cell R2C2, which should also now show "xxx". * With cell R2C2 still selected, type Shift-F4. * This should change the formula in R2C2 from =R[1]C[1] to =R3C3. * However it changes it to =R2C2, and the cell no longer references the xxx as can be seen. Please see screen dumps attached. ps. Also just as an aside, why is the formula syntax called "Excel R1C1" when the feature is useful in its own right? Is there another variant of R1C1 syntax that one should be aware of?
Created attachment 49688 [details] Screen dumps.
Failed to reproduce on LibreOffice 3.4 340m1(Build:103) for OpenSuse Linux. When I execute shift+F4, the syntax correctly switches to R3C3 and "xxx" appears. It could be a version issue. Thanks for the steps and screenshots.
As the originator of this bug I can confirm the issue as reported is fixed in LO 3.4.2 (Build:203) under Win XP. Thanks.
Marking this as resolved per Comment 3. And yes, I do remember fixing this but I just don't remember under which bug number I fixed.
Zdeněk Crhonek committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/3cfdac90efd2b4c8397ca7ccf8bce91672000c82%5E%21 uitest for bug tdf#39650 It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
The test exist, set status to Verified.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d4d046bb9c5d17cdd432b362c38914cc7b0a75f1 tdf#39650: move UItest to CppUnittest It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.