Issue 28404 - problem when entering strings into cells using the '-char
Summary: problem when entering strings into cells using the '-char
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-04-27 09:22 UTC by norbert2
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description norbert2 2004-04-27 09:22:17 UTC 
Because I wanted to make a cell show the string "=R1", not the dereferenced, 
just the dereferenced value, just the string, I have entered "'=R1".

Here I found the following problems:

- enter "'=R1" into a cell

- re-select that cell:
The '-char is not shown in the edit-field. Excel shows it correct.

- double click the cell:
Here the '-char is also not shown in the cell when starting to edit it. Excel 
shows it correctly.
Here Calc also has a bug, that shows the "R1" highlighted blue like it would be 
a reference to the cell R1. (But it is correctly handled as string although 
the '-char is not displayed.)
Comment 1 norbert2 2004-04-27 09:23:32 UTC 
correction of the first sentence of my last comment:

"Because I wanted to make a cell show the string "=R1", not the de-referenced 
value, just the string, I have entered "'=R1"."
Comment 2 frank 2004-04-27 11:08:57 UTC 
Hi Niklas,

have a look at this one please.

Formatting the cell as text and following the description Calc will retain the
text value.

Frank
Comment 3 Marcus 2017-05-20 11:13:54 UTC 
Reset assigne to the default "issues@openoffice.apache.org".