Bug 35801 - EDITING formula being in OVERWRITE mode
Summary: EDITING formula being in OVERWRITE mode
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.4 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-30 08:45 UTC by Maximiliano Curia
Modified: 2016-03-20 17:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Maximiliano Curia 2011-03-30 08:45:28 UTC
Hi,

The problem shows after you have edited a cell and left the editing mode in OVERWRITE.
If you try to edit any cell by clicking in the formula text input (and not by pressing F2), the changes you make are applied as if you were in INSERT mode, but, while you are editing the changes show as is you were in OVERWRITE mode.

If you try to edit the cell by pressing F2, the editing mode seems to be forced to INSERT.

The problem is also present in OOO Calc, (al least in versions 2.0, 2.4, and 3.2).
Comment 1 Björn Michaelsen 2011-12-23 11:45:49 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 2 Maximiliano Curia 2012-07-22 00:58:17 UTC
Hi,

The bug is still present in 3.5.4. It's quite simple to test:

- start localc.
- edit cell A1, while editing press insert (should change to overwrite mode) and end the cell edition pressing enter being in the overwrite mode.
- place yourself again in cell A1, move cursor left to overwrite the 4 with a 5.

While editing the entry line show 1235, and cell shows 12354.

The end result is that A1 ends up with a 12354 value.

The expected result is to end up with a 1235 value.
Comment 3 Hashem Masoud 2012-09-05 08:08:00 UTC
(In reply to comment #2)
This works for me in:
Version 3.6.0.4 (Build ID: 932b512) Slackware Linux 13.37
With a slightly different step:

> - start localc.
> - edit cell A1, while editing press insert (should change to overwrite mode)
> and end the cell edition pressing enter being in the overwrite mode.
> - place yourself again in cell A1, move cursor left to overwrite the 4 with a
> 5.

Here you have to place the cursor in the "Input line" text box. If you do this, overwrite mode (which is using the Insert button) works normally.

> 
> While editing the entry line show 1235, and cell shows 12354.
> 
> The end result is that A1 ends up with a 12354 value.
> 
> The expected result is to end up with a 1235 value.

Please confirm whether this works or not so we can close the bug.
Comment 4 Maximiliano Curia 2012-09-05 10:08:23 UTC
This bug is still present in libreoffice 3.6.1 (debian version 3.6.1-1, not sure which release it is).

I replied by mail to the followup of Hashem Massoud, I tested with the version 3.6.1-1 before replying. As I don't the mail I've sent publishe in the bug I'll copy my answer:

> Here you have to place the cursor in the "Input line" text box. If you do this,
> overwrite mode (which is using the Insert button) works normally.

Please, read the step by step "how to reproduce the bug".

The bug presents itself whenever you enter the input line to edit the
value while being in OVERWRITE mode. Of course, involving the overwrite
behavior you need to type a char that replaces another, without the
usage of backspace, delete or selection.

> Please confirm whether this works or not so we can close the bug.

The bug is still present, no solution was shown in the previous followup.
Comment 5 sophie 2014-12-31 11:17:52 UTC
Hi, I can not reproduce with Version: 4.5.0.0.alpha0+
Build ID: 57626f2132f73e4e42b31e364b25c5867336e718
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-12-26_09:28:24. 
The only thing remaining in the bug is the forced inserting mode by pressing F2, the overwrite mode is lost. Sophie
Comment 6 QA Administrators 2016-01-17 20:03:58 UTC
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.4 or later)  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System

Please DO NOT:

- Update the version field
- Reply via email (please reply directly on the bug tracker)
- Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)

If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2016-01-17
Comment 7 Maximiliano Curia 2016-03-20 17:59:58 UTC
Hi,

I've finally tested this issue against the newer version (5.1.1) of localc and the issue seems to be gone. The current behavior changes the editing mode back to insert whenever the user leaves the editing mode, which should be fine for most use cases.

Happy hacking.