[Libreoffice-bugs] [Bug 46117] New: EDITING: changes to formulae by clicking in a cell not shown in formula bar

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Wed Feb 15 08:29:54 PST 2012


             Bug #: 46117
           Summary: EDITING: changes to formulae by clicking in a cell not
                    shown in formula bar
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.0 Release
          Platform: x86-64 (AMD64)
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: major
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: domwoolf at gmail.com

Normally it is possible to edit an equation  by pointing and clicking on cells.
(1) type =
(2) click in cell A1
(3) type +
(4) click in cell A2

... the formula =A1+A2 is shown in the formula bar and applied to the active cell once <enter> is hit or <tick> is pressed.


If while entering a formula the user clicks in the formula bar to move the cursor location (for example, to enter text in the middle of an existing equation)
this ceases to work.  Specifically clicking in a cell fails to update the text shown in the formula bar even though it does change the formula saved once
<enter> is hit. 

Minimal method to reproduce bug:

(1) active cell is A3
(2) type = 1 + + 2
(3) click between the two +'s in the formula bar to edit the mistake in this equation
(4) click in cell A1
**** no change is shown in formula bar ****
(5) hit <enter>
**** contents of cell A3 are now = 1 + A1 + 2 *****

If at step (4) user click multiple times in A1 because they do not see anything happening, the cell reference will be added multiple times to the formula.

Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

More information about the Libreoffice-bugs mailing list