Bug 45802 - LibreOffice fails to update cell reference field after changing between A1/R1C1
Summary: LibreOffice fails to update cell reference field after changing between A1/R1C1
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.0 RC2
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Cell-Reference
  Show dependency treegraph
Reported: 2012-02-08 13:39 UTC by OfficeUser
Modified: 2022-07-13 08:53 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 OfficeUser 2012-02-08 13:39:31 UTC
This bug report is about the input field in the calc toolbar, where the name of the selected cell/range is displayed. By default after opening a blank spreadsheet it displays "A1".

Bug Report:
- Open a blank spreadsheet: Note A1 is displayed in the cell reference field
- Go to "Tools/Options.../LibreOffice Calc/Formula"
- Change "Formula syntax" to "Excel R1C1"
- Click OK

Note: The reference field still displays "A1".

- Move the cursor right and left: Now "R1C1" is displayed as expected.
Comment 1 bfoman (inactive) 2012-07-18 08:14:59 UTC
Confirmed with:
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit
Comment 2 Owen Genat (retired) 2014-08-09 07:14:07 UTC
Tested under GNU/Linux using:

- v4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a
- v4.2.5.2 Build ID: 61cb170a04bb1f12e77c884eab9192be736ec5f5
- v4.3.0.3 Build ID: 08ebe52789a201dd7d38ef653ef7a48925e7f9f7

All versions still exhibit the initial display problem as reported.
Comment 3 QA Administrators 2015-09-04 02:48:10 UTC Comment hidden (obsolete)
Comment 4 OfficeUser 2015-10-22 20:18:47 UTC
The bug is still present in
Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe

I have tested the Linux build.
Comment 5 QA Administrators 2016-11-08 11:18:58 UTC Comment hidden (obsolete)
Comment 6 OfficeUser 2016-11-08 13:25:31 UTC
I can still reproduce this bug with LibreOffice
Comment 7 QA Administrators 2018-07-12 02:44:43 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2020-07-12 03:37:14 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2022-07-13 03:30:22 UTC Comment hidden (obsolete)
Comment 10 OfficeUser 2022-07-13 07:31:07 UTC
I can still reproduce this bug with:

Version: / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 1:7.3.4~rc2-0ubuntu0.18.04.1~lo1
Calc: threaded
Comment 11 OfficeUser 2022-07-13 07:32:41 UTC
@Eike: I set keyword "easyHack". Is that ok?
Comment 12 Eike Rathke 2022-07-13 08:53:28 UTC
Only if it was identified as an EasyHack and the difficulty level has been determined and code pointers are provided so a new dev can dive into it. Hence I removed it again.
See https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Keywords#EasyHack