Using R1C1 reference style, converting from a relative to an absolute reference (using Shift+F4), Calc incorrectly converts the reference. --== To reproduce ==-- Open Calc Tools > Options > LibreOffice Calc > Formula > Formula options > Formula syntax > Excel R1C1 > OK In row 1, column 1 (usually A1) enter the data: 1 In row 1, column 2 (usually B2) enter the data: 2 In row 2, column 1 (usually A2) enter the data: 3 In row 2, column 2 (usually B2) enter (without quotes) the formula: "= R1C1" Press "Enter" to confirm input - the formula returns "1", as it should - Select the reference "R1C1" in the formula bar (still in cell B2) Press "Shift+F4" - the reference changes to "R1C" (incorrect, it should be R1C[-1]) - Press "Enter" to confirm input - the formula returns "2", this is incorrect (should still return "1") - Select the reference "R1C" in the formula bar (still in cell B2) Press "Shift+F4" again - the reference changes to "RC1" (incorrect, it should be R[-1]C1) - Press "Enter" to confirm input - the formula returns "3", this is incorrect (should still return "1") - Select the reference "RC1" in the formula bar (still in cell B2) Press "Shift+F4" again - the reference changes to "RC" (incorrect, it should be R[-1]C[-1]) - Press "Enter" to confirm input - the formula returns "Err:522", this is incorrect (should still return "1") - --== End of reproduction ==-- Using LibreOfficePortable 3.3.2 as downloaded from http://portableapps.com/apps/office/libreoffice_portable Running off local drive (C:\PortableApps\LibreOfficePortable) in Win7 64bit About: LibreOffice 3.3.2 OOO330m19 (Build:202) tag libreoffice-3.3.2.2 Apologies for the wordy post, but I wanted to avoid misinterpretation as far as possible.
I just picked up a typo in my bug report. Row 1, column 2 (where the number '2' is entered) is actually B1 (not B2).
Confirmed LibreOffice 3.3.2
I'm taking it, though it's a bit tight for 3.4. If I can't make it, I'll re-target for 3.4.1.
I'm on this, right now.
Fixed it in the 3.4 branch. The fix will be available in Beta2.
I've tested the fix on LibreOfficePortable 3.4.1; unfortunately it is only partially fixed. I've filed a new bug addressing it in more detail: https://bugs.freedesktop.org/show_bug.cgi?id=39135
There is no need to reopen this if you've filed a new one.