Issue 77765 - edit cell contents in overtype actually inserts
Summary: edit cell contents in overtype actually inserts
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2007-05-24 17:32 UTC by sandreas41
Modified: 2017-05-20 11:13 UTC (History)
2 users (show)

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

demo movie showing unexpected result (697.27 KB, application/x-shockwave-flash)
2007-07-30 16:38 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description sandreas41 2007-05-24 17:32:05 UTC
Editing cell contents by clicking in the input line, and pressing [Insert] to
change to Overtype mode, actually inserts, and creates a descrepency between the
cell and the input line.

(This works with any existing spreadsheet), 
 but to reproduce:
New spreadsheet,
Type in cell A1 something like: "ABC DEF"
Desire to change contents, 
Click in input line, perhaps at the E
Change to Overtype Mode,
type "ef".
See changes in input line looks like: "ABC Def"
See changes in cell below looks like: "ABC DefEF"
Press [Enter]
Get second results. Not as expected.
Comment 1 pracslipkerm 2007-07-10 13:05:23 UTC
What version of are you using??
I just tried in OOo 2.2.1 (Win XP SP2) and I get the correct result 
(ie. "ABC Def").
Comment 2 sandreas41 2007-07-10 15:07:44 UTC
Just confirmed it is still in 2.2.1 rc2
Comment 3 Rainer Bielefeld 2007-07-30 16:36:15 UTC
I checked with "2.2.1  Multilingual German version WIN XP: [680m18(Build9161)]"
and can confirm the effect, after <ENTER> The result in A1 ie "ABC DeefF",
although input pane showed "ABC Deef", pls. see attached demo movie!
Comment 4 Rainer Bielefeld 2007-07-30 16:38:32 UTC
Created attachment 47204 [details]
demo movie showing unexpected result
Comment 5 Rainer Bielefeld 2007-07-30 16:41:39 UTC
Related to Issue 62232?
Comment 6 frank 2007-07-31 13:06:19 UTC
Hi Niklas,

typed ABC DEF into a cell, pressed Enter, selected Cell by doubleclick and set
the input cursor in front of the E in the edit line. Changed to overwright mode
and typed ef. Input line is correct but cell is not.

Comment 7 sandreas41 2009-06-14 22:14:14 UTC
This bug is still present in release 3.1

It happens when clicking in the edit/formula bar between the Formatting toolbar
and the row/column grid. To the right of the math button and = (function button)

Pressing Ins to toggle to Overtype does not change the results, whether I am
already in overtype, or press Ins once or twice.

Click in edit bar, type over a character, press [Enter]. Check result. :( 

This bug does not occur when pressing [Enter] to edit with the cursor below, 
within the grid area.
Comment 8 Marcus 2017-05-20 11:13:35 UTC
Reset assigne to the default "".