Bug 107717 - Cannot use c or r as cell names
Summary: Cannot use c or r as cell names
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-05-09 07:36 UTC by Odd Nordland
Modified: 2017-05-09 08:02 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Screen dump with error message (34.75 KB, image/jpeg)
2017-05-09 07:38 UTC, Odd Nordland
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Odd Nordland 2017-05-09 07:36:54 UTC
Description:
I was defining names for cells in a spreadsheet and wanted to use a, b and c. While a and b were accepted, c produces an error message that it was an invalid name.
This not only happens with "c"; it also happens with "r". All other single letters (including æ, ø, å) were accepted.

Steps to Reproduce:
1.Select an arbitrary cell
2.Press Ctrl+F3
3.Select Add
4.Enter c in the name field
5.Delete c in the name field
6.Enter r in the name field
7.Delete r in the name field
8.Enter any other single letter in the name field

Actual Results:  
In steps 4 and 6 the error message "Invalid name. Only use letters, numbers and underscore." appears and the Add button is greyed (inactive).
In step 8 the Add button is activated.

Expected Results:
The software should accept a single c or r as a name just like all the other single letters.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; rv:53.0) Gecko/20100101 Firefox/53.0
Comment 1 Odd Nordland 2017-05-09 07:38:50 UTC
Created attachment 133180 [details]
Screen dump with error message
Comment 2 Odd Nordland 2017-05-09 07:41:21 UTC
While the hardware is 64 bit, the operating system (Windows 10 Pro) is 32 bit.
Comment 3 Markus Mohrhard 2017-05-09 07:55:41 UTC
r and c are excluded as they cause issues in R1C1 notation.
Comment 4 Mike Kaganski 2017-05-09 08:02:15 UTC
This is not a bug.

The R1C1 notation (see https://help.libreoffice.org/Common/Formula_1, and https://support.office.com/en-us/article/Overview-of-formulas-in-Excel-ecfdc708-9162-49e8-b993-c311f47ca173 - expand 'Using references in Excel formulas' and see 'The R1C1 reference style') allows using single R as 'An absolute reference to the current row', and C is the same for column respectively. So, these single characters have their own meaning.