Issue 27970 - Copy-Paste from cell to Input line adds trailing (delimiter?) character
Summary: Copy-Paste from cell to Input line adds trailing (delimiter?) character
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2004-04-19 14:45 UTC by norbert2
Modified: 2014-04-23 06:28 UTC (History)
2 users (show)

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

copy_paste.sxc (5.38 KB, application/vnd.sun.xml.calc)
2004-04-19 14:45 UTC, norbert2
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description norbert2 2004-04-19 14:45:00 UTC
Please open the attached spreadsheet:

- (A1 is selected after opening the spreadsheet) press CTRL+C

- select A2

- click into the edit-field at the top to be able to insert content to to B1

- press CTRL+V:
The first strange thing here is the "space" that has been inserted after 
the "1", that seems not to be a real space

- press backspace in order to delete this "space":

Have a look at the cell: It contains "1,00E-00" instead of "1,00E-001" like the 
edit-field contains!

- confirm:
That incorrect value is applied to the cell! This is fatal!
Comment 1 norbert2 2004-04-19 14:45:26 UTC
Created attachment 14634 [details]
Comment 2 norbert2 2004-04-19 14:46:02 UTC
I mean B1 instead of A2 in the second step!
Comment 3 norbert2 2004-04-19 17:10:41 UTC
The char at the end that is shown as "space", seems so be a strange "linebreak".

If I copy it into an editor, it is interpreted as line-break by the editor.
But If I copy a number terminated with a line-break from the editor and paste it
into Calc as described, the problem does not happen.
Comment 4 flibby05 2004-04-19 18:46:00 UTC
set prio P1 -> P3
Comment 5 norbert2 2004-04-19 21:14:39 UTC
I have set the prio to "1", because there might be some people who use Calc for
serious Calculations.
In some cases having another value entered than the one that is displayed could
be fatal!
Comment 6 frank 2004-04-20 08:39:52 UTC
Hi Malte,

deleting the last character in the edit line changes the value in the cell by
deleting the last number of the scientific format, making 0.1 to 1. The problem
is, the last character in the eidt line isn't the same as in the cell.

Comment 7 frank 2004-04-20 08:40:32 UTC
set the target
Comment 8 norbert2 2004-04-20 09:06:30 UTC
Please note that this NOT only happens with scientific numbers.
Comment 9 malte_timmermann 2004-04-20 14:25:02 UTC
Comment 10 openoffice 2004-05-24 16:37:31 UTC
Comment 11 andreas.martens 2004-06-18 12:50:09 UTC
Because of a shortage of resources we have to retarget this issue to OOo later. 
Comment 12 Rainer Bielefeld 2014-04-23 06:28:04 UTC
Still Reproducible with "AOO 4.1.0 RC3 – English UI / German locale [AOO410m17(Build:9763)  -  Rev. 1586584 2014-04-11 08:56:50]" on German WIN7 Home Premium (64bit)", “historic” 4. User Profile used for all predecessor versions

Effect happens with any contents if a complete cell will be pasted into input line.

Status and Assignee: changed due to facts

It's really daunting that such meaningless Summaries can survive 10 years in a bug touched by experts.