Bug 45802

Summary:	LibreOffice fails to update cell reference field after changing between A1/R1C1
Product:	LibreOffice	Reporter:	OfficeUser <norbert.notz>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	bfo.bugmail
Version:	3.5.0 RC2
Hardware:	Other
OS:	All
Whiteboard:
i915 platform:		i915 features:

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 2012-07-18 08:14:59 UTC

Confirmed with:
LO 3.5.5.3 
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

Comment 2 Owen Genat 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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.