Bug 158574 - Changing the column to R in Navigation after transition (syntax Excel R1C1)
Summary: Changing the column to R in Navigation after transition (syntax Excel R1C1)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Navigator
  Show dependency treegraph
Reported: 2023-12-07 08:18 UTC by Barsovski
Modified: 2023-12-09 11:39 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Barsovski 2023-12-07 08:18:27 UTC
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 -,

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: (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
Version: (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