To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=65510
User atdsm changed the following:
What |Old value |New value
================================================================================
CC|'' |'atdsm'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Summary|problem with two '-chars |Inconsistent stripping of
| |leading apostrophe (seemin
| |gly arbitrary)
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Fri Jun 30 06:04:12 -0700
2006 -------
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.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
