Bug 103711 - The Eurosign € is not allowed in the name of an area inside the table
Summary: The Eurosign € is not allowed in the name of an area inside the table
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Windows (All)
: medium enhancement
Assignee: Not Assigned
Whiteboard: interoperability
: 102272 (view as bug list)
Depends on:
Blocks: Cell-Name
  Show dependency treegraph
Reported: 2016-11-04 17:52 UTC by terra
Modified: 2017-07-23 21:26 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description terra 2016-11-04 17:52:44 UTC
I tried to use the name "Währungsunion_200€_Gesamt" assigned to a Tablearea:
Währungsunion_200€_Gesamt = $Bestand.$T$231

I get a Err:501 because of the € Letter. This should be solved!

PS:  The Dollarsign $ doesnt work either in this string

Actual Results:  
see description

Expected Results:
see description

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:49.0) Gecko/20100101 Firefox/49.0
Comment 1 m.a.riosv 2016-11-04 23:28:10 UTC
Please find here what is allowed.

Comment 2 terra 2016-11-05 08:51:02 UTC
if it is not a bug then it should be possible to include these special signs into the List of allowed letters.
Even MS was able to use special signs in Excel with named cells.
Comment 3 Julien Nabet 2016-11-05 10:32:03 UTC
So it means it's an enhancement.
Comment 4 terra 2016-11-05 11:53:37 UTC
Yes it is an enhancement. I cannot program, but i hope that one of you or an other specialist can include these and maybe other signs in the correct programcode for named cells and other parts of libreoffice where special sign are needed.
Comment 5 m.a.riosv 2016-11-06 00:49:16 UTC
*** Bug 102272 has been marked as a duplicate of this bug. ***
Comment 6 Julien Nabet 2016-11-06 16:04:43 UTC
Eike: I noted the code pointer ScCompiler::IsCharFlagAllConventions
but just wonder if ODF convention is ok with €. I mean if Excel accepts it but ODF doesn't (I don't know if it's the case or not), how to deal with Euro symbol?
Comment 7 Morten Leikvoll 2016-11-07 09:09:50 UTC
Ref bug#102272, please note that this issue prevents libreoffice from supporting certain xlsx sheets. Wether its an enhancement or not can be discussed. An option to support these characters would be to replace them with valid ones during import.
Comment 9 Julien Nabet 2016-11-07 20:09:13 UTC
(In reply to m.a.riosv from comment #8)
> http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06-part2.
> pdf
> Page 48-49

Ok, so I read this:
Expressions should limit the names of their identifiers to only ([UNICODE]) letters, underscores, and digits, not including patterns that look like cell references or the words True or False
So € should be allowed.
Comment 10 terra 2016-11-07 20:51:20 UTC
And not only the "€" also the "$" (only if it on the end of a string) and maybe the "§" and the symbol for british pound "£".
Comment 11 m.a.riosv 2016-11-07 23:47:03 UTC
I'm not sure € or $ are unicode letters

Identifier ::= ( LetterXML
  (LetterXML | DigitXML | '_' | CombiningCharXML)* )
- ( [A-Za-z]+[0-9]+ )
- ([Tt][Rr][Uu][Ee]) - ([Ff][Aa][Ll][Ss][Ee])

Comment 12 Morten Leikvoll 2016-11-08 07:43:40 UTC
You are right. The characters '$','€','£' and '?' are not part of XML1.0 letter spec. As for my "child" bug#102272, this is obvious an xlsx document not following the opendoc specs.
All I can wish for in this case is to get notified about this, and given an option to repair it, wich is clearly an enhancement request.