Apache OpenOffice (AOO) Bugzilla – Issue 62232
Input Line must not remember Overwrite Mode
Last modified: 2013-10-26 07:57:40 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. prlj13
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.
Hi Niklas, please have a look at this one. Frank
Changing target (last integration for 2.0.3 is over).
change target from 2.x to 3.x according to http://wiki.services.openoffice.org/wiki/Target_3x
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