https://bugs.freedesktop.org/show_bug.cgi?id=46117
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@lists.freedesktop.org
ReportedBy: domwo...@gmail.com
Normally it is possible to edit an equation by pointing and clicking on cells.
E.g.
(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.
However,
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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
