Bug 107717

Summary: Cannot use c or r as cell names
Product: LibreOffice Reporter: Odd Nordland <onordla>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal    
Priority: medium    
Version: 5.3.2.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Screen dump with error message

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.