Issue 62232

Summary: Input Line must not remember Overwrite Mode
Product: Calc Reporter: prlj13 <prlj13>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: issues, lars_o_hansen, rainerbielefeld_ooo_qa
Version: OOo 2.0Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
See Also:
Issue Type: DEFECT Latest Confirmation in: 4.0.1
Developer Difficulty: ---

Description prlj13 2006-02-18 00:05:03 UTC
In Calc, when overwrite (opposed to insert) is selected while editting cells,
the cell and the formula box do not jive after the first time.

For example, if a cell contains "AAAA", and I want to overwrite part of the
contents of the cell, I'll select the cell to start editing (by clicking on the
formula box).  Then I'll press insert on the keyboard (to switch from insert to
overwrite).  The formula box and cell jive.  However, after I'm done editting to
cell (leaving overwrite as is), and I select another cell for editting, I'm
still in overwrite mode.  Now when I start editting the 2nd cell, the formula
box modifies the cell as if I'm in overwrite mode, but the cell in the
spreadsheet modifies the cell as if I'm in insert mode (they don't jive).  When
I'm done editting the cell, the data from the cell (not the formula box) is kept.

It is debatable which data should be kept.  I think Excell 'forgets' overwrite
mode after completing editting a cell.  I'd prefer it if Calc doesn't forget
overwrite mode.

Comment 1 lars 2006-02-18 15:39:33 UTC
confirmed with OOo 2.0.2 RC1 on WinXP Pro SP2; enter AAAAA in A1, enter BBBBB in 
B1, put the focus on A1, click in the Input line, press Insrt on your keyboard, 
type something: you overwrite the cell content in both the input line and the 
cell. Now put the focus on B1 and click in the input line. Type something: the 
input line is in overwrite mode, the cell is in insert mode.
Comment 2 frank 2006-03-08 13:43:57 UTC
Hi Niklas,

please have a look at this one.

Comment 3 niklas.nebel 2006-05-11 10:12:08 UTC
Changing target (last integration for 2.0.3 is over).
Comment 4 Martin Hollmichel 2007-11-09 16:51:47 UTC
change target from 2.x to 3.x according to
Comment 5 Rainer Bielefeld 2013-10-26 07:57:40 UTC
Reproducible with "AOO 4.0.1   – German UI / German locale  [Rev. 1524958 2013-09-20 11:40:29]" on  German WIN7 Home Premium (64bit)", “historic”  4.0  User Profile used for all  predecessor versions. 

Generally Calc seems to be in 'Insert Mode' for editing cells, after double click into a cell characters will be inserted without overwriting cells. When you changed to Overwrite mode for cell editing after termination of edit (<Enter>) mode will switch back to 'Insert Mode'

Steps how to reproduce Input Line Issue
1. From AOO start Center open new Spreadsheet
2. Into A1 Type 1234 <Enter>
3. Into A2 Type 5678 <Enter>
4. Click on A2 
5. Click into Input Line in front of "6"
   > Caret flashes before "6"
5. <Insert>
   Caret changes to Overwrite mode
7. Type "a" 
   > Cell contents now "5a78"
8. DoubleClick A1 in front of "2"
   > Caret flashes in cell in front of "2" in "Insert Mode"
   > A1 Contents appears in Input line
9. Click into Input line in front of "2"
   > Unexpectedly Overwrite Mode, what is different to situation in cell
10. Type "b"
    Bug: different results in 
         Input Line: "1b34"
         Cell:       "1b234"
11. <Enter> will decide for Cell contents, not for Input Line Contents

So there seems to be some inconsistent Input Mode remembering for Input Line, what leads to wrong unexpected inputs

Additional Info:
(a) that never worked correctly, already reproducible with OOo 1.1.5
(b) LibO 4.2 still affected
(c) Assignee back to default because of facts.
(d) Still reproducible with AOO 4.1.0-dev, but because of incomplete 
    LCo selector (Bug 123063) no correct information can be left