Issue 28847

Summary: editing formulas with brackets causes unlimited bad undo actions
Product: Calc Reporter: norbert2 <norbert.notz>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
undo_formula.sxc none

Description norbert2 2004-05-07 07:51:56 UTC
Please ...

- open the attached spreadsheet

- double-click A1

- if the cursor is within the brackets: move it out of the brackets with the 
cursor keys
  if the cursor is outside the brackets: move it into the brackets with the 
cursor keys:

Now undo gets enabled and you can press it unlimited times and the cursor jumps 
between the first and the last bracket.


- double-click A2:

Here is no need to move the cursor. The problem happens directly after 
switching to edit-mode
Comment 1 norbert2 2004-05-07 07:52:17 UTC
Created attachment 15053 [details]
undo_formula.sxc
Comment 2 frank 2004-05-07 08:54:02 UTC
Hi Henning,

I think it's yours, if not please re-assign to the developer in charge.

Frank
Comment 3 norbert2 2004-05-07 13:54:07 UTC
Also a problem here is when entering formulas. After you have entered brackets, 
the other changements cannot be undone because the undo-function the hangs in 
the loop to jump between the brackets...
Comment 4 openoffice 2004-06-21 15:02:11 UTC
initial target set
Comment 5 obaraj 2006-01-20 15:57:12 UTC
Configuration:
Windows XP professional SP2

Build:
OpenOffice.org 2.0.1

This issue was replicated.

A) Reproduction step-by-step 

   1) open a new Spreadsheet
   2) type in "=()" into any cell
   3) select "edit" menu, select "undo" (alternately use ctrl-z)
      (notice that the undo operation loops the cursor from infront to behind
      the final ')')

B) Reproduction step-by-step (can't undo inputs)

   1) follow steps 1 - 3 above
   2) undo until cursor is inside the ()
   3) select any other cell (via mouse click or arrow keys on keyboard or 
      just type in some input from the keyboard)
   4) select "edit" menu, select "undo" (alternately use ctrl-z)
      (note that the cursor continues to loop in the same fashion as above.
       added cell reference cannot be undone)

C) other info

If the cell is not in edit mode you are able to perform undo actions as 
normal. Also you are able to undo new input that lies outside of the () even 
while the cell is in edit mode. 
Comment 6 openoffice 2006-01-24 09:28:19 UTC
HB->TL: This seems to be related to EditEngine