Bug 106610 - EDITING: you can define names with ' in the name box but you can't use them properly
Summary: EDITING: you can define names with ' in the name box but you can't use them p...
Status: RESOLVED DUPLICATE of bug 86214
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.5.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-03-17 23:58 UTC by Gilward Kukel
Modified: 2017-03-18 14:05 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 Gilward Kukel 2017-03-17 23:58:59 UTC 
Description:
After every start of LibreOffice, you can define exactly one name with ' using the name box (not the dialog "Define names") e.g. a' but when you then put =a' into a cell it says Err:509 (Operator missing). You can only do this in the name box until you open the dialog "Define names".

Steps to Reproduce:
1. close and start LibreOffice
2. in Calc's name box, type a' and press Enter

Actual Results:  
name is accepted

Expected Results:
error message, name not accepted


Reproducible: Always

User Profile Reset: No

Additional Info:
the same in 5.3.1.2


User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0
Comment 1 Markus Mohrhard 2017-03-18 01:32:00 UTC 
At least in master it is no longer possible to define these names. See e.g. https://cgit.freedesktop.org/libreoffice/core/commit/?id=a070d0d34763c83b4e957a7aee8b7f255a1d5519 that tests that test' is not a valid name and will not be accepted.
Comment 2 Markus Mohrhard 2017-03-18 01:34:09 UTC 
Most likely a duplicate of Bug 86214. The fix for that bug can not be backported as it changes translatable strings.
Comment 3 Xisco Faulí 2017-03-18 14:05:23 UTC 
Closing as RESOLVED DUPLICATED as per comment 2

*** This bug has been marked as a duplicate of bug 86214 ***