Summary: | The Eurosign € is not allowed in the name of an area inside the table | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | terra |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | aron.budea, erack, miguelangelrv, nerd, serval2412, terra |
Priority: | medium | ||
Version: | 5.1.6.2 release | ||
Hardware: | Other | ||
OS: | Windows (All) | ||
Whiteboard: | interoperability | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 109178 |
Description
terra
2016-11-04 17:52:44 UTC
Please find here what is allowed. https://help.libreoffice.org/Calc/Naming_Cells 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. So it means it's an enhancement. 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. *** Bug 102272 has been marked as a duplicate of this bug. *** 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? 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. (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. And not only the "€" also the "$" (only if it on the end of a string) and maybe the "§" and the symbol for british pound "£". I'm not sure € or $ are unicode letters http://docs.oasis-open.org/office/v1.2/csd06/OpenDocument-v1.2-csd06-part2 Identifier ::= ( LetterXML (LetterXML | DigitXML | '_' | CombiningCharXML)* ) - ( [A-Za-z]+[0-9]+ ) - ([Tt][Rr][Uu][Ee]) - ([Ff][Aa][Ll][Ss][Ee]) https://www.w3.org/TR/REC-xml/#NT-CombiningChar 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. |