Bug 158574

Summary: Changing the column to R in Navigation after transition (syntax Excel R1C1)
Product: LibreOffice Reporter: Barsovski <bars.work>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: buzea.bogdan, miguelangelrv
Priority: medium    
Version: 7.6.3.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103030    

Description Barsovski 2023-12-07 08:18:27 UTC 
Description:
When the display of columns as numbers is configured (syntax Excel R1C1), when moving to a row through Navigator (F5), the column changes to "R", although the transition occurs correctly. 
Ubuntu 22.04
Tested LibreOffice version with problem - 7.3.4.2, 7.6.3.2

Steps to Reproduce:
0. Alt+F12 -> LibreOfiice Calc -> Formula -> set syntax to "Excel R1C1" -> apply
1. F5
2. Set column to exist column (for example "B")
3. Set row to exist row (for example 20)
4. Hit enter

Actual Results:
Column changing to "R", transition to [column "B" row 20] occurs correctly.

Expected Results:
Don't automatically switch column "B" to "R"


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
Version: 7.6.3.2 (X86_64) / LibreOffice Community
Build ID: 29d686fea9f6705b262d369fede658f824154cc0
CPU threads: 12; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: en-US (C.UTF-8); UI: en-US
Calc: CL threaded
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Comment 1 m_a_riosv 2023-12-07 13:58:42 UTC 
Reproducible
Version: 24.2.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: a9ad36ae46ff76c0d59b0d170314fdd3a9ee5d35
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded