[tdf-discuss] R1C1 absolute/relative reference style broken?

Hi all,
I've been using LibO 3.3 for a while now and I believe I found a bug
regarding the R1C1 reference style.  Please confirm whether or not it is
actually a bug.

Using R1C1 reference style, 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 ==--

I am using LibreOfficePortable 3.3.2 as downloaded from
http://portableapps.com/apps/office/libreoffice_portable
Running off my local drive (C:\PortableApps\LibreOfficePortable) in Win7
64bit
LibreOffice 3.3.2 
OOO330m19 (Build:202)
tag libreoffice-3.3.2.2

I apologise for the wordy post, but I wanted to avoid misinterpretation as
far as possible.

Regards
Jack

--
View this message in context: 
http://nabble.documentfoundation.org/R1C1-absolute-relative-reference-style-broken-tp2794768p2794768.html
Sent from the Discuss mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to discuss+help@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted