Issue 65510 - Inconsistent stripping of leading apostrophe (seemingly arbitrary)
Summary: Inconsistent stripping of leading apostrophe (seemingly arbitrary)
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.2
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2006-05-17 23:01 UTC by norbert2
Modified: 2017-05-20 11:13 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description norbert2 2006-05-17 23:01:16 UTC


- open a blank spreadsheet

- enter "'3" into cell A1 (without the "-chars)

- enter "''3" into cell A2 (without the "-chars)

The result is as expected: A1 shows "3" while A2 shows "'3".

Now compare the Input line with these two different cells focused: both cells
show "'3". But A2 should show "''3", the text we have entered there.

(Excel correctly shows "''3".)
Comment 1 atdsm 2006-06-30 14:04:12 UTC
Confirmed - Windows XP SP2, OOo 2.0.3-RC5.

This is a case of inconsistent behavior.

From the OOo help:
"If you decide to enter a number directly as text, enter an apostrophe (')
first. For example, for years in column headings, you can enter '1999, '2000 and
'2001. The apostrophe is not visible in the cell, it only indicates that the
entry is to be recognized as a text."

OOo help does not state here how it will handle an apostrophe preceding a
non-number string. In practice, OOo strips the leading apostrophe from the
string altogether UNLESS the string is purely a number OR in the case of a
recognized misspelling (?). (This can be observed by following the directions
above, and by trying the combinations below.)

Tried the following combinations:

'3           (Apostrophe NOT stripped; displayed as "3")
''3          (Apostrophe is stripped; cell contents read "'3")
'''3         (Apostrophe is stripped; cell contents read "''3")
'Something   (Apostrophe is stripped; cell contents read "Something")
'Something'  (Apostrophe is stripped; cell contents read "Something'")
'Someword    (Apostrophe NOT stripped; displayed as "'Someword" - a misspelling)
'001-202-222 (Apostrophe is stripped; cell contents read "001-202-222")

Expected behavior: OOo should never strip the apostrophe from the front of the
text entered; it should simply not display the apostrophe (except in the formula
bar). OR, perhaps it should display the apostrophe except in cases where a pure
number has been entered, thus enabling someone to enter a word in single quotes
(eg. 'Something') without having the leading apostrophe disappear.

Changing summary to reflect inconsistent behavior.
Comment 2 atdsm 2006-06-30 14:05:06 UTC
To workaround, use ="[text]", where [text] is the text you desire to have
appear, such as ''3.
Comment 3 frank 2006-07-07 12:48:34 UTC
Hi Niklas,

one for you.

Comment 4 Marcus 2017-05-20 11:13:44 UTC
Reset assigne to the default "".