Bug 115593 - Name a cell "C"
Summary: Name a cell "C"
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.0.0.beta2
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-02-09 18:02 UTC by Microbd
Modified: 2018-02-12 16:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Microbd 2018-02-09 18:02:27 UTC 
Description:
Could not give the name of "C" to a cell. All other letters work!

The name "C1a" is refused while "D1a" is accepted!

Tested on PC Windows et Mac OSX.

Steps to Reproduce:
1.Name a cell "C"
2.
3.

Actual Results:  
Nom incorrect. La référence à une cellule, ou à une plage de cellules n'est pas autorisée.
Invalid name The reference to a cell, or a range of cells is not allowed.

Expected Results:
Accept "C" as the cell name as it accepts all other letters.


Reproducible: Always


User Profile Reset: No



Additional Info:
Article :
http://mackid.legtux.fr/?p=1586


User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36
Comment 1 m_a_riosv 2018-02-09 23:08:21 UTC 
For me only 'c' it's not accepted 'cla' is accepted.
Versión: 6.0.0.3 (x64)
Id. de compilación: 64a0f66915f38c6217de274f0aa8e15618924765
Subproc. CPU: 4; SO: Windows 10.0; Repres. IU: predet.; 
Configuración regional: es-ES (es_ES); Calc: CL
Comment 2 Xavier Van Wijmeersch 2018-02-10 06:52:32 UTC 
no repro with

Version: 5.4.6.0.0+
Build ID: 01f19aba638860db54ca9a60e30ce6f21ee0ea5a
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 6.1.0.0.alpha0+
Build ID: bc2ae79f81c8aa081d6340348c70c0440f6e895e
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: gtk3; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 6.1.0.0.alpha0+
Build ID: d30eefb677b446886f7b5bab6de93d489ba63529
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-02-06_16:54:53
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 3 Microbd 2018-02-10 07:18:55 UTC 
Repro with :
Version: 6.0.1.1
Build ID: 60bfb1526849283ce2491346ed2aa51c465abfe6
Comment 4 Gilward Kukel 2018-02-12 15:20:51 UTC 
"R" is also forbidden.
It is the same in Excel.
Maybe because "C" means "column" and "R" means "row".
Comment 5 m_a_riosv 2018-02-12 16:12:36 UTC 
Thanks for the poing gilward, so it keeps the compatibility with RC address format.

I think we can resolve as not a bug.